Horngren's Accounting, Student Value Edition (12th Edition)
12th Edition
ISBN: 9780134487151
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.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 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…
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…
Learning 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…
Chapter 23 Solutions
Horngren's Accounting, Student Value Edition (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
- 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_forwardProfessional foes earned budget for a service company LundquistFret well. CPAs, offer three types of services to clents: auditing, tax, and small business accounting. Based on experience and projected growth, the following billable hours have been estimated for the year ending May 31. 20Y8: The average billing rate for staff is 140 per hour, and the average billing rate for partners is 450 per hour. Prepare a professional fees earned budget for Lundquist Fretwell, CPAs, for theyear ending May 31, 20Y8, using the following column headings and showing the estimated professional fees by type of service rendered:arrow_forwardTask 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_forward
- an 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_forwardCreat an initial budget sheet showing the sistribution of $100,000 use the example's format on EXCEL.arrow_forwardQUESTION 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_forward
- BUDGETING 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_forwardProblem 4: PERT Cost A project requires these activities to be completed and the table below shows the expected time and budgeted cost for each activity. The complete budget using ES times. Suppose the project is on its 10th week. Using this information, determine if the project is on track given that: Activity A is 100% done with a cost of $1,800 Activity B is 100% done with a cost of $6,000 Activity C is 80% done with a cost of $6,000 Activity D is 100% done with a cost of $8,500 Activities E and F have not been started Your assessment of the project including a recommended strategy on the next steps.arrow_forwardSales and Production Budgets Ultimate Audio Company manufactures two models of speakers, U500 and S1000. Based on the following production and sales data for June. U500 S1000 Estimated inventory (units), June 1 262 71 Desired inventory (units), June 30 301 62 Expected sales volume (units): Northeast Region 2,950 3,300 Southwest Region 5,650 4,900 Unit sales price $135 $215 a. Prepare a sales budget. all mounts posi numbers. ULTIMATE AUDIO COMPANY Sales Budget For the Month Ending June 30 Product and Area Unit Sales Volume Unit Sales Price Total Sales Model U500: Northeast Region Southwest Region Total Next Check My Work Sign.outarrow_forward
- Please answer with steps explanation computation for each steps answer in textarrow_forwardRequired information Use the following information for the Quick Study below. [The following information applies to the questions displayed below.] Brodrick Company expects to produce 21,200 units for the year ending December 31. A flexible budget for 21,200 units of production reflects sales of $466,400; variable costs of $63,600; and fixed costs of $142,000. QS 23-4 Flexible budget performance report LO P1 Assume that actual sales for the year are $551,800 (26,900 units), actual variable costs for the year are $113,900, and actual fixed costs for the year are $135,000. Prepare a flexible budget performance report for the year. BRODRICK COMPANY Flexible Budget Performance Report For Year Ended December 31 Favorable/ Unfavorable Flexible Budget Actual Results Variances Contribution margin 2$ 0 $arrow_forwardManagement Accounting Course Project – Part 1, B Group The Terranova Company is preparing information to complete its master budget for the quarter ending December 31, 2020. The company intends to make unit sales in the related months as follows: September 5,000 October 9,750 November 11,700 December 14,625 Units are to be sold for $10 each. Sales are 60% for cash and 40% on credit. Credit sales are collected in the month following the sale. *Required: 1) Prepare a sales budget for Terranova for the quarter ending December 31, 2020. Show activity by month and in total. (Hint: a quarter = 3 months.) 2) Complete a schedule of expected cash collections for the quarter ending December 31, 2020. Show activity by month and in total.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 Pub
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Cornerstones 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