Collaborative Estimate Example

	A	B	C	D	E	F	G
1
2	This document is provided as a demonstration of a Collaborative Estimate used by Sparkbox in intitial conversations with potential new clients. We invite our customers to help us with the estimate, since it’s only our combined knowledge and experience that can make for a successful project. The "Task" column below should be replaced with the tasks needed for a given project. The min and max hour columns allow you to make a rough estimate quickly by specifying a range. The rest of the fields are calculated based on the yellow highlighted fields. If you have questions, please talk to Ben Callahan: @bencallahan
3
4	Task	Min Hours	Max Hours	Min Price	Max Price	Avg Price
5	Research	40	80	$7,000.00	$14,000.00	$10,500.00	← here you can leave a note explaining what’s included in this range
6	Planning	80	120	$14,000.00	$21,000.00	$17,500.00	← you should replace each of these "task" lines with what’s needed for your specific project
7	Implementation	250	500	$43,750.00	$87,500.00	$65,625.00	← the calculations generate min, max, and average prices, helping your customer understand that there are many ways to approach each project
8	Polish	40	80	$7,000.00	$14,000.00	$10,500.00	← we always reserve time to refine the design in the browser—make sure you want to put the work in your portfolio and that your client is proud of your work
9	Support	80	160	$14,000.00	$28,000.00	$21,000.00	← you may need to plan for some support or training once the site is live—let your client know you don’t want to just finish the job and disappear, but that you’ll be around to help them support it long-term
10	Subtotal	410	780	$85,750.00	$164,500.00	$125,125.00	← doesn’t include project management
11	Total with PM			$98,612.50	$189,175.00	$143,893.75
12	Avg per week	51.25	65.00	$12,326.56	$15,764.58	$14,045.57	← we invoice weekly, so this provides a rough idea of the weekly cost
13
14
15		Rate / Hr	PM	OT Rate / Hr
16		$175.00	15.00%	$262.50	← set your hourly rate and an estimated percentage of time for Project Management, overtime is calculated at 1.5 x the hourly rate
17
18		Min Weeks	Max Weeks
19		8	12	← these are used to calculate the averages on line 12 above, and provide a very rough undersanding of the total duration of the project
20
21
22
23
24
25
26
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