please show steps

The following table lists the components needed to assemble an end item, lead times, and quantities on hand. Item LT (week) Amount on hand End 1 0 B 3 7 1 12 D 1 22 00 - M F 1 29 G 1 5 1 9 Click here for the Excel Data File End Item B (2) c D (3) E (2) F (3) G (2) E (2) H (4) E (2) a. If 21 units of the end item are to be assembled, how many additional units of E are needed? (Hint: You don't need to develop an MRP plan to determine this.) Additional units b. An order for the end item is scheduled to be shipped at the start of week 15. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don't need to develop an MRP plan for this part either.) The latest week Bunny Helpers, Inc., has just received an order for 100 Deluxe Easter Baskets, which must be ready for delivery at the start of week 6. An MRP planner has prepared the following table showing product structure, lead times (orders are lot-for-lot), and quantities on hand Deluxe Easter Basket BOM Lead Time On- Hand 10 Deluxe Easter Basket Dark Chocolate Truffles (2 per) Carved Chocolate Eggs (4 per) 1 week 2 weeks 30 1 week 50 Each Deluxe Basket contains two dark chocolate truffles and four carved chocolate eggs. If the firm is using a fixed-period lot size of two periods, what is the order size for the first order