Month 2020 Sales 2021 Sales 2023 Sales
January $1,409 $2,032 $1,895
February $2,317 $2,237 $2,537
March $2,212 $2,638 $2,707
April $2,677 $2,997 $3,147
May $2,900 $2,915 $3,283
June $3,041 $3,323 $3,417
July $2,649 $3,297 $3,485
August $3,989 $3,703 $4,060
September $4,427 $4,954 $5,076
October $6,408 $7,261 $7,613
November $11,467 $11,722 $13,534
December $8,576 $10,779 $10,151 Calculate the average monthly sales for each year.
2. Calculate the year-over-year percent changes in average monthly sales.
o Determine the percent changes from year to year using your answers to
question 1.
o Using your answers to question 2(a), calculate the annual rate of change.
3. Establish monthly average ratios to determine how each month compares to the
yearly average.
o For each month, calculate the average sales across all three years. Also
average the yearly averages calculated in question 1. Round your answers
to whole numbers.
o For each month, establish a ratio between the average sales in the month
(from question 3(a)) and the average of the yearly sales (also from
question 3(a)). Express the ratio so that the average yearly sales is a term
of one. Round your answers to two decimals.
4. Project sales into the future to forecast monthly sales in 2023 along with total
yearly sales.
o Project the average monthly dollar volume sales for 2023 using the annual
rate of change from question 2(b). Round your answer to a whole
number.
o Convert the projection from question 4(a) into a monthly projection for
2023 using the monthly ratio established in question 3(b). Total the
projected sales for 2023. Round all of your answers to whole numbers.