Please help with Part B.

Other Info Makes 1 batch (12 cupcakes) Ingredients Cupcakes . 50 units flour 2 large eggs 100 units sugar 200 units butter 5 units Vanilla Basic Process: Time (minute) Instruction 12 Prepare the batter for the cupcakes Custard Filling 150 units cream 1 unit Vanilla . 50 units sugar 2 units flour 4 large egg yolks 8 Make the custard filing 25 Chill the custard filing 55 Bake the cupcakes and let cool. Icing 150 units cream 2 units Vanilla 4 units sugar 20 Add the filing to the cooked cupcake 10 Prepare and add the icing Jelly 1 pkg flavored jelly crystals 250 ml boiling water 1 pkg gelatin powder 5 Prepare and add the jelly MRP Even though our business is not up and running yet, a friend has asked me to make 3 batches of "Crazy Good Custard Filled Cupcakes for her party. Each batch makes 12 cupcakes. We are going to create a schedule to guide us through the process to ensure we can deliver. a) Develop a product structure (BOM) for a batch of "Crazy Good Custard Filled Cupcakes. The recipe is below. Item Lead Time (Day) Safety Stock Proj. On Hand Schedule Receipts Lot Size Final Product 2 0 0 0 L4L 1 0 0 0 L4L Cupcake Custard Filing 1 0 0 0 L4L Icing 1 0 0 0 L4L Jelly 1 0 0 0 L4L Flour 2 150 100 50 On day 3 100 Vanilla 4 0 3 0 LFL Sugar 1 50 50 100 On day 4 100 Eggs 3 0 2 0 FOQ 12 Butter 2 100 50 100 On day 3 FOQ 200 Cream 1 200 250 100 On day 4 FOQ 250 Crystal 3 0 1 0 L4L Gelatin Powder 2 0 1 0 L4L b) Create and complete an MRP planning schedule for only the items listed below (based on the BOM) using the following assumptions: o We do not have any batches available. o Our demand is to be ready on day 8. o We do not have anything in inventory except for what is noted below You should use below table for calculation of each item of MRP. You can copy and paste it if needed 1 2 3 4 5 6 7 8 9 10 Quantity Lot Size Item: Cupcake Gross Requirements Scheduled Receipts Projected On Hand 0 Net Requirements Planned Order Receipts Planned Order Releases Safty Stock Lead Time Project on Hand Other Info Makes 1 batch (12 cupcakes) Ingredients Cupcakes . 50 units flour 2 large eggs 100 units sugar 200 units butter 5 units Vanilla Basic Process: Time (minute) Instruction 12 Prepare the batter for the cupcakes Custard Filling 150 units cream 1 unit Vanilla . 50 units sugar 2 units flour 4 large egg yolks 8 Make the custard filing 25 Chill the custard filing 55 Bake the cupcakes and let cool. Icing 150 units cream 2 units Vanilla 4 units sugar 20 Add the filing to the cooked cupcake 10 Prepare and add the icing Jelly 1 pkg flavored jelly crystals 250 ml boiling water 1 pkg gelatin powder 5 Prepare and add the jelly MRP Even though our business is not up and running yet, a friend has asked me to make 3 batches of "Crazy Good Custard Filled Cupcakes for her party. Each batch makes 12 cupcakes. We are going to create a schedule to guide us through the process to ensure we can deliver. a) Develop a product structure (BOM) for a batch of "Crazy Good Custard Filled Cupcakes. The recipe is below. Item Lead Time (Day) Safety Stock Proj. On Hand Schedule Receipts Lot Size Final Product 2 0 0 0 L4L 1 0 0 0 L4L Cupcake Custard Filing 1 0 0 0 L4L Icing 1 0 0 0 L4L Jelly 1 0 0 0 L4L Flour 2 150 100 50 On day 3 100 Vanilla 4 0 3 0 LFL Sugar 1 50 50 100 On day 4 100 Eggs 3 0 2 0 FOQ 12 Butter 2 100 50 100 On day 3 FOQ 200 Cream 1 200 250 100 On day 4 FOQ 250 Crystal 3 0 1 0 L4L Gelatin Powder 2 0 1 0 L4L b) Create and complete an MRP planning schedule for only the items listed below (based on the BOM) using the following assumptions: o We do not have any batches available. o Our demand is to be ready on day 8. o We do not have anything in inventory except for what is noted below You should use below table for calculation of each item of MRP. You can copy and paste it if needed 1 2 3 4 5 6 7 8 9 10 Quantity Lot Size Item: Cupcake Gross Requirements Scheduled Receipts Projected On Hand 0 Net Requirements Planned Order Receipts Planned Order Releases Safty Stock Lead Time Project on Hand