Calculating average daily usage shows the number of sales of a specific product your company makes on an average day. To calculate the quantity, choose a period of measurement.
Note, if your company is often affected by seasonality (for example, fashion retail), then calculate the average daily usage of an item for each season and then run the formula during each season.
If a company needs to be highly accurate, it’s possible to use the formula to learn the number of sales per month and then per year based on the results.
To make it easier to understand the formula, check the following examples:
MarketExample is an online store that sells products. The store needs to find out the average daily usage of their highly popular ice tea sold in bottles. The period of measurement is one month.
The average daily usage = 300 / 31.
The MarketExample store sells an average of 9.7 of these bottles.
The next step is to find out how much time it takes for an item to arrive upon its reorder. It’s an easy step. Add all periods affecting the time from a reorder to arrival. The calculation should include such periods as approvals (if any), processing of order forms, delivery, etc. Overall, everything affects the time of item’s arrival to the inventory.
Then calculate reorder delay. It’s a critical step, but retailers often omit it. If vendors or suppliers work only during certain days (i.e., only during business days), then include this delay in the equation.
Now let’s take a look at formula examples.
MarketExample orders bottles of ice tea from a local vendor. It takes a day to approve the order, one day for the order date to arrive at the warehouse, and one day to receive, process, and place a new order upon its delivery. In this case, the supply delay is:
1 + 1 + 1 = 3 (days)
But there is one critical condition — local vendor accepts orders only on Mondays. Meaning the reorder delay is around six days.
This condition changes the situation and complicates the task, so the store has to be prepared. The store can’t be sure that the stock will be sold at the same rate at all times.
According to the supply delay, lead time calculation is as follows:
3 + 6 = 9 (days)
MarketExample has to consider 9 days of average lead time.
Using safety stock protects the business from unexpected situations. Many different factors can affect the supply, for example, seasonal demand, bigger delays when delivering the item, etc.
Having safety stock helps with these difficult to predict factors. But to have safety stock, you need to calculate how many items the store needs.
The safety stock equation is as follows:
(max daily usage) * (max lead time) – (avg daily usage) * (avg lead time) = safety stock.
You have average lead time and average daily usage, and now it’s time to calculate maximum daily usage and maximum lead time. Maximum daily usage is the maximum a daily usage could go, for example, 20. Maximum lead time is the longest delay during a given period, for example, 13.
(20 x 13) – (9.7 x 9) = 172.7
Now you have everything to calculate ROP:
(9.7 x 9) + 172.7 = 260
When the stock drops to 260, the manager should take care of a reorder.
A reorder point system helps with a smooth inventory flow. ROP prevents items from running out, customer and income loss. Moreover, a business avoids unnecessary expenditure caused by overbuying to prevent shortages. Consider calculating ROP if you want your business to strive.
This article is not intended to provide tax, legal, or investment advice, and BooksTime does not provide any services in these areas. This material has been prepared for informational purposes only, and should not be relied upon for tax, legal, or investment purposes. These topics are complex and constantly changing. The information presented here may be incomplete or out of date. Be sure to consult a relevant professional. BooksTime is not responsible for your compliance or noncompliance with any laws or regulations.
A bookkeeping expert will contact you during business hours to discuss your needs.