Azuka Nig. Plc is a listed company that manufactures high quality products for use by the bakery industry. These high quality products help in facilitating significant and sustainable growth to Baking outfits. The Company has its prime plants in Abuja and a factory in Lagos where it manufactures these products using skilled labour and quality materials available from its suppliers. The market for the product is high. The bakery products produced are of three classes, Super-class, Medi-class and Mini-class. The following information relates to the production and sales of each of the products at the Lagos factory: Mini-class Medi-class Super-class Direct material cost N50,000 N71,000 N90,000 Direct labour @N6,000 per hour N12,000 N15,000 N18,000 Variable overhead @ ₦3,000 per machine hour N6,000 ₦9,000 N12,000 The unit sales price N90,000 N110,000 N125,000 Annual production in units 500 300 200 The total fixed overhead budgeted for the year in Lagos factory is N12,000,000. The company has enough direct labour force for production capacity. The available machine hours are 2,500 hours. The investment cost for the Lagos Plant is N35 million at a cost of capital of 10%. As a result of the limitation in the Lagos plant capacity, the company decided to establish the Port Harcourt plant where the 3 major types of bakery product will be produced. 100 The variable cost structure will be maintained while the company intends to implement the following changes in the new plant: (i) Unit selling price of mini-class will be reduced by 10%, but the quantity of production and sales will increase by 15%; (ii) Unit selling price of medi-class will be increased by 5%, but the quantity of production and sales will reduce by 10%; and (iii) Unit selling price of Super-class and quantity of production and sales will be maintained. The following information is available for the factory in Port Harcourt. (i) The annual fixed overhead is estimated at N9,000,000; (ii) The available machine and labour hours are enough to achieve desired production capacity; and (iii) The investment is N38million at ruling rate of 10%. You are required to:
Using the marginal costing approach, compute the optimal product mix that will be produced in the Lagos Plant in order to maximise profit showing the net profit by the product.
Using the throughput accounting model, determine which of the three products is more profitable in Lagos Plant and show the net profit made by the plant.
Prepare a marginal costing statement showing the profit generated in the Port Harcourt Plant.
Compute the breakeven sales in units and value for Port Harcourt Plant.
Prepare the marginal costing statement of the company using your solution in a. and c above.
Using the residual income approach, explain the viability of the two plants.
Revise this question
Throughput accounting: theory of constraints and the throughput accounting ratio › LayoutsBreak-even analysis and margin of safety for Skills level decisions › LayoutsContribution to sales ratio, target profit and target revenue › LayoutsLimiting factors: allocating a single scarce resource › LayoutsDivisional performance: return on investment and residual income › Layouts for divisional performanceSuggested answer
Azuka Nig. Ltd
a. Optimal product mix that will maximise Lagos Plant profit using marginal costing approach. MI ME SU N N N Selling price 90,000 110,000 125,000 Direct material 50,000 71,000 90,000 Direct labour 12,000 15,000 18,000 Variable overhead 6,000 9,000 12,000 Total variable cost 68,000 95,000 120,000 Contribution 22,000 15,000 5,000 Machine hours per unit 2 hours 3 hours 4 hours Contribution per hour N 11,000 N 5,000 N 1,250 Ranking 1st 2nd 3rd Allocation of available Machine hours: Available machine hours 2,500 hrs Production of Product MI 500 units x 2 (1,000) hrs Balance 1,500 hrs Production of ME 300 units x 3 (900) hrs Balance 600 hrs Production of SU = 600hour /4 150 units = (600) hrs Contribution: N MI = 500 units x 22,000 = 11, 000,000 ME = 300 units x 15, 000 = 4,500,000 SU = 150 units x 5,000 = 750,000 Total contribution 16,250,000 Less fixed cost (12,000,000) Net profit 4,250,000 111
b. Determination of most profitable product and Lagos Plant net profit using throughput accounting. MI ME SU Selling Price N 90,000 N110,000 N125,000 Direct material N50,000 N71,000 N90,000 Throughput returns N40,000 N39,000 N35,000 Machine hours per unit 2 hours 3 hours 4 hours Throughput returns /hour N20,000 N13,000 N8,750 Operating costs N Variable costs less material N18,000 x 500 + N24,000 x300 + N30,000 x 200 = N9,000,000+ N7,200,000 + N6,000,000 = 22,200,000 Fixed cost = 12,000,000 Total operating cost = 34,200,000 Total hours = 2,500 Machine hours Operating cost per hour N34,200,000/2,500 = N13,680 Throughput Accounting ratio = Throughput return per hour/Operating cost per hour MI ME SU Throughput returns /hour N20,000 N13,000 N8,750 Operating cost per hour N13,680 N13,680 N13,680 Throughput Accounting ratio 1.4620 0.9503 0.6396 Ranking 1st 2nd 3rd Allocation of available machine hours: Available machine hours 2,500 hrs Production of Product MI = 500 units x 2 = (1,000) hrs Balance 1,500 hrs Production of ME = 300 units x 3 = (900) hrs Balance 600 hrs Production of SU = 600hour /4 150 units= (600) hrs 112 Throughput returns : N N N MI = 500 units x 40,000 = N20,000,000 ME = 300 units x 39,000 = 11,700,000 SU = 150 units x 35,000 = 5,250,000 36,950,000 Operating cost (34,200,000) Net Profit 2,750,000
c. Marginal costing statement showing the profit generated in the Port Harcourt Plant. Mini- class Medi-class Super-class Adjusted Sales quantity 1.15 x 500 0.90 x 300 200 575 270 200 Adjusted selling price 0.9 x N90,000 1.05 x N110,000 N125,000 N81,000 N115,500 N125,000 Variable costs: N N N N Direct material 50,000 71,000 90,000 Direct labour @N6,000 per hour 12,000 15,000 18,000 Variable overhead @ N3,000 per Machine hour 6,000 9,000 12,000 Variable cost 68,000 95,000 120,000 Contribution per unit 13,000 20,500 5,000 Total contribution 7,475,000 5,535,000 1,000,000 14,010,000 Fixed cost (9,000,000) Net Profit 5,010,000 113
d. Breakeven sales in units and value for Port Harcourt Plant. Breakeven point in Units in a Multi-product:=Fixed Cost/Weighted Contribution Mini-class Medi-class Super-class Contribution per unit N13,000 N 20,500 N 5,000 Quantities in units 575 270 200 1045 Proportion 0.55 0.25837 0.19133 1.00 Weighted Contribution = N7150 + N5,296.585 + N958.15 = N13,404.735 BEP in Units = N9,000,000/N13,404.735 = 671 units Share of Product 369 173 129 Breakeven point in Value = FC/Weighted Contribution ratio Mini-class Medi-class Super-class Contribution per unit N13,000 N20,500 N5,000 Selling price N81,000 N115,500 N125,000 C/S ratio 0.1605 0.1775 0.04 Sales Revenue N46,575,000 N31,185,000 N25,000,000 N102,760,000 Sales Proportion 0.45324 0.30347 0.24329 1.00 Weighted C/S ratio 0.07275 0.05387 0.00973 0.13635 BEP in value = N9,000,000 / 0.13635 = N66,006,601 Share of Products = N29,916,832 N20,031,023 N16,058,746
e. Marginal costing statement of the company using solution in a and c. Marginal costing profit statement for the two plants and company) Particulars Lagos Plant Port Harcourt Plant Company N’000 N’000 N’000 Sales 96,750 102,760 199,510 Less: Variable costs (80,500) (88,750) (169,250) Contribution 16,250 14,010 30,260 Fixed cost (12,000) (9,000) (21,000) Net Profit 4,250 5,010 9,260 114
f. Use the residual income approach, explain the viability of the two plants. Particulars Plant one Plant two N’000 N’000 Sales 96,750 102,760 Less Variable costs (80,500) (88,750) Contribution 16,250 14,010 Fixed cost (12,000) (9,000) Net Profit 4,250 5,010 Imputed cost (3,500) (3,800) Residual Income 750 1,210 From the above report, the residual income referred to as the economic profit shows that both Plants are very viable generating positive residual incomes of N750,000 and N1,210,000 for Lagos and Port Harcourt plants respectively.
Examiner’s report This is a compulsory question under the new syllabus and dwells on advanced costing techniques with special emphasis on marginal costing, throughput accounting, breakeven analysis under conditions of limiting factor constraints. The question also tests candidates ability to determine the performance of the two plants (Lagos and Port Harcourt Plants) using the residual income parameter. The first part of the question tests candidates’ ability to compute maximum profit in the Lagos plant where there exists limiting factor. The second question tests candidates ability to determine company’s machine utilisation rate for each machine and also establish the machine hours per unit of product produced under the throughput accounting model. The third question dwells on the preparation of marginal costing statement for Port Harcourt Plant in view of issues of sensitivity analysis on selling price and quantity under a non-limiting factor situation in the plant. The fourth part of the question dwells on the determination of breakeven quantities and values for multi-product situation in the Port Harcourt Plant taking into consideration the effect of sensitivity analysis on product selling prices and quantities. The fifth part of the question is to prepare the company profitability statement using the marginal costing approach. The final part dwells on determination of the viability of the two plants using the residual income approach. The question being a compulsory question was well attempted. The candidates’ performance was however average (about 45%). The major pitfalls were: ► candidate inability to compute the operating costs as well as operating cost per available hour; and 115 ► inability of most candidates to differentiate between the use of limiting factor in conventional marginal costing and throughput analysis in preparing marginal costing statements. It is recommended that candidates use ICAN study manual and other Performance Management text books in preparing for future examination.
Marking guide Sect. Description Marks Marks Total a. Calculation of optimal product mix that maximises Lagos Plant profit using marginal costing approach (1/6 for each tick = 1/6 x 36) 6 b. Determination of most profitable product and Lagos Plant net profit using throughput accounting (¼ each for 28 ticks) 7 c. Marginal costing profit statement (1/4 each for 16 ticks) 4 d. Calculation of breakeven sales in units and value for Port Harcourt plant (1/4 each for 24 ticks) 6 e. Marginal costing profit statements for the two plants and the company (1/3 each for 12 ticks) 4 f. Preparation of residual income for the plants (1/4 each for 12 ticks) 3 30 116