E5 Performance with Data Analysis. 20 marks, about 36 minutes at exam pace. Section C style, 20 marks.
How to use this practice
This is practice written for this site in the style of ACCA's constructed response questions. It is not an ACCA question and the marking points are not ACCA's marking scheme. It follows the E5 syllabus on data analysis techniques for forecasting.
Write your answer in the box under each requirement. Show your workings for calculations. Your text stays in this browser.
Afterwards, open the marking points and tick each point that your answer made clearly and only once. Points marked as figures are correct amounts.
Scenario
Zephyr Ltd makes specialised machines in batches. The first batch took 200 labour hours. An 85 percent cumulative average learning curve is expected to apply. Labour costs $12 an hour. The company will make 8 batches this year.
The management accountant also wants to forecast total monthly costs, using monthly output (in thousands of units) and total cost (in $000) for the last six months.
Monthly output and total cost
Last six months.
Output (000 units)
Total cost ($000)
10
70
12
76
15
88
18
99
20
108
24
126
Requirement 1
Calculate the total labour hours and the labour cost for the 8 batches, and the hours and cost for batches 5 to 8. (8 marks)
Note: Use b = log 0.85 / log 2 = -0.2345.
0 words
Tick each point that your answer made clearly and only once. Points here are this site's own. A real examiner may accept other valid points.
Marks counted: 0 of 8
Requirement 2
Use regression analysis to estimate the fixed cost per month and the variable cost per thousand units, and forecast the total cost for output of 30,000 units. Calculate the correlation coefficient. (8 marks)
Note: Use y = a + bx.
0 words
Tick each point that your answer made clearly and only once. Points here are this site's own. A real examiner may accept other valid points.
Marks counted: 0 of 8
Requirement 3
Assess the reliability of the forecast for 30,000 units and the limitations of the techniques. (4 marks)
0 words
Tick each point that your answer made clearly and only once. Points here are this site's own. A real examiner may accept other valid points.
Marks counted: 0 of 4
Marks counted across all requirements: 0 of 20. The pass mark for ACCA exams is 50 percent.