BrandProfitability-Q6.xlsx
Brand Profitability
| Brand Profitability |
| Report Item |
Cruiser 2.0 |
The Climber |
Silver Bullet |
Cruiser 3.0 |
Cruiser 4.0 |
| Brand Revenues |
475,200 |
241,800 |
945,000 |
489,900 |
392,400 |
| - Rebates |
10,800 |
4,650 |
16,900 |
10,650 |
16,400 |
| - Cost of Goods Sold |
115,130 |
78,971 |
330,500 |
128,412 |
98,517 |
| = Gross Profit |
349,270 |
158,179 |
597,600 |
350,838 |
277,483 |
| Brand Design |
0 |
0 |
0 |
0 |
0 |
| + Ad Design |
0 |
0 |
0 |
0 |
0 |
| + Brand Advertising |
31,062 |
15,000 |
0 |
22,500 |
31,062 |
| + Brand Promotions |
1,500 |
1,500 |
1,500 |
1,500 |
1,500 |
| + Internet Marketing |
3,502 |
10,479 |
0 |
6,077 |
9,231 |
| = Expenses |
36,064 |
26,979 |
1,500 |
30,077 |
41,793 |
| Brand Profit |
313,206 |
131,200 |
596,100 |
320,761 |
235,690 |
| Profit per Unit |
725 |
705 |
883 |
753 |
721 |
| % from Brand Revenues |
66 |
54 |
63 |
65 |
60 |
| End of Worksheet |