Horngren's Accounting (12th Edition)
12th Edition
ISBN: 9780134486444
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 23, Problem E23.16E
Preparing a flexible budget performance report Learning Objective 1
Murphy Company managers received the following incomplete performance report;
| MURPHY COMPANY Flexible Budget Performance Report For the Year Ended July 31,2018 |
|||||
| Actual Results | Flexible |
Flexible Budget | Sales Volume Variance | Static Budget | |
| Units | 35,000 | (a) |
35,000 | 5,000 F | (g) |
| Sales Revenue | $ 219,000 | (b) |
$ 219,000 | $ 27,000 F | (h) |
| Variable Expenses | 85,000 | (c) |
84,000 | 13,000 U | (i) |
| Contribution Margin | 134,000 | (d) |
135,000 | 14,000 F | (j) |
| Fixed Expenses | 105,000 | (e) |
100,000 | 0 | (k) |
| Operating Income | $ 29,000 | (f) |
$ 35,000 | $ 14,000 F | (l) |
Complete the performance report. Identify the employee group that may deserve praise and the group that may be subject to criticism. Give your reasoning.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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…
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…
a) Why do successful companies tend to use the bottom-up approach to establish a master budget?
b) Green Tea’s data show the following information for the financial year, beginning July 2020:
July
Aug.
Sept.
Oct.
Nov.
Estimated sales (units)
25,000
25,000
27,000
27,500
28,000
Sales price per unit
$31
$31
$31
$31
$31
Direct labour per unit
$1.75
$1.75
$1.50
$1.50
$1.50
Labour rate per hour
$21
$21
$24
$24
$24
New machinery will be added in September. This machine will reduce the labour required per unit and increase the labour rate for those employees qualified to operate the machinery.
Finished goods inventory is required to be 20% of the next month’s requirements. Direct material requires 2.5 kg per unit at a cost of $5 per kg. The ending inventory required for direct materials is 20% of the next month’s needs. In July, the beginning inventory is 3,750 units of finished goods and 13,125 kg of…
Chapter 23 Solutions
Horngren's Accounting (12th Edition)
Ch. 23 - Prob. 1QCCh. 23 - MajorNet Systems is a start-up company that makes...Ch. 23 - MajorNet Systems is a start-up company that makes...Ch. 23 - MajorNet Systems is a start-up company that makes...Ch. 23 - MajorNet Systems has budgeted three hours of...Ch. 23 - MajorNet Systems has budgeted three hours of...Ch. 23 - FrontGrade Systems allocates manufacturing...Ch. 23 - FrontGrade Systems allocates manufacturing...Ch. 23 - FrontGrade Systems allocates manufacturing...Ch. 23 - The person probably most responsible for the...
Ch. 23 - HajorNet System’s static budget predicted...Ch. 23 - What is a variance?Ch. 23 - Explain the difference between a favorable and an...Ch. 23 - What is a static budget performance report?Ch. 23 - How do flexible budgets differ from static...Ch. 23 - How is a flexible budget used?Ch. 23 - What are the two components of the static budget...Ch. 23 - What is a flexible budget performance report?Ch. 23 - What is a standard cost system?Ch. 23 - Explain the difference between a cost standard and...Ch. 23 - Give the general formulas for determining cost and...Ch. 23 - How does the static budget affect cost and...Ch. 23 - List the direct materials variances, and briefly...Ch. 23 - List the direct labor variances, and briefly...Ch. 23 - List the variable overhead variances, and briefly...Ch. 23 - List the fixed overhead variances, and briefly...Ch. 23 - How is the fixed overhead volume variance...Ch. 23 - What is management by exception?Ch. 23 - List the eight product variances and the manager...Ch. 23 - Briefly describe how journal entries differ in a...Ch. 23 - What is a standard cost income statement?Ch. 23 - Matching terms Learning Objective 1 Match each...Ch. 23 - Preparing flexible budgets Learning Objective 1...Ch. 23 - Calculating flexible budget variances Learning...Ch. 23 - Matching terms Learning Objective 2 Match each...Ch. 23 - Identifying the benefits of standard costs...Ch. 23 - Calculating materials variances Learning Objective...Ch. 23 - Calculating labor variances Learning Objective 3...Ch. 23 - Interpreting material and labor variances Learning...Ch. 23 - Computing standard overhead allocation rates...Ch. 23 - Computing overhead variances Learning Objective 4...Ch. 23 - Understanding variance relationships Learning...Ch. 23 - Journalizing materials entries Learning Objectives...Ch. 23 - Journalizing labor entries Learning Objectives 6...Ch. 23 - Preparing a standard cost income statement...Ch. 23 - Preparing a flexible budget Learning Objective 1...Ch. 23 - Preparing a flexible budget performance report...Ch. 23 - Preparing a flexible budget performance report...Ch. 23 - Defining the benefits of setting cost standards...Ch. 23 - Calculating materials and labor variances Learning...Ch. 23 - Computing overhead variances Learning Objective 4...Ch. 23 - Calculating overhead variances Learning Objective...Ch. 23 - Preparing a standard cost income statement...Ch. 23 - Preparing journal entries Learning Objective 6 MOH...Ch. 23 - Preparing a standard cost income statement...Ch. 23 - Preparing a flexible budget performance report...Ch. 23 - Preparing a flexible budget computing standard...Ch. 23 - Computing standard cost variances and reporting to...Ch. 23 - Computing and journalizing standard cost variances...Ch. 23 - Prob. P23.29APGACh. 23 - Preparing a flexible budget performance report...Ch. 23 - Preparing a flexible budget and computing standard...Ch. 23 - Prob. P23.32BPGBCh. 23 - Prob. P23.33BPGBCh. 23 - Preparing a standard cost income statement...Ch. 23 - Prob. P23.35CTCh. 23 - Preparing a flexible budget and performance report...Ch. 23 - Prob. 23.1TIATCCh. 23 - Decision Case 23-1 Suppose you manage the local...Ch. 23 - Fraud Case 23-1 Drew Castello, general manager of...
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
- Question 3 a) Why do successful companies tend to use the bottom-up approach to establish a master budget? b) Green Tea's data show the following information for the financial year, beginning July 2020: July Aug. Sept. Oct. Nov. Estimated sales (units) 25,000 25,000 27,000 27,500 28,000 Sales price per unit $31 $31 $31 $31 $31 Direct labour per unit $1.75 $1.75 $1.50 $1.50 $1.50 Labour rate per hour $21 $21 $24 $24 $24 New machinery will be added in September. This machine will reduce the labour required per unit and increase the labour rate for those employees qualified to operate the machinery. Finished goods inventory is required to be 20% of the next month's requirements. Direct material requires 2.5 kg per unit at a cost of $5 per kg. The ending inventory required for direct materials is 20% of the next month's needs. In July, the beginning inventory is 3,750 units of finished goods and 13,125 kg of materials. Required: i) Prepare a production budget for the first quarter of the…arrow_forwardE9-26A Budgeted income statement (Learning Objective 2) Delta Labs performs a specialty lab test for local companies for $45 per test. For the upcoming quarter, Delta Labs is projecting the following sales: January February March Number of lab tests 5,600 4,900 5,700 The budgeted cost of performing each test is $21. Operating expenses are projected to be $59,000 in January, $57,000 in February, and $58,000 in March. Delta Labs is subject to a corporate tax rate of 30%. Requirement Prepare a budgeted income statement for the first quarter, with a column for each month and for the quarter.arrow_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
- 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.00arrow_forwardPreparing a performance report Use the flexible budget prepared in P7-6 for the 29,000-unit level of activity and the actual operating results listed below for the 29,000- unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 29,000 units differs from the master budget operating income at 30,000 units in Figure 7-12. 3. Given the level at which the company operated, how was its cost control? Item Direct materials: Direct labor:arrow_forwardPerformance Report Based on Budgeted and Actual Levels of Production Bowling Company budgeted the following amounts: At the end of the year, Bowling had the following actual costs for production of 3,800 units: Required: 1. Calculate the budgeted amounts for each cost category listed above for the 4,000 budgeted units. 2. Prepare a performance report using a budget based on expected production of 4,000 units. 3. Prepare a performance report using a budget based on the actual level of production of 3,800 units.arrow_forward
- BUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)Ronstadt Limited’s budget for the four months from January to April includes the following data:1. MonthSalesMaterialsWagesOverheads $000$000$000$000January615115.030360February636120.033390March690135.036420April684130.040425 2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.5. One-half of the overhead expenditure is paid in the month in…arrow_forwardHoward 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_forwardView Policies Current Attempt in Progress Avalon, Inc's static budget shows $40,500 budgeted for direct materials, $54,000 budgeted for direct labor, and $13,500 budgeted for overhead. Avalon's actual direct materials were $42,000, actual direct labor was $51,000, and actual overhead was $13,800. What is the total difference between the static budget and actual, and is the difference favorable or unfavorable? O $4,800, unfavorable O $1,200, favorable O $1,200, unfavorable O $4,800, favorable Save for Later Attempts: 0 of 1 used Submit Answerarrow_forward
- Question Content Area Given the following information, determine the activity rate (rounded to the nearest cent) for setups. Activity Total Activity-Base Usage Budgeted Activity Cost Setups 10,000 $57,200 Inspections 23,400 $149,700 Assembly (dlh) 73,800 $394,500 a. $5.61 b. $5.35 c. $6.40 d. $5.72arrow_forwardIntegrated 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…arrow_forwardPlease prepare a consolidated budget pivot table in Excel by budget class and year. Please upload your excel document. Budget Class – Staff Costs • Salary of the Project Manager @ USD 5,000 per month. • Salary of the Admin Finance Officer @ USD 3,500 per month. • Salary of Admin. & Finance Assistant @USD 1,000 per month • Salary of Driver @USD 500 per month Budget Class – Equipment & Furniture Cost of the office equipment and furniture required for the project is USD 30,000 for three years to be procured during the 1st year of the project. Budget Class – Operating Costs (training) Two trainers are required for each training. Each training lasts for 5 days. The total number of participants for each training is 30. • DSA/ ticket cost of each participant @ USD1, 000 per training. • Total number of 5-day trainings planned for each year is 4. • Fee for Trainer @ USD 2,000 per training. • Cost of logistic arrangements for each training @ USD 10,000. In addition to the main direct…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 Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher: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
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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