Sign inSign upSign in
Menu
Skills level · Performance Management

Performance Management · November 2020

Every objective and theory question in this paper, with answers where we have them, and the topic notes to revise each one.

6 questions6 theory15 topics to revise
Source: ICAN Pathfinder, Skills Level Examination, Performance Management, November 2020

November 2020 diet

0 objective and 6 theory
Time allowed: 31/4 hours (including 15 minutes reading time).
0 objective6 theory140 theory marks set
No.SectionMarksCovers
Q1Section A (compulsory)40Relevant costs: reduce output, shut down, special order; techniques and principles.
Q2Section B20Marginal costing v throughput accounting, TAR, profit-maximising output.
Q3Section B20Variance reconciliation under marginal costing, fixed overhead variances, causes of labour variances.
Q4Section B20Transfer price effects with capacity change, incentive transfer price.
Q5Section B20Balanced scorecard perspectives, goals and measures for an airline, usefulness.
Q6Section B20Divisional ROCE and other measures (members, revenue per member), NPV of investment.

Theory questions Written questions

1
Theory question 1Section A (compulsory)
40 marks
a 20b 10c 10

Adeco Nigeria plc is a large and diversified company with several factories. One of its factories that produces “Apex” has not been able to meet its sales target for over two years. The board has mandated the company’s management to take a decisive step on what to do with the factory. The management therefore set up a committee of three, the factory manager, marketing manager and the management accountant to analyse the situation and come up with a report on what they feel the management should do. The marketing manager submitted two proposals to the committee, these are: ● a sales volume of 25,000 units can be achieved with a selling price of ₦13.50 per unit and an advertising campaign of ₦37,500; or ● a sales volume of 35,000 units can be achieved at a selling price of ₦11.25 with an advertising campaign costing ₦52,500. The management accountant is to work on these proposals with the information provided by the factory manager and come up with calculations that will help the committee to know which of the proposals to be recommended to management. The management accountant is also required to prepare a third scenario that would reflect the factory closure. 54 The factory manager submitted the following information to the management accountant: Budgeted sales and production of Apex (units) 50,000 N000 Sales 750.0 Less production costs: Material A – 1 kg per unit 75.0 Material B – 1 litre per unit 37.5 Labour – 1 hour per unit 187.5 Variable overhead 150.0 Fixed overhead 75.0 Non-production costs 75.0 Total cost 600.0 Budgeted profit 150.0 The following additional information has also been made available: (i) There are 50,000 kg of material A in inventory. This originally cost ₦1.5 per kg. Material A has no other use and unless it is used by the division, it would have to be disposed off at a cost of ₦750 for every 5,000 kg. (ii) There are 30,000 litres of material B in inventory. Any unused material can be used by another department to substitute for an equivalent amount of a material, which currently costs ₦1.875 per litre. The original cost of material B was ₦0.75 per litre and it can be replaced at a cost of ₦2.25 per litre. (iii) All production labour hours are paid on an hourly basis. Rumours of the closure of the department have led to a large proportion of the department’s employees leaving the organisation. Uncertainty over its closure has also resulted in management not replacing these employees. The department is therefore short of labour hours but has sufficient man hour to produce 25,000 units. Output in excess of 25,000 units would require the department to hire contract labour at a cost of ₦5.625 per hour. If the department is shut down, the present labour force will be deployed within the organisation. (iv) Included in the variable overhead is the depreciation of the only machine used in the department. The original cost of the machine was ₦300,000 and it is estimated to have a life span of 10 years. Depreciation is calculated on a straight-line basis. The machine has a current resale value of ₦37,500. If the machinery is used for production, it is estimated that the resale value of the machinery will fall at the rate of ₦150 per 1,000 units produced. All other costs included in variable overhead vary with the number of units produced. 55 (v) Included in the fixed production overhead is the salary of the factory manager which amounts to ₦30,000. If the department were to shut down, the manager would be made redundant with a redundancy pay of ₦37,500. All other costs included in the fixed production overhead are general factory overheads and will not be affected by any decision concerning the factory. (vi) The non-production cost charged to the factory is an apportionment of the total on-production costs incurred by the factory. The committee will be meeting in a week’s time to prepare its report to the management on what course of action the management should take, either one of the marketing manager’s proposals or to close down the factory.

RequiredAs the management accountant of Adeco Plc, you are to:
a

Prepare detail calculations to support the committee’s recommendation to the management whether to: i. reduce production to 25,000 units ii. reduce production to 35,000 units iii. shut down the factory.

20 marks
b

A customer has just placed a special order for 25,000 of Apex and the customer is willing to pay ₦12.00 per unit. Advise management whether to accept or reject the order. Assume that for any shortfall in material “A” required to produce the order, it can be bought at a price of ₦2.00 per kg.

10 marks
c

Discuss the management accounting techniques and principles that a management accountant will apply in preparing calculations to support management decision in such a circumstance as above.

10 marks
Suggested answer

ADECO NIGERIA PLC. (a) Relevant savings and revenue 25,000 units 35,000 units Shut down ₦ ₦ ₦ Sales revenue 337,500 393,750 – Material B 9,375 – 56,250 Sale of machinery 33,750 32,250 37,500 Total revenue/savings 380,625 426,000 93,750 Relevant costs Material A disposal 3,750 2,250 7,500 Purchase material B – 11,250 – Labour 93,750 150,000 – Variable overhead (excl. depreciation) 60,000 84,000 – Advertising campaign 37,500 52,500 – Manager’s salary 30,000 30,000 – Redundancy pay – – 37,500 Total relevant costs 225,000 330,000 45,000 Net savings 155,625 96,000 48,750

