Difference in percentage - Better explained?

[Guest]

I have to keep track of items that are sent to wards in a hospital. Each
ward has a set quota. Each day the ward is sent it's quota of items, plus an
extra 20% just in case. If the quota is set up correctly, then the return
rate (returns divided by items sent) should be 20%.

Here is what my report currently tells me:
Item Quota (sent) Returned Return Rate
Bib 125 75 60%
Diaper 200 15 8%

What i would like to do is have another column that suggests what the quota
should be (i.e. - we should send less bibs and more diapers) to achieve a
return rate of 20%.

Does this better explain what i need? Is there a way to do this easily in
access?

 

[Rick B]

Okay, I think I get it now.

In your example, you sent 125 bibs, and they returned 75. That means they
used 50, right? Tomorrow, you should send 50 (plus 20%) which is 60.

You don't need the return rate in your example below.

Just calculate how many they used, add 20%, and make that the number you
send tomorrow.


New Needed Value = ([Quota] - [Returned])*1.20

 

[Rick B]

For the Diaper example...

200 - 15 * 1.20

185 * 1.20

222

 

[Guest]

Thank you!

Okay, I think I get it now.

In your example, you sent 125 bibs, and they returned 75. That means they
used 50, right? Tomorrow, you should send 50 (plus 20%) which is 60.

You don't need the return rate in your example below.

Just calculate how many they used, add 20%, and make that the number you
send tomorrow.


New Needed Value = ([Quota] - [Returned])*1.20




--
Rick B

I have to keep track of items that are sent to wards in a hospital. Each
ward has a set quota. Each day the ward is sent it's quota of items, plus
an
extra 20% just in case. If the quota is set up correctly, then the return
rate (returns divided by items sent) should be 20%.

Here is what my report currently tells me:
Item Quota (sent) Returned Return Rate
Bib 125 75 60%
Diaper 200 15 8%

What i would like to do is have another column that suggests what the
quota
should be (i.e. - we should send less bibs and more diapers) to achieve a
return rate of 20%.

Does this better explain what i need? Is there a way to do this easily in
access?