Replace X with 32 and please show excel formulas!!

4.

a. Complete the following MPS time-phased record: (25 points)

Toaster

Week		1	2	3	4	5	6	7	8
Gross Requirements		35	20	2+X	25	3+X	25	4+X	25
Orders		8	9	6	4	2	1
Projected Available Balance	X
Available-to-promise
MPS

MPS Lot Size = X

The following events occurred during week 1:

- Actual demand during week 1 was only 28 units

- The forecast for week 9 is 6 + X

- An order for 4 in week 2 was accepted.

- An order for 3 in week 4 was accepted.

- An order for 2 in week 3 was accepted.

- The MPS in week 1 (if any) was produced at the 85% (round up to the nearest integer)

b. Update the record below after rolling through time.

Toaster

Week		2	3	4	5	6	7	8	9
Gross Requirements		20	5+X	25	5+X	25	5+X	25	6+X
Orders
Projected Available Balance
Available-to-promise
MPS

MPS Lot Size = X