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 (12th Edition)
- 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_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_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_forward
- Management 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_forwardQuestion 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_forward
- BUS 203: INTRODUCTION TO COST AND MANAGEMENT ACCOUNTING PROJECT: CASH BUDGETING ASSOCIATE DEGREE YEAR 2: SEMESTER 1 (2020/21)Ronstadt Limited’s budget for the four months from January to April includes the following data:1. MonthSalesMaterialsWagesOverheads $000$000$000$000January615115.030360February636120.033390March690135.036420April684130.040425 2. One-third of sales revenue is received one month after sale and the remainder is received two months after sale. The sales in the previous two months were: November $600 000; December $540 000.3. One-quarter of purchases of materials are paid for in the month of purchase. The remainder are paid for two months later. Purchases in the previous two months were: November $108 000; December $106 000.4. Two-thirds of the wages are paid in the month in which they are earned, and the balance is paid in the following month. The wages for the previous December amounted to $30 000.5. One-half of the overhead expenditure is paid in the month in…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_forwardA. Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Jan. 31 Feb. 28 Mar. 31 Beginning inventory Finished goods Direct materials: silicon 4,500 8,500 11,200 4,900 9.100 12.000 5,000 9.200 13,000 Direct materials: solution Prepare a sales budget, production budget, direct materials budget for silicon and solution, and a direct labor budget. B. The data shown were obtained from the financial records of Italian Exports, Inc., for March: Estimated sales $560,000 Sales Purchases 567.923 294,823 10 50,320 Ending inventory Administrative salaries Marketing expense Sales commissions Rent expense Depreciation expense Utilities Sales are expected to increase each month by 10%. Prepare a budgeted income statement. 7,500 1,100 2,500…arrow_forward
- Required Information Use the following information for the Quick Study below. Miami Solar manufactures solar panels for industrial use. The company budgets production of 4,200 units (solar panels) in July and 4,500 units in August. QS 20-14 Manufacturing: Direct labor budget LO P1 Each unit requires 4 hours of direct labor at a rate of $15 per hour. Prepare a direct labor budget for July. MIAMI SOLAR Direct Labor Budget For Month Ended July 31 Budgeted production Total labor hours needed Budgeted cost of direct labor 4,200arrow_forwardDay Inc manufactures travel socks. The budgeted selling price is $17 per lock the variable cost in $10 per lock, and budgeted fixed costs are $10,000 per month Prepare a fexible budget for mulut leve of 3.000 locks and 5,000 locks for the month ended Apr 30, 2024 Unds Daje, Inc Flexible Budget For the Month Ended April 30, 2024 Budget Amounts Per Unit 3,000 5.000arrow_forwardLearnCo PARAGRAPH IS FOR ASSISTANCE TO HELP WITH THE QUESTIONS IN THE IMAGES ONLY WANT THE IMAGES ANWSERED 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 for various factors such as planned advertising…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning