Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 6, Problem 6.31AE
Using regression analysis output to predict
Using the data provided in E6-29A, the laboratory manager performed a regression analysis to predict total laboratory overhead costs. The output generated by Excel is as follows:
6.1-6.3 Full Alternative Text
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 3,100 tests are performed.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Click 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.
Classify costs and make a quality-initiative decision (Learning Objective 5) Sinclair Corp. manufactures radiation-shielding glass panels . Suppose Sinclair is consider-ing spending the following amounts on a new TOM program :Strength-testing one item from each batch of panels ......................... . Training employees in TOM ................................................................. . Training suppliers in TOM .................................................................... . Identifying preferred suppliers that commit to on-time delivery ofperfect quality materials ................................................................... .Sinclair expects the new program to save costs through the following:Avoid lost profits from lost sales due to disappointed customers ....... Avoid rework and spoilage ................................................................. .. Avoid inspection of raw materials ........................................................ . Avoid…
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
- Calculate a job cost using ABC (Learning Objective 2)Oliver Industries, a small, family-run manufacturer, has adopted an ABC system . The fol- lowing manufacturing activities, indirect manufacturing costs, and usage of cost drivers have been estimated for the year :54-7Direct materials ................................................................................ ? Direct labor ...................................................................................... ? Manufacturing overhead ...... .......... .......... ............. ................. .......... ? Total job cost .................................................................................... $?Classifying costs within the cost hierarchy (Learning Objective 2) Classify each of the following costs as either unit-level, batch-level, product-level, orfacility-level.a. Engineering costs for new productb. Order processingc. Depreciation on factoryd. Direct labore. Shipment of an order to a customerf. Product line manager…arrow_forwardMANAGEMENT ACCOUNTING & CONTROL STANDARD COSTS AND VARIANCE ANALYSIS LEARNING ACTIVITY 1 Torres Company has established standard costs for the cabinet department, in which one size of MX cabinet is made. The standard costs of producing one of these MX cabinets are shown below: Standard Cost Card – MX Cabinet Direct Material: Lumber 50 board ft at P 4 200 Direct Labor: 8 hours at P 10 80 Overhead Costs: Variable – 8 hrs at P5 40 Fixed – 8 hrs at P3 24 Total Standard Unit Cost 344 During June 2018, 500 of these cabinets were produced. The cost of operations during the month are shown below. There is no work in process at the beginning and end of the month. Direct material purchased: 30,000 bf at P4.10 123,000 Direct materials used: 24,000 board ft Direct labor: 4,200 hrs at P9.50 39,900 Overhead Costs : Variable Costs 22,000 Fixed Costs 11,000…arrow_forwardA marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the sample values of total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.arrow_forward
- Click to watch the Tell Me More Learning Objective 1 video and then answer the questions below. 1. Which of the following manufacturers is most likely to use a process cost system? Purse manufacturer Sports drink manufacturer Automobile manufacturer Guitar manufacturer 2. Process and job order cost systems are similar in that both systems _______. record and summarize product costs classify product costs as direct materials, direct labor, and factory overhead allocate factory overhead costs to products All of these choices are correct.arrow_forwardI have the following information: direct materials $250 and total manufacturing cost $700. Overhead applied to jobs at a rate of 200% of direct labor cost. This is for Chapter 2 job costing in managerial accounting. I am supposed to figure out conversion cost, direct labor cost, and manufacturing overhead. I know the formula for conversion cost= direct labor + manufacturing OH Prime cost= direct labor + direct materials How do I figure out direct labor cost with the given information? The learning objective states calcualte predetermined overhead rate, but I do not have estimated manufacturing cost and estimated labor. Can you please help? Thanks, Erica Gordonarrow_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_forward
- Pareto chart and cost of quality report for a service company The administrator of Liberty Hospital has been asked to perform an activity analysis of the emergency room (ER). The ER activities include cost of quality and other patient care activities. The lab tests and transportation are hospital services external to the ER for determining external failure costs. The result of the activity analysis is summarized as follows: Activities Activity Cost Patient registration $ 6,500 Verifying patient information 9,700 Assigning patients 13,000 Searching/waiting for doctor 9,200 Doctor exam 4,900 Waiting for transport 17,500 Transporting patients 16,200 Verifying lab orders 14,500 Searching for equipment 8,200 Incorrect labs 11,300 Lab tests 17,000 Counting supplies 19,000 Looking for supplies 8,200 Staff training 4,800 Total $160,000 a. b. c. d. Classify the…arrow_forwardLearning curve, cumulative average-time learning model. Northern Defense manufactures radar systems. It has just completed the manufacture of its first newly designed system, RS-32. Manufacturing data for the RS-32 follow: Calculate the total variable costs of producing 2, 4, and 8 units.arrow_forwardMethod of Least Squares, Developing and Using the Cost Formula The method of least squares was used to develop a cost equation to predict the cost of receiving purchased parts at a video game manufacturer. Ninety-six data points from monthly data were used for the regression. The following computer output was received: Intercept 175,600 Slope 455 The cost driver used was number of parts inspected. Required: 1. What is the cost formula? Total cost of receiving = $ + ( $ × ) 2. Using the cost formula from Requirement 1, identify each of the following: independent variable, dependent variable, Variable rate per professional hour, and fixed cost per month. Independent variable Dependent variable Variable rate per professional hour per part inspected Fixed cost per month 3. Using the cost formula, predict the cost of receiving for a month in which 7,200 parts are inspected. Total cost of receiving = $arrow_forward
- The Bienestar Cardiology Clinic has two major activities: diagnostic and treatment. The two activities use four resources: nursing, medical technicians, cardiologists, and equipment. Detailed interviews have provided the work distribution matrix shown below. The total time estimated corresponds to practical capacity (interviewers adjusted the total time to about 80 percent of the available time). The equipment time is measured in machine hours. Thus, the total time (at practical capacity) in the system is 20,000 hours. In considering the implementation of a TDABC model, the following unit times and transaction information are also provided: Required: 1. Calculate the cost of each activity using the indicated values of the resource drivers. 2. Calculate the capacity cost rate for TDABC. Using the capacity cost rate, calculate the cost of each activity under TDABC. Compare these values with those obtained in Requirement 1 and discuss possible reasons for any differences. 3. Suppose that the actual activity driver quantities are 3,500 and 9,000. Calculate the cost of unused capacity. 4. Suppose that the clinic acquires new equipment that reduces the total time required for the two activities from 6,000 to 4,000 hours. The equipment cost remains the same. Explain how the ABC system would be updated and then describe how TDABC would provide updates. 5. Suppose that diagnosing patients without any cardiac disease takes two hours while diagnosing patients with mildly diseased hearts takes an additional 1.5 hours and those with more severe problems takes an additional two hours. Prepare a time equation and, using the capacity cost rate from Requirement 2, calculate the activity rate for each of the three types of patients.arrow_forwardFormation of an Activity Dictionary A hospital is in the process of implementing an ABC system. A pilot study is being done to assess the effects of the costing changes on specific products. Of particular interest is the cost of caring for patients who receive in-patient recovery treatment for illness, surgery (noncardiac), and injury. These patients are housed on the third and fourth floors of the hospital. The floors are dedicated to patient care and have only nursing stations and patient rooms. A partial transcript of an interview with the hospitals nursing supervisor is as follows: 1. How many nurses are in the hospital? There are 101 nurses, including me. 2. Of these 100 nurses, how many are assigned to the third and fourth floors? Fifty nurses are assigned to these two floors. 3. What do these nurses do (please describe)? Provide nursing care for patients, which, as you know, means answering questions, changing bandages, administering medicine, changing clothes, etc. 4. And what do you do? I supervise and coordinate all the nursing activity in the hospital. This includes surgery, maternity, the emergency room, and the two floors you mentioned. 5. What other lodging and care activities are done for the third and fourth floors by persons other than the nurses? The patients must be fed. The hospital cafeteria delivers meals. The laundry department picks up dirty clothing and bedding once each shift. The floors also have a physical therapist assigned to provide care on a physician-directed basis. 6. Do patients use any equipment? Yes. Mostly monitoring equipment. 7. Who or what uses the activity output? Patients. But there are different kinds of patients. On these two floors, we classify patients into three categories according to severity: intensive care, intermediate care, and normal care. The more severe the illness, the more activity is used. Nurses spend much more time with intermediate care patients than with normal care. The more severe patients tend to use more of the laundry service as well. Their clothing and bedding need to be changed more frequently. On the other hand, severe patients use less food. They eat fewer meals. Typically, we measure each patient type by the number of days of hospital stay. And you have to realize that the same patient contributes to each type of product. Required: Prepare an activity dictionary with three categories: activity name, activity description, and activity driver.arrow_forwardSEARCH ASK CHAT MATH SOLVER BUY Cornerstones of Cost Management (Cornerstones Series) 4th Edition ISBN: 9781305970663 Author: Don R. Hansen, Maryanne M. Mowen Publisher: Cengage Learning bookmark_border expand_more Chapter 8 : Budgeting For Planning And Control expand_more Section: Chapter Questions format_list_bulleted Problem 13CE: Nashler Company has the following budgeted variable costs per unit produced: Budgeted fixed overhead... See similar textbooks Concept explainers Question The following has been extracted from the financial records of ATF Limited: Annual budgeted capacity of the plant 40,000 units Production during the year 35,000 units Opening finished goods stock 3,000 units Closing finished…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.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
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,
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
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Relevant Costing Explained; Author: Kaplan UK;https://www.youtube.com/watch?v=hnsh3hlJAkI;License: Standard Youtube License