Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 10, Problem 10.19AE
Prepare a segment margin performance report (Learning Objective 2)
Drizzdale Industries has gathered the following information about the actual sales revenues and expenses for its pharmaceuticals segment for the most recent year.
| Sales | $ 866,320 |
| Variable Cost of Goods Sold | $ 143,325 |
| Variable Operating Expenses | $ 162,162 |
| Direct Fixed Manufacturing |
$ 96,300 |
| Direct Fixed Operating Expenses | $17,280 |
| Common Fixed Expenses | $ 14,140 |
Budgeted data for the same time period for the pharmaceutical segment are as follows (all data are in millions):
| Budgeted sales in units | 9,100 |
| Budgeted average selling price per unit | $ 85 |
| Variable Cost of Goods Sold per unit | $ 15 |
| Variable Operating Expenses per unit | $ 18 |
| Direct Fixed Manufacturing Overhead (in total) | $ 90,000 |
| Direct Fixed Operating Expenses (in total) | $ 16,000 |
| Common Fixed Expenses Allocated to the Pharmaceutical Segment | $ 14,000 |
Prepare a segment margin performance report for the pharmaceutical segment. In this report, be sure to include lines for the contribution margin, the segment margin, and operating income. Calculate a variance and a variance percentage for each line in the report. Round to the nearest hundredth for the variance percentages (for example, if your answer is 16.2384%, round it to 16.24%).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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…
Howard Cooper, the president of Campbell Computer Services, needs your help. He wonders about the potential effects on the firm's
net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 3.
Standard rate and variable costs
Service rate per hour
$
85.00
Labor cost
37.00
Overhead cost
7.10
Selling, general, and administrative cost
Expected fixed costs
Facility maintenance
Selling, general, and administrative
3.80
$522,000
142,000
Required:
a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 45,000 hours of
services in Year 3.
b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can
achieve. According to the consultant's analysis, if Campbell charges customers $80 per hour, the firm can achieve 50,000 hours of
services. Prepare a flexible budget using the consultant's assumption.
c. The same…
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
- Drizzdale Industries has gathered the following information about the actual sales revenues and expenses for its pharmaceuticals segment for the most recent year Sales $ 866,320 Variable Cost of Goods Sold $ 143,325 Variable Operating Expenses $ 162,162 Direct Fixed Manufacturing Overhead $ 96,300 Direct Fixed Operating Expenses $ 17,280 Common Fixed Expenses $ 14,140 Budgeted data for the same time period for the pharmaceutical segment are as follows (all data are in millions): Budgeted sales in units 9,100 Budgeted average selling price per unit $ 85 Variable Cost of Goods Sold per unit $ 15 Variable Operating Expenses per unit $ 18 Direct Fixed Manufacturing Overhead (in total) $ 90,000 Direct Fixed Operating Expenses (in total) $ 16,000 Common Fixed Expenses Allocated to the Pharmaceutical Segment $ 14,000 Prepare a segment margin performance report for the pharmaceutical…arrow_forwardRoberds 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: Revenue Faculty wages Course supplies Administrative expenses Actual students Actual courses Revenue Expenses: Faculty wages Course supplies Administrative expenses Total expense Net operating income In March, the school budgeted for 1,720 students and 69 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 Students Courses Revenue Expenses: Fixed element per month Faculty wages Course supplies Administrative expenses $0 $0 $0 $ 25,550 Total expense Net operating income Variable element per student $203 $0 $33 Required: Prepare a flexible budget performance report showing both the school's activity variances and revenue and spending variances for March. Label each variance as…arrow_forwardCoyle Manufacturing reports the following information for year 1: Sales revenue (60,000 units) Manufacturing costs Materials Variable cash costs Fixed cash costs. Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total costs Operating profits (losses) Coyle Manufacturing Budgeted Income Statement For Year 2 Sales revenue Manufacturing costs: Materials Variable cash costs Fixed cash costs Depreciation (fixed) All depreciation charges are fixed. Manufacturing depreciation is expected to increase by 10 percent in year 2. Marketing and administrative depreciation are expected to remain the same for year 2. Sales volume is expected to increase by 5 percent, but prices are expected to fall by 10 percent. Materials costs per unit are expected to decrease by 8 percent. Unit variable cash manufacturing costs are expected to increase by 15 percent. Fixed cash costs are expected to…arrow_forward
- Budget Performance Report for a Cost CenterThe Eastern District of Adelson Inc. is organized as a cost center. The budget for the Eastern District of Adelson Inc. for themonth ended December 31 is as follows:Sales salaries $819,840System administration salaries 448,152Customer service salaries 152,600Billing salaries 98,760Maintenance 271,104Depreciation of plant and equipment 92,232Insurance and property taxes 41,280Total $1,923,968During December, the costs incurred in the Eastern District were as follows:Sales salaries $818,880System administration salaries 447,720Customer service salaries 183,120Billing salaries 98,100Maintenance 273,000Depreciation of plant and equipment 92,232Insurance and property taxes 41,400Total $1,954,452Required:1. Prepare a budget performance report for the manager of the Eastern District of Adelson for the month of December.Enter all amounts as positive numbers. If an amount box does not require an entry, leave it blank, or enter zero "0".arrow_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_forwardThe controller of Emery, Inc. has computed quality costs as a percentage of sales for the past 5 years (20X1 was the first year the company implemented a quality improvement program). This information is as follows: Required: 1. Prepare a trend graph for total quality costs. Comment on what the graph has to say about the success of the quality improvement program. 2. Prepare a graph that shows the trend for each quality cost category. What does the graph have to say about the success of the quality improvement program? Does this graph supply more insight than the total cost trend graph does? 3. Prepare a graph that compares the trend in relative control costs versus relative failure costs. Comment on the significance of this trend.arrow_forward
- Howard Cooper, the president of Finch Computer Services, needs your help. He wonders about the potential effects on the firm's net income if he changes the service rate that the firm charges its customers. The following basic data pertain to fiscal Year 1: Standard rate and variable costs Service rate per hour Labor cost Overhead cost Selling, general, and administrative cost. Expected fixed costs Facility maintenance Selling, general, and administrative Required: a. Prepare the pro forma income statement that would appear in the master budget if the firm expects to provide 28,000 hours of services in Year 1. b. A marketing consultant suggests to Mr. Cooper that the service rate may affect the number of service hours that the firm can achieve. According to the consultant's analysis, if Finch charges customers $57 per hour, the firm can achieve 31,000 hours of services. Prepare a flexible budget using the consultant's assumption. c. The same consultant also suggests that if the firm…arrow_forwardAs a newly hired management accountant, you have been asked to prepare a profit plan for the company for which you work. As part of this task, you've been asked to do some what-if analyses. Following is the budgeted Information regarding the coming year: Selling price per unit Variable cost per unit Fixed costs (per year) Required: $ 100.00 60.00 1,113,040 1. What is the breakeven volume, in units and dollars, for the coming year? 2. Assume that the goal of the company is to earn a pretax (operating) profit of $316,000 for the coming year. How many units would the company have to sell to achieve this goal? 3. Assume that of the $60 variable cost per unit the labor-cost component is $27. Current negotiations with the employees of the company indicate some uncertainty regarding the labor cost component of the variable cost figure presented above. What is the effect on the breakeven point in units if selling price and fixed costs are as planned, but the labor cost for the coming year is…arrow_forwardPrepare a complete projected income statement in the contribution format for each scenario, in the manner of a flexible budget. Please show work Carolina Manufacturing Company has been operating at a loss for several years. A management team has assembled to determine what course of action to take next year to reach profitability. They begin by reviewing the most recent income statement (below). Carolina Manufacturing Company Income Statement For the Year Ended December 31 Sales (45,000 units at $15) Less cost of goods sold: Net loss Direct materials Direct labor Manufacturing overhea Gross margin Less operating expenses Selling expenses Variable Sales commissions Shipping 135,000 117,450 147,750 Fixed (advertising, salaries) Administrative expenses Variable (billing and other) Fixed (salaries and other) 40,500 8,100 180,000 $675,000 400,200 274,800 228,600 2,700 72,000 74,700 ($28,500)arrow_forward
- Hudson Community College enrolls students in two departments, Liberal Arts and Sciences. The college also has two service departments, the Library and the Computing Services Department. The usage of these two service departments' output for the year is as follows: User of Service Library Computing Services Liberal Arts Sciences Library Computing Services Provider of Service Computing Library Services 10% The budgeted costs in the two service departments for the year are as follows: Provider of Service 60% 40% Library Computing Services Total $700,000 270,000 Required: 1. Use the direct method to allocate the budgeted costs of the Library and Computing Services Department to the college's Liberal Arts and Sciences departments. (Do not round intermediate calculations.) 20% 70% Liberal Arts Sciencesarrow_forwardAkagera Finance Plc has two service departments, the Human Resources (HR) Department and the Computing Department. Akagera Finance Plc has two other departments that directly service customers, the Deposit Department and the Loan Department. The usage of the two service departments’ output for the year is as follows: User of Service Provider of Service HR Computing HR 0 10% Computing 10% 0 Deposit 55% 50% Loan 35% 40% The budgeted costs in the two service departments for the year are as follows: HR $ 529,000 Computing 758,500 Required: Use the reciprocal-services method to allocate the budgeted costs of the HR and Computing departments to the Deposit and Loan departmentsarrow_forwardHudson Community College enrolls students in two departments, Liberal Arts and Sciences. The college also has two service departments, the Library and the Computing Services Department. The usage of these two service departments' output for the year is as follows: User of Service Library Computing Services Liberal Arts Sciences Provider of Service Computing Services 20% Library Computing Services Library 65% 35% The budgeted costs in the two service departments for the year are as follows: $1,090,000 550,000 30% 50% Required: 1. Use the step-down method to allocate Hudson Community College's service department costs to the Liberal Arts and Sciences departments. (Do not round intermediate calculations.) Allocation of Computing Service costs Allocation of Library costs Total costs allocated to each department Liberal Arts Sciencesarrow_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 Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Why do we need accounting?; Author: EconClips;https://www.youtube.com/watch?v=weCXE2wIl90;License: Standard Youtube License