Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Kancil Edar Sdn Bhd has reported that the sales of their popular car, Kancil Tur

ID: 3241033 • Letter: K

Question

Kancil Edar Sdn Bhd has reported that the sales of their popular car, Kancil Turbo have grown steadily at auto dealership in Johor for the past 5 years. Before the new model was introduced, the Sales Director, Echa Syazreena had predicted the first year sales of the new model would be 410 cars as shown below. a) Using exponential smoothing with a weight of alpha = 0.30, develop forecast for year 2 through 6. b) Use a 3 - year moving average to forecast the sales of Kancil Edar Sdn Bhd in Johor through year 6. c) What are the Mean Absolute Deviation (MAD) and Mean Squared Error (MSE)? d) Using the trend projection (regression) method, develop a forecast for sales of Kancil Turbo in year 6.

Explanation / Answer

a ) smoothed values using expoential smoothing are 495, 501.9,520.23,539.361

b )

A3 525.3333 A4 555