5. The materials handling manager of a manufacturing company is trying to forecast the costof maintenance for the company's fleet of over-the-road tractors. The manager believesthat the cost of maintaining the tractors increases with their age. The following data werecollected.Age (years)4.54.54.54.04.04.05.05.05.5Yearly Maintenance Cost ($)6191,0491,0334957236818901,522987Age (years) Yearly Maintenance Cost ($)5.00.50.56.06.01.01.01.01,1941631827641,373978466549a. Use linear regression model to develop a relationship to forecast the yearly maintenancecost based on the age of a tractor (use Excel)b. If a section has a three-year old tractor, what is the forecast for the annual maintenancecost?

Linear regression is a statistical method that uses the straight line equation to analyze data and…

Answered: a. Use linear regression model to…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Q1) Forecasting is both art and science. Describe the situations where we use Qualitative forecasting techniques and quantitative forecasting techniques
Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. Gershon has collected the data shown in the following table: Maroon 5 TV Appearances Demand for Guitars Y = This exercise contains only parts b, c, and d. b) Using the least-squares regression method, the equation for forecasting is (round your responses to four decimal places): + 4 2 X 5 7 5 9 7 6 7 6 10 7
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: August 31 September 7 September 14 Week Of September 21 September 28 October 5 Week Of a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places). pints (round your b) Using a 3-week weighted moving average, with weights of 0.10, 0.35, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week of October 12 = response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 350 and x = 0.25, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). August 31 September 7 September 14…
Sales of the Crown Gems have been increasing over the past five years. The operations manager has estimated sales in 2017 to be 410 Crown Gems. Using exponential smoothing with a weight of α = 0.30, the forecasts for 2017 through 2022 were developed. The forecasts for 2017 through 2022 is: Year Forecast 2016 450 2017 450 2018 463.5 2019 479.85 2021 504.795 2022 528.5565 a. Advise Crown Gems of the benefits associated with this method of forecasting. b.Caution the manager on the limitations associated with your forecast.
a. Using POM for Windows' least squares-linear regression module, develop a relationship to forecast production ratings from test scores. (Round your responses to three decis and include a minus sign if necessary.) Y= - 23 + .945 x where Y = Production rating and X = Test score. b. If a worker's test score was 54, what would be your forecast of the worker's production rating? 51. (Enter your response as an integer.) c. Comment on the strength of the relationship between the test scores and production ratings. The coefficient of correlation for the least-squares regression model is and the coefficient of determination is (Enter your responses rounded to three decimal places.) More info Test Score Production Rating Production Test Worker Worker Rating Score A 55 43 K 58 57 B 38 43 75 75 93 87 67 48 D 86 77 31 26 E 88 82 62 49 F 66 68 24 25 G 55 47 Q 78 84 Clear all Check 50 46 34 32 41 41 51 58 J 69 74 T 39 30 Print Done LLMN OPoRS
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: S Week Of August 31 September 7 September 14 September 21 September 28 October 5 a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places) b) Using a 3-week weighted moving average, with weights of 0.15, 0.35, and 0.50, using 0.50 for the most recent week, the forecasted demand for the week of October 12 = order the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 350 and a = 0.30, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places) Week Of Pints Used Forecast for this Date 350 350.00 356.00 August 31 September 7 September 14 September 21 September 28 October 5 October 12 Pints…
4. The yearly demand for units manufactured by the Orion Company Limited has been as follows:Year Units Year Units1 520 5 8602 830 6 9403 520 7 9904 750 8 850Required:i. Prepare a forecast for year 5 through 8 by using a three-year simple moving average.What is the forecast for year 9?ii. Calculate the Cumulative Frequency Error (CFE), Mean Absolute Deviation (MAD),Mean Squared Error (MSE), and Mean Absolute Percentage Error (MAPE) as at the endof year 8.
The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City's many competitors. The manager has collected the following demand data for the past 8 months: Demand for Soft Shag Month Carpet (1,000 yd.) 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 Compute the exponentially smoothed forecast (a = .20) for the given data. Compute an adjusted exponentially smoothed forecast (with a = .20 and β = .20) for the given data
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year Mileage miles (round your response to the nearest whole number). a) Using a 2-year moving average, the forecast for year 6 = 1 3,050 2 4,000 3 3,450 4 3,750 5 3,750
3)The errors in a particular forecast are as follows: 3, -3, 4, 0, -2. What is the tracking signal for each period of the forecast? (use excel to show formulas )
Find the three-month moving average of the sales of shoes for this year.
(Use an excel file to show formulas used)

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

a. Use linear regression model to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor (use Excel) b. If a section has a three-year old tractor, what is the forecast for the annual maintenance cost?