Quantity Discount Evaluator

This Quantity Discount Evaluator is based on a common financial decision model that helps people decide whether to accept a discount offered due to ordering larger quantities. Enter the data under Input and then click Calculate. The results are then displayed. Use this decision support tool to test different sets of assumptions and to see results change.

 
Input
   Results
   Alternative 1 Alternative 2
Annual Quantity
Used		 $   EOQ $ $
Cost per Order $ Order Quantity $ $
Holding Cost
per year per unit		 $ Number of Orders $ $
  Alternative 1 Alternative 2 Average Inventory $ $
Unit Price $ $ Ordering Costs $ $
Minimum Order
Quantity		 $ $ Storage Costs $ $
Purchasing Costs $ $
 Total Costs $ $

Average Inventory - This value is the average amount of inventory in storage. It assumes that usage is a constant rate and that new inventory comes when the old inventory is totally used.

EOQ - EOQ (Economic Order Quantity) is the ideal number of units to buy at one purchase. This minimizes the sum of the costs to purchase the goods. It also depends on the annual usage.

Holding Cost - Holding Cost is the cost to hold one unit for one year in inventory.

See the JavaScript for this decision aid.

copyright (c) 2000-2001 by D. J. Power

DSS Home |  About Us |  Contact Us |  Site Index |  Subscribe | What's New
Please Tell Your Friends about DSSResources.COM Copyright © 1995-2008 by D. J. Power (see his home page).
DSSResources.COMsm is maintained by Alexander P. Power and Daniel J. Power. Please contact them at webmaster@dssresources.com with questions. See disclaimer and privacy statement.