We provided our services to a client who required us to develop a report which would help monitor the orders of raw materials from the warehouse.Read case study →
The company we provided our services to, had requested a model of standard analysis for the production of consumer goods (charcuterie, canned goods) and the chain of stores it owns. Charcuterie is a branch of cooking involving prepared meats, such as ham, sausage, bacon, confit, or other pork products. While the original French translation refers to pork, modern charcuterie boards can include other types of food, such as duck, goose, cheese, toast, fruit, or other options.
We provided reports for monthly sales and margin, as well as weekly and daily sales where we analysed the total sales per week and day. Furthermore, reports can be presented per hours and other types of details in order to help increase sales by building special promotions. It is always important to see how stock management impacts sales.
We monitored the evolution per each type of sale (stores, key accounts, agents etc.) and compared the results. We also analysed monthly sales and margin (%) per division (meat, fruits etc.) to compare the results and identify variances that needed further investigation. Top customers also represented a priority which is why we focused on analysing monthly sales and other operational indicators. Monthly sales where also presented for top products to observe seasonality. It was important to understand and analyse those products because they represented a significant part of total sales.
Locations and distances in km where also analysed for logistic purposes. Our company prepared an analysis based on square meters and products to understand and control the results. We also compared selling prices per kg and type of sale which played an important role in controlling the prices and having a commercial policy.
We used the available data in order to monitor the evolution of new employees and their bonuses, however the tables allow the implementation of others KPIs as well. For example KPI/store presented daily average sales which allowed a comparison between the results and the possible cost of new investments. We then provided reports that reconciled sales figures from cash registers with finance to see purchasing trends per store.
In order to expand the business and cover new regions it was vital to compare the available market with current sales. Our services highlighted the impact of stock management on sales and purchasing trends per stores. This helped the company make better, smarter business decisions based on clear results and explanations.
Read about the services we provided for different companies, the challenges we faced and the solutions we offered in order to meet the requirements.