Workforce Numerical Past Questions and Answers


Use the Above table to solve the following questions


21)

If the percentage changes in expenses that each Department exhibited between Quarters 3-4 continued into the first quarter of the next year, what would be that quarter’s total expenses (to the nearest £100)?

Answer : B

Explanation:

Step 1 – Calculate the % change by Department between Quarters 3-4
HR: (1,346 – 1,305) / 1,305 = 3.14%.
Note: some people find it quicker to calculate 1,346 / 1,305 = 1.0314
Marketing: (4,309 – 3,652) / 4,309 = 17.99%
Sales: (5,245 – 5,091) / 5,245 = 3.02%
IT: (956 – 938) / 956 = 1.92%
R&D: (1,821 – 1,755) / 1,821 = 3.76%

Step 2 – Calculate the next quarter’s expenses for each department
HR: 103.14% x 1,346 = 1,1388
Marketing: 4,309 x 117.99% = 5,084
Sales: 5,245 x 103.02% = 5,403.7
IT: 956 x 101.92% = 974
Finance: 4,463 x 98.2% = 4,383
R&D: 1,821 x 103.76% = 1,889

Step 3 - Calculate the next quarter’s total
expenses 1,388 + 5,084 + 5,404 + 974 + 4,383 + 1,889 = £19,122

Thus the correct answer is (B), £19,100
22)

The Finance Department has receipts for £14,476 of its annual expenses. What percentage of the Finance Department’s annual expenses do not have receipts?

Answer : D

Explanation:

Step 1 – Total the Finance Department’s expenses for all 4 quarters

4,257 + 4,830 + 4,545 + 4,463 = 18,095

Step 2 – Calculate the % for which there are receipts 14,476 / 18,095 = 80%
Step 3 - Calculate the % for which there are no receipts 100 – 20 = 20%
23)

60% of the Sales Department’s budgets for Quarters 1 and 4 was for attending a Sales Conference. The remainder of the budget was split equally between accommodation and travel costs. What were the Sales Department’s travel costs for
Quarters 1 and 4 combined?

Answer : E

Explanation:

Step 1 – Although the annual expense budget is provided, we are not told what the quarterly expense budget is. The table provides data for the annual expense budget and the quarterly expenses, without any mention of what the quarterly expense budget may be, since it cannot be assumed that the annual budget is spread equally over each quarter. Therefore we cannot accurately ascertain 60% of the quarterly budget based on the data provided.

Thus the correct answer is (E), Can’t tell from the data
 
24)

If the annual expense budget was evenly allocated for each Quarter, which Department is under budget by the highest amount in Quarter 4?

Answer : D

Explanation:

Step 1 – Calculate the quarterly expense budgets for each Department
(excluding IT which is not shown in the answer options)
HR: 6,500 / 4 = 1,625
Marketing: 16,000 / 4 = 4,000
Sales: 22,500 / 4 = 5,625
Finance: 20,000 / 4 = 5,000
R&D: 6,000 / 4 = 1,500

Step 2 – Compare to the Quarter 4 figures for each Dept.
HR: 1,625 – 1,346 = £279
Marketing is over budget
Sales: 5,625 – 5,245 = £380
Finance: 5,000 – 4,463 = £537
R&D is over budget

Thus the correct answer is (D), Finance
25)

Which Department has the highest expense budget per member of staff?

Answer : E

Explanation:

Step 1 – Have a quick look at the data to see if this can be seen by inspection.
In this case, it is unlikely you can ‘see’ the answer before doing some number-crunching.

Calculate the expense budget per member of staff for each department.
6,500 / 3 = £2,167
16,000 / 6 = £2,667
22,500 / 12 = £1,875
4,500 / 5 = £900
20,000 / 7 = £2,857
Thus the correct answer is (E), Finance

Similar CBTs


Popular CBTs