Shown below is a partially completed MPS record for hand drills.

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

Item: Hand drills					Order Policy: 60 units
					Lead Time: 1 week
Quantity on Hand: 30	Week
	1	2	3	4	5	6
Forecast	15	40	10	25	45	25
Customer orders (booked)	20	30	5	15	0	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
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

MPS start

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

enter your response here

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

b. A distributor of the hand drills places an order for

30

units. What is the appropriate shipping date for the entire order?

The order should ship on week

enter your response here.

(Enter your response as an integer.)