1. Complete the history portion of the Elm Co. SOP 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 Future October November December January Sales Plan (in units) 800 850 900 900 Actual (in units) 826 851 949 Diff. month Diff. cumulative Operations Plan (in units) 800 800 800 (in employees) 6 8 8 Number working days/mo. 23 19 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