Shown below is a partially completed MPS record for ball bearings.

Part $2$

a$.$ Develop the MPS for ball bearings. $($Enter your responses as integers. A response of$"0"$ is equivalent to being not$$ applicable.$)$

$$Item: Ball bearings

Order$$ Policy: $500$ units

Lead$$ Time: $1$ week

Quantity

on$$ Hand: $400$

Week

$1$

$2$

$3$

$4$

$5$

$6$

$7$

$8$

$9$

$10$

Forecast

$550$

$350$

$450$

$450$

$350$

$350$

$200$

$250$

$400$

$350$

Customer orders$($booked$)$

$300$

$350$

$250$

$250$

$150$

$200$

$50$

$100$

$50$

$50$

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

$$

enter your response here

$$

enter your response here

MPS quantity

$500$

$$

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

$$

enter your response here