Managerial Accounting
3rd Edition
ISBN: 9780077826482
Author: Stacey M Whitecotton Associate Professor, Robert Libby, Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 5, Problem 1.4GAP
To determine
Introduction:
Least-square regression:
It is a statistical technique that shows the best fitting line between the X-axis and the Y-axis. It helps minimize the sum squared errors between the regression line and the actual data.
To prepare:
Least-square regression analysis.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Tempe Office Services and Supplies (TOSS) provides various products and services in the Tempe
Research Park, home to numerous high-tech and bio-tech companies. Making color copies is one of its
most popular and profitable services. The controller performed a regression analysis of data from the
Color Copy Department with the following results:
Intercept
R-squared
Number of observations
X coefficient
Month
July
August
September
October
November
December
The regression output was based on the following data:
Number of
Color
Copies
25,900
23,000
19,550
18, 150
22,150
20,400
Req 1
30.874686
0.970922
Req 2
6
0.081144
Required:
1. What is the variable cost per color copy for TOSS?
2. What is the fixed cost for the Color Copy Department?
3. Based on the regression output obtained by the controller, what cost formula should be used to
estimate future total costs for the Color Copy Department? Enter answer as an equation in the form of y=
a + bx.
Variable cost per color copy
Fixed cost
Color…
Tempe Office Services and Supplies (TOSS) provides various products and services in the Tempe
Research Park, home to numerous high-tech and bio-tech companies. Making color copies is one of its
most popular and profitable services. The controller performed a regression analysis of data from the
Color Copy Department with the following results:
Intercept
R-squared
Number of observations
X coefficient
Month
July
August
September
October
November
December
The regression output was based on the following data:
Number of Color Copy
Color
Copies
25,900
23,000
19,550
18, 150
22,150
20,400
30.874686
0.970922
Req 1
6
0.081144
Required:
1. What is the variable cost per color copy for TOSS?
2. What is the fixed cost for the Color Copy Department?
3. Based on the regression output obtained by the controller, what cost formula should be used to
estimate future total costs for the Color Copy Department? Enter answer as an equation in the form of y=
a + bx.
Req 2
Variable cost
Department
Costs
$…
The Iowa City Veterinary Laboratory performs a variety of diagnostic tests on commercial and domestic animals. The lab has incurred the following costs over the past year.
Required:1. Plot the data above in a scatter diagram. Assign cost to the vertical axis and the number of diagnostic tests to the horizontal axis. Visually fit a line to the plotted data.2. Using the visually fit line, estimate the monthly fixed cost and the variable cost per diagnostic test.
Chapter 5 Solutions
Managerial Accounting
Ch. 5 - Define each of the following terms variable cost,...Ch. 5 - Prob. 2QCh. 5 - Prob. 3QCh. 5 - Prob. 4QCh. 5 - Prob. 5QCh. 5 - Describe the three methods used to estimate cost...Ch. 5 - Prob. 7QCh. 5 - Prob. 8QCh. 5 - Prob. 9QCh. 5 - Prob. 10Q
Ch. 5 - Prob. 11QCh. 5 - Prob. 12QCh. 5 - Prob. 13QCh. 5 - Prob. 14QCh. 5 - Which of the following increases when activity...Ch. 5 - Prob. 2MCCh. 5 - Prob. 3MCCh. 5 - Consider the following information for a local...Ch. 5 - Prob. 5MCCh. 5 - Prob. 6MCCh. 5 - Prob. 7MCCh. 5 - Prob. 8MCCh. 5 - Prob. 9MCCh. 5 - Hathaway Corp, manufactures garden hoses. Last...Ch. 5 - Identifying Cost Behavior Heather Oak is trying to...Ch. 5 - Prob. 2MECh. 5 - Defining Cost Behavior Match each of the following...Ch. 5 - Prob. 4MECh. 5 - Defining Terms for the High-Low Method Indicate...Ch. 5 - Prob. 6MECh. 5 - Prob. 7MECh. 5 - Prob. 8MECh. 5 - Prob. 9MECh. 5 - Prob. 10MECh. 5 - Prob. 11MECh. 5 - Prob. 12MECh. 5 - Prob. 13MECh. 5 - Prob. 14MECh. 5 - Prob. 15MECh. 5 - Prob. 16MECh. 5 - Compare full absorption costing to variable...Ch. 5 - Identifying Cost Behavior Patterns Steve...Ch. 5 - Prob. 2ECh. 5 - Prob. 3ECh. 5 - Prob. 4ECh. 5 - Estimating Cost Behavior Using High-Low Method...Ch. 5 - Prob. 6ECh. 5 - Prob. 7ECh. 5 - Prob. 8ECh. 5 - Prob. 9ECh. 5 - Estimating Cost Behavior Using Scattergraph and...Ch. 5 - Estimating Cost Behavior Using Least-Squares...Ch. 5 - Comparing High-Low Method and Least-Squares...Ch. 5 - Preparing Contribution Margin Income Statement...Ch. 5 - Determining Cost Behavior, Preparing Contribution...Ch. 5 - Prob. 15ECh. 5 - Prob. 16ECh. 5 - Prob. 17ECh. 5 - Prob. 18ECh. 5 - Comparing Full Absorption Costing and Variable...Ch. 5 - Estimating Cost Behavior Using Least-Squares...Ch. 5 - Prob. 1.1GAPCh. 5 - Prob. 1.2GAPCh. 5 - Prob. 1.3GAPCh. 5 - Prob. 1.4GAPCh. 5 - Prob. 1.5GAPCh. 5 - Prob. 1.6GAPCh. 5 - Prob. 2.1GAPCh. 5 - Prob. 2.2GAPCh. 5 - Prob. 2.3GAPCh. 5 - Prob. 2.4GAPCh. 5 - Prob. 2.5GAPCh. 5 - Prob. 2.6GAPCh. 5 - Prob. 2.7GAPCh. 5 - Prob. 3.1GAPCh. 5 - Prob. 3.2GAPCh. 5 - Prob. 3.3GAPCh. 5 - Prob. 3.4GAPCh. 5 - Prob. 3.5GAPCh. 5 - Prob. 4.1GAPCh. 5 - Prob. 4.2GAPCh. 5 - Prob. 4.3GAPCh. 5 - Comparing Full Absorption and Variable Costing...Ch. 5 - Comparing Full Absorption and Variable Costing...Ch. 5 - Prob. 5.3GAPCh. 5 - Prob. 6.1GAPCh. 5 - Prob. 6.2GAPCh. 5 - Prob. 6.3GAPCh. 5 - Prob. 6.4GAPCh. 5 - Prob. 6.5GAPCh. 5 - Prob. 6.6GAPCh. 5 - Prob. 1.1GBPCh. 5 - Prob. 1.2GBPCh. 5 - Prob. 1.3GBPCh. 5 - Prob. 1.4GBPCh. 5 - Estimating Cost Behavior Using Scattergraph,...Ch. 5 - Prob. 1.6GBPCh. 5 - Prob. 2.1GBPCh. 5 - Estimating Cost Behavior Using Scattergraph,...Ch. 5 - Prob. 2.3GBPCh. 5 - Prob. 2.4GBPCh. 5 - Prob. 2.5GBPCh. 5 - Prob. 2.6GBPCh. 5 - Prob. 2.7GBPCh. 5 - Prob. 3.1GBPCh. 5 - Prob. 3.2GBPCh. 5 - Prob. 3.3GBPCh. 5 - Prob. 3.4GBPCh. 5 - Prob. 3.5GBPCh. 5 - Prob. 4.1GBPCh. 5 - Prob. 4.2GBPCh. 5 - Prob. 4.3GBPCh. 5 - Prob. 5.1GBPCh. 5 - Prob. 5.2GBPCh. 5 - Prob. 5.3GBPCh. 5 - Prob. 6.1GBPCh. 5 - Prob. 6.2GBPCh. 5 - Prob. 6.3GBPCh. 5 - Prob. 6.4GBPCh. 5 - Prob. 6.5GBPCh. 5 - Prob. 6.6GBP
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
- A 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_forwardDeMarco Company is developing a cost formula for its packing activity. Discussion with the workers in the Packing Department has revealed that packing costs are associated with the number of customer orders, the size of the orders, and the relative fragility of the items (more fragile items must be specially wrapped in bubble wrap and Styrofoam). Data for the past 20 months have been gathered: Required: 1. Using the method of least squares, run a regression using the number of orders as the independent variable. 2. Run a multiple regression using three independent variables: the number of orders, the weight of orders, and the number of fragile items. Which regression equation is better? Why? 3. Predict the total packing cost for 25,000 orders, weighing 40,000 pounds, with 4,000 fragile items.arrow_forwardMethod 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_forward
- High-low method; regression analysis. (CIMA, adapted) Catherine McCarthy, sales manager of Baxter Arenas, is checking to see if there is any relationship between promotional costs and ticket revenues at the sports stadium. She obtains the following data for the past 9 months:arrow_forwardJensen Tire Auto is deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. What does the scatter chart indicate about the relationship between weekly usage and annual maintenance expense? b. Use the data to develop an estimated regression equation that could be used to predict the annual maintenance expense for a given number of hours of weekly usage. What is the estimated regression model? c. Test whether each of the regression parameters 0 and 1 is equal to zero at a 0.05 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? d. How much of the variation in the sample values of annual maintenance expense does the model you estimated in part (b) explain? e. If the maintenance contract costs 3,000 per year, would you recommend purchasing it? Why or why not?arrow_forwardA brand manager for ColPal Products must determine how much time to allocate between radio and television advertising during the next month. Market research has provided information on audience exposure, which the manager would like to maximize. After reviewing the research, the manager found the following linear optimization model for audience exposure, where x is the number of minutes of radio ads and y is the number of minutes of TV ads. Graph the constraints and identify the feasible region. Then identify each of the corner points and show how increasing the objective function value identifies the optimal solution. Maximize Exposure = 360x+790y 400x+2000y ≤24,000 x-3y ≤0 x20 and y 20 remory the graph of the feasible region. Chouse the corell graph below. OA Ay 20- OB. 10- G '50' 100 Identify the vertices of the given feasible region. 45 15 (0,0). (0,12) 2 2 Q Q 20- 20 20- 10- G '50' 100 50 100 10- G (Type an ordered pair, using integers or decimals rounded to two decimal places as…arrow_forward
- Log Cabins Unlimited constructs vacation houses in the North Carolina mountains. The company has developed the following value chart: a. How much of the total time is value-added time? ______ hours b. How much total time is spent performing non-value-added activities? ______ hours c. Calculate the manufacturing cycle efficiency of the process. Note: Round the percentage to one decimal point (i.e. show 14.445% as 14.4%). ______%arrow_forwardNicholson Co sells mobile telephones. It supplies its customers with telephones and wireless telephone connections. Customers pay an annual fee plus a monthly charge based on calls made. The company has recently employed a consultant to install a balanced scorecard system of performance measurement and to benchmark the results against those of Nicholson Co's competitors. Unfortunately the consultant was called away before the work was finished. You have been asked to complete the work. The following data is available. Nicholson Co Operating data for the year ended 30 November 2013 Sales revenue $480 million Sales attributable to new products $8 million Average capital employed $192 million Profit before interest and tax $48 million Average number of customers 1,960,000 Average number of telephones returned for repair each day 10,000 Number of bill queries 12,000 Number of customer complaints 21,600 Number of customers lost 117,600 Average number of telephones unrepaired at the end of…arrow_forwardNicholson Co sells mobile telephones. It supplies its customers with telephones and wireless telephone connections. Customers pay an annual fee plus a monthly charge based on calls made.The company has recently employed a consultant to install a balanced scorecard system of performance measurement and to benchmark the results against those of Nicholson Co’s competitors. Unfortunately the consultant was called away before the work was finished. You have been asked to complete the work. The following data is available.Nicholson Co Operating data for the year ended 30 November 2013 Sales revenue $480 millionSales attributable to new products $8 millionAverage capital employed $192 millionProfit before interest and tax $48 millionAverage numbers of customers 1,960,000Average number of telephones returned for repair each year 10,000Number of bill queries 12,000Number of customer complaints 21,600Number of customers lost 117,600Average number of telephones unrepaired at the end of each day…arrow_forward
- Nicholson Co sells mobile telephones. It supplies its customers with telephones and wireless telephone connections. Customers pay an annual fee plus a monthly charge based on calls made. The company has recently employed a consultant to install a balanced scorecard system of performance measurement and to benchmark the results against those of Nicholson Co's competitors. Unfortunately the consultant was called away before the work was finished. You have been asked to complete the work. The following data is available. Nicholson Co Operating data for the year ended 30 November 2013 Sales revenue $480 million Sales attributable to new products $8 million Average capital employed $192 million Profit before interest and tax $48 million Average number of customers 1,960,000 Average number of telephones returned for repair each day 10,000 Number of bill queries 12,000 Number of customer complaints 21,600 Number of customers lost 117,600 Average number of telephones unrepaired at the end of…arrow_forwardNicholson Co sells mobile telephones. It supplies its customers with telephones and wireless telephone connections. Customers pay an annual fee plus a monthly charge based on calls made. The company has recently employed a consultant to install a balanced scorecard system of performance measurement and to benchmark the results against those of Nicholson Co's competitors. Unfortunately the consultant was called away before the work was finished. You have been asked to complete the work. The following data is available. Nicholson Co Operating data for the year ended 30 November 2013 Sales revenue $480 million Sales attributable to new products $8 million Average capital employed $192 million Profit before interest and tax $48 million Average number of customers 1,960,000 Average number of telephones returned for repair each day 10,000 Number of bill queries 12,000 Number of customer complaints 21,600 Number of customers lost 117,600 Average number of telephones unrepaired at the end of…arrow_forwardThe Port Authority sells a wide variety of cables and adapters for electronic equipment online. Last year the mean value of orders placed with the Port Authority was 47.28, and management wants to assess whether the mean value of orders placed to date this year is the same as last year. The values of a sample of 49,896 orders placed this year are collected and recorded in the tile PortAuthority. a. Formulate hypotheses that can be used to test whether the mean value of orders placed this year differs from the mean value of orders placed last year. b. Use the data in the file PortAuthority to conduct your hypothesis test. What is the p value for your hypothesis test? At = 0.01, what is your conclusion?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 LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher: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,
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 (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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
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,
How to Estimate Project Costs: A Method for Cost Estimation; Author: Online PM Courses - Mike Clayton;https://www.youtube.com/watch?v=YQ2Wi3Jh3X0;License: Standard Youtube License