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

trade payable daysaccounting balance sheet template excelhow to calculate conversion cost per equivalent unitpayback method advantagesjournal entry for bills payablegarnishee order wikijournal entry for prepaid rent receivedclosing stock trial balancehorizontal analysis for income statementcontra assets examplesjournal entry for prepaymentdiscount on notes payable journal entrytotal fixed cost formulastockholder equity statementreceivables turnover formulawhat is dishonour of billhow to calculate declining balance depreciationar turnover days formuladefine sundries expenseunearned service revenue still unearned journal entryaccounts receivable calculatordiminishing depreciation formulawhat is fifo method in accountingjournal entry for common stock issuedbank reconciliation statement journal entriesmargin vs markup tablean accrued expensevaluing zero coupon bondswhat is accounts receivable agingvaluation allowance journal entrycalculating a markupprepaid accounting entrycommon size income statementsalary received journal entryaccounting worksheet templatecost accounting journal entries examplesaccrude expensemargin and markup formulasdegree of operating leverage formulaloan balance calculator excelwhat is an accounts payable ledgerlifo examplerearrange formula calculatorpresent annuity tablehow to calculate depreciation using straight line methodcommon size balance sheet formulacapital lease lessor journal entriesunfavorable labor rate variancehow to calculate irr in excelthe asset turnover ratio is computed by dividingrental ledger sampleunearned revenue t accountledger card templateinterest expense journal entrypetty cash record sheetperpetual inventory system journal entrymarkup v margin calculatoraccumulated depreciation is what type of accountsimple interest vs compound interest formulaactivity based costingshow to record accrued revenuecost of ending inventory calculatorleverage ratio calculation formulafv of annuity formulagearing financereturn on capital employed definitionnpv depreciationincome summary closing entrypredetermined overhead allocation ratehow to compute cost of goods manufacturedpresent value of a single sum calculator