Please make sure to add end item.

Week

10

11

12

13

14

15

16

17

Master Prodcuion Schedule

100

100

40

40

100

200

200

200

Component

Available Inventory

Spares

A

20

12 units in week 12

End Item	Gross Requirements
	On-Hand = 0
	Net Requirements
	Planned Order Receipt
	Planned Order Release

B

155

10 units in week 8

C

140

22 units in week 10

A LT=1 week

B LT=2 weeks

C LT=2 weeks

Complete the following problem. Please find the data table in the Excel spreadsheet Homework 5.xls. I strongly recommend completing the problem in Excel. Consider the product structure diagram in the figure below. Given the available inventory for each of the components and the master production schedule for the end item and spares described in Homework5.xls, perform the explosion calculus to determine the planned order releases for components A, B and C. Assume that lot-for-lot scheduling is used throughout, and there are no scheduled receipts. Hint: Note that is required for both A and B. End Item A(2) 1 week B(1) 2 weeks C(1) 2 weeks D(2) 1 week C(2) 2 weeks E(3) 2 weeks