products planning class

13. The following product structure tree indicates the components needed to assemble a one unit of product W. Suppose that the forecasted demands for the product W for weeks 3 to 8 are 30, 50,0,60,25, 25. The starting inventory of product Win week 3 is zero and the production manager anticipates returns of 10 end products in week 6. The cost of producing subcomponent Bis $60, the holding cost is $0.50/unit/period, and the setup cost is $100 (Do not use Microsoft Excel) (35 Points) w 8 (2) C141 D (2) E (2) F D131 G (2) (a) Construct the MRP table for product W if the lead time is one week. (6) Construct the MRP table for subcomponent B if the lead time is one week. Use lot sizing with Lot to Lot to calculate setup, holding, and total costs for subcomponent B. (d) Use lot sizing with EOQ to calculate setup, holding, and total costs for subcomponent B. () Use lot sizing with Silver-Meal to calculate setup, holding, and total costs for subcomponent B. Use lot sizing with Least Unit Cost to calculate setup, holding, and total costs for subcomponent B. Use lot sizing with Part Period Balancing Technique (PPB) to calculate setup, holding, and total costs for subcomponent B