Looking at the graph and table, it is clear: a sharp increase in sales occurred in March, when all the crackers were sold in 19 days. The leader is April: the goods were sold out in less than a week (6 days). During the month, the turnover of goods took place 6 times, bringing the most profit.
In January, rusks sold the worst; it would take 62 days for the outlet to sell all the goods. It is clear that the goods did not have time to turn over even once during the month, and therefore, they did not work off the invested funds. There is no need to order this item for the next period, since the January batch should be sold. But as a result of a mistake made by a store employee, a batch of rusks was ordered for February. As a result, warehouse stocks increased, liquid assets became less, and consumer activity remained at a low level.
The data from the table paytm database and graph show that the winter months are the most unfavorable in terms of sales. But from the beginning of spring until the end of the analyzed period, sales are constantly growing and the turnover does not fall below 30 days. Accordingly, when planning purchases for the next year, there is an understanding of what figure to focus on when selecting a 30-day lot size.
(41 + 36 + 15 + 23) / 4 = 29 packs.
This is the figure that should be used as a kind of standard for warehouse stocks when planning purchases, starting from February of the following year. That is, in the last winter month, it is necessary to purchase so many crackers that there are 29 packs in the warehouse. If there is a change in demand for any reason, then it will be necessary to simply adjust the order.
Read also!
"Lead generation - what is it? Basic methods and how to manage them"
Read more
Step 2: Compare monthly sales of the product with the average for the period
What is this for?
We now have the opportunity to compare monthly sales figures. But what value should be taken as the norm or standard? For example, in May, crackers were sold out in 19 days, and in February – in 28, so we conclude that the first month was better than the second. But in terms of sales, we have no idea how much was lost in February, and how much was gained in May.
Thus, it is necessary to have some specific benchmark – it is the average turnover rate. Based on it, you can draw conclusions about whether the month was successful in terms of sales or not.
What do we need for this? To determine the average number of packs of crackers lying in the warehouse for six months, we need to calculate:
average inventory for 6 months;
number of days in a half year;
how many packs were sold during the analyzed period.
How to calculate sales speed correctly? If you take the price from the shelf, the turnover indicator may be incorrect, and your conclusions may be erroneous. As a result, warehouse stocks may be either excessive or insufficient.
Let's calculate the average supply of crackers for six months:
Average inventory for the period = ((TI1 / 2) + TI2 + ... + (TIn / 2) / (n – 1),
Where:
TS – inventory on a specific date;
n – the number of dates in the selected period. If we analyze data for 6 months, then n = 6.
Average inventory for 6 months in rubles:
Month Stock on the last day of the month Data in the formula
January 874 874/2 = 437
February 874 874
March 76 76
April 228 228
May 210 210
June 646 646/2 = 323
Total items in stock 2 148
Number of months to calculate (n) 6 – 1 = 5
Average stock of goods for 6 months 429.6
Purchase price 18.2
Average stock of goods in packs 429 / 18.2 = 24
The table shows that the average stock of chips for six months is 24 pack