selleratheart_product_launch.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Color Legend
2
Input - Fill out these areas
3
Supplier should provide this info
4
1) Goals
5
6
Our target is 10% of market share
7
Top 10 Competitor Est Monthly Sales According to Junglescout
1130
8
My Goal of units/month (10% of market share)
200
9
Units per day 6,67
10
Number of units for first order (for three month)
100
11
12
13
Main keywords for PPC
Amazon suggested bid
14
Keyword 1 According to Keyword Inspector
$1,00
15
Keyword 2 According to Keyword Inspector
$1,00
16
Estimated CPC$1,00
17
18
2) Invoice
19
Input from Supplier
20
Total QuantitySourcing PriceUNIT PRICE (USD)Total Cost (USD)
21
5001Product Cost FOB $ 5,00 $ 500,00
22
2Prep and Pack $ - $ -
23
3Packaging $ - $ -
24
4Shipping/Taxes $ 0,75 $ 375,00
25
5PayPal/Wire Fee $ 60,00 $ 60,00
26
Total Landed Price-$1,87 $ 935,00
27
28
3) Other Expenses
29
30
Other costsTotals
31
Photography $ 250,00
32
Optimization Services $ -
33
Designer $ -
34
Other $ 500,00
35
Total Other Expenses $ 750,00
36
37
38
4) Other Expenses
39
40
PPC sales target/dayAD BudgetTotals
41
4 Daily PPC Budget $ 10,00 Conversion rate 5%
42
PPC 30 Day Cost $ 300,00 60% of sales trough PPC
43
44
Facebook Ads Budget $ 15,00
<-- Enter Daily Budget Here
45
Facebook Ads 30 Day Cost
$ 450,00
46
47
Total Ad Cost $ 750,00
48
49
5) Giveaways
50
I don't recommend doing giveaways but if you want do them in this section enter the amount of giveaways that will be given and the fees
51
52
53
Total 15 Day Giveaway based on CompetitionGiveaway # of GiveawaysService Fee Cost
54
565Vipon/AmzTracker0 $ -
55
Market Hustl0 $ -
56
Viral Launch ($50 off Coupon Code: 5DDWYVGVLP)
0 $ -
57
Total Giveaway amount0 $ -
58
Customer price per giveaway
$ -
<-End customer price with promo code
59
Total Customer Paid $ -
60
Subtotal Giveaway Service Cost
$ -
61
62
Amazon Selling Price $ 33,99
<--Value is auto updated based off choice in C77
63
AZ fee at least $X.XX per item
$ 9,00
64
COGS $ 9,00
65
Giveaway cost of 0 Units
$ -
66
67
68
Total Giveaway Cost $ -
69
70
Expected % Return from Giveaways
0%
Expected Reviews per Giveaway
0
71
72
6) 1st Month's Profits
73
74
75
76
Stock leftover over after giveaway
500
77
Selling Price $ 29,99
<-- Dropdown based on your inputs in Section 7's for Selling Price
78
Est profit per item (Linked to right profit column)
#N/A
79
80
Profit on remaining Stock
#N/A
81
Total Giveaway Cost $ -
82
Total Ad Cost $ 750,00
83
Total Other Expenses $ 750,00
84
1st month's Profit = Profit on remaining Stock - Total Giveaway Cost - Total Ad Cost - Total Other Expenses
#N/A
85
Actual ROI with Promo Cost End of Day
#N/A
86
Estimated Days of Stock after promo
2,50
87
Daily Profit after promo #N/A
88
Monthly Profit (30) after promo
#N/A
89
90
91
92
7) Price points
93
94
Fulfillment by Amazon Fees
Selling Price
FeeProfit Total Sales Total ProfitROIMargin
95
$8,00 $ 6,99 $ 9,05 $ (0,19) $ 3.495,00 $ (94,25)10,08%-2,70%
<- ~Break even price point
96
$ 7,99 $ 9,20 $ 0,66 $ 3.995,00 $ 330,75 -35,37%8,28%
97
$ 12,99 $ 9,95 $ 4,91 $ 6.495,00 $ 2.455,75 -262,65%37,81%
98
$ 13,99 $ 10,10 $ 5,76 $ 6.995,00 $ 2.880,75 -308,10%41,18%
99
$ 14,99 $ 10,25 $ 6,61 $ 7.495,00 $ 3.305,75 -353,56%44,11%
100
$ 15,99 $ 10,40 $ 7,46 $ 7.995,00 $ 3.730,75 -399,01%46,66%
Loading...