| A | B | C | D | E | F | G | H | I | J |
1 | Month | Q1 | Q2 | Q3 | Q4 | Total | | | | |
2 | Seasonality | 0.9 | 1.1 | 0.8 | 1.2 | | | | | |
3 | | | | | | | | | | |
4 | Units Sold | 3,592 | 4,390 | 3,192 | 4,789 | 15,962 | | | | |
5 | Sales Revenue | $89,789 | $109,742 | $79,812 | $119,718 | $399,061 | | | | |
6 | Cost of Sales | 0 | 0 | 0 | 0 | 0 | | | | |
7 | Gross Margin | 89,789 | 109,742 | 79,812 | 119,718 | 399,061 | | | | |
8 | | | | | | | | | | |
9 | Salesforce | 8,000 | 8,000 | 9,000 | 9,000 | 34,000 | | | | |
10 | Advertising | 10,000 | 10,000 | 10,000 | 10,000 | 40,000 | | | | |
11 | Corp Overhead | 13,468 | 16,461 | 11,972 | 17,958 | 59,859 | | | | |
12 | Total Costs | 31,468 | 34,461 | 30,972 | 36,958 | 133,859 | | | | |
13 | | | | | | | | | | |
14 | Prod. Profit | $58,320 | $75,281 | $48,840 | $82,761 | $265,202 | | | | |
15 | Profit Margin | 65% | 69% | 61% | 69% | 66% | | | | |
16 | | | | | | | | | | |
17 | Product Price | $40.00 | | | | | | | | |
18 | Product Cost | $25.00 | | | | | | | | |
19 | | | | | | | | | | |
20 | | | | | | | | | | |
21 | | | | | | | | | | |
|