Weighted Moving Average. Use Excel Spreadsheet $($Copy the table below and Paste it into Excel$).$ Your manager is trying to determine what forecasting method to use. Based on the following historical data, calculate the following forecast and specify what procedure you would utilize.

Calculate the weighted three$-$month moving average for period $12$ using weights of $0\mathrm{.}40($for the period t$1)$; $0\mathrm{.}30($for the period t$2),$ and $0\mathrm{.}30($for the period t$3).($Do not round intermediate calculations. Round your answers to $1$ decimal place.$)$

Month Actual Demand

$152$

$255$

$353$

$467$

$577$

$665$

$767$

$868$

$979$

$1079$

$1181$

$1282$

Question $6$ options:

$78\mathrm{.}8$

$66\mathrm{.}4$

$76\mathrm{.}7$

$74\mathrm{.}8$