Question: This assignment will be conducted in asynchronous session. This is individual assignment. Mention your name and student ID in the file. Submit the assignment in
This assignment will be conducted in asynchronous session. This is individual assignment. Mention your name and student ID in the file. Submit the assignment in excel file (*.XLS) Please do the following instructionsRead the attached case with the title of "Agarwal automobiles: fuel station forecasting and inventory management" to understand the context of the problemBased on the "Exhibit 7: Daily Sales Data", create forecast of Petroleum, Diesel, and HSP fuel in 2016 using moving average method (with 2, 3, and 4 moving period) and using exponential smoothing (determine your own alpha value)Evaluate the best forecasting method based on the criteria of MAD, MSE, and MAPE for each type of fuel
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
