MyLab Accounting with Pearson eText -- Access Card -- for Horngren's Accounting, The Financial Chapters
12th Edition
ISBN: 9780134490397
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
Sanchez Corporation manufactures tables for schools. The 2023 operating budget is based on sales of 100,000 units at $500 per table. Budgeted variable costs are $350 per unit, while fixed costs total $6,000,000.
For 2023, actual sales were 110,000 units at $490 each. Actual variable costs were $360 per unit and fixed costs totaled $5,800,000.
Required:
a) Prepare a report showing actual results, a static budget and a flexible budget.
b) Explain the significance of a flexible budget versus a static budget.
Please 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…
Completing a comprehensive budgeting problem—manufacturing company
The Gerard Tire Company, manufactures racing tires for bicycles. Gerard sells tires for $90 each. Gerard is planning for the next year by developing a master budget by quarters. Gerard’s balance sheet for December 31, 2018, follows:
Other data for Gerard Tire Company:
Budgeted sales are 1,500 tires for the first quarter and expected to increase by 200 tires per quarter. Cash sales are expected to be 10% of total sales, with the remaining 90% of sales on account.
Finished Goods Inventory on December 31, 2018, consists of 300 tires at $33 each.
Desired ending Finished Goods Inventory is 30% of the next quarter’s sales; first quarter sales for 2020 are expected to be 2,300 tires. FIFO inventory costing method is used.
Raw Materials Inventory on December 31, 2018, consists of 600 pounds of rubber compound used to manufacture the tires.
Direct materials requirements are 2 pounds of a rubber compound per tire. The cost of…
Chapter 23 Solutions
MyLab Accounting with Pearson eText -- Access Card -- for Horngren's Accounting, The Financial Chapters
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
- Preparing a performance report Use the flexible budget prepared in P7-6 for the 31,000-unit level and the actual operating results listed below for the 31,000-unit level. Required: 1. Prepare a performance report. 2. List the major reasons why the actual operating income at 31,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_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_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
- this is actually a budgeting lesson. Beginning inventory 4.000 unit Ending inventory 3.500 unit The lack will be allocated to the 5 months (Jan, Feb, March, April dan May). Arrange production budget with a policy that accentuate production stability!arrow_forwardeBook Show Me How Question Content Area Budget Performance Reports for Cost Centers Partially completed budget performance reports for Delmar Company, a manufacturer of light duty motors, follow: Delmar CompanyBudget Performance Report—Vice President, ProductionFor the Month Ended June 30 Plant Actual Budget OverBudget (Under)Budget Eastern Region $561,500 $561,500 $0 Central Region 400,300 404,300 (4,000) Western Region (g) (h) (i) $(j) $(k) $(l) $(4,000) Delmar CompanyBudget Performance Report—Manager, Western Region PlantFor the Month Ended June 30 Department Actual Budget OverBudget (Under)Budget Chip Fabrication $(a) $(b) $(c) Electronic Assembly 72,400 71,470 930 Final Assembly 114,150 115,070 $(920) $(d) $(e) $(f) $(920) Delmar CompanyBudget Performance Report—Supervisor, Chip FabricationFor the Month Ended June 30 Cost Actual…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_forward
- eBook Question Content Area Before the year began, the following static budget was developed for the estimated sales of 100,000. Sales are sluggish and management needs to revise its budget. Use this information to prepare a flexible budget for 80,000 and 90,000 units of sales. blankblankFlexible Budget blank 100,000 80,000 90,000 Sales $3,710,000 $fill in the blank 1 $fill in the blank 2 Cost of Goods Sold Direct Material $900,000 $fill in the blank 3 $fill in the blank 4 Direct Labor 1,100,000 fill in the blank 5 fill in the blank 6 Variable Manufacturing Overhead 260,000 fill in the blank 7 fill in the blank 8 Fixed Manufacturing Overhead 70,000 fill in the blank 9 fill in the blank 10 Cost of Goods Sold $2,330,000 $fill in the blank 11 $fill in the blank 12 Gross Profit $1,380,000 $fill in the blank 13 $fill in the blank 14 Variable Sales and Administrative Expenses 200,000 fill in the blank 15 fill in the blank 16 Fixed Sales and Administrative…arrow_forwardPrepare a 12-month Master Budget for a company of your choosing. It can be a company that you are closely connect too or one randomly selected. COMPLETED IN EXCEL. As you are preparing the Master Budget, some information is NOT provided. You are required to decide or predict or forecast this information. Provide an introduction for the company you have chosen. The introduction should include the following: Name of company Location of company Name of owner Nature of the business. Type of product Fiscal period For the company that you have selected - Prepare a 12-month Master Budget. Your submission must show each month’s activities. Here are some considerations to include in preparing the budget: You must forecast your sales, purchases, direct labour and manufacturing overhead for each month and any other information as required All sales are on accounts Expected collections are to be 50% in the month of the sale, 30 % in the first month following the sale, and 20% in the second…arrow_forwardFlexible Budgeting At the beginning of the period, the Fabricating Department budgeted direct labor of $9,280 and equipment depreciation of $2,300 for 640 hours of production. The department actually completed 600 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting. Round your labor rate to nearest cent.$arrow_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_forwardPractice : (see attachemnt) please address parts B, C, D please show any calculations for reference a) What is meant by the term flexible budget? What role do flexible budgets play in evaluating performance? The cost accountant for Bradley, Inc., prepared the following monthly performance report relating to the Finishing Department: Budgeted Production Actual Production number units: 6000 units 6500 units Direct materials: $90,000 $99,600 Direct labor: $48,000 $55,200 Variable Manufacturing Overhead: $6,000 $9,000 Fixed Manufacturing Overhead: $66,000 $64,200 What would the flexible budget amounts be for each of the following: Direct materials Direct labor Variable manufacturing overhead Compute the…arrow_forward(Learning Objective 5: Use the COGS model to make management decisions)Spicer Industries prepares budgets to help manage the company. Spicer is budgeting forthe fiscal year ended January 31, 2018. During the preceding year ended January 31, 2017,sales totaled $9,700 million and cost of goods sold was $6,400 million. At January 31, 2017,inventory was $1,500 million. During the upcoming 2018 year, suppose Spicer expects costof goods sold to increase by 12%. The company budgets next year’s ending inventory at$1,800 million.Requirement1. One of the most important decisions a manager makes is how much inventory to buy. Howmuch inventory should Spicer purchase during the upcoming year to reach its budget?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
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