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...
-
On January 1, 2014, Grand Isle Corporation issued $900,000 in bonds that mature in five years. The bonds have a stated interest rate of 10 percent and pay interest on December 31 each year. When the...
-
Let x be a discrete random variable that possesses a binomial distribution. a. Using Table I of Appendix C, write the probability distribution of x for n = 7 and p = .30 and graph it. b. What are the...
-
Describe the shifts in UK share ownership over the past 60 years. Suggest some reasons for the changes.
-
You have recently been hired by Keafer Manufacturing to work in its newly established treasury department. Keafer Manufacturing is a small company that produces highly customized cardboard boxes in a...
-
Give a brief background on Knutsford express bus company jamaica. discuss how they could adopt lufthansa business model in their operations
-
Madetoja Oys job-costing system has two direct-cost categories: direct materials and direct manufacturing labour. Manufacturing overhead (both variable and fixed) is allocated to products on the...
-
Explain how you would design a tree data structure to represent the directory structure. What attributes would each node of the tree contain? How would you handle nested directories?
-
Identify the circumstances that may warrant the expression of (a) a qualified opinion, (b) an adverse opinion, and (c) a disclaimer of opinion.
-
What factors should be considered by an auditor in determining whether (a) he can serve as the principal auditor, and (b) whether, as principal auditor, he should make reference to the work of...
-
Sweet Cookies is planning to launch a new line of cookies and wants to assess the market size. The cookies have a mixed chocolate-pineapple flavor and will be targeted at the premium end of the...
-
Indicate the possible effects on the auditor's report of a departure from (a) a promulgated principle and (b) a GAAP.
-
Find the z-score for which the area to its right is 0.14.
-
Day Non-conformances Day Non-conformances 1 21 17 20 2 22 18 16 3 20 19 11 4 21 20 24 5 23 21 25 6 39 22 21 7 18 23 23 00 8 9 10 222 24 24 20 20 25 24 22 26 28 11 19 27 21 12 23 28 19 13 22 29 15 14...
-
The first national bank pays a 4% interest rate compound continuously. The effective annual rate paid by the bank is __________. a. 4.16% b. 4.20% c. 4.08% d. 4.12%
-
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. Sketch possible arrangements for the piping and valves for Figure 14-6. Note that every tank needs to be able to receive fresh washwater or overflow from the next higher letter tank, except for...
-
What are some ideal ways for the board and staff to communicate with each other?
-
Define the differences between the respective authorities, responsibilities, and liabilities of an individual board member and those of the full board.
Study smarter with the SolutionInn App