See instructions Below. The excel is simply the template to begin working. You will need to fill in the excel.

Mal also has a specific set of requirements: o use a 3-month weighted average to forecast January. o see how the 3-month weighted average method would perform against historical data. o see the 3-month weighted average charted out within the model. o Mal is not sure how what weights he would like to use. Your model should allow him to adjust the weights, listed in G4-14, and see these changes change the models output. The 3-month weighted average formula is listed below: (Wt-1*Ut-1)+(Wt-2*Ut-2)+(Wt-3*Ut-3) (Wt-1 +Wt-2+Wt-3) o Fi = The forecasted values (column D) o Wi-x = the weight for the prior months. For example, if Fi = April then, Wt-1 would equal to March, Wt-2 would equal February and Wt-3 would equal January. o Ut-x = the units for the prior months, similar to how the weights work.Firefly Shipping Company - Units Moved Forecast Model Year Month Units 3-Month WMA Time T-1 T-2 T-2 2017 January 3,935 Weight 3 2 1 2017 February 6,890 2017 March 9,450 2017 April 10,695 2017 May 9,756 2017 June 8,740 2017 July 11,500 2017 August 12,224 2017 September 12,355 2017 October 9,555 2017 November 10,777 3-Month WMA Unit Chart April 2017-January 18 2017 December 10,055 2018 January