Vidhi Specialty Food Ingredients Limited is a leading manufacturer of Superior Synthetic and Natural Food Grade Colours. The company manufactures as well as trades these goods. As an analyst it would matter to us to see how these manufacturing, trading and overall profit margins for this business looks like across the year. Let’s apply what we learnt in previous Blog 117 - Decoding Inventory & COGS Line items.
To compute overall margins, we need to first compute Total Operating income from the footnotes/ Income statement. Let’s take an example of FY20, where we can see the Total Operating income to be INR 22461.58 Lakhs. Please note, this includes Operating revenue of INR 21,345.21 Lakhs (inclusive of Excise, since Excise duty figures aren't available separately in financial statements, we won't be able to net it out of revenues) and Other Operating revenue of INR 1116.37 Lakhs.
Now that we have this clarity on revenue figures, lets compute COGS. Overall COGS as we now know it, will be a total of three line items
Cost of Materials Consumed (Raw materials consumed)
Change in WIP, FG & SIT
This amounts to a total of INR 13345.25 Lakhs. Thus, Gross profit = Total Operating Revenue - COGS
It's time we proceed to computing Manufacturing goods and Trading goods profit margins. Note, While computing Overall Gross profit margin, we will be taking a revenue figure of INR 22461.58 Lakhs, whereas while computing Manufacturing and Trading Gross profit margins, we will be referring to individual manufacturing and trading revenue figures (INR 18229.84 lakhs and INR 3115.37 Lakhs respectively).
Now that we have manufacturing revenue figures, To calculate Manufacturing gross profit margin, we need Manufacturing COGS which is computed as follows:
Manufactured COGS = Cost of Materials Consumed + Changes in WIP and FG = 10630.25+814.30-1130.07+748.46-603.08 = INR 10459.86 lakhs