Help needed with forcasting

[ychami]

i want to look at potential opportunities with new customers for a given number of weeks in the year...

meaning...i have an opportunity to sell customer1 an average weekly revenue of $66.67 for the last 15 weeks of the year...i attached a sample layout.

i want to know how i can calculate the new revenue total for each month if i have a number of these opportunities.

the total and the # of weeks will be variables i would need to enter.

thanks in advance.