Problem 2. (Resource Planning-ATP. Total 15 pts.)

The following Table provides the Master Production Schedule of a product for the next 8 weeks and the Customer Orders you have Committed so far.

Model A
	Begin Inventory	Weeks
		1	2	3	4	5	6	7	8
MPS	5	10	10	20	10	20	0	10	20
Committed Orders		10		15		30		15
Inventory
ATP:Cul
ATP:D	5

Answer the following questions

a) For the given Committed Orders, calculate the Inventoriesfor week 1 to week 8.

b) For the given Committed Orders,

i) calculate the Available-to-Promise-cumulative(ATP:Cul) and the Available-to-Promise-discrete (ATP:D) quantities for the eight weeks.

ii) Use the result of ATP:Cul and ATP:D obtained to explain the meaning of the 2nd non-zero number.

iii) Use the result of ATP:Cul, and/or ATP:D obtained to answer the following questions

o Can you commit an New Customer Order of 10 units to be delivered in week 4 without changing the current MPS? (the Yes answer means that you will be able to deliver this order and all previously committed orders on the promised time). Explain why?

o How about the New Customer Order is 20 units instead of 10 units to be delivered in week 4? Explain why?

c) Briefly explain why, for any given period, the ATP:Culnumber will always be smaller than or equal to the Inventory of the period?