How do I set up a weighted percentage formula in Excel?

D

Diamond75

I'm trying to set up a sliding scale weighted percentage formula for a
management company. It would be based on a variable number of vehicles that
are weighted differently. As a vehicle would be added at a certain weighted
percentage how would that change the percentage that each vehicle would pay
into a fixed cost? This formula will be used in Excel. Thank you for any
assistance.
 
S

SteveM

I'm trying to set up a sliding scale weighted percentage formula for a
management company.  It would be based on a variable number of vehiclesthat
are weighted differently.  As a vehicle would be added at a certain weighted
percentage how would that change the percentage that each vehicle would pay
into a fixed cost?  This formula will be used in Excel.  Thank you for any
assistance.
Click to expand...

If I read it right, you just sum the weights and then divide the
weight of each truck by the sum to normalize the values. And the
fraction is the percentage of fixed cost each truck would pay. So say
you have 3 trucks with weights 4, 6 and 9. They sum up to 19 so Truck
1 pays 4/19, Truck 2, 6\19 and Truck 3, 9\19 or 21%, 32% and 47%
respectively. I'm sure you can do the simple calcs. in Excel without
my help.

SteveM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the weighted average of text that have been given values 1
How do I set up a weighted formula in Excel? 2
How do I calculate a weighted average in a pivot table? 0
Help writing formula for investing spreadsheet 0
Weighted ranking of a series 3
How do I set up a formula to calculate a letter as a value 1
how do i set up a profit margin formula 2
how do i set up a weighted factor model in excel? 1

Top