47) |
What is the difference in revenue between the package with the lowest number of sales and the package with the highest number of sales over the 12 month period, across all regions combined?
Step 1 – find the highest selling and the lowest selling number of new mobile phone contracts by totaling sales across all 5 regional stores for each package
|
Platinum
package |
Gold package |
Silver package |
Bronze package |
Central |
4,540 |
4,854 |
5,083 |
5,425 |
Northern |
4,725 |
5,005 |
5,382 |
5,846 |
Southern |
4,584 |
5,123 |
5,759 |
5,428 |
Western |
4,682 |
4,759 |
4,956 |
4,869 |
Eastern |
4,884 |
5,256 |
4,982 |
4,592 |
TOTAL |
23,415 |
24,997 |
26,162 |
26,160 |
Step 2 – calculate the difference in sale values between the Silver and Platinum
packages
Silver package = 26,162 x £30 = £784,860
Platinum package = 23,415 x £40 = £936,600
Difference = £936,600 - £784,860 = £151,740
So the correct answer is £151,740
|