Inventory is valued at $$700$ per unit.

Elm Co$.$ Sales and Operations Planning Spreadsheet

History

Sep October November December

Sales

Forecast

Actual

$($in million $$)$

Diff. month

Diff. cumulative

$($in units$)$

$($in units$)$

Operations

Plan

Number working days$/$mo$.$

Actual

$($in units$)$

$\backslash$table$[[0\mathrm{.}80,0\mathrm{.}85,0\mathrm{.}90],[800,850,900],[826,851,949],[26,1,49],[,27,76]]$

Diff. month

Diff. cumulative

Inventory

Plan

$($in units$)$

$($in $1,000$$ $)$

Actual

Days of supply

$($in units$)$

$122$

$73$

$-76$