Maths Help

[jane234]

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

 

[Access Developer]

Total days = Fred's Days + Tom's Days

Fred's Part of Total Cost = Total Cost x (Fred's Days/Total Days)
Tom's Part of Total Cost = Total Cost x (Tom's Days/Total Days)

Is that what you were seeking? I ask because that seems a trivial
calculation for anyone who can use a computer and ask a question in a
newsgroup, so I'm wondering if I am missing some vital part of what you are
asking.

 

[jane234]

Total days = Fred's Days + Tom's Days

Fred's Part of Total Cost = Total Cost x (Fred's Days/Total Days)
Tom's Part of Total Cost = Total Cost x (Tom's Days/Total Days)

Is that what you were seeking? I ask because that seems a trivial
calculation for anyone who can use a computer and ask a question in a
newsgroup, so I'm wondering if I am missing some vital part of what you are
asking.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access

Hi Larry

Thank you for getting back to me.

No you are not missing a VITAL part but one part which I think I did not explain very well looking
at it.


Total day park open

210 days
Total cost £2200.00

Fred's share 30 days
Tom's share 10 days

So working out from your info it would be

Total days = Fred's Days + Tom's Days =40 days

Fred's Part of Total Cost = £2200.00 x (30/40)=£314.00
Tom's Part of Total Cost = £2200.00 x (10/40)=£104.76

Then add Fred's and Tom's Total together =£418.00
Take that off the Grand Total of £2,200.00 =£1,782.00 left to spilt between both of them =£891 Each
Fred's Part £314.00 plus £891 = £1205.00
Tom's Part £104.76 plus £891 =£995.00
Add the above together = £2200. Simple

Now here is the bit that Is not trivial calculation (Well to me)
Which I did not explain to well (sorry)

As I said the Fred and tom days could be more or less so have I got to do all the above each time
the days alter?

Thanks for your time

Jane

pp build

 

[Rob Parker]

To give a definite answer to this, we need to know the 'business rule' which
applies to this scenario.

Are the unalloted days to be costed equally between the two owners?
or
Are the unalloted days to be costed on the same ratio as the alloted days?
or
.... some other business rule?

And what are you wanting, exactly, from the people who answer the questions
in this newsgroup? An expression to put into a calculated field in a query
or form, or something else. If so, what - and exactly what information do
you have available in fields in your database tables?

Rob

 

[jane234]

Hi Rob

Well to be fair the person who uses the carvan the most will pay a more percent on the unalloted
days than the other person. BUT how to work out that is another thing.

And what are you wanting, exactly, from the people who answer the questions
in this newsgroup?

1....A formula to work out what I have ask?

2....Then when I have that I then can make a data base to use for about 20 carvans with different
percentage for people.

 

[Rob Parker]

Replies in-line below:

Rob

Hi Rob

Well to be fair the person who uses the carvan the most will pay a more
percent on the unalloted
days than the other person. BUT how to work out that is another thing.

This to me means that you don't have a 'business rule' for this situation.
By business rule I mean what you describe as 'BUT how to work out that ...'
Are you wanting consensus from the group on what this should be? I suspect
that you won't get it here - we're answering database questions. If you
pick one of the alternatives I suggested, or define exactly what you want to
use as your business rule, then I'm sure you'll get a reply - perhaps from
me, perhaps from someone else following this thread - with an appropriate
formula.

1....A formula to work out what I have ask?

2....Then when I have that I then can make a data base to use for about 20
carvans with different
percentage for people.

And, if you want a formula/expression that you can plug into a query, you
need to answer this question also.
<snip>