Part B? The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The managerbelieves that the cost of maintaining the tractors increases with their age. The following data was collected:YearlyMaintenanceCost (S)YearlyMaintenanceCost ($)1,794Age(years)Age(years)6.51,2191,6496.07.52.57636.51,6332.57825.01,0959.01.3646.01,3238.01,9736.01,2813.01,5788.01,4903.01,0662,1221,5877.03.01,1497.5a. Use POM for Windows' least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor. (Enter yourresponses rounded to three decimal places and include a minus sign if necessary.)Y = 744.346 + 115.609'xwhere Y = Yearly maintenance cost in dollars and X= Age in years.b. If a section has 20 three-year-old tractors, what is the forecast for the annual maintenance cost? $ 3056.53. (Enter your response rounded to two decimal places.)

a)The POS for Windows regression model is as follows

The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data was collected: Age (years) Yearly Maintenance Cost ($) Age (years) Yearly Maintenance Cost ($) 6.5 1,219 6.0 1,794 7.5 1,649 2.5 763 6.5 1,633 2.5 782 5.0 1,095 9.0 1,364 6.0 1,323 8.0 1,973 1,578 1,066 1,149 6.0 1,281 3.0 8.0 1,490 3.0 2,122 1,587 7.0 3.0 7.5 a. Use POM for Windows' least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor. (Enter your responses rounded to three decimal places and include a minus sign if necessary.) Y = 744.346 + 115.609'x where Y = Yearly maintenance cost in dollars and X= Age in years. b. If a section has 20 three-year-old tractors, what is the forecast for the annual maintenance cost? $ 3056.53. (Enter your response rounded to two decimal places.)

The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data was collected: Age (years) Yearly Maintenance Cost ($) Age (years) Yearly Maintenance Cost ($) 6.5 1,219 6.0 1,794 7.5 1,649 2.5 763 6.5 1,633 2.5 782 5.0 1,095 9.0 1,364 6.0 1,323 8.0 1,973 1,578 1,066 1,149 6.0 1,281 3.0 8.0 1,490 3.0 2,122 1,587 7.0 3.0 7.5 a. Use POM for Windows' least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor. (Enter your responses rounded to three decimal places and include a minus sign if necessary.) Y = 744.346 + 115.609'x where Y = Yearly maintenance cost in dollars and X= Age in years. b. If a section has 20 three-year-old tractors, what is the forecast for the annual maintenance cost? $ 3056.53. (Enter your response rounded to two decimal places.)

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

The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the tractors increases with their age. The following data was collected: Yearly Maintenance Yearly Maintenance Age (years) Age (years) Cost ($) Cost (S) 6.5 819 8.0 1,394 5.5 1,249 2.5 363 6.5 1,233 2.5 382 7.0 695 9.0 964 6.0 923 8.0 1,573 6.0 881 3.0 1,178 7.0 1,090 3.0 666 7.0 1,722 3.0 749 7.5 1,187 a. Use POM for Windows' least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor. (Enter your responses rounded to three decimal places and include a minus sign if necessary.) Y = 365.727 + 110,721 X where Y = Yearly maintenance cost in dollars and X= Age in years. b. If a section has 20 four-year-old tractors, what is the forecast for the annual maintenance cost? $ |- (Enter your response rounded to two…
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $14.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR I II III IV QUANTITY (UNITS) Y = 14 20 28 18 QUARTER THIS YEAR I II III IV QUANTITY (UNITS) 20 26 30 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. 18.535 X + 0.630 t
From the following time series data of sale project the sales for the next three years. Year 2001 2002 2003 2004 2005 2006 2007 Sales (*000 units) 80 90 92 83 94 99 92
An avant-garde clothing manufacturer runs a series of high-profile, risque ads on a billboard on Highway 101 and regularly collects protest calls from people who are offended by them. The company has no idea how many people in total see the ad, but it has been collecting statistics on the number of phone calls from irate viewers: a) Choose the correct Pareto chart below. O A. Frequency (number) LL WROMI O B. Frequency (number) Type R M W I O Description Offensive racially/ethnically Demeaning to men Demeaning to women Ad is Incomprehensible Other RMWO Frequency (number) LONDO Number of Complaints 12 4 13 2 7 WROMI O Frequency (number) OFONSO 12- RM WIO
1.The reported unemployment is 5.5% of the population. What measurement scale is used to measure unemployment? Interval Nominal Ordinal Ratio 2.Which one of the following is NOT an example of discrete data? Number of employees reporting in sick Number of households watching the Home Shopping Network Number of miles between New York City and Chicago Number of members of the Denver Lions Club
Question 2: Consider again that the company making tires for bikes is concerned about the exact width of its cyclocross tires. The company has a lower specification limit of 22.8 mm and an upper specification limit of 23.2 mm. The standard deviation is 0.15 mm and the mean is 23 mm. What is the probability that a tire will either be too wide or too narrow?
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $0.5 million each. Sales for these NCMS for the past two years were as follows: Use Exhibit 18.10. LAST YEAR THIS YEAR QUANTITY (UNITS) QUANTITY QUARTER (UNITS) QUARTER I 11 I 16 II 17 II 23 III 25 III 27 IV 15 IV 18 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) Y = b. Compute trend and seasonal factor from a linear regression line obtained with Excel. (Do not round intermediate calculations. Round your answers to 3 decimal places.) Period Trend Forecast Seasonal Factors Last Year II IV This Year II III IV
DFC Company has recorded the past years sales for the company: Year(t) Sales(x) (in Million Pesos) 2011(1) 2012(2) 2013(3) 2014(4) 2015(5) 2016(6) 2017(7) 2018(8) 2019(9) 2020(10) 219 224 268 272 253 284 254 278 282 298 Use the naïve model. Compute for MAE and MSE Use a three period moving average. Compute for the MAE and MSE Use the simple exponential smoothing to make a forecasting table. Compute the MAE and MSE of the forecasts. Alpha = 0.1 Use the least square method to make the forecasting table. Compute the MAE and MSE *** Use excel or r programming
Specifying the statistical test
Calculate the Mean Absolute Percentage Error for the following data: Actual 91 86 87 97 Forecast 91.3 86.3 98.1 99.5 (Keep two decimal places in your answer)
A well-known multinational FMCG produces more than fifty products and sells them in the market. Out of fifty products one is mineral water for drinking purpose and supplies different size pack bottles in the market. Product manager observed that, during hot days the sale of water is more as compared to the normal days. He started the collection of data of weekly sale of water and the average weekly temperature. Product manager was interested in developing a relationship between sales and temperature; therefore, he discussed and shared the following data with you
Records pertaining to the monthly number of job-related injuries at an underground coal mine were being studied by a government agency. The values for the past 100 months were as follows: Injuries Frequency of per Month Occurrence 32 40 2 15 3 4 1. 1. Apply the chi-square test to these data to test the hypothesis that the underlying distribution is Poisson. Important note: In the answer box below, just put the numerical test statistic value. Use x.xx format for the numerical value you provide as the answer. Do NOT compare the test statistic with the critical value from a table. Answer: