Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 10, Problem 10.40BE
To determine
To find: The missing values in the table and also tell as they are favorable or unfavorable.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Submit your final work via moodle.gusto-education.com by
10th February 2024 (Saturday) 23:59 PM
Submit your declaration form and Assignment Brief within 3 school days after Hand-
in.
Unit Learning Outcomes
LO1: Explore the nature, source, and purpose of management accounting
information.
LO2: Evaluate management accounting techniques to inform optimal resource
allocation and decision-making.
LO3: Analyse actual and standard costs to control and correct variances.
LO4: Evaluate how the management accounting function contributes to performance
measurement and monitoring.
Transferable skills and competencies developed
Vocational scenario
You have been hired as a Junior Management Accountant by a manufacturing
company called Columbus Canopy Company (CCC) is a leading player in the industry
and is constantly striving to maintain its competitive advantage. The company is
experiencing rapid growth and facing various challenges in resource allocation,
decision-making, and performance…
The Gourmand Cooking School runs short cooking courses at its small campus. Management has identified two cost drivers it uses in
its budgeting and performance reports-the number of courses and the total number of students. For example, the school might run
two courses in a month and have a total of 62 students enrolled in those two courses. Data concerning the company's cost formulas
appear below
Instructor wages
Classroom supplies
utilities
Campus rent
Insurance
Administrative expenses
Fixed Cost Cost per
per Month
Revenue
Instructor wages
Classroom supplies
Utilities
Campus rent
Insurance
Administrative expenses
$1,240 5 75
$5,000
$2,200
$3,600 $ 44
Courses
Course
$ 2,950
For example, administrative expenses should be $3,600 per month plus $44 per course plus $6 per student. The company's sales
should average $890 per student
The company planned to run four courses with a total of 62 students, however, it actually ran four courses with a total of only 58
students. The actual…
The College of Business at Northeast College is accumulating data as a first step in the preparation of next year's budget development. One cost that is being looked at
closely is administrative costs as a function of student credit hours. Data on administrative costs and credit hours for the past thirteen months are shown below:
Month
July
August
September
October
November
December
January
February
March
April
May
June
July
Total
Average
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
ANOVA
Administrative
Costs
$ 130, 151
Regression
Residual
Total
83,293
226,090
216,734
258,433
185,299
219,817
245, 510
209,802
192,095
250,828
171,098
128,677
$ 2,517,827
$ 193,679
SUMMARY OUTPUT
Regression Statistics
The controller's office has analyzed the data and has given you the results from the regression analysis:
Credit Hours
df
1
11
12
1,100
557
1,834
1,442
1,751
1,554
1,781
1,815
1,506
1,565
1,802
862
757
18,326
1,410
0.9169697
0.840833374
0.826363681
22,082.14006
13
SS…
Chapter 10 Solutions
Managerial Accounting (5th Edition)
Ch. 10 - (Learning Objective 1) Companies often...Ch. 10 - (Learning Objective 1) Which of the following is...Ch. 10 - (Learning Objective 1) In terms of responsibility...Ch. 10 - (Learning Objective 2) Which of the following is...Ch. 10 - (Learning Objective 2) A segment margin is the...Ch. 10 - Prob. 6QCCh. 10 - Prob. 7QCCh. 10 - Prob. 8QCCh. 10 - Prob. 9QCCh. 10 - Prob. 10QC
Ch. 10 - Identify and understand responsibility centers...Ch. 10 - Identify types of responsibility centers (Learning...Ch. 10 - Identify centralized and decentralized...Ch. 10 - Prob. 10.4SECh. 10 - Prob. 10.5SECh. 10 - Prob. 10.6SECh. 10 - Calculate ROI (Learning Objective 3) Refer to Epic...Ch. 10 - Prob. 10.8SECh. 10 - Prob. 10.9SECh. 10 - Prob. 10.10SECh. 10 - Prob. 10.11SECh. 10 - Interpret a performance report (Learning Objective...Ch. 10 - Prob. 10.13SECh. 10 - Classify KPIs by balanced scorecard perspective...Ch. 10 - Use vocabulary terms (Learning Objectives 1, 2, 3,...Ch. 10 - Prob. 10.16SECh. 10 - Identify type of responsibility center (Learning...Ch. 10 - Complete and analyze a performance report...Ch. 10 - Prepare a segment margin performance report...Ch. 10 - Compute and interpret the expanded ROI equation...Ch. 10 - Prob. 10.21AECh. 10 - Prob. 10.22AECh. 10 - Comparison of ROI and residual income (Learning...Ch. 10 - Prob. 10.24AECh. 10 - Comprehensive flexible budget problem (Learning...Ch. 10 - Prepare a flexible budget performance report...Ch. 10 - Work backward to find missing values (Learning...Ch. 10 - Construct a balanced scorecard (Learning Objective...Ch. 10 - Sustainability and the balanced scorecard...Ch. 10 - Identify type of responsibility center (Learning...Ch. 10 - Complete and analyze a performance report...Ch. 10 - Prob. 10.32BECh. 10 - Prob. 10.33BECh. 10 - Prob. 10.34BECh. 10 - Prob. 10.35BECh. 10 - Prob. 10.36BECh. 10 - Prob. 10.37BECh. 10 - Prob. 10.38BECh. 10 - Prob. 10.39BECh. 10 - Prob. 10.40BECh. 10 - Prob. 10.41BECh. 10 - Sustainability and the balanced scorecard...Ch. 10 - Prepare a budget with different volumes for...Ch. 10 - Prepare and interpret a performance report...Ch. 10 - Prob. 10.45APCh. 10 - Prob. 10.46APCh. 10 - Prob. 10.47APCh. 10 - Evaluate subunit performance (Learning Objectives...Ch. 10 - Prob. 10.49BPCh. 10 - Prob. 10.50BPCh. 10 - Evaluate divisional performance (Learning...Ch. 10 - Prob. 10.52BPCh. 10 - Determine transfer price at a manufacturer under...Ch. 10 - Evaluate subunit performance (Learning Objectives...Ch. 10 - Prob. 10.55SC
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Roberds Tech is a for-profit vocational school. The school bases its budgets on two measures of activity (i.e., cost drivers), namely student and course. The school uses the following data in its budgeting: Fixed element per month Variable element per student Variable element per course Revenue $ 0 $ 298 $ 0 Faculty wages $ 0 $ 0 $ 3,100 Course supplies $ 0 $ 52 $ 40 Administrative expenses $ 26,500 $ 27 $ 52 In March, the school budgeted for 1,910 students and 88 courses. The school's income statement showing the actual results for the month appears below: Roberds Tech Income Statement For the Month Ended March 31 Actual students 1,810 Actual courses 91 Revenue $ 411,340 Expenses: Faculty wages 214,950 Course supplies 62,590 Administrative expenses 84,562 Total expense 362,102 Net operating income $ 49,238 Required: Prepare a flexible budget performance report showing both the school's activity variances and revenue and spending…arrow_forwardRequired: Compute the following for Iguana, Incorporated, for the second quarter (April, May, and June). Note: Do not round your intermediate calculations. April May June 2nd Quarter Total 1. Budgeted Sales Revenue $6,250selected answer correct $7,500selected answer correct $10,000selected answer correct $23,750 2. Budgeted Production in Units 270selected answer correct 340selected answer correct 390selected answer correct 1,000not attempted 3. Budgeted Cost of Direct Material Purchases $4,656selected answer incorrect not attempted not attempted $4,656 4. Budgeted Direct Labor Cost not attempted not attempted not attempted $0 5. Budgeted Manufacturing Overhead not attempted not attempted not attempted $0 6. Budgeted Cost of Goods Sold not attempted not attempted not attempted $0 7. Total Budgeted Selling and Administrative Expensearrow_forwardAssume that a company provided the following excerpts of Information from its flexible budget performance report Actual Results Courses (91) students (92) Expenses: Administrative expense ($125+ $25091 + $3092) What is the administrative expense activity variance? Multiple Choice O O $550 P $225 F $1.575 P 51125 M 8 260 $ 8,900 Flexible Planning Budget Budget 2 9 > ? 270 $?arrow_forward
- Prepare a 12-month Master Budget for a company of your choosing. It can be a company that you are closely connect too or one randomly selected. COMPLETED IN EXCEL. As you are preparing the Master Budget, some information is NOT provided. You are required to decide or predict or forecast this information. Provide an introduction for the company you have chosen. The introduction should include the following: Name of company Location of company Name of owner Nature of the business. Type of product Fiscal period For the company that you have selected - Prepare a 12-month Master Budget. Your submission must show each month’s activities. Here are some considerations to include in preparing the budget: You must forecast your sales, purchases, direct labour and manufacturing overhead for each month and any other information as required All sales are on accounts Expected collections are to be 50% in the month of the sale, 30 % in the first month following the sale, and 20% in the second…arrow_forwardComplete the flexible budget variance analysis by filling in the blanks in the partial flexible budget performance report for 9,000 travel locks for Galen, Inc. E (Click the icon to view the report.) (For variances with a $0 value, make sure to enter "0" in the appropriate cells.) - X Galen, Inc. Data Table Flexible Budget Performance Report (partial) For the Month Ended April 30, 2018 Actual Flexible Budget Flexible Galen, Inc. Results Variance Budget Flexible Budget Performance Report (partial) For the Month Ended April 30, 2018 Flexible Budget Units 9.000 9,000 Flexible Budget Actual Sales Revenue 171,000 $ 153,000 Results Variance 51,900 49,700 Variable Costs Units 9,000 (a) 9,000 Contribution Margin 119.100 103,300 Sales Revenue 171,000 (b) (c) s 153.000 15,700 15,100 Fixed Costs Variable Costs 51,900 (d) (e) 49,700 Operating Income $ 103.400 $ 88,200 Contribution Margin 119,100 (f) (g) 103,300 Fixed Costs 15,700 (h) () 15,100 Operating Income $ 103,400 (k) s 88,200 Print Donearrow_forwardShawnTech is a for-profit vocational school. The school bases its budgets on two measures of activity (i.e., cost drivers), namely student and course. The school uses the following data in its budgeting: Fixed element per month variable element per student variable element per course revenue $0 $354 $0 faculty wages $0 $0 $2,300 course supplies $0 $48 $40 administrative expenses $41,700 $13 $21 In October, the school budgeted for 1,400 students and 127 courses. The actual activity for the month was 1,500 students and 129 courses. Prepare a report showing the school's activity variances for October. Label each variance as favorable (F) or unfavorable (U).arrow_forward
- After overhead adjustment, income increased by $5,000. Actual MOH = $130,000. MOH applied using DLH. Budgeted DLH - $6,000; actual DLH = $8,000. Computer budgeted MOH.arrow_forwardIn this task you are provided with an excel file with 2 spread sheets (Budgeted Rooms Revenue Sheet, Actual Rooms Revenue sheet) with the actual figures on the rooms for a given quarter. You are required to calculate the actual revenue that has been generated for each month in the given quarter based on the actual occupancy rate. Calculate the following details using the appropriate sheet as per the given instructions Budgeted Rooms Revenue Sheet Refer to the projected data sheet. In this sheet first calculate the total projected/forecasted revenue per room type for all 365 days. You are also required to calculate total projected/forecasted revenue per room type for each month for Jan, Feb and Mar. Calculate the total rooms for each month Calculate the Total Revenue for all room types for each month Calculate the total projected revenue for 3 months (Jan, Feb and Mar) Actual Rooms Revenue Sheet In this sheet you are provided with the Actual occupancy for each month. Calculate the…arrow_forwardRefer to the data for The Terminator Inc. in Brief Exercise 8–6. A management intern has suggested thatthe budgeted revenues and costs should be adjusted for the actual level of activity in April before they arecompared to the actual revenues and costs. Because the actual level of activity was 5% higher than budgeted, the intern suggested that all budgeted revenues and costs should be adjusted upward by 5%. A reportcomparing the budgeted revenues and costs, with this adjustment, to the actual revenues and costs appearson the following page.The Terminator Inc.Variance ReportFor the Month Ended April 30AdjustedPlanning ActualBudget Results VariancesJobs ............................................. 105 105Revenue ...................................... $20,475 $20,520 $ 45 FExpenses:Mobile team operating costs .... 10,500 10,320 180 FExterminating supplies ............. 1,890 960 930 FAdvertising ............................... 840 800 40 FDispatching costs ..................... 2,310…arrow_forward
- Barlow Company manufactures book bags and has provided the following information for June 2018: E (Click the icon to view the information.) Requirements 1. Prepare a flexible budget performance report. (Hint: You will need to calculate the flexible budget amounts for 10,000 units.) 2. As the company owner, which employees would you praise or criticize after you analyze this performance report? Requirement 1. Prepare a flexible budget performance report. (Hint. You will need to calculate the flexible budget amounts for 10,000 units.) (Enter a "0" for any zero balances. For any $0 variances, leave the Favorable (F)/Unfavorable (U) input blank. Enter all amounts as positive values.) Barlow Company Flexible Budget Performance Report For the Month Ended June 30, 2018 - X 1 Data Table (1) - (3) (3) - (5) Budget Flexible Sales Static Budget 11,000 Amounts Actual Budget Flexible Volume Static Actual Results Units 10,000 Per Unit Results Variance Budget Variance Budget Sales Revenue $ 174,000 $…arrow_forwardBarlow Company manufactures book bags and has provided the following information for June 2018: E (Click the icon to view the information.) Requirements 1. Prepare a flexible budget performance report. (Hint: You will need to calculate the flexible budget amounts for 10,000 units.) 2. As the company owner, which employees would you praise or criticize after you analyze this performance report? Requirement 1. Prepare a flexible budget performance report. (Hint. You will need to calculate the flexible budget amounts for 10,000 units.) (Enter a "0" for any zero balances. For any $0 variances, leave the Favorable (F)/Unfavorable (U) input blank. Enter all amounts as positive values.) Barlow Company Flexible Budget Performance Report For the Month Ended June 30, 2018 1 2 3 4 - X Data Table (1) - (3) (3) - (5) Budget Flexible Sales Amounts Actual Budget Flexible Volume Static Static Budget Actual Results Per Unit Results Variance Budget Variance Budget Units 10,000 11,000 Units Sales Revenue…arrow_forwardthis is actually a budgeting lesson. Beginning inventory 4.000 unit Ending inventory 3.500 unit The lack will be allocated to the 5 months (Jan, Feb, March, April dan May). Arrange production budget with a policy that accentuate production stability!arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY