Business Mathematics — Assignment
Name: ____________________ Class: ____________________ Date: ____________
Instructions: Use the dataset and graph to answer the questions. Show all calculations.
Dataset (Month : Sales (000s))
Jan : 120
Feb : 135
Mar : 150
Apr : 160
May : 155
Jun : 170
Jul : 185
Aug : 190
Sep : 200
Oct : 210
Nov : 220
Dec : 240
Questions
1. Plot the monthly sales on a line graph (graph provided).
2. Calculate total annual sales (in 000s).
3. Calculate the average (mean) monthly sales.
4. Find the median monthly sales.
5. Calculate the approximate compound monthly growth rate from January to December (CAGR).
6. Briefly describe the sales trend and suggest one possible reason for an increase in sales towards the end of the year.
Solutions (worked out)
Total annual sales (000s): 2135
Mean monthly sales (000s): 177.92
Median monthly sales (000s): 177.5
Approx. compound monthly growth rate (Jan → Dec): 6.50% per month
Annualized approx growth: 113.01%