Reorder Point Calculator

The reorder point is the level to which inventory is allowed to fall before a purchase order for further supplies is placed.

A business does not want to run out of inventory as this can lead to lost revenue, on the other hand holding too much inventory means cash is tied up in funding the inventory.

By calculating the reorder point, a business can ensure that the minimum inventory is held while maintaining a level to satisfy demand.

The reorder point formula is given by:

Reorder point = Normal daily demand x (Days safety stock inventory + Supplier lead time)

The normal daily demand is the average rate at which the inventory is used in units. The days safety stock inventory is the number of days of normal demand held as a buffer stock to allow for errors in the lead time and demand calculations.

reorder point calculator v 1.0
Reorder Point Calculator Preview

The lead time is the time in days it takes between the inventory being ordered from a supplier and it being delivered to the business.

For example, if the normal demand is 200 units per day and the supplier lead time is 10 days, and a days safety stock inventory of 5 days is needed, then the reorder point calculation gives 200 x (10 + 5) = 3,000 units. When the inventory reaches 3,000 units, the reorder point inventory has been reached and a purchase order should be drawn up to order more from the supplier.

Using the Reorder Point Calculator

The Excel reorder point calculator, available for download below, calculates the reorder point for up to three products by entering details relating to the average daily usage, the safety inventory required, and the supplier lead time, The calculator is used as follows:

  • The product name is entered. Enter a product name or reference for the product.
  • The average daily demand in units is entered. Enter the average daily demand for the product in units. The average daily demand can be calculated by taking actual usage over a period of time and dividing this by the number of days in the time period. For example, if the usage over one month was 3,000 units then the average daily usage would be 3,000 / 30 = 100 units per day.
  • The required days safety stock inventory is entered. This is the number of days inventory demand that is required to be held as a buffer stock to allows for errors in demand calculations, delays in delivery etc.
  • The supplier lead time is entered. This is the number of days the supplier takes to deliver a product from the date of placing the order to the date the inventory is delivered to the business. The reorder point calculator calculates the total number of days inventory needed.
  • The reorder point is calculated. The reorder point calculator calculates the safety stock inventory in units, the forecast unit demand during the lead time, and finally the reorder point in units. When the inventory reaches the reorder point the business should order inventory for that product.
Reorder Point Calculator Download

Notes and major health warnings
Users use this reorder point software at their own risk. We make no warranty or representation as to its accuracy and we are covered by the terms of our legal disclaimer, which you are deemed to have read. This is an example of a tool that you might use to show how to calculate reorder point. It is purely illustrative. This is not intended to reflect general standards or targets for any particular company or sector. If you do spot a mistake in the reorder point calculator, please let us know and we will try to fix it.
Reorder Point Calculator November 6th, 2016Team

You May Also Like

Related pages

accrual examplesaccurred definitionaccounts receivable turnover ratecalculate ending finished goods inventorycontribution margin income statement templatewhat is deferred revenue expenditurecalculate gp margincapital lease examplecalculate annuity present valuelease accounting entrieswhat is irr in accountingcontribution margin income statement formatworking capital turnover ratio formulaprepaid expense exampleintercompany receivables and payablesbookkeeping entriesbook in accountingpremium bonds interestaccounting ratio calculatorfuture value of lump sumamortisation in accountingexample of a multi step income statementwarranty expense on income statementperiodic quizthree column cashbookassets to equity ratio formulaamortization bond premiumdoubtful accounts journal entryadjusting entries example problemsunearned creditnotes payable current liabilitymeaning of accounting cycleadjusting entries accounting practice problemsmonthly balance sheet template excelsample timesheet template excelaccounting quizzes with answerspetty cash definition in accountingrecording petty cashwhat is closing entries in accountingjv accounting termpartnership profit sharing ratioapic common stockformula for fifopmt calculation formulabank overdraft liabilitiescash operating cycle definitionhow to calculate markup in accountingdepreciation double entrycalculating amortization expenseexcel formula future valueexamples of retained earningsabsorption costing definitionhow to calculate markup from cost and selling pricetimesheet spreadsheetdupont analysis chartasset normal balancesteps in accounting cycledtl definitiondepreciation declining balancedebtor turnovermerchandise inventory current assetjournal entry for wagesaccount payable journal entry examplewhat is the purpose of preparing a bank reconciliationthe first step in the accounting cycle isledger t accountstransactional analysis simple explanationstock dividends journal entryhow to prepare journal entries in accountingdeferred tax explainedpayment in perpetuityaccount receivable debit or creditpv of lease paymentspetty cash in balance sheetwriting off bad debt journal entrydouble entry for prepayment