Enigmachrysalis
Active Member
- Joined
- Apr 13, 2009
- Messages
- 352
- Office Version
- 365
- Platform
- Windows
So here are the players in a cost per unit (CPU) calculation:
After period (a)
This year's cost
Last year's cost
This year's units
Last year's units
Before period
This year's cost
Last year's cost
This year's units
Last year's units
Here is the calculation by business segment for the difference of the Before/After periods year over year:
(TY_Cost_After/TY_Units_After)-(TY_Cost_Before/TY_Units_Before)
minus
(LY_Cost_After/LY_Units_After)-(LY_Cost_Before/LY_Units_Before)
To get the total CPU for all business segments, I simply sum all the before/after periods and perform the same math.
Now this works at the business unit level, but if I take each business segment variance and multiply it times TY_Units_After, i.e. the number of units in this year's after period, sum these products, and then divide the total sum TY_Units_After for all business units, I get a different cost per unit!
I have other calculations that similarly break down when they are compared in these 2 manners. I think it is a matter of mix, but until I can explain it properly, I can't be confident in which is correct!
Do you guys see the problem?
After period (a)
This year's cost
Last year's cost
This year's units
Last year's units
Before period
This year's cost
Last year's cost
This year's units
Last year's units
Here is the calculation by business segment for the difference of the Before/After periods year over year:
(TY_Cost_After/TY_Units_After)-(TY_Cost_Before/TY_Units_Before)
minus
(LY_Cost_After/LY_Units_After)-(LY_Cost_Before/LY_Units_Before)
To get the total CPU for all business segments, I simply sum all the before/after periods and perform the same math.
Now this works at the business unit level, but if I take each business segment variance and multiply it times TY_Units_After, i.e. the number of units in this year's after period, sum these products, and then divide the total sum TY_Units_After for all business units, I get a different cost per unit!
I have other calculations that similarly break down when they are compared in these 2 manners. I think it is a matter of mix, but until I can explain it properly, I can't be confident in which is correct!
Do you guys see the problem?