![Horngren's Accounting, Student Value Edition (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134487151/9780134487151_largeCoverImage.gif)
Horngren's Accounting, Student Value Edition (12th Edition)
12th Edition
ISBN: 9780134487151
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
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
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Students have asked these similar questions
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…
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…
Dear 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…
Chapter 22 Solutions
Horngren's Accounting, 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
- Following are the budgeted income statements for the second quarter of 2019 for SeaTech Inc.: April $238,000 May $289,000 June Sales $323,000 Cost of goods sold* Gross profit 163,200 193,800 214, 200 $ 74,800 $ 95, 200 $108,800 Operating expenses" Operating income 37,400 42,500 45,900 $ 37,400 $ 52,700 $ 62,900 Includes all product costs (i.e., direct materials, direct labor, and manufacturing overhead). I Includes all period costs (i.e., selling, general, and administrative expenses). The company expects about 30% of sales to be cash transactions. Of sales on account, 60% are expected to be collected in the first month after the sale is made, and 40% are expected to be collected in the second month after sale. Depreciation, insurance, and property taxes represent $20,400 of the estimated monthly cost of goods sold and $13,600 of the estimated monthly operating expenses. The annual insurance premium is paid in January, and the annual property taxes are paid in August. Of the remainder…arrow_forwardHatcher Company prepared the following budgeted income statement for 2019: E (Click the icon to view the budgeted income statement.) Read the requirements. Requirement 1. Prepare a budgeted income statement with columns for 600 units, 1,100 units, and 1,300 units sold. Hatcher Company Budgeted Income Statement For the Year Ended December 31, 2019 - X Data Table Unit sales 600 Sales Revenue Cost of Goods Sold Hatcher Company Gross Profit Budgeted Income Statement Selling and Administrative Expenses For the Year Ended December 31, 2019 Operating Income Unit sales 1,100 Sales Revenue ($750 per unit) $ 825,000 495,000 Cost of Goods Sold (60% of sales) Gross Profit 330,000 288,750 Selling and Administrative (35% of sales) 41,250 Operating Income Print Donearrow_forwardDear Bartleby, can you please help with "calculations for cost of goods sold/operating expenses occured in the following problem, for March, April, May and June, 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,…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_forwardComputer Assignment The SK Industries, Inc. manufactures and sells two products, Accel Active and Accel Regular. In September 2018, SK Industries Budget Department gathered the following data in order to prepare budgets for 2019: 2019 Projected Sales Units Price Accel Active 45,000s225 Accel Regular 75,000|s155 Product Expected Target Inventories January 1, 2019 December 31, 2019 Product Accel Active 9,000 12,000 Accel Regular 17,000 25,000 The following direct materials are expected to be used in the two products: |Material Used per Unit Direct Material Unit Accel Active Accel Regular pound One 6. Two pound 4 2 Three pound 2 Projected data for 2019 with respect to direct materials are as follows: Direct Material Expected Purchase Price Expected Inventories Target Inventories (January 1, 2019) (December 31, 2019) One SIs 27,000 lb 35,000 lb Two S7 30,000 lb 35,000 lb Three $4 4,000 lb 7,000 lb Projected direct labor requirements and rates for 2019 are as follows: Product Accel Active…arrow_forwardPrepare a Sales Budget, Purchases Budget and Forecasted Income Statement for 2022 third quarter of Maryland Enterprises. Using the ff. data: June July August September Units to be Sold 1,000 1,250 1,500 1,350 Selling Price P190 Unit Cost P120 Beginning Inv for July 100 units Desired Ending Inventory 10% of Last month Unit Sales ling Expenses P25 per forecasted sales in units Administrative Expenses P10,000 per montharrow_forward
- Prepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenue 2. Prepare a production budget for 2 quarters. Sales budget data for Palermo Company are given in exercise 1. Management desires to have an ending finished goods inventory equal to 25% of the next quarter's expected unit sales. Prepare a production budget by quarters for the first 6 months of 2019. Palermo Company Direct Labor Budget For the Six Months Ending June 30, 2019…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_forwardshown below are the totals from 2018 period budgets. Revenue badget P 100,000 Materials usage from production budget 15,000 Labor cost budget 20,000 Manufacturing overhead budget 20,000 General and administrative budget 30,000 Capital Expenditure budget 20,000 Work in progress inventories Beginning of 2018 10,000 End of 2018 5,000 Finished goods inventory Beginning of 2018 15,000 End of 2018 10,000 Tax Rate 40% 1. prepared a forecasts income statement for the year.arrow_forward
- Integrated Excel: Preparing a Contribution Format Income Statement Using the High-Low Method Jay Corporation has provided data from a two-year period to aid in planning. The Controller has asked you to prepare a contribution format income statement. Budgeted information for Quarter 1 of 2024: Sales in units Sales price per unit After analyzing expenses, the company has determined the following cost patterns. Cost of Goods Sold (per unit) Sales Commissions (per dollar of sales). Administrative Salaries (per quarter) Rent Expense (per quarter) Depreciation Expense (per quarter) Shipping has been determined to be a mixed cost with the following total costs and units: 2022 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2023 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Cost $ 67,000 $ 94,000 $ 89,800 $ 92,600 $ 72,500 $80,000 $ 84,000 $ 100,000 17,000 $ 48.00 Units 12,500 21,000 13,800 20,000 13,700 14,000 14,300 22,500 $29.00 9.50€ $ 45,000 $ 27,000 $ 36,000 Required: Use the data to answer the…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_forwardPrepare a sales budget. Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by quarters for the year ending December 31, 2019. Palermo Company Sales Budget For the Year Ending December 31, 2019 Description Q1 Q2 Q3 Q4 Year Estimates sales Sales price x unit Sales Revenuearrow_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:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
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