Question $3$

As they enter March, the team at Mark$$s Tires is meeting with their key tire suppliers to ensure they have sufficient stock of winter tires for the new season. Mark$$s fiscal year runs May $1$st to May $1$st and it is important for the management team to understand the seasonality of demand for this product. The sales team has estimated that sales of winter tires for this new fiscal year will be $450$ units. In addition, below is the number of winter tire sets $($units$)$ sold over the last $3$ years.

Month $2021$ Sales $($units$)2022$ Sales $($units$)2023$ Sales $($units$)$

May $252829$

June $273032$

July $242728$

August $232628$

September $282825$

October $353638$

November $394240$

December $434749$

January $485255$

February $444854$

March $404247$

April $333540$

$3\mathrm{.}1.$ Based on the data above, calculate the seasonal index for each month. Show results using $2$ decimal points.

$3\mathrm{.}2.$ Based on the data above and the seasonal index on question $3\mathrm{.}1$ above, calculate the seasonal volume by month for the new fiscal year. Show results using whole numbers.

$3\mathrm{.}3.$ Identify $3$ operational decisions that may be impacted by this forecast.

do this in excel