All sales in the three week period were based on an average £9.50 reduction in the sales price of the units sold. What was the total saving made by customers who bought units over the 3 week period (to the nearest £100)?
Step 1 – Calculate the total sales We could use the working from Q6 to obtain Week 1 and Week 3 sales totals. Week 2 sales = 20 + 40 + 18 + 14 + 6 = 98 Total sales = Week 1 + Week 2 + Week 3 = 95 + 98 + 120 = 313 Step 2 – Calculate the amount saved 313 x £9.50 = £2,973.50 Step 3 - (to the nearest £100) £2,973.50 = £3,000 Thus the correct answer is (A) £3,000
Tip: when summing numbers from a column or row, be careful not to take numbers from an adjacent category. It is also a good idea to enter the numbers as you go straight into your calculator, instead of writing out the sum on your rough paper then performing the calculation. This will reduce the number of stages in your working and save time and reduce the potential for input errors.
The Western Region?s overall sales (£120,000) were in a ratio of 3:2 to the Eastern Region?s sales which itself had half the sales of the Northern and Southern Regions combined. What were the total sales of all 4 Regions?
Answer : E
Explanation
Step 1 – Calculate each Region’s sales Eastern Region’s sales = 2 x 120,000 / 3 = 80,000 Northern + Southern Regions’ sales = 80,000 x 2 = 160,000
Step 2 – Calculate the total sales 120,000 + 80,000 + 160,000 = 360,000 Thus the correct answer is (E) £360,000
Next year staff numbers are to be reduced by 1 at stores with 6 or less staff, and by 2 staff at all other stores. What will be the average monthly target per staff member across all 5 stores if the regional target (across the 5 stores) is £168,000?
Step 1 – Calculate the new staff numbers
Step 2 – Calculate the average target per staff member Average = target / total number of staff = 168,000 / 28 = £6,000
Thus the correct answer is (B) £6,000
Over the three week period, which Store achieved the highest sales per sales staff member?
Step 1 – Calculate each Store’s total sales Use the Actual sales figures for each of the 3 weeks, as follows:
Step 2 – Calculate each Store’s average sales per sales staff member, as follows:
Thus the correct answer is (C) Wilkington
For Weeks 1 and 3, across all 5 stores combined, what was the difference (in units) between Actual and Target sales volumes?
Step 1 – Calculate the total Week 1 and Week 3 sales across the 5 Stores Week 1: 20 + 30 + 25 + 15 + 5 = 95 Week 3: 35 + 40 + 24 + 12 + 9 = 120
Step 2 - Calculate the total Week 1 and Week 3 targets across the 5 Stores Week 1: 15 + 20 + 20 + 10 + 10 = 75 Week 3: 35 + 35 + 30 + 15 + 15 = 130
Step 3 – Calculate the difference for Weeks 1 and 3 Week 1: 95 – 75 = 20 over target Week 3: 120 – 130 = 10 under target Thus the correct answer is (E) 20 over target (Week 1); 10 under target (Week 3)