Homework Excel
Sheet1
| Projected Profits Worksheet | |
| Assumptions Table | |
| - | |
| Gross Sales Increase | |
| Wages Increase | |
| Cost of Goods Sold | |
| Advertising Increase | |
| 2020 | |
| Income: | |
| Gross Sales | 200,000.00 |
| Sales Incentives | 5,000.00 |
| Total income | |
| Expenses: | |
| Wages | 65,000.00 |
| Cost of Goods Sold | 8,900.00 |
| Rent | 12,000.00 |
| Supplies | 21,000.00 |
| Advertising | 2,750.00 |
| Total expenses | |
| Net profit |