Workings 25,000 units 35,000 units Shut down 1. Sales revenue No. of units 25,000 35,000 Selling price ₦13.50 ₦11.25 Sales revenue ₦337,500 ₦393,750 2. Savings made on material B Surplus available 5,000 _ 30,000 Saving per litre ₦1.875 ₦1.875 ₦1.875 Total saving ₦9,375 – ₦56,250 3. Sale of machinery Current market price ₦37,500 ₦37,500 ₦37,500 Reduction in value ₦3,750 ₦5,250 _ Sale proceeds ₦33,750 ₦32,250 ₦37,500 4. Disposal cost of material A Quantity to be disposed of 25,000 15,000 50,000 Cost of disposal ₦3,750 ₦2,250 ₦7,500 5. Purchase cost of material B Production requirement 25,000 35,000 No. of litres to be _ 5,000 Purchased 66 Purchase cost ₦11,250 6. Labour costs Normal labour costs ₦93,750 ₦93,750 Contract labour – ₦56,250 ₦93,750 ₦150,000 7. Variable overhead @ ₦2.40 per unit* ₦60,000 ₦84,000 *Variable overhead/unit ₦ Total variable overhead 150,000 less depreciation 30,000 120,000 Variable overhead/unit = ₦120,000 50,000 = ₦2.40 per unit 8. Manager’s salary – relevant 9. Redundancy pay – relevant 10. General fixed overheads and non-production overheads – not relevant

(b) Special order From the calculations in (a), the decision will be to produce 25,000 units at a price of ₦13.50. This means that the special order of 25,000 units could be produced, with the following relevant revenues and costs: ₦ Revenue: Sales (25,000 × ₦12.0) 300,000 Savings made on material A disposal {250,000 𝑋 ₦750 5000 } 3,750 303,750 Costs: Material B (20,000 x ₦1.875) 37,500 Labour (25,000 × ₦ 5.625) 140,625 Variable overhead (25,000 × ₦2.40) 60,000 238,125 Additional contribution 65,625 Decision: Adeco is advised to accept the special order as it will produce additional contribution of ₦65,625. 67

(c) The cost accounting technique normally used by the management accountant to Assist management in decision making is the marginal costing technique, while the cost accounting principle is the relevant costs and relevant revenue principle. Marginal costing might be used for decision-making. For example, marginal costing is used for limiting factor analysis, linear programming and contribution techniques. It is appropriate to use marginal costing for decision-making when it can be assumed that future fixed costs will be the same, no matter what decision is taken, and that all variable costs represent future cash flows that will be incurred as a consequence of any decision that is taken. These assumptions about fixed and variable costs are not always valid. When they are not valid, relevant costs should be used to evaluate the economic/financial consequences of a decision. Relevant costs should be used for assessing the economic or financial consequences of any decision by management. Only relevant costs and benefits should be taken into consideration when evaluating the financial consequences of a decision. A relevant cost is a future cash flow that will occur as a direct consequence of making a particular decision. The key concepts in this definition of relevant costs are as follows:

• Relevant costs are costs that will occur in the future. They cannot include any costs that have already occurred in the past.

• Relevant costs of a decision are costs that will occur as a direct consequence of making the decision. Costs that will occur anyway, no matter what decision is taken, cannot be relevant to the decision.

• Relevant costs are cash flows. Notional costs, such as depreciation charges, notional interest costs and absorbed fixed costs, cannot be relevant to a decision.

Marking Guide Marks Marks Marks

a. (i) Production of 25000 units (½ x 13) 6.5 (ii) Production of 35000 units (½ mark x 13 ticks) 6.5 (iii) Shutdown of factory (½ mark x 13ticks) 6.5 Headline 0.5 20.0 b. Management Accounting Technique (Any 4 points @ 2½marks) 10.0 c. Accept or reject decision on special order (10ticks @ 1 mark) 10.0 40.0 68

Examiner’s Report The question tests candidates’ understanding of marginal costing as well as relevant costing techniques. Being a compulsory question, all candidates attempted the question. The performance of student was just above average. The major pitfall was candidate lack of understanding of the subject area especially in situation that has to do with savings, replacement costs and cost incurred in situation of shutdowns. Candidates are advised to read the ICAN study text when preparing for future examination of the Institute.

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, November 2020, Question 1
2
Theory question 2Section B
20 marks
a 4b 4c 8d 4

Ideal Nigeria Limited manufactures two products, Light and Medium, on the same machines. Sales demand for the products exceeds the machine capacity of the company’s production department. The potential sales demand in each period is for 10,000 units of Light and 15,000 units of Medium. Sales prices cannot be increased due to competition from other producers in the market. The maximum machine capacity in the production department is 40,000 hours in each period. 56 The following cost and profitability estimates have been prepared: Light Medium N N Sales price 110 135 Direct materials (50) (45) Direct labour and variable overhead (30) (55) Contribution per unit 30 35 Machine hours per unit 1.5 hours 2 hours Fixed costs in each period are N450,000. Required:

a

Using marginal costing principles, calculate the profit-maximising output in each period, and the amount of profit.

4 marks
b

Explain how throughput accounting differs from marginal costing in its approach to maximising profit.

4 marks
c

Using throughput accounting, calculate the throughput accounting ratio for Light and Medium.

8 marks
d

Using throughput accounting principles, calculate the profit maximising output in each period, and the amount of profit.

4 marks
Suggested answer

IDEAL NIGERIA LIMITED

(a) Marginal costing approach Profit will be maximised by producing output to maximise the contribution per machine hour (contribution per unit of limiting factor). Light Medium Contribution per unit ₦30 ₦35 Machine hours per unit 1.5 hours 2 hours Contribution per machine hour ₦20 ₦17.50 Ranking for manufacture 1st 2nd Profit will be maximised by making and selling 10,000 units of Light in each period (maximum sales demand). This will require 15,000 machine hours. The remaining 25,000 machine hours should be used to make and sell 12,500 units of Medium. ₦ Contribution from Light: 10,000 ×₦30 300,000 Contribution from Medium: 12,500 ×₦35 437,500 Total contribution 737,500 Fixed costs 450,000 Profit 287,500 (b) Throughput Accounting recognises material costs and its components as the only variable costs while the variable costs under marginal costing consist of direct materials costs, direct labour costs and variable overhead costs. 69 Under throughput accounting, direct labour costs are treated as fixed costs under other operational costs while marginal costing treats direct labour costs as relevant or variable costs relevant for decision making. The Net profit of throughput accounting differs from that of the marginal costing because the components of their costs of sales vary. The main difference between throughput accounting and marginal costing is in the treatment of direct labour and variable overhead costs as a ’fixed cost’ in the short-term. In throughput accounting, fixed costs are referred to as ’factory cost’.

(c) Throughput accounting ratio = Return per bottleneck unit / Factory cost per bottleneck unit Here, the bottleneck resource is machine time. Light Medium ₦ ₦ Sales price 110 135 Materials cost 50 45 Throughput 60 90 Machine hours per unit 1.5 hours 2 hours Throughput/return per machine hour ₦40 ₦45 To calculate the cost per factory hour, we need to make an assumption about direct labour cost and variable overhead costs. It is assumed that the direct labour cost and variable overhead cost in the answer to part (a) is fixed in the short-term. ₦ Direct labour and variable overhead costs: Light: 10,000 ×₦30 300,000 Medium: 15,000 ×₦55 825,000 Total Direct labour/Variable Overhead 1,125,000 Fixed costs 450,000 Factory cost in each period 1,575,000 70 Factory cost per machine hour = ₦1,575,000/40,000 hours = ₦39.375. Light Medium Return per machine hour ₦40 ₦45 Factory cost per machine hour ₦39.375 ₦39.375 Machine hours per unit 1.5 hours 2 hours Throughput accounting ratio 1.02 (102%) 1.14 (114%) Ranking for manufacture 2nd 1st

Note: The aim should be to maximise the throughput accounting ratio, and to ensure that the ratio is higher than 1.0.

(d) Profit will be maximised by making and selling 15,000 units of Medium (maximum sales demand). This will use up 30,000 machine hours. The remaining 10,000 machine hours should be used to make 6,666.67 units of Light. ₦ Return from Medium: 15,000 ×₦90 1,350,000 Return from Light: 6,666.67×₦60 400,000 Total return/throughput 1,750,000 Fixed costs 1,575,000 Profit ₦175,500

Marking Guide Marks Marks Marks

a. - Profit maximizing output using Marginal Costing principles (8 ticks @ 1 tick = ¼ mark) 2.0 - Maximising output (2 ticks @ ½mark) 1.0 - Maximum profit ( 4ticks @ ¼mark) 1.0 4.0 b. Throughput accounting Vs Marginal Costing (2 points @ 2 marks per tick) 4.0 c. Calculation of Throughput Accounting ratio

- Throughput returns/per Machine hour (8 ticks @ ¼ mark) 2.0 - Computation of Factory Cost/Machine hour (8 ticks @ ¼ mark) 2.0 - Computation of Throughput Accounting ratio (4ticks @ 1 mark) 4.0 8.0 d. Profit Maximisation/output using Throughput Accounting:

- Computation of output (2 ticks @ 1 tick) 2.0 - Computation of Profit (4 ticks @ ½ mark) 2.0 4.0 20.0 71

Examiner’s Report The question tests candidates’ understanding of application of marginal costing and throughput accounting principles. The performance of candidates was just average. The major pitfall was candidates’ poor understanding of marginal costing and throughput accounting techniques. Candidates are encouraged to read the Institute’s study text when preparing for future examinations of the Institute.

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, November 2020, Question 2
3
Theory question 3Section B
20 marks
a 12b 4c 4

Toma Paste Nigeria Limited produces tomatoe paste which serves as an alternative for an immediate stew for working mothers instead of looking for fresh tomatoes. For the forthcoming period, the company’s budgeted fixed costs were ₦600,000 and budgeted production and sales were 13,000 units. The product has the following standard cost: N Selling price 500 Materials 5kg × N40/kg 200 Labour 3hrs × N40/hr 120 Variable overheads 3hrs × N30/hr 90 Actual results for the period were as follows: 11,000 units were made and sold, earning revenue of ₦5,720,000. 66,000kg of materials were bought at a cost of ₦2,970,000 but only 63,000 kg were used. 36,000 hours of labour were paid for at a cost of ₦1,422,000. The total cost for variable overheads was ₦1,170,700 and fixed costs were ₦400,000. 57 The company uses marginal costing and values all inventory at standard cost. Required:

a

Prepare a statement reconciling actual and budgeted profit using appropriate variances.

12 marks
b

Recalculate the fixed production overhead variances, assuming the company uses absorption costing.

4 marks
c

Discuss possible causes for the labour variances you have calculated.

4 marks
Suggested answer

(a) Reconciliation Statement between Budgeted and Actual Profit N’000 Budgeted contribution 1170.0 Sales volume variance 180.0 (A) Sales price variance 220.0 (F) Standard Contribution 1,210.0 Cost variances F A N. N. Materials price 330.0 Materials usage 320.0 Labour rate 18.0 Labour efficiency 120.0 Variable overhead rate 90.7 Variable overhead efficiency 90.0 Total 18.0 950.7 Total cost variances 932.7 (A) Actual contribution 277.3 Less Fixed cost 400.0 Actual loss (122.7) 72

Workings TOMA PASTE NIGERIA LIMITED Materials price variance: based on quantities purchased since inventories are valued at standard cost. N’000 66,000 kg of materials should cost (×N40) 2,640 They did cost 2,970 Material price variance 330 (A) kg 11,000 units produced should use (× 5kg) 55,000 They did use 63,000 Usage variance in kg 8,000 (A) Standard price per kg N40 Usage variance in ₦ N320,000 (A) Labour rate variance N’000 36,000 hours of labour should cost (×N40) 1,440 They did cost 1,422 Labour rate variance 18 (F) Labour efficiency variance hours 11,000 units produced should take (× 3 hours) 33,000 They did take 36,000 Efficiency variance in hours 3,000 (A) Standard rate per hour N40 Efficiency variance (in ₦) N120,000(A) Variable Overhead Variances: N’000 36,000 hours should cost (×N30) 1,080.0 They did cost 1,170.7 Variable overhead expenditure variance 90.7 (A) Variable overhead efficiency variance (36,000hrs – 33,000hrs) =3,000 hours (A) ×N30 per hour = N90,000 (A) 73 Sales price variance N’000 11,000 units should sell for (x N500) 5,500 They did sell for 5,720 Sales price variance 220 (F) Sales volume (contribution margin) variance Budgeted sales volume in units 13,000 Actual sales volume in units 11,000 Sales volume variance in units 2,000 (A) × Standard contribution per unit N90 Sales volume variance in N.contribution N180,000 (A) N/B = Standard Contribution = (N500 – N410) ALTERNATIVE TO COMPUTING VARIANCES

- Material price Variance = Actual Cost less Standard Cost = Actual Quantity Purchased x Actual Cost Per kg less = Actual Quantity Purchased x Standard Cost per kg = (AQ x AC) – (AQ x SC) = 66,000 x 2,970,000 66,000 – (66,000 x N40) = N2,970,000 – N2,640,000 = N330,000 Adverse

- Material Usage Variance = Standard Cost less Standard Cost of Actual Production = Actual Quantity Used x Standard Cost Per kg less = Standard Cost of material per unit x Actual Production = (AQ x SC) – (SC x AP) = (63,000 x 40) – (N200 x 11,000) 74 = N2,520,000 – N2,200,000 = N320,000 Adverse

- Labour Rate Variance = Actual Cost less Standard Cost = (Actual hours used x Actual hour rate less = (Actual hours used x Standard labour rate per hour) = (36,000 x N1,422,000 36,000 ) – (36,000 x N40) = N1,422,000 – N1,440,000 = N18,000 Favourable

- Labour Efficiency Variance= Standard Cost - Standard Cost of Actual Production = (Actual hours x Standard labour rate per hour) - (Standard labour rate per unit x Actual Production) = (36,000 x N40) – (N120 x 11,000) = N1,440,000 – N1,320,000 = N120,000 Adverse

- Variable Overhead Efficiency Variance = Standard Cost – Standard Cost of Actual Production = (Actual Hours x Standard variable overhead per hour)-(Standard variable overhead per unit x Actual Production) = (36,000 x N30) – (N90 x 11,000) = N1,080,000 – N990,000 = N90,000 Adverse 75

- Variable Overhead Expenditure Variance = (Actual Cost – Standard Cost) = (Actual Hours x Actual Variable Overhead per hour) – (Actual Hours x Standard Variable overhead per hour) = (AH x AVOH) – (AH – SVOH) = (36,000 x ( N1,170,700 36,000 ) – (36,000 x N30) = N1,170,700 – N1,080,000 = N90,700 Adverse = (SSP – ASP) AQS = N500 – ( N5,720,000 11,000 ) x 11,000

- Sales Volume Variance = (Standard Sales – Budgeted Sales) = (Actual Sales Volume x Standard Sales Price) - (Budgeted Quantity x Standard Sales Price ) = (AQS x SSP) – (BQS – SSP) = (11,000 x N500) – (13,000 x N500) = N5,500,000 – N6,500,000 = N1,000,000 Adverse

- Standard Margin = (Standard Sales Price – Standard Cost per unit) = N500 – N410 = N90

- Sales Volume Variance = N90 N500 x N1,000,000 1 = N180,000 Adverse Working Notes N’000 Budgeted contribution N90.00 × 13,000 units 1,170.0 Budgeted fixed costs (600.0) Budgeted profit 570.0 76 Actual profit N’000 N’000 Sales 5,720.0 Materials 2,970.0 Less closing inventory (3,000kg ×N40.00) (120.0) 2,850.0 Labour 1,422.0 Variable overheads 1,170.7 Fixed costs 400.0 Total (5,842.7) Actual loss in the period (122.7)

b) If the company uses absorption costing with a direct labour hour absorption rate, we can calculate an expenditure, capacity and efficiency variance for fixed production overheads. Budgeted absorption rate per hour: Budgeted labour hours: 13,000 × 3 = 39,000 hrs Budgeted fixed cost N600,000 Budgeted absorption rate: N600,000 /39,000 = N15.38 Fixed overhead expenditure variance N’000 Budgeted fixed overhead costs 600 Actual fixed overhead costs 400 Fixed overhead expenditure variance 200 (F) Fixed overhead capacity variance hours Budgeted hours of work 39,000 Actual hours worked 36,000 Capacity variance in hours 3,000 (A) Standard fixed overhead rate per hour N15.38 Fixed overhead capacity variance in N. N46,140 (A) Fixed overhead efficiency variance Efficiency variance in hours = 3,000 hours (A) – see answer to (a). Fixed overhead efficiency variance = 3,000 hours (A) ×N15.38 = N46,140(A). 77 ALTERNATIVE SOLUTION

• Fixed Overhead Expenditure Variance = Actual Cost – Budgeted Cost = N400,000 – N600,000 = N200,000 Favourable

• Fixed Overhead Capacity Variance = (Budgeted Cost – Standard Cost) = (Budgeted Hours x Standard Cost per hour) – (Actual Hours x Standard Cost per hour) = (BH x SC) – (AH x SC) =(13,000 x3 N600,000 13,000 𝑥 3 - (36,000 x (N600,000 39,000 ) = N600,000 – N553,846 = N46,154 Adverse

- Fixed Overhead Efficiency Variance = = (Standard Cost - Standard Cost of Actual Production) = (AH x SC) – (SCAP) = (36,000 x (N600,000 39,000 ) – (11,000 x (N600,000 𝑥 3 39,000 ) = N553,846 - N507,692 = N46,154 Adverse N/B: Due to round-off or, any answer between N46,140 (A) to N46,154 (A) will be accepted.

(c) Labour rate The labour rate variance is favourable indicating a lower rate per hour was paid than expected. This is perhaps because lower grade of labour were used during production. Though less likely, it is possible that staff had a pay cut imposed upon them/decrease in buy rate. Finally, an incorrect or outdated standard could have been used. Labour efficiency This is significantly adverse, indicating staff took much longer than expected to complete the output. This may relate to the favourable labour rate variance, reflecting employment of less skilled or experienced staff. Staff demotivated by a pay cut are also less likely to work efficiently. 78 It may also relate to the reliability of machinery as staff may have been prevented from reaching full efficiency by unreliable equipment. Others include: • Decrease in machine set up time

• Idle time

• Lack of motivation

• Faulty equipment/Machine breakdown

Marking Guide Marks Marks Marks a. Reconciliation Statement (16 ticks @ ½ mark) 8.0

- Workings (8 ticks @ ½ mark) 4.0 12.0 b. Recalculation of Fixed overhead variances

- 3 fixed overhead variances (1 mark each) 3.0 - Working ( 2 ticks @ ½ mark each) 1.0 4.0 c. Labour rate variance (Any 2 points at 1 point = 1 mark) 2.0 Labour efficiency Variance (Any 2 points @ 1 point = 1 mark) 2.0 4.0 20.0

Examiner’s Report The question tests candidates’ understanding of application of standard costing and variance analysis. Majority of the candidates attempted the question. The performance of candidates was above average. The major pitfall was candidates inability to understand the application of standard costing using marginal costing as well as treatment of fixed overhead under absorption costing approach. Another pitfall was candidates’ failure to understand the treatment of inventory under standard costing principle. Candidates are encouraged to read the Institute’s study text when preparing for future examination of the Institute. 79

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, November 2020, Question 3
4
Theory question 4Section B
20 marks
a 10b 5c 5

Adeb Nigeria Limited has two divisions, Eastern and Northern divisions. Eastern division makes materials that are used to manufacture special blocks. It transfers some of these materials to the Northern division and sells some of the materials externally to other block manufacturers. Northern division makes special blocks from the materials and sells them to traders in building materials. The production capacity of Eastern division is 10,000 tonnes per month. At present, sales are limited to 5,000 tonnes to external customers and 3,000 tonnes to Northern division. The transfer price was agreed at ₦200 per tonne in line with the external sales trade price at 1st July which was the beginning of the budget year. From 1st December, however, strong competition in the market has reduced the market price for the materials to ₦180 per tonne. The manager of the Northern division has suggested that the transfer price for the materials from Eastern division should be the same as for external customers. The manager of Eastern division rejected this suggestion on the basis that the original budget established the transfer price for the entire financial year. From each tonne of materials, Northern division produces 10 blocks, which it sells at ₦40 per blocks. It would sell a further 20,000 blocks if the price were reduced to ₦32 per block. Other relevant data are given below: Eastern division Northern division N N Variable cost per tonne 70 60 Fixed cost per month 150,000 60,000 The variable costs of Northern division exclude the transfer price of materials from Eastern division. 58 Required:

a

Prepare estimated profit statements for the month of December for each division and for Adeb Nigeria Limited as a whole, based on transfer prices of ₦200 per tonne and of ₦180 per tonne, when producing at i. 80% capacity ii. 100% capacity, on the assumption that Northern division reduces the selling price to ₦32.

10 marks
b

Comment on the effect that might result from a change in the transfer price from ₦200 to ₦180.

5 marks
c

Suggest an alternative transfer price that would provide an incentive for Northern division to reduce the selling price and increase sales by 20,000 blocks a month.

5 marks
Suggested answer

ADEB NIGERIA LIMITED

(a) Profit statements in December

(i) Operating at 80% capacity Transfer price ₦200 Transfer price ₦180 Eastern division Northern division Total Eastern division Northern division Total ₦’000 ₦’000 ₦’000 ₦’000 ₦’000 ₦’000 Sales: External (₦180x5000) 900 1,200 2,100 900 1,200 2,100 Transfers (₦200x3000) 600 - 0 540 - 0 Total 1,500 1,200 2,100 1,440 1,200 2,100 Costs Tr

(ii) Operating at 100% capacity Transfer price ₦200 Transfer price ₦180 Eastern division Northern division Total Eastern division Northern division Total ₦’000 ₦’000 ₦’000 ₦’000 ₦’000 ₦’000 Sales: External (₦180x5000) 900 1,600 2,500 900 1,600 2,500 Transfers (₦200x5000) 1,000 - 0 900 - 0 Total 1,900 1,600 2,500 1,800 1,600 2,500 Costs Transfers - (1,000) 0 - (900) 0 Variable (700) (300) (1,000) (700) (300) (1,000) Fixed (150) (60) (210) (150) (60) (210) Total (850) (1,360) (1,210) (850) (1,260) (1,210) Profit 1,050 240 1,290 950 340 1,290 N/B: Under the Northern Div. External Sales = ((₦32x5000x10 blocks) = ₦1,600,000 Under the Northern Div. Variable Costs = ((₦60x5000) = ₦300,000

(b) The effect of a change in the transfer price from ₦200 to ₦180 will result in lower profit for Eastern division and higher profit for Northern division, but the total profit for the company as a whole will be unaffected. A reduction in the transfer price to ₦180 (or possibly lower) is recommended, because this is the price at which Northern division can buy the materials externally. At any price above ₦180, Northern division will want to buy externally, and this would not be in the interests of the company as a whole. Significantly, at a transfer price of both ₦200 and ₦180, Northern division would suffer a fall in its divisional profit if it reduced the selling price of blocks to ₦32 and increased capacity by 20,000 blocks each month. A reduction in price would be in the best interests of the company as a whole, because total profit would rise from ₦1,150,000 per month to ₦1,290,000.

(c) Ignoring the transfer price, the effect on Northern division of reducing the sale price of blocks to ₦32 would be to increase external sales by ₦640,000 and variable costs in Northern division by ₦120,000 (2,000 tonnes × ₦60). Cash flows would therefore improve by ₦520,000 per month (₦640,000 less ₦120,000). To persuade Northern division to take the extra 2,000 tonnes, the transfer price should not exceed ₦260 (₦520,000/2,000). This is above the current external market price which is ₦180 although there is strong price competition in the market. 81 The transfer price for Eastern division should not be less than the variable cost of production in Eastern division, which is ₦70 per tonne. In the final analysis, an optimal transfer price suggested should be between ₦70 to ₦180.

Marking Guide Marks Marks Marks a. (i) Profit Statement @ 80% capacity (50 ticks @ 1 mark for 10 ticks) 5.0 (ii) Profit Statement @ 100% capacity (50 ticks @ 1 mark for 10 ticks) 5.0 10.0

b. Comments on effect on transfer price change (2 points @ 2½ marks per point) 5.0 c. Other transfer price to provide incentive (2 points @ 2½ marks per point) 5.0 20.0

Examiner’s Report The question tests candidates’ understanding of transfer pricing technique. The attempt on this question by candidates was moderate. The performance of candidates is above average. The major pitfall was candidates poor understanding of the requirements of the question especially in areas of varying capacity for production and sales as well as determination of optimum transfer price. Candidates are advised to read the Institute’s study text when preparing for the Institute’s examination in future.

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, November 2020, Question 4
5
Theory question 5Section B
20 marks
a 6b 9c 5

Dat Air was founded in January 2010 by Dr. Daniel Taiwo and the airline has been branded as a low-cost airline in Nigeria. Dat Air’s strategy is to operate as a low- cost and highly efficient airline, and it does this by: (i) Operating mostly in cities where other airlines do not fly to reduce landing cost; (ii) Using only one aircraft model in order to reduce maintenance and operational costs. These planes are leased rather than bought outright; (iii) Having only one category of seat class; there is no pre-allocated seats or in- flight entertainment; and to (iv) Focus on e-commerce with customers both booking tickets and checking in for flights online. Customers who booked well in advance before the flight date enjoy substantial discount. The airline was given an ’on time arrival’ ranking of second best by the Nigerian aviation authority, who rank all 20 airlines operating locally in the country based on the number of flights which arrive on time at their destinations. 48 Dat Air flights were cancelled in 2018 compared to 35 in 2017. This increase was due to an increase in the staff absentee rate at Dat Air from 5 days per staff member per year to 7 days. The average ’ground turnaround time’ for airlines in Nigeria is 2 hours, meaning that, on average, planes are on the ground for cleaning, refuelling, etc for 2 hours before departing again. Customer satisfaction surveys have 59 shown that 90% of customers are happy with the standard of cleanliness on Dat Air’s planes. The number of passengers carried by the airline has grown from 200,000 passengers on a total of 2,107 flights in 2010 to 650,000 passengers on 5,320 flights in 2018. The overall growth of the airline has been helped by the limited route licensing policy of the Nigerian government, which has given DAT Air almost monopoly status on some of its routes. However, the government is now set to change this policy with almost immediate effect, and it has become more important than ever to monitor performance effectively. This has necessitated the management of Dat Air to examine the airline’s performance using the balanced scorecard model. This will enable the management to discover areas where improvement is needed in its operations. Required:

a

Describe each of the FOUR perspectives of the balanced scorecard.

6 marks
b

For each perspective of the balanced scorecard, identify ONE goal together with a corresponding performance measure which could be used by DAT Air to measure the company’s performance. The goals and performance measures should be specifically relevant to Dat Air. For each pair of goals and performance measures, explain why you have chosen them.

9 marks
c

Appraise the usefulness of the balanced scorecard as a performance evaluation technique.

5 marks
Suggested answer

DAT AIR

(a) The four perspectives Financial perspective – this perspective is concerned with how a company looks to its shareholders. How can it create value for them? Kaplan and Norton identified three core financial themes which will drive the business strategy: revenue growth and mix, cost reduction and asset utilisation Customer perspective – this considers how the organisation appears to customers. The organisation should ask itself: ’to achieve our vision, how should we appear to our customers?’ The customer perspective should identify the customer and market segments in which the business will 82 compete. There is a strong link between the customer perspective and the revenue objectives in the financial perspective. If customer objectives are achieved, revenue objectives should be too. Internal perspective – this requires the organisation to ask itself: ’what must we excel at to achieve our financial and customer objectives?’ It must identify the internal business processes which are critical to the implementation of the organisation’s strategy. These will include the innovation process, the operations process and the post-sales process. Learning and growth perspective – this requires the organisation to ask itself whether it can continue to improve and create value. The organisation must continue to invest in its infrastructure – i.e. people, systems and organisational procedures – in order to improve the capabilities which will help the other three perspectives to be achieved.

(b) Goals and Measures: Perspective Goal Performance Measure Comments/Remarks Customer To improve on the existing level of cleaningness of Airplanes Rating of the cleaning by the customers. This constitute a major factor adding value to customers. Customer To ensure that flights are on time. To reduce the number of flight cancelled “On time arrival” ranking from the aviation authority. The number of flights cancelled. DAT Air is currently No. 2 in the ranking and customers are more likely to use it. If flights are frequently cancelled, customers will not use it as it will be received as unreliable. Internal Extending operations to other cities where no airline fly to currently The number of customer base and fights in a year This represents area where the airline has been excelling Internal To improve turnaround time on the ground. To improve the cleaningness of DAT’s Planes. To develop the online booking system. On the ground time % of customers happy with the standards of the planes (customer satisfaction) percentage downtime Less time spent on ground means fewer planes are needed, reduce leasing costs. About 85% of customers are happy meaning 15% can result in loss of revenue. Since the company relies on booking system. It is critical in situation of growing number of customers. 83 This Financial (a) To continue to use will help to make one model of aircraft superior returns to the shareholders of the company. Financial (b) To use fewer planes to transport customers.

(c) To increase set revenue per plane Operating efficiency will be driven by getting more customers on fewer planes. This measures the cost side. This covers the first part of achieving operating efficiency by having fewer empty seats on planes Innovation & Learning Cost of lease of plane per customer Revenue per available passenger It is critical to the company that its workforce are reliable as absentee staff will lead to flight cancellation. If ground crew are better trained, they reduce the time the place stays on the ground, resulting in fewer planes being required and thus lowers costs. Cleaning results in customer satisfactory and retention will increase Innovation & Learning To reduce the The number of days employee absentee absent per employee. rate. Number of days’ To increase ground training per ground crew training on crew members cleaning and refuelling procedures Taking advantage of The increase in This area will help the new developments in number of customers airline to maintain its the e-commerce to who book online in competitive position in the improve business advance industry operations The extent reduction in maintenance and operational costs when compared with increase in customers’ base and revenue.

c. APPRAISAL OF THE USEFULNESS OF THE BALANCED SCORECARD AS A PERFORMANCE EVALUATION TECHNIQUE

• Better Strategic Planning The Balanced Scorecard provides a powerful framework for building and communicating strategy. The business model is visualised in a Strategy Map which helps managers to think about cause-and-effect relationships between the different strategic objectives. The process of creating a Strategy Map ensures that consensus is reached over a set of interrelated strategic objectives. It means that performance outcomes as well as key enablers or drivers of future performance are identified to create a complete picture of the strategy.

• Improved Strategy Communication & Execution Having a one-page picture of the strategy allows companies to easily communicate strategy internally and externally. We have known for a long time that a picture is worth a thousand words. This 'plan on a page' facilitates the understanding of the strategy and helps to engage staff and external stakeholders in the delivery and review of the strategy. The thing to remember is that it is difficult for people to help execute a strategy which they don’t fully understand.

• Better Alignment of Projects and Initiatives The Balanced Scorecard helps organisations map their projects and initiatives to the different strategic objectives, which in turn ensures that the projects and initiatives are tightly focused on delivering the most strategic objectives.

• Better Management Information The Balanced Scorecard approach helps organisations design key performance indicators for their various strategic objectives. This ensures that companies are measuring what actually matters. Research shows that companies with a BSC approach tend to report higher quality management information and better decision-making.

• Better Process Alignment Well implemented Balanced Scorecards also help to align organisational processes such as budgeting, risk management and analytics with the strategic priorities. This will help to create a truly strategy focused organisation.

Marking Guide Marks Marks Marks a. (i) Listing of each perspective ( 1 mark each) 4.0

(ii) Discussing each perspective (½ mark each) 2.0 6.0 b. Goods/Performance measures of the perspectives

- Any 3 of the perspective goals 3.0 - Any 3 corresponding measures 3.0 - Any 3 corresponding explanations 3.0 9.0 c. Usefulness of Balance Scorecard (2 points @ 2½ marks per point) 5.0 20.0

Examiner’s Report The question tests candidate knowledge of the concept of balance scorecard as an instrument of identifying corporate goals and associated performance measures. The performance of students is below average. The major pitfall was candidates’ inability to identify the corporate goals and the associated measures. Candidates are advised to read the ICAN study text when preparing for future examinations of the Institute.

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, November 2020, Question 5
6
Theory question 6Section B
20 marks

Lapez operates a chain of health and fitness clubs, located in state capitals in Nigeria. For easy administration, the clubs are structured into two divisions, the Northern and the Southern divisions. Each division has a General manager who is responsible for revenue, cost and investment decisions at their clubs. A bonus is awarded each year to the General manager that generates the higher return on capital employed (ROCE). 60 The following summary information shows the results of the divisions for the past two years: Year ending 31st December 2018 2017 Northern Southern Northern Southern N000 N000 N000 N000 Revenue 2,700 3,720 2,850 3,375 Staff costs 1,725 2,145 1,770 1,965 Others operating cost 690 1,012 750 930 Operating profit 285 563 330 480 Capital employed 750 1,350 1,125 1,800 Average number of members 6,880 9,425 7,050 8,320 Notes: (i) Revenue is comprised largely of income from membership fees. (ii) Lapez uses net book value of non-current assets as the capital employed. The capital employed figures in the above table are the net book value of the non-current assets of each division at the end of the year. (iii) Non-current assets are depreciated on a straight-line basis over a period of five years and are assumed to have no residual value. There were no additions nor disposals of non-current assets during the years 2017 and 2018. (iv) Both divisions have a cost of capital of 15%. (v) Ignore taxation and inflation. However, investigations by Lapez’s management revealed that at the end of 2017 the General manager of the Southern division rejected the opportunity to acquire a new building and equipment to set up a new fitness club at a total cost of ₦1,200,000. The building could have been purchased for ₦525,000 and for the purpose of this evaluation, it is assumed that it would have held that value for five years and that no depreciation would have been charged on the building. The new equipment would have cost ₦675,000 and would have been depreciated in accordance with Lapez’s policy over five years. The investment would have taken place on 1 January 2018. The forecast annual profit and number of members for the proposed new club were as follows: N000 Revenue 1,012.5 Staff costs (556.5) Other operating costs (including depreciation of the equipment) (240.0) Operating profit 216.0 Average number of members 2,100 It is Lapez’s policy that investments of this type should be appraised over five years using net present value. 61 Required:

a

Discuss the relative performance of the two divisions using Return on Capital Employed and TWO other performance measures that you think are appropriate.

15 marks
b

Calculate the net present value of the investment. Ignore taxation and inflation. (5 Marks) 62 Formulae Learning curve Y = axb Where Y = cumulative average time per unit to produce x units a = the time taken for the first unit of output x = the cumulative number of units produced b = the index of learning (log LR/log2) LR = the learning rate as a decimal Demand curve P = a – bQ b = change change in in quantity price a = price when Q = 0 MR = a – 2bQ The linear regression equation of Y on X is given by: Y= 𝑎 + 𝑏𝑋 where b= 𝑛 𝑋𝑌− ( 𝑋)( 𝑌) 𝑛 𝑋2− 𝑋 2 a = 𝑛 𝑦− 𝑏 𝑛 𝑥 Coefficient of determination (r2) r2 = (𝑛 𝑛 𝑋𝑌 − 𝑥 𝑌 2 𝑋2− 𝑋 2 (𝑛 𝑦2− 𝑋 2 The Miller-Orr Model 𝑆𝑝𝑟𝑒𝑎𝑑 =3 x 134x Transaction Cost x Variance of Cash flows 3 Interest rate as a proportion 63 Annuity Table Present value of an annuity of 1 i.e. 1 - (1 + r)-n r Where r = discount rate n = number of periods Discount rate (r) Periods (n) 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 1 0·990 0·980 0·971 0·962 0·952 0·943 0·935 0·926 0·917 0·909 1 2 1·970 1·942 1·913 1·886 1·859 1·833 1·808 1·783 1·759 1·736 2 3 2·941 2·884 2·829 2·775 2·723 2·673 2·624 2·577 2·531 2.487 3 4 3·902 3·808 3.717 3·630 3.546 3.465 3·387 3·312 3·240 3·170 4 5 4·853 4·713 4·580 4·452 4·329 4·212 4·100 3·993 3.890 3·791 5 6 5·795 5·601 5·417 5·242 5·076 4·917 4·767 4·623 4.486 4·355 6 7 6·728 6.472 6·230 6·002 5·786 5·582 5·389 5·206 5·033 4·868 7 8 7·652 7·325 7·020 6·733 6·463 6·210 5·971 5·747 5·535 5·335 8 9 8·566 8·162 7·786 7.435 7·108 6·802 6·515 6·247 5·995 5·759 9 10 9·471 8·983 8·530 8·111 7·722 7·360 7·024 6·710 6.418 6·145 10 11 10·368 9·787 9·253 8·760 8·306 7·887 7.499 7·139 6·805 6.495 11 12 11·255 10·575 9·954 9·385 8·863 8·384 7·943 7·536 7'161 6·814 12 13 12·134 11·348 10·635 9·986 9·394 8·853 8·358 7·904 7·487 7·103 13 14 13·004 12·106 11·296 10·563 9·899 9·295 8·745 8·244 7·786 7·367 14 15 13·865 12·849 11·938 11·118 10·380 9·712 9·108 8·559 8·061 7·606 15 (n) 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 1 0·901 0·893 0·885 0·877 0·870 0·862 0·855 0·847 0·840 0·833 1 2 1·713 1·690 1·668 1·647 1·626 1·605 1·585 1·566 1·547 1·528 2 3 2.444 2.402 2·361 2·322 2·283 2·246 2·210 2·174 2·140 2·106 3 4 3·102 3·037 2·974 2·914 2·855 2·798 2·743 2.690 2·639 2.589 4 5 3·696 3·605 3·517 3·433 3·352 3·274 3·199 3·127 3·058 2·991 5 6 4·231 4·111 3·998 3·889 3·784 3·685 3·589 3.498 3.410 3·326 6 7 4·712 4·564 4.423 4·288 4·160 4·039 3·922 3·812 3·706 3·605 7 8 5·146 4·968 4.799 4·639 4.487 4·344 4·207 4·078 3·954 3·837 8 9 5·537 5·328 5·132 4·946 4·772 4·607 4.451 4·303 4·163 4·031 9 10 5·889 5·650 5.426 5·216 5·019 4·833 4·659 4.494 4·339 4·192 10 11 6·207 5·938 5·687 5.453 5·234 5·029 4·836 4·656 4.486 4·327 11 12 6·492 6·194 5·918 5·660 5·421 5·197 4·988 4·793 4·611 4.439 12 13 6·750 6.424 6·122 5·842 5·583 5·342 5·118 4·910 4·715 4·533 13 14 6·982 6·628 6·302 6·002 5·724 5.468 5·229 5·008 4·802 4·611 14 15 7·191 6·811 6.462 6·142 5·847 5·575 5·324 5·092 4·876 4·675 15 64 65

Suggested answer

LAPEZ (a) 2018 2017 Northern Southern Northern Southern ROCE % 38.0 41.7 29.3 26.7 Staff costs/revenue % 63.9 57.7 62.1 58.2 Other operating costs/revenue % 25.6 27.2 26.3 27.6 Asset turnover 3.6 2.8 2.5 1.9 Operating profit/revenue % 10.6 15.1 11.6 14.2 Depreciation N’000 375.0 450.0 375.0 450.0 Op costs-depreciation N’000 315.0 562.0 375.0 480.0 Op costs- depreciation/revenue % 11.7 15.1 13.2 14.2 Revenue per member N 392 395 404 406 Staff costs per member N 251 228 251 236 Residual Income 172.50 360.50 161.25 210.00 Absolute Profit N 285 N 563 N 330 N 480 In 2017 the Northern division generated the higher ROCE and the General manager of that division would have received the bonus. The revenue for the Northern division was lower than that of the southern division but so was its capital employed. This is because it had a lower investment in non-current assets and its assets are older (assuming that all assets in each particular division were acquired at the same date). Revenue at the Northern division has fallen by 5.3% between 2017 and 2018. Also. revenue per member slightly fell from N404 in 2017 to ₦392 in 2018. Therefore, it can be concluded that the decline in revenue is due to the fall in number of members. The opposite is true for the Southern division, as revenue has increased by 10.2% over the period. Revenues per member are in line with the Northern division at N395 and have been maintained over the period. The operating profit has fallen over the period at the Northern division due to a fall in revenue and also less effective cost management with operating profit margins decreasing from 11.6% to 10.6%. Conversely, in the Southern division, the operating profit margin has increased from 14.2% to 15.1%. However further information can be obtained from a deeper analysis of the figures:

• Staff expenses as a percentage of revenue have increased for the Northern division but decreased for the Southern division. Given that revenue is almost directly linked to the number of members, it could be argued that this is to be expected given that it is highly likely that many of the staff costs are fixed.

• Operating costs as a percentage of revenue have fallen for both divisions but if depreciation is excluded it can be seen that they have increased for the Southern division. The General manager of the southern division would earn the bonus in 2018. b. Year N’000 Disc factor PV N Investment 0 -1,200 1.000 -1,200 Cash inflow 1-5 351 3.352 1,177 Sales of assets 5 525 0.497 261 NPV 238 The NPV of the project is N238,000. This NPV is positive.

Workings Calculation of Depreciation for each year = N675,000 5 year = N135,000 Calculation of Adjusted Annual Cashflows = Operating Profit = N 216,000 Add: Depreciation = N 135,000 = N 351,000 The NPV of the investment is positive and therefore this investment should have been made.

Marking Guide Marks Marks Marks a. Computation/discussion of ROCE and two other performance measures for 2017/2018:

- Computation of ROCE @ 1 mark 4.0 - Discussion of relative performance for ROCE 1.0 - Computation of any other two measures @ 1 mark 8.0 - Discussion of relative performance 2.0 15.0 b. Computation/Appraisal of Investment (5 ticks @ 1 mark) 5.0 20.0

Examiner’s Report The question tests candidates knowledge of company divisional performance and the use of appropriate parameters when financial data are provided on divisional basis. The question also test’s candidates’ ability in investment appraisal technique. Majority of the candidates attempted the question. The performance of candidates is above average. The major pitfall was inability of candidates to carry out thorough and relevant appraisal of the ratios computed. Also, candidates inability to apply the annuity table since the cash flow is regular for the duration of the investment is a major pitfall. Candidates are advised to read the Institute’s study text when preparing for the Institute’s examination in future. THE INSTITUTE OF CHARTERED ACCOUNTANTS OF NIGERIA

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, November 2020, Question 6
Source and reference. These questions come from the Institute of Chartered Accountants of Nigeria (ICAN) Pathfinder for the Skills Level Examination, Performance Management, November 2020. When you use them, please cite the source, for example: ICAN Pathfinder, Skills Level Examination, Performance Management, November 2020. Each question carries its own reference and a button to copy it.