Road to Pitches: Budget

	B	C	D	E	F	G	H	I
1
2	Category	Description	Quantity	Cost per Unit	Budget Total	Actual Total		Variance [(under)/over]

3	Vehicle	Truck	1	$9,000	$9,000	$12,901		$3,901
4	Vehicle	Safety inspection	1	$300	$300	$229		-$71
5	Vehicle	Towing services	1	$500	$500	$0		-$500
6	Vehicle	Repairs (tires)	1	$3,000	$3,000	$961		-$2,039
7	Vehicle	Insurance (per month)	12	$150	$1,800	$320		-$1,480
8	Vehicle	Detailing	1	$0	$0	$136		$136
9					$14,600	$14,547		-$53
10
11	Solar	300 W Solar Cell	2	$300	$600	$524		-$76
12	Solar	100 Ah Battery	2	$780	$1,560	$1,850		$290
13	Solar	Battery Management System	2	$50	$100	$0		-$100
14	Solar	Solar Charger	1	$300	$300	$201		-$99
15	Solar	Inverter 2kW	1	$200	$200	$226		$26
16	Solar	24 V USB-C Charger	1	$100	$100	$0		-$100
17	Solar	Cables and Wires - Solar	0	$0	$0	$169		$169
18	Solar	Roof rack	0	$0	$0	$0		$0
19
20					$2,860	$2,970		$110
21
22	Electrical	LED lights	8	$20	$160	$164		$4
23	Electrical	Cable and Wires - Electrical	1	$500	$500	$198		-$302
24	Electrical	Electrical terminators	1	$150	$150	$589		$439
25
26	Plumbing	Grey Water Tank	1	$100	$100	$0		-$100
27	Plumbing	Fresh Water Tank	1	$150	$150	$32		-$118
28	Plumbing	Pumps, pipes	1	$100	$100	$50		-$50
29	Plumbing	Plumbing hardware and connectors	1	$200	$200	$405		$205
30
31	Bathroom	Propane shower heater	1	$170	$170	$206		$36
32	Bathroom	Shower pan/wet room	1	$400	$400	$463		$63
33	Bathroom	Composting toilet (DIY)	1	$70	$70	$123		$53
34
35	Floors	Plywood - floors	3	$15	$45	$71		$26
36	Floors	Lumber - floors	10	$7	$70	$54		-$16
37	Floors	Insulation - floors	0	$0	$0	$66		$66
38	Floors	Supplies - floors	0	$0	$0	$28		$28
39	Floors	Flooring	0	$0	$0	$0		$0
40
41	Structure	Plywood 0.5mm Walls	13	$15	$195	$439		$244
42	Structure	More Plywood	5	$30	$150	$185		$35
43	Structure	Lumber	10	$7	$70	$145		$75
44	Structure	Windows and door	1	$500	$500	$45		-$455
45	Structure	Roof vent	2	$100	$200	$226		$26
46	Structure	Insulation - walls	0	$0	$0	$45		$45
47	Structure	Skylight & supplies	0	$0	$0	$171		$171
48	Structure	Ceiling Slats	0	$0	$0	$508		$508
49	Structure	Vinyl floors	0	$0	$0	$117		$117
50	Structure	Drawers	0	$0	$0	$365		$365
51
52					$1,115	$2,247		$142
53
54	Misc	Diesel Heater	1	$200	$200	$147		-$53
55	Misc	Backup Camera	1	$100	$100	$68		-$32
56	Misc	Hardware, tools, supplies	1	$500	$500	$1,113		$613
57	Misc	Demolition waste	1	$0	$0	$60		$60
58	Misc	Parking and tickets	1	$0	$0	$294		$294
59
60					$800	$1,682		$588
61
62	Kitchen	Sink	1	$50	$50	$57		$7
63	Kitchen	Faucet	1	$30	$30	$100		$70
64	Kitchen	Kitchen counter	1	$130	$130	$343		$213
65	Kitchen	Gas cooker	1	$80	$80	$40		-$40
66	Kitchen	Inverter for fridge	1	$40	$40	$21		-$19
67	Kitchen	Fridge (used)	1	$50	$50	$180		$130
68	Kitchen	Backsplash	0	$0	$0	$40		$40
69	Kitchen	Kitchen drawers	0	$0	$0	$195		$195
70
71					$380	$976		$231
72
73	Interior	Paint and supplies	1	$100	$100	$74		-$26
74	Interior	Curtains	1	$50	$50	$0		-$50
75
76	Media	Website	1	$0	$0	$20		$20
77	Media	Marketing materials	1	$0	$0	$205		$205
78	Media	Camera	1	$0	$0	$1,130		$1,130
79	Media	Camera peripherals	1	$0	$0	$159		$159
80					$0	$1,514		$1,514
81
82	Total				$22,020	$26,458		$4,494
83				Total Unbudgeted	$5,222	$5,222	Total Unbudgeted
84				Expected Cost	$27,242	$21,236	Total Budgeted Spend
85				Expected Remaining Spend	$784	$784	Expected Remaining Spend
86
87				Cost of build only		$10,397
88
89	SUMs
90	Category	Total Spend	Under	Over	Budget Total	Actual Total		Net
91	Solar	$2,860	$0	$110	$2,860	$2,970		$110
92	Electrical	$810	$0	$141	$810	$951		$141
93	Plumbing	$486	$64	$0	$550	$486		-$64
94	Bathroom	$640	$0	$152	$640	$792		$152
95	Structure	$1,115	$0	$1,132	$1,115	$2,247		$1,132
96	Misc	$800	$0	$882	$800	$1,682		$882
97	Kitchen	$380	$0	$596	$380	$976		$596
98	Interior	$74	$76	$0	$150	$74		-$76
99	Media	$0	$0	$1,514	$0	$1,514		$1,514
100	Vehicle	$14,547	$0	$53	$14,600	$14,547		$53