Sign inSign upSign in
Menu
Skills level · Performance Management

Performance Management · May 2023

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

7 questions7 theory9 topics to revise
Source: ICAN Pathfinder, Skills Level Examination, Performance Management, May 2023

May 2023 diet

0 objective and 7 theory
Time allowed: 31/4 hours (including 15 minutes reading time). Attempt five out of seven questions.
0 objective7 theory135 theory marks set
No.SectionMarksCovers
Q1Section A (compulsory)30Working capital cycle (outside the map); pay-off table, maximax, maximin and minimax regret for daily boxes of apples.
Q2Section B20Football programmes pay-off table with probabilities; expected profit; perfect information; limits of expected value.
Q3Section B20Relevant revenue and cost of a contract (labour grade 1 idle, replacement cost, NRV, lost contribution of Y); job-cos...
Q4Section B20Choose between two mutually exclusive contracts using incremental revenues and costs (Abuja, Lagos).
Q5Section C15Expected NPV of two projects with joint probabilities (same as Nov 2021 Q5; NPV outside course).
Q6Section C15Theme park: premium ticket demand function, MR=MC price, equipment hire benefit and sensitivity.
Q7Section C15Learning rate from batch times, time for 400 more units, minimum price with opportunity cost of scarce labour.

Theory questions Written questions

1
Theory question 1Section A (compulsory)
30 marks

Vestapricy and Company Limited is a manufacturing outfit located in Port Harcourt. It produces a tracking device that is attached to motor vehicles. The device is designed to help locate the whereabouts of stolen motor vehicles within the country. The company’s capital (or cash operating cycle) is the length of time between the payment for purchased materials and the receipt of payment from selling the goods made with the materials. The table below gives information extracted from the annual accounts of Vestapricy and Company limited for the past three years. Extracts from Vestapricy and Company Limited annual accounts for 31st December 2020 to December 2022: 2020 2021 2022 N N N Inventory: Raw materials 108,000 145,800 180,000 Work in progress 75,600 97,200 93,360 Finished goods 86,400 129,600 142,875 Purchases 518,400 702,000 720,000 Sales 864,000 1,080,000 1,188,000 Trade receivables 172,800 259,200 297,000 Trade payables 86,400 105,300 126,000 63 Other information is as follow: (1) All purchases and sales are on credit. (2) Direct wages: - 2021: N300,000 - 2022: N250,000 (3) Production expenses: - 2021: N72,600 - 2022: N171,995 (4) The company’s policy is that any data that will be used from the statement of financial position in determining the working capital cycle period will be average based. Required:

a

i. Compute the cost of goods sold for 2021 and 2022. (3 Marks) ii. Calculate the length of the working capital cycle (assuming 365 days in the year) for 2021 and 2022. (7 Marks) iii. List the actions that the management of the company might take to reduce the length of the cycle. (5 Marks)

b

In 2023, the company (Vestapricy) decided to open a new small apple shop in Owerri to be managed by a shopkeeper. The shopkeeper is deciding on the number of boxes of special apples it hopes to buy each day. A box of apples earns a contribution of N400 and costs N250. Demand of apple is uncertain and could vary from 30 boxes to 10 boxes. Any apple that is purchased but not sold will be thrown away at the end of the day. The shop keeper has decided that he will buy 10 boxes, 20 boxes or 30 boxes each day, and these are the only three options he wants to consider.

Requiredi. Construct the Pay-off table for this business in Owerri. (7 Marks) ii. How many boxes should the storekeeper purchase if the decision is based on: The Maximax decision rule; The Maximum decision rule and The Minimax regret decision rule? Give reasons for your decisions. (8 Marks) 64
Suggested answer

(a) i. Computation of Cost of goods sold for 2021 and 2022 2021 2022 N N Opening raw Material 108,000 145,800 Materials Purchased 702,000 720,000 Cost of material available 810,000 865,800 Less Closing Material 145,800 180,000 Cost of material used 664,200 685,800 Direct Wages 300,000 250,000 Prime Cost 964,200 935,800 Production expenses 72,600 171,995 1,036,800 1,107,795 Add Opening work in progress 75,600 97,200 Less Closing work in Progress (97,200) (93,360) Production costs 1,015,200 1,111,635 Add opening Finished goods 86,400 129,600 Less Closing finished goods (129,600) (142,875) Cost of goods sold 972,000 1,098,360

i. Length of working capital cycle (Assuming 365 days in a year) for 2021 and 2022 Working capital cycle for 2021 Holding Period for raw material stock = [(Opening +Closing )/2] x 365 Purchases = [(108,000 + 145,800)/2] x 365 702,000 = 66 days Production period for Work in Progress = [(Opening +Closing) /2] x 365 Cost of goods sold = [(75,600 + 97,200)/2] x 365 972,000 = 33 days Holding period for Finished goods = [(Opening +Closing )/2] x 365 Cost of goods sold [(86,400 + 129,600)/2] x 365 972,000 = 41 days Collection period for receivables = [(Opening +Closing )/2] x 365 Sales = [(172,800 + 259,200)/2] x 365 1,080,000 = 73 days Less Payment period for payable = (Opening +Closing)/2] x 365 Purchases = (86,400 + 105,300)/2 x 365 702,000 = (50 days) Working capital cycle 163 days Working capital cycle for 2022 76 Holding Period for raw material stock = [(Opening +Closing)/2] x 365 Purchases = [(145,800 + 180,000)/2] x 365 720,000 = 83 days Production period for Work in Progress = [(97,200 + 93,360)/2 x 365 1,098,360 = 32 days Holding period for Finished goods = [(Opening +Closing)/2] x 365 Cost of goods sold = [(129,600 + 142,875)/2] x 365 1,098,360 = 45 days Collection period for receivables = (Opening +Closing)/2] x 365 Sales = [(259,200 + 297,000)/2] x 365 1,188,000 = 85 days Less Payment period for payable = [(Opening +Closing )/2] x 365 Purchases = [(105,300 + 126,000)/2] x 365 720,000 = (59 days) Working capital cycle 186 days

(iii) Actions that the management of the company might take to reduce the length of the cycle:

• Reduce the period raw materials are held in inventory by adopting a JIT system

• Improve the throughput of the products by adopting efficient manufacturing equipment and process

• Reducing finished goods holding period by producing to order.

• Reducing the length of time customers take to pay by offering early settlement discount.

• Negotiate for longer credit period with suppliers

• Company need to improve on sales strategy to sell more maybe open new markets or they should plan to reduce the sales target to reduce the amount of finished goods left at the end of the year. (b)i. Payoff Table Constructing the Payoff table Course of Action Demand of 10 boxes Demand of 20 boxes Demand of 30 boxes N N N Buy 10 boxes (4000 – 2500)=1500 (4000 - 2500)=1500 (4000 – 2500)=1500 Buy 20 boxes (4000 – 5000)= (1000) (8000 – 5000)=3000 (8000 – 5000)=3000 Buy 30 boxes (4000 – 7500)= (3500) (8000 – 7500)= 500 (12000 – 7500)=4500 77 Payoff table Course of Action Demand of 10 boxes Demand of 20 boxes Demand of 30 boxes N N N Buy 10 boxes 1500 1500 1500 Buy 20 boxes (1000) 3000 3000 Buy 30 boxes (3500) 500 4500

ii. Number of boxes based on maximum decision rule Course of action Maximum of maximum returns Buy 10 boxes 1500 Buy 20 boxes 3000 Buy 30 boxes 4500 Decision: Buy 30 boxes Number of boxes based on maximin decision rule Course of action Maximum of minimum returns Buy 10 boxes 1500 Buy 20 boxes (1000) Buy 30 boxes (3500) Decision: Buy 10 boxes Minimax regret decision rule Constructing the regret Payoff table Course of Action Demand of 10 boxes Demand of 20 boxes Demand of 30 boxes N N N Buy 10 boxes (1500 – 1500)= 0 3000 – 1500=1500 4500 – 1500)=3000 Buy 20 boxes 1500 – (-1000) = 2500 (3000 – 3000)= 0 4500 – 3000)=1500 Buy 30 boxes 1500 – (-3500) =5000 3000 – 500= 2500 4500 – 4500= 0 Regret Payoff table Course of Action Demand of 10 boxes Demand of 20 boxes Demand of 30 boxes N N N Buy 10 boxes 0 1500 3000 Buy 20 boxes 2500 0 1500 Buy 30 boxes 5000 2500 0 Number of boxes based on Minimax regret decision rule Course of action Minimum of Maxi regret returns N Buy 10 boxes 3000 Buy 20 boxes 2500 Buy 30 boxes 5000 Decision: Buy 20 boxes which delivers minimum of the maxi regrets. 78

Examiner’s report This is a compulsory question that is in two parts. The first part tests candidates ability to determine company’s cost of goods sold and working capital cycle period. The second part is on decision making under situation of uncertainty as it affects maxi-max decision rule, mini-max decision rule and maxi-min regret decision rule. The question being a compulsory question was well attempted. Performance of the candidates was average. The major pitfalls are the inability of most candidates to use average stock in determining the working capital cycle and correctly set out the payoff matrix table. It is hereby recommended that candidates should use ICAN study manual and other Performance Management text books in preparing for future Institute’s examination.

Marking guide Mark s Marks

a) i Cost of goods sold 2021 and 2022 (30 ticks @1/10 mark) 3 ii Length of working capital cycle for 2021 and 2022 (28 ticks @1/4 mark) 7 iii Factors that will reduce length of working capital cycle (any 5 points @1 mark) 5 15 b) i Pay off table (21 ticks @1/3 mark) 7 ii • Maximax (5 ticks @½ mark) 2½

• Maximax (5 ticks @½ mark) 2½

• Minimax Regret (6 ticks @½ mark) 3 8 15 30

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

The local football club has asked for your advice on the number of programmes that should be printed for each game. The cost of printing and production of programmes for each game, as quoted by the local printer, is ₦1,000,000 plus ₦400 per copy. Advertising revenue which has been agreed for the season represents ₦800,000 for each game. Programmes are sold for N150 each. A review of sales during the previous seasons indicates that the following pattern is expected to be repeated during the coming season of 50 games: Number of programmes sold Number of games 10,000 5 20,000 20 30,000 15 40,000 10 Programmes not sold at the game are sold as waste paper to a paper manufacturer at N100 per copy. Assuming that the four quantities listed are the only possibilities, you are required to:

a

Prepare a payoff table;

6 marks
b

Determine the number of programmes that would provide the highest profit if a constant number of programmes were to be printed for each game;

4 marks
c

Explain why you should buy 30,000 or 40,000 copies, assuming one of these is the most profitable quantity, despite the fact that the most probable sales are 20,000 copies per game;

2 marks
d

Calculate the profit which would arise from a perfect forecast of the numbers of programmes which would be sold at each game.

4 marks
e

Discuss the major limitations at expected value criterion in decision making. (4 Marks) 65

Suggested answer

PAY OFF TABLE (N600) a. Course of Prob. State of Nature (Demand) Action 10,000 20,000 30,000 40,000 10,000 0.1 2,700 2,700 2,700 2,700 20,000 0.4 5,700 5,200 5,200 5,200 30,000 0.3 8,700 8,200 7,700 7,700 40,000 0.2 11,700 11,200 10,700 10,200 79 Cost of copies Cost of Unsold copies N600 a. N200 + (250 x 10) + (300 x 0) = 2,700 b. N200 + (250 x 10) + (300 x 0) = 2,700 c. N200 + (250 x 10) + (300 x 0) = 2,700 d. N200 + (250 x 10) + (300 x 0) = 2,700 e. N200 + (250 x 10) + (300 x 10) = 5,700 f. N200 + (250 x 20) + (300 x 0) = 5,200 g. N200 + (250 x 20) + (300 x 0) = 5,200 h. N200 + (250 x 20) + (300 x 0) = 5,200 i. N200 + (250 x 10) + (300 x 20) = 8,700 j. N200 + (250 x 20) + (300 x 10) = 8,200 k. N200 + (250 x 30) + (300 x 0) = 7,700 l. N200 + (250 x 30) + (300 x 0) = 7,700 m. N200 + (250 x 10) + (300 x 30) = 11,700 n. N200 + (250 x 20) + (300 x 20) = 11,200 o. N200 + (250 x 30) + (300 x 10) = 10,700 p. N200 + (250 x 40) + (300 x 0) = 10,200 State of Nature (N’000) Course of Action Prob. 10,000 20,000 20,000 40,000 10,000 0.1 N270 N270 N270 N270 20,000 0.4 N2,280 N2,080 N2,080 N2,080 30,000 0.3 N2,610 N2,460 N2,310 N2,310 40,000 0.2 N2,340 N2,240 N2,140 N2,040

b. Maximax Decision Rule course of Action Maximum Profit 10,000 270 20,000 2,080 30,000 2,310 40,000 2,040 *Least Cost yields highest profit Decision: 10,000 copies

c. The production or printing of the programmes involves incurring fixed cost. The larger the volume printed, the lower will be the cost of printing per copy. Therefore, printing 30,000 or 40,000 copies will be an optimistic decision informed by the need to maximise the benefit that is derivable from the fixed cost of printing. 80

d. Profit from perfect forecast: N’000 Result without perfect information (270 + 2080 + 2310 + 2040) (6,700) Result with perfect information (270 + 270 + 270 + 270) (1,080) 5,620

e. Limited of expected value criteria

i. It depends on subjective probability ii. Only useful for repetitive outcome and not for one-off iii. The expected value might not be one of the possible outcome iv. It does not give a view of the risk involved v. it is a weighted average of all possible outcomes.

Examiner’s report The question is on decision making under uncertainty and tests candidates’ ability to answer questions on maxi-max decision rule and decision on perfect information. The question was well attempted. The Performance of the candidate was average. The major pitfall observed was the inability of candidates to set out the Payoff matrix table and decipher the process of computing values when there is perfect information. It is hereby recommended that candidates should use ICAN study manual on Performance Management when preparing for future Institute’s examination.

Marking guide

a. Pay off table

• 15 ticks @1/5 mark) 3

• 15 ticks @1/5 mark) 3 6 b. Number of programmes (8 ticks @½ mark) 4 c. Most profitable quantity (4 points @½ mark) 2 d. Profit from perfect forecast (4 ticks @½ mark) 4 e. Major Limitations (4 points @1 mark) 4 20 81

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, May 2023, Question 2
3
Theory question 3Section B
20 marks
a 8b 6c 6

Kenny Limited (KL) has been offered a contract that, if accepted, would significantly increase next year’s activity levels. The contract requires the production of 20,000 kg of product X and specifies a contract price of N10,000 per kg. The resources used in the production of each kg of X include the following: Resources per kg of X Labour: Grade 1 2 hours Grade 2 6 hours Materials: A 2 units B 1 litre Grade 1 labour is highly skilled and although it is currently under-utilised in the firm, it is KL’s policy to continue to pay grade 1 labour in full. Acceptance of the contract would reduce the idle time of grade 1 labour. Idle time payments are treated as non- production overheads. Grade 2 is unskilled labour with a high turnover, and may be considered a variable cost. The costs to KL of each type of labour are Grade 1 N400 per hour Grade 2 N200 per hour The materials required to fulfil the contract would be drawn from those materials already in stock. Material A is widely used within the firm, and any usage for this contract will necessitate replacement. Material B was purchased to fulfil an expected order that was not received, if material B is not used for the contract, it will be sold. For accounting purposes, FIFO is used. The various values and costs for A and B are: A B per unit per litre (N) (N) Book value 800 3,000 Replacement cost 1,000 3,200 Net realisable value 900 2,500 A single recovery rate for fixed factory overheads is used throughout the firm, even though some fixed production overheads could be attributed to single products or departments. The overhead is recovered per productive labour hour, and initial estimates of next year’s activity, which excludes the current contract, show fixed production overheads of N60,000,000 and productive labour hours of 300,000. Acceptance of the contract would increase fixed production overheads by N22,800,000. 66 Variable production overheads are accurately estimated at N300 per productive labour hour. Acceptance of the contract would be expected to encroach on the sales and production of another product. Y, which is also made by KL Limited. It is estimated that sales of Y would then decrease by 5,000 units in the next year only. However, this forecast reduction in sales of Y would enable attributable fixed factory overheads of N5,800,000 to be avoided. Information on Y is as follows: (per unit) Sales price N7,000 Labour grade 2 4 hours Materials: relevant variable costs N1,200 All activity undertaken by KL is job costed using full or absorption costing in order to derive a profit figure for each contract. If the contract for X is accepted, it will be treated as a separate job for routine costing purposes. The decision to accept or reject the contract will be taken in sufficient time to enable its estimated effects to be incorporated in the next year’s budget and also in the calculations carried out to derive the overhead recovery rate to be used in the forthcoming year. Required:

