Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please answer detail. 4 questions per chegg policy Demand for oil changes at Garcia's Garage has been as follows: IT Month January February March April
please answer detail. 4 questions per chegg policy
Demand for oil changes at Garcia's Garage has been as follows: IT Month January February March April May June July August Number of Oil Changes 33 50 49 50 66 49 53 57 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 19 23 21 27 15 18 28 14 13 a. Prepare a forecast for weeks 6 through 10 by using a 4-week moving average. (Enter your responses rounded to two decimal places.) Week Forecast 6 Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with a = 0.8. Forecast the number of calls for week 6, which is next week. Week 1 2 3 4 5 Actual Service Calls 24 32 36 27 30 The forecast for week 6 is service calls. (Enter your response rounded to two decimal places.) Demand for oil changes at Garcia's Garage has been as follows: IT Month January February March April May June July August Number of Oil Changes 33 50 49 50 66 49 53 57 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 19 23 21 27 15 18 28 14 13 a. Prepare a forecast for weeks 6 through 10 by using a 4-week moving average. (Enter your responses rounded to two decimal places.) Week Forecast 6 Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with a = 0.8. Forecast the number of calls for week 6, which is next week. Week 1 2 3 4 5 Actual Service Calls 24 32 36 27 30 The forecast for week 6 is service calls. (Enter your response rounded to two decimal places.)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started