| Excel Spreadsheet Template for Economic order quantity (EOQ) with production lot sizes.The basic EOQ model finds that particular quantity to order which minimizes the total variable costs of inventory. If the EOQ is produced in-house rather than purchased from vendors, use the OM-EOQPROD model.
 Alvin Air Systems in Alvin , Texas , produces repair and maintenance items for commercial air conditioning systems. Alvin cannot use the standard EOQ for determining production lot sizes. One problem is that the standard EOQ assumes that an order quantity or lot of material is received all at once. At Alvin , most production lots take some time to complete and parts are placed in stock on a daily basis until the run is over. A related problem is that substantial sales usually occur before the run is over. To solve these problems, Alvin uses the modified EOQ model for production lot sizes. Why? The EOQ must be larger than maximum investment to account for sales made during the production run.
Vendors sometimes offer several different price/quantity plans, so EOQDISC is set up to evaluate four discount plans at once.
|
