Question: Develop a spreadsheet that reproduces the calculations. As in the example, the spreadsheet should include the net predicted demand for trumpets. The columns should correspond to weeks and should be labeled 1 to 18. Below the net predicted demand for trumpets should be the calculations for the valve casing assembly, and below that the calculations for the valves. For each component, include rows for the following information:
(1) gross requirements,
(2) scheduled receipts,
(3) on-hand inventory,
(4) time-phased net requirements, and
(5) lot-for-lot planned order release.
Your spreadsheet should automatically update all calculations if the net predicted demand for trumpets changes.