K
Keith
I have a spreadsheet the needs to workout a cost per year based on the
number of people and the number of times they use a consumable product.
For example:
Say I sell biscuits.
I have 30 customers that under contract will always have a packed of
biscuits on a years contract. Once the run out of a packed another
packed is sent out.
If each packed holds 10 biscuits then how many packets they will get in
the year is directly Proportional to the number of biscuits they eat per
day. If the ate 5 a day the a packed would last two days and if they
only ate one a day the packet would last 10 days.
Assuming the rate each packed is used at is the same per customer how
much will the year cost.
As you can see this is a sill example and my real problem is far more
complex, but you get the idea.
I need this spreadsheet to be user friendly so I tried to use scenarios.
But I have a problem. I have a field for customers and one for usage
but the cost is complex (not like the biscuits). I could have solved
the problem is scenarios could take calculated fields or point to a
specific cell, but they just convey the value to a figure. If the
figure in the cell changes due to number of customers or usage the
scenario doesn't change.
Can anybody point me in the right direction?
I can give more info or explain better if you need me to.
number of people and the number of times they use a consumable product.
For example:
Say I sell biscuits.
I have 30 customers that under contract will always have a packed of
biscuits on a years contract. Once the run out of a packed another
packed is sent out.
If each packed holds 10 biscuits then how many packets they will get in
the year is directly Proportional to the number of biscuits they eat per
day. If the ate 5 a day the a packed would last two days and if they
only ate one a day the packet would last 10 days.
Assuming the rate each packed is used at is the same per customer how
much will the year cost.
As you can see this is a sill example and my real problem is far more
complex, but you get the idea.
I need this spreadsheet to be user friendly so I tried to use scenarios.
But I have a problem. I have a field for customers and one for usage
but the cost is complex (not like the biscuits). I could have solved
the problem is scenarios could take calculated fields or point to a
specific cell, but they just convey the value to a figure. If the
figure in the cell changes due to number of customers or usage the
scenario doesn't change.
Can anybody point me in the right direction?
I can give more info or explain better if you need me to.