An end item$$s demand forecasts for the next $3$ weeks are $32$ units, followed by

forecasts of $28$ units for weeks $4$ and $5,$ forecasts of $38$ units for weeks $6$ and $7,$ and forecasts of $34$ units

for weeks $8$ through $10.$ The current on$-$hand inventory is $67$ units. The order policy is to produce in lots of

$72.$ The booked customer orders for the item, starting with week $1,$ are $34,28,36,41,31,19,29,10,12,$

and $24$ units. The lead time is $2$ weeks.

a$)$ Develop an MPS for this end item.

b$)$ The marketing department has received six orders for this item in the following sequence:

Order $1$ is for $40$ units to be delivered in period $3$

Order $2$ is for $60$ units to be delivered in period $4$

Order $3$ is for $40$ units to be delivered in period $5$

Order $4$ is for $35$ units to be delivered in period $3$

Order $5$ is for $20$ units to be delivered in period $6$

Order $6$ is for $30$ units to be delivered in period $9$

Assuming that the prospective MPS you developed in part $($a$)$ does not change, which orders would

you be able to accept based on the available to promise $($ATP$)?$

If possible, please explain how to create the MPS in Excel. Thanks.