Improving Efficiency in Production Planning
High-end candle and fragrance business, Parks Candles, came to Xlteq with a problem involving their production planning and supply needs. Starting life as a single shop over 30 years ago, they expanded over the following decades until today where they are now producing over 32,000 candles a day to meet demand. Their current production process was paper based, and they required a simple solution to bring the process up-to-date. They also needed management reports to be data driven which would drive the production plan and help maintain stock levels.
Xlteq conducted an in-depth review of the customer needs, and offered various solutions using Excel and Access. Whilst the client expressed the ultimate desire for an Access database solution, they requested an intermediary phase to be built using an Excel workbook as this was a more familiar tool for their staff to use. Although producing this solution in Excel created several unique challenges and was further complicated by one employee using an Apple Mac, Xlteq was able to fully develop a production planning tool which met all the customer requirements, and ultimately provided enhanced functionality over and above the initial specification.