Mini-Video - Accounting 2 - Chapter 21 "The High-Low Method" - YouTube

Channel: JCCCvideo

[10]
Now, once we determine once we determine, folks, that there is a relationship between
[19]
two variables, we still want to come up with the equation of that line, the Y equals A
[24]
plus B times X.
[26]
One way that we can do that, kind of a quick and dirty little way, is what is known as
[31]
the highlow method.
[34]
And the objective, again, is to calculate the equation of the mixed cost.
[39]
That Y equals A plus B times X, okay?
[44]
Now I've learned that the best way to teach highlow method is actually just to do an example.
[49]
So we're going to do an example here.
[51]
All right?
[52]
Okay, here is a series of months and the units produced and the total cost for each.
[60]
And let's say we feel that these, this is a situation that is a mixed cost.
[65]
And we did that, perhaps, by plotting out a scatter diagram.
[70]
Okay, the first thing that we want to do here is identify which of these columns is the
[75]
X variable and which one of these is the Y variable.
[79]
Okay, well which is the X variable?
[82]
Units produced.
[84]
Okay.
[86]
And total cost is the Y variable, okay?
[90]
Now what we do, come off that if you would and show me, is once we've identified the
[97]
X and the Y there we go, show it all if you can.
[103]
Then what we want to do, actually, is we kind of want to cover up the Y's, don't even look
[108]
at them.
[110]
Just look at your X's.
[112]
And I want you to determine which of these is the highest X and which of these is the
[117]
lowest X.
[118]
I'm not asking you which is the highest Y and lowest Y no, no, no.
[121]
Cover up the Y's so you're not even tempted to look at them right now.
[124]
Which of these of these is the highest X?
[127]
Which of these is the lowest X?
[129]
Okay.
[130]
So going back to the computer, once you do that, which is the highest X?
[137]
>>February.
[138]
>>February, okay?
[141]
That's the high.
[144]
Which of these is the lowest X?
[146]
>>June.
[147]
>>June.
[149]
That is the low.
[151]
You with me?
[152]
Okay.
[153]
So, what we're going to do then, once we've determined the high month and the low month,
[162]
we're going to actually use all the data from those months now, and we are going to figure
[171]
out the equation of the mixed cost, okay?
[176]
The first thing that we're going to do is we're going to determine the variable cost,
[187]
okay?
[188]
So let me go back over the document camera, all right?
[193]
Okay.
[194]
The first thing we're going to solve for is B, which is the variable cost.
[198]
Well that equals the change in Y over the change in X of the high and the low point,
[205]
okay?
[207]
So the change in Y is is it 29,000 minus 20,500?
[220]
Somebody help me oops, I just wrote on that.
[222]
>>That's right.
[225]
>>Okay.
[226]
Divided by the change in X of the high and the low point.
[231]
So that would be 67,500 units minus 17,500 units; is that correct?
[243]
>>Yup.
[244]
>>So if you compute that out, that comes out to 17 cents a unit.
[255]
That is the B in our line.
[258]
Are you with me?
[260]
Okay.
[261]
Now the next step is we want to solve for A, which is our fixed cost.
[268]
The way we're going to do that is we're going to, once again, consider the entire equation
[276]
of a mixed cost.
[278]
We just solved for B, okay?
[285]
Now what we're going to do is we're going to borrow the Y and the X from either the
[290]
high or the low point, okay?
[293]
From the high or the low point.
[295]
So going back to the computer, we're going to use either this X and Y up here or this
[301]
one down here.
[303]
Either way it'll give us the same answer.
[305]
I usually use the low one because it seems like it's sometimes easier math, okay?
[310]
So what is the Y what is Y at the low point?
[318]
>>20,500.
[320]
>>20,500.
[322]
A is what we're trying to solve for.
[325]
What is X at the low?
[329]
>>17,500. >>17,500; is that correct?
[335]
Okay.
[337]
So once you do that you get 20,500 equals A plus let's see what .17 times 17,500 equals.
[352]
I think that's 2,975.
[356]
>>I can barely see it.
[360]
>>Thank you.
[362]
So 20,500 equals A plus 2,975.
[367]
So what does A equal?
[372]
17,525?
[377]
Okay.
[381]
So we now have our B and we now have our A, okay?
[387]
Now let me show you how I don't like you to show this answer.
[393]
Some students will write this out, they'll say Y equals 17,525 plus .17X.
[402]
Well, yeah, sort of.
[406]
But let's go ahead and define these variables for this specific situation.
[413]
What does Y, in this situation, equal?
[417]
We're looking back at the computer, Y equals total costs, right?
[423]
So let's say total costs equals $17,525 plus – well, what does X equal in this example?
[439]
Units produced, right?
[442]
So let's say 17 cents per unit produced times the number of units produced.
[458]
Now, doesn't that just give you a better warm fuzzy in your tummy that you really understand
[466]
what this what we really did was?
[469]
Okay.
[470]
Because now what can we do?
[472]
Well, now what we can do is once we have that equation right there, let's say we expect
[481]
an activity level of 20,000 units.
[483]
Well, what would we expect to be our total costs?
[487]
Well, we can plug it into that equation and we can come up with an answer of 20,925.
[492]
Are you with me?
[496]
Okay, that's why we want that equation.
[498]
So as managers (inaudible) costs.
[501]
(Inaudible) costs is a huge part of running a business.
[506]
Are you with me?