Namaste.In our last two sessions, we were discussing CVP or BEP analysis.I hope you have understood the basic concepts now relating to first about variable cost, fixed cost, then the contribution margin, and then about the calculation of BEP.We will just have a look at what is PV ratio, because it is a very important calculation for any business, for any product or any particular plan.So, this is a relationship between the profit margin or a contribution margin as a percentage to revenue.So, we relate the sales price to variable cost, we get the contribution margin, and we divide it by selling price.So, we are known as a percentage suppose your sale of 10 lakhs, what is a gross margin or what is a contribution margin you are earning that is the PV ratio.If sales go up from 10 lakhs to 11 lakhs, on the extra 1 lakh of sales, what is the extra profit which you will earn that you get from PV ratio of contribution margin ratio?Now, the calculation is done like this.The basic formula was profit is equal to sales minus total cost, but we divide the total cost into a variable and fixed.And the contribution margin is a comparison between revenue and variable costs.To calculate the profit now sales minus variable cost you get a contribution. From contribution, we can deduct a fixed cost to know the profit.Now, the upper part that is from sales variable cost and contribution can be converted on per unit basis, because all these three components change as the number of units or the level of activity changes.Now, this profit formula is like this S minus V into Q is minus FC is profit, or you can use it to calculate Q that is projected quantity or the target quantity for a certain level of profit.So now, FC plus expected profit is in the numerator divided by S minus VC getting it? Then we also discuss the BEP analysis, I am just keeping its uses etcetera.We will go to formulae.Now, for calculating BEP in unit terms, our target is to earn fixed cost.So, fixed cost is kept in the numerator, we divide it by contribution per unit.If you want to make a short form you can say FC upon quantity per unit, always keep in mind that fixed cost is not per unit, fixed cost is in total.There is no sense to have a fixed cost on a unit basis; it is a total fixed cost to be recovered from a certain number of units.So, we divide it by contribution per unit, so that we know how many units you need to sell to recover that much of fixed cost which is nothing but a break-even.Now, many times it is difficult to have per unit data of contribution.So, instead of the contribution per unit, we divide it by the PV ratio formula. Now, what is the formula of PV ratio?It is a contribution upon sales.So, as a percentage what is our margin is the PV ratio we divide the fixed cost by PV ratio to get BEP in sales value.Now, this is the CVP - Cost Volume Profit graph, it is also called a breakeven chart.Have a look at it carefully, it is very important and I think all concepts will become clear; if you just look at it for a few seconds, getting it. So, you have got fixed cost which is a horizontal line not starting from 0, starting from a certain level about 1 lakh in this example.Then from there itself emerges a line going up which is a total cost line because the total cost is never 0, it is 0 at 0 units it is equal to fixed cost, and then it’s slowly going up in the proportion in which variable costs are increasing. Then this red line is known as total sales sometimes called as TR or other the total revenue line, it starts with 0 and it goes up at a particular point it crosses the TCor the other total cost line. This point is nothing but breakeven point because at this point you can cover all your costs and earn more revenue than your cost. Every company always wants to above this level of sales. Below this level is what is known as loss area because now your costs are more than sales.Above this level, your sales are more than costs.So, you are in the profit area.Once you cross breakeven every extra contribution you earn is all your profit because fixed costs are now covered.So, as the number of units increased, the profit area can go on increasing and increasing, but the loss area is limited maximum loss is equal to fixed cost at 0 points because the fixed cost is the costs which we incur irrespective of sales.So, at 0 you have incurred all your fixed costs the revenue is 0.So, fixed cost is a maximum loss from there the loss goes on decreasing it comes to 0at breakeven point; and above this, you have got profit that is why BEP is a very interesting and important calculation for most of the companies or plants because they want to at least break even getting it.Then we had discussed one illustration.Now, taking from this we will take or we will discuss one more concept I hope you remember this illustration.Now, suppose just have a look at this illustration once again.Their estimated sales were given as 12000 bikes at which level they had earned a profit of 5 lakhs.Now, based on these there is a concept called as MOS or Margin Of Safety.We know that company at 12000 units is above breakeven point how much above it is nothing but the margin of safety.So, we had calculated breakeven point to be in terms of units at 11400.The estimated sales are 12000, that means, 12 minus 11400, 600 bikes more than breakeven that is called a margin of safety in units.It can also be calculated in sales terms or it can be calculated as a percentage.So, you can sell 12000 units; that means, you have a margin of 600.So, 600 upon 12000 this how MOS is calculated as a percentage; I will just show you the formula.Getting it?The margin of safety is equal to actual sales minus breakeven sales either in units, you can do or you can in rupees you can do.Another way of showing it is MOS as a percentage: sales minus BEP that is your MOS is in bracket divided by actual sales.Just keep in mind that do not divide it by BEP some students mistake they calculator most divide it by BEP that will also give you some answer, but that is not a margin of safety as a percentage, getting it.Now, this represents the safety available to the business at the current level of sales because everybody wants to avoid losses.So, to avoid losses, you are above a certain level of sales how much you are above is the margin of safety.Now, let us try to do one simple illustration.So, Prabha Devi Ornaments, they have sales of 5000 units, the sale price is 50, the variable cost is 30, fixed cost is 35000.Now, compute BEP quantity amount as well as MOS as a percentage.So, do this calculation.So, how will you proceed?Firstly, you have to compare 50 and 30 because that is the primary profit you are earning.What that is known as 50 minus 30?I hope you remember that is called a contribution per unit.So, one calculation you will do in the beginning is to compute the contribution per unit.So, one unit you sell gives you 20 rupees.How much you have to earn a minimum?Minimum you have to earn enough to cover your 35000 because that is your fixed cost.So, 35000 upon 20 is a BEP quantity.You can convert the quantity into amount by multiplying it by 50 or you divide this 35000by PV ratio.So, how much is PV ratio? 50 minus 30, 20 is a contribution divided by 50, 20 by 50.So, 40 per cent is a PV ratio.Now, if you divide the fixed cost by 40 per cent you will get BEP amount.Now, having calculated quantity and amount go for calculation of MOS.I will show you the calculations.I hope it is clear to you 35000 divided by 20, that means, 1750 units is a breakeven point.You need to sell 1750 units to recover 35000.Now, in terms of sales value, you will have to first calculate PV ratio which is 20 by50; that means, 40 per cent 35000 by 40 per cent gives you 87500 rupees that is BEP in terms of rupees.So, the first two calculations we have done.Now, next is MOS; they have given a sales of 5000.So, compute MOS percentage.Now, 5000 is their sales level and what you require is only 1750.So, the difference between 5000 minus 1750 is their MOS and then convert it into percentage ok.So, the margin of safety 5000 minus 1750 divided by their current sales of which is 5000.So, you get 65 per cent.What it means is suppose their sale of 5000 starts falling let us say by 10 per cent, 20percent, 30 per cent, 40 per cent, they are still not in losses.They will have to worry because sales are dropping, but it can go up to 65 per cent before which they will not go in losses, that is why they have a margin of safety of 65 per cent.Are you getting me?So, these were simple illustrations.Now, let us go to the cases which have been shared with you.I hope you have got the printout.If not please take the printout, you can stop this video here, take the printout and let us try to solve those cases together ok.So, you have been shared with five cases.Let us go one by one.Let us start with Ganesh Ji.So, Ganesh limited is selling three products in brand names A, B and C. And these are the details of their cost structures.So, you know the direct material labour and variable overheads which are 8, 8, 9 for products selling price is 35, same way for B and C. The monthly fixed cost is 480000.Now, they have given the sales volume for 2 months in July and August.So, two sales mixes of given in July it is same 20, 20 and 20000 for A, B, C. And inAugust, it is something different.Now, we have to do two things first find the monthly profits.So, for both the months of July and August, calculate the profits of the company.And if your calculations bring out that higher profit is earned in the month of lower volume, kindly justify.So, think over why it is possible, is it possible, that lesser sales and more profits.And second in part B, if sales mix of each month is considered as two sales mixes say mix X 1 and mix X 2, compute the breakeven point for each mix and which of the two mixes you recommend.So, these two months are treated as two sales plans, and then we have to calculate which plan do you recommend.Ok, I hope you are getting it.So now, how will you go ahead, just think over?I think most of you know by now that the first step is calculating the contribution per unit.We know sales price; we know the variable costs.So, compute the contribution.Based on the contribution you can also compute the PV ratio for all the three products.Now, you know the number of units sold in July.So, contribution per number of units will give you a total contribution for July and August separately, from that deduct the fixed costs.Contribution minus fixed costs give you the proper in part we have been asked to calculate monthly profits, so that is the first thing you do it.And then we will discuss as to which month has more profits you can just see that in July their total sales are 20 plus 20 plus 20 means 60000.And in August their sales have slightly gone down.So, let us see which month gives you more profits.So, I am trying to show it in the excel.But you try to do it in your notebook.These are the 3 months.Firstly, make a statement of contribution, and for PV ratio.So, please make four columns particulars A, B, C.We start with sale price which is 36, 55 and 58 from that deduct variable cost per unit for each of the three products.I hope you are doing it with me.So, please write down the elements of variable cost, which is the DM, DL and variable overheads, which gives us the variable cost per unit.So, you have got 8, 8 and 9.So, take these figures here.Fine, you are getting it?So, 8 plus 8 plus 9 means variable cost per unit is 25.Selling price is 36; variable cost is 25, so contribution per unit is 11.So, from one unit of a company can make a contribution margin of 11.And as a percentage, it is 0.306.So, 11 upon 36 will give you this ratio known as PV ratio.Now, in the same manner, take the data for product B which is 14, 8 and 20, please compute the variable costs the total variable cost contribution and PV ratio.So, how much have you got, are you getting a contribution of 12?Just have a look at the solution total VC is 42, 54 minus 42 means twelve rupees is a contribution and PV ratio is 0.22 got it.Now, do it for product C. I think I do not have to show the solution.You can do it for C.Are you getting the contribution of 4 rupees?And 0.06 is the PV ratio.Please keep in mind for any case involving CVP analysis of marginal costing the starting point will be the calculation of contribution per unit.Sometimes you know for the unit, if you do not know you calculate the PV ratio for that type of units or for that line of activity, what is a margin company able to earn, this calculation is a starting point.This is the first compulsory calculation.Now, based on this let us calculate monthly profits.So, please make a profitability statement for July now.We know the selling price; we know the number of units.So, you can easily calculate sales.You know the contribution per unit also from the contribution chart.Apply those data and calculate the profit from each of the three products that will become the total profit for July.Are you able to do it?So, 11 is a profit or contribution per unit into 20000 that means, 2 lakh sorry 20 yeah220000 is a contribution.Now, there is no point in deducting fixed cost because you do not know separately fixed cost for A, but if you complete it for the whole company so 220 here, 440 for B, and80000 for C that means for a company as a whole, they can earn a contribution of 540000 from a sale of 2960000.From this deduct the fixed cost of 480000, now 540 minus 480; you get a profit of 60000.Are you getting it?Ok, I hope you have calculated the profit for July.Now continue the same process calculate the profitability for August.Again you know the selling price and contribution you do not have to calculate the total sales, they do not play many roles.What we want is called total contribution and deduct it from fixed cost isn’t going to change.So, what is going to change profit is a contribution earned in August.So, please compute the contribution 11 per unit into 35000 units.So, 385000 for A, getting it; 192 for B, and 20000 for C; so, the total is 597.So, you can compare in July it was 540.Now, the contribution has increased to 597.Deduct the fixed cost of 480; you can see that the profit is now 117000.So, the first part of the question was to make a monthly profitability statement and compute the profit of July and August.All can do it?Now, you will be surprised that profit has almost doubled from 60000 to 119, but the number of units has gone down from 60000 to 56000, but profit as double.How was this magic possible?This magic was possible because they have to change the sales mix earlier sales mix was one is to one between A, B, C. Now, they have emphasized much more on A, it is 35000, 16000 to 5000, and they were available to double the profit.The question was fine monthly profits and if your calculations bring out higher profits, kindly justify the findings.So, how will you be able to justify it can you give any reasoning for more profits inAugust.Yes, the reason is because of the better sales mix in August.Why this sales mix is superior to the sales mix of July?Because, if you compare the three products product, A is much better than B or C and they have increased the sales of A while have cut down the sale of C, that is how they have increased their contribution. Fixed cost anyway does not change which is 480.So, any incremental contribution directly goes to profit. So, they could nearly double their profit.Are you getting it? So, next time, we will continue with the second part of the question. Namaste Thank you.
Log in to save your progress and obtain a certificate in Alison’s free Introduction to Cost Accounting and Cost Classification online course
Sign up to save your progress and obtain a certificate in Alison’s free Introduction to Cost Accounting and Cost Classification online course
Please enter you email address and we will mail you a link to reset your password.