Prepare a master schedule given this information: The forecast for each week of an eight$-$week schedule is $50$ units. The MPS rule is

to schedule production if the projected on$-$hand inventory would be negative without it$.$ Customer orders $($committed$)$ are follows:

Click here for the Excel Data File

Use a production lot size of $75$ units and no beginning inventory.

Note: Leave no cells blank $-$ be certain to enter $"$O$"$ wherever required.Prepare a master schedule given this information: The forecast for each week of an eight$-$week schedule is $50$ units. The MPS rule is to schedule production if the projected on$-$hand inventory would be negative without it$.$ Customer orders $($committed$)$ are follows:

Week Customer Order

$152$

$235$

$320$

$412$

Click here for the Excel Data File

Use a production lot size of $75$ units and no beginning inventory.

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required.