ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
PropertiesInputs
PLEASE DOWNLOAD THIS (Under file menu)
Micromart.com
2
Location Address:
<----- complete including where in the building it will be placed
3
Location Type:<----- complete
4
Hours of operation:<----- complete
5
What categories of items for sale here:<----- complete
6
Operator Comments
7
Best caseMiddleOkay case
8
Assumptions
9
Daily onsite headcount300270240
<----- how many people are on site daily?
10
Servicable days / month303030<----- complete
11
Average basket size2.11.91.7
<----- number of items ordered per transaction. Typically it's 2
12
Average item price$3$3$3
<----- how much will you charge on average for your items?
13
Average item cost$1.2$1.2$1.2
<----- how much is the average price of what you're selling?
14
Average order size$6.30$5.67$5.10
15
Average order cost$2.5$2.3$2.0
16
Delivery cost / stop$0$0$0
<----- how much it costs you to drive there and pay the driver to restock it?
17
Technology SaaS fee / day$2$2$2<---- in USD
18
Payment processing %4%4%4%
19
Payment processing fixed$0.10$0.10$0.10<---- in USD
20
Single fridge capacity250250250
<--- selling vending snacks/drink around 250. Fresh food is 120
21
22
Business Drivers
23
Foot traffic %90%81%72%
<--- how many people walk by the store every day as a %
24
Traffic conversion %8%6%5%
<--- how many people that walk by buy something
25
Sell through (not expired)99.5%99.5%99.5%
<----- for fresh food, this is 30% to 15% waste. for vending its 5% to 1%
26
Smart-Cabinets321
27
Orders / day22148
28
Deliveries (at least) / week 110.5
29
30
Monthly Revenue$4,082$2,381$1,270
31
Revenue / day$136$79$42
32
33
Monthly Costs$2,104$1,231$638
34
Inventory cost / day$55$32$16
35
Payment processing fee / month$228$137$76
36
SaaS fee / month$180$120$60
37
Delivery cost / month$0$0$0
38
Data cost (if not on WIFI)$32$21$12
39
40
Gross Profit$1,979$1,150$632
41
Profit margin48%48%50%
42
Revenue share5%5%5%
<----- how much are you giving to the building? are there rules on this?
43
44
NET$1,775$1,031$568
45
Profit / unit$592$516$568
46
Hardware payback (months)101211
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