a

Advise KL on the desirability of the contract

8 marks
b

Show how the contract, if accepted, will be reported on the routine job costing system used by KL

6 marks
c

Briefly explain the reasons for any differences between the figures used in (a) and (b) above.

6 marks
Suggested answer

(a) Relevant costs and relevant revenues from acceptance of contract (₦’000) (₦’000) Sales revenue (20,000 kg at ₦10,000) 200,000 Relevant costs: Labour (20,000 × 6hrs × ₦200) 24,000 Materials A (20,000 × 2 units × ₦1,000 replacement cost) 40,000 B (20,000 × 1 litre × 2,500 NRV) 50,000 Variable overheads b (20,000 × 8hrs × ₦300) 48,000 162,000 Add increase in fixed costs 22,800 Net incremental costs 184,800 Add Loss on product Y Lost contributionc (5,000 × ₦3,800) 19,000 Fixed costs avoidedd (5,800) 13,200 198,000 Excess of relevant revenues over relevant costs 2,000 Advice: In view of the fact that the Contract achieved excess of relevant revenue over relevant cost, the Contract is therefore desirable.

Notes i. Grade 1 labour is not an incremental cost. ii. Variable overheads vary with production labour – 8 labour hours per unit are used, causing variable overheads to increase by ₦300 per hour. Grade 1 labour is not an incremental cost, but it does cause variable overheads to increase.

iii. Lost contribution Selling price 7,000 Less Grade 2 labour (4 hrs × ₦200) 800 Materials 1,200 Variable overheads (4 hrs × ₦300) 1,200 3,200 Contribution 3,800

iv. Assumed fixed costs represent incremental costs or incremental savings. 82

(b) To calculate the product cost for job costing purposes it is necessary to calculate the fixed overhead rate. The calculation is as follows: Fixed overheads Director labour hours Initial budget ₦60,000,000 300,000 Plus contract ₦22,800,000 160,000a Less product Y (₦5,800,000) (20,000) = (4hrs × 5,000) ₦77,000,000 440,000 Fixed overhead absorption rate = ₦175/hour (₦77,000,000/440,000hrs).

Note a The fixed overhead rate is per productive labour hour. Grade 1 labour hours represent additional productive labour hours. If the contract is not accepted then grade 1 labour hours will be non-productive. Total productive hours relating to the contract = 2,000 × (2 hours + 6 hours) = 160,000 hours The job costing contract will be reported as follows: (₦000) (₦000) Direct labour: Grade 1 (20,000×2hrs×₦400) 16,000 Grade 2 (20,000×6hrs×₦200) 24,000 40,000 Direct materials: A (20,000×2units×₦800) 32,000 B (20,000×1litre×₦3,000) 60,000 92,000 Variable overheads 20,000×8hrs×₦300 48,000 Fixed overheads 20,000×8hrs×₦175 28,000 76,000 Total cost (208,000) Sales revenue 200,000 Reported loss (8,000)

c. The difference between the relevant cost profit of ₦2,000,000 and the routine cost loss of ₦8,000,000 arises because of the different ways in which costs are determined in each statement. A reconciliation and summary of the difference is as follows: Difference ₦000 Explanation Grade 1 labour 16,000 Not charged as a relevant cost because it is ’sunk’ and will be incurred anyway. Material A (8,000) Replacement cost is relevant but book value is the routing charge. Material B 10,000 Book value overstate the charge – realisable value is the relevant cost. 83 Fixed overheads 5,200 Routine costing passes on overheads that would be incurred anyway. The relevant cost is simply the incremental cost. Effect on product Y (13,200) Routine costing ignores the loss of contribution from Y – relevant costing takes it into account 10,000

Examiner’s report The question test’s candidate’s ability to answer questions on relevant costing. The question was well attempted. The Performance was above average. The major pitfall observed was candidate inability to decipher relevant costs of material, labour and overhead cost elements in situations involving replacement costs, realisable value of materials and replacement costs. It is hereby recommended that candidates should use ICAN Study Text on Performance Management when preparing for future Institute’s examination.

Marking guide a Desirability of the contract (16 ticks @½ mark) 8 b Routine job casting (12 ticks @½ mark) 6 c Differences between (a) and (b) (Any 4 points @1½ marks) 6 20

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

