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!