Productivity Worksheet

	A	B	C	D	E	F	G	H	I
1	Plan to	$30,000.00		Ave Hrly Pay	$15.00	Mthly Increase	$4,000.00		Setup & use worksheet
2								1	What's your revenue goal?
3		Period 1	Period 2	Period 3	Period 4	Period 5	Period 6	2	What is your average hourly pay?
4	Revenue	$10,000.00	$14,000.00	$18,000.00	$22,000.00	$26,000.00	$30,000.00	3	What is your current monthly revenue?
5	Marketing ROI	15	15	15	15	15	15	4	What is your average marketing ROI
6	Marketing Spend	$666.67	$933.33	$1,200.00	$1,466.67	$1,733.33	$2,000.00	5	What is your job average?
7	Job Average	$4,500.00	$4,500.00	$4,500.00	$4,500.00	$4,500.00	$4,500.00	6	Change # of employees. Keep productivity and Percentage in green as much as possible
8	Jobs / Month	2.2	3.1	4.0	4.9	5.8	6.7
9	Leads / Month	11.1	15.6	20.0	24.4	28.9	33.3
10
11
12	Employees	1	1	2	2	2.5	3
13	Monthly Hours	160	160	320	320	400	480		Steps to manage growth
14	Productivity	$62.50	$87.50	$56.25	$68.75	$65.00	$62.50	1	Maintain ROI within +/- of 1
15								2	Spend the correct amount for marketing each month
16								3	Maintain current job average or better
17	Check							4	Sell the calculated weekly goal
18	30% payroll	$3,000.00	$4,200.00	$5,400.00	$6,600.00	$7,800.00	$9,000.00	5	Hire 30 days before the need
19	Actual Payroll	$2,400.00	$2,400.00	$4,800.00	$4,800.00	$6,000.00	$7,200.00	6	No overtime
20	Percentage	24%	17%	27%	22%	23%	24%	7	Monitor productivity of each job (establish processes)
21
22
23
24
25	Profit First	$10,000.00
26
27	Income
28	Profit	500
29	Owners Comp	5000
30	Tax	2000
31	OP X	$2,500.00
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58	Monthly Expenses	$/Month
59
60	Van/General insurance	$191
61	Website	$25
62	Gas	$330
63	Electricity	$100
64	Quickbooks	$30
65	Banking	$10
66	Sander/Vacuum	$325
67	Google Domains	$13
68	Verizon	$450
69	Accountant	$25	Daily
70
71
72	Total	$1,499	$68
73
74	Jeep Insurance	$120
75	Jeep	$320
76	Rent	$1,500
77	Life Ins	$16
78	Tranont	$200
79	Young Living	$75
80	Food	$500
81	Eating out	$200
82	Legal Shield	$30
83	Streaming TV	$47
84	Internet	$65
85	Electricity	$300
86	Dance	$160
87	Total	$3,533
88
89	Business Monthly Total	$1,499
90	Personal Monthly Total	$3,533
91
92	Monthly Total	$5,032	$229
93
94
95
96	Daily revenue Min		$297
97
98	Taxes	$707
99
100