ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
MERCH BUDGET
2
PLEASE NOTE IF YOU COPY AND PASTE THIS THE FORMULAS MAY BE LOST
3
4
ITEMTOUR HOODY
5
PRICE30
6
CURRENCYPOUNDS
7
MANUFACTURING COST1200
8
9
SIZES
10
XXS10
11
XS20
12
M30
13
L40
14
XL50
15
XXL40
16
XXXL10
17
TOTAL ORDER200
18
19
FREE GIVE AWAYS10
20
21
FOR SALE190
22
SELL PRICE30
23
GROSS REVENUE5700
24
SALES TAX AT 20%6Per Unit
25
SALES COMMISSION @ 20%6Per Unit
26
UNIT PRICE per hoody6
**INCLUDES SALE TAGS AND BAR CODES AND DELIVERY - IF THESE ARE NOT INCLUDED ADD THEM
27
balance after costs12
**REMEMBER THIS ONLY APPLIES IF YOU SELL ENOUGH TO BREAK EVEN, IF YOU HAVE NOT COVERED MANUFACTURING,
28
YOU DON'T MAKE A PROFIT PER ITEM UNTIL YOU DO
29
30
PROFIT PER ITEM12
31
32
FIXED COSTS
33
PHOTO SHOOT & ITEM DESIGN200
**REMEMBER YOU NEED TO OWN THE DESIGN OR YOU NEED TO KNOW IF YOU HAVE TO PAY THE DESIGNER A PERCENTAGE.
34
MARKETING0
**THIS IS WHEN YOU ARE ONLY USING YOUR OWN PLATFORMS TO PROMOTE.
35
BREAKEVEN77.77777778
**TOTAL COST TO MAKE THEM ALL + FIXED COSTS = 1400. TAKE SALES INCOME MINUS COMMISSION AND TAX (22 POUNDS) AND DIVIDE
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100