Problem $2$

Maple Co$.$ SOP Historical Data

Maple Company plans to maintain $5$ days of supply in inventory, but actual inventory is off target at the

end of the year.

$($a$)$ Complete the history portion of the Maple Co$.$ SOP spreadsheet below.

Show your work by retaining formulas in all cells. Fill in all shaded cells below.

Maple Co$.$ SOP Spreadsheet

$($b$)$ Given that the plan was to maintain $5$ days of supply in inventory, interpret the spreadsheet and explain the primary reason$($s$)$ why inventory is off target at the end of December.

$($c$)$ From an S&OP perspective, what specific action$($s$)$ would you consider to bring inventory levels back toward target in January?