Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Management

Authors: Geert Bekaert, Robert J. Hodrick

2nd edition

013299755X, 132162768, 9780132997553, 978-0132162760

More Books

Students also viewed these Finance questions