Question 1
Debonair's Pizza is a small restaurant catering to patrons with a taste of African pizza. One of its specialties is Name) Desert Prize Pizza. Martha Kamutenya. manager of Debonair's Pizza, must forecast weekly demand for those special pizzas so that she can order the correct amount of pizza shells weekly. Recently. the demand has been as follows.
Week Number of Polish Prize Pizzas sold
September 1 50
September 8 65
September 15 52
September 22 60
September 29 70
October 6 60
Required
a) Forecast the demand for Name, Desert Prize Pizza for September 22 - October 6. using the 3 period moving average method. Note: Round up all the forecasts to two decimal places
b) Forecast the demand for September 22 - October 6. using weights of 0.5. 0.3. 0.2 for the most recent. next recent. and most distant data. respectively.
c) Assume that the forecast for September 1 to be 55. Forecast the demand for September 8-October 6 using the exponential smoothing method with a = 0.3.
d) Now. forecast the demand for September 8-October 6 using the exponential smoothing method with a = 0.6. How do they compare to that in part (c)?
Question 2
The Windhoek Central hospital is considering the purchase of a new ambulance for its patients.
The decision veil rest partly on the anticipated mileage to be driven next year. 2019. The kilometers driven during the past 5 years are as follows.
|
Year
|
Kilometers
|
|
1
|
3000
|
|
2
|
4000
|
|
3
|
3400
|
|
4
|
3800
|
|
5
|
3700
|
a. Forecast the mileage for the next year using a 2 year moving average
b. Find the MAD based on the 2 year moving average forecast in plan (Hint: You will only have 3 years of matched data).