Horngren's Accounting: The Managerial Chapters (12th Edition) (loose Leaf Version)
12th Edition
ISBN: 9780134486826
Author: MILLER-NOBLES, Tracie L.; Mattison, Brenda L.; Matsumura, Ella Mae
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 23, Problem E23.17E
Preparing a flexible budget performance report
Learning Objective 1
Flex. Bud. Var. for Op. Inc. $31,040 F
Top managers of Marshall Industries predicted 2018 sales of 14,800 units of Is product at a unit price of $9.50. Actual sales for the year were 14,600 units at $12.00 each. Variable costs were budgeted at $2.00 per unit, and actual variable costs were $2.10 per unit Actual fixed costs of $48,000 exceeded budgeted fixed costs by $4,000.
Prepare Marshalls flexible budget performance report. What variance contributed most to the year's favorable results? What caused this variance?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents 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…
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…
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…
Chapter 23 Solutions
Horngren's Accounting: The Managerial Chapters (12th Edition) (loose Leaf Version)
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
- Use the following information for Exercises 9-50 and 9-51: Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for 475, and the S12L5 sells for 300. Projected sales (number of speakers) for the coming 5 quarters are as follows: The vice president of sales believes that the projected sales are realistic and can be achieved by the company. Exercise 9-50 Sales Budget Refer to the information regarding Stillwater Designs above. Required: 1. Prepare a sales budget for each quarter of 20X1 and for the year in total. Show sales by product and in total for each time period. 2. CONCEPTUAL CONNECTION How will Stillwater Designs use this sales budget?arrow_forwardLearning Curve Sharon Glessing, controller for Janson Company, has noticed that the company faces a 80 percent learning rate for its specialty design line. In planning the cost of the latest design, Sharon assumed that the first set of units would take 1,200 direct labor hours. She decided to use this information in budgeting for the cost of the total project, which would involve the manufacture of 16 sets. Direct labor is paid $40 per hour. Required: 1. Complete the table below showing results by row for total production of: one unit, two units, four units, eight units, and sixteen units. (Round hour answers to two significant digits.) (Round Cumulative Total Time answers to the nearest whole number.) Cumulative Number of Units Cumulative Average Time per Unit in Hours 1,200 ✓ 960 ✓ 768 ✔ 614.4 ✔ 492 X 2. What is the total labor cost if Janson Company makes eight sets? Sixteen sets? (Use the rounded answers in the subsequent computations). Total labor cost for eight sets Total labor…arrow_forwardAccounting Please solve it ASAP with all requirements Q.7. Toews Ltd has prepared the following flexible budget for the coming year. The Budgeted level of activity is 7,500 units. £ Sales 250,000 Direct material 75,000 Direct labour 60,000 Variable overheads 30,000 Fixed overheads 45,000 Profit 22,500 lf the budget is flexed to a level of activity of 10,000 units, what would the total budgeted cost be? a) £280,000 b) £265,000 c) £123,750 d) £168,750arrow_forward
- Preparing a flexible budget and performance report This continues the Piedmont Computer Company situation from Chapter 22. Assume Piedmont Computer Company has created a standard cost card for the PCC model tablet computer, with overhead allocated based on direct labor hours: During the month of September, Piedmont Computer Company incurred the following costs while manufacturing 1,100 PCC model tablets; Requirements Prepare a flexible budget for September for 900, 1,000, and 1,100 PCC model tablets. The tablet has a standard sales price of $675. List variable costs separately. Using 1,000 PCC model tablets for the static budget, prepare a flexible budget performance report for September. Total sales revenue for the month was $767,800. The company sold 1,100 tablets. What insights can the management of Piedmont Computer Company draw from the performance report?arrow_forwardQuestion 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_forwardPreparing a flexible budget performance report Top managers of Marshall Industries predicted 2018 sales of 14,800 units of its product at a unit price of $9.50. Actual sales for the year were 14,600 units at $12.00 each. Variable costs were budgeted at $2.00 per unit, and actual variable costs were $2.10 per unit. Actual fixed costs of $48,000 exceeded budgeted fixed costs by $4,000. Prepare Marshall’s flexible budget performance report. W/hat variance contributed most to the year’s favorable results? What caused this variance?arrow_forward
- Task 1 Pedro Sdn Bhd. manufactures and sells two cookware products in a single plant. The new manager wants to have quarterly budgets and has prepared the following information for the first quarter of 2021. The following information is available: Budgeted sales: Product A …….60,000 units @RM100 each Product B …….40,000 units @RM125 each Budgeted inventories: Beginning Ending Product A Product B Direct material (Metal) Direct material (Plastic) Direct material (Handles) 20,000 8,000 32,000 kg 29,000 kg 6,000 units 25,000 10,000 36,000 kg 32,000 kg 7,000 units Standard variable costs: Product A Product B Direct materials: Metal Plastic Handles Total materials 5kg @RM8.00 3kg@RM5.00 1 unit @RM3.00 RM40.00 15.00 3.00 58.00 4kg @RM8.00 3kg@RM5.00 RM32.00 15.00 47.00 Direct labour Variable manufacturing overhead Total 2hours@RM12.00 2hours@RM1.50 24.00 3.00 85.00 3hours@RM16.00 3hours@RM1.50 48.00 4.50…arrow_forwardan be repaid as planned? Explain. pd. 20,000 to start each Problem 6 (Flexible Budget) Factory Overhead Flexible Budget Preparation Summary flexible overhead budgets are to be prepared for two departments of Summer Machine Company. Budget data follows: Department 1 Manufacturing overhead varies at the rate of P6.50 for each machine hour. and the fixed manufacturing overhead is budgeted for the year at P300,000. At normal capacity, the department should operate at 200,000 machine hours. Department 2 Manufacturing overhead varies at the rate of P7.00 for each direct labor hour, and the fixed manufacturing overhead is budgeted for the year at P500,000. At normal capacity, the department should operate at 400,000 machine hours. One direct labor is equal to two machine hours. Required: Prepare in summary form a flexible budget for each department showing costs at normal capacity, at 90, 80, 70, and 60 percent of normal capacity.arrow_forwarda) 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…arrow_forward
- QUESTION 1 New Norm Fashion produces washable face mask shield. The following budgeted/ actual information is provided regardingto the production of face mask: RM/unit Selling price 50.00 Direct materials 8.00 Direct labour 5.00 Variable production overheads 3.00 Details of its operations for the month of May and June 2021 are as follows: May June Production 500 380 Sales 300 500 Fixed production overheads are budgeted at RM4,000 per month and are absorbed on a unit basis. The normal level of production is budgeted at 400 units per month. Other costs: RM/month Fixed selling 4,000 Fixed administration 2,000 Variable sales commission 5% of sales revenue There was no opening inventory of face mask at the beginning of May. Required: (a) Prepare income statement for the month of May and June using (i) variable costing (ii) absorption costing (b) Prepare a reconciliation of profit or loss figures based on your answers in a(i) and (c)Describe a situation where net profit under variable…arrow_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_forwardBUDGETING A BUSINESS SCENARIO - STEP 5 FIXED COST BUDGET Fixed costs budget will be different for every organization and will depend upon what sort of resources are consumed by each entity.. Budg expects her fixed costs and her capital expenditure for the next three months to be as follows: ● ● ● Rent on the new workshop of $3,000 will be paid in January to cover the months of January, February and March. New machinery and tools will cost $15,000 and will be delivered and paid for in January. These new non-current assets will have an expected useful life of five years and should be depreciated on the straight line basis. She anticipates that she will receive and pay an electricity bill in March covering the period 1 January to 15 March. She expects that this bill will be for around $1,500. Budg estimates that the new workshop will use a further $300 of electricity between 16th and 31st March. Each month of operation should be allocated an equal amount of electricity cost. An invoice…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher: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
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