This budget is for a certificate that can be redeemed. It is sent out to
many people and the first year it was in effect, 40% of what was sent out was
redeemed. So, the second year they planned to send out additional above the
budget based on that 40% redemption. I thought this was pretty basic,
however, I can't see how they got the 62,500. It doesn't make sense given
the fact they said they were figuring on 40% redemption.

"John C" wrote:

What does 40% redemption in the budget actually mean?
--
** John C **
Please remember, if your question is answered, to check the YES box below.
It helps everyone.


"vtrud" wrote:

I'm working on a spreadsheet that I need to give an additional amount showing
an increase in the budget amount based on a 40% redemption of the budget. On
this spreadsheet in a previous year someone figured this using a calculator
and entered it manually in the spreadsheet rather than using a formula. I
don't know how to figure it manually much less use a formula. I've been
trying to come up with it based on what they had but can't. They had a
budget of 50,000 and and came up with an increase amount of 62,500. I don't
know how they came up with that.