Horngren's Accounting: The Managerial Chapters, Student Value Edition (12th Edition)
12th Edition
ISBN: 9780134491509
Author: MILLER-NOBLES, Tracie L., Mattison, Brenda L., Matsumura, Ella Mae
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 22, Problem E22.37E
Using sensitivity analysis
Learning Objective 7
1. Op. Inc. at 1,700 units $306,000
Rucker Company prepared the following
| RUCKER COMPANY Budgeted Income Statement For the Year Ended December 31, 2019 |
|
| Unit Sales | 1,300 |
| Sales Revenue ($400 per unit) | $520,000 |
| Cost of Goods Sold (45% of sales) | 234,000 |
| Gross Profit | 286,000 |
| Selling and Administrative Expenses (10% of sales) | 52,000 |
| Operating Income | $ 234,000 |
Requirements
1 Prepare a budgeted income statement with columns for 700 units, 1,300 units, and 1,700 units sold.
2. How might managers use this type of budgeted income statement?
3. How might spreadsheet software such as Excel assist in this type of analysis?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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.
Roberds 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…
Sampson Merchandising Firm is developing its budgets for Year 2. The Year 1 income statement is as follows:
Sales (200,000 units)$500,000Less Cost of goods sold 325,000Gross profit$175,000Operating expenses (includes $20,000 of depreciation) 120,000Net income$ 55,000
Selling prices will increase by 10 percent, and sales volume in units will decrease by 6 percent. The cost of goods sold as a percent of sales will decrease to 62 percent. Other than depreciation, all operating costs are variable.
Prepare a budgeted income statement for Year 2.
Chapter 22 Solutions
Horngren's Accounting: The Managerial Chapters, Student Value Edition (12th Edition)
Ch. 22 - Prob. 1QCCh. 22 - A company prepares a five-year budget. This budget...Ch. 22 - Which of the following is the cornerstone of the...Ch. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - Suppose Iron City manufactures cast iron skillets....Ch. 22 - The budgeted income statement is part of which...Ch. 22 - Prob. 9QCCh. 22 - Suppose Mallcentral sells 1,000 hardcover books...
Ch. 22 - Suppose Mallcentral sells 1,000 hardcover books...Ch. 22 - The budgeted balance sheet is part of which...Ch. 22 - Information technology has made it easier for...Ch. 22 - Prob. 1RQCh. 22 - Prob. 2RQCh. 22 - How is benchmarking beneficial?Ch. 22 - What is budgetary slack? Why might managers try to...Ch. 22 - Explain the difference between strategic and...Ch. 22 - Explain the difference between static and flexible...Ch. 22 - What is a master budget?Ch. 22 - In a manufacturing company, what are the three...Ch. 22 - Why is the sales budget considered the cornerstone...Ch. 22 - Prob. 10RQCh. 22 - What is the formula used to determine the amount...Ch. 22 - What are the two types of manufacturing overhead?...Ch. 22 - How is the predetermined overhead allocation rate...Ch. 22 - What is the capital expenditures budget?Ch. 22 - What are the three sections of the cash budget?Ch. 22 - Prob. 16RQCh. 22 - How does the master budget for a merchandising...Ch. 22 - Prob. 18RQCh. 22 - Prob. 19RQCh. 22 - Prob. 20RQCh. 22 - Budgeting benefits Learning Objective 1 List the...Ch. 22 - S22-2 Budgeting types
Learning Objective...Ch. 22 - Prob. S22.3SECh. 22 - S22-4 Preparing an operating budget—production...Ch. 22 - Prob. S22.5SECh. 22 - Prob. S22.6SECh. 22 - Prob. S22.7SECh. 22 - Prob. S22.8SECh. 22 - Prob. S22.9SECh. 22 - Prob. S22.10SECh. 22 - Prob. S22.11SECh. 22 - S22-12 Understanding the components of the master...Ch. 22 - S22-13 Preparing an operating budget—sales...Ch. 22 - Prob. S22.14SECh. 22 - Prob. S22.15SECh. 22 - Prob. S22.16SECh. 22 - Prob. S22.17SECh. 22 - Prob. S22.18SECh. 22 - Prob. S22.19SECh. 22 - Prob. S22.20SECh. 22 - Prob. E22.21ECh. 22 - Prob. E22.22ECh. 22 - Prob. E22.23ECh. 22 - Preparing an operating budget—direct materials,...Ch. 22 - E22-25 Preparing an operating budget—cost of goods...Ch. 22 - Prob. E22.26ECh. 22 - Preparing a financial budget—schedule of cash...Ch. 22 - Prob. E22.28ECh. 22 - E22-29 Preparing the financial budget-cash...Ch. 22 - Preparing the financial budget—budgeted balance...Ch. 22 - Prob. E22.31ECh. 22 - Prob. E22.32ECh. 22 - Prob. E22.33ECh. 22 - Prob. E22.34ECh. 22 - E22-35 Preparing a financial budget—cash...Ch. 22 - Prob. E22.36ECh. 22 - Using sensitivity analysis Learning Objective 7 1....Ch. 22 - Preparing an operating budget—sales, production,...Ch. 22 - Prob. P22.39APGACh. 22 - Preparing a financial budgetbudgeted income...Ch. 22 - Completing a comprehensive budgeting...Ch. 22 - Prob. P22.42APGACh. 22 - Prob. P22.43APGACh. 22 - P22-44A Preparing a financial budget—budgeted...Ch. 22 - Prob. P22.45APGACh. 22 - Prob. P22.46APGACh. 22 - Prob. P22.47BPGBCh. 22 - Prob. P22.48BPGBCh. 22 - Prob. P22.49BPGBCh. 22 - Prob. P22.50BPGBCh. 22 - Prob. P22.51BPGBCh. 22 - Prob. P22.52BPGBCh. 22 - Prob. P22.53BPGBCh. 22 - Preparing a comprehensive budgeting...Ch. 22 - Prob. P22.55BPGBCh. 22 - Using Excel for to prepare an operating budget...Ch. 22 - Prob. P22.57CPCh. 22 - Prob. 22.1TIATCCh. 22 - Prob. 22.1DCCh. 22 - Prob. 22.1EICh. 22 - Prob. 22.1FC
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
- 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.arrow_forwardProblem 2 The Batting Company manufactures cricket bats which it sells for $80 each. For the first quarter of 2020, the company collectd the following information. Budgeted sales, 4,000 bats Finished good inventory on December 31, 2019, 1,000 bats Desired ending inventory of bats at the end of March 2020, 600. Direct materials requirements are 3 feet of lumber, for each bat at a cost of $5.50 per foot. Direct materials inventory on December 31, 2019 was 3,000 feet of lumber at $5.50 per foot. Desired ending inventory of raw materials is 5,000 feet of lumber. Each bat requires 2 hours of direct labor at an average cost of $20 per hour Required: Prepare the following for the Batting Company for the first quarter. The sales budget The production budget The direct materials and the direct labor budgetsarrow_forward7-23A Compute breakeven and project income (Learning Objectives 1 & 2)Grover’s Steel Parts produces parts for the automobile industry. The company hasmonthly fixed expenses of $630,000 and a contribution margin of 70% of revenues.Requirements1. Compute Grover’s Steel Parts’ monthly breakeven sales in dollars.2. Use the contribution margin ratio to project operating income (or loss) if revenues are$520,000 and if they are $1,010,000.3. Do the results in Requirement 2 make sense given the breakeven sales you computedin Requirement 1? Explain.arrow_forward
- a) 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_forwardRender Co. CPA is preparing activity-based budgets for 2019. The partners expect the firm to generate billable hours for the year as follows. Data entry . . . . . . . . . . . 2,200 hours Auditing 4,800 hours Tax 4,300 hours Consulting 750 hours The company pays $15 per hour to data-entry clerks, $30 per hour to audit personnel, $40 per hour to tax personnel, and $50 per hour to consulting personnel. Prepare a schedule of budgeted labor costs for 2019 using activity-based budgeting.arrow_forwardDear Bartleby, can you please assist with solving the following item enclosed, thank you. Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April May June Sales $ 112,000 $ 136,000 $ 152,000 Cost of goods sold* 76,800 91,200 100,800 Gross profit $ 35,200 $ 44,800 $ 51,200 Operating expenses† 17,600 20,000 21,600 Operating income $ 17,600 $ 24,800 $ 29,600 *Includes all product costs (i.e., direct materials, direct labor, and manufacturing overhead).†Includes all period costs (i.e., selling, general, and administrative expenses).The company expects about 40% of sales to be cash transactions. Of sales on account, 65% are expected to be collected in the first month after the sale is made, and 35% are expected to be collected in the second month after sale. Depreciation, insurance, and property taxes represent $9,600 of the estimated monthly cost of goods…arrow_forward
- 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…arrow_forwardThe marketing department of HASF Corporations has submitted the following sales forecast for the upcoming fiscal year (all sales are on account) Q1 Q2 Q3 Q4 total Budgeted units sales ? 10% increase 10 % decrease 16,335 62,685 Budget selling price per unit 18 18 18 ? 18 budgeted sales revenue ? 297,000 ? 294,030 ? Other information Each quarter ending finished goods inventory is 20% of next month units sold. Next year first quarter beginning inventory is 3,000. Each finished units require 3 grams of raw material that cost Rs 3 per unit. Management desired to end each quarter with an inventory of raw material equal to 15% of the current quarter production needs Beginning inventory of raw material in first quarter 3,000 grams Find total cost of raw material purchased in all four Quarters?arrow_forwardThe marketing department of HASF Corporations has submitted the following sales forecast for the upcoming fiscal year (all sales are on account) Q1 Q2 Q3 Q4 total Budgeted units sales ? 10% increase 10 % decrease 16,335 62,685 Budget selling price per unit 18 18 18 ? 18 budgeted sales revenue ? 297,000 ? 294,030 ? Other information Each quarter ending finished goods inventory is 20% of next month units sold. Next year first quarter beginning inventory is 3,000. Each finished units require 3 grams of raw material that cost Rs 3 per unit. Management desired to end each quarter with an inventory of raw material equal to 15% of the current quarter production needs Beginning inventory of raw material in first quarter 3,000 gramsarrow_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_forwardtask 1 Prepare the following budgets for the year 2021: - a. Sales budget. Show total sales by quarter and in total for the year. b. Production budget. Show total production unit by quarter and in total for the year. c. Direct material usage and purchase budget. d. Direct labour budget. task 2 Based Jaka’s experience, fifty percent (50%) of sales are paid in cash. Of the sales on account, seventy percent (70%) are collected in the quarter of sale; the remaining thirty percent (30%) are collected in the quarter following the sale. Total sales for the fourth quarter of 2020 totaled RM2,000,000. Required: Refer to the sales budget prepared in Task 1. Construct a cash receipts budget including an accounts receivable aging schedule for Jaka Sdn Bhd for each quarter of year 2021.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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
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