Question: increase their fleet size or not. Since their ultimate objective is to satisfy the certain percentage of nationwide transportation demand, they obtained the following data
increase their fleet size or not. Since their ultimate objective is to satisfy the certain percentage of nationwide transportation demand, they obtained the following data representing total transportation demand in billions of dollars. You can copy tables into Excel
Table Demand for transportation
Source: US Department of Commerce, Bureau of Economic Analysis
a Plot the time series data and comment on the pattern you observe.
b Use weighted moving average method to forecast the demand for
c Use exponential smoothing with optimal alpha to forecast the demand for
d Use regression method to forecast the demand for
e Compute the following measures of forecast accuracy: mean absolute error MAE mean squared error RMSE mean absolute percentage error MAPE for your forecasts in parts b c and d
f Determine the most accurate forecast method and estimate the demand for
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
