Shown below is a partially completed MPS record for$2"$ pneumatic control valves.

Part $2$

$$First$,$ develop an MPS for$2"$ pneumatic control valves. $($Enter your responses as integers. A response of$"0"$ is equivalent to being not$$ applicable.$)$

$$Item: $2"$ Pneumatic control valve

Order$$ Policy: $75$ units

Lead$$ Time: $1$ week

Quantity

on$$ Hand: $10$

Week

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

Forecast

$40$

$45$

$40$

$35$

$35$

$30$

$50$

$50$

Customer orders$($booked$)$

$60$

$45$

$30$

$30$

$5$

$10$

$10$

$0$

Projected$$ on$-$hand inventory

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

MPS quantity

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here

$$

enter your response here