i ened this in 3-4 hrs
Sheet1
| Your Name Goes Here | ||||||
| 11/13/20 | ||||||
| Sales Forecast | ||||||
| Assumptions: | ||||||
| 1st quarter sales: | 1000 | |||||
| Quarterly sales increase: | 5% | |||||
| Selling Price: | 18.95 | |||||
| Cost of Goods sold (each): | 12.45 | |||||
| Advertising Expence: | 1,000.00 | |||||
| 1st Q | 2nd Q | 3rd Q | 4th Q | Total | ||
| Unit Sales: | ||||||
| Price: | ||||||
| ========= | ========= | ========= | ========= | ========= | ||
| Revenue: | ||||||
| Cost of goods sold: | ||||||
| ========= | ========= | ========= | ========= | ========= | ||
| Gross Income: | ||||||
| Advertising Expence: | ||||||
| ========= | ========= | ========= | ========= | ========= | ||
| Net Income: |
1
2
3
4
5
6
7
8
9
A
B
Your Name Goes Here
11/13/2020
Sales Forecast
Assumptions:
1st quarter sales:
1000
Quarterly sales increase:
5%
Selling Price:
18.95
Cost of Goods sold (each):
12.45