I did this on an Excel spreadsheet years ago and its easy.
In excel in column “A” we went down the line and placed the dollar
amount of each part, line by line, then at the bottom it added a
In the next column, column “B” we had what PERCENTAGE each line was
of the total.
At the top we entered the total shipping charge.
Then in column “C” we had a formula that MULTIPLIED the shipping
charge by the percentage to figure what percentage of the shipping
wwent to that part.
Column “D” totaled the part and shipping.
Similar to below:
TOTAL SHIPPING = $20.00 (Assume this $20 sits in cell “G-1”)
“A” “B” “C” "D"
PART PERCENTAGE SHIPPING PART TOTAL FOR PART
$15.00 23% $4.60 $19.60
$20.00 31% $6.20 $26.20
$30.00 46% $13.80 $43.80
TOTAL OF PARTS ($15 + $20 +$30) = $65.00 (Assume this is cell “B-10”
The formulas in Excel
The 1st $15 part is in cell “A-5” for example. The "23% cell would
be “B-5”. In B-5 the formula would be =sum(A5/$b$10)
Format this cell to be a percentage)
Then copy the formula to the 31% cell and 46% cell. The dollar signs
"$b$’ tells excel to keep that cell constant as you copy.
The “C” column formula would be =sum(c5*$g$1)
The Total of Parts in B-10 would be =sum(a5:a7) This adds up the lines
from $15 down to $30.
Hope that helps.