How to Calculate an Inventory Reserve

by Chuck Brown; Updated September 26, 2017
...

Inventory reserve is that portion of a company’s earnings set aside, or escrowed, to pay for and maintain company inventory. Since this figure is partly speculative in nature, hypothetical forecasting is part of arriving at a reasonable figure. Generally accepted accounting principles do give some general guidelines to help you arrive at a reasonable inventory reserve figure. Using sales figures for inventory moved in the recent past (last four to six quarters) will provide a basis for calculating the inventory reserve.

Step 1

Take inventory if you have not done so lately or do not have a regularly scheduled inventory as part of your management policy. Compare your counts to your three or four most recent inventory sheets. It is a good idea to go back farther if you have the information. Make note of any glaring inconsistencies and determine the reason for them.

Step 2

Calculate your inventory costs. Maintaining inventory costs the company in more ways than one. You pay someone to manage it. You pay other inventory-related costs, such as shrinkage, spoilage and loss. You also pay the cost to store your inventory. Use your current inventory count and as many of your most recent counts as you have to calculate cost percentages for your inventory upkeep. You may find that these costs offset or more than offset the inventory reserve money you have set aside. This is not unusual.

Step 3

Use either the item cost to the company at the time of purchase or the current market value to set the actual costs for every inventoried item. Generally accepted accounting practices require you to use the lesser of the two. For instance, if you paid $20 to make a starter, but due to the recent increase in vehicle recalls from that particular vehicle maker, the starter now has a market value of $15, your accounting entry must reflect this change in value. Record the value loss as a debit of $5 and credit your inventory $5.

Step 4

Set your costs for inventory at replacement value when there is a difference between replacement value and market value. Most inventory value is difficult to precisely assess as there are just too many variables in play. Replacement value is more readily determined. Be sure to keep these values reasonable and in line with current, acceptable values.

Step 5

Classify your inventory according to units moved. Determine what is most active in your inventory and label those products Level 1. Group the next most frequently sold products into a separate classification, labeling these Level 2. Continue the same method until you have accounted for every piece of inventory and its activity level. Skew your reserves to the most active. Set up the rarely-if-ever moved items in the category "Available as Ordered" or "Available Upon Request." Require a deposit for these categories before ordering.

Tips

  • Use your inventory reserve calculations to remove old, never sold items from your order sheets.

About the Author

Chuck Brown is a freelance writer and former teacher and athletic coach. He has held professional stints as a business owner, personal fitness trainer, curriculum designer, website designer, market trader and real estate investor. Brown holds a bachelor's degree in English and a master's degree in Christian counseling.

Photo Credits

  • medical inventory image by Pix by Marti from Fotolia.com