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

how to record dividends payablefreight journal entrydoubtful accounts journal entrybookkeeping for dummies cheat sheetpayroll test questions and answersthe effective interest amortization methodwhat is markup and marginissue of shares journal entriesexamples of transactional analysisbookkeeping documentscogs accountingrental bookkeepingwhat is factoring accounts receivableonline equation rearrangernpv perpetuity calculatormultiple step income statementwhat is consignee and consignordirect materials variancewhat is journal voucher in accountingaccounts receivable dsoexamples of asset accountscash disbursement journal examplespreadsheet accounts templatecalculation of accrued interest on fixed depositprepaid insurance adjusting entry examplesentry for accrued expensespv growing annuitydeferred tax asset accounting treatmentdiscuss the accounting cycleclosing entry for income summaryprepaid expenses in trial balanceentry for sale of fixed assetrental ledger templatecogs examplear accounting entriesaccounts aptitude questions and answershow to calculate ear on financial calculatormarkup percentage equationhow to calculate variable costs per unitpmt excel exampleannuities formula calculatordepreciation straight line method formulaprepaid insurance isgoodwill accounting journal entrybasic accounting bookkeepingacid test ratio formulahow to calculate overhead recovery ratethe difference between markup and marginsales taxes collected by a retailer are recorded bymeaning of consignment accountcapital expenditure balance sheetfv pmt calculatorreversing entries in accountingpv of annuity factorhow to calculate receivable turnoverformula for calculating payback periodflexible budget definition and exampleuncredited chequesmerchandise inventory current assetaccounts spreadsheet templatewhat are temporary accounts in accountingdaily timesheet template exceldebits increaselcm inventoryaccrued and prepaid expensesaccounting quizzformula for reducing balance depreciationspecific identification method of inventory costingfixed overhead capacity varianceproviding for doubtful accountsin a bank reconciliation a nsf check isdeferred tax asset examplejournal entry for bills receivablejournal entry for reserves and surpluswhen is the balance in a prepaid expense account reduceddu pont equationvariable cost per unit formulaweighted average accounting formulais finished goods a current asset