Tayo Limited is a civil engineering company based in Benin. Contracts are carried out under the supervision of project managers who are sent out from Head Office and remain on site for the duration of the contract. The project manager recruits local labour, and arranges for plant and materials to be provided by Head Office. Some time ago, the company successfully tendered for two contracts which have now become mutually exclusive. It is currently considering which of these to accept. Both jobs would last for 12 months. 67 The following information about each contract is available: Abuja Lagos ₦’000 ₦’000 Contract price 17,000 18,000 Penalty payment (i.e. a condition of the tender if offered the job and it is not accepted) 1,600 800 Materials

RequiredIn store (at cost) Contracted for To be ordered (at current cost) 2,000 - 4,000 2,400 3,600 3,400 Labour required: Project manager’s salary Travel, lodgings etc. Local recruitment 1,000 400 7,000 1,000 400 5,600 Head office: Plant depreciation Interest on plant General administration 600 200 800 600 200 800 Notes: (i) The materials which would be used on the Abuja job have increased in money value by 60% over their purchase cost. Tayo Limited has no other use for these materials on any other contract apart from the Abuja one, but they could be re- sold to other companies in the industry at 90% of their value. Transportation and other selling costs would further decrease the cash inflow from the sale by 16.67% of the sales price. (ii) The materials for the Lagos job have no other obvious use, but could be sold for scrap if the contract were cancelled. The scrap value would be 10% of cost, and costs of transport, etc. would be paid by the scrap merchant. It is likely, however, that the materials could be used next year on another contract in substitution for a different material normally costing 20% less than the cost of the materials to be used on the Lagos contract. (iii) Local labour can be hired as and when required. (iv) Plant is depreciated on a straight line basis, and the interest on plant charge is a nominal cost added for accounting purposes. (v) The two contracts would require similar plant, although more plant would be required for the Lagos than for the Abuja job. The plant not required on the Abuja job would be sub-contracted out by Head Office for ₦200,000 per annum. 68 (vi) Head office administration costs are fixed at ₦2,500,000 for the coming year. This excludes project managers’ salaries. Required:
a

Present the data to management in a form which will assist in making the decision as to which job to undertake. Provide notes to explain the principles which have been used in selecting the data and to support any calculations made.

12 marks
b

Comment on the appropriateness of the approach used in your analysis.

4 marks
c

List briefly any other factors which ought to be considered before finally making the decision in this case.

4 marks
Suggested answer

TAYO LIMITED

a) Consequences of undertaking the: Abuja Contract Lagos contract ₦’000 ₦’000 ₦’000 ₦’000 Contract revenue 17,000 18,000 Sale of materials held for the Abuja contract (Note 1) 2,400 Saving in material purchases by alternative use of materials for Lagos contract (note 2) 4,800 Hire of plant 200 _______ ₦22,000 ₦20,400 84 Incremental costs: Materials to be ordered (note 3) 4,000 3,400 Project manager’s travel, lodging, etc. 400 400 Local labour 7,000 5,600 Penalty for cancelling the other contract 800 1,600 12,200 11,000 Excess of revenue/savings over incremental costs ₦9,800 ₦9,400

Notes: i. If the Lagos job is undertaken, sales of materials no longer required for the Abuja job would be: ₦’000 Current market price = ₦2,000 × 1.60 = 3,200 Sales value = ₦3,200 × 90% 2,880 Less transport cost (16.67%) 480 Net sales revenue 2,400

ii. If the Abuja job is undertaken, the materials for the Lagos job might be re-used on a different contract, thereby saving the purchase of additional materials: ₦’000 Materials held 2,400 Contracted for 3,600 Cost of unwanted materials 6,000 Saving in purchases on different contract (80%) ₦4,800

iii. The materials contracted for to carry out the Lagos job must be paid for whatever happens. Although not yet received, they must be paid for whichever (if either) contract is undertaken. It is therefore not an incremental cost chargeable to the Lagos contract. For similar reasons, materials already held are not an incremental cost to their respective contracts. The alternative use of materials not required, is however, significant - and this has been taken into account on the revenue side of the analysis.

iv. It is assumed that the project manager’s salary is a fixed cost, whichever contract (if either) is undertaken. Incremental labour costs are therefore travel, lodgings etc. and local labour.

v. The penalty cost of failing to undertake one contract should be treated as a consequential cost of undertaking the other contract.

vi. The excess of revenue/savings over incremental costs calculated for each contract shows the comparative effect on profits of undertaking each job in preference to the other. The difference between the two figures (₦9,800,000 85 and ₦9,400,000) shows that there is a difference between the two projects of ₦400,000 in favour of the Abuja job.

b. The approach used has assumed that one project or the other will be undertaken. Some costs have already been incurred (some materials, plant); other costs have been committed (project manager’s salary, head office administration) and others are notional (interest on plant). These are not relevant to any decision about the future action. The only relevant considerations should be:

i. future revenues or cash savings as a consequence of the decision; ii. future costs, incurred as an additional expense as a consequence of the decision. In the situation in part (a), incremental revenues are the revenues from the contract undertaken, alternative uses of materials held but not required and hire of plant. Incremental costs are only those additional costs which would be incurred as a result of the decision to undertake one of the contracts. The cost accounting profit or loss recorded for each contract might be: Abuja: ₦17,000,000 – ₦16,000,000 = ₦1,000,000 Lagos: ₦18,000,000 – ₦18,200,000 = (₦200,000) These figures are irrelevant to a decision because the costs include past, committed or notional costs, and other revenues and penalty costs to the company are ignored.

c) Other factors to consider are:

