Calculations and backup should be completed and submitted in one Excel file. Word documents or other...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Fixed Costs (listed) XX 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 $79.00 per each $34.00 per each $12.00 per each $6.00 per each Packaging Costs Electricity $8.00 per each $550,000 per month Waste and Other Costs Salary and Wages Costs Fringe Benefits Rent Costs 50% of Salaries $900,000 per month $50,000 per month $380,000 per month Insurance Costs Depreciation Costs 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) January February 235,000 177,000 $ 18,495,000 $ 13,995,000 7,735,000 $ 5,843,000 Revenue Raw Materials Packaging Materials Electricity $ 2,870,000 $ 2,197,000 $ 1,485,000 $ 962,000 Waste and Other Costs $ 1,985,000 $ 1,452,000 550,000 $ 275,000 $ 900,000 $ 50,000 $ Wages Fringe Benefits $ 560,000 280,000 $ $ Rent 900,000 Insurance 55,000 Depreciation $ 380,000 $ 390,000 Question 1: Prepare a static budget in Excel for Vroom-Vroom based on 200,000 units produced. (32 points) a) Show the static budget for January in Contribution Margin Income Statement format – be sure to list out each expense line. b) Compare January's static budget to January's actual results. Specify which line items are favorable or unfavorable and how much. Provide potential explanations for each of the variable costs. Note: Saying that an item was above or below budget is NOT an explanation. You need to include potential (made-up) reasons. c) Show the static budget for February in Contribution Margin Income Statement format – be sure to list out each expense line. d) Compare February's static budget to February's actual results. Specify which line items are favorable or unfavorable and how much. Provide potential explanations for each of the variable costs. Note: Saying that an item was above or below budget is NOT an explanation. You need to include potential (made-up) reasons. Extra Credit: (6 points) a) Using the static budget for January in Question 1 (compared to January actual results), calculate the price variance and volume variance for raw materials. 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 Fixed Costs (listed) XX 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 $79.00 per each $34.00 per each $12.00 per each $6.00 per each Packaging Costs Electricity $8.00 per each $550,000 per month Waste and Other Costs Salary and Wages Costs Fringe Benefits Rent Costs 50% of Salaries $900,000 per month $50,000 per month $380,000 per month Insurance Costs Depreciation Costs 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) January February 235,000 177,000 $ 18,495,000 $ 13,995,000 7,735,000 $ 5,843,000 Revenue Raw Materials Packaging Materials Electricity $ 2,870,000 $ 2,197,000 $ 1,485,000 $ 962,000 Waste and Other Costs $ 1,985,000 $ 1,452,000 550,000 $ 275,000 $ 900,000 $ 50,000 $ Wages Fringe Benefits $ 560,000 280,000 $ $ Rent 900,000 Insurance 55,000 Depreciation $ 380,000 $ 390,000 Question 1: Prepare a static budget in Excel for Vroom-Vroom based on 200,000 units produced. (32 points) a) Show the static budget for January in Contribution Margin Income Statement format – be sure to list out each expense line. b) Compare January's static budget to January's actual results. Specify which line items are favorable or unfavorable and how much. Provide potential explanations for each of the variable costs. Note: Saying that an item was above or below budget is NOT an explanation. You need to include potential (made-up) reasons. c) Show the static budget for February in Contribution Margin Income Statement format – be sure to list out each expense line. d) Compare February's static budget to February's actual results. Specify which line items are favorable or unfavorable and how much. Provide potential explanations for each of the variable costs. Note: Saying that an item was above or below budget is NOT an explanation. You need to include potential (made-up) reasons. Extra Credit: (6 points) a) Using the static budget for January in Question 1 (compared to January actual results), calculate the price variance and volume variance for raw materials.
Expert Answer:
Answer rating: 100% (QA)
Variable Cost These are the cost that increments with the expansion in the unit of creations This implies that if the unit of creation has expanded the expense of creation will likewise increment Cost ... View the full answer
Related Book For
Cost Accounting A Managerial Emphasis
ISBN: 978-0133138443
7th Canadian Edition
Authors: Srikant M. Datar, Madhav V. Rajan, Charles T. Horngren, Louis Beaubien, Chris Graham
Posted Date:
Students also viewed these accounting questions
-
a. Prepare a profit graph for Donaldson Company. To prepare your graph, use sales volumes of zero units and 50,000 units as shown in cells B23 and B24. As a first step, create a formula in cell C23...
-
Selling price per unit $750 Variable cost per unit $450 Annual fixed cost $180,000 Net income after tax $360,000 Tax rate 25% 1)Reduce the selling price by $60. The sales team forecast that with a...
-
Assume management predicts that the selling price per unit and variable cost per unit will be the same in 2014 as in 2013. Fixed manufacturing costs and marketing, distribution, and customer-service...
-
Phoenix Corp. faltered in the recent recession but is recovering. Free cash flow has grown rapidly. Forecasts made in 2016 are as follows. Phoenix's recovery will be complete by 2021, and there will...
-
You recently went to work for Allied Components Company, a supplier of auto repair parts used in the after-market with products from Daimler, Chrysler, Ford, and other automakers. Your boss, the...
-
List two possible limitations when using social media for marketing research.
-
Among 100 fish caught in a large lake, 18 were inedible due to the pollution of the environment. If we use \(\frac{18}{100}=0.18\) as an estimate of the corresponding true proportion, with what...
-
The Montero Company, a wholesale distributor of furnace and air conditioning equipment, began business on July 1, 20X2. The following summarized transactions occurred during July: a. Monteros...
-
You are flying your glider around your local airport for fun one late Saturday afternoon in July. The convective currents are great that day. You fly for about 1.5 hours enjoying a perfect day for...
-
1. Assume a 30% tax rate, and the Totals per financial statements provided. Complete the following schedule as per Figure 16.4. Assume that the Totals per financial statements (second to bottom row)...
-
A promissory note has a face value of $5000 and it carries an interest rate of 5% for a period of 6 months (including the period of grace). It is sold 3 months before the legal due date. What is the...
-
This information is for Java Growers for the year ended December 31, 2025 (amounts in thousands). Instructions Prepare the 2025 statement of cash flows for Java Growers. Identify cash flow...
-
What was the change in Globals book value of equity from 2021 to 2022 according to Table 2.1? Does this imply that the market price of Globals shares increased in 2022? Explain. TABLE 2.1 Liabilities...
-
The following quote on Tesla stock appeared on April 8, 2022, on Yahoo! Finance. If you wanted to buy Tesla, what price would you pay per share? How much would you receive per share if you wanted to...
-
Radiocarbon dating assumes that the abundance of \({ }^{14} \mathrm{C}\) in the environment has been constant. Suppose \({ }^{14} \mathrm{C}\) was less abundant 10,000 years ago than it is today....
-
Which of the following are valid PDFs? Justify your answer. a. \(f(x)=(.2)^{x}(.6)^{1-x} I_{\{0,1\}}(x)\) b. \(f(x)=(.3)(.7)^{x} I_{\{0,1,2, \ldots\}}\{x\}\) c. \(f(x)=.6 e^{-x / 4} I_{(0,...
-
Y2 1. what are the basic securities? explain with example 2. what are common stocks? explain with example 3. what are the government regulations on securities 4. what are the self-regulatory...
-
Provide a few individual examples who revealed what aspects of emotional intelligence?
-
An analysis of La Flamme's operating income changes between 2015 and 2016 shows the following: (Continuation of Exercise 13-16) Operating income for 2016 ........................... $1,700,000 Add...
-
Why do managers consider direct costs to be more accurate than indirect costs?
-
Why should managers consider income tax issues when choosing a transfer-pricing method?
-
Draw and explain the class diagram for stable analysis pattern? Identify and highlight all participants and explain why they exist.
-
List some design and implementation issues faced, when implementing this pattern. Explain each issue.
-
List some differences between the analysis pattern described here and the traditional pattern.
Study smarter with the SolutionInn App