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:
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)
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.
Revise this question
Expected values and decision rules: maximax, maximin and minimax regret › Layouts for pay-off tables and decision rulesSuggested 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