i. the constraints on working which make the contract mutually exclusive. If there is a shortage of labour, funds etc. it might be possible to overcome and carry out both projects; ii. the likelihood of another contract being offered for the same period of time, which is more profitable than either the Abuja or Lagos jobs; iii. loss of goodwill and future contracts by not undertaking either project; iv. reliability of the prospective customer in each contract v. reliability of costs forecasts, labour availability etc. on both contracts. The net difference between the two jobs, ₦400,000, is relatively small and sensitivity/risk analysis will be very important; vi. the preference for the Lagos contract (by ₦400,000) has assumed that the alternative use for the Lagos contract materials will exist. It is only a likelihood, however. Failure to obtain this saving would shift the preference strongly in favour of accepting the Lagos job. 86

Examiner’s report The question test’s candidates ability to answer questions on relevant costing and decision making. The question was well attempted. The Performance was above average. The major pitfall observed was candidates’ inability to decipher relevant costs of material, labour and overhead in situations involving replacement and historical costs. It is hereby advised that candidates should use ICAN study manual on Performance Management when preparing for future institute’s examination.

Marking guide a Date to assist Decision Making (24 ticks @½ mark) 12 b Comment on Appropriations (Any 4 points @ 1mark) 4 c List of factors (Any 4 points @ 1mark) 4 20

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, May 2023, Question 4
5
Theory question 5Section C
15 marks
a 10b 5

A company is considering whether or not to invest in any of the two projects where the initial cash investment would be N13,000,000 for A and N14,000,000 for B. The project would have a five-year life, and the estimated annual cash flows are as follows: Project A Year Cash inflows Cash outflows N N 1 6,000,000 3,000,000 2 8,000,000 4,000,000 3 10,000,000 4,000,000 4 9,000,000 3,000,000 5 Total 6,000,000 39,000,000 3,000,000 17,000,000 Project B Year Cash inflows Cash outflows N N 1 10,000,000 5,000,000 2 9,000,000 4,000,000 3 8,000,000 3,000,000 4 8,000,000 3,000,000 5 4,000,000 2,000,000 Total 39,000,000 17,000,000 69 The company cost of capital is 10%. The estimates of cash outflows are considered fairly reliable. However, the estimates of cash inflows are much more uncertain. Several factors could make the annual cash flows higher or lower than expected. Factor 1: There is a 20% probability that government measures to control the Industry will reduce annual cash inflows by 25%. Factor 2: There is a 30% probability that another competitor will also enter the market: this would reduce the estimated cash inflows by 10%. Factor 3: There is a 40% probability that demand will be stronger than expected. The company would not be able to supply more products to the market, but it would be able to sell at higher prices and cash inflows would be 5% higher than estimated. Required:

a

Calculated the expected net present value of the two projects.

10 marks
b

Which of the Projects will be more profitable?

5 marks
Suggested answer

a. Calculate the expected net Present value of the two Projects Computation of joint Probability distribution S/N Factor 1 Factor 2 Factor 3 Workings Joint Probability 1 YES YES YES 0.2 x 0.3 x 0.4 0.024 2 YES YES NO 0.2 x 0.3 x 0.6 0.036 3 YES NO NO 0.2 x 0.7 x 0.6 0.084 4 NO NO NO 0.8 x 0.7 x 0.6 0.336 5 NO NO YES 0.8 x 0. 7 x 0.4 0.224 6 NO YES YES 0.8 x 0.3 x 0.4 0.096 7 YES NO YES 0.2 x 0.7 x 0.4 0.056 8 NO YES NO 0.8 x 0.3 x 0.6 0.144 Total 1.000 87 Impact on inflow S/N Joint Probability Inflow impact Result Final expected value 1 0.024 1 - 0.25 -0.10 + 0.05 0.70 0.0168 2 0.036 1 -0.25 – 0.10 0.65 0.0234 3 0.084 1 – 0.25 0.75 0.0630 4 0.336 1-0.0 1.00 0.3360 5 0.224 1 +0.05 1.05 0.2352 6 0.096 1 -0.10+ 0.05 0.95 0.0912 7 0.056 1 – 0.25 + 0.05 0.80 0.0448 8 0.144 1 – 0.10 0.90 0.1296 1.000 0.9400 Thus the EV of considering the 3 factors is 0.94. Therefore the NPV of Project A and B are: Project A Year Cash inflow EV of Cash flow Cash outflow Net Cash flow Discount rate 10% PV of cash flow N’000 N’000 N’000 N’000 N’000 0 - (13000) (13,000) 1.000 (13000) 1 6000 x 0.94 5640 (3000) 2640 0.909 2399.76 2 8000 x 0.94 7520 (4000) 3520 0.826 2907.52 3 10000 x 0.94 9400 (4000) 5400 0.756 4002.40 4 9000 x 0.94 8460 (3000) 5460 0.683 3729.18 5 6000 x 0.94 5640 (3000) 2640 0.621 1639.44 NPV +1678.30 Project B Year Cash inflow EV of Cash flow Cash outflow Net Cash flow Discount rate 10% PV of cash flow N’000 N’000 N’000 N’000 N’000 0 - (14000) (14,000) 1.000 (14000) 1 10000 x 0.94 9400 (5000) 4400 0.909 3999.60 2 9000 x 0.94 8460 (4000) 4460 0.826 3683.96 3 8000 x 0.94 7520 (3000) 4520 0.756 3417.12 4 8000 x 0.94 7520 (3000) 4520 0.683 3087.16 5 4000 x 0.94 3760 (2000) 1760 0.621 1092.96 NPV +1280.80

