Assume that owners decided to go ahead with the Canmore expansion (first introduced in question 4)....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Assume that owners decided to go ahead with the Canmore expansion (first introduced in question 4). The junior accountant has prepared the following report to compare the static budget (from question 4) to the actual results. The owners have asked you to complete a variance analysis. Required: Part A (4 marks)- Create a Static Budget Report Variance Analysis, indicating whether variances are favorable (F) or unfavorable (U). All variance amounts should be shown as positive numbers. Static Budget Actual Variance Favorable or Amount Results Amount Unfavorable Sales in Units 4,096 5,330 Sales 512,000 $ 639,600 Less: Variable Costs: Cost of Goods Sold 217,000 220,000 Sales Commissions 66,560 70,356 Total Variable Costs 283,560 290,356 Contribution Margin 228,440 349,244 Less: Fixed Costs: Total Fixed Costs 197,000 177,000 Net Operating Income 31,440 172,244 What is the weakness of using a static budget report to evaluate performance? (2 marks) Required: Part B (6 marks) - The owners can see that the company sold a different amount of units than budgeted. They have asked you to create a flexible budget report. Flexible Budget Actual Variance Favorable (F) or Amount Results Amount Unfavorable (U) Sales in Units 5,330 Sales 639,600 Less: Variable Costs: Cost of Goods Sold 220,000 Sales Commissions 70,356 Total Variable Costs 290,356 Contribution Margin 349,244 Less: Fixed Costs 177,000 Net Operating Income 172,244 Management was pleased on the results based on the static budget report. Should they be pleased? What does the flexible budget tell you? What are your recommendations to management based on the flexible budget report? (3 marks) Assume that owners decided to go ahead with the Canmore expansion (first introduced in question 4). The junior accountant has prepared the following report to compare the static budget (from question 4) to the actual results. The owners have asked you to complete a variance analysis. Required: Part A (4 marks)- Create a Static Budget Report Variance Analysis, indicating whether variances are favorable (F) or unfavorable (U). All variance amounts should be shown as positive numbers. Static Budget Actual Variance Favorable or Amount Results Amount Unfavorable Sales in Units 4,096 5,330 Sales 512,000 $ 639,600 Less: Variable Costs: Cost of Goods Sold 217,000 220,000 Sales Commissions 66,560 70,356 Total Variable Costs 283,560 290,356 Contribution Margin 228,440 349,244 Less: Fixed Costs: Total Fixed Costs 197,000 177,000 Net Operating Income 31,440 172,244 What is the weakness of using a static budget report to evaluate performance? (2 marks) Required: Part B (6 marks) - The owners can see that the company sold a different amount of units than budgeted. They have asked you to create a flexible budget report. Flexible Budget Actual Variance Favorable (F) or Amount Results Amount Unfavorable (U) Sales in Units 5,330 Sales 639,600 Less: Variable Costs: Cost of Goods Sold 220,000 Sales Commissions 70,356 Total Variable Costs 290,356 Contribution Margin 349,244 Less: Fixed Costs 177,000 Net Operating Income 172,244 Management was pleased on the results based on the static budget report. Should they be pleased? What does the flexible budget tell you? What are your recommendations to management based on the flexible budget report? (3 marks)
Expert Answer:
Answer rating: 100% (QA)
Workings Static Budget Amount Actual Results Differences Sales in units q 4048 5170 1122 F Sales 125... View the full answer
Related Book For
Business Statistics
ISBN: 978-0321925831
3rd edition
Authors: Norean Sharpe, Richard Veaux, Paul Velleman
Posted Date:
Students also viewed these accounting questions
-
What is underapplied overhead? When Cost of Goods Sold is adjusted for underapplied overhead, will the cost increase or decrease? Why?
-
What is overapplied overhead? When Cost of Goods Sold is adjusted for overapplied overhead, will the cost increase or decrease? Why?
-
What is the difference between cost of goods sold and adjusted cost of goods sold?
-
Molecular weight data for some polymer are tabulated here. Compute the following: (a) The number-average molecular weight (b) The weight-average molecular weight. (c) If it is known that this...
-
The cost of goods sold computations for Sooner Company and Later Company are shown below. Instructions (a) Compute inventory turnover and days in inventory for each company. (b) Which company moves...
-
Find a general solution of each reducible second-order differential equation in Problems 4354. Assume x, y and/or y' positive where helpful (as in Example 11). y 3 y" = 1 Example 11 Solve the...
-
The 2000 mm long composite bar shown in Figure 1.46 consists of an aluminum bar having a modulus of elasticity E Al = 70 GPa and length L Al = 500 mm, which is securely fastened to a steel bar having...
-
A manager is trying to decide whether to buy one machine or two. If only one is purchased and demand proves to be excessive, the second machine can be purchased later. Some sales will be lost,...
-
Find the length of the curve (t)=(9,,) for-3
-
Consider the two mutually exclusive projects in Table P5.49. Salvage values represent the net proceeds (after tax) from disposal of the assets if they are sold at the end of each year. Both projects...
-
You are to calculate the price of a put option (European) on a currency with a strike price of .60, the current exchange rate of .62, six months to expiration, the volatility pursuant to the exchange...
-
Discuss the following statements. a. The Phillips curve implies that when unemployment is high, inflation is low, and vice versa. Therefore, we may experience either high inflation or high...
-
When President Abdel Fatah al-Sissi came to power in a 2013 military coup, he promised to fix Egypts mounting economic problems. Three years later, those problems had only intensified. The country...
-
In May 2019, South Koreas two major airlinesKorean Airlines and Asiana Airlines Inc.were hit by foreign exchange losses arising from the weakness of the Korean won against the U.S. dollar. Korean Air...
-
For decades, the European Union has been thought of as the worlds largest regional trade deal, measured by the number of countries involved and their combined GDP, but that has now changed. On...
-
The informal labor market in the informal work at home (e.g., preparing meals, taking care of children) is not counted as part of GDP. Such work also does not constitute employment in labor market...
-
3. You wish to make a one-year investment and have two choices: i. ii. Invest in a one-year zero-coupon bond and earn the one-year spot rate Invest in a three-year, 4% annual coupon bond and sell it...
-
Interest Compounded Annually. When P dollars is invested at interest rate i, compounded annually, for t years, the investment grows to A dollars, where A = P(1 + i) t . Trevor's parents deposit $7800...
-
Has the trend of de-creasing difference in age at first marriage seen in Exercise gotten stronger recently? Here are the scatterplot and residual plot for the data from 1975 through 2011, along with...
-
The data set provided contains last months credit card purchases of 500 customers randomly chosen from a segment of a major credit card issuer. The marketing department is considering a special offer...
-
Gallup found in 2013 that 58% of Americans worry a great deal or a fair amount about global warming, up from 55% in 2012. Results for this Gallup poll were based on telephone interviews conducted...
-
A regulation basketball is initially flat and is then inflated to a pressure of approximately \(24 \mathrm{lb} / \mathrm{in}^{2}\) absolute. Consider the air temperature to be constant at...
-
The presence of raindrops in the air during a heavy rainstorm increases the average density of the air-water mixture. Estimate by what percent the average air-water density is greater than that of...
-
Assume that the air volume in a small automobile tire is constant and equal to the volume between two concentric cylinders \(13 \mathrm{~cm}\) high with diameters of \(33 \mathrm{~cm}\) and \(52...
Study smarter with the SolutionInn App