Okohia Ugo Manufacturing Company limited manufactures four types of fans named, Exclusive, Premium, Deluxe, and Standard with the following codes: E, P, D and S. The Financial Controller, with the approval of the Board, wants to review the profitability of the Company’s four products and the effect of several proposals for varying the product mix. The net profit margin of 25% profitability target for each product is desired. The following information are available for 2023. Particulars E P D S Total Units Produced/Sold 20,000 24,000 36,000 40,000 Materials N4.400,00 0 N5,200,00 0 N7,600,000 N8,400,00 0 N25,600,00 0 Labour N2,000,00 0 N2,360,00 0 N3,440,000 N3,800,00 0 N11,600,00 0 Overheads N1,600,00 0 N1,840,00 0 N2,560,000 N2,800,00 0 N8,800,000 The products use the same materials, labour and overheads. The possible unit selling prices of individual products are given below: Particulars E P D S Amount Pr Amount Pr Amount Pr Amount Pr Selling Price N800 0.5 N500 0.3 N900 0.2 N850 0.5 N700 0.3 N540 0.5 N800 0.3 N750 0.3 N600 0.2 N600 0.2 N700 0.5 N650 0.2 The company considers specific fixed costs for each products and general fixed cost attributable to the company. The specific fixed costs are attributable to individual products while the company fixed cost is considered to be N21,665,000 per period. Required:
i. Determine the expected selling price for each product. (3 Marks) ii. Determine the unit variable cost of each product. (3 Marks)
Prepare a profit statement based on marginal costing approach for each product and the company, stating the company’s net profit or loss as well as stating which product(s) achieved the 25% profit margin target.
Determine the effect on the company’s net profit if: (i) Product D is discontinued due to legislative provisions. (3 Marks) 61 (ii) Product D is discontinued and this resulted in a consequent loss of customers, causing a decrease of 4,000 units in sales of Product P. \` (3 Marks) (iii) Product D’s selling price is increased to N860 with a resultant decrease in quantity produced and sold to be 30,000 units, with no effects on other products. (3 Marks) (iv) Product E is increased by 10,000 units to be sold at N500 each by adding a second shift in which higher wages must be paid which increases the direct labour cost per unit to N60 for each additional unit. (3 Marks) (v) Production of product E is reduced to 10,000 units which will be sold at a selling price of N800 each, and if production of Product S is increased to 50,000 units to be sold at N700 each. Part of the plant in which Product E is produced can easily be adapted to produce Product S. (4 Marks)
State THREE limitations of sensitivity analysis.
Revise this question
One-off contracts, shutdown and further processing of joint products › Layouts for the three decisionsReducing uncertainty: research, simulation and sensitivity analysis › Layouts for simulation and sensitivityExpected values and decision rules: maximax, maximin and minimax regret › Layouts for pay-off tables and decision rulesHigh-low method and cost estimation for budgets › Layouts for the high-low methodSuggested answer
ai. Determination of expected selling price for each product Product E Product P Product D Product S Amt Pr EV Amt Pr EV Amt Pr EV Amt Pr EV 800 0.5 400 500 0.3 150 900 0.2 180 850 0.5 425 700 0.3 210 540 0.5 270 800 0.3 240 750 0.3 225 600 0.2 120 600 0.2 120 700 0.5 350 650 0.2 130 Selling Price = N730 Selling Price = N540 Selling Price = N770 Selling Price = N780
ii. Determine the unit variable cost of each product Since the Products use the same materials, Labour and overheads Computing the variable cost Using High – Low method: Cost Item Cost of Highest Quantity Cost of Lowest Quantity Cost Difference Difference between High and Low quantities Variable cost = Cost Difference /Difference in Quantity Material 8,400,000 4,400,000 4,000,000 40,000 – 20,000 = 20,000 N200 Labour 3,800,000 2,000,000 1,800,000 40,000 – 20,000 = 20,000 N90 Overhead 2,800,000 1,600,000 1,200,000 40,000 – 20,000 = 20,000 N60 Variable costs for each Product Cost Element Product E Product P Product D Product S N N N N Material 200 200 200 200 Labour 90 90 90 90 Overhead 60 60 60 60 Total unit Variable cost 350 350 350 350
b. Profit Statement (Marginal Costing Approach) Particulars Product E Product P Product D Product S Total Units 20,000 24,000 36,000 40,000 Sales 14,600,000 12,960,000 27,720,000 31,200,000 86,480,000 Variable 7,000,000 8,400,000 12,600,000 14,000,000 42,000,000 70 cost Contribution 7,600,000 4,560,000 15,120,000 17,200,000 44,480,000 Fixed Overead 1,000,000 1,000,000 1,000,000 1,000,000 4,000,000 Attributable Profit 6,600,000 3,560,000 14,120,000 16,200,000 40,480,000 Profit margin 45.20% 27.469% 50.94% 58.441% General Fixed overhead 21,665,000 Net Profit N18,815,000 All the 4 products achieved 25% profit margin or more benchmark. Computation of fixed costs N Material: Total cost @ 20,000 units = 4,400,000 Variable cost (N200 x 20,000) 4,000,000 Material Fixed cost 400,000 Labour: Total cost @ 20,000 units = 2,000,000 Variable cost (N90 x 20,000) 1,800,000 Labour Fixed cost 200,000 Overhead: Total cost @ 20,000 units = 1,600,000 Variable cost (N60 x 20,000) 1,200,000 Overhead Fixed cost 400,000 Total Fixed Overhead 1,000,000
c. Effect on Company’s Net Profit:
i. If Product D is discontinued: Particulars Product E Product P Product S Total Units 20,000 24,000 40,000 Sales 14,600,000 12,960,000 31,200,000 58,760,000 Variable cost 7,000,000 8,400,000 14,000,000 29,400,000 Contribution 7,600,000 4,560,000 17,200,000 29,360,000 Fixed Overead 1,000,000 1,000,000 1,000,000 3,000,000 Attributable Profit 6,600,000 3,560,000 16,200,000 26,360,000 Less General fixed cost 21,665,000 Net Profit 4,695,000
ii. If D is discontinued and P sales decreased by 4,000 units: Particulars Product E Product P Product S Total Units 20,000 20,000 40,000 Sales 14,600,000 10,800,000 31,200,000 56,600,000 Variable cost 7,000,000 7,000,000 14,000,000 28,000,000 71 Contribution 7,600,000 3,800,000 17,200,000 28,600,000 Fixed Overead 1,000,000 1,000,000 1,000,000 3,000,000 Attributable Profit 6,600,000 2,800,000 16,200,000 25,600,000 Less General fixed cost 21,665,000 Net Profit 3,935,000
iii. Where Product D selling Price increased to N860 and quantity decreased to 30,000 units: Particulars Product E Product P Product D Product S Total Units 20,000 24,000 30,000 40,000 Selling Price N730 N540 N860 N780 Sales 14,600,000 12,960,000 25,800,000 31,200,000 84,560,000 Variable cost 7,000,000 8,400,000 10,500,000 14,000,000 39,900,000 Contribution 7,600,000 4,560,000 15,300,000 17,200,000 44,660,000 Fixed Overead 1,000,000 1,000,000 1,000,000 1,000,000 4,000,000 Attributable Profit 6,600,000 3,560,000 14,300,000 16,200,000 40,660,000 Less General Fixed Cost 21,665,000 Net Profit 18,995,000
iv. Where Product E is increased by 10,000 units to be sold at N500 each and additional Labour cost at N60 for each additional unit. Particulars Product E Product P Product D Product S Total Units 20,000 24,000 36,000 40,000 Selling Price N730 N540 N770 N780 Sales 14,600,000 12,960,000 27,720,000 31,200,000 86,480,000 Variable cost 7,000,000 8,400,000 12,600,000 14,000,000 42,000,000 Contribution 7,600,000 4,560,000 15,120,000 17,200,000 44,480,000 Fixed Overead 1,000,000 1,000,000 1,000,000 1,000,000 4,000,000 Attributable Profit 6,600,000 3,560,000 14,120,000 16,200,000 40,480,000 Net Returns on Additional Uints revenue (N500 - N410) 900,000 900,000 7,500,000 3,560,000 14,120,000 16,200,000 41,380,000 72 Less General fixed cost 21,665,000 Net Profit 19,715,000
v. If Product E is reduced to 10,000 units and sold at N800 each and Product S is increased to 50,000 units and sold at N700 per unit Particulars Product E Product P Product D Product S Total Units 10,000 24,000 36,000 50,000 Selling Price N800 N540 N770 N700 Sales 8,000,000 12,960,000 27,720,000 35,000,000 83,680,000 Variable cost 3,500,000 8,400,000 12,600,000 17,500,000 42,000,000 Contribution 4,500,000 4,560,000 15,120,000 17,500,000 41,680,000 Fixed Overead 1,000,000 1,000,000 1,000,000 1,000,000 4,000,000 Attributable Profit 3,500,000 3,560,000 14,120,000 16,500,000 37,680,000 Less General Fixed cost 21,665,000 Net Profit 16,015,000
d. Limitations of sensitivity analysis:
• No probability insight or probability of likely occurrence;
• Variables are static and may be misleading;
• Ignores variability interaction hence one variable focused;
• Oversimplifies extreme risk; and
• Sustains garbage in Garbage out in cost.
Examiner’s report This is a compulsory question under the new syllabus which test candidates’ ability in using marginal costing approach in preparing profit statement. It also dwells on expected value computation for selling prices, use of high-low methods in cost separation into variable and fixed costs, and application of sensitivity analysis in decision making. The question was well attempted and the candidates’ performance was however average. The major pitfall was the candidates’ inability to decipher the sensitivity issues in part (c) iii to v. It is hereby recommended that candidates use ICAN Study Text and other Performance Management text books in preparing for future Institute’s examinations. 73
Marking guide Sect. Description Marks Marks Marks ai. 4 ticks = 3 marks 3 ii. 3 ticks = 3 marks 3 6
b. 35 ticks = 5 marks 5
ci. 3 ticks = 3 marks 3 ii. 3 ticks = 3 marks 3 iii. 3 ticks = 3 marks 3 iv. 3 ticks = 3 marks 3 v. 4 ticks = 4 marks 4 16
d. 3 ticks = 3 marks 3 30