Numerical Test 2 Solutions
Numerical Test 2 Solutions
Numerical Test 2 Solutions
Solution Booklet
1
Q1 Which of the products shown had the lowest value of sales per non-European store
and which had the highest value of sales per European store?
2
Q2 What is the discrepancy (in $) between the AE25 price per product unit in non -European
stores compared to European stores. Use an exchange rate of 0.80 to the $.
(A) $30
(B) $120
(C) $130
(D) $200
(E) $230
The information that you need is shown in both tables. Note from the possible answers it
doesn’t matter which is the greater, we just need the difference.
Tip: if you struggle with the term “ x to the $” and you sometimes multiply when you
should divide by the conversion, think of an extreme example. So think of a two
currencies that have very different strengths, for example Zimbabwean Dollar to the
British Pound. It doesn’t matter what the values are but you know there are lots of
ZWDs to the BGP and you also know that the same product will cost a lot more ZWDs
than GBP. Hopefully that will help you decide if currency A should be a higher number
than currency B, or vise versa.
Step 1 – read from the table the AE25 price per product unit (non-European
stores) = $130
Step 2 – Calculate the AE25 price per product unit (European stores)
= 200 ¸ 0.80 = $250
Q3 This month’s combined target for non-European and European sales of AE25 is 40,000.
Using an exchange rate of 0.75 to the $, what is the difference between the sales values
shown and this target?
(A) 575
(B) 750
(C) 5,100
(D) 5,750
(E) 7,500
3
Q4 Given that a customer uses the promotional offers shown, put the 5 products sold in non-
European stores into order of increasing promotional price per unit (starting with the
cheapest).
The information that we need is shown in the first table (non-European stores)
Step 3 – put these promotional prices into order alongside the fifth product (AE25)
priced at $130 and not on promotion
Thus the correct answer is (C), PU10, DE45, AE25, PU20, FD24
4
Q5 On the previous day, the value of the shares held in the Emerging Markets Fund was 0.5%
lower than the values given here. What was the previous day’s value of shares in the
Emerging Markets Fund?
The information that we need is shown in both the graph and the table.
Step 1 - Calculate the value of the shares component of the Emerging Markets Fund
5
Q6 Which out of the Emerging Markets, UK and Far Eastern funds hold the lowest value
of Cash and the lowest value of Bonds?
The information that we need is shown in both the table and the graph.
Step 1 - Calculate the value of the Cash held within each of the Funds in the question
Cash value = total value x cash %
UK (Cash) = 55.6 x 10% = £5.56 million
Cash
UK £5.56 million
Far Eastern £7.86 million
Emerging
Markets £3.89 million
Step 2 - Calculate the value of the Bonds held within each of the Funds in the
question Bonds value = total value x bonds %
UK (Bonds) = 55.6 x 20% = £11.12 million
Bond
UK £11.12 million
Far Eastern £3.41 million
Emerging
Markets £11.67 million
Thus the correct answer is (B), Emerging Markets (Cash); Far Eastern (Bonds)
6
Q7 Which of the components of the UK and US equity funds have the highest and the
lowest value?
Tip: Note that just from looking at the graph and table we know the overall US fund is
smaller than the UK fund and the smallest fraction within the US find (10% to
Derivatives) is not larger than the smallest fraction within the UK fund. So we can
instantly say the smallest fraction is Derivatives in the US fund. As it happens there is
only one multiple choice with this as an option so we know (E) is the correct answer.
In full, the solution is as follows. The information that we need is shown in both the
graph and the table.
Calculate the value of each component of each equity fund, using this
Thus the correct answer is (E), lowest is US Fund (Derivatives); highest is UK Fund
(Shares)
7
Q8 Which equity fund holding(s) hold less than double the number of Shares compared
to Bonds?
(A) UK
(B) US
(C) Emerging Markets
(D) UK, US
(E) UK, US, Emerging Markets
Bonds Shares
UK 20 40
US 15 55
European 7 70
Far Eastern 13 30
Emerging Markets 30 50
The UK fund has exactly double the number of Shares compared to Bonds. Only the
Emerging Markets has less than double the number of Shares compared to Bonds.
8
Q9 Averaged across the Manufacturing Plants, put the average values for each of
the maintenance costs in decreasing size order, starting with the highest.
Thus the correct answer is (A), Servicing, Administration, Misc., Rent, Insurance,
Utilities
9
Q10 For the Glasgow manufacturing plant, which maintenance cost(s) represent
approximately 7% of the total costs?
Step 2 - For the Glasgow plant, calculate each cost as a % of the total cost
Tip: to save time, you can stop after you’ve calculated 7% for Insurance and just scan
across the row to see if any other costs are close to £195. You will see that Utilities are.
10
Q11 What is the average annual cost for servicing each of the 5 manufacturing plants
(assume 4 weeks in a month)?
(A) £3,300
(B) £12,400
(C) £16,500
(D) £39,600
(E) £48,000
Q12 Which two manufacturing plants have the same total maintenance costs per week?
Calculate the total weekly maintenance costs for each production plant
Midlands = 196 + 1,050 + 300 + 95 + 650 + 525 = 2,816
Bordeaux = 204 + 1,100 + 250 + 236 + 600 + 400 = 2,790
Berlin = 212 + 950 + 275 + 164 + 450 + 400 =2,451
Amsterdam = 154 + 1,025 + 350 + 245 + 525 + 500 = 2,799
Glasgow = 195 + 875 + 300 + 189 + 720 + 425 = 2,704
11
Q13 Which garden furniture manufacturer has 22.5% of the UK market in terms of
2010 annual sales?
(A) Manufacturer A
(B) Manufacturer B
(C) Manufacturer C
(D) Manufacturer D
(E) Manufacturer E
Step 1 – Calculate the total annual sales for all furniture manufacturers
1.2 + 3.3 + 2.4 + 2.7 + 2.4 = £12 million
Step 2 – Next, the quickest way to complete this question is to calculate 22.5% of the
12 million and see which manufacturer has this sales value. So 22.5% of 12 is 2.7. We
immediately see that Manufacturer D has sales of 2.7 (ignoring any units).
Alternatively, the slower way would be to calculate the % of the UK market held by
each furniture manufacturer:
12
Q14 Manufacturers B and D each aim to increase their annual sales from 2010 to 2011 by
a quarter. Manufacturers A, C and E each aim to grow their annual sales by a fifth.
Assuming all companies meet these targets, what will be 2011’s total furniture
manufacturer sales (to the nearest £million)?
Step 1 - Calculate the 2011 targets for each garden furniture manufacturer
Step 2 – Calculate the total 2011 target for all garden furniture manufacturers
1.44 + 4.125 + 2.88 + 3.375 + 2.88 = 14.7
Note: in this question we were lucky that £14.7 million was not an available answer.
Sometimes questions deliberately include the answer not rounded as required, to catch
you out.
13
Q15 What is the percentage increase in Company C’s total sales for 2010 compared its
2009 total sales?
(A) 0.83%
(B) 0.84%
(C) 0.85%
(D) 0.86%
(E) 0.87%
14
Q16 If Company C’s sales in 2009 were in the ratio of 8:7 for online: offline sales, what were
the offline sales (to the nearest £1,000)?
(A) £110,000
(B) £1,000,000
(C) £1,100,000
(D) £1,110,000
(E) £1,111,000
Step 1 – use Manufacturer C’s 2009 total sales figure from the previous
question i.e. 2,380,000 (312,500 + 396,700 + 546,300 + 595,500 + 529,000)
15
Q17 Assume that the percentage change trends between the Current Year and Next Year
continue at the same rate for a subsequent year. What’s the subsequent year’s
average entry level graduate salary across the 5 sectors (to the nearest £500)?
(A) £28,000
(B) £28,500
(C) £29,000
(D) £29,500
(E) Can’t tell from data
It might be tempting to do the following calculation, however since we don’t know how
many graduates there are in each sector we cannot calculate the average salary. For
example if Engineering has 1,000 graduates and Research has 10, it is not true to add
up the totals and divide by the number of sectors (five).
16
Q18 In Year 3 a company paid the average entry graduate starting salaries when recruiting 15
graduates for a consultancy role and 6 graduates for a research role. What was the
average salary per recruited graduate?
(A) £26,000
(B) £26,114
(C) £26,429
(D) £26,500
(E) £27,000
Q19 Which sector has seen the smallest percentage increase in graduate entry level salary
between Year 2 and the Current Year?
(A) Engineering
(B) Research
(C) Consulting
(D) Legal
(E) Accounting
17
Q20 The current year’s entry level graduate salaries for working in logistics and retail are
£25,000 and £24,000 respectively. If these sectors experience the same percentage
change as the legal sector over the same period, what’s next year’s predicted entry
level graduate salary in the logistics and retail sectors (to the nearest £100)?
Step 1 – calculate the % increase in legal sector salaries between the current year and
next year
100% x (34.3 – 33.2)/33.2 = 3.31%
18