Preparing a Flexible Budget for Performance Reporting Suppose you receive the following performance report from the accounting department for your first month as plant manager for a new company. Your supervisor, the vic performance in the area of cost control. Units Actual 10,000 Budgeted Variance 12,000 2,000 U Costs: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Total costs $717,600 $864,000 $146,400 F $829,200 $1,036,800 $207,600 F $432,000 $518,400 $86,400 F $900,000 $864,000 $36,000 U $2,878,800 $3,283,200 $404,400 F REQUIRED Prepare a variance analysis Note: Do not use negative signs with your answers. Units (in cases) Costs: Static Budget Activity Variance 12,000 Flexible Budget Flexible Budget Variance 10,000 Actual 2,000 x Static (Total) Variance Direct materials $ 864,000 Direct labor $ 1,036,800 $ $ 146,400 x F 207,600 x F 864,000 x $ 146,400 x F ÷ 1,036,800 * $ 207,600 x F ÷ Variable overhead $ 518,400 $ 86,400 F ÷ 518,400 x $ 86,400 x $ Fixed overhead $ 864,000 $ 36,000 x $ 864,000 $ 36,000 U ÷ Total costs $ 3283200 $ 476400 F 3283200 $ 404400 F 717,600 $ 829,200 $ 432,000 900,000 2878800 $ 146,400 F 207,600 F ÷ ÷ 86,400 F $ 36,000 U 404400 F ÷

Preparing a Flexible Budget for Performance Reporting Suppose you receive the following performance report from the accounting department for your first month as plant manager for a new company. Your supervisor, the vic performance in the area of cost control. Units Actual 10,000 Budgeted Variance 12,000 2,000 U Costs: Direct materials Direct labor Variable manufacturing overhead Fixed manufacturing overhead Total costs $717,600 $864,000 $146,400 F $829,200 $1,036,800 $207,600 F $432,000 $518,400 $86,400 F $900,000 $864,000 $36,000 U $2,878,800 $3,283,200 $404,400 F REQUIRED Prepare a variance analysis Note: Do not use negative signs with your answers. Units (in cases) Costs: Static Budget Activity Variance 12,000 Flexible Budget Flexible Budget Variance 10,000 Actual 2,000 x Static (Total) Variance Direct materials $ 864,000 Direct labor $ 1,036,800 $ $ 146,400 x F 207,600 x F 864,000 x $ 146,400 x F ÷ 1,036,800 * $ 207,600 x F ÷ Variable overhead $ 518,400 $ 86,400 F ÷ 518,400 x $ 86,400 x $ Fixed overhead $ 864,000 $ 36,000 x $ 864,000 $ 36,000 U ÷ Total costs $ 3283200 $ 476400 F 3283200 $ 404400 F 717,600 $ 829,200 $ 432,000 900,000 2878800 $ 146,400 F 207,600 F ÷ ÷ 86,400 F $ 36,000 U 404400 F ÷

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

