Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134067254
Author: Braun
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 6, Problem 6.32AE
Performing a regression analysis to predict
The manager of the main laboratory facility at Elmhurst Health Center (from E6-29A) collects seven additional months of data after obtaining the regression results in E6-31A. The number of tests performed and the total monthly overhead costs for the lab follow:
| Month | Number of Lab Tests Performed | Total Laboratory Overhead Costs |
| August | 3,350 | $23,500 |
| September | 3,700 | $27,550 |
| October | 3,650 | $24,500 |
| November | 3,450 | $26,400 |
| December | 4,200 | $28,500 |
| January | 2,500 | $22,800 |
| February | 3,800 | $25,350 |
Use Excel to do the following:
Requirements
- 1. Run a regression analysis using data for August through February.
- 2. Determine the lab’s cost equation (use the output from the regression analysis you performed using Excel).
- 3. Determine the R-square using the Excel output you obtain. What does the lab’s R-square indicate?
- 4. Predict the lab’s total overhead costs for the month if 3,500 tests are performed.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What is the earnings per share ?
Accounting
Express Delivery Company (EDC) is considering outsourcing its Payroll Department to a payroll processing company for an annual fee of $220,800. An internally prepared report summarizes the Payroll Department’s annual operating costs as follows:
Supplies
$ 30,800
Payroll clerks’ salaries
120,800
Payroll supervisor’s salary
58,800
Payroll employee training expenses
10,800
Depreciation of equipment
20,800
Allocated share of common building operating costs
15,800
Allocated share of common administrative overhead
28,800
Total annual operating cost
$ 286,600
EDC currently rents overflow office space for $36,800 per year. If the company closes its Payroll Department, the employees occupying the rented office space could be brought in-house and the lease agreement on the rented space could be terminated with no penalty.
If the Payroll Department is outsourced the payroll clerks will not be retained; however, the supervisor would be transferred to the company’s Human…
Chapter 6 Solutions
Managerial Accounting (5th Edition)
Ch. 6 - (Learning Objective 1) A graph of a variable cost...Ch. 6 - (Learning Objective 2) Which of the following is...Ch. 6 - (Learning Objective 2) In the cost equation...Ch. 6 - Prob. 4QCCh. 6 - Prob. 5QCCh. 6 - (Learning Objective 3) Which of the following is...Ch. 6 - Prob. 7QCCh. 6 - (Learning Objective 5) Which of the following is...Ch. 6 - Prob. 9QCCh. 6 - Prob. 10QC
Ch. 6 - Identify cost behavior (Learning Objectives 1 2)...Ch. 6 - Prob. 6.2SECh. 6 - Compute fixed costs per unit (Learning Objective...Ch. 6 - Prob. 6.4SECh. 6 - Predict and graph total mixed costs (Learning...Ch. 6 - Prob. 6.6SECh. 6 - Prepare and analyze a scatterplot (Learning...Ch. 6 - Prob. 6.8SECh. 6 - Use the high-low method (Learning Objective 4)...Ch. 6 - Prob. 6.10SECh. 6 - Prob. 6.11SECh. 6 - Prob. 6.12SECh. 6 - Write a cost equation given regression output...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Identify cost behavior graph (Learning Objectives...Ch. 6 - Prob. 6.18SECh. 6 - Prob. 6.19SECh. 6 - Prob. 6.20AECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Prob. 6.22AECh. 6 - Prob. 6.23AECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatterplot (Learning Objective 3) Melody...Ch. 6 - Continuation of E6-25A: High-low method (Learning...Ch. 6 - Continuation of E6-25A: Regression analysis...Ch. 6 - Regression analysis using Excel output (Learning...Ch. 6 - Prob. 6.29AECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Performing a regression analysis to predict...Ch. 6 - Prob. 6.33AECh. 6 - Prob. 6.34AECh. 6 - Compare absorption and variable costing (Learning...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.40AECh. 6 - Prob. 6.41BECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Use unit cost data to forecast total costs...Ch. 6 - Prob. 6.44BECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatter plot (Learning Objective 3) Tammy...Ch. 6 - Continuation of E6-46B: High-low method (Learning...Ch. 6 - Prob. 6.48BECh. 6 - Prob. 6.49BECh. 6 - Prob. 6.50BECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Prob. 6.53BECh. 6 - Prob. 6.54BECh. 6 - Prob. 6.55BECh. 6 - Prob. 6.56BECh. 6 - Prob. 6.57BECh. 6 - Prob. 6.58BECh. 6 - Prob. 6.59BECh. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.61BECh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prob. 6.64APCh. 6 - Prob. 6.65APCh. 6 - Prob. 6.66APCh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prepare traditional and contribution margin income...Ch. 6 - Prob. 6.70BPCh. 6 - Prob. 6.71BPCh. 6 - Prob. 6.72SCCh. 6 - Cost Behavior in Real Companies Choose a company...Ch. 6 - Ethics of building inventory (Learning Objective...Ch. 6 - Prob. 6.76ACT
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
- Thalassines Kataskeves, S.A., of Greece makes marine equipment. The company has been experiencing losses on its bilge pump product line for several years. The most recent quarterly contribution format income statement for the bilge pump follows: Thalassines Kataskeves, S.A. Income Statement—Bilge Pump For the Quarter Ended March 31 Sales $ 410,000 Variable expenses: Variable manufacturing expenses $ 123,000 Sales commissions 50,000 Shipping 21,000 Total variable expenses 194,000 Contribution margin 216,000 Fixed expenses: Advertising (for the bilge pump product line) 27,000 Depreciation of equipment (no resale value) 120,000 General factory overhead 38,000* Salary of product-line manager 113,000 Insurance on inventories 5,000 Purchasing department 49,000† Total fixed expenses 352,000 Net operating loss $ (136,000) *Common costs allocated on the basis of machine-hours. †Common costs allocated on the basis of…arrow_forwardDo companies maintain two sets of depreciation schedules, one for financial reporting and the other one for tax purposes?arrow_forwardnone ??arrow_forward
- Need help with this accounting questionsarrow_forwardCarichem Company produces sanitation products after processing specialized chemicals. The following relates to its activities: 1 Kilogram of chemicals purchased for $4000 and with an additional $2000 is processed into 400 grams of Crystals and 80 litres of a Cleaning agent. At split-off, a gram of Crystal can be sold for $2 and the Cleaning agent can be sold for $8 per litre. At an additional cost of $800, Carichem can process the 400 grams of Crystal into 500 grams of Detergent that can be sold for $4 per gram. The 80 litres of Cleaning agent is packaged at an additional cost of $600 and made into 200 packs of Softener that can be sold for $4 per pack. Required: 1. Allocate the joint cost to the Detergent and the Softener using the following: a. Sales value at split-off method b. NRV method 2. Should Carichem have processed each of the products further? What effect does the allocation method have on this decision?arrow_forwardGeneral accountingarrow_forward
- Allocate the two support departments’ costs to the two operating departments using the following methods: a. Direct method b. Step-down method (allocate HR first) c. Step-down method (allocate IS first) d. The Algebraic method.arrow_forwardCan you help me with accounting questionsarrow_forwardFinancial accounting question not use ai please don'tarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
GE McKinsey Matrix for SBU Strategies; Author: Wolters World;https://www.youtube.com/watch?v=FffD1Ze76JQ;License: Standard Youtube License