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.$)$

Part $3$Part $4$

$$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$

$400$

$450$

$350$

$400$

$150$

$250$

$500$

$350$

Customer orders$($booked$)$

$300$

$350$

$250$

$250$

$150$

$150$

$50$

$150$

$100$

$100$

Projected$$ on$-$hand inventory

$$

$350$

$$

$0$

$$

$100$

$$

$150$

$$

$300$

$$

$400$

$$

$250$

$$

$0$

$$

$0$

$$

$150$

MPS quantity

$500$

$$

$0$

$$

$500$

$$

$500$

$$

$500$

$$

$500$

$$

$0$

$$

$0$

$$

$500$

$$

$500$

MPS start

$$

$0$

$$

$500$

$$

$500$

$$

$500$

$$

$500$

$$

$0$

$$

$0$

$$

$500$

$$

$500$

$$

$0$

$$Available$-$to$-$

promise$($ATP$)$ 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