If so, what do you suggest be done to improve the system? Prepare a flexible budget and recompute the budget variances.
Service Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $132,650 3,500 Network center Number of devices monitored 630,400 9,850 Electronic mail Number of user accounts 64,800 7,200 Handheld technology support Number of handheld devices issued 133,920 9,300 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has…
Landon is working on putting together the financials for his company's quarterly report. His company uses standard costs within its absorption costing system, and Landon needs to find the budgeted. cost per unit in order to estimate COGS. Landon has provided the following cost information. 2 3 41 15 16 17 18 Budgeted variable manufacturing cost per unit Budgeted variable operating cost per unit Budgeted fixed overhead costs Budgeted fixed operating costs Budgeted production in units $ D 5.00 3.00 30,000 20,000 5,000 E F G H functions with cell references to the Problem area or work area as indicated. How much cost should be capitalized to inventory for each unit produced? Cost per unit
Your department head wants you to perform a cost analysis and provide data to the CFO next week. The budget information below comes directly from your accounting department and the figures are correct, however you know that your CFO's time is important and she often asks for ratios that are not calculated by your accounting department. Your department head has challenged you to present common ratios as he wants to mentor you for a potential assistant director position. Your figures need to be specific and accurate. Since you do not know "exactly" which figures to present, you decided to cover the Eight Basic Ratios Used in Health Care. This way, you can answer any question intelligently. Use the data listed below to calculate (show your work) each of the Eight Basic Ratios Used in Health Care. Explain for each ratio what your answer means to the company. (You should have 8 explanations.) Current Assets = $18,000,542.00 Current Liabilities = $12,240,543.00 Cash & Cash…
Direct Labor Cost Budget Direct labor needs from the direct labor cost budget should be coordinated between the production and personnel departments so that there will be enough labor available for production. Before you make any changes to the budget, you review the information on the following Direct Labor Data Table and enter the units to be produced from the Production Budget. After scanning the Direct Labor Cost Budget (which follows the Direct Labor Data Table), you observe that LearnCo has omitted quite a few numbers from the budget. Fill in the missing amounts. You may need to use numbers from the Direct Labor Data Table, or from the sales budget, production budget, and direct materials purchases budget you prepared. When required, round your answers to the nearest dollar. Direct Labor Data Table Gluing Assembly Hours required per unit: Basic abacus 0.10 0.10 Deluxe abacus 0.10 0.20 Labor hourly rate: Gluing $13 Assembly $19 Units to be…
Vaughn Creations sells window treatments (shades, blinds, and awnings) to both commercial and residential customers. The following information relates to its budgeted operations for the current year. Revenues Direct materials costs Direct labor costs. Overhead costs Operating income (loss) Revenues Direct materials costs Direct labor costs. Overhead costs Operating income (loss) Activity Cost Pools Scheduling and travel Setup time Supervision The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not more profitable given that the installations of window coverings are less complex for residential customers. In addition, the residential client base resides in close proximity to the company office, so travel costs are not as expensive on a per client visit for residential customers. As a result, she has decided to take a closer look at the overhead costs assigned to the two product lines to determine whether a more accurate…
1. Explain why a company needs these budgets used in #2 of your homework and how will they help the manager prepare for the next year? For example: ordering inventory, increasing or decreasing material costs so their sales will increase and cost decrease (labor, raw materials, or costs that pertain to operations)? Make sure to explain what each budget tells the manager.
Terry Travers is the manufacturing supervisor of Aurora Manufacturing Company, which produces avariety of plastic products. Some of these products are standard items that are listed in the company’scatalog, while others are made to customer specifications. Each month, Travers receives a performancereport showing the budget for the month, the actual activity, and the variance between budget and actual.Part of Travers’s annual performance evaluation is based on his department’s performance against budget.Aurora’s purchasing manager, Sally Christensen, also receives monthly performance reports and she, too,is evaluated in part on the basis of these reports.The monthly reports for June had just been distributed when Travers met Christensen in the hallwayoutside their offices. Scowling, Travers began the conversation, “I see we have another set of monthlyperformance reports hand-delivered by that not very nice junior employee in the budget office. He seemedpleased to tell me that I’m in…
Critiquing a Variance Report; Preparing a Performance Report Several years ago, Westmont Corporation developed a comprehensive budgeting system for planning and control purposes. While departmental supervisors have been happy with the system, the factory manager has expressed considerable dissatisfaction with the information being generated by the system. A report for the company’s Assembly department for the month of march follows: After receiving a copy of this cost report, the supervisor of the assembly department started, “These reports are super. It makes me feel really good to see how well things are going in my department. I can’t understand why those people upstairs complain so much about the reports.” For the last several years, the company’s marketing department has chronically failed to meet the sales goals expressed in the company’s monthly budgets. Required: 1. The company’s president is uneasy about the cost reports and would like you to evaluate their usefulness to the…
Budgets need to be fair and attainable for employees to consider the budget important in their normal daily activities. Which of the following is not considered a human behavior problem? Allowing employees the opportunity to be a part of the budget process Allowing goals to be so low that employees develop a "spend it or lose it" attitude Setting goals too tightly making it difficult to meet performance expectation Setting goals among managers that conflict with one another
Service Department Charges and Activity Bases Middler Corporation, a manufacturer of electronics and communications systems, uses a service department charge system to charge profit centers with Computing and Communications Services (CCS) service department costs. The following table identifies an abbreviated list of service categories and activity bases used by the CCS department. The table also includes some assumed cost and activity base quantity information for each service for October. CCS ServiceCategory Activity Base Budgeted Cost Budgeted ActivityBase Quantity Help desk Number of calls $133,760 3,200 Network center Number of devices monitored 748,250 10,250 Electronic mail Number of user accounts 70,950 6,450 Handheld technology support Number of handheld devices issued 168,960 9,600 One of the profit centers for Middler Corporation is the Communication Systems (COMM) sector. Assume the following information for the COMM sector: The sector has…
Elmo Security Consultants (ESC) offer a standardized review of data security for small business owners. The following data apply to the provision of these reviews: Sales price per unit (1 unit = 1 review with recommendations) Fixed costs (per month): Selling and administration Production overhead (e.g., rent of facilities) Variable costs (per review): Labor for oversight and feedback Outsourced security analysis Materials used in reviews Review overhead Selling and administration (e.g., scheduling and billing) Number of reviews per month Required: a. Variable review (production) cost per unit b. Variable total cost per unit c. Full cost per unit d. Full absorption cost per unit e. Prime cost per unit f. Conversion cost per unit Calculate the amount for each of the following (one unit = one review) if the number of reviews is 2,500 per month. Also calculate if the number of reviews decreases to 2,000 per month. g. Contribution margin per unit h. Gross margin per unit 2,500 Reviews $ 500…