Question 3 - Material Requirement Plan for iPhone Model F(5 marks) Apple, the world-leading mobile device manufacturer, is preparing the materials for the production of the latest model F, which the final product F is assembled by the subassemblies and components as shown in the product structure tree below. If you are given the following information regarding the forecast demand of Product F. on-hand inventory, scheduled receipt, order lead time and minimum order quantity. Prepare the material requirement planning reports for all the components. (4 marks) Model F Sub A (1) SubB (3) Compc Comp CompD Comp E (2) (1) (2) (3) "number in brackets show the quartity required for thatitem to make one unit ofits parent. Week 1 2 3 4 5 6 7 8 9 10 Forecast Demand 20 15 35 5 15 10 35 5 0 20 Beginning Lead Time On-Hand Scheduled Receipt Minimum Order item (Weeks) Inventory (Week, Quantity) Quantity Model F 1 40 (1, 15), (2, 10) 20 Sub 1 20 (1, 10) 20 Sub B 2 60 (2.45) 60 Comp C 2 0 (2,10) 10 Comp D 1 120 (1, 10) 120 Comp E 2 180 (2.30) 180 *Remark: Minimum order quantity means the order size of that item at each period must be equal or larger than the minimum order quantity. If Applewants to combine some orders of the final product (Model F) assembly, given the order setup cost is $1000/order and inventory holding cost is $15/unit/week. Apply the least- total-cost method to determine the lot size of each order for the final product. You don't need to rework your MRP records for all sub-assemblies and components. Just show the steps on how you determine each order size for the final product F. (1 mark)