Ahousaht Financial Overview


1	Ahousaht Values
2	Open, Honest, Transparent Communication
3	Maintain spending within our mandated Management Action Plan (MAP)
4	Maximizing value for the entire community input & involvement
5	Capacity Building through Training
6	Mutual Accountability
7
8
9	Executive Director Contact: Rob Bullock cell: 250 888 7439 rbullock@ahousaht.ca
10
11
12
13	please go to our new redesigned website at www.ahousaht.ca
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35


1	Name	Department	Cell	Work	EMAIL

2	All Council				council@ahousaht.ca
3
4	Alec Dick	Manager, Operations & Maintenance		250-670-9585	Alec.Dick@ahousaht.ca
5	Andrew Webster	Council	250-385-7907		Andrew.Webster@ahousaht.ca
6	Angus Campbell	Council	250-266-2493		Angus.Campbell@ahousaht.ca
7	Anne Atleo	Operations Coordinator	250-266-2657	250-670-9563	Anne.Atleo@ahousaht.ca
8	Arnold Robinson	Council	250-266-2648		arnold.robinson@ahousaht.ca
9	Barb Atleo	Aboriginal Justice		250-670-9558	Barb.Atleo@ahousaht.ca
10	Bonita Frank	Medical & Membership		250-670-9531 or 9563	Bonita.Frank@ahousaht.ca
11	Caroline Atleo	Housing		250-670-2452	Caroline.Atleo@ahousaht.ca
12	Clara Thomas	Council, Admin & Finance Receptionist	250-266-2278	250-670-9531 or 9563	Clara.Thomas@ahousaht.ca
13	Cliff Atleo	Council			Cliff.Atleo@ahousaht.ca
14	Darlene Dick	Alcohol & Drug Councilor, Council		250-670-9558	Darlene.Dick@ahousaht.ca
15	Dave Frank	Cultural Support		250-670-3558	Dave.Frank@ahousaht.ca
16	Dave G Jacobson	Health	250-266-0085		dave.g.jacobson@ahousaht.ca
17	Qamiina (Edward) Sam	Council	250-726-1541	250-670-2412	edward.sam@ahousaht.ca
18	Gena Swan	Accounts payable		250-670-9563	gena.swan@ahousaht.ca
19	Greg Louie	Chief Councilor	250-726-8222	250-670-9563	Greg.Louie@ahousaht.ca
20	Guy Louie	Council	250-885-1665		Guy.Louie@ahousaht.ca
21	Joe Rampanen	Council	250-266-2527		Joe.Rampanen@ahousaht.ca
22	John Titian	Fisheries Guardian		250-670-9535	John.Titian@ahousaht.ca
23	Julia Atleo	Health Manager	250-266-2489	250-670-9558	Julia.Atleo@ahousaht.ca
24	Karen Frank	Ahousaht Health Rep		250-670-3558	Karen.Frank@ahousaht.ca
25	Kayla Little	Housing Assistant		250-670-2452	kayla.little@ahousaht.ca
26	Larry Swan	Fisheries guardian		250-670-9535	Larry.Swan@ahousaht.ca
27	Iris Frank	Office Manager - Health Dept		250-670-9558	iris.frank@ahouaht.ca
28	Louie Frank Jr	Youth Worker		250-670-9558	Louie.Frankjr@ahousaht.ca
29	Luke Swan	Council, Fisheries Manager	250-266-2509	250-670-9535	Luke.Swan@ahousaht.ca
30	Marie Donahue	Aboriginal Justice		250-670-9558	Marie.Donahue@ahousaht.ca
31	Mark Jack	Council	250-266-2492	250-670-9583	Mark.jack@ahousaht.ca
32	Melinda Swan	Operations Coordinator assistant		250-670-9563	melinda.swan@ahousaht.ca
33	Michelle Campbell	Admin & Finance		250-670-9563	Michelle.Campbell@ahousaht.ca
34	Molina Dick	Admin & Finance	2502662652	250-670-9565	Molina.Dick@ahousaht.ca
35	Noreen John	Admin & Finance		250-670-9563	Noreen.John@ahousaht.ca
36	Patti Campbell	Council, Deputy Chief	250-266-2497	250-670-9670	Patti.Campbell@ahousaht.ca
37	Ramona Mark	Family Support Worker		250-670-9558	Ramona.Mark@ahousaht.ca
38	Rebecca Atleo	Education Director	250-266-1792	250-670-9662	rebecca.atleo@ahousahted.ca
39	Rob Bullock	Executive Director	250 888 7439		Rob.Bullock@ahousaht.ca
40	Robert Atleo	Social Development Manager	250-266-0026	250-670-9558	Robert.Atleo@ahousaht.ca
41	Rod Sam	Water Tech		250-670-9585	Rod.Sam@ahousaht.ca
42	Selina Frank	Family Support Worker	250-	250-670-9558	Selina.Frank@ahousaht.ca
43	Thomas Campbell	Council	250-731-7758		Thomas.Campbell@ahousaht.ca


