Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 10, Problem 10.32BE
To determine
To prepare: The segment margin performance report for the pharmaceutical segment.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Learning Objective 2
Product Costs and Product Profitability Reports, using a Single Plantwide Factory Overhead Rate
Isaac Engines Inc. produces three products-pistons, valves, and cams-for the heavy equipment
industry. Isaac Engines has a very simple production process and product line and uses a single
plantwide factory overhead rate to allocate overhead to the three products. The factory overhead
rate is based on direct labor hours. Information about the three products for 20Y2 is as follows:
Pistons
Valves
Cams
Budgeted
Volume
(Units)
6,000
13,000
1,000
Pistons
Direct Labor
Hours Per Unit
Valves
Cams
If required, round all per unit answers to the nearest cent.
a. Determine the plantwide factory overhead rate.
$
28 ✔per dlh
0.30
0.50
0.10
0.3 ✔ dlh
The estimated direct labor rate is $20 per direct labor hour. Beginning and ending inventories are
negligible and are, thus, assumed to be zero. The budgeted factory overhead for Isaac Engines is
$235,200.
0.5 dlh
0.1 ✓dlh
Price Per
Unit…
Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method
Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution
format income statement.
Budgeted information for Quarter 1 of 2024:
Sales in units
Sales price per unit
After analyzing expenses, the company has determined the following cost patterns.
Cost of Goods Sold (per unit)
Sales Commissions (per dollar of sales).
Administrative Salaries (per quarter)
Rent Expense (per quarter)
Depreciation Expense (per quarter)
Shipping has been determined to be a mixed cost with the following total costs and units:
2022
Quarter 1
Quarter 2
Quarter 3
Quarter 4
2023
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Total Cost
$ 67,000
$ 94,000
$ 89,800
$ 92,600
$ 72,500
$80,000
$ 84,000
$ 100,000
17,000
$ 48.00
Units
12,500
21,000
13,800
20,000
13,700
14,000
14,300
22,500
$29.00
9.50€
$ 45,000
$ 27,000
$ 36,000
Required:
Use the data to answer the…
In Organizational Development (OD), each area of OD has its own budget to maintain. Please create a
spreadsheet indicating the following purchases for the different OD areas and the remaining balance for
each department based on the beginning budget and purchases as indicated.
The Center for the Advancement of Teaching
and Learning
Beginning Budget $60,000
Speaker
Books
Speaker Gifts
$2,000
100 @ $22.50 each
$200.00
Leadership Development
Beginning Budget $40,000
Retreat Location Rental
Retreat Lunch
Conference
Awards
$8,000
$11.00 each for 72
attendees
$9,000
$8,800
Creative and Strategic Initiatives
Beginning Budget $25,000
Camera
Software
Digital subscriptions
$7,000
$2,000
$550.00
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
- Johnston Bookstore is the bookstore on campus for students and faculty. The bookstore E9-18A Sales budget for a retail organization (Learning Objective 2) shows the following sales projections in units by quarter for the upcoming year School Supplies Apparel Miscellaneous Quarter Books 1,570 200 580 690 1st. ..... 2nd 800 190 330 540 3rd 1,790 240 880 890 4th 670 180 540 440 The average price of an item in each of the departments is as follows: Average sales price per unit Books.. $85 School supplies Apparel.. Miscellaneous. $18 $29 $ 6 Requirement Prepare a sales budget for the upcoming year by quarter for the Johnston Bookstore, with sales categorized by the four product groupings (books, school supplies, apparel, and miscellaneous).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_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_forward
- ing price of $26 per case. The following information relates to the budget for Main Street a flexible budget performance report (Learning Objective 5) Main Street Muffins sells its muffins to restaurants and coffee houses for an average sell- Muffins for this year (all figures are annual totals unless otherwise noted): Performance Evaluation 629 E10-26A Prepare Budgeted sales in cases 9,100 cases Packaging cost per case. %24 Shipping expense per case Sales commission expense. 2 5% of sales price Salaries expense.. $6,500 Office rent $3,900 Depreciation. $2,500 Insurance expense... $1,800 $ 900 Office supplies expense. During the year, Main Street Muffins actually sold 9,500 cases, resulting in total sales rev- enue of $255,200. Actual expenses (in total) from this year are as follows: Packaging cost. $ 10,600 $ 19,500 $ 12,760 $ 7,300 Shipping expense.. Sales commission expense. Salaries expense... $ 3,900 $ 2,500 $ 1,600 Office rent Depreciation. Insurance expense.. $ 1,600 Office…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: 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_forwardLackawanna Community College has three divisions: Liberal Arts, Sciences, and Business Administration. The college's comptroller is trying to decide how to allocate the costs of the Admissions Department, the Registrar's Department, and the Computer Services Department. The comptroller has compiled the following data for the year just ended. Department Admissions Registrar Computer Services Division Liberal Arts Annual Cost $136,000 233,000 492,000 Sciences Business Administration Budgeted Budgeted Enrollment Credit Hours 2,900 1,750 1,650 49,000 42,250 36,250 Required: 1. Distribute the departmental costs to the college's three divisions based on the allocation base given. 2. Choose the better allocation base for distributing the cost to the following departments: Department and Allocation Base Planned Courses Requiring Computer Work Complete this question by entering your answers in the tabs below. Admissions (enrollment) Registrar (credit hours) Computer Services (courses requiring…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_forwardHoward 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…arrow_forwardBE2.12 - Using Excel to Calculate Gross Margin and Revenue PROBLEM Bugsy provided the following operating information during the current year. Operating income Selling, general, and administrative costs Cost of goods sold $ 185,000 42,000 77,500 Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. What was Bugsy's gross margin this year? Gross margin What was its total revenue this year? Total revenuearrow_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 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_forwardLearning Objective 4 Wiki Wiki Company has determined that the variable overhead rate is $4.50 per direct labor hour in the Fabrication Department. The normal production capacity for the Fabrication Department is 10,000 hours for the month. Fixed costs are budgeted at $60,000 for the month. a. Prepare a monthly factory overhead flexible budget for 9,000, 10,000, and 11,000 hours of production. Enter all amounts as positive numbers. Wiki Wiki Company Monthly Factory Overhead Cost Budget-Fabrication Department Direct labor hours Variable factory overhead cost Fixed factory overhead cost Total factory overhead cost 9,000 $ $ 10,000 $ $ 11,000 b. How much overhead would be applied to production if 9,000 hours were used in the department during the month? If required, round your calculations to two decimal places and your final answer to the nearest dollar.arrow_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 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_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Why do we need accounting?; Author: EconClips;https://www.youtube.com/watch?v=weCXE2wIl90;License: Standard Youtube License