Percentage function formula

[gracious]

Hello, I have inserted my sheet to give you an idea of what I am tryin
to do. My boss wants the freight/fuel plus tax(which is the totalH/C
to be costed out to each job based on the % that the individual jo
costs are in relation to the whole invoice. I have instructed the shee
to take the total job cost and find what % it is to the 318.44 and the
I told it to take that % x the 37.61 (H/C) to add that cost for a tota
cost, but the total at the bottom for H/C do not equal the H/C whic
then throws off the cost.
How do I get the %'s accurate so that my H/C is correct? I have
difference of $4.45.
Thank you Gracious

**************************************************************

Invoice Total $318.44

Freight $30.00
Fuel $4.50

9% Tax $3.11
Total H/C $37.61
% of
Name Amount 9% Tax Total invoice H/C Total Cost
Job $157.44 $14.17 $171.61 53.89% $20.27 $191.88
Job $33.03 $2.97 $36.00 11.31% $4.25 $40.25
Job $57.18 $5.15 $62.33 19.57% $7.36 $69.69
Job $9.99 $0.90 $10.89 3.42% $1.29 $12.18
$0.00 $0.00 $0.00 0.00% $0.00 $0.00
$0.00 $0.00 $0.00 0.00% $0.00 $0.00
$0.00 $0.00 $0.00 0.00% $0.00 $0.00
$0.00 $0.00 $0.00 0.00% $0.00 $0.00
$0.00 $0.00 $0.00 0.00% $0.00 $0.00
$257.64 $23.19 $280.83 $33.16 $313.99

edited: guess you can't copy and paste....how can I get this on here s
that you will be able to see it correctly?????

 

[Bill Kuunders]

Gracious...
Your percentages do not add up to 100
You need to divide each individual job cost into the sum of the
job costs not into the invoice total.i.e. 171.61 into 280.83 to get
61.1085%
etc.

 

[Guest]

Your problem may be a rounding problem. spread sheets don't attach to what I
can read.

 

[gracious]

Gracious...
Your percentages do not add up to 100
You need to divide each individual job cost into the sum of the
job costs not into the invoice total.i.e. 171.61 into 280.83 to get
61.1085%
etc.

Thank you so very much! I guess I had looked at it too long and go
frustrated and didn't realize that I was adding in the H/C t
calculate the %....whew...what a relief thank you for setting m
straight and all the way from New Zealand!!! TY Bill K HUGS HUG
HUGS ;

 

[Bill Kuunders]

Thank you for the feedback.
It made my day.
Bill K