Essentials Of Business Analytics
1st Edition
ISBN: 9781285187273
Author: Camm, Jeff.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 5, Problem 21P
The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firm’s leading product over the past eight years:
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Use simple linear
regression analysis to find the parameters for the line that minimizes MSE for this time series. - c. What is the average cost increase that the firm has been realizing per year?
- d. Compute an estimate of the cost/unit for next year.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Midgett Co. has accumulated data to use in preparing its annual profit plan for the upcoming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff suggested that linear regression be employed to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis are as follows:
Month
MaintenanceCost
Machine Hours
Jan.
$
5,040
620
Feb.
3,648
420
Mar.
4,320
520
Apr.
3,331
390
May
5,221
650
June
3,550
400
July
3,655
430
Aug.
5,365
690
Sept.
5,110
640
Oct.
4,866
610
Nov.
3,944
460
Dec.
3,790
440
Sum
$
51,840
6,270
Average
$
4,320.00
522.50
Average cost per hour ($51,840/6,270) = $8.27 (rounded to the nearest cent)r = 0.99821r2 = 0.99780The percent of the total variance that can be…
Midgett Co. has accumulated data to use in preparing its annual profit plan for the upcoming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff suggested that linear regression be employed to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis are as follows:
Month
MaintenanceCost
Machine Hours
Jan.
$
5,000
600
Feb.
3,644
440
Mar.
4,400
610
Apr.
3,337
480
May
5,222
660
June
3,390
410
July
3,618
470
Aug.
5,384
630
Sept.
5,114
590
Oct.
4,883
590
Nov.
3,925
430
Dec.
3,850
350
Sum
$
51,767
6,260
Average
$
4,313.92
521.67
Average cost per hour ($51,767/6,260) = $8.27 (rounded to the nearest cent)
r = 0.85977
r2 = 0.73920
The percent of the total variance that…
Assume that the current date is February 1, 2021. The linear regression model was applied to a monthly time series data based on the last 24 months' sales. (From January 2019 through December 2020). The following partial computer output summarizes the results.
Coefficient
Estimate
t
Intercept
4.3
2.07
Slope
1.6
2.98
Determine the predicted sales for February.
Chapter 5 Solutions
Essentials Of Business Analytics
Ch. 5 - Consider the following time series data:
Using...Ch. 5 - Refer to the time series data in Problem 1. Using...Ch. 5 - Problems 1 and 2 used different forecasting...Ch. 5 - Consider the following time series data:
Compute...Ch. 5 - Consider the following time series...Ch. 5 - Consider the following time series...Ch. 5 - Prob. 8PCh. 5 - Prob. 9PCh. 5 - Prob. 10PCh. 5 - For the Hawkins Company, the monthly percentages...
Ch. 5 - Corporate triple A bond interest rates for 12...Ch. 5 - The values of Alabama building contracts (in...Ch. 5 - The following time series shows the sales of a...Ch. 5 - Prob. 15PCh. 5 - The following table reports the percentage of...Ch. 5 - Consider the following time series: a. Construct a...Ch. 5 - Consider the following time series:
Construct a...Ch. 5 - The Seneca Children’s Fund (SCF) is a local...Ch. 5 - The president of a small manufacturing firm is...Ch. 5 - Consider the following time series: a. Construct a...Ch. 5 - Consider the following time series...Ch. 5 - The quarterly sales data (number of copies sold)...Ch. 5 - Prob. 25PCh. 5 - South Shore Construction builds permanent docks...Ch. 5 - Hogs & Dawgs is an ice cream parlor on the border...Ch. 5 - Donna Nickles manages a gasoline station on the...Ch. 5 - The Vintage Restaurant, on Captiva Island near...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardOlympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forward
- Life Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300arrow_forwardTable 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?arrow_forwardDemand for Candy Bars In this problem you will determine a linear demand equation that describes the demand for candy bars in your class. Survey your classmates to determine what price they would be willing to pay for a candy bar. Your survey form might look like the sample to the left. a Make a table of the number of respondents who answered yes at each price level. b Make a scatter plot of your data. c Find and graph the regression line y=mp+b, which gives the number of respondents y who would buy a candy bar if the price were p cents. This is the demand equation. Why is the slope m negative? d What is the p-intercept of the demand equation? What does this intercept tell you about pricing candy bars? Would you buy a candy bar from the vending machine in the hallway if the price is as indicated. Price Yes or No 50 75 1.00 1.25 1.50 1.75 2.00arrow_forward
- Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to 2012. a. Let x represent time in years starting with x=0 for the year 1997. Let y represent the number of seals in thousands. Use logistic regression to fit a model to these data. b. Use the model to predict the seal population for the year 2020. c. To the nearest whole number, what is the limiting value of this model?arrow_forwardXYZ Corporation Stock Prices The following table shows the average stock price, in dollars, of XYZ Corporation in the given month. Month Stock price January 2011 43.71 February 2011 44.22 March 2011 44.44 April 2011 45.17 May 2011 45.97 a. Find the equation of the regression line. Round the regression coefficients to three decimal places. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict the stock price to be in January 2012? January 2013?arrow_forwardTable 3 gives the annual sales (in millions of dollars) of a product from 1998 to 20006. What was the average rate of change of annual sales (a) between 2001 and 2002, and (b) between 2001 and 2004?arrow_forward
- The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients. Complete parts a through c. E Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs = 5304.4 + (0.0219) × Billable Hours +1 (Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.) Monthly overhead costs and billable hours data Overhead Costs Billable Hours O IT $385,000 3,000 $430,000 4,000 $460,000 5,000 $511,000 6,000 $580,000 7,000 $600,000 8,000 Print Donearrow_forward9. NORTH-SOUTH AIRLINE CASE Northern Airline Data Engine Cost per Aircraft 43.49 Airframe Cost Average Age (Hours) 6,512 8,404 11,077 11,717 13,275 15,215 18,390 per Aircraft 51.80 Year 2001 2002 54.92 38.58 2003 69.70 51.48 2004 68.90 58.72 2005 63.72 45.47 2006 84.73 50.26 2007 78.74 79.60 Southeast Airline Data Engine Cost per Aircraft 18.86 Airframe Cost Average Age (Hours) 5,107 8,145 7,360 5,773 7,150 9,364 8,259 Year Per Aircraft 2001 13.29 2002 25.15 31.55 2003 32.18 40.43 2004 31.78 22.10 2005 25.34 19.69 2006 32.78 32.58 2007 35.56 38.07arrow_forwardThe following chart shows the actual sales for the last 12 months for a given company. Assume that sales are best fit by a linear trend and you can use single linear regression to set up a forecasting model. Using the sales data answer below questions (justify your answers): A.What would be the typical linear regression equation for the number of sales? B.Make the sales forecast for period 15 of next year. C. Make the sales forecast for period 17 of next year. D. What is the standard error for the data?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY