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!