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. VXSensor 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 (example data only you will get unique data for you from excel file) for the two solar models in a future 8 week period are:

WEEK 5 6 7 8 9 10 11 12

Dual-View 90 100 110 105 85 75 65 55

Tri-View 45 50 45 35 25 65 75 35

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 and 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 planned receipts for VX-Sensor using the part period balancing algorithm. The inventory at the end of week 3 is zero units and there 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.

The problem should be solved on the MRP Auto Ring Excel file.