maths help

[build]

Hi
Hope this is the right place for this, sorry if not and could you point me to the right place if not


This is my problem

I have two people sharing the running cost of caravan one person will use the caravan a lot more
than the other.

I'm trying to work out how to get at the cost for each person.


The total running cost of the caravan From March to October is £2200.00

The season runs from March to October

Names of people are


Fred
Tom


Fred will use the caravan 30 days a year


Tom will use it 8 days a year


These could be more or less days

The rest of the time would be empty.

So Fred would have to pay more of the total cost than Tom

Hope some one can help a dum blonde


Thank you

Jane



Reply With Quote

 

[bookerk2]

Couple of solutions to your problem

I am assuming that you want a formula and/or action to calculate days divided by the cost of the car. So you could use a simple function that says:
=2200.00/C2 (THIS IS WHERE I STARTED WHEN I TESTED IT)
and it should look like this when you use auto fill in your total box. Does this help?
EMPLOYEE DAYS USED TOTAL DUE
steve 4 550
dave 10 220
paul 3 733.3333333

 

[XLPadawan]

Hi
Hope this is the right place for this, sorry if not and could you point me to the right place if not


This is my problem

I have two people sharing the running cost of caravan one person will use the caravan a lot more
than the other.

I'm trying to work out how to get at the cost for each person.


The total running cost of the caravan From March to October is £2200.00

The season runs from March to October

Names of people are


Fred
Tom


Fred will use the caravan 30 days a year


Tom will use it 8 days a year


These could be more or less days

The rest of the time would be empty.

So Fred would have to pay more of the total cost than Tom

Hope some one can help a dum blonde


Thank you

Jane



Reply With Quote

Being a math guy first (Excel is my secondary skill), I have just the thing you need:

Total cost of van divided by total user-days = 2200.00 / 38 = 57.89
Multiply each rider's days by 57.89:
Fred: 30 x 57.89
Tom: 8 x 57.89

Maybe I'm the one who's in the wrong place, or maybe I just like dumb blondes.