Calculations and backup should be completed and submitted in one Excel file. Word documents or other file types will not be accepted. Use proper Contribution Margin Income Statement formatting (see below). Each question refers to the same initial data. Treat each question separately. Ignore income taxes. Assume no beginning or ending inventories. Calculations and backup should be completed and submitted in Excel. Leave any formulas used in the Excel cells (do not hard code or type in results); this allows for partial credit if possible. Analysis can either be typed into cells in Excel (formatted to be easily legible) or typed into a text box in Excel. Students are expected to work independently. Contribution Margin format example: Volume XX Sales XX Variable Costs (listed) XX Variable Costs Total XX Contribution Margin XX Fixed Costs (listed) XX Fixed Costs Total XX Operating Income XX Note: This case study is based on Material from Chapters 8 & 9. The extra credit is based on Material in Chapter 10. (We do not specifically cover Chapter 10, so that is why this portion of the case study is Extra Credit.) Vroom-Vroom manufactures ride-on cars for toddlers and young children. They have a fiscal year of January through December. When they were preparing their budget, they couldn't decide if a static or flexible budget would be best for their company - so they did both. It is now March, and their accounting department is catching up on analyzing variances for both January and February. Vroom-Vroom would like to use this opportunity to determine whether they would be better off with a static or flexible budget going forward. They want to choose which budget and related variance analysis provides them the best information for decision-making. Here is the data that Vroom-Vroom used for their budgets: Monthly Budget Data: Selling price per unit: Raw Material Costs Packaging Costs Electricity Waste and Other Costs Salary and Wages Costs Fringe Benefits Rent Costs Insurance Costs Depreciation Costs $79.00 per each $34.00 per each $12.00 per each $6.00 per each $8.00 per each $550,000 per month 50% of Salaries $900,000 per month $50,000 per month $380,000 per month Vroom-Vroom estimated sales/production will be between 100,000 and 300,000 cars per month. Their static budget is based on 200,000 cars sold per month. Assume that all units produced in a month are also sold in that month. Vroom- Vroom's unit of production/sale is a car (unit/each). Here are the Actual Results in January and February: Actual Data: Production (Units) Revenue Raw Materials Packaging Materials Electricity Waste and Other Costs Wages Fringe Benefits Rent Insurance Depreciation January February 235,000 177,000 $ 18,495,000 $13,995,000 $ 7,735,000 $ 5,843,000 $ 2,870,000 $ 2,197,000 $ 1,485,000 $ 962,000 $ 1,985,000 $ 1,452,000 $ 550,000 $ 560,000 $ 275,000 $ 280,000 $ 900,000 $ 900,000 $ 50,000 $ 55,000 $ 380,000 $ 390,000 Question 3: Analyze the differences between static and flexible budgets. (34 points) a) What is the difference between static and flexible budgets in theory? b) What are the differences between the static and flexible budgets for Vroom-Vroom? What variances are different and by how much? What does this tell us? c) What are the pros and cons for each - static and flexible budgets? d) Write a letter to Vroom-Vroom's CFO. Explain the results in January and February. Provide your recommendation for either static or flexible budgets. Provide explanations and backup for your recommendation. Note: A letter to the CFO should have correct spelling and grammar, and is expected to be approximately 400 words. Thorough explanations with backup are required. Calculations and backup should be completed and submitted in one Excel file. Word documents or other file types will not be accepted. Use proper Contribution Margin Income Statement formatting (see below). Each question refers to the same initial data. Treat each question separately. Ignore income taxes. Assume no beginning or ending inventories. Calculations and backup should be completed and submitted in Excel. Leave any formulas used in the Excel cells (do not hard code or type in results); this allows for partial credit if possible. Analysis can either be typed into cells in Excel (formatted to be easily legible) or typed into a text box in Excel. Students are expected to work independently. Contribution Margin format example: Volume XX Sales XX Variable Costs (listed) XX Variable Costs Total XX Contribution Margin XX Fixed Costs (listed) XX Fixed Costs Total XX Operating Income XX Note: This case study is based on Material from Chapters 8 & 9. The extra credit is based on Material in Chapter 10. (We do not specifically cover Chapter 10, so that is why this portion of the case study is Extra Credit.) Vroom-Vroom manufactures ride-on cars for toddlers and young children. They have a fiscal year of January through December. When they were preparing their budget, they couldn't decide if a static or flexible budget would be best for their company - so they did both. It is now March, and their accounting department is catching up on analyzing variances for both January and February. Vroom-Vroom would like to use this opportunity to determine whether they would be better off with a static or flexible budget going forward. They want to choose which budget and related variance analysis provides them the best information for decision-making. Here is the data that Vroom-Vroom used for their budgets: Monthly Budget Data: Selling price per unit: Raw Material Costs Packaging Costs Electricity Waste and Other Costs Salary and Wages Costs Fringe Benefits Rent Costs Insurance Costs Depreciation Costs $79.00 per each $34.00 per each $12.00 per each $6.00 per each $8.00 per each $550,000 per month 50% of Salaries $900,000 per month $50,000 per month $380,000 per month Vroom-Vroom estimated sales/production will be between 100,000 and 300,000 cars per month. Their static budget is based on 200,000 cars sold per month. Assume that all units produced in a month are also sold in that month. Vroom- Vroom's unit of production/sale is a car (unit/each). Here are the Actual Results in January and February: Actual Data: Production (Units) Revenue Raw Materials Packaging Materials Electricity Waste and Other Costs Wages Fringe Benefits Rent Insurance Depreciation January February 235,000 177,000 $ 18,495,000 $13,995,000 $ 7,735,000 $ 5,843,000 $ 2,870,000 $ 2,197,000 $ 1,485,000 $ 962,000 $ 1,985,000 $ 1,452,000 $ 550,000 $ 560,000 $ 275,000 $ 280,000 $ 900,000 $ 900,000 $ 50,000 $ 55,000 $ 380,000 $ 390,000 Question 3: Analyze the differences between static and flexible budgets. (34 points) a) What is the difference between static and flexible budgets in theory? b) What are the differences between the static and flexible budgets for Vroom-Vroom? What variances are different and by how much? What does this tell us? c) What are the pros and cons for each - static and flexible budgets? d) Write a letter to Vroom-Vroom's CFO. Explain the results in January and February. Provide your recommendation for either static or flexible budgets. Provide explanations and backup for your recommendation. Note: A letter to the CFO should have correct spelling and grammar, and is expected to be approximately 400 words. Thorough explanations with backup are required