cell?

Q$6$ Data collected on the yearly registrations for a Six Sigma seminar at the quality college are shown in the following table

$\backslash$table$[[$Year$,1,2,3,4,5,6,7,8,9,10,11],[$Registrations$,4,6,4,5,10,8,7,9,12,14,15]]$

a$).$ Develop a three year moving average to forecast registration from year $4$ to year $10$

b$).$ Estimate demand again for years $4$ to $10$ with a $3$ year weighted moving average in which registrations in the most recent year are given a weight of $2$ and registrations in the other $2$ years are each given a weight of $1$

c$).$ Which of the two forecasting methods seems better.

Marks $-5$

QT$-$ Long Beach Bank employs three loan officers, each working eight hours per day. Each officer processes an average of five loans per day. The bank's payroll cost for the officers is SK$20$ por day, and wheri tisitity overhead expense of $$500.$