Need answer with solution Subject: MGT TOPIC: Forcasting

Customer Service Viking Rent A Car Services, Manila Philippines Viking Rent A Car Services rents cars to travelling salespersons and tourists at airports in the Philippines. A key good customer service continued customer loyalty is to have enough cars available to meet demand. The summer months have the highest demand, owing a large number of vacationers. The demand for cars is shown on the following table. 25 98 120 35 Month Actual Demand January February 29 March April May 144 June July August September October November December Additional information given: Estimated total demand for next year is 915 cars, Requirement: (Round off your answers to the nearest unit) 1. Predict the demand use Naive, moving average using one quarter as the value of n. Exponential Smoothing for the total demand with alpha=0.10. 2. Determine the forecast accuracy using MAD, MSE and MAPE F for January = 20. 3. Predict the demand for January February, and March next year using exponential smoothing with trend adjustments and trend projections. 47 75 60 49 41 30