Concept explainers
Preparing a flexible budget performance report Learning Objective 1
3. Static Bud. Var. for Op. Inc. $22,900 F
Cell One Technologies manufactures capacitors for cellular base stations and other communications applications. The company's July 2018 flexible budget shows output levels of 6,000,7,500, and 9,500 units. The static budget was based on expected sales of 7,500 units.
CELL ONE TECHNOLOGIES
Flexible Budget
For the Month Ended July 31, 2018
Budget Amount per Unit
Units | 6,000 | 7,500 | 9,500 | |
Sales Revenue | $ 21 | $ 126,000 | $ 157,500 | $ 199,500 |
Variable Expenses | 10 | 60,000 | 75,000 | 95,000 |
Contribution Margin | 66,000 | 82,500 | 104,500 | |
Fixed Expenses | 55,000 | 55,000 | 55,000 |
Operating Income$ 11,000 $ 27,500 $ 49,500
The company sold 9,500 units during July, and its actual operating income was as follows:
CELL ONE TECHNOLOGIES Income Statement For the Month Ended July 31,2018 |
|
Sales Revenue | $206,500 |
Variable Expenses | 100,100 |
Contribution Margin | 106,400 |
Fixed Expenses | 56,000 |
Operating Income | $ 50,400 |
Requirements
1. Prepare a flexible budget performance report for July.
2. What was the effect on Cell One s operating income of selling 2,000 units more than the static budget level of sales?
3. What is Cell One's static
4. Explain why the flexible budget performance report provides more useful information to Cell One's managers than the simple static budget variance. What insights can Cell One’s managers draw from this performance report?
Want to see the full answer?
Check out a sample textbook solutionChapter 23 Solutions
Horngren's Accounting: The Managerial Chapters (12th Edition) (loose Leaf Version)
- Refer to Cornerstone Exercise 8.6. Required: 1. Calculate the total budgeted cost of units produced for Play-Disc for the coming year. Show the cost of direct materials, direct labor, and overhead. 2. Prepare a cost of goods sold budget for Play-Disc for the year. 3. What if the beginning inventory of finished goods was 75,200 (for 16,000 units)? How would that affect the cost of goods sold budget? (Assume Play-Disc uses the FIFO method.) Play-Disc makes Frisbee-type plastic discs. Each 12-inch diameter plastic disc has the following manufacturing costs: For the coming year, Play-Disc expects to make 300,000 plastic discs, and to sell 285,000 of them. Budgeted beginning inventory in units is 16,000 with unit cost of 4.75. (There are no beginning or ending inventories of work in process.) Required: 1. Prepare an ending finished goods inventory budget for Play-Disc for the coming year. 2. What if sales increased to 290,000 discs? How would that affect the ending finished goods inventory budget? Calculate the value of budgeted ending finished goods inventory.arrow_forwardCreat an initial budget sheet showing the sistribution of $100,000 use the example's format on EXCEL.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_forward
- @ Gusteau's manufactures high-quality boxes of flavored seltzer which it sells for $14 per box. Below is some information related to Gusteau's capacity and budgeted fixed manufacturing costs for 2019: Budgeted Fixed Days of Hours of Denominator-Level W Capacity Concept Theoretical Capacity Practical Capacity Normal Capacity Master Budget Capacity $10,187,250 $10,194,980 # 3 E $ Help Center? Period 4 Manufacturing Overhead per $1,750,000 $1,750,000 $1,750,000 $1,750,000 R Production Production % 5 per Period T 362 310 310 310 Production during 2019 was 990,000 boxes of flavored seltzer, with 15,000 remaining in ending inventory at 12/31/19. Assume beginning inventory is zero. 22 Variable manufacturing costs were $1.78 per unit (there are no variable cost variances). Actual fixed manufacturing overhead costs were $1,750,000, the same as budgeted. Fixed manufacturing overhead cost variances are written off to cost of goods sold in the period in which they occur. (Note: Round interim…arrow_forwardgive an answer as per introduction i want correct answerarrow_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
- Question Content Area I AM NEEDING THE PICTURES ANWSERED THE PASSAGE IS JUST FOR ASSISTANCE TO ANSWER THE QUESTIONS Question Content Area LearnCo LearnCo manufactures and sells one product, an abacus for classroom use, with two models, the Basic model and the Deluxe model. The company began operations on January 1, 20Y1, and is planning for 20Y2, its second year of operations, by preparing budgets from its master budget. The company is trying to decide how many units to manufacture, how much it might spend on direct materials and direct labor, and what their factory overhead expenses might be. In addition, the company is interested in budgeting for selling and administrative costs, and in creating a budgeted income statement showing a prediction of net income for 20Y2. You have been asked to assist the controller of LearnCo in preparing the 20Y2 budgets. Sales Budget The sales budget often uses the prior year’s sales as a starting point, and then sales quantities are revised…arrow_forwardprofile-image Student question Time to preview question: 00 : 08 : 51 The Epsilon Co. have a building, which houses three production department, Alpha, Beta and Gamma, and one service department Delta. The service department, Delta is wholly involved in working for the three production departments and it is estimated that department Alpa uses 50%, department Beta uses 30% and department Gamma uses 20% of the services of department Delta. The budgeted overhead for the four departments for a period were: REQUIRED: a. Apportion the costs to the departments on the most equitable bases and calculate the overhead absorption rate, based on labour hours, for all the production department.arrow_forwardInstruction: I want you to prepare a production budget of Learning is Fun Company with the provided information below. Learning is Fun Company forecasts sales in units for January to May as follows: Jan Feb Mar Apr 2,800 May 3,000 Units 2,000 2,200 2,500 Additional Information: • The Company would like to maintain 100 units in its ending inventory at the end of each month. • Beginning inventory at the start of January amounts to 50 units.arrow_forward
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial 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