Mankato

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Profit and Loss / Income Statement			Inputs
2	Assumptions
3		Manager Hourly Rate	25.00	25.00	25.00	25.00	25.00	25.00	25.00	25.00	25.00	25.00	25.00	25.00
4		Manager Hours	0.00	0.00	6.50	11.50	4.75	0.50	1.75	3.75	25.75	11.25	0.00	0.00
5																25%	25%
6			22-Jan	22-Feb	22-Mar	22-Apr	22-May	22-Jun	22-Jul	22-Aug	22-Sep	22-Oct	22-Nov	22-Dec	TOTAL	TOTAL	TOTAL
7		INCOME	Hub	Hub	Hub	Hub	Hub	Hub	Hub	Hub	Hub	Hub	Hub	Hub	Hub	YR 2	YR 3
8		Total Earned Revenue													$ 500.00	$ 625.00	$ 781.25
9		Online Sales (Aggregration)	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
10		Market Share Boxes	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
11		Wholesale Sales	$ -	$ -	$ -	$ -	$ 200.00	$ 300.00	$ -	$ -	$ -	$ -	$ -	$ -	$ 500.00	$ 625.00	$ 781.25
12		Sponsorships	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
13		LFPP Expenses	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -
14		LFPP Labor	$ -	$ -	$ 162.50	$ 287.50	$ 118.75	$ 12.50	$ 43.75	$ 93.75	$ 643.75	$ 281.25	$ -	$ -	$ 1,643.75	$ 2,054.69	$ 2,568.36
15		TOTAL INCOME	$ -	$ -	$ 162.50	$ 287.50	$ 118.75	$ 12.50	$ 43.75	$ 93.75	$ 643.75	$ 281.25	$ -	$ -	$ 2,143.75	$ 2,679.69	$ 3,349.61
16		COSTS OF GOOD SOLD	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%	70%		65%	65%
17	Once we have sales/price items we can refined this by adding values by account and tweaking the % of sales	Boxes, bags, other packaging													$ -
18		Purchase of product for marketshare boxes													$ -
19		Purchase of product for wholesale sales													$ -
20		Labor	0	0	0	0	0	0	0	0	0	0	0	0	$ -
21		Total COGS	$ -	$ -	$ 113.75	$ 201.25	$ 83.13	$ 8.75	$ 30.63	$ 65.63	$ 450.63	$ 196.88	$ -	$ -	$ 1,150.63	$ 1,741.80	$ 2,177.25
22		Gross Profit	$ -	$ -	$ 48.75	$ 86.25	$ 35.63	$ 3.75	$ 13.13	$ 28.13	$ 193.13	$ 84.38	$ -	$ -	$ 993.13	$ 937.89	$ 1,172.36
23	Expenses	EXPENSES
24		Hub Manager	0	0	162.5	287.5	118.75	13	43.75	93.75	643.75	281.25	0	0	1,643.75	2054.6875	2568.359375
25		Market's OASDI & Medicare obligation													0.00	0	0
26		Other staff wages paid													0.00	0	0
27		Market's OASDI & Medicare obligation													0.00	0	0
28		Online ordering platform subscription			750										750.00	937.5	1171.875
29		Credit/debit card processing fees													0.00	0	0
30		Food handler license													0.00	0	0
31		Insurance													0.00	0	0
32		Marketing and Promotion													0.00	0	0
33		Supplies													0.00	0	0
34															0.00	0	0
35															0.00	0	0
36		Total Expenses	0.00	0.00	912.50	287.50	118.75	12.50	43.75	93.75	643.75	281.25	0.00	0.00	2,393.75	2,992.19	3,740.23
37
38		NET INCOME	$ -	$ -	$ (863.75)	$ (201.25)	$ (83.13)	$ (8.75)	$ (30.63)	$ (65.63)	$ (450.63)	$ (196.88)	$ -	$ -	$ (1,400.63)	$ (2,054.30)	$ (2,567.87)
39
40		Capital and Other Expenditures (over $1,000 \| coolers, refrigeration, trailers, cool bot, )
41			22-Jan	22-Feb	22-Mar	22-Apr	22-May	22-Jun	22-Jul	22-Aug	22-Sep	22-Oct	22-Nov	22-Dec	TOTAL	TOTAL	TOTAL
42															0.00	0	0
43															0.00	0	0
44															0.00	0	0
45															0.00	0	0
46															0.00	0	0
47			$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	0
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