Pricing Example (MAKE A COPY).xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2
3	Employee Name	LCAT	Hourly Rate	FICA	Suta	Benefits	Direct Fringe	Direct Rate	On Site Rate	Profit / Risk	Fully Loaded Billing Rate	Target Burdened Rate	Accept (Y/N)	Final Base Year Rate	Final OY1 Rate	Final OY2 Rate	Final OY3 Rate	Final OY4 Rate
4	Employee 1	Janitor 1	$19.00	$0.00	$0.00	$4.41	$4.41	$19.00	$26.67	$2.40	$29.07	$0.00		$29.07	$29.50	$29.94	$30.39	$30.85
5			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		$0.00	$0.00	$0.00	$0.00	$0.00
6			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00		$0.00	$0.00	$0.00	$0.00	$0.00
7
8
9			$19.00	$0.00	$0.00	$4.41	$4.41		$26.67	$2.40				$29.07	$29.50	$29.94	$30.39	$30.85
10
11
12	NOTES:											Proposed Revenue		$ 55,579	$ 56,404	$ 57,245	$ 58,106	$ 58,985	$ 286,319
13	Assumptions											Fringe		$ 9,173	$ 9,173	$ 9,173	$ 9,173	$ 9,173	$ 45,864
14	Total Hours of Service		1912	Given								Labor		$ 39,520	$ 39,520	$ 39,520	$ 39,520	$ 39,520	$ 197,600
15												Gross Profit		$ 6,886	$ 7,711	$ 8,552	$ 9,413	$ 10,292	$ 42,855
16												%		12%	14%	15%	16%	17%	15%
17
18												OH	10%	$ 688.63	$ 771.12	$ 855.25	$ 941.29	$ 1,029.24	$ 4,285.52
19												G&A	16%	$ 1,101.80	$ 1,233.79	$ 1,368.40	$ 1,506.06	$ 1,646.78	$ 6,856.84
20												Fringe	10%	$ 688.63	$ 771.12	$ 855.25	$ 941.29	$ 1,029.24	$ 4,285.52
21												Operational Costs		$ 2,479.06	$ 2,776.03	$ 3,078.89	$ 3,388.64	$ 3,705.26	$ 15,427.89
22												Net Profit		$ 4,407	$ 4,935	$ 5,474	$ 6,024	$ 6,587	$ 27,427
23
24
25
26											Estimated Revenue Per Month			$ 4,631.59	$ 4,700.33	$ 4,770.44	$ 4,842.14	$ 4,915.43
27
28
29
30
31
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
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