# solution

Demand for oil changes at Garcia’s Garage has been as follows: Number of Oil Changes 39 44 Month January February March April May June July August \$ 8888 42 62 52 56 a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For January, let X = 1; for February, let X = 2; and so on The forecasting model is given by the equation Y = + X. (Enter your responses rounded to two decimal places.) Marianne Kramer, the owner of Handy Man Rentals, rents carpet cleaners to contractors and walk-in customers. She is interested in arriving at a forecast of rentals so that she can order the correct quantities of supplies that go with the cleaners. Data for the last 10 weeks are shown here. Week 1 2 3 4 5 6 7 8 9 10 Rentals 17 23 30 22 19 19 25 32 17 10 a. Prepare a forecast for weeks 6 through 10 by using a 4-week moving average. (Enter your responses rounded to two decimal places.) Forecast Week 6