Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN: 9781337115773
Author: Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 3, Problem 45E
Scattergraph Method
Refer to the information for Luisa Crimini above.
Required:
CONCEPTUAL CONNECTION Prepare a scattergraph based on Luisa’s data. Use monthly cost for the vertical axis and number of appointments for the horizontal axis. Based on an examination of the scattergraph, does there appear to be a linear relationship between the cost of tanning services and the number of appointments?
Use the following information for Exercises 3-44 through 3-46:
Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows:
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Please help answer the Income statement. Use the data at the top of the schedule to complete the report. use the data from your cost of services provided schedule. The cost to use is:
Daycare $18 - 22 dogs per day
Boarding $25 - 12 dogs per day
Grooming $25 - 4 grooms per day
Penny is compiling a list of costs incurred so far on a project. She must categorize these costs so that she can present the amount of direct cost incurred. Which of the following should Penny include in this list?This type of question contains radio buttons and checkboxes for selection of options. Use Tab for navigation and Enter or space to select the option. option A Expense incurred in meeting the regulatory standards for the company option B Benefits for employees in the organization option C Travel expenses to the customer’s office option D Costs incurred for maintaining coffee stations around the office.
The controller of the Blade Company wants you to estimate a cost function from the following two observations in a general ledger account called Maintenance:
(Click to view the information.)
Required
1. Estimate the cost function for maintenance.
2. Can the constant in the cost function be used as an estimate of fixed maintenance cost per month? Explain.
Requirement 1. Estimate the cost function for maintenance. (Round your answers to the nearest cent as needed.)
Maintenance costs =
Maintenance costs =
+(
+(
X
X
Requirement 2. Can the constant in the cost function be used as an estimate of fixed maintenance cost per month? Explain.
the relevant range, not at cost levels
the relevant range. If there are no months with zero
The cost function in requirement 1 is an estimate of how costs behave
machine-hours represented in the maintenance account, data in that account
function provides the best available starting point for a straight line that approximates how a cost behaves
be used to…
Chapter 3 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
Ch. 3 - Prob. 1DQCh. 3 - What is a driver? Give an example of a cost and...Ch. 3 - Suppose a company finds that shipping cost is...Ch. 3 - Some firms assign mixed costs to either the fixed...Ch. 3 - Explain the difference between committed and...Ch. 3 - Explain why the concept of relevant range is...Ch. 3 - Why do mixed costs pose a problem when it comes to...Ch. 3 - Describe the cost formula for a strictly fixed...Ch. 3 - Describe the cost formula for a strictly variable...Ch. 3 - What is the scattergraph method, and why is it...
Ch. 3 - Describe how the scattergraph method breaks out...Ch. 3 - What are the advantages of the scattergraph method...Ch. 3 - Prob. 13DQCh. 3 - What is meant by the best-fitting line?Ch. 3 - What is the difference between the unit cost of a...Ch. 3 - Prob. 16DQCh. 3 - (Appendix 3A) Explain the meaning of the...Ch. 3 - A factor that causes or leads to a change in a...Ch. 3 - Which of the following would probably be a...Ch. 3 - Prob. 3MCQCh. 3 - In the cost formula, the term 128,000,000 a. is...Ch. 3 - In the cost formula, the term 12,000 a. is the...Ch. 3 - Prob. 6MCQCh. 3 - Prob. 7MCQCh. 3 - The following cost formula for total purchasing...Ch. 3 - An advantage of the high-low method is that it a....Ch. 3 - Prob. 10MCQCh. 3 - Prob. 11MCQCh. 3 - Prob. 12MCQCh. 3 - The total cost for monthly supervisory cost in a...Ch. 3 - Yates Company shows the following unit costs for...Ch. 3 - (Appendix 3A) In the method of least squares, the...Ch. 3 - Creating and Using a Cost Formula Big Thumbs...Ch. 3 - Using High-Low to Calculate Fixed Cost, Calculate...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Using Regression to Calculate Fixed Cost,...Ch. 3 - Inventory Valuation under Absorption Costing Refer...Ch. 3 - Inventory Valuation under Variable Costing Refer...Ch. 3 - Absorption-Costing Income Statement Refer to the...Ch. 3 - Variable-Costing Income Statement Refer to the...Ch. 3 - Creating and Using a Cost Formula Kleenaire Motors...Ch. 3 - Using High-Low to Calculate Fixed Cost, Calculate...Ch. 3 - Using High-Low to Calculate Predicted Total...Ch. 3 - Brief Exercise 3-28 Using High-Low to Calculate...Ch. 3 - Using Regression to Calculate Fixed Cost,...Ch. 3 - Inventory Valuation under Absorption Costing Refer...Ch. 3 - Inventory Valuation under Variable Costing Refer...Ch. 3 - Brief Exercise 3-32 Absorption-Costing Income...Ch. 3 - Brief Exercise 3-33 Variable-Costing Income...Ch. 3 - Variable and Fixed Costs What follows are a number...Ch. 3 - Cost Behavior, Classification Smith Concrete...Ch. 3 - Prob. 36ECh. 3 - Prob. 37ECh. 3 - Prob. 38ECh. 3 - Step Costs, Relevant Range Bellati Inc. produces...Ch. 3 - Matching Cost Behavior Descriptions to Cost...Ch. 3 - Examine the graphs in Exercise 3-40. Required: As...Ch. 3 - Prob. 42ECh. 3 - Prob. 43ECh. 3 - High-Low Method Refer to the information for Luisa...Ch. 3 - Scattergraph Method Refer to the information for...Ch. 3 - Method of Least Squares Refer to the information...Ch. 3 - Use the following information for Exercises 3-47...Ch. 3 - Use the following information for Exercises 3-47...Ch. 3 - Method of Least Squares, Developing and Using the...Ch. 3 - The method of least squares was used to develop a...Ch. 3 - Identifying the Parts of the Cost Formula;...Ch. 3 - Inventory Valuation under Absorption Costing...Ch. 3 - Inventory Valuation under Variable Costing Lane...Ch. 3 - Income Statements under Absorption and Variable...Ch. 3 - (Appendix 3A) Method of Least Squares Using...Ch. 3 - (Appendix 3A) Method of Least Squares Using...Ch. 3 - Identifying Fixed, Variable, Mixed, and Step Costs...Ch. 3 - Identifying Use of the High-Low, Scattergraph, and...Ch. 3 - Identifying Variable Costs, Committed Fixed Costs,...Ch. 3 - Scattergraph, High-Low Method, and Predicting Cost...Ch. 3 - Method of Least Squares, Predicting Cost for...Ch. 3 - Cost Behavior, High-Low Method, Pricing Decision...Ch. 3 - Prob. 63PCh. 3 - Variable and Fixed Costs, Cost Formula, High-Low...Ch. 3 - Cost Separation About 8 years ago, Kicker faced...Ch. 3 - Variable-Costing and Absorption-Costing Income...Ch. 3 - Refer to the information for Farnsworth Company...Ch. 3 - (Appendix 3A) Scattergraph, High-Low Method,...Ch. 3 - (Appendix 3A) Separating Fixed and Variable Costs,...Ch. 3 - (Appendix 3A) Cost Formulas, Single and Multiple...Ch. 3 - Suspicious Acquisition of Data, Ethical Issues...
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
- Method of Least Squares Refer to the information for Luisa Crimini on the previous page. Required: 1. Using a computer spreadsheet program such as Excel, run a regression on these data. Based on the regression output, write the cost formula for tanning. (Note: Round the fixed cost to the nearest dollar and the variable rate to the nearest cent.) 2. Using the formula computed in Requirement 1, what is the predicted cost of tanning services for September for 2,500 appointments? Use the following information for Exercises 3-44 through 3-46: Luisa Crimini has been operating a beauty shop in a college town for the past 10 years. Recently, Luisa rented space next to her shop and opened a tanning salon. She anticipated that the costs for the tanning service would primarily be fixed, but found that tanning salon costs increased with the number of appointments. Costs for this service over the past 8 months are as follows:arrow_forwardLinear cost approximation. Dr. Young, of Young and Associates, LLP, is examining how overhead costs behave as a function of monthly physician contact hours billed to patients. The historical data are as follows:arrow_forwardWhich 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 methodarrow_forward
- Classify each of the cost items as one of the business functions of the value chain in “Payment of booth registration fee at a medical conference to promote new products to physicians.”arrow_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_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
- Convert the accompanying database to an Excel table to find: a.The total cost of all orders. b.Thetotal quantity of airframe fasteners purchased. c. The total cost of all orders placed with Manley Valve. Question content area bottom Part 1 a. The total cost of all orders is $?????? enter your response here.arrow_forwardJohnson Filtration. Inc., provides maintenance service for water filtration systems throughout southern Florida. Customers contact Johnson with requests for maintenance service on their water filtration systems. To estimate the service time and the service cost. Johnson’s managers want to predict the repair time necessary for each maintenance request. Hence, repair time in hours is the dependent variable. Repair time is believed to be related to three factors: the number of months since the last maintenance service, the type of repair problem (mechanical or electrical), and the repairperson who performs the repair (Donna Newton or Bob Jones). Data for a sample of 10 service calls are reported in the following table: Develop the simple linear regression equation to predict repair time given the number of months since the last maintenance service, and use the results to test the hypothesis that no relationship exists between repair time and the number of months since the last maintenance service at the 0.05 level of significance. What is the interpretation of this relationship? What does the coefficient of determination tell you about this model? Using the simple linear regression model developed in part (a), calculate the predicted repair time and residual for each of the 10 repairs in the data. Sort the data in ascending order by value of the residual. Do you see any pattern in the residuals for the two types of repair? Do you see any pattern in the residuals for the two repairpersons? Do these results suggest any potential modifications to your simple linear regression model? Now create a scatter chart with months since last service on the x-axis and repair time in hours on the y-axis for which the points representing electrical and mechanical repairs are shown in different shapes and/or colors. Create a similar scatter chart of months since last service and repair time in hours for which the points representing repairs by Bob Jones and Donna Newton are shown in different shapes and/or colors. Do these charts and the results of your residual analysis suggest the same potential modifications to your simple linear regression model? Create a new dummy variable that is equal to zero if the type of repair is mechanical and one if the type of repair is electrical. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the type of repair. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Create a new dummy variable that is equal to zero if the repairperson is Bob Jones and one if the repairperson is Donna Newton. Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Develop the multiple regression equation to predict repair time, given the number of months since the last maintenance service, the type of repair, and the repairperson. What are the interpretations of the estimated regression parameters? What does the coefficient of determination tell you about this model? Which of these models would you use? Why?arrow_forwardA two-sample test for means was conducted to determine if the completion time for continuing education programs for nurses differed when costs are paid by employers (Yes) versus when individuals paid out of their own funds (No). The Excel Data Analysis tool results are provided. Complete parts a through c below Click the icon to view the Excel Data Analysis tool results. a. Explain how to use this information to draw a conclusion if the null hypothesis is Hoy - 50. Clearly state the correct cribcal value and p-value and your conclusion. The alternative hypothesis is H₁: The p-value is (Type an integer or a decimal rounded to Bree decimal places as needed.) Therefore, the null hypothesis. The data provide sufficient evidence to conclude that the mean completion time is Excel Data Analysis tool results t-Test Two-Sample Assuming Unequal VananDES Mean Variance Yes 34.081 445.045 No 28.601 348.065 for nurses when costs are paid by employers. Observations 12 8 Hypothesized Mean Difference 0…arrow_forward
- The total number of term life insurance contracts sold in Problem 13 is 199. The following pie chart shows the percentages of contracts sold by each salesperson. a. What are the problems with using a pie chart to display these data? b. What type of chart would be preferred for displaying the data in this pie chart? c. Use a different type of chart to display the percentage of contracts sold by each salesperson that conveys the data better than the pie chart. Format the chart and add data labels to improve the charts readability.arrow_forwardMementos Academy is assessing whether to outsource its student enrolment processes. The general process followed by staff in the enrolment office is to first validate students’ prior academic record (e.g., secondary school results) and send an offer of enrolment, provide degree advice and enter students’ study program details into the student record system, and collect fees. The following table shows the costs associated with these three processes: Cost Validation Student records Fees collection Staff salaries 70,400 43,900 39,700 Data processing 9,200 32,500 7,900 Telephone 1,700 4,600 3,000 Postage - 1,500 4,000 Consumables 3,700 45,900 11,800 Electricity 1,600 3,100 3,000 Equipment depreciation 12,200 35,800 31,900 Insurance…arrow_forwardThe Human Resources Manager for Optilytics LLC is evaluating applications for the position of Senior Data Scientist. The file OptilyticsLLC presents summary data of the applicants for the position. a. Use a PivotTable in Excel to create a joint probability table showing the probabilities associated with a randomly selected applicants sex and highest degree achieved. Use this joint probability table to answer the questions below. b. What are the marginal probabilities? What do they tell you about the probabilities associated with the sex of applicants and highest degree completed by applicants? c. If the applicant is female, what is the probability that the highest degree completed by the applicant is a PhD? d. If the highest degree completed by the applicant is a bachelors degree, what is the probability that the applicant is male? e. What is the probability that a randomly selected applicant will be a male whose highest completed degree is a PhD?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 Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher: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
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
What is Risk Management? | Risk Management process; Author: Educationleaves;https://www.youtube.com/watch?v=IP-E75FGFkU;License: Standard youtube license