EOQ EXCEL CALCULATION
Homework 3
EOQ Calculation on MS Excel Spreadsheet
Problem:
Tasks: Use Excel to Calculate EOQ and Respective Costs for each of the Five Electronic Products.
Fill out the highlighted areas on the posted Excel spreadsheet (Homework 3 EOQ Excel.xlsx) to determine decision values regarding EOQ decisions and pertinent costs related to 5 inventory items.
Report and discuss your results.
Note: 1) we are looking for the theoretical values; thus no need for rounding; 2) The formulas to calculate annual demands and EOQ have been illustrated in Worksheet 2, titled “Sample”. You only need to duplicate the formulas to the relevant cells in Worksheet 1.
SCLT 3384 Victor Cheng