1. Complete the history portion of the Elm Co. sales and operations planning spreadsheet given below.

Inventory is valued at $700 per unit. The actual inventory at the end of September was 150 units.

Transcribed Image Text:

Elm Co. Sales and Operations Planning Spreadsheet History October November December Sales Forecast (in million $) 0.80 0.85 0.90 (in units) 800 850 900 Actual (in units) 826 851 949 Diff. month Diff. cumulative Operations Plan (in units) 800 800 800 (in employees) 6 8 Number working days/mo. 23 19 19 Actual (in units) 798 802 800 Diff. month Diff. cumulative Inventory Plan (in units) (in 1,000 $) Actual (in units) 122 73 -76 Days of supply