Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 6, Problem 6.52BE
Using regression analysis output to predict
Using the data provided in E6-50B, the laboratory manager performed a regression analysis to predict total laboratory overhead costs. The output generated by Excel is as follows:
Requirements
- 1. Determine the lab’s cost equation (use the output from the Excel regression).
- 2. Determine the R-square (use the output from the Excel regression).
- 3. Predict the total laboratory overhead for the month if 2,700 tests are performed.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Which of the following will give you the most accurate allocation between a cost's fixed component and variable component?
a. Examination of a students’ registration forms for miscellaneous fees and tuition fees
b. Use of the least squares method to allocate the cost of electricity
c. Dividing the total cost on the water bill among the different departments based on direct labor hours
d. Dividing the total cost of the postpaid plan using the high-low method
1. Set up a table with columns for cumulative number of units, cumulative average time per unit in hours, and cumulative total in hours using the cumulative average time learning curve. Complete the table for 1,2,4, and 8 units.
What is the cumulative total time in hours for 8 units?
2. Set up a table assuming an 80% cummulative avergae time learning curve.
What is the cumulative total time in hours for 8 units?
3. What is the difference in variable cost of producing four units? (between the result using the 0.90 model and 0.80 model)
Click to watch the Tell Me More Learning Objective 2 video and then answer the questions below.
1. The first step in preparing a cost of production report is to _____.
compute equivalent units of production
determine the units to be assigned costs
determine the cost per equivalent unit
allocate costs to units transferred out and partially completed units
2. The last step in preparing a cost of production report is to _____.
compute equivalent units of production
determine the units to be assigned costs
determine the cost per equivalent unit
allocate costs to units transferred out and partially completed units
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
- Need some help making a cheet sheet for an up coming test. please provide examples. The exam covers chapters 1 through 13. Here are some suggested study topics: Cost Classifications - variable, fixed and mixed, period and product, direct and indirect, opportunity, sunk, relevant, traceable, common, etc. Calculate the results of changes to cost assumptions (CVP) Calculate net income based on contribution margin values either dollars or % Application of Manufacturing Overhead - calculate predetermined overhead rate or activity rates applied to a product or job - job order using a predetermined overhead rate or rates and activity-based costing calculate over and underapplied overhead calculate adjusted cost of goods sold Job Costing What is the total cost of the job and average cost per unit. Cost of Goods Manufactured and cost of goods sold Calculate break even and target profit Create a contribution format income statement Gross margin calculations absorption or variable costing…arrow_forwardCheck image file for question Q1a. Allocate the service department costs to the two operating departments using the direct method. b.Allocate the service department cost to the two operating departments using ,I)the step-down method (Allocate administrative service first) . ii)the step down method (Allocoate Maintenance service first) c. Assuming you are the manager of the Daily Patient department.Discuss which method of cost allocation would you prefer.Justify your decision d.Mr Smith the financial controller of LabAid is convinced that the step-down method allocates more costs to the operating departments than the direct method.Do you agree with ,Mr Smith.Explain.arrow_forwardWeber Valley Regional Hospital has collected data on all of its activities for the past 16 months. Data for cardiac nursing care follow: Required: 1. Using the high-low method, calculate the variable rate per hour and the fixed cost for the nursing care activity. 2. Run a regression on the data, using hours of nursing care as the independent variable. Predict cost for the cardiac nursing care for September Year 2 if 1,400 hours of nursing care are forecast. Evaluate the regression equation. How comfortable are you with the predicted cost for September Year 2? 3. Upon looking into the events that happened at the end of Year 1, you find that the cardiology ward bought a cardiac-monitoring machine for the nursing station. Administrators also decided to add a new supervisory position for the evening shift. Monthly depreciation on the monitor and the salary of the new supervisor together total 10,000. Now, run two regression equations, one for the observations from Year 1 and the second using only the observations for the eight months in Year 2. Discuss your findings. What is your predicted cost of the cardiac nursing care activity for September Year 2?arrow_forward
- What I Know Before we begin this lesson, let us check first your prior knowledge on this module. After taking and checking this short test, take note of the items that you are not able to answer correctly and look for the right answer as you go through this module. Direction: Encircle the letter of the correct answer. 1. What type of cost includes product ingredients and materials? а. fixed b. revenue с. total d. variable 2. What type of cost includes the rental of space? а. fixed b. revenue c. total d. variable 3. What type of cost is the product of the price and the quantity sold? а. fixed b. revenue с. total d. variable 4. What concept is being described when the business will neither earn a profit nor suffer a loss? а. break-even b. loss с. profit d. summit 5. What type of analysis shows equal revenue and total cost? а. break-even b. cost of variable c. profit-loss d. volume of salesarrow_forwardClick to watch the Tell Me More Learning Objective 4 video and then answer the questions below. 1. Which of the following represents the computation of direct materials cost per equivalent unit? Total direct cost for the period divided by total equivalent units of direct materials. Total equivalent units of direct materials divided by total direct cost for the period. Total direct cost for the period divided by total units of direct materials. Total units of direct materials divided by total direct cost for the period. 2. What is the conversion cost per equivalent unit, when the total conversion cost for the period is $1,225 and the total units of packaged drinking water produced during the same period is 5,000 gallons (70 percent complete). $0.17 per gallon $0.35 per gallon $2.86 per gallon None of these choices are correct.arrow_forwardVariable Costing Income Statement for a Service Company The actual and planned data for Underwater University for the Fall term were as follows: Enrollment Tuition per credit hour Credit hours Registration, records, and marketing costs per enrolled student Revenue Variable costs: Registration, records, and marketing costs $ Instructional costs Total variable costs Instructional costs per credi ur Depreciation on classrooms and equipment Registration, records, and marketing costs vary by the number of enrolled students, while instructional costs vary by the number of credit hours. Depreciation is a fixed cost. Contribution margin Depreciation on classrooms and equipment Operating income $ Actual $ 4,500 Prepare a variable costing income statement showing the contribution margin and operating income for the Fall term. Underwater University Variable Costing Income Statement For the Fall Term $ $120 60,450 $275 $64 $825,600arrow_forward
- 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. Use the information included in the Excel Simulation and the Excel functions described below to complete the task.arrow_forwardprocedure for the following lab procedures, given a total lab cost of $1.25 million and an average hourly lab tech rate of $15 (to calculate the RVU, divide the total sample expense by the com- Job-Order Costing Self-Quiz Problem Cost per Using the weighted procedure method of setting rates, calculate the relative value and mon denominator of .25): Projected Labor Supply Procedure Volume in Minutes Expense ($) Amylase 4,000 15 .75 Bleeding time 5,000 12 .50 Uric acid 3,000 10 .50 Platelet count 7,800 9. .25 Hematocrit 7,600 8. .25arrow_forwardCompute the linear cost function, relating total overhead costs to physician contact hours, using the representative observations of 200 and 300 hours. Plot the linear cost function. Does the constant component of the cost function represent the fixed overhead costs of Young and Associates? Why?arrow_forward
- The following data apply to the provision of psychological testing services: Sales price per unit (1 unit = 1 test plus feedback to client) Fixed costs (per month): Selling and administration Production overhead (e.g., rent of testing facilities) Variable costs (per test): Labor for oversight and feedback Selling and administration (e.g., scheduling and billing) Number of tests per month Outsourced test analysis Materials used in testing. Production overhead a. Variable production cost per unit. b. Variable cost per unit. c. Full cost per unit. d. Full absorption cost per unit. Prime cost per unit. Conversion cost per unit. Contribution margin per unit. Gross margin per unit. e. 1. 9 h. 320 16,000 15,000 Required: Calculate the amount for each of the following (one unit one test) if the number of tests is 2,000 per month. Also calculate if the number of tests decreases to 1,250 per month. (Do not round intermediate calculations. Round your final answers to the nearest whole dollar.)…arrow_forwardUnk The costs of the Accounting Department at Central Hospital would be considered by the Surgery Department to be: A. a) direct costs. B. b) indirect costs. C. c) incremental costs. D. d) opportunity costs. E. e) sunk costs.arrow_forwardActivity-Based Costing, Lean Operations, and the Costs of Quality E4-24A Compare traditional and ABC allocations on a job (Learning Objective 2) Radley Products has adopted an ABC costing system. The following manufacturing activi- ties, indirect manufacturing costs, and cost drivers have been identified: Activity Machine setup Total estimated MOH costs related to activity Total estimated amount of allocation base activity $ 120,000 $1,050,000 Machining Polishing Quality control Facility-level costs sdngas 000' 6,000 machine hours 10,000 polishing cloths 4,000 tests run 50,000 DL hours 000'08 $ 280,000 $ 120.000 Total manufacturing overhead (MOH) $1.650.000 The Job Cost Record for Job #624 revealed that direct materials requisitioned for the job totaled $1,050. The Job Cost Record also showed that direct labor for this job totaled 10 hours at a wage rate of 525 per hour. Other data collected on the resources used by Job #624 included: 1 machine setup required 5 machine hours 2…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
GE McKinsey Matrix for SBU Strategies; Author: Wolters World;https://www.youtube.com/watch?v=FffD1Ze76JQ;License: Standard Youtube License