Given the following average demand for each month, calculate the seasonal indices for each

month. Note that your answer, if done correctly, should have all the seasonal indices add up to the

number of periods in the entire season, in this case $12.$

Month Average demand Seasonal index

January $300\mathrm{.}28$

February $500\mathrm{.}46$

March $850\mathrm{.}78$

April $1101\mathrm{.}01$

May $1251\mathrm{.}15$

June $2452\mathrm{.}25$

July $2552\mathrm{.}34$

August $1351\mathrm{.}24$

September $1000\mathrm{.}92$

October $900\mathrm{.}83$

November $500\mathrm{.}46$

December $300\mathrm{.}28$

Total $130512$

Problem $5.$ Using the data in problem $4$ and the seasonal indices you have calculated, calculate

expected monthly demand if the annual forecast is $2000$ units.

Month Seasonal index Forecast

January $0\mathrm{.}2847$

February $0\mathrm{.}4677$

March $0\mathrm{.}78130$

April $1\mathrm{.}01168$

May $1\mathrm{.}15192$

June $2\mathrm{.}25375$

July $2\mathrm{.}34390$

August $1\mathrm{.}24207$