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
Textbook Question
Chapter 10, Problem 10.27AE
Work backward to find missing values (Learning Objective 5)
Newton Industries has a relevant range extending to 31,800 units each month. The following performance report provides information about Newton’s budget and actual performance for April:
Requirement
Fill in all missing numbers in the table. Be sure to label any variances as favorable or unfavorable.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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…
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…
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
- In 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_forwardPrepare 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_forwardSubmit 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…arrow_forward
- ShawnTech 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_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_forwardFriendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forward
- Using Regression to Calculate Fixed Cost, Calculate the Variable Rate, Construct a Cost Formula, and Determine Budgeted Cost Refer to the information for Speedy Petes on the previous page. Coefficients shown by a regression program for Speedy Petes data are: Required: Use the results of regression to make the following calculations: 1. Calculate the fixed cost of deliveries and the variable rate per delivery. 2. Construct the cost formula for total delivery cost. 3. Calculate the budgeted cost for next month, assuming that 3,000 deliveries are budgeted. (Note: Round answers to the nearest dollar.) Use the following information for Brief Exercises 3-26 through 3-29: Speedy Petes is a small start-up company that delivers high-end coffee drinks to large metropolitan office buildings via a cutting-edge motorized coffee cart to compete with other premium coffee shops. Data for the past 8 months were collected as follows:arrow_forwardPease Contractors is a local home remodeling company. In analyzing financial performance, the accountant compares actual results with a flexible budget. The standard direct labor rates used in the flexible budget are established each year at the time the annual plan is formulated and held constant for the entire year. The standard direct labor rates in effect for the current fiscal year and the standard hours allowed for the actual output of work for August are shown in the following schedule. Worker Classification Standard Direct Labor Rate per Hour Standard Direct Labor-Hours Allowed for Output Supervisor $ 50 1,800 Skilled 30 2,250 General 20 4,950 The actual direct labor-hours worked and the actual direct labor rates per hour experienced for the month of August were as follows. Worker Classification Actual Direct Labor Rate per Hour Actual Direct Labor-Hours Supervisor $ 54 2,112 Skilled 32 2,112 General 18 5,376 Required: Calculate the dollar…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 - 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_forward
- this 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_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_forwardOne subunit of Field Sports Company had the following financial results last month: E (Click the icon to view the financial results.) Read the requirements. Requirement 1. Complete the performance evaluation report for the subunit. (Enter a variance for each account as a positive number and select whether the variance is favorable or unfavorable. Enter the variance percent as a percentage rounded to two decimal places, X.XX%.) - X Actual Flexible Flexible Budget Requirements Subunit X Results Budget Variance (F or U) Net Sales Revenue $ 473,000 S 453.000 1. Complete the performance evaluation report for the subunit (round to two decimal places). 265,000 254,000 Variable Expenses Based on the data presented and your knowledge of the company, what type of responsibility center is this subunit? 3. Which items should be investigated if part of management's decision criteria is to investigate all variances equal to or exceeding $4,000 and exceeding 10% (both criteria must be met)?…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
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