ABC Limited is engaged in the business of Manufacturing alloy components. The CFO of the Company estimates that the Turnover of Company for the forthcoming Financial Year will be ₹100 Crore and thereafter year on year th

CS Professional · Valuations & Business Modelling · PYQS · June 2019
ABC Limited is engaged in the business of Manufacturing alloy components. The CFO of the Company estimates that the Turnover of Company for the forthcoming Financial Year will be ₹100 Crore and thereafter year on year the Company can achieve 10% growth. He has also estimated that Earnings Before Interest, Tax, Depreciation and Amortisations (EBITDA) for the forthcoming Financial Year will be 25% on Turnover. He also informs the Management that the Company can maintain the 25% EBITDA, provided there is not much change in the expenditure, as the 80% of expenditure of the Company is variable in nature. However, the purchase head of the Company comes out with the information that price for one of important Raw Material-'A', which forms 50% of the total raw materials is likely to rise upto 30% during the next Financial Year. (Raw Material Cost is estimated to be 60% of the Total Variable Cost). An alternate Raw Material-'P' is available, however it is costlier and it will bring down present EBITDA margin to 20%. It is expected that price of Material- 'P' will be stable in the next Financial Year. Assume there is no change in fixed or other variable expenses except change in Material 'A's price, as a part of the management you are required to: Find out % of Variable and Raw Material cost on Sales if Material 'P' is used and also find out at what levels of increase in Material-'A's price, the Company can opt for use of Raw Material-'P'.

Answer & Explanation:

Usage of Material 'P' Profitability using Material 'P' Turnover (₹) 100 EBITDA (₹) 20 Total Expenses (₹) 80 Total Variable Expenses (₹) (Total Expenses - Fixed Expenses) (80-15) 65 % of Variable Expenses in Total cost (65/80)% 81.25% Total Cost of Raw materials (Raw Material cost using Material A + 5 cr) (36+5) 41 % of Raw Material Cost (41/80)*100 51.25 Cost of Material P 23 % of Raw Material 'P' in Raw Material Cost (23/41)*100 56.10 Difference in Profitable when Material A raises by 30% (20-19.6) 0.40 At what % of material A price raise both material will be Similar 2.22 27.78 Upto 27.78% Of Material A's price raise it can be used, beyond that Material P can be opted.

Topics: Cost Management

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic