Excel Solution with Formula

Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 Ultima Steppers, which are to be shipped in week 10. Subscripts indicate quantity required for each parent. Assume lot-for-lot ordering.

Item	Lead Time	On-Hand Inventory	Components
Stepper	2	10	A(2), B(2), C(1)
A	1	10	D(1), F(2)
B	2	20	E(1), F(3)
C	3	10	D(2), E(3)
D	2	15
E	2	5
F	2	20

c) Develop a net material requirements plan for F (enter your responses as whole numbers).

		Week		Lead Time
Item		3	4	5	6	7	8	9	10	(weeks)
F	Gross req				enter your response here	enter your response here				2
	On hand				enter your response here	enter your response here
	Net req				enter your response here	enter your response here
	Order receipt				enter your response here	enter your response here
	Order release		enter your response here	enter your response here