b. Project A will be more profitable with a higher NPV of N1,678,300 88

Examiner’s report The question test’s candidates’ ability to provide solutions on investment appraisal decision with sensitivity components. The question was well attempted. The Performance was above average. The major pitfall observed was the candidates’ inability to decipher the sensitivity issues that bother on factors that affect the cash inflows for both Projects A and B. It is hereby advised that candidates should use ICAN study manual on Performance Management when preparing for future Institute’s examination.

Marking guide

a. Expected Net Present Value

• Joint Probability (9 ticks @1/6 marks) 1½

• Impact on cashflow (9 ticks @1/6 marks) 1½

• (7 ticks @1 mark) 7 10 b. The more profitable project (10 ticks @½ mark) 5 15

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, May 2023, Question 5
6
Theory question 6Section C
15 marks

TK is a theme park. The following information is available for the forthcoming month: Forecast daily ticket sales and prices Ticket Price per sales ticket Pre-booked discounted ticket 1,500 N580 Standard ticket 8,000 N780 Premium family ticket (admits 4 people) 675 N3,700 The theme park will be open for 30 days in the month. Costs Variable costs per person per day are forecast to be N2050 Fixed costs for the month are forecast to be N130,000,000 Pricing information The sales of pre-booked discounted tickets and standard tickets will be restricted to 1,500 and 8,000 per day respectively for the forthcoming month. It is forecast that all of these tickets will be sold. 70 A premium family ticket admits four people to the theme park and allows them to go to the front of the queues in the theme park. The price of a premium family ticket has been set at N3,700 in order to maximise the profit from the sale of these tickets for the month. Market information shows that for every N100 increase in the selling price of a premium family ticket, the demand would reduce by 25 tickets. For every N100 decrease in the selling price, the demand would increase by 25 tickets. The theme park has adequate capacity to accommodate any level of demand for the premium family tickets. It is to be assumed that four people would always be admitted on every premium family ticket sold. Sales of the different ticket types are independent of each other. Equipment hire TK is considering hiring some automated ticket reading equipment for the forthcoming month. The hire of this equipment would increase fixed costs by N5,000,000 for the month. However, variable costs per person would be reduced by 8% during the period of the hire. Required:

a

Calculate the financial benefit of hiring the equipment for the forthcoming month given its impact on variable cost and the price charged for premium family tickets.

11 marks
b

It has now been realised that a competing theme park is planning to offer discounted ticket prices during the forthcoming months. It is thought that this will reduce the demand for TK’s standard tickets. TK will not be able to reduce the price of the Standard Tickets for the forthcoming month. Discuss the sensitivity of the decision to hire the equipment to a change in the number of standard tickets sold per day. (Note: your answer should include the calculation of the sensitivity). (4 Marks) 71

Suggested answer

a) Current Position Particulars Pre-booked Standard Premium Family Sales Price per ticket ₦580 ₦780 ₦3,700 No of ticket 1,500 8,000 675 Monthly sales in quantity 30 x 1500 =45,000 240,000 20,250 Monthly Fixed Costs N130,000,000 Determination of Optimal price of Premium family: P = a + bx Where a = Maximum Price at which no Premium Ticket will be sold: b = Changes in P = Price Elasticity Changes in X Marginal cost = Variable Cost = N2050 x 0.92 = N1886 =b

- 100 25 -= 4 89 Therefore: bxap = + xaP =

- 4 700,3 =a- 6754 ( ) = a- 2700 a = 3700 + 2700 a= .400,6 Therefore P = 4400,6 - x Converting to Total Revenue TR=P x Q ( 4400,6 - xx ) = 400,6 xx - 24 MR = ∂ ∂TR x= 8400,6- x MC = VC = 1886 Pr isofitmax imized where MR =MC 886,18400,6 -x= - 400,6886,18 x = - - 514,48 x = - x=

- 8/514,4 - x= 564 units Contribution: Pre-booked Ticket Premium Price 580 780 6,400 Variable Cost (1,886) (1,886) (1,886) (1,306) (1,106) 4.514 Tickets sold per month 45,000 240,000 16,920 (58,770,000) (265,440,000) (76,376,880) Total Quantity for the month 1500 x 30=45,000; 8,000 x 30=240,000; 564 x 30=16,920 Total Contribution Prebooked Ticket (58,770,000) Standard Ticket (265,440,000) Premium Ticket 76,376,880 (247,833,120) Decision: No financial benefit unless it is undertaken for corporate social responsibility 90 Standard Ticket

b. Sensitivity Analysis Variable Cost Savings from Standard Ticket [(2,050 – 1,886) x 8,000 x 30] = 39,360,000 Hiring Cost of equipment = (5,000,000) 34,360,000

Examiner’s report The question tests candidates’ ability to provide solutions on optimal pricing, marginal cost and sensitivity implication on hire of ticketing equipment. The question was well attempted. The Performance was above average. The major pitfall observed was the candidates’ inability to decipher the method to be used to compute the marginal revenue as well as determine the sensitivity components of hire of the ticketing equipment. It is hereby advised that candidates should use ICAN study manual on Performance Management when preparing for future Institute’s examination.

Marking guide a Financial benefit and Premium Price Charged (22 ticks @½ mark) 11 b Sensitivity Analysis (4 ticks @1 mark) 4 15

Source: ICAN Pathfinder, Skills Level Examination, Performance Management, May 2023, Question 6
7
Theory question 7Section C
15 marks

Kola Plc produces and sells a brand of security padlock keys. Its budget for next year is as follows: N’000 N’000 Sales 18,000 Materials (15,000 kg) 1,800 Labour (42,000 hours) 7,560 Variable production overheads (absorbed on labour hours) 2,520 Fixed production overheads (absorbed on labour hours) 1,260 Administration overheads (absorbed on labour hours) 2,520 15,660 Profit 2,340 When reviewing the budget, the company is approached by a customer asking for a quote for a special security padlock keys - superior lock. Kola Plc is a bit apprehensive about the order since they tried a similar venture at the end of last year and made heavy losses as shown below: N N Sales (200 units) 960,000 Materials (500kg) 54,000 Labour (5,000 hours) 840,000 Variable production overheads (N42/hour) 210,000 Fixed production overheads (N24/hour) 120,000 Administration overheads - (N36/hour) 180,000 1,404,000 Loss (444,000) Further research showed that the time taken for the first 50 units of these was 1,800 hours and the first 100 units took 3,000 hours. The customer is insistent that Kola Plc at least quotes a price for his requirement of 400 units though part of Kola plc’s reluctance to do so arises from the fact that the order would divert labour away from the planned production of the regular padlock keys and the company has found it impossible to recruit more staff. If the contract is taken on, the same type of material would be used as for the regular padlock keys, fixed production overheads of N150,000 and N30,000 of administration costs would be incurred.

RequiredCalculate the minimum price Kola plc should quote for the 400 units of the special padlock keys. 72 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 in price change in quantity 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 = 𝑛 𝑋𝑌 − 𝑥 𝑌1 2 (𝑛 𝑋2− 𝑋 2 (𝑛 𝑦2− 𝑋 2 73 The Miller-Orr Model 𝑆𝑝𝑟𝑒𝑎𝑑 =3 x 13 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 . 34x Transaction Cost x Variance of Cash flows Interest rate as a proportion 74 75
Suggested answer

Working Notes

• The contract time for the 400 units is calculated using the learning curve technique. The company has already produced 200 units and now needs to produce another 400, i.e. 600 in total.

• The learning rate is computed as follows: Cumulative Cumulative Cumulative Average Quantity Hours Hours per unit 50 1,800 36 100 3,000 30 The learning rate is therefore 30/36 = 831/3%

• The contract time can now be determined using the learning curve formula: Y = axb 91 Where: Y = Cumulative average time for the cumulative output of 600 units A = the average time for the first batch i.e. 36 hours x = Output level desired Number of units in the 1st bacth = 600 50 = 12 b = Log of .83333 Log of 2 = −0.263 :. Y = 36(12)-0.263 = 18.73 hours Total hours for the 600 units= 600 x 18.73 = 11,238 hours Less: Total hours for the first 200 units already produced 5,000 hours Hours now required 6,238 hours

• Contribution per labour hour. This is necessary because labour is in short supply. Any labour hour used on the special order entails opportunity cost. From the budget statement. N’000 N’000 Sales 18,000 Materials 1,800 Labour 7,560 VOH 2,520 11,880 Contribution 6,120 Budgeted labour hours 42,000 Contribution/hour = 6,120,000 ÷ 42,000 = ₦145.71 Calculation of minimum price ₦ Materials 1,000kg x N1,800,000 = 120,000 15,000 Labour 6,238 x 7,560,000 = 1,122,840 42,000 VOH 6,238 x 2,520,000 = 374,280 42,000 Direct fixed costs = 180,000 Opportunity cost of labour 6,238 x ₦145.71 908,939 Minimum price N2,706,059

Examiner’s report This question tests candidates’ ability to use relevant costing approach to determine the minimum price to quote for special security padlock considering the learning effect on labour hours. The question was fairly attempted. However, the performance was average. The major pitfall observed was candidate inability to take note of the implication of learning effect on labour and variable overhead cost. It is hereby recommended that candidates should use ICAN study manual on Performance Management when preparing for future Institutes’ examination.

Marking guide The Minimum Price (15 ticks @1 mark) 15 ICAN/231/Q/B5 Examination No.................... THE INSTITUTE OF CHARTERED ACCOUNTANTS OF NIGERIA SKILLS LEVEL EXAMINATION – MAY 2023 PUBLIC SECTOR ACCOUNTING & FINANCE EXAMINATION INSTRUCTIONS PLEASE READ THESE INSTRUCTIONS BEFORE THE COMMENCEMENT OF THE PAPER

1. Check your pockets, purse, mathematical set, etc. to ensure that you do not have prohibited items such as telephone handset, electronic storage device, programmable devices, wristwatches or any form of written material on you in the examination hall. You will be stopped from continuing with the examination and liable to further disciplinary actions including cancellation of examination result if caught.

2. Write your EXAMINATION NUMBER in the space provided above.

3. Do NOT write anything on your question paper EXCEPT your examination number.

4. Do NOT write anything on your docket.

5. Read all instructions in each section of the question paper carefully before answering the questions.

6. Do NOT answer more than the number of questions required in each section, otherwise, you will be penalised.

7. All solutions should be written in BLUE or BLACK INK. Any solution written in PENCIL or RED INK will not be marked. THE INSTITUTE OF CHARTERED ACCOUNTANTS OF NIGERIA

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