I don't want to waste anyone's time with what is probably a really simple question, but I am having trouble extracting, and then correctly re-applying, some percentage markups to a budgeted value I am working with.
Obviously, under normal circumstances, I would start with a Cost
and mark it up to get my final Sum Total
, like so:
Labor Material
Cost 10,000.00 10,000.00
Supervision 3% 300.00 (Cost * Supervision)
Load 5% 515.00 (Cost + Supervision) * Load
Waste 5% 500.00 (Cost * Waste)
Tax 9.25% 925.00 (Cost * Tax)
------------------------------------------
Sub Total 10,815.00 11,425.00
Overhead 10% 1,081.50 1,142.50 (Sub Total * Overhead)
Profit 10% 1,189.65 1.256.75 (Sub Total + Overhead) * Profit
------------------------------------------
Total 13.086.15 13,824.25
Sum Total 26,910.40
However, there are circumstances in which I will actually be working backwards from the Sum Total
towards an initial Cost
. The catch is I need to introduce two variables accounting for a Labor
percent and a Material
percent (something like 40%
and 60%
).
I've been able to track back correctly when one value is 100%
and the other is 0%
, but when I use any combination in the middle, I end up just a little off of my expected Sum Total
.
I don't really know what information I need to supply to help find a solution (don't even know how to tag this question), but I'd really appreciate any help I can get on this scenario.
Thanks!