Question

1. Electro Fans has just received an order for one thousand 20-inch fans due week 7. Each fan consists of a housing assembly, two grills, a fan assembly, and an electrical unit. The housing assembly consists of a frame, two supports, and a handle. The fan assembly consists of a hub and five blades. The electrical unit consists of a motor, a switch, and a knob. The following table gives lead times, on-hand inventory, and scheduled receipts. See the following data table:
   1. Construct a product structure.
   2. Construct a time-phased product structure.
   3. Prepare a net material requirements plan.

COMPONENT	LEAD	ON-HAND	LOT	SCHEDULED
COMPONENT	TIME	INVENTORY	SIZE	RECEIPT
Fan	1	100
Housing	1	100
Frame	2
Supports (2)	1	50	100
Handle	1	400	500
Grills (2)	2	200	500
Fan Assembly	3	150
Hub	1
Blades (5)	2		100
Electrical Unit	1
Motor	1
Switch	1	20	12
Knob	1		25	200 knobs in week 2

Answer 1

Below is the product structure -

Below is the time phased structure -

Below is the MRP schedule -

Fan Q = L4L LT = 1		On Hand	1	2	3	4	5	6	7
Gross Requirement		0	0	0	0	0	0	1000
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	100	100	100	100	100	100	100	0
Net Requirements		0	0	0	0	0	0	900
Planned Order Receipts		0	0	0	0	0	0	900
Planned Order Releases		0	0	0	0	0	900	0
Housing Assembly Q = L4L LT = 1	Gross Requirement		0	0	0	0	0	900	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	100	100	100	100	100	100	0	0
Net Requirements		0	0	0	0	0	800	0
Planned Order Receipts		0	0	0	0	0	800	0
Planned Order Releases		0	0	0	0	800	0	0
Grill Q = 500 LT = 2	Gross Requirement		0	0	0	0	0	1800	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	200	200	200	200	200	200	400	400
Net Requirements		0	0	0	0	0	1600	0
Planned Order Receipts		0	0	0	0	0	2000	0
Planned Order Releases		0	0	0	2000	0	0	0
Fan Assebly Q = L4L LT = 3	Gross Requirement		0	0	0	0	0	900	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	150	150	150	150	150	150	0	0
Net Requirements		0	0	0	0	0	750	0
Planned Order Receipts		0	0	0	0	0	750	0
Planned Order Releases		0	0	750	0	0	0	0
Electrical Unit Q = L4L LT = 1	Gross Requirement		0	0	0	0	0	900	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	0	0	0	0	0	0	0	0
Net Requirements		0	0	0	0	0	900	0
Planned Order Receipts		0	0	0	0	0	900	0
Planned Order Releases		0	0	0	0	900	0	0
Frame Q = L4L LT = 2	Gross Requirement		0	0	0	0	800	0	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	0	0	0	0	0	0	0	0
Net Requirements		0	0	0	0	800	0	0
Planned Order Receipts		0	0	0	0	800	0	0
Planned Order Releases		0	0	800	0	0	0	0
Suports Q = 100 LT = 1	Gross Requirement		0	0	0	0	1600	0	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	50	50	50	50	50	50	50	50
Net Requirements		0	0	0	0	1550	0	0
Planned Order Receipts		0	0	0	0	1600	0	0
Planned Order Releases		0	0	0	1600	0	0	0
Handle Q = 500 LT = 1	Gross Requirement		0	0	0	0	800	0	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	400	400	400	400	400	100	100	100
Net Requirements		0	0	0	0	400	0	0
Planned Order Receipts		0	0	0	0	500	0	0
Planned Order Releases		0	0	0	500	0	0	0
Hub Q = L4L LT = 1	Gross Requirement		0	0	750	0	0	0	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	0	0	0	0	0	0	0	0
Net Requirements		0	0	750	0	0	0	0
Planned Order Receipts		0	0	750	0	0	0	0
Planned Order Releases		0	750	0	0	0	0	0
Blades Q = 100 LT = 2	Gross Requirement		0	0	3750	0	0	0	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	0	0	0	50	50	50	50	50
Net Requirements		0	0	3750	0	0	0	0
Planned Order Receipts		0	0	3800	0	0	0	0
Planned Order Releases		3800	0	0	0	0	0	0
Motor Q = L4L LT = 1	Gross Requirement		0	0	0	0	900	0	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	0	0	0	0	0	0	0	0
Net Requirements		0	0	0	0	900	0	0
Planned Order Receipts		0	0	0	0	900	0	0
Planned Order Releases		0	0	0	900	0	0	0
Switch Q = 12 LT = 1	Gross Requirement		0	0	0	0	900	0	0
Scheduled Receipts		0	0	0	0	0	0	0
Projected on Hand	20	20	20	20	20	8	8	8
Net Requirements		0	0	0	0	880	0	0
Planned Order Receipts		0	0	0	0	888	0	0
Planned Order Releases		0	0	0	888	0	0	0
Knob Q = 25 LT = 1	Gross Requirement		0	0	0	0	900	0	0
Scheduled Receipts		0	200	0	0	0	0	0
Projected on Hand	0	0	200	200	200	0	0	0
Net Requirements		0	0	0	0	700	0	0
Planned Order Receipts		0	0	0	0	700	0	0
Planned Order Releases		0	0	0	700	0	0	0