5. Tesla Solar is one of the leading manufacturers of residential solar panels. Production at the Tesla Solar factory are scheduled by an ERP system using MRP logic. There are two models Tristar and Quadstar, both of which are assembled from the same base unit PolyCell, which is not used in the production of any other solar panels. The lead time to assemble a solar panel is one week, and PolyCell production also requires one week. The current gross requirements (example data only you will get unique data for you from excel file) for the two watch models in a future 8 week period are: WEEK 5 Bella 42 Harmony 85 6 13 10 7 77 112 8 51 38 9 32 25 11 8 12 46 12 18 39 38 74 The Tristar inventory at the end of week 4 is 15 units while that for Quadstar is 18 units. For Tristar there are scheduled receipts of 15 in week 5 and 20 in week 7. For Quadstar there are scheduled receipts of 12 in week 5 and 16 in week 6. Solve in the attached worksheet. istog lot si multiple (LSXFZ tabacco ponat. Joers to TZ a pang (ii) Derive the planned receipts for PolyCell using the part period balancing algorithm. The inventory at the end of week 3 is zero units and there are scheduled receipts of 42 in week 5 and 31 in week 6. The BOM of Tristar requires 3 PolyCells while Quadstar requires 4. The order cost is $1000 and the holding cost is $2.50 per housing/week. 5. Tesla Solar is one of the leading manufacturers of residential solar panels. Production at the Tesla Solar factory are scheduled by an ERP system using MRP logic. There are two models Tristar and Quadstar, both of which are assembled from the same base unit PolyCell, which is not used in the production of any other solar panels. The lead time to assemble a solar panel is one week, and PolyCell production also requires one week. The current gross requirements (example data only you will get unique data for you from excel file) for the two watch models in a future 8 week period are: WEEK 5 Bella 42 Harmony 85 6 13 10 7 77 112 8 51 38 9 32 25 11 8 12 46 12 18 39 38 74 The Tristar inventory at the end of week 4 is 15 units while that for Quadstar is 18 units. For Tristar there are scheduled receipts of 15 in week 5 and 20 in week 7. For Quadstar there are scheduled receipts of 12 in week 5 and 16 in week 6. Solve in the attached worksheet. istog lot si multiple (LSXFZ tabacco ponat. Joers to TZ a pang (ii) Derive the planned receipts for PolyCell using the part period balancing algorithm. The inventory at the end of week 3 is zero units and there are scheduled receipts of 42 in week 5 and 31 in week 6. The BOM of Tristar requires 3 PolyCells while Quadstar requires 4. The order cost is $1000 and the holding cost is $2.50 per housing/week