To create a computer (their final product, named product A), company BashimoX needs to combine many different parts to create A. D = 2 units of B + 2 units of C B = 1 unit of E + 2 units of F C = 1 unit of F E = 3 units of F A = 3 units of B + 2 units of D + 2 units of E Inventory on hand: A = 0 B = 30 C = 40 D = 10 E = 25 F = 0 Production lead time: A, E and F = 1 week C and D = 2 weeks B = 3 weeks Lot-for-lot production = item C Lot sizes: - A = multiple of 25 - B = multiple of 25 - D = multiple of 50 - E = multiple of 50 - F = multiple of 125 There is an order of 20 units of product A to be delivered in week 15 1) In excel, make the full MRP schedule for the order including all the items. Will the company be able to make the order? 2) In excel, make the full MRP schedule for the order but without any on hand inventory and scheduled receipt for all items. Will the company be able to make the order? 3) In excel, make the MRP schedule for item F when the company can only use one machine and make 125 units of itemF each week. Can the company make the order? Show the changed MRP schedule for item F and any other items impacted by the change.