Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
16th Edition
ISBN: 9780134475585
Author: Srikant M. Datar, Madhav V. Rajan
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 10, Problem 10.25E
Account analysis, high-low. Stein Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2018. The following cost and other data were gathered for 2017:
- 1. Which of the preceding costs is variable? Fixed? Mixed? Explain.
Required
- 2. Using the high-low method, determine the cost function for each cost.
- 3. Combine the preceding information to get a monthly operating cost function for the Stein Corporation.
- 4. Next month, Stein expects to use 400 machine hours, have 80 employees, and ship 9,000 units. Estimate the total operating cost for the month.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Armer Company is accumulating data to use in preparing its annual profit plan for the coming year.
The cost behavior pattern of the maintenance costs must be determined. The accounting staff has
suggested the use of linear regression to derive an equation for maintenance hours and costs.
Data regarding the maintenance hours and costs for the last year and the results of the regression
analysis follow:
Maintenance
Machine
Month
Cost
Hours
$ 4,200
Jan.
480
Feb.
3,000
320
Mar.
3,600
400
Apr.
2,820
300
May
4,350
500
June
2,960
310
July
3,030
320
Aug.
4,470
520
Sept.
4,260
490
Oct.
4,050
470
Nov.
3,300
350
Dec.
3,160
340
Sum
$43, 200
4,800
$ 3,600
$
$
$ 684.65
Average
400
Average cost per hour
a (intercept)
b (coefficient)
9.00
7.2884
Standard error of the estimate
34.469
R-squared
0.99724
t-value for b
60.105
At 400 hours of activity, Armer management can be approximately two-thirds confident that the
maintenance costs will be in the range of
The Black is trying to plan for the next year. Their sales forecast for the next year is $3,500,000. Using the following current income statement, prepare the proforma income statement for the next year. Pay attention to the separation of expenses into fixed and variable components.
can you explain in more detailed
You are doing some financial analysis research for your work and managed to get (incomplete) data. You will use this data to deduce the required information. You can assume 365 days in a year.
a) Alpha Co. reported a cost of goods sold of $64,380.00 and an accounts payable balance of $16,700.00 last year. Compute the average time taken to pay suppliers. Discuss the significance of a longdays’ costs in payables for the firm.
b) Bravo Ltd. equity multiplier is 1.93, its total asset turnover is 2.65, and its profit margin is 4.20 percent. Compute the Return on Equity (ROE). Explain the impact on ROE, should the total asset turnover decline next year.
c) Charlie Inc. has a profit margin of 7.90 percent, a total asset turnover of 1.54, and a Return on Equity (ROE) of 13.47 percent. Solve for the debt-equity ratio.
d) Delta GMBH’s ROE is 8.9 percent. Sales are $2,956,000.00. Total debt ratio is 0.3743. Total debt is $964,000.00. Determine the return on assets (ROA).
Chapter 10 Solutions
Horngren's Cost Accounting: A Managerial Emphasis (16th Edition)
Ch. 10 - What two assumptions are frequently made when...Ch. 10 - Describe three alternative linear cost functions.Ch. 10 - What is the difference between a linear and a...Ch. 10 - High correlation between two variables means that...Ch. 10 - Name four approaches to estimating a cost...Ch. 10 - Describe the conference method for estimating a...Ch. 10 - Describe the account analysis method for...Ch. 10 - List the six steps in estimating a cost function...Ch. 10 - When using the high-low method, should you base...Ch. 10 - Describe three criteria for evaluating cost...
Ch. 10 - Define learning curve. Outline two models that can...Ch. 10 - Discuss four frequently encountered problems when...Ch. 10 - Prob. 10.13QCh. 10 - All the independent variables in a cost function...Ch. 10 - Multicollinearity exists when the dependent...Ch. 10 - HL Co. uses the high-low method to derive a total...Ch. 10 - A firm uses simple linear regression to forecast...Ch. 10 - In regression analysis, the coefficient of...Ch. 10 - A regression equation is set up, where the...Ch. 10 - What would be the approximate value of the...Ch. 10 - Estimating a cost function. The controller of the...Ch. 10 - Identifying variable-, fixed-, and mixed-cost...Ch. 10 - Various cost-behavior patterns. (CPA, adapted)....Ch. 10 - Matching graphs with descriptions of cost and...Ch. 10 - Account analysis, high-low. Stein Corporation...Ch. 10 - Account analysis method. Gower, Inc., a...Ch. 10 - Prob. 10.27ECh. 10 - Estimating a cost function, high-low method. Lacy...Ch. 10 - Linear cost approximation. Dr. Young, of Young and...Ch. 10 - Cost-volume-profit and regression analysis....Ch. 10 - Regression analysis, service company. (CMA,...Ch. 10 - High-low, regression. May Blackwell is the new...Ch. 10 - Learning curve, cumulative average-time learning...Ch. 10 - Learning curve, incremental unit-time learning...Ch. 10 - High-low method. Wayne Mueller financial analyst...Ch. 10 - High-low method and regression analysis. Market...Ch. 10 - High-low method; regression analysis. (CIMA,...Ch. 10 - Regression, activity-based costing, choosing cost...Ch. 10 - Interpreting regression results. Spirit...Ch. 10 - Cost estimation, cumulative average-time learning...Ch. 10 - Cost estimation, incremental unit-time learning...Ch. 10 - Regression; choosing among models. Apollo Hospital...Ch. 10 - Multiple regression (continuation of 10-42). After...Ch. 10 - Cost estimation. Hankuk Electronics started...Ch. 10 - Prob. 10.45PCh. 10 - Interpreting regression results, matching time...Ch. 10 - Purchasing department cost drivers, activity-based...Ch. 10 - Purchasing department cost drivers, multiple...
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
- The cost data for BC Billing Solutions for the year 2020 is as follows: A. Using the high-low method, express the company’s overtime wages as an equation wherexrepresents number of invoices processed. Assume BC has monthly fixed costs of $3,800. B. Predict the overtime wages if 9,000 invoices are processed. D. Using Excel, create a scatter graph of the cost data and explain the relationship between the number of invoices processed and overtime wage expense.arrow_forwardThe Black is trying to plan for the next year. Their sales forecast for the next year is $3,500,000. Using the following current income statement, prepare the proforma income statement for the next year. Pay attention to the separation of expenses into fixed and variable components.arrow_forwardThe information provided below was taken from the records of Chotoo Projects for the financial year ended 31 May 2020. Extract of statement of comprehensive income for the year ended 31 May 2020 R Revenue 480 000 Direct costs 240 000 Rent income 150 000 Advertising 4 800 Salaries and wages 90 000 Rates and taxes 1 200 Other operating expenses 80 000 21 Additional information 1. Revenue is calculated as direct cost plus 25%. 2. Revenue is divided equally each month. Revenue is expected to increase by 18% for the financial year ending 31 May 2021. 3. Fifty percent (50%) of the revenue is for cash and the balance is on credit. Debtors normally pay their accounts as follows: 40% in the month of the invoice, and these debtors are entitled to a 5% discount; 55% one month after the invoice; The balance is usually written off as bad debts. 4. Purchases for June and July are expected to be 30 000 per month. All purchases are for cash. 5. In terms of the lease agreement rent is received…arrow_forward
- Use the information given below to calculate each of the following independently 3.1 Expected total Marginal Income and Net Profit/Loss Slumber Limited manufactures beds. The following information was extracted from the budget for 2024:Expected production and sales (units) 1 200Selling price per bed R6 000Direct materials cost per bed R1 700Direct labour cost per bed R860Variable manufacturing overheads cost per bed R320Fixed manufacturing overheads cost R1 084 800Sales commission (as a percentage of the selling price) 20%Fixed administrative and selling costs R720 000 PLEASE PUT THE ANSWER IN RANDSarrow_forwardData for Hermann Corporation are shown below: Fixed expenses are $77,000 per month and the company is selling 2,600 units per month. Required: 1-a. How much will net operating income increase (decrease) per month if the monthly advertising budget increases by $8,200 and monthly sales increase by $15,300 ? 1-b. Should the advertising budget be increased? Complete this question by entering your answers in the tabs below. How much will net operating income increase (decrease) per month if the monthly advertising budget increases by $8,200 and monthly sales increase by $15,300 ? (Round any unit calculations up to the nearest whole unit.)arrow_forwardCombine the preceding information to get a monthly operating cost function for the Stein Corporationarrow_forward
- Refer to the information for Jasper Company on the previous page.Required:1. Prepare an income statement for Jasper for last year. Calculate the percentage of sales for eachline item on the income statement. (Note: Round percentages to the nearest tenth of a percent.)2. CONCEPTUAL CONNECTION Briefly explain how a manager could use the incomestatement created for Requirement 1 to better control costs.arrow_forwardHow many units will Cadre need to sell in order to realize a target profit of $300,000? Use commas as needed (i.e. 1,234). What dollar sales will Cadre need to generate in order to realize a target profit of $300,000? Rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). Construct a contribution margin income statement for the month of November that reflects $2,400,000 in sales revenue for Cadre, Inc. Rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345). Cadre Inc. Contribution Margin Income Statement For the Month of Novemberarrow_forwardVarious Financial data for 2019 and 2020 follows. Calculate the total productivity measure and the partial measures for labour, raw materials, and energy for this company for both years. 2019 $75,000 Output: Input: Sales Total Productivity Partial Lab Productivity Partial Material Productivity Labour Materials Energy Other 19,150 21,620 12,250 8,300 61,320 For your answers, write value rounded to two decimal points. Include zeros if applicable and do not include any symbols. (Examples: 3.445 should be written as 3.45, 3.000 should be written as 3.00) 2019 2020 2020 $92,300 22,150 25,120 26,730 5,170 79,170 Partial Energy Partial Other For your answers below, type one of the options exactly as provided in the brackets. Based on the results the company overall is The company's best improvement is seen in The company's biggest decline is seen in (improving / declining). (labour / material / energy / other). (labour / material / energy / other).arrow_forward
- The marketing department of Metroline Manufacturing estimates that its sales in 2016 will be $1.68 million. Interest expense is expected to remain unchanged at $35,000, and the firm plans to pay $66,000 in cash dividends during 2016. Metroline Manufacturing's income statement for the year ended December 31, 2015, is given along with a breakdown of the firm's cost of goods sold and operating expenses into their fixed and variable components. a. Use the percent-of-sales method to prepare a pro forma income statement for the year ended December 31, 2016. b. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2016. c. Compare and contrast the statements developed in parts a. and b. Which statement probably provides the better estimate of 2016 income? Explain why.arrow_forward1. Calculate the contribution margin percentage and breakeven point in units and revenues for June2. What is the margin of safety (in units) for June 2021?arrow_forwarda) Compute the selling price per unit in 2019, using the equation method. b) Given the sales of 3,000 units and the selling price calculated in (a), prepare a contribution marginincome statement for the year ended December 31, 2019, detailing the components of total fixed costsand clearly showing contribution and net income. c) Calculate Benoit’s break-even point in units and in sales dollars.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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