SEH_MVP_budget.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH
1
2	Name	Jon Miller
3	Email	jon@vetsmakeit.com
4
5	INPUTS AND ASSUMPTIONS														Legend
6	ACTIVE INPUTS					SCENARIO MANAGER
7							ACTIVE CASE								User Selection

8		ACTIVE SCENARIO # (USER SELECTED	1			CASE#	1	1	2	3
9		ACTIVE SCENARIO NAME	Base			NAME	Base	Base	Upside	Downside					In-Sheet Link
10
11		One-way distance from OSE to Lot (Miles)	70				70	70	60	90					Input
12		Gas ($/gal)	4				4	4	4	5
13		Average MPG	15				15	15	18	12					Calculation
14		MO Sales Tax (%)	4.225%
15		Construction Days	15				15	15	10	30					Result
16		Planning Days	15				15	15	10	30
17		Paid Hours (hrs/day)	8
18
19		DEBT
20		Loan Amount
21		Annual Interest Rate
22		Tenor of Loan
23
24		CONSTRUCTION ASSUMPTIONS
25		Total SEH Construction Man-hours	1000
26
27		PERSONNEL ASSUMPTIONS
28		Builders
29		Volunteers
30		Crew Leaders	6
31		Crew Members	18
32		Total Build Crew	24
33
34		Managers
35		Project Manager	1
36		Regulatory Liaison
37		Logistics Manager
38		Site Manager	1
39		Total Managers	2
40
41		Total Personnel	26
42
43		WAGE ASSUMPTIONS
44		Crew Leader ($/hr)	50
45		Crew Member ($/hr)	50
46		Project Manager ($/SEH)
47		Site Manager ($/SEH)
48
49	COST CALCULATIONS
50	SEH PREPARATION COSTS
51		PLAN APPROVAL COSTS
52		Engineer approval	1000				1000	1000	500	1500
53
54
55		PERMITTING COSTS
56			325				325	325	250	400
57
58		LAND COSTS
59		Lot Price	0				0
60		Grading	12500				12500	12500	10000	15000
61		Utility Hookup	12500				12500	12500	10000	15000
62		Soil Inspection
63		Title and Deed fees	1250				1250	1250	500	2000
64
65		FOUNDATION COSTS
66
67
68		Total Preparation Costs
69
70	SEH CONSTRUCTION COSTS
71	FLAGS AND INDICES
72		Construction Timeline	Day #	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
73		Daily Construction Man-Hours		192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192	192
74		Cumulative Construction Man-Hours		192	384	576	768	960	1152	1344	1536	1728	1920	2112	2304	2496	2688	2880	3072	3264	3456	3648	3840	4032	4224	4416	4608	4800	4992	5184	5376	5568	5760
75		Construction Man-Hours Remaining		1000	808	616	424	232	40	-152	-344	-536	-728	-920	-1112	-1304	-1496	-1688	-1880	-2072	-2264	-2456	-2648	-2840	-3032	-3224	-3416	-3608	-3800	-3992	-4184	-4376	-4568
76		Construction Days		1	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
77
78		LABOR COSTS
79		Crew Leader	14400	2400	2400	2400	2400	2400	2400	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
80		Crew Member	43200	7200	7200	7200	7200	7200	7200	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0
81		Site Manager
82		Project Manager
83		Subtotal	57600
84
85		MATERIAL COSTS
86
87
88		DELIVERY AND STORAGE COSTS
89
90
91		INSPECTION COSTS
92		Building Consultant Cost
93
94	OSE COSTS
95		CAPITAL COSTS
96		TOOLS
97
98
99		JIG MATERIAL
100