1		Monthly Pmt	2013-14	2014-15	2015-16	12	MONTHS
2	Mortgage - Bank of Montreal; repayable at $5,737 per month including interest at prime
3	plus 1.875% per annum; term maturity date of August 31, 2016; secured by a Ministerial
4	guarantee. 47,806 112,629		112,629	47,806
5	Loan - Nuu-chah-nulth Tribal Council - Note 9 4,917,699 4,917,699	0	4,917,699	4,917,699	4,917,699
6	Loan - All Nations Trust, lender for CMHC housing; repayable at $6,785 per month
7	including interest at 1.64% per annum; term maturity date of December 1, 2036; secured
8	by buildings with a net book value of $1,759,876. 1,488,527 1,545,111	6,785	1,545,111	1,488,527	1,431,064
9	Loan - Bank of Montreal; repayable at $2,350 per month including interest at prime plus
10	1.5% per annum; secured by Ministerial guarantee 124,883 150,283	2,350	150,283	124,883	99,483
11	Loan - Bank of Montreal; repayable at $18,695 per month including interest at prime plus
12	2.0% per annum, secured by Ministerial guarantee 2,245,670 2,355,342	18,695	2,355,342	2,245,670	2,125,474
13	Demand loan - Royal Bank of Canada; repayable at $2,275 per month including interest at
14	3.33% per annum; secured by a Ministerial guarantee 301,331 318,593	2,275	318,593	301,331	283,536
15	Demand loan - Royal Bank of Canada; repayable at $2,095 per month including interest at
16	2.73% per annum; secured by a Ministerial guarantee 60,656 83,801	2,095	83,801	60,656	36,876
17	Demand loan - Royal Bank of Canada; repayable at $2,637 per month including interest at
18	3.99% per annum; secured by a Ministerial guarantee 444,240 457,905	2,637	457,905	444,240	428,864
19	Demand loan - Royal Bank of Canada; repayable at $2,350 per month including interest at
20	1.5%. 49,271 74,652	2,350	74,652	49,271	0
21	Loan - Nuu-chah-nulth Economic Development Corporation (loan #1); repayable at $650
22	per month including interest at 8% per annum, term maturity date of January 1, 2019;
23	secured by a promissory note in the amount of $54,000 33,112 19,671	650	19,671	33,112	25,136
24	Loan - Nuu-chah-nulth Economic Development Corporation (loan #2); repayable at $2,329
25	per month including interest at 8% per annum, term maturity date of January 1, 2019;
26	secured by a loan agreement in the amount of $217,600 181,241 194,521	2,329	194,521	181,241	162,724
27	Foregivable Loan - Nuu-chah-nulth Economic Development Corporation; forgivable
28	against a contribution of $25,000 towards the dock improvements, non-interest bearing, to
29	be paid down by forgiving $1 for every $1 principal paid on loan #2. 4,534 25,000		25,000	4,534	0
30	Loan - Nuu-chah-nulth Economic Development corporation: repayable at $2,427 per
31	month including interest at 7% per annum; matures on April 1, 2022 and secured by a
32	promissory note from Ahousaht Education Authority and Ahousaht First Nation. 170,227 186,903	2,427	186,903	170,227	152,318
33	Loan - Nuu-chah-nulth Economic Development corporation: repayable at $1,093 per
34	month including interest at 12% per annum; matures on May 1, 2022 and secured by a
35	promissory note from Ahousaht Education Authority and Ahousaht First Nation. 66,546 71,432	1,093	71,432	66,546	52,641
36	Loan - Royal Bank		40,346
37	Loan - Royal Bank		17,416
38	Loan - Bank of Montreal		7,851
39
40			10,579,155	10,135,743	9,715,815
41					4,798,116


1	Ahousaht Chief & Council STRATEGIC PLAN
2	1. Develop an ʕaaḥuusʔatḥ Constitution
3	2. Promote organizational culture based on ʕaaḥuusʔatḥ pillar values
4	3. Build an Elders and Disability Long-term Care facility and/or a Palliative Care home (L,A,Q; 2YR)
5	4. Develop an overall ʕaaḥuusʔatḥ housing plan including homes for young families, elders and rental units
6	5. Establish an affordable day care other than the school for working parents
7	6. Develop youth program promoting healthy, active ʕaaḥuusʔatḥ youth (C, 1H)
8	7. Develop a library (C,1H)
9	8. Improve use of Information Technology (Computer room for job hunting, resumes, teaching community) (G, 1H)
10	9. Repair the community gardens’ greenhouse, and continue to grow our own fruits and vegetables (C,1H)
11	10. Prepare for staff retirements
12	11. Re-activate committees
13	12. Engage in quarterly meetings with ḥaw’iiḥ (Q, 1H)
14	13. Ensure the Tofino Protocol agreement is followed (A, 1H)
15	14. Re-establish the Ahousaht Security
16	15. Ensure our roads are paved and well drained (2YR)
17	16. Develop and build a Spiritual Place on old church site (G, Q; 1H)
18	17. Implement a new waste and waste water treatment plant
19	18. Improve Emergency Preparedness, Emergency Centre, Ambulance, Fire, Training, First Responders, Community Communication (C,L; 1H)
20	19. Revise the Ahousaht Financial Policy
21	20. Revise the Ahousaht Personnel Policy
22	21. Revise the Ahousaht Elections Code
23	22. Follow the Community Tripartite Agreement between Ahousaht and the RCMP (1H)
24	23. Resume with Governance training to Chief and Council, managers, and staff (Ar, 1H)
25	24. Sign the USMA protocol agreement
26	25. Establish a new cemetery (L; 1YR)
27	26. Ensure a new strategic plan is revisited every four years after each Chief and Council election
28	27. Establish an ʕaaḥuusʔatḥ census
29	28. Strengthen new sources of revenue; more jobs; Economic Action Plan (strong partnership with MHSS) (G, 1H)
30	29. Establish a taxation system for properties, homes and businesses in the ʕaaḥuusʔatḥ hahoulthee
31	30. Revisit the Community and Land Use Plan
32	31. Develop a risk management plan including business continuity
33	32. Achieve all goals set out in the Management Action Plan (MAP) and exit the MAP as soon as possible
34	33. Continuously be aware of opportunities for all Ahousaht, all departments, staff and community
35	34. Health and Life Skills for Community (C; 1YR)
36	35. Replace Administrative Building (Gr; 2YR)
37	36. Debt Elimination Plan (G, 2YR)
38	37. Language Teachings (G, 1YR)
39	38. Overall Communication Plan (G, 1H)
40	39. Community Training, Job Skills, Fishing Skills (1H)
41
42	Council Support: A-Andy, Ar-Arnie, C-Cliff, G-Guy, Gr-Greg, L-Luke, Q-Quamina
43	Time Frame: 1H-Six Months, 1YR – one year, 2YR – two years
44
45	Risks:
46	Natural Disasters, Attacks/Terrorism, Wildlife, Staffing issues, Technology, Infrastructure break downs,
47	Diseases, Power Outage, Cultural & Community Practises, Attendance, Addiction, Family Issues


1	Executive Director Projects/Notes																INAC Ahousaht Renewal
2									Year End Analysis/Prep/Adjustments
3	INAC	WWTP							GL Ops to Capital Adjustments		Jan 25, 2016	posted Jan 29, 2016					Program	Program	2015-16	2016-17	2017-18	2018-19	Increase	Apr 01		Program Description
4	Renewal - 2 + 1 year renewal (last year under outside of MAP)	First Pmt	INAC Approved Aug 2015	96,338.00	WCC	July 2015	21,220.18	Chq#	101 buildings renovations								NG00	Band Admin	570,698.40	619,173.00		643,291.00	8.49%	133153.35	x	NG00 - IGS - BAND 1 378.A0920.NG00.10659.A0000.82431 $153,971.00
5	Housing Streams 1, 2, 3, Stacy MacNeil,		Rec'd Jan 4, 2016			Aug 2015	10,941.50		70100	-101	70100	REPAIR	EXPENSE	873.6			NP00	AEA School	3,167,152.30	3,347,285.00		3,477,667.00	5.69%		x	NP00 - ELEMENTARY/SECONDARY 1 378.A0920.NP00.10659.A0000.82431 $832,379.00
6	Self Governance		WCC	85,000.00		Sep 2015	7,695.00		70150	-101	70150	FUEL	EXPENSE	176			NP50	AEA Post Secondary	754,762.95	797,691.00		828,761.00	5.69%		x	NP50 - POST SECONDARY EDUCATION 1 378.A0920.NP50.10659.A0000.82431 $198,364.00
7	OSR Clawback (Blue Book)		Proj Leader	6,000.00		Oct 2015	10,067.50		70200	-101	70200	ADMIN	EXPENSE	815			NP80	Income Assistance	1,166,289.85	1,282,379.00		1,332,329.00	9.95%		x	NP80 - INCOME ASSISTANCE 1 378.A0920.NP80.10659.A0000.82431 $318,893.00
8	Community Comprehensive Plan (CCP) >$75k (Contacted Feb 17 2016 CCP Comm Comprehensive Plan Wendy Cheney or Paul Miller acting 604-868-3250)		Band Admin	5,338.00		Nov 2015	13,898.83		70275	-101	70275	SUPPLIES	EXP	32,672.46			NPC0	Assisted Living	95,062.40	104,525.00		108,596.00	9.95%		x	NPC0 - ASSISTED LIVING - BLOCK 1 378.A0920.NPC0.10659.A0000.82431 $25,992.00
9				96,338.00		Dec 2015	18,304.89		70350	-101	70350	CONTRACTS	EXP	6,056.82			NPG0	Membership	11,307.40	11,951.00		12,416.00	5.69%	2570.4	x	NPG0 - LTS CORE-REGIS&MEMBERSHIP 1 313.A0920.NPG0.10659.A0000.82431 $2,972.00
10	Admin		Contingency	41,000.00					70375	-101	70375	EQUIPMENT	PURCHASED	1,100.04			NT40	Economic Devel	88,777.10	93,826.00		97,481.00	5.69%		x	NT40 - LEDSP-EcDev-Allocations 1 378.A0920.NT40.10659.A0000.82431 $19,832.20
11	Year End Prep (reclassifications of charges - capital)					WCC Total	82,127.90	2,872.10	70400	-101	70400	FREIGHT	EXPENSES	1,308.00			NTH1	AEA O&M	14,415.15	17,254.00		17,926.00	19.69%		x	NTH1 - EDU - FACILITIES O&M 1 378.A0920.NTH1.10659.A0000.82431 $3,647.35
12	Strategic Planning - updates every 6 months, community involvement	Second pmt	INAC Approved Sept 2015	115,303.00					75000	-101	75000	ADMINITRATION	FEES	6,072.67			NTK0	Housing Ops	270,063.70	323,250.00		335,841.00	19.69%		x	NTK0 - HOUSING 1 378.A0920.NTK0.10659.A0000.82431 $68,326.40
13	Emergency Preparedness - Emergency Response Center (Jody Kaden)		band admin	2,806.00	GrPacific	Oct 2015	5,470.48	chq 2535 20160116	80350	-101	80350	WATER	TAXI	1,075.00			NTM0	Capital	405,094.70	484,875.00		503,762.00	19.69%		x	NTM0 - OTHER - CAPITAL 1 378.A0920.NTM0.10659.A0000.82431 $102,488.75
14	Grants/ Funding In		Total	118,109.00		Nov 2015	10,108.92	chq 2535 20160116	80400	-101	80400	WAGES	EXPENSE	56,066.47			NTM1	Ops & Maint	322,825.75	200,847.00		208,670.00	-37.78%		x	NTM1 - OTHER - FACILITIES O&M 1 378.A0920.NTM1.10659.A0000.82431 $81,674.80
15	HR Policy / Staff Meeting March		Contingency	22,580.00		Dec 2015	14,837.43	chq 19 20160128	80450	-101	80450	EI	EXPENSE	5,852.79				Waste & Wastewater		185,557.00		192,785.00
16	Community Communication Initiative- Emergency Phones		Net payment	95,529.00					80500	-101	80500	CPP	EXPENSE	771.15			Grand Total	Grand Total	6,866,449.70	7,468,613.00			8.77%
17	Community Planning Initiative (CCP)								80550	-101	80550	WCB	EXPENSE	3,179.76											x	Water & Wastewater Operations
18	Debt Reduction - two loans, possibly NEDC Loan				Golder	2/22/2016	1337.7	inv 744236	80600	-101	80600	PENSION	PLAN	3,609.96	119,629.72											NPE0 - PREVENTION PROJECTS (2015/16 Family Violence Protection ) 1 355.A093D.NPE0.10659.A0000.82431 $14,013.00
19	OH&S																NPE0		14,013.00
20	Report prep/submissions					12/22/2015	28,584.40	INVOICE 731947 DEC 22/2015 $ 28584.40 CHEQUE # 10-002421O/S	102	equipment							NTMV		95,580.00							TBD
21	Treaty Loan - Nancy	Contingency	INAC Approved	41,000.00				INVOICE 20150603 JUNE 3 /2015 $ 300.00 CHEQUE # 50-000251 R	70100	-102	70100	REPAIR	EXPENSE	4,190.75			New 2016-17			66,906.00
22			Asked release Dec 2015	22,580.00			31,754.53	INVOICE 515432 JUNE 12/2012 $ 617.50 CHEQUE # 10-000050 R	70150	-102	70150	FUEL	EXPENSE	1,443.41			Total		6,976,042.70	7,468,613.00					A	7.06%
23	Housing			18,420.00				INVOICE 529411 FEB 19/2013 $ 29009.79 CHEQUE # 10-000071R	70175	-102	70175	EQUIP	RENTAL	264.22			Total Education		3,936,330.40	4,162,230.00						5.74%
24	Toolkit of agreements, templates	WCC						INVOICE 529411 FEB 19 2013 $ 29009.79 CHECQUE # 10-000080 O/S	70275	-102	70275	SUPPLIES	EXP	5,103.58			Total Admin		3,039,712.30	3,306,383.00						8.77%
25	Private Homes Repairs, Completions: Need accounting from owner	2015 Fees		149,240.00					70350	-102	70350	CONTRACTS	EXP	5,823.65
26	Rental Repairs	Travel		13,340.00					70375	-102	70375	EQUIPMENT	PURCHASED	4,491.71			Cash Flow
27	Rent to Own	Mileage		4,400.00					70400	-102	70400	FREIGHT	EXPENSES	778			Apr		1,889,559.00	10,705.00				1,900,264.00
28		Boat		1,040.00					70550	-102	70550	INSURANCE	EXP.	1,186.00			May		619,895.00	8,029.00				627,924.00
29	Capital	Accommodations		2,550.00					70575	-102	70575	INTEREST	EXP.	1.16			June		619,895.00	8,029.00				627,924.00
30	WWTP	Meals		2,700.00					80350	-102	80350	WATER	TAXI	940	24,222.48		July		619,895.00	8,029.00				627,924.00
31	Anderson Creek	Total		173,270.00					105 stock								Aug		619,895.00	8,029.00				627,924.00
32	Gym Seismic Upgrade								70150	-105	70150	FUEL	EXPENSE	2,307.47			Sep		619,895.00	8,029.00				627,924.00
33	Past Project - School Deficiencies	Estimated							70275	-105	70275	SUPPLIES	EXP	10,542.52			Oct		619,895.00	8,029.00				627,924.00
34	Capital Project Officer	Cost 2016………….. $ 33,100.00		33,100.00					70350	-105	70350	CONTRACTS	EXP	8,491.95			Nov		619,895.00	8,027.00				627,922.00
35	Chuchimhyiip Medical Building Retrofit/Expansion	Cost 2017…………… $ 32,000.00		32,000.00					70375	-105	70375	EQUIPMENT	PURCHASED	811.42			Dec		619,895.00					619,895.00
36	FNIIP Infrastructure planning Wish List Summer planning, implement plan in Fall	Cost 2018 …………… $ 62,500.00		62,500.00					70400	-105	70400	FREIGHT	EXPENSES	251			Jan		619,894.00					619,894.00
37	Mini Mall	Cost 2019 ………….…$ 33,000.00		33,000.00					70425	-105	70425	FUEL	EXPENSE	69.54			Feb
38		Cost 2020 ………….. $ 40,300.00		40,300.00					80350	-105	80350	WATER	TAXI	20	22,493.90	166,346.10	Mar
39	Fisheries																		7,468,613.00	66,906.00
40	AFC Working Group																			7,535,519.00					B
41	Commitments to working more positive
42	Trial to be held in Ahousaht March 9
43									2/27/2016	Account	Description	Debit	Credit	Company From	Company To		NPG0 - LTS CORE-REGIS&MEMBERSHIP 1 313.A0920.NPG0.10659.A0000.82431 $2,570.40							2,570.40
44	Medical								70100	-101	REPAIR	EXPENSE	0.10	50-70100-101	40-70100-101	entered Feb 29, 2016	NG00 - IGS - BAND 1 378.A0920.NG00.10659.A0000.82431 $133,153.35							133,153.35
45	Chuchimhyiip Medical Building Retrofit/Expansion								70275	-101	SUPPLIES	EXP	802.57	50-70275-101	40-70275-101	entered Feb 29, 2016	NP00 - ELEMENTARY/SECONDARY 1 378.A0920.NP00.10659.A0000.82431 $719,833.55							719,833.55	719,833.55
46	Health $500k expansion								80350	-101	WATER	TAXI	80.00	50-80350-101	40-80350-101	entered Feb 29, 2016	NP50 - POST SECONDARY EDUCATION 1 378.A0920.NP50.10659.A0000.82431 $171,543.60							171,543.60	171,543.60
47									80400	-101	WAGES	EXPENSE	3,802.12	50-80400-101	40-80400-101	entered Feb 29, 2016	NP80 - INCOME ASSISTANCE 1 378.A0920.NP80.10659.A0000.82431 $275,775.70							275,775.70
48	Land Claim								80450	-101	EI	EXPENSE	367.76	50-80450-101	40-80450-101	entered Feb 29, 2016	NPC0 - ASSISTED LIVING - BLOCK 1 378.A0920.NPC0.10659.A0000.82431 $22,478.25							22,478.25
49	Tribunal Hearing in Tofino July 22,23,24								80500	-101	CPP	EXPENSE	25.73	50-80500-101	40-80500-101	entered Feb 29, 2016	NT40 - LEDSP-EcDev-Allocations 1 378.A0920.NT40.10659.A0000.82431 $20,177.30							20,177.30
50									80550	-101	WCB	EXPENSE	199.81	50-80550-101	40-80550-101	entered Feb 29, 2016	NTF1 - WTR&SEWER-FACILITIES O&M 1 378.A0920.NTF1.10659.A0000.82431 $46,946.00							46,946.00
51	O&M								80600	-101	PENSION	PLAN	180.04	50-80600-101	40-80600-101	entered Feb 29, 2016	NTH1 - EDU - FACILITIES O&M 1 378.A0920.NTH1.10659.A0000.82431 $3,710.25							3,710.25	3,710.25
52	New subdivision lots-culverts								70350	-102	CONTRACTS	EXP	553.03	50-70350-102	40-70350-102	entered Feb 29, 2016	NTK0 - HOUSING 1 378.A0920.NTK0.10659.A0000.82431 $69,514.70							69,514.70
53	Powerline over to lodge								80350	-102	WATER	TAXI	150.00	50-80350-102	40-80350-102	entered Feb 29, 2016	NTM0 - OTHER - CAPITAL 1 378.A0920.NTM0.10659.A0000.82431 $104,272.05							104,272.05
54									70275	-105	SUPPLIES	EXP	772.44	50-70275-105	40-70275-105	entered Feb 29, 2016	NTM1 - OTHER - FACILITIES O&M 1 378.A0920.NTM1.10659.A0000.82431 $43,191.90							43,191.90
55													6,933.60	10440	10450		NTMV - MUNICIPAL SERVICES 1 379.A096D.NTMV.10659.A0000.82431 $10,705.00							10,705.00
56									1/9/2016	Staples Phone Robert Atleo	246.21	SOC DEV	Cell phones	10-70225-101	30-70225-101		Sub-Total: $1,623,872.05							1,623,872.05	895,087.40		146.1
57									1/18/2016	Shaw Internet Jan 2016	69.44	Admin	IT/Computers	10-70225-101	40-70225-101											2015-16 extra	18,750.00
58									1/3/2016	Telus Sim Card Housing	16.8	Housing	Cell phones	10-70225-101	80-70225-101		NPG0 - LTS CORE-REGIS&MEMBERSHIP 1 313.A0920.NPG0.10659.A0000.82431 $453.60							453.60			20,550.00
59									1/3/2016	Wal Mart Monitors Alec Dick & Greg Hayes	306.88	CAPITAL	IT/Computers	10-70225-101	40-70225-101		NG00 - IGS - BAND 1 378.A0920.NG00.10659.A0000.82431 $23,497.65							23,497.65			7,577.40
60									1/9/2016	Telus Sim Card Housing	16.8	Housing	Cell phones	10-70225-101	80-70225-101		NP00 - ELEMENTARY/SECONDARY 1 378.A0920.NP00.10659.A0000.82431 $127,029.45							127,029.45	127,029.45	40960.8	40,960.80
61									9/19/2016	Home Depot Floor Cover	60.41	CAPITAL	Renovations	10-70225-101	40-70225-101		NP50 - POST SECONDARY EDUCATION 1 378.A0920.NP50.10659.A0000.82431 $30,272.40							30,272.40	30,272.40	9761.25	9,761.25
62									12/11/2016	Acer Phone for Housing Dept	166.87	HOUSING	Cell Phones	10-70225-101	80-70225-101		NP80 - INCOME ASSISTANCE 1 378.A0920.NP80.10659.A0000.82431 $48,666.30							48,666.30			94,155.15
63									12/11/2016	Memory Stick 64GB	87.34	HOUSING	Cell Phones	10-70225-101	80-70225-101		NPC0 - ASSISTED LIVING - BLOCK 1 378.A0920.NPC0.10659.A0000.82431 $3,966.75							3,966.75			7,674.60
64									12/29/2016	Yates Funeral Home	3,299.30	3229.3	SOC DEV Funerals	10-70225-101	40-70225-101		NT40 - LEDSP-EcDev-Allocations 1 378.A0920.NT40.10659.A0000.82431 $3,560.70							3,560.70			1,148.70
65									10/24/2016	Acer 7" Tabs AGM	671.21	CAPITAL	IT/Computers	10-70225-101	40-70225-101		NTH1 - EDU - FACILITIES O&M 1 378.A0920.NTH1.10659.A0000.82431 $654.75							654.75	654.75	2543.85	2,543.85
66									11/8/2016	Wal Mart Monitors Reception & Google Earth	463.68	CAPITAL	IT/Computers	10-70225-101	40-70225-101		NTK0 - HOUSING 1 378.A0920.NTK0.10659.A0000.82431 $12,267.30							12,267.30			47,658.30
67									11/18/2016	BC Backroads Software	94.09	CAPITAL	Google Earth Project	10-70225-101	40-70225-101		NTM0 - OTHER - CAPITAL 1 378.A0920.NTM0.10659.A0000.82431 $18,400.95							18,400.95			71,487.30
68									11/21/2016	Best Buy Google Earth Camera	426.03	CAPITAL	Google Earth Project	10-70225-101	40-70225-101		NTM1 - OTHER - FACILITIES O&M 1 378.A0920.NTM1.10659.A0000.82431 $7,622.10							7,622.10			56,969.25
69									11/21/2016	Home Depot Telephone Jacks	10.73	CAPITAL	Renovations	10-70225-101	40-70225-101		Sub-Total: $276,391.95							276,391.95	157,956.60	53,265.90	379,382.70
70									1/30/2016	BW Chilliwack	113.64	Medical	Travel	10-70225-101	25-70225-101
71									1/30/2016	BW Chilliwack	113.64	Soc Dev	Travel	10-70225-101	30-70225-101									1,900,264.00	1,053,044.00	53,265.90
72									12/29/2016	Yates Funeral Home	-70.00	Soc Dev		10-70225-101	30-70225-101											1,106,309.90
73									2/10/2016	Amazon Cobra VHF Radios	161.45	Admin	IT/Computers	10-70225-101	40-70225-101
74									2/25/2016	Staples Dave Jacobsen Phone	230	Capital	IT/Computers	10-70225-101	40-70225-101
75									2/25/2016	Telus SIM Card	16.8	Capital	IT/Computers	10-70225-101	40-70225-101
76											DR	CR	DR	CR	DR	CR
77												6501.32	10-70225-101			10410
78											289.85	entered Feb 29, 2016		10430	30-70225-101
79											5810.02	entered Feb 29, 2016		10440	40-70225-101
80											287.81	entered Feb 29, 2016		10480	80-70225-101
81											113.64	entered Feb 29, 2016		10425	25-70225-101
82
83								1695	6/22/2015	ASSOCIATED ENGINEERING (B.C.) 4,912.77 R2015/07/31	4,912.77			10-70350-101	40-70350-101
84								1661	6/16/2015	ASSOCIATED ENGINEERING (B.C.) 7,935.50 R2015/07/31	7,935.50			10-70350-101	40-70350-101
85								1721	6/23/2015	CANADIAN ALBERNI ENGINEERING L 3,032.96 R2015/07/3	3,032.96			10-70350-101	40-70350-101
86								2078	10/6/2015	CEDAR CREEK CASKETS 1,300.00 R2015/10/31	1,300.00			10-70350-101	30-70350-101
87								1885	8/6/2015	COMMUNICATION SERVICES 1,194.50 R2015/08/31	1,194.50			10-70350-101	40-70350-101
88								1975	9/8/2015	COMMUNICATION SERVICES 1,217.00 R2015/09/30	1,217.00			10-70350-101	40-70350-101
89								1632	5/28/2015	COMMUNICATION SERVICES 1,392.00 R2015/06/30	1,392.00			10-70350-101	40-70350-101
90								2549	2/2/2016	COMMUNICATION SERVICES 1,504.88	1,504.88			10-70350-101	40-70350-101
91								1629	5/28/2015	COMMUNICATION SERVICES 1,820.18 R2015/06/30	1,820.18			10-70350-101	40-70350-101
92								2083	10/6/2015	COMMUNICATION SERVICES 2,882.72 R2015/10/31	2,882.72			10-70350-101	40-70350-101
93								1534	5/6/2015	COMMUNICATION SERVICES 3,485.92 R2015/05/31	3,485.92			10-70350-101	40-70350-101
94								1500	5/1/2015	COMMUNICATION SERVICES 3,493.28 R2015/05/31	3,493.28			10-70350-101	40-70350-101
95								1735	6/29/2015	COMMUNICATION SERVICES 4,354.76 R2015/07/31	4,354.76			10-70350-101	40-70350-101
96								2411	1/7/2016	COMMUNICATION SERVICES 5,535.00	5,535.00			10-70350-101	40-70350-101
97								1946	8/31/2015	COMMUNICATION SERVICES 5,614.51 R2015/09/30	5,614.51			10-70350-101	40-70350-101
98								2124	10/19/2015	COMMUNICATION SERVICES 900.02 R2015/11/30	900.02			10-70350-101	40-70350-101
99								1382	4/2/2015	COMMUNICATION SERVICES 996.45 R2015/04/30	996.45			10-70350-101	40-70350-101
100								EFT		COMMUNICATION SERVICES 7485.24 (TV's)	7,485.24			10-70350-101	40-70350-101
101
102								2590	2/10/2016	N.E.D.C 21,252.75	21,252.75			10-70350-101	77-70350-101
103								2414	1/7/2016	N.E.D.C 21,252.75 C2016/01/07 Reason: None Entered	21,252.75			10-70350-101	77-70350-101
104								1671	6/16/2015	N.E.D.C 21,252.75 R2015/07/31	21,252.75			10-70350-101	77-70350-101
105								1957	9/3/2015	N.E.D.C 3,900.00 R2015/09/30	3,900.00			10-70350-101	77-70350-101
106								1956	9/3/2015	N.E.D.C 4,781.42 R2015/09/30	4,781.42			10-70350-101	77-70350-101
107								2296	11/23/2015	N.E.D.C 42,505.50 R2015/12/31	42,505.50			10-70350-101	77-70350-101
108								2069	10/2/2015	N.E.D.C 5,184.58 R2015/10/31	5,184.58			10-70350-101	77-70350-101
109								2495	1/19/2016	N.E.D.C 5,958.00	5,958.00			10-70350-101	77-70350-101
110								1626	5/26/2015	N.E.D.C 6,863.58 R2015/06/30	6,863.58			10-70350-101	77-70350-101
111								2122	10/19/2015	N.E.D.C 7,784.58 R2015/11/30	7,784.58			10-70350-101	77-70350-101
112								1921	8/20/2015	NUU-CHAH-NULTH TRIBAL COUNCIL 4,357.00 R2015/09/30	4,357.00			10-70350-101	77-70350-101
113								1934	8/20/2015	NUU-CHAH-NULTH TRIBAL COUNCIL 55,830.50 R2015/09/3	55,830.50			10-70350-101	77-70350-101
114								2368	12/15/2015	NUU-CHAH-NULTH TRIBAL COUNCIL 7,245.00	7,245.00			10-70350-101	77-70350-101
115								2489	1/19/2016	NUU-CHAH-NULTH TRIBAL COUNCIL 7,245.00	7,245.00			10-70350-101	77-70350-101
116
117								2322	11/30/2015	STAPLES BUSINESS DEPOT 1,073.08	1,073.08			10-70275-101	40-70275-101
118								1935	8/20/2015	STAPLES BUSINESS DEPOT 1,185.77 R2015/09/30	1,185.77			10-70275-101	40-70275-101
119								1413	4/9/2015	STAPLES BUSINESS DEPOT 1,438.04 R2015/04/30	1,438.04			10-70275-101	40-70275-101
120								2565	2/9/2016	STAPLES BUSINESS DEPOT 1,490.25	1,490.25			10-70275-101	40-70275-101
121								1631	5/28/2015	STAPLES BUSINESS DEPOT 2,432.14 R2015/06/30	2,432.14			10-70275-101	40-70275-101
122								1887	8/6/2015	STAPLES BUSINESS DEPOT 2,671.78 R2015/09/30	2,671.78			10-70275-101	40-70275-101
123								2423	1/7/2016	STAPLES BUSINESS DEPOT 5,540.53	5,540.53			10-70275-101	40-70275-101
124								2419	1/7/2016	STAPLES BUSINESS DEPOT 774.29	774.29			10-70275-101	40-70275-101
125								1672	6/16/2015	STAPLES BUSINESS DEPOT 954.88 R2015/07/31	954.88			10-70275-101	40-70275-101
126								1665	6/16/2015	STAPLES PREFERRED CUSTOMER PRO 439.02 C2015/08/27	439.02			10-70275-101	40-70275-101
127								1754	7/3/2015	THINK COMMUNICATIONS INC. 1,890.16 R2015/07/31	1,890.16			10-70350-101	40-70350-101
128								2418	1/7/2016	THINK COMMUNICATIONS INC. 2,650.28	2,650.28			10-70350-101	40-70350-101
129								1443	4/17/2015	THINK COMMUNICATIONS INC. 629.70 R2015/05/31	629.70			10-70350-101	40-70350-101
130
131								1883	8/6/2015	YATES FUNERAL SERVICE & CREMAT 1,971.50 R2015/08/3	1,971.50			10-70350-101	30-70350-101
132								2063	9/29/2015	YATES FUNERAL SERVICE & CREMAT 2,736.00 C2015/09/2	2,736.00			10-70350-101	30-70350-101
133								2065	9/29/2015	YATES FUNERAL SERVICE & CREMAT 2,736.00 C2015/10/1	2,736.00			10-70350-101	30-70350-101
134								2097	10/8/2015	YATES FUNERAL SERVICE & CREMAT 3,968.00 R2015/10/3	3,968.00			10-70350-101	30-70350-101
135
136										Realloc Admin Exp to Capital, Treaty, Other Dept			-291,052.74	10-70350-101	10410
137										Realloc Admin Exp to Capital, Treaty, Other Dept			-17,999.78	10-70275-101
138										Realloc Admin Exp to Capital, Treaty, Other Dept		12,711.50		30-70350-101	10430
139										Realloc Admin Exp to Capital, Treaty, Other Dept		17,999.78		40-70275-101	10440
140										Realloc Admin Exp to Capital, Treaty, Other Dept		5,170.14		40-70350-101
141										Realloc Admin Exp to Capital, Treaty, Other Dept		57,757.69		40-70350-101
142										Realloc Admin Exp to Capital, Treaty, Other Dept		215,413.41		77-70350-101	10477
143												309,052.52	-309,052.52
144										entered Feb 29, 2016


1	2017-18 Fiscal Year			April 1, 2017 to Mar 31, 2018		12	MONTHS
2	Dept#	Dept		YTD Actuals	Prorated Actual	Budget	Expected Year End Variance	Var%			Month to month spending		Notes
3	10	ADMIN		$1,854,755.50	$1,854,755.50	$1,725,417.48	-$129,338.02	-7.0%	175k Taaqwiiaak; 120k Water Filtration costs; $100k Audit + $185k DISC	-7.50%	$860,508.68
4	25	HEALTH		$1,274,803.88	$1,274,803.88	$1,246,683.96	-$28,119.92	-2.2%		-2.26%	$953,493.17		$75,000 added in FNHA funding
5	30	SOCDEV		$1,225,590.77	$1,225,590.77	$1,204,604.33	-$20,986.44	-1.7%		-1.74%	$284,345.66
6	40	CAPITAL		$1,601,509.45	$1,601,509.45	$1,599,494.00	-$2,015.45	-0.1%		-0.13%	$1,251,178.24	Prorated Actual	$705,000 added in WWTP DAR funding
7	50	OPSMAINT		$1,058,457.38	$1,058,457.38	$1,030,599.86	-$27,857.52	-2.6%		-2.70%	$621,682.23	$0.00	$175,000 added WTP funding
8	60	COMMUNITY		$464,169.93	$464,169.93	$522,393.60	$58,223.67	12.5%		11.15%	$92,500.83
9	70	FORESTRY		$4,479.55	$4,479.55		-$4,479.55				$4,330.06
10	75	FISHERIES		$278,154.55	$278,154.55	$279,273.60	$1,119.05	0.4%		0.40%	$130,564.96		$75,000 home use fish funding
11	77	ECONOMIC			$0.00	$291,548.00	$291,548.00			100.00%	-$12,721.43
12	80	HOUSING		$750,932.67	$750,932.67	$603,583.55	-$147,349.12	-19.6%	CMHC renovation funding pending	-24.41%	$356,170.11
13	90	TREATY		$42.00	$42.00	$15,000.00	$14,958.00	35614.3%		99.72%	$36.00
14	Grand Total			$8,512,895.68	$8,512,895.68	$8,518,598.38	$5,702.70		Year end capital and operational invoices caught up in March		$3,774,632.34
15				$2,288,420.69		$709,883.20
16	YTD Actuals = Year to Date Actuals = Actual expenses spent year to date										CONTROL #: Does this agree to cell L21 & L22 on spreadsheet
17	Prorated Actual = Year to Date totals divided by number of months so far in the year multiplied by 12 = an estimate of what we will spend for the entire year										8,512,895.68
18	MAP Budget are the budget numbers that Ahousaht needs to come in at or below.										291,548.00
19	Variance is the difference between MAP Budget and Prorated Actual amount; negative amounts are bad										Print to PDF, save, then send to INAC quarterly
20
21				2014-15	2015-16	2016-17	2017-18
22	Net Debt projected to end of year			10,135,743	9,715,815	9,313,285	8,927,432
23
24	BUDGET SUMMARY					Black =Good; Red = Bad
25				YTD Actuals	Original Budget (Funding Additions not included)	Prorated Annual Variance					ALL			rbullock@ahousaht.ca
26	10	ADMIN	Advertising		$2,262.60	$2,262.60					10	ADMIN	Council, Rob B
27			Audit fees		$35,317.00	$35,317.00					25	HEALTH	Dave	julia.atelo@ahousaht.ca
28			Benefits	$162,917.70	$115,274.87	-$210,560.53					30	SOCDEV	Robert	robert.atleo@ahousaht.ca
29			Capital	$10,166.57	$16,998.43	-$3,334.71					40	CAPITAL	Alec, Rob B	alec.dick@ahousaht.ca
30			Contractual services	$642,969.19	$219,632.15	-$1,066,306.23					50	OPSMAINT	Alec	alec.dick@ahousaht.ca
31			Honoraria	$6,100.00		-$12,200.00					60	COMMUNITY	Dave, Robert	julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca
32			Insurance	$106,751.44	$ -	-$213,502.88					70	FORESTRY
33			Legal fees	$26,947.15	$62,836.25	$8,941.95					75	FISHERIES	Luke	luke.swan@ahousaht.ca
34			Office supplies	$67,000.91	$ -	-$134,001.82					77	ECONOMIC	Council, Rob
35			Other	$192,685.06	$112,318.25	-$273,051.87					80	HOUSING	Patti	caroline.atleo@ahousaht.ca
36			Postage & frieght	$2,115.74	$23,023.29	$18,791.81					90	TREATY
37			Repairs & maintenance	$527.93	$79,340.58	$78,284.72
38			Salaries	$473,672.84	$455,254.92	-$492,090.76
39			Telecommunications	$74,345.23	$20,396.21	-$128,294.25
40			Training	$3,136.66	$8,952.35	$2,679.03
41			Travel	$85,419.08	$12,863.45	-$157,974.71
42			Membership fees		$947.13	$947.13
43		ADMIN Total		$1,854,755.50	$1,165,417.48	-$2,544,093.52
44	25	HEALTH	Advertising		$ -
45			Audit fees		$ -
46			Capital	$1,726.55	$ -	-$3,453.10
47			Contractual services	$428,955.54		-$857,911.08
48			Honoraria	$1,250.00	$ -	-$2,500.00
49			Insurance		$ -
50			Legal fees		$ -
51			Office supplies	$92,352.46	$31,080.00	-$153,624.92
52			Other	$68,173.13	$5,796.00	-$130,550.26
53			Postage & frieght	$505.00	$ -	-$1,010.00
54			Repairs & maintenance	$2,896.75	$31,500.00	$25,706.50
55			Salaries	$414,900.61	$361,596.00	-$468,205.22
56			Telecommunications		$12,999.96	$12,999.96
57			Training		$ -
58			Travel	$264,043.84	$41,004.00	-$487,083.68
59			Healthy Baby		$6,000.00	$6,000.00
60			(CW) Workshops		$6,500.00	$6,500.00
61			Youth Activities		$20,799.96	$20,799.96
62			Community Workshops		$23,000.04	$23,000.04
63		HEALTH Total		$1,274,803.88	$540,275.96	-$2,009,331.80
64	30	SOCDEV	Advertising		$ -
65			Audit fees		$ -
66			Benefits	$6,959.50		-$13,919.00
67			Capital		$ -
68			Contractual services	$22,020.55		-$44,041.10
69			Honoraria		$ -
70			Legal fees		$ -
71			Office supplies	$8,749.66	$ -	-$17,499.32
72			Other	$864,762.62	$920,540.73	-$808,984.51
73			Postage & frieght	$120.00		-$240.00
74			Repairs & maintenance	$9,594.97		-$19,189.94
75			Salaries	$286,978.08	$108,787.44	-$465,168.72
76			Telecommunications		$ -
77			Training		$ -
78			Travel	$26,405.39	$ -	-$52,810.78
79			Materials & supplies		$ -
80			Special Needs		$27,547.92	$27,547.92
81			Gaurdian Financial Assistance		$ -
82			Admin Fee Office Supplies, Rent		$11,100.00	$11,100.00
83			Assisted Living		$38,226.24	$38,226.24
84			Disability		$8,200.00	$8,200.00
85		SOCDEV Total		$1,225,590.77	$1,114,402.33	-$1,336,779.21
86	40	CAPITAL	Advertising		$ -
87			Audit fees		$ -
88			Benefits		$ -
89			Capital		$ -
90			Contractual services	$1,300,647.53	$427,494.00	-$2,173,801.06
91			Honoraria		$ -
92			Insurance		$ -
93			Legal fees		$ -
94			Office supplies	$72,715.83	$ -	-$145,431.66
95			Other	$43,771.62		-$87,543.24
96			Postage & frieght	$7,480.00	$ -	-$14,960.00
97			Repairs & maintenance	$1,718.91	$50,000.04	$46,562.22
98			Salaries	$27,255.04	$ -	-$54,510.08
99			Telecommunications		$ -
100			Training	$1,377.60	$ -	-$2,755.20
101			Travel	$146,542.92	$3,999.96	-$289,085.88
102			Materials & supplies		$18,000.00	$18,000.00
103			Rentals		$ -
104			Membership fees		$ -
105		CAPITAL Total		$1,601,509.45	$499,494.00	-$2,703,524.90
106	50	OPSMAINT	Advertising		$ -
107			Audit fees		$ -
108			Benefits	$7,342.08	$41,999.98	$27,315.82
109			Capital	$9,726.03	$ -	-$19,452.06
110			Contractual services	$250,237.60	$ -	-$500,475.20
111			Honoraria		$ -
112			Insurance	$2,016.00	$ -	-$4,032.00
113			Legal fees		$ -
114			Office supplies	$150,980.36	$ -	-$301,960.72
115			Other	$133,990.61	$14,400.00	-$253,581.22
116			Postage & frieght	$33,931.72	$ -	-$67,863.44
117			Repairs & maintenance	$33,823.55	$54,000.00	-$13,647.10
118			Salaries	$393,340.35	$209,999.88	-$576,680.82
119			Telecommunications	$186.63	$3,600.00	$3,226.74
120			Training	$1,460.88	$3,000.00	$78.24
121			Travel	$41,421.57	$ -	-$82,843.14
122			Materials & supplies		$ -
123			Rentals		$3,600.00	$3,600.00
124			Membership fees		$ -
125		OPSMAINT Total		$1,058,457.38	$330,599.86	-$1,786,314.90
126	60	COMMUNITY	Advertising		$ -
127			Audit fees		$ -
128			Benefits	$8,780.90	$73,905.60	$56,343.80
129			Capital		$ -
130			Contractual services	$25,680.00	$ -	-$51,360.00
131			Honoraria	$34,525.00	$ -	-$69,050.00
132			Insurance		$ -
133			Legal fees		$ -
134			Office supplies	$12,467.13	$ -	-$24,934.26
135			Other	$82,921.29	$39,240.00	-$126,602.58
136			Postage & frieght	$40.00	$ -	-$80.00
137			Repairs & maintenance		$3,624.00	$3,624.00
138			Salaries	$158,446.10	$369,528.00	$52,635.80
139			Telecommunications	$5,561.25	$ -	-$11,122.50
140			Training		$5,544.00	$5,544.00
141			Travel	$135,748.26	$5,112.00	-$266,384.52
142			Materials & supplies		$9,492.00	$9,492.00
143			Rentals		$15,948.00	$15,948.00
144			Membership fees		$ -
145		COMMUNITY Total		$464,169.93	$522,393.60	-$405,946.26
146	70		Contractual services	$3,677.78		-$7,355.56
147			Salaries	$281.77		-$563.54
148			Travel	$520.00		-$1,040.00
149		0 Total		$4,479.55		-$8,959.10
150	75	FISHERIES	Audit fees		$2,500.00	$2,500.00
151			Benefits	$2,384.16	$9,503.16	$4,734.84
152			Capital	$756.00	$ -	-$1,512.00
153			Contractual services	$22,724.34	$ -	-$45,448.68
154			Honoraria		$ -
155			Insurance	$6,813.27	$7,700.00	-$5,926.54
156			Legal fees		$ -
157			Office supplies	$26,091.34	$ -	-$52,182.68
158			Other	$4,265.75	$24,000.00	$15,468.50
159			Postage & frieght	$3,355.00	$ -	-$6,710.00
160			Repairs & maintenance	$58,231.51	$4,400.00	-$112,063.02
161			Salaries	$136,398.02	$105,310.44	-$167,485.60
162			Telecommunications	$599.68		-$1,199.36
163			Training		$3,000.00	$3,000.00
164			Travel	$16,535.48	$24,000.00	-$9,070.96
165			Materials & supplies		$3,000.00	$3,000.00
166			Rentals		$ -
167			Membership fees		$ -
168			Admin Fee		$9,120.00	$9,120.00
169			Telecommunications & Utilities		$6,240.00	$6,240.00
170		FISHERIES Total		$278,154.55	$198,773.60	-$357,535.50
171	77	ECONOMIC	Advertising		$6,000.00	$6,000.00
172			Audit fees		$ -
173			Benefits		$29,754.00	$29,754.00
174			Capital		$10,000.00	$10,000.00
175			Contractual services		$7,500.00	$7,500.00
176			Honoraria		$ -
177			Insurance		$ -
178			Legal fees		$ -
179			Office supplies		$ -
180			Other		$50,000.00	$50,000.00
181			Postage & frieght		$ -
182			Repairs & maintenance		$22,500.00	$22,500.00
183			Salaries		$148,794.00	$148,794.00
184			Telecommunications		$3,000.00	$3,000.00
185			Training		$ -
186			Travel		$ -
187			Materials & supplies		$14,000.00	$14,000.00
188			Rentals		$ -
189			Membership fees		$ -
190		ECONOMIC Total			$291,548.00	$291,548.00
191	80	HOUSING	Advertising		$ -
192			Audit fees		$ -
193			Benefits	$4,743.48	$15,301.26	$5,814.30
194			Capital	$32,605.44	$ -	-$65,210.88
195			Contractual services	$44,059.95	$13,010.83	-$75,109.07
196			Honoraria	$500.00	$ -	-$1,000.00
197			Insurance	$1,131.00	$36,707.44	$34,445.44
198			Legal fees		$ -
199			Office supplies	$1,997.15	$ -	-$3,994.30
200			Other	$25,108.01	$13,575.55	-$36,640.47
201			Postage & frieght	$21,989.30	$2,091.26	-$41,887.34
202			Repairs & maintenance	$227,331.35	$57,775.90	-$396,886.80
203			Salaries	$373,482.98	$66,530.61	-$680,435.35
204			Telecommunications	$599.68	$124.85	-$1,074.51
205			Training		$ -
206			Travel	$17,384.33	$1,324.90	-$33,443.76
207			Materials & supplies		$2,454.96	$2,454.96
208			Membership fees		$ -
209			Mortgage		$127,186.00	$127,186.00
210		HOUSING Total		$750,932.67	$336,083.55	-$1,165,781.79
211	90	TREATY	Advertising		$ -
212			Audit fees		$ -
213			Benefits		$ -
214			Capital		$ -
215			Contractual services		$1,800.00	$1,800.00
216			Honoraria		$3,000.00	$3,000.00
217			Insurance		$ -
218			Legal fees		$9,000.00	$9,000.00
219			Office supplies		$ -
220			Other	$42.00	$1,200.00	$1,116.00
221			Postage & frieght		$ -
222			Repairs & maintenance		$ -
223			Salaries		$ -
224			Telecommunications		$ -
225			Training		$ -
226			Travel		$ -
227			Materials & supplies		$ -
228			Rentals		$ -
229			Membership fees		$ -
230		TREATY Total		$42.00	$15,000.00
231	Grand Total			$8,512,895.68	$5,013,988.38


1	2017-18 Fiscal Year			April 1, 2017 to Feb 28, 2018		11	MONTHS
2	Dept#	Dept		YTD Actuals	Prorated Actual	Budget	Expected Year End Variance			Month to month spending		Notes
3	10	ADMIN		$1,692,790.71	$1,846,680.77	$1,540,417.48	-$306,263.29	175k Taaqwiiaak; 120k Water Filtration costs; $100k Audit	-19.88%	$698,543.89
4	25	HEALTH		$1,098,954.94	$1,198,859.93	$1,191,510.46	-$7,349.47	less than 1% variance	-0.62%	$777,644.23		$75,000 added in FNHA funding
5	30	SOCDEV		$1,116,174.86	$1,217,645.30	$1,197,087.50	-$20,557.81	less than 2% variance	-1.72%	$174,929.75
6	40	CAPITAL		$1,454,904.63	$1,587,168.69	$1,799,494.00	$212,325.31		11.80%	$1,104,573.42	Prorated Actual	$705,000 added in WWTP DAR funding
7	50	OPSMAINT		$947,547.67	$1,033,688.37	$1,030,599.86	-$3,088.51	less than 1% variance	-0.30%	$510,772.52	$0.00	$175,000 added WTP funding
8	60	COMMUNITY		$438,247.24	$478,087.90	$522,393.60	$44,305.70		8.48%	$66,578.14
9	70	FORESTRY		$20.00	$21.82		-$21.82			-$129.49
10	75	FISHERIES		$263,595.74	$287,558.99	$286,773.60	-$785.39	less than 1% variance	-0.27%	$116,006.15		$75,000 home use fish funding
11	77	ECONOMIC			$0.00	$291,548.00	$291,548.00		100.00%	-$12,721.43
12	80	HOUSING		$687,538.78	$750,042.31	$623,583.55	-$126,458.76	CMHC renovation funding pending	-20.28%	$292,776.22
13	90	TREATY		$30.00	$32.73	$15,000.00	$14,967.27		99.78%	$24.00
14	Grand Total			$7,699,804.57	$8,399,786.80	$8,498,408.05	$98,621.24			$2,961,541.23
15				$1,475,329.58		$708,200.67
16	YTD Actuals = Year to Date Actuals = Actual expenses spent year to date									CONTROL #: Does this agree to cell L21 & L22 on spreadsheet
17	Prorated Actual = Year to Date totals divided by number of months so far in the year multiplied by 12 = an estimate of what we will spend for the entire year									7,699,804.57
18	MAP Budget are the budget numbers that Ahousaht needs to come in at or below.									291,548.00
19	Variance is the difference between MAP Budget and Prorated Actual amount; negative amounts are bad									Print to PDF, save, then send to INAC quarterly
20
21				2014-15	2015-16	2016-17	2017-18
22	Net Debt projected to end of year			10,135,743	9,715,815	9,313,285	8,927,432
23
24	BUDGET SUMMARY					Black =Good; Red = Bad
25				YTD Actuals	Original Budget (Funding Additions not included)	Prorated Annual Variance				ALL			rbullock@ahousaht.ca
26	10	ADMIN	Advertising		$2,262.60	$2,262.60				10	ADMIN	Council, Rob B
27			Audit fees		$35,317.00	$35,317.00				25	HEALTH	Dave	julia.atelo@ahousaht.ca
28			Benefits	$153,759.29	$115,274.87	-$192,243.71				30	SOCDEV	Robert	robert.atleo@ahousaht.ca
29			Capital	$10,166.57	$16,998.43	-$3,334.71				40	CAPITAL	Alec, Rob B	alec.dick@ahousaht.ca
30			Contractual services	$631,792.43	$219,632.15	-$1,043,952.71				50	OPSMAINT	Alec	alec.dick@ahousaht.ca
31			Honoraria	$4,000.00		-$8,000.00				60	COMMUNITY	Dave, Robert	julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca
32			Insurance	$89,546.24	$ -	-$179,092.48				70	FORESTRY
33			Legal fees	$26,947.15	$62,836.25	$8,941.95				75	FISHERIES	Luke	luke.swan@ahousaht.ca
34			Office supplies	$35,218.93	$ -	-$70,437.86				77	ECONOMIC	Council, Rob
35			Other	$178,215.43	$112,318.25	-$244,112.61				80	HOUSING	Patti	caroline.atleo@ahousaht.ca
36			Postage & frieght	$1,085.00	$23,023.29	$20,853.29				90	TREATY
37			Repairs & maintenance	$527.93	$79,340.58	$78,284.72
38			Salaries	$420,272.84	$455,254.92	-$385,290.76
39			Telecommunications	$64,063.48	$20,396.21	-$107,730.75
40			Training	$3,136.66	$8,952.35	$2,679.03
41			Travel	$74,058.76	$12,863.45	-$135,254.07
42			Membership fees		$947.13	$947.13
43		ADMIN Total		$1,692,790.71	$1,165,417.48	-$2,220,163.94
44	25	HEALTH	Advertising		$ -
45			Audit fees		$ -
46			Capital	$1,330.87	$ -	-$2,661.74
47			Contractual services	$337,927.44		-$675,854.88
48			Honoraria	$1,250.00	$ -	-$2,500.00
49			Insurance		$ -
50			Legal fees		$ -
51			Office supplies	$83,200.33	$31,080.00	-$135,320.66
52			Other	$64,033.16	$5,796.00	-$122,270.32
53			Postage & frieght	$445.00	$ -	-$890.00
54			Repairs & maintenance	$2,588.65	$31,500.00	$26,322.70
55			Salaries	$383,432.21	$361,596.00	-$405,268.42
56			Telecommunications		$12,999.96	$12,999.96
57			Training		$ -
58			Travel	$224,747.28	$41,004.00	-$408,490.56
59			Healthy Baby		$6,000.00	$6,000.00
60			(CW) Workshops		$6,500.00	$6,500.00
61			Youth Activities		$20,799.96	$20,799.96
62			Community Workshops		$23,000.04	$23,000.04
63		HEALTH Total		$1,098,954.94	$540,275.96	-$1,657,633.92
64	30	SOCDEV	Advertising		$ -
65			Audit fees		$ -
66			Benefits	$6,624.72		-$13,249.44
67			Capital		$ -
68			Contractual services	$22,020.55		-$44,041.10
69			Honoraria		$ -
70			Legal fees		$ -
71			Office supplies	$8,633.27	$ -	-$17,266.54
72			Other	$779,926.82	$920,540.73	-$639,312.91
73			Postage & frieght	$120.00		-$240.00
74			Repairs & maintenance	$8,033.37		-$16,066.74
75			Salaries	$264,689.29	$108,787.44	-$420,591.14
76			Telecommunications		$ -
77			Training		$ -
78			Travel	$26,126.84	$ -	-$52,253.68
79			Materials & supplies		$ -
80			Special Needs		$27,547.92	$27,547.92
81			Gaurdian Financial Assistance		$ -
82			Admin Fee Office Supplies, Rent		$11,100.00	$11,100.00
83			Assisted Living		$38,226.24	$38,226.24
84			Disability		$8,200.00	$8,200.00
85		SOCDEV Total		$1,116,174.86	$1,114,402.33	-$1,117,947.39
86	40	CAPITAL	Advertising		$ -
87			Audit fees		$ -
88			Benefits		$ -
89			Capital		$ -
90			Contractual services	$1,166,317.16	$427,494.00	-$1,905,140.32
91			Honoraria		$ -
92			Insurance		$ -
93			Legal fees		$ -
94			Office supplies	$72,715.83	$ -	-$145,431.66
95			Other	$40,726.68		-$81,453.36
96			Postage & frieght	$7,235.00	$ -	-$14,470.00
97			Repairs & maintenance	$1,718.91	$50,000.04	$46,562.22
98			Salaries	$25,449.53	$ -	-$50,899.06
99			Telecommunications		$ -
100			Training	$1,377.60	$ -	-$2,755.20
101			Travel	$139,363.92	$3,999.96	-$274,727.88
102			Materials & supplies		$18,000.00	$18,000.00
103			Rentals		$ -
104			Membership fees		$ -
105		CAPITAL Total		$1,454,904.63	$499,494.00	-$2,410,315.26
106	50	OPSMAINT	Advertising		$ -
107			Audit fees		$ -
108			Benefits	$6,041.92	$41,999.98	$29,916.14
109			Capital	$7,966.19	$ -	-$15,932.38
110			Contractual services	$232,641.47	$ -	-$465,282.94
111			Honoraria		$ -
112			Insurance	$2,016.00	$ -	-$4,032.00
113			Legal fees		$ -
114			Office supplies	$147,499.77	$ -	-$294,999.54
115			Other	$131,316.32	$14,400.00	-$248,232.64
116			Postage & frieght	$17,502.47	$ -	-$35,004.94
117			Repairs & maintenance	$33,094.43	$54,000.00	-$12,188.86
118			Salaries	$330,507.77	$209,999.88	-$451,015.66
119			Telecommunications	$186.63	$3,600.00	$3,226.74
120			Training	$1,460.88	$3,000.00	$78.24
121			Travel	$37,313.82	$ -	-$74,627.64
122			Materials & supplies		$ -
123			Rentals		$3,600.00	$3,600.00
124			Membership fees		$ -
125		OPSMAINT Total		$947,547.67	$330,599.86	-$1,564,495.48
126	60	COMMUNITY	Advertising		$ -
127			Audit fees		$ -
128			Benefits	$8,096.97	$73,905.60	$57,711.66
129			Capital		$ -
130			Contractual services	$25,680.00	$ -	-$51,360.00
131			Honoraria	$33,425.00	$ -	-$66,850.00
132			Insurance		$ -
133			Legal fees		$ -
134			Office supplies	$12,467.13	$ -	-$24,934.26
135			Other	$81,343.59	$39,240.00	-$123,447.18
136			Postage & frieght	$40.00	$ -	-$80.00
137			Repairs & maintenance		$3,624.00	$3,624.00
138			Salaries	$147,756.53	$369,528.00	$74,014.94
139			Telecommunications	$5,336.25	$ -	-$10,672.50
140			Training		$5,544.00	$5,544.00
141			Travel	$124,101.77	$5,112.00	-$243,091.54
142			Materials & supplies		$9,492.00	$9,492.00
143			Rentals		$15,948.00	$15,948.00
144			Membership fees		$ -
145		COMMUNITY Total		$438,247.24	$522,393.60	-$354,100.88
146	70		Travel	$20.00		-$40.00
147		0 Total		$20.00		-$40.00
148	75	FISHERIES	Audit fees		$2,500.00	$2,500.00
149			Benefits	$2,384.16	$9,503.16	$4,734.84
150			Capital	$756.00	$ -	-$1,512.00
151			Contractual services	$22,724.34	$ -	-$45,448.68
152			Honoraria		$ -
153			Insurance	$6,813.27	$7,700.00	-$5,926.54
154			Legal fees		$ -
155			Office supplies	$24,586.59	$ -	-$49,173.18
156			Other	$4,199.83	$24,000.00	$15,600.34
157			Postage & frieght	$3,355.00	$ -	-$6,710.00
158			Repairs & maintenance	$55,449.74	$4,400.00	-$106,499.48
159			Salaries	$127,301.82	$105,310.44	-$149,293.20
160			Telecommunications	$599.68		-$1,199.36
161			Training		$3,000.00	$3,000.00
162			Travel	$15,425.31	$24,000.00	-$6,850.62
163			Materials & supplies		$3,000.00	$3,000.00
164			Rentals		$ -
165			Membership fees		$ -
166			Admin Fee		$9,120.00	$9,120.00
167			Telecommunications & Utilities		$6,240.00	$6,240.00
168		FISHERIES Total		$263,595.74	$198,773.60	-$328,417.88
169	77	ECONOMIC	Advertising		$6,000.00	$6,000.00
170			Audit fees		$ -
171			Benefits		$29,754.00	$29,754.00
172			Capital		$10,000.00	$10,000.00
173			Contractual services		$7,500.00	$7,500.00
174			Honoraria		$ -
175			Insurance		$ -
176			Legal fees		$ -
177			Office supplies		$ -
178			Other		$50,000.00	$50,000.00
179			Postage & frieght		$ -
180			Repairs & maintenance		$22,500.00	$22,500.00
181			Salaries		$148,794.00	$148,794.00
182			Telecommunications		$3,000.00	$3,000.00
183			Training		$ -
184			Travel		$ -
185			Materials & supplies		$14,000.00	$14,000.00
186			Rentals		$ -
187			Membership fees		$ -
188		ECONOMIC Total			$291,548.00	$291,548.00
189	80	HOUSING	Advertising		$ -
190			Audit fees		$ -
191			Benefits	$4,274.73	$15,301.26	$6,751.80
192			Capital	$29,448.24	$ -	-$58,896.48
193			Contractual services	$44,059.95	$13,010.83	-$75,109.07
194			Honoraria	$300.00	$ -	-$600.00
195			Insurance	$1,131.00	$36,707.44	$34,445.44
196			Legal fees		$ -
197			Office supplies	$1,997.15	$ -	-$3,994.30
198			Other	$23,979.60	$13,575.55	-$34,383.65
199			Postage & frieght	$18,099.30	$2,091.26	-$34,107.34
200			Repairs & maintenance	$214,345.70	$57,775.90	-$370,915.50
201			Salaries	$332,309.10	$66,530.61	-$598,087.59
202			Telecommunications	$599.68	$124.85	-$1,074.51
203			Training		$ -
204			Travel	$16,994.33	$1,324.90	-$32,663.76
205			Materials & supplies		$2,454.96	$2,454.96
206			Membership fees		$ -
207			Mortgage		$127,186.00	$127,186.00
208		HOUSING Total		$687,538.78	$336,083.55	-$1,038,994.01
209	90	TREATY	Advertising		$ -
210			Audit fees		$ -
211			Benefits		$ -
212			Capital		$ -
213			Contractual services		$1,800.00	$1,800.00
214			Honoraria		$3,000.00	$3,000.00
215			Insurance		$ -
216			Legal fees		$9,000.00	$9,000.00
217			Office supplies		$ -
218			Other	$30.00	$1,200.00	$1,140.00
219			Postage & frieght		$ -
220			Repairs & maintenance		$ -
221			Salaries		$ -
222			Telecommunications		$ -
223			Training		$ -
224			Travel		$ -
225			Materials & supplies		$ -
226			Rentals		$ -
227			Membership fees		$ -
228		TREATY Total		$30.00	$15,000.00	$14,940.00
229	Grand Total			$7,699,804.57	$5,013,988.38	-$10,385,620.76


1	2017-18 Fiscal Year			April 1, 2017 to Jan 31, 2018		10	MONTHS
2	Dept#	Dept		YTD Actuals	Prorated Actual	Budget	Expected Year End Variance		Month to month spending		Notes
3	10	ADMIN		$1,611,684.39	$1,934,021.27	$1,540,417.48	-$393,603.79	175k Taaqwiiaak; 120k Water Filtration costs; $100k Audit	$617,437.57
4	25	HEALTH		$847,435.32	$1,016,922.38	$1,236,336.96	$219,414.58		$526,124.61		$75,000 added in FNHA funding
5	30	SOCDEV		$1,013,108.78	$1,215,730.54	$1,189,570.66	-$26,159.87		$71,863.67
6	40	CAPITAL		$1,396,008.67	$1,675,210.40	$1,799,494.00	$124,283.60		$1,045,677.46	Prorated Actual	$705,000 added in WWTP DAR funding
7	50	OPSMAINT		$890,914.74	$1,069,097.69	$1,030,599.86	-$38,497.83		$454,139.59	$0.00	$175,000 added WTP funding
8	60	COMMUNITY		$409,274.80	$491,129.76	$522,393.60	$31,263.84		$37,605.70
9	70	FORESTRY		$4,459.55	$5,351.46		-$5,351.46		$4,310.06
10	75	FISHERIES		$229,197.62	$275,037.14	$286,773.60	$11,736.46		$81,608.03		$75,000 home use fish funding
11	77	ECONOMIC			$0.00	$291,548.00	$291,548.00		-$12,721.43
12	80	HOUSING		$623,137.57	$747,765.08	$623,583.55	-$124,181.53	CMHC renovation funding pending	$228,375.01
13	90	TREATY		$24.00	$28.80	$15,000.00	$14,971.20		$18.00
14	Grand Total			$7,025,245.44	$8,430,294.53	$8,535,717.71	$105,423.19		$2,286,982.10
15				$800,770.45		$711,309.81
16	YTD Actuals = Year to Date Actuals = Actual expenses spent year to date								CONTROL #: Does this agree to cell L21 & L22 on spreadsheet
17	Prorated Actual = Year to Date totals divided by number of months so far in the year multiplied by 12 = an estimate of what we will spend for the entire year								7,025,245.44
18	MAP Budget are the budget numbers that Ahousaht needs to come in at or below.								291,548.00
19	Variance is the difference between MAP Budget and Prorated Actual amount; negative amounts are bad								Print to PDF, save, then send to INAC quarterly
20
21				2014-15	2015-16	2016-17	2017-18
22	Net Debt projected to end of year			10,135,743	9,715,815	9,313,285	8,927,432
23
24	BUDGET SUMMARY					Black =Good; Red = Bad
25				YTD Actuals	Original Budget (Funding Additions not included)	Prorated Annual Variance			ALL			rbullock@ahousaht.ca
26	10	ADMIN	Advertising		$2,262.60	$2,262.60			10	ADMIN	Council, Rob B
27			Audit fees		$35,317.00	$35,317.00			25	HEALTH	Dave	julia.atelo@ahousaht.ca
28			Benefits	$135,095.62	$115,274.87	-$154,916.37			30	SOCDEV	Robert	robert.atleo@ahousaht.ca
29			Capital	$9,296.94	$16,998.43	-$1,595.45			40	CAPITAL	Alec, Rob B	alec.dick@ahousaht.ca
30			Contractual services	$629,673.81	$219,632.15	-$1,039,715.47			50	OPSMAINT	Alec	alec.dick@ahousaht.ca
31			Honoraria	$4,000.00		-$8,000.00			60	COMMUNITY	Dave, Robert	julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca
32			Insurance	$72,341.04	$ -	-$144,682.08			70	FORESTRY
33			Legal fees	$26,947.15	$62,836.25	$8,941.95			75	FISHERIES	Luke	luke.swan@ahousaht.ca
34			Office supplies	$31,339.58	$ -	-$62,679.16			77	ECONOMIC	Council, Rob
35			Other	$171,532.28	$112,318.25	-$230,746.31			80	HOUSING	Patti	caroline.atleo@ahousaht.ca
36			Postage & frieght	$935.00	$23,023.29	$21,153.29			90	TREATY
37			Repairs & maintenance	$527.93	$79,340.58	$78,284.72
38			Salaries	$384,723.90	$455,254.92	-$314,192.88
39			Telecommunications	$64,063.48	$20,396.21	-$107,730.75
40			Training	$3,136.66	$8,952.35	$2,679.03
41			Travel	$78,071.00	$12,863.45	-$143,278.55
42			Membership fees		$947.13	$947.13
43		ADMIN Total		$1,611,684.39	$1,165,417.48	-$2,057,951.30
44	25	HEALTH	Advertising		$ -
45			Audit fees		$ -
46			Capital	$1,048.82	$ -	-$2,097.64
47			Contractual services	$198,880.14		-$397,760.28
48			Honoraria	$1,250.00	$ -	-$2,500.00
49			Insurance		$ -
50			Legal fees		$ -
51			Office supplies	$75,488.23	$31,080.00	-$119,896.46
52			Other	$53,876.91	$5,796.00	-$101,957.82
53			Postage & frieght	$415.00	$ -	-$830.00
54			Repairs & maintenance	$2,386.00	$31,500.00	$26,728.00
55			Salaries	$351,857.20	$361,596.00	-$342,118.40
56			Telecommunications		$12,999.96	$12,999.96
57			Training		$ -
58			Travel	$162,233.02	$41,004.00	-$283,462.04
59			Healthy Baby		$6,000.00	$6,000.00
60			(CW) Workshops		$6,500.00	$6,500.00
61			Youth Activities		$20,799.96	$20,799.96
62			Community Workshops		$23,000.04	$23,000.04
63		HEALTH Total		$847,435.32	$540,275.96	-$1,154,594.68
64	30	SOCDEV	Advertising		$ -
65			Audit fees		$ -
66			Benefits	$6,065.60		-$12,131.20
67			Capital		$ -
68			Contractual services	$21,811.55		-$43,623.10
69			Honoraria		$ -
70			Legal fees		$ -
71			Office supplies	$8,633.27	$ -	-$17,266.54
72			Other	$699,226.32	$920,540.73	-$477,911.91
73			Postage & frieght	$120.00		-$240.00
74			Repairs & maintenance	$7,192.21		-$14,384.42
75			Salaries	$244,137.99	$108,787.44	-$379,488.54
76			Telecommunications		$ -
77			Training		$ -
78			Travel	$25,921.84	$ -	-$51,843.68
79			Materials & supplies		$ -
80			Special Needs		$27,547.92	$27,547.92
81			Gaurdian Financial Assistance		$ -
82			Admin Fee Office Supplies, Rent		$11,100.00	$11,100.00
83			Assisted Living		$38,226.24	$38,226.24
84			Disability		$8,200.00	$8,200.00
85		SOCDEV Total		$1,013,108.78	$1,114,402.33	-$911,815.23
86	40	CAPITAL	Advertising		$ -
87			Audit fees		$ -
88			Benefits		$ -
89			Capital		$ -
90			Contractual services	$1,122,872.00	$427,494.00	-$1,818,250.00
91			Honoraria		$ -
92			Insurance		$ -
93			Legal fees		$ -
94			Office supplies	$72,715.83	$ -	-$145,431.66
95			Other	$40,653.18		-$81,306.36
96			Postage & frieght	$7,235.00	$ -	-$14,470.00
97			Repairs & maintenance	$1,718.91	$50,000.04	$46,562.22
98			Salaries	$20,162.23	$ -	-$40,324.46
99			Telecommunications		$ -
100			Training	$1,377.60	$ -	-$2,755.20
101			Travel	$129,273.92	$3,999.96	-$254,547.88
102			Materials & supplies		$18,000.00	$18,000.00
103			Rentals		$ -
104			Membership fees		$ -
105		CAPITAL Total		$1,396,008.67	$499,494.00	-$2,292,523.34
106	50	OPSMAINT	Advertising		$ -
107			Audit fees		$ -
108			Benefits	$5,498.85	$41,999.98	$31,002.28
109			Capital	$7,966.19	$ -	-$15,932.38
110			Contractual services	$224,166.27	$ -	-$448,332.54
111			Honoraria		$ -
112			Insurance	$2,016.00	$ -	-$4,032.00
113			Legal fees		$ -
114			Office supplies	$140,877.67	$ -	-$281,755.34
115			Other	$124,832.33	$14,400.00	-$235,264.66
116			Postage & frieght	$17,432.47	$ -	-$34,864.94
117			Repairs & maintenance	$32,064.63	$54,000.00	-$10,129.26
118			Salaries	$301,411.23	$209,999.88	-$392,822.58
119			Telecommunications	$186.63	$3,600.00	$3,226.74
120			Training		$3,000.00	$3,000.00
121			Travel	$34,462.47	$ -	-$68,924.94
122			Materials & supplies		$ -
123			Rentals		$3,600.00	$3,600.00
124			Membership fees		$ -
125		OPSMAINT Total		$890,914.74	$330,599.86	-$1,451,229.62
126	60	COMMUNITY	Advertising		$ -
127			Audit fees		$ -
128			Benefits	$7,483.76	$73,905.60	$58,938.08
129			Capital		$ -
130			Contractual services	$25,680.00	$ -	-$51,360.00
131			Honoraria	$31,825.00	$ -	-$63,650.00
132			Insurance		$ -
133			Legal fees		$ -
134			Office supplies	$11,008.86	$ -	-$22,017.72
135			Other	$79,835.30	$39,240.00	-$120,430.60
136			Postage & frieght	$40.00	$ -	-$80.00
137			Repairs & maintenance		$3,624.00	$3,624.00
138			Salaries	$137,927.17	$369,528.00	$93,673.66
139			Telecommunications	$4,511.25	$ -	-$9,022.50
140			Training		$5,544.00	$5,544.00
141			Travel	$110,963.46	$5,112.00	-$216,814.92
142			Materials & supplies		$9,492.00	$9,492.00
143			Rentals		$15,948.00	$15,948.00
144			Membership fees		$ -
145		COMMUNITY Total		$409,274.80	$522,393.60	-$296,156.00
146	70		Contractual services	$3,677.78		-$7,355.56
147			Salaries	$281.77		-$563.54
148			Travel	$500.00		-$1,000.00
149		0 Total		$4,459.55		-$8,919.10
150	75	FISHERIES	Audit fees		$2,500.00	$2,500.00
151			Benefits	$2,261.62	$9,503.16	$4,979.92
152			Capital	$756.00	$ -	-$1,512.00
153			Contractual services	$22,724.34	$ -	-$45,448.68
154			Honoraria		$ -
155			Insurance	$6,813.27	$7,700.00	-$5,926.54
156			Legal fees		$ -
157			Office supplies	$23,736.82	$ -	-$47,473.64
158			Other	$4,132.68	$24,000.00	$15,734.64
159			Postage & frieght	$2,266.70	$ -	-$4,533.40
160			Repairs & maintenance	$33,044.94	$4,400.00	-$61,689.88
161			Salaries	$118,468.64	$105,310.44	-$131,626.84
162			Training		$3,000.00	$3,000.00
163			Travel	$14,992.61	$24,000.00	-$5,985.22
164			Materials & supplies		$3,000.00	$3,000.00
165			Rentals		$ -
166			Membership fees		$ -
167			Admin Fee		$9,120.00	$9,120.00
168			Telecommunications & Utilities		$6,240.00	$6,240.00
169		FISHERIES Total		$229,197.62	$198,773.60	-$259,621.64
170	77	ECONOMIC	Advertising		$6,000.00	$6,000.00
171			Audit fees		$ -
172			Benefits		$29,754.00	$29,754.00
173			Capital		$10,000.00	$10,000.00
174			Contractual services		$7,500.00	$7,500.00
175			Honoraria		$ -
176			Insurance		$ -
177			Legal fees		$ -
178			Office supplies		$ -
179			Other		$50,000.00	$50,000.00
180			Postage & frieght		$ -
181			Repairs & maintenance		$22,500.00	$22,500.00
182			Salaries		$148,794.00	$148,794.00
183			Telecommunications		$3,000.00	$3,000.00
184			Training		$ -
185			Travel		$ -
186			Materials & supplies		$14,000.00	$14,000.00
187			Rentals		$ -
188			Membership fees		$ -
189		ECONOMIC Total			$291,548.00	$291,548.00
190	80	HOUSING	Advertising		$ -
191			Audit fees		$ -
192			Benefits	$4,027.20	$15,301.26	$7,246.86
193			Capital	$21,947.04	$ -	-$43,894.08
194			Contractual services	$44,059.95	$13,010.83	-$75,109.07
195			Honoraria	$100.00	$ -	-$200.00
196			Insurance	$1,131.00	$36,707.44	$34,445.44
197			Legal fees		$ -
198			Office supplies	$1,732.74	$ -	-$3,465.48
199			Other	$23,339.99	$13,575.55	-$33,104.43
200			Postage & frieght	$16,834.30	$2,091.26	-$31,577.34
201			Repairs & maintenance	$195,775.79	$57,775.90	-$333,775.68
202			Salaries	$297,429.47	$66,530.61	-$528,328.33
203			Telecommunications		$124.85	$124.85
204			Training		$ -
205			Travel	$16,760.09	$1,324.90	-$32,195.28
206			Materials & supplies		$2,454.96	$2,454.96
207			Membership fees		$ -
208			Mortgage		$127,186.00	$127,186.00
209		HOUSING Total		$623,137.57	$336,083.55	-$910,191.59
210	90	TREATY	Advertising		$ -
211			Audit fees		$ -
212			Benefits		$ -
213			Capital		$ -
214			Contractual services		$1,800.00	$1,800.00
215			Honoraria		$3,000.00	$3,000.00
216			Insurance		$ -
217			Legal fees		$9,000.00	$9,000.00
218			Office supplies		$ -
219			Other	$24.00	$1,200.00	$1,152.00
220			Postage & frieght		$ -
221			Repairs & maintenance		$ -
222			Salaries		$ -
223			Telecommunications		$ -
224			Training		$ -
225			Travel		$ -
226			Materials & supplies		$ -
227			Rentals		$ -
228			Membership fees		$ -
229		TREATY Total		$24.00	$15,000.00	$14,952.00
230	Grand Total			$7,025,245.44	$5,013,988.38


1	2017-18 Fiscal Year			April 1, 2017 to Dec 31, 2017		9	MONTHS
2	Dept#	Dept		YTD Actuals	Prorated Actual	Budget	Expected Year End Variance		Month to month spending		Notes
3	10	ADMIN		$1,426,591.75	$1,902,122.33	$1,540,417.48	-$361,704.85	175k Taaqwiiaak; 120k Water Filtration costs; $100k Audit	$432,344.93
4	25	HEALTH		$724,293.41	$965,724.55	$1,181,163.46	$215,438.91		$402,982.70		$75,000 added in FNHA funding
5	30	SOCDEV		$894,050.45	$1,192,067.27	$1,182,053.83	-$10,013.44		-$47,194.66
6	40	CAPITAL		$1,291,148.06	$1,721,530.75	$1,799,494.00	$77,963.25		$940,816.85	Prorated Actual	$705,000 added in WWTP DAR funding
7	50	OPSMAINT		$748,577.94	$998,103.92	$1,030,599.86	$32,495.94		$311,802.79	$0.00	$175,000 added WTP funding
8	60	COMMUNITY		$380,724.55	$507,632.73	$522,393.60	$14,760.87		$9,055.45
9	70	FORESTRY		$4,459.55	$5,946.07		-$5,946.07		$4,310.06
10	75	FISHERIES		$213,606.59	$284,808.79	$286,773.60	$1,964.81		$66,017.00		$75,000 home use fish funding
11	77	ECONOMIC			$0.00	$291,548.00	$291,548.00		-$12,721.43
12	80	HOUSING		$541,001.69	$721,335.59	$623,583.55	-$97,752.04	CMHC renovation funding pending	$146,239.13
13	90	TREATY		$21.00	$28.00	$15,000.00	$14,972.00		$15.00
14	Grand Total			$6,224,474.99	$8,299,299.99	$8,473,027.38	$173,727.39		$1,486,211.65
15				$638,876.67		$706,085.62
16	YTD Actuals = Year to Date Actuals = Actual expenses spent year to date								CONTROL #: Does this agree to cell L21 & L22 on spreadsheet
17	Prorated Actual = Year to Date totals divided by number of months so far in the year multiplied by 12 = an estimate of what we will spend for the entire year								6,224,474.99
18	MAP Budget are the budget numbers that Ahousaht needs to come in at or below.								291,548.00
19	Variance is the difference between MAP Budget and Prorated Actual amount; negative amounts are bad								Print to PDF, save, then send to INAC quarterly
20
21				2014-15	2015-16	2016-17	2017-18
22	Net Debt projected to end of year			10,135,743	9,715,815	9,313,285	8,927,432
23
24	BUDGET SUMMARY					Black =Good; Red = Bad
25				YTD Actuals	Original Budget (Funding Additions not included)	Prorated Annual Variance			ALL			rbullock@ahousaht.ca
26	10	ADMIN	Advertising		$2,262.60	$2,262.60			10	ADMIN	Council, Rob B
27			Audit fees		$35,317.00	$35,317.00			25	HEALTH	Dave	julia.atelo@ahousaht.ca
28			Benefits	$115,618.65	$115,274.87	-$115,962.43			30	SOCDEV	Robert	robert.atleo@ahousaht.ca
29			Capital	$9,296.94	$16,998.43	-$1,595.45			40	CAPITAL	Alec, Rob B	alec.dick@ahousaht.ca
30			Contractual services	$568,265.86	$219,632.15	-$916,899.57			50	OPSMAINT	Alec	alec.dick@ahousaht.ca
31			Honoraria	$4,000.00		-$8,000.00			60	COMMUNITY	Dave, Robert	julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca
32			Insurance	$55,089.23	$ -	-$110,178.46			70	FORESTRY
33			Legal fees	$26,947.15	$62,836.25	$8,941.95			75	FISHERIES	Luke	luke.swan@ahousaht.ca
34			Office supplies	$27,312.43	$ -	-$54,624.86			77	ECONOMIC	Council, Rob
35			Other	$143,610.63	$112,318.25	-$174,903.01			80	HOUSING	Patti	caroline.atleo@ahousaht.ca
36			Postage & frieght	$935.00	$23,023.29	$21,153.29			90	TREATY
37			Repairs & maintenance	$527.93	$79,340.58	$78,284.72
38			Salaries	$335,949.58	$455,254.92	-$216,644.24
39			Telecommunications	$64,063.48	$20,396.21	-$107,730.75
40			Training	$3,136.66	$8,952.35	$2,679.03
41			Travel	$71,838.21	$12,863.45	-$130,812.97
42			Membership fees		$947.13	$947.13
43		ADMIN Total		$1,426,591.75	$1,165,417.48	-$1,687,766.02
44	25	HEALTH	Advertising		$ -
45			Audit fees		$ -
46			Capital	$1,048.82	$ -	-$2,097.64
47			Contractual services	$157,020.63		-$314,041.26
48			Honoraria	$1,250.00	$ -	-$2,500.00
49			Insurance		$ -
50			Legal fees		$ -
51			Office supplies	$65,348.92	$31,080.00	-$99,617.84
52			Other	$47,934.41	$5,796.00	-$90,072.82
53			Postage & frieght	$415.00	$ -	-$830.00
54			Repairs & maintenance	$2,318.50	$31,500.00	$26,863.00
55			Salaries	$304,830.92	$361,596.00	-$248,065.84
56			Telecommunications		$12,999.96	$12,999.96
57			Training		$ -
58			Travel	$144,126.21	$41,004.00	-$247,248.42
59			Healthy Baby		$6,000.00	$6,000.00
60			(CW) Workshops		$6,500.00	$6,500.00
61			Youth Activities		$20,799.96	$20,799.96
62			Community Workshops		$23,000.04	$23,000.04
63		HEALTH Total		$724,293.41	$540,275.96	-$908,310.86
64	30	SOCDEV	Advertising		$ -
65			Audit fees		$ -
66			Benefits	$5,318.68		-$10,637.36
67			Capital		$ -
68			Contractual services	$19,417.35		-$38,834.70
69			Honoraria		$ -
70			Legal fees		$ -
71			Office supplies	$8,633.27	$ -	-$17,266.54
72			Other	$617,795.76	$920,540.73	-$315,050.79
73			Postage & frieght	$120.00		-$240.00
74			Repairs & maintenance	$5,545.80		-$11,091.60
75			Salaries	$211,297.75	$108,787.44	-$313,808.06
76			Telecommunications		$ -
77			Training		$ -
78			Travel	$25,921.84	$ -	-$51,843.68
79			Materials & supplies		$ -
80			Special Needs		$27,547.92	$27,547.92
81			Gaurdian Financial Assistance		$ -
82			Admin Fee Office Supplies, Rent		$11,100.00	$11,100.00
83			Assisted Living		$38,226.24	$38,226.24
84			Disability		$8,200.00	$8,200.00
85		SOCDEV Total		$894,050.45	$1,114,402.33	-$673,698.57
86	40	CAPITAL	Advertising		$ -
87			Audit fees		$ -
88			Benefits		$ -
89			Capital		$ -
90			Contractual services	$1,047,110.78	$427,494.00	-$1,666,727.56
91			Honoraria		$ -
92			Insurance		$ -
93			Legal fees		$ -
94			Office supplies	$68,710.98	$ -	-$137,421.96
95			Other	$40,183.64		-$80,367.28
96			Postage & frieght	$7,170.00	$ -	-$14,340.00
97			Repairs & maintenance	$1,718.91	$50,000.04	$46,562.22
98			Salaries	$20,162.23	$ -	-$40,324.46
99			Telecommunications		$ -
100			Training	$1,377.60	$ -	-$2,755.20
101			Travel	$104,713.92	$3,999.96	-$205,427.88
102			Materials & supplies		$18,000.00	$18,000.00
103			Rentals		$ -
104			Membership fees		$ -
105		CAPITAL Total		$1,291,148.06	$499,494.00	-$2,082,802.12
106	50	OPSMAINT	Advertising		$ -
107			Audit fees		$ -
108			Benefits	$4,676.92	$41,999.98	$32,646.14
109			Capital	$7,966.19	$ -	-$15,932.38
110			Contractual services	$207,180.17	$ -	-$414,360.34
111			Honoraria		$ -
112			Insurance	$2,016.00	$ -	-$4,032.00
113			Legal fees		$ -
114			Office supplies	$119,145.15	$ -	-$238,290.30
115			Other	$64,044.20	$14,400.00	-$113,688.40
116			Postage & frieght	$16,662.09	$ -	-$33,324.18
117			Repairs & maintenance	$31,097.80	$54,000.00	-$8,195.60
118			Salaries	$263,633.68	$209,999.88	-$317,267.48
119			Telecommunications	$186.63	$3,600.00	$3,226.74
120			Training		$3,000.00	$3,000.00
121			Travel	$31,969.11	$ -	-$63,938.22
122			Materials & supplies		$ -
123			Rentals		$3,600.00	$3,600.00
124			Membership fees		$ -
125		OPSMAINT Total		$748,577.94	$330,599.86	-$1,166,556.02
126	60	COMMUNITY	Advertising		$ -
127			Audit fees		$ -
128			Benefits	$6,498.16	$73,905.60	$60,909.28
129			Capital		$ -
130			Contractual services	$25,680.00	$ -	-$51,360.00
131			Honoraria	$31,075.00	$ -	-$62,150.00
132			Insurance		$ -
133			Legal fees		$ -
134			Office supplies	$10,583.80	$ -	-$21,167.60
135			Other	$75,600.00	$39,240.00	-$111,960.00
136			Postage & frieght	$40.00	$ -	-$80.00
137			Repairs & maintenance		$3,624.00	$3,624.00
138			Salaries	$123,250.74	$369,528.00	$123,026.52
139			Telecommunications	$4,207.50	$ -	-$8,415.00
140			Training		$5,544.00	$5,544.00
141			Travel	$103,789.35	$5,112.00	-$202,466.70
142			Materials & supplies		$9,492.00	$9,492.00
143			Rentals		$15,948.00	$15,948.00
144			Membership fees		$ -
145		COMMUNITY Total		$380,724.55	$522,393.60	-$239,055.50
146	70		Contractual services	$3,677.78		-$7,355.56
147			Salaries	$281.77		-$563.54
148			Travel	$500.00		-$1,000.00
149		0 Total		$4,459.55		-$8,919.10
150	75	FISHERIES	Audit fees		$2,500.00	$2,500.00
151			Benefits	$1,951.38	$9,503.16	$5,600.40
152			Capital	$756.00	$ -	-$1,512.00