A MRP system is used by Ring Security Inc. to schedule production activities. The Ring Camera is sold in two models Dual-View and Tri-View.The VX-Sensor is used in both models. The Dual-View assembly uses 2 sensors while Tri-View uses 3 sensors. VX- Sensor is not used in the production of any other product. The lead time to assemble either model is one week, and that for the VX-Sensor is also one week. The current gross requirements for the two solar models in a future 8 week period are:

Week	5	6	7	8	9	10	11	12
Dual-View	101	124	214	87	79	127	147	87
Tri-View	50	55	28	28	43	58	67	39

The Dual-View inventory at the end of week 4 is 23 units while that for Tri-View is 9 units. For Dual-View there are scheduled receipts of 22 in week 5 and 13 in week 7. For Tri-View there are scheduled receipts of 9 in week 5 and 21 in week 6. Solve the following in the attached worksheet. (i)Production of Dual-View is to occur in lot size multiples (LSM) of 35 units, while that for Tri-View occurs in minimum lot sizes (LMIN) of 40 units. Derive the MRP tableau corresponding to weeks 5 to 12 for the cameras. (ii)Derive the plannedreceipts for VX-Sensorusing the partperiod balancing algorithm. Theinventory at theend of week3 is zero units andthere are scheduled receipts of 65 in week 5, 47 in week 6 and 81 in week 10. The order cost is $720 and the holding cost is $1.15 per sensor/week.

	MRP System - Ring Camera
	NAME: Dual View	Lead Time	1	End Inventory	23
			Lot Size - LSM	35
	WEEK	3	4	5	6	7	8	9	10	11	12
	Gross Requirements (G)			101	124	214	87	79	127	147	87
	Scheduled Receipts (S)			22	0	13	0	0	0	0	0
	Net Requirements (R)
	Planned Receipts (P)			1	1	1	1	1	1	1	1
	Planned Ending Inv. (V)
	Planned Order Releases (O)
	NAME: Tri View	Lead Time	1	End Inventory	9
			Lot Size - LMIN	40
	WEEK	3	4	5	6	7	8	9	10	11	12
	Gross Requirements (G)			50	55	28	28	43	58	67	39
	Scheduled Receipts (S)			9	21	0	0	0	0	0	0
	Net Requirements (R)
	Planned Receipts (P)			1	1	1	1	1	1	1	1
	Planned Ending Inv. (V)
	Planned Order Releases (O)
	PRODUCT	BOM-Qty
	NAME: Dual View	2
	NAME: Tri View	3
	PART PERIOD BALANCING ALGORITHM
	NAME: VX-Sensor	Order Cost =	$720	Holding Cost. =	$1.15
	WEEK	3	4	5	6	7	8	9	10	11	12
	Gross Requirements (G)
	Scheduled Receipts (S)			65	47				81
	Net Requirements (R)
	Planned Receipts (P)
Order Cycle-1	Holding Cost											Worksheet area - Complete as needed
Total Cost
Order Cycle-2	Holding Cost
Total Cost
Order Cycle-3	Holding Cost
Total Cost