Sample Operations Analysis.xlsx

	A	B	C	D	E
1	Sample Operations Analysis			$0	Annual Gross Revenue
2	Est. Monthly Revenue (Avg).	$0.00
3	Item	Qty	Cost	Total	Notes/Comments
4	Royalty	6%	$0.00	$0.00	6% Wkly (Equivalent to 6% Monthly)
5	Brand Develop. Fund	2%	$0.00	$0.00	Additional 1% toward local advertising
6	Technology Fee	1	$550.00	$550.00	POS System/Mobile Apps/Timecard Manage
7	Local Internet	1	$200.00	$200.00	Must spend at least
8	Rent	1	$3,000.00	$3,000.00
9	Utilities	1	$500.00	$500.00	Est. at $350 - $500
10	COGS	30%	$0.00	$0.00	Cost of Goods Sold
11	Insurance	1	$275.00	$275.00	Insurance
12	Ice Machine	1	$275.00	$275.00	Ice Machine
13	Total Monthly			$4,525.00	Total Monthly
14
15
16
17	Monday - Friday
18	Time	Employees on shift	Rate/Hr	Total
19	5.30 - 6.30 (1 hr)	1	$12.00	$12.00
20	6.30 - 8.00 (1.5 hrs)	2	$12.00	$36.00
21	8.00 - 11.30 (3.5 hrs)	2	$12.00	$84.00
22	11.30 - 3PM (3.5 hrs)	2	$12.00	$84.00
23	3PM - 5PM (2 hrs)	2	$12.00	$48.00
24	5PM - 8PM (3 hrs)	2	$12.00	$72.00
25	Total (Day)			$336.00
26	Total (Week)			$1,680.00
27	Total (Month)			$6,720.00
28	Saturday
29	Time	#	Rate/Hr	Total
30	5.30 - 6.30 (1 hr)	1	$12.00	$12.00
31	6.30 - 8.00 (1.5 hrs)	2	$12.00	$36.00
32	8.00 - 11.30 (3.5 hrs)	2	$12.00	$84.00
33	11.30 - 3PM (3.5 hrs)	2	$12.00	$84.00
34	3PM - 5PM (2 hrs)	2	$12.00	$48.00
35	5PM - 8PM (3 hrs)	2	$12.00	$72.00
36	Total (Day)			$336.00
37	Total (Month)			$1,344.00
38	Saturday
39	Time	#	Rate/Hr	Total
40	5.30 - 6.30 (1 hr)	1	$12.00	$12.00
41	6.30 - 8.00 (1.5 hrs)	2	$12.00	$36.00
42	8.00 - 11.30 (3.5 hrs)	2	$12.00	$84.00
43	11.30 - 3PM (3.5 hrs)	2	$12.00	$84.00
44	3PM - 5PM (2 hrs)	2	$12.00	$48.00
45	5PM - 8PM (3 hrs)	2	$12.00	$72.00
46	Total (Day)			$336.00
47	Total (Month)			$1,344.00
48	Profit Margin			($13,933.00)
49	* Fill in the fields colored GREEN
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