simple average formula...can you solve it in principle?

[Guest]

How do you run a report or formula for the following principle example?

Based on a sales competition, I have 100 days to get my daily average income
to a total average of $45. I am averaging $30 income daily through the first
61 days. How do I run a report that can tell me (instead of manually doing
it) the amount of daily income I need to average for the remaining 38 days in
order to meet my goal of $45.00 for the 100-day period? I am using 2003
version.

thanks....

A.W.

 

[Bob Phillips]

=((target_days*target_average)-(days_to_date*average_to_date))/(target_days-
days_to_date)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Excel is not necessary:

To make your average you need 4500 total (45 * 100). You already have 1830
(30 * 61). You need an additional 2670 and you only have 39 days to acquire
it or need to make 68.46 per day.


In Excel:

In A1, put =45*100
In A2, put =30*61
In A3, put =A1-A2
In A4, put =A3/39