question B please , using the excel template provided

MRP Calculations 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. We are going to create a schedule to guide us through the process to ensure we can deliver. Develop a product structure (BOM) for a batch of "Crazy Good Custard Filled Cupcakes". The recipe is below. Lead Time Safety Proj. Co Schedule Recipe LS that 2 0 LAL LAL 1 Care Casting Icing Jelly Flour Vanilla Sugar Steck Hand o 0 0 0 0 O 0 0 O 0 150 100 0 3 50 SO 1 4 1 LAL 0 14L So Osday 3 100 URL 100 Onday 4 100 FOQ 13 100 day 30 200 100 day 400 250 0 L4L L4L Butter Crown Crval Kilatin Powder 1 3 2 100 200 . 0 50 250 1 1 b) Create and complete an MRP planning schedule for only the items listed below (based on the BOM) using the following assumptions: . We do not have any batches available. Our demand is to be ready on day 8. We do not have anything in inventory except for what is noted below Recipe: Ingredients Cupcakes units for Other Info Makes 1 batch Baske Process Time (minute Instructie 12 Prepare the battle for the cupcakes Make the custard . 200 nits but . 5 utits Vanilla Custard Filling 150 units cream . I wil Villa sumes * a unitstar large yolls cing 150 scream 2 in Vanilla 25 Chill the custard filling SS Bake the cupcakes and let cool 20 Add the filing to the cooked cake 10 Prepare and add the king Jelly 1 pkgaveldly crystals 250 nebling Ipaglipade Prepare and add the jelly E G You should use below table for calculation of each item of MRP. You can copy and paste it if needed M N Item: 1 2 3 4 5 6 7 8 9 10 Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipts Planned Order Releases 0 2 10 11 12 14 15 16 12 18 19 20 21 23 24 20 27 Ready SPC SPC Oraphs A 100 Bit of Mato Quantity Lot Size Safty Stock Lead Time Project on Hand MRP Calculations 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. We are going to create a schedule to guide us through the process to ensure we can deliver. Develop a product structure (BOM) for a batch of "Crazy Good Custard Filled Cupcakes". The recipe is below. Lead Time Safety Proj. Co Schedule Recipe LS that 2 0 LAL LAL 1 Care Casting Icing Jelly Flour Vanilla Sugar Steck Hand o 0 0 0 0 O 0 0 O 0 150 100 0 3 50 SO 1 4 1 LAL 0 14L So Osday 3 100 URL 100 Onday 4 100 FOQ 13 100 day 30 200 100 day 400 250 0 L4L L4L Butter Crown Crval Kilatin Powder 1 3 2 100 200 . 0 50 250 1 1 b) Create and complete an MRP planning schedule for only the items listed below (based on the BOM) using the following assumptions: . We do not have any batches available. Our demand is to be ready on day 8. We do not have anything in inventory except for what is noted below Recipe: Ingredients Cupcakes units for Other Info Makes 1 batch Baske Process Time (minute Instructie 12 Prepare the battle for the cupcakes Make the custard . 200 nits but . 5 utits Vanilla Custard Filling 150 units cream . I wil Villa sumes * a unitstar large yolls cing 150 scream 2 in Vanilla 25 Chill the custard filling SS Bake the cupcakes and let cool 20 Add the filing to the cooked cake 10 Prepare and add the king Jelly 1 pkgaveldly crystals 250 nebling Ipaglipade Prepare and add the jelly E G You should use below table for calculation of each item of MRP. You can copy and paste it if needed M N Item: 1 2 3 4 5 6 7 8 9 10 Gross Requirements Scheduled Receipts Projected On Hand Net Requirements Planned Order Receipts Planned Order Releases 0 2 10 11 12 14 15 16 12 18 19 20 21 23 24 20 27 Ready SPC SPC Oraphs A 100 Bit of Mato Quantity Lot Size Safty Stock Lead Time Project on Hand