Budget (CURRENT).xlsx

	A	B	C	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Expenses			Income
2
3	Overhead (monthly)	$8,178.41		Labour	$6,855.76
4	Gross profit (monthly, pre-tax)	$2,377.35		Materials and subcontract	$3,700.00
5	Gross profit (annually, pre-tax)	$28,528.20		Total (monthly)	$10,555.76
6
7
8	Monthly expense	Details	cost
9	General liability insurance	Western Coast insurance $1000.91 /year	$83.41		hourly wage	worksafe	E.I.	CPP	vacation	stat	sick days	true cost	charge out	hourly net	hours/month	benefits (monthly)	monthly net
10	Powell River business license	$180/year	$15.00	employee contributions			1.58%	5.25%
11	POP insurance	Worksafe personal coverage $1200 /year	$100.00	employer contributions		4.79%	2.26%	5.10%	4%	4%	4%
12	accounting services	Avalon (bookeeping, payroll, taxes)	$750.00	Mike	$30.00	$1.44	$0.68	$1.53	$1.20	$1.20	$1.20	$37.25	$55.00	$17.76	60		$1,065.30
13	tools	new tools	$300.00	JP (lead)	$42.00	$2.01	$0.95	$2.14	$1.68	$1.68	$1.68	$52.14	$75.00	$22.86	60		$1,371.42
14	consumables	glue, shop supply, blades, etc.	$200.00	Brandon	$32.00	$1.53	$0.72	$1.63	$1.28	$1.28	$1.28	$39.73	$60.00	$20.27	70		$1,419.04
15	tool maintenance / depreciation		$200.00	Craig (carpenter)									$75.00	$75.00	40		$3,000.00
16	office supply	paper, ink, etc	$30.00	Craig (contractor)									$80.00	$80.00	0		$0.00
17	Misc. and unexpected		$500.00
18	employee appreciation		$60.00		monthly cost	markup	income
19	digital subscriptions	timesheet app, website hosting, zoho sign	$75.00	Materials	$15,000.00	15%	$2,250.00
20	marketing	Google ads, signs, business cards etc.	$100.00	Subcontract	$3,000.00	15%	$450.00
21	work truck insurance		$90.00	Kingcome			$1,000.00
22	work truck maintenance / depreciation		$200.00
23	gas		$600.00
24	phone		$45.00
25	internet		$30.00
26	owner pay	$1200 / week salary	$4,800.00
27	Project managing	one day / week	0
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