please help me complete each section

Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? L24 A B C D E F G H Scenario 30 points We are beginning our second year. Instead of waiting for people to find your bakery, you hired a sales manager to optimize your product exposure. You now supply cupcakes to boutique hotels, bridal shops, and luxury shops. Based on popularity, you only produce chocolate cupcakes with chocolate icing. Your sales manager is pushing for the company to create and maintain budgets. Create a Sales, Production Materials, and Labor budget in preparation for the new year. Sales Budget The Sales Manager believes we can sell 36,000 dozen cupcakes during the first quarter (Jan-Mar) and that there will be a quarterly increase (see Sales Increase). In order to increase sales quarterly, we will need to reduce our customer price (see Customer Price). Create a Sales Budget for each quarter. Sales Increase 3.50% Customer Price$ 15.00 Quarters 01 Q2 Q4 Total Budgeted Sales Selling price per dozen Total Sales revenue Q3 Production Budget Based on the Sales Budget create a Production Budget. We always want to have at least 1 day of inventory. Beginilag Inventory is listed below Beginning Inventory 356 Quarters Q1 Q2 03 04 Total Budgeted Sales Desired Ending Inventory Total Units Needed Less: Beginning Inventory Required Production Grading Financials Costs Job Order EOS CVP Budgets Variances Pricing Discussion + 24 XV fx B D E F G H Materials Budget We need to know how much raw materials to have on hand based on our production budget. We also need to calculate the cost of these purchases. Create the materials budget in units and in costs. The amount per dozen comes from the EOS tab. The cost per unit is projected to be higher than the cost per unit in the EOS tab (see material cost increase), Material Cost Increase 2.50% Quarters Q1 Total Required production 02 03 04 Sugar Raw materials needed Material Amt per dz Flour 0.50 Butter 0.25 0.50 Eggs 0.17 Milk 0.10 Cocoa Powder 0.25 Chocolate icing 0.75 Bakery box 1.00 Cost per unit Material Flour Butter Sugar Eggs Milk Cocoa Powder Chocolate icing Bakery box Total Price per dozen Grading Financials Costs Joh ter FOS CVP Budate Warna Pricing Dicuri L24 - X fx B A VES D E F G H a 02 03 04 51 Chocolate icing 52 Bakery box 53 Total 54 Price per dozen 55 56 Labor Budget You have recently hired more people to mix, bake, and package your cupcakes. The mixers, bakers, and packers perform their jobs at different speeds, Review the number of dozen cupcakes each position can complete within an hour. Based on this information, calculate the Standard Time 57 that each position needs to complete all required production. Prepare a labor budget for these employees. 58 Quarters 59 Q1 Total 60 Dozen per Hr Standard Time Hrly Rate 61 Mixers 32 $ 62 Bakers 16 $ 17.00 63 Packers 32 $ 13.00 64 Total 65 Standard time based on 1st quarter Required Production 66 67 68 69 70 71 72 73 14.00 74 75 76 77 70