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 | |
|---|---|---|---|---|---|
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 386,404.00 | 19.69% | 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 | |||||||||||||||||||||
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 Sep 30, 2017 | 6 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $745,983.48 | $1,491,966.96 | $1,215,417.48 | -$276,549.48 | -$248,263.34 | |||||
4 | 25 | HEALTH | $464,539.82 | $929,079.64 | $1,015,642.96 | $86,563.32 | $143,229.11 | $75,000 added in FNHA funding | ||||
5 | 30 | SOCDEV | $531,467.36 | $1,062,934.72 | $1,059,503.33 | -$3,431.39 | -$409,777.75 | |||||
6 | 40 | CAPITAL | $972,824.84 | $1,945,649.68 | $1,999,494.00 | $53,844.32 | $622,493.63 | Prorated Actual | $705,000 added in WWTP DAR funding | |||
7 | 50 | OPSMAINT | $516,397.57 | $1,032,795.14 | $1,030,599.86 | -$2,195.28 | $79,622.42 | $0.00 | $175,000 added WTP funding | |||
8 | 60 | COMMUNITY | $261,241.01 | $522,482.02 | $522,393.60 | -$88.42 | -$110,428.09 | |||||
9 | 70 | FORESTRY | $2,459.17 | $4,918.34 | -$4,918.34 | $2,309.68 | ||||||
10 | 75 | FISHERIES | $140,291.63 | $280,583.26 | $286,773.60 | $6,190.34 | -$7,297.96 | $75,000 home use fish funding | ||||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | -$12,721.43 | ||||||
12 | 80 | HOUSING | $349,146.56 | $698,293.12 | $573,583.55 | -$124,709.57 | CMHC funds not recd | -$45,616.00 | ||||
13 | 90 | TREATY | $9.00 | $18.00 | $15,000.00 | $14,982.00 | $3.00 | |||||
14 | Grand Total | $3,984,360.44 | $7,968,720.88 | $8,009,956.38 | $41,235.50 | -$753,902.90 | ||||||
15 | $661,628.14 | $667,496.37 | ||||||||||
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 | 3,984,360.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 | $154,600.70 | 2016-17 | ||||||||||
21 | 2013-14 | 2014-15 | 2015-16 | Estimated | ||||||||
22 | Net Debt projected to end of year | 10,579,155 | 10,135,743 | 9,715,815 | 9,313,285 | It will take 21+ years to pay off all debt, at current rates | ||||||
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 | $92,775.94 | $115,274.87 | -$70,277.01 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $6,245.07 | $16,998.43 | $4,508.29 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $283,816.38 | $219,632.15 | -$348,000.61 | 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 | $20,099.65 | $ - | -$40,199.30 | 70 | FORESTRY | ||||||
33 | Legal fees | $62,836.25 | $62,836.25 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | |||||
34 | Office supplies | $25,037.84 | $ - | -$50,075.68 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $58,426.59 | $112,318.25 | -$4,534.93 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $885.00 | $23,023.29 | $21,253.29 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $79,340.58 | $79,340.58 | |||||||||
38 | Salaries | $227,844.27 | $455,254.92 | -$433.62 | ||||||||
39 | Telecommunications | $44,478.03 | $20,396.21 | -$68,559.85 | ||||||||
40 | Training | $3,136.66 | $8,952.35 | $2,679.03 | ||||||||
41 | Travel | -$20,761.95 | $12,863.45 | $54,387.35 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $745,983.48 | $1,165,417.48 | -$326,549.48 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $1,019.57 | $ - | -$2,039.14 | ||||||||
47 | Contractual services | $93,956.70 | -$187,913.40 | |||||||||
48 | Honoraria | $750.00 | $ - | -$1,500.00 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $48,923.70 | $31,080.00 | -$66,767.40 | ||||||||
52 | Other | $29,059.93 | $5,796.00 | -$52,323.86 | ||||||||
53 | Postage & frieght | $355.00 | $ - | -$710.00 | ||||||||
54 | Repairs & maintenance | $1,230.40 | $31,500.00 | $29,039.20 | ||||||||
55 | Salaries | $208,289.68 | $361,596.00 | -$54,983.36 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $80,954.84 | $41,004.00 | -$120,905.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 | $464,539.82 | $540,275.96 | -$388,803.68 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $3,847.58 | -$7,695.16 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $13,496.15 | -$26,992.30 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $5,015.80 | $ - | -$10,031.60 | ||||||||
72 | Other | $354,253.93 | $920,540.73 | $212,032.87 | ||||||||
73 | Postage & frieght | $65.00 | -$130.00 | |||||||||
74 | Repairs & maintenance | $1,150.88 | -$2,301.76 | |||||||||
75 | Salaries | $147,262.01 | $108,787.44 | -$185,736.58 | ||||||||
76 | Telecommunications | $ - | ||||||||||
77 | Training | $ - | ||||||||||
78 | Travel | $6,376.01 | $ - | -$12,752.02 | ||||||||
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 | $531,467.36 | $1,114,402.33 | $51,467.61 | ||||||||
86 | 40 | CAPITAL | Advertising | $ - | ||||||||
87 | Audit fees | $ - | ||||||||||
88 | Benefits | $ - | ||||||||||
89 | Capital | $ - | ||||||||||
90 | Contractual services | $767,185.85 | $427,494.00 | -$1,106,877.70 | ||||||||
91 | Honoraria | $ - | ||||||||||
92 | Insurance | $ - | ||||||||||
93 | Legal fees | $ - | ||||||||||
94 | Office supplies | $66,670.98 | $ - | -$133,341.96 | ||||||||
95 | Other | $25,312.69 | -$50,625.38 | |||||||||
96 | Postage & frieght | $10.00 | $ - | -$20.00 | ||||||||
97 | Repairs & maintenance | $1,512.51 | $50,000.04 | $46,975.02 | ||||||||
98 | Salaries | $20,162.23 | $ - | -$40,324.46 | ||||||||
99 | Telecommunications | $ - | ||||||||||
100 | Training | $688.80 | $ - | -$1,377.60 | ||||||||
101 | Travel | $91,281.78 | $3,999.96 | -$178,563.60 | ||||||||
102 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
103 | Rentals | $ - | ||||||||||
104 | Membership fees | $ - | ||||||||||
105 | CAPITAL Total | $972,824.84 | $499,494.00 | -$1,446,155.68 | ||||||||
106 | 50 | OPSMAINT | Advertising | $ - | ||||||||
107 | Audit fees | $ - | ||||||||||
108 | Benefits | $3,196.59 | $41,999.98 | $35,606.80 | ||||||||
109 | Capital | $966.19 | $ - | -$1,932.38 | ||||||||
110 | Contractual services | $172,274.79 | $ - | -$344,549.58 | ||||||||
111 | Honoraria | $ - | ||||||||||
112 | Insurance | $2,016.00 | $ - | -$4,032.00 | ||||||||
113 | Legal fees | $ - | ||||||||||
114 | Office supplies | $94,089.08 | $ - | -$188,178.16 | ||||||||
115 | Other | $3,205.20 | $14,400.00 | $7,989.60 | ||||||||
116 | Postage & frieght | $10,868.34 | $ - | -$21,736.68 | ||||||||
117 | Repairs & maintenance | $23,875.44 | $54,000.00 | $6,249.12 | ||||||||
118 | Salaries | $183,214.57 | $209,999.88 | -$156,429.26 | ||||||||
119 | Telecommunications | $3,600.00 | $3,600.00 | |||||||||
120 | Training | $3,000.00 | $3,000.00 | |||||||||
121 | Travel | $22,691.37 | $ - | -$45,382.74 | ||||||||
122 | Materials & supplies | $ - | ||||||||||
123 | Rentals | $3,600.00 | $3,600.00 | |||||||||
124 | Membership fees | $ - | ||||||||||
125 | OPSMAINT Total | $516,397.57 | $330,599.86 | -$702,195.28 | ||||||||
126 | 60 | COMMUNITY | Advertising | $ - | ||||||||
127 | Audit fees | $ - | ||||||||||
128 | Benefits | $4,519.06 | $73,905.60 | $64,867.48 | ||||||||
129 | Capital | $ - | ||||||||||
130 | Contractual services | $25,680.00 | $ - | -$51,360.00 | ||||||||
131 | Honoraria | $12,300.00 | $ - | -$24,600.00 | ||||||||
132 | Insurance | $ - | ||||||||||
133 | Legal fees | $ - | ||||||||||
134 | Office supplies | $6,861.24 | $ - | -$13,722.48 | ||||||||
135 | Other | $49,724.53 | $39,240.00 | -$60,209.06 | ||||||||
136 | Postage & frieght | $40.00 | $ - | -$80.00 | ||||||||
137 | Repairs & maintenance | $3,624.00 | $3,624.00 | |||||||||
138 | Salaries | $89,966.47 | $369,528.00 | $189,595.06 | ||||||||
139 | Telecommunications | $3,000.00 | $ - | -$6,000.00 | ||||||||
140 | Training | $5,544.00 | $5,544.00 | |||||||||
141 | Travel | $69,149.71 | $5,112.00 | -$133,187.42 | ||||||||
142 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
143 | Rentals | $15,948.00 | $15,948.00 | |||||||||
144 | Membership fees | $ - | ||||||||||
145 | COMMUNITY Total | $261,241.01 | $522,393.60 | -$88.42 | ||||||||
146 | 70 | Contractual services | $1,782.50 | -$3,565.00 | ||||||||
147 | Salaries | $176.67 | -$353.34 | |||||||||
148 | Travel | $500.00 | -$1,000.00 | |||||||||
149 | 0 Total | $2,459.17 | -$4,918.34 | |||||||||
150 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | |||||||
151 | Benefits | $1,458.12 | $9,503.16 | $6,586.92 | ||||||||
152 | Capital | $756.00 | $ - | -$1,512.00 | ||||||||
153 | Contractual services | $21,325.00 | $ - | -$42,650.00 | ||||||||
154 | Honoraria | $ - | ||||||||||
155 | Insurance | $7,700.00 | $7,700.00 | |||||||||
156 | Legal fees | $ - | ||||||||||
157 | Office supplies | $13,101.03 | $ - | -$26,202.06 | ||||||||
158 | Other | $1,820.92 | $24,000.00 | $20,358.16 | ||||||||
159 | Postage & frieght | $255.00 | $ - | -$510.00 | ||||||||
160 | Repairs & maintenance | $23,613.55 | $4,400.00 | -$42,827.10 | ||||||||
161 | Salaries | $70,860.60 | $105,310.44 | -$36,410.76 | ||||||||
162 | Training | $3,000.00 | $3,000.00 | |||||||||
163 | Travel | $7,101.41 | $24,000.00 | $9,797.18 | ||||||||
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 | $140,291.63 | $198,773.60 | -$81,809.66 | ||||||||
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 | $2,436.72 | $15,301.26 | $10,427.82 | ||||||||
193 | Capital | $11,140.48 | $ - | -$22,280.96 | ||||||||
194 | Contractual services | $41,700.00 | $13,010.83 | -$70,389.17 | ||||||||
195 | Honoraria | $ - | ||||||||||
196 | Insurance | $1,131.00 | $36,707.44 | $34,445.44 | ||||||||
197 | Legal fees | $ - | ||||||||||
198 | Office supplies | -$1,334.97 | $ - | $2,669.94 | ||||||||
199 | Other | $17,664.81 | $13,575.55 | -$21,754.07 | ||||||||
200 | Postage & frieght | $7,504.30 | $2,091.26 | -$12,917.34 | ||||||||
201 | Repairs & maintenance | $103,552.13 | $57,775.90 | -$149,328.36 | ||||||||
202 | Salaries | $153,910.00 | $66,530.61 | -$241,289.39 | ||||||||
203 | Telecommunications | $124.85 | $124.85 | |||||||||
204 | Training | $ - | ||||||||||
205 | Travel | $11,442.09 | $1,324.90 | -$21,559.28 | ||||||||
206 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||
207 | Membership fees | $ - | ||||||||||
208 | Mortgage | $127,186.00 | $127,186.00 | |||||||||
209 | HOUSING Total | $349,146.56 | $336,083.55 | -$362,209.57 | ||||||||
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 | $9.00 | $1,200.00 | $1,182.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 | $9.00 | $15,000.00 | $14,982.00 | ||||||||
230 | Grand Total | $3,984,360.44 | $5,013,988.38 | |||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to Aug 31, 2017 | 5 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $591,382.78 | $1,419,318.67 | $1,315,417.48 | -$103,901.19 | -$402,864.04 | |||||
4 | 25 | HEALTH | $393,716.08 | $944,918.59 | $960,469.46 | $15,550.87 | $72,405.37 | $75,000 added in FNHA funding | ||||
5 | 30 | SOCDEV | $434,406.40 | $1,042,575.36 | $1,110,319.83 | $67,744.47 | -$506,838.71 | |||||
6 | 40 | CAPITAL | $818,962.25 | $1,965,509.40 | $1,999,494.00 | $33,984.60 | $468,631.04 | Prorated Actual | $705,000 added in WWTP DAR funding | |||
7 | 50 | OPSMAINT | $447,464.74 | $1,073,915.38 | $1,030,599.86 | -$43,315.52 | $10,689.59 | $0.00 | $175,000 added WTP funding | |||
8 | 60 | COMMUNITY | $223,115.55 | $535,477.32 | $522,393.60 | -$13,083.72 | -$148,553.55 | |||||
9 | 70 | FORESTRY | $885.63 | $2,125.51 | -$2,125.51 | $736.14 | ||||||
10 | 75 | FISHERIES | $119,645.25 | $287,148.60 | $286,773.60 | -$375.00 | -$27,944.34 | $75,000 home use fish funding | ||||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | Offset deficits in other departments | -$12,721.43 | |||||
12 | 80 | HOUSING | $293,153.62 | $703,568.69 | $573,583.55 | -$129,985.14 | CMHC revenue not yet rec'd | -$101,608.94 | ||||
13 | 90 | TREATY | $0.00 | $15,000.00 | $15,000.00 | -$6.00 | ||||||
14 | Grand Total | $3,322,732.30 | $7,974,557.52 | $8,105,599.38 | $131,041.86 | -$1,415,531.04 | ||||||
15 | $700,998.12 | $675,466.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 | 3,322,732.30 | ||||||||||
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 | 2016-17 | |||||||||||
21 | 2013-14 | 2014-15 | 2015-16 | Estimated | ||||||||
22 | Net Debt projected to end of year | 10,579,155 | 10,135,743 | 9,715,815 | 9,313,285 | It will take 21+ years to pay off all debt, at current rates | ||||||
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 | $42,368.78 | $115,274.87 | $13,589.79 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $200.00 | $16,998.43 | $16,518.43 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $331,910.52 | $219,632.15 | -$576,953.10 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||
31 | Honoraria | $4,000.00 | -$9,600.00 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||
32 | Insurance | -$23,804.04 | $ - | $57,129.70 | 70 | FORESTRY | ||||||
33 | Legal fees | $62,836.25 | $62,836.25 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | |||||
34 | Office supplies | $17,833.65 | $ - | -$42,800.76 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | -$31,802.86 | $112,318.25 | $188,645.12 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $865.00 | $23,023.29 | $20,947.29 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $79,340.58 | $79,340.58 | |||||||||
38 | Salaries | $180,979.66 | $455,254.92 | $20,903.74 | ||||||||
39 | Telecommunications | $1,101.83 | $20,396.21 | $17,751.81 | ||||||||
40 | Training | $8,952.35 | $8,952.35 | |||||||||
41 | Travel | $67,730.24 | $12,863.45 | -$149,689.12 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $591,382.78 | $1,165,417.48 | -$253,901.19 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $1,019.57 | $ - | -$2,446.97 | ||||||||
47 | Contractual services | $82,015.44 | -$196,837.06 | |||||||||
48 | Honoraria | $750.00 | $ - | -$1,800.00 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $40,338.55 | $31,080.00 | -$65,732.52 | ||||||||
52 | Other | $23,576.27 | $5,796.00 | -$50,787.05 | ||||||||
53 | Postage & frieght | $150.00 | $ - | -$360.00 | ||||||||
54 | Repairs & maintenance | $994.40 | $31,500.00 | $29,113.44 | ||||||||
55 | Salaries | $174,489.28 | $361,596.00 | -$57,178.27 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $70,382.57 | $41,004.00 | -$127,914.17 | ||||||||
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 | $393,716.08 | $540,275.96 | -$404,642.63 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $3,370.86 | -$8,090.06 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $12,622.15 | -$30,293.16 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $5,801.24 | $ - | -$13,922.98 | ||||||||
72 | Other | $279,042.69 | $920,540.73 | $250,838.27 | ||||||||
73 | Postage & frieght | $35.00 | -$84.00 | |||||||||
74 | Repairs & maintenance | $500.88 | -$1,202.11 | |||||||||
75 | Salaries | $127,599.19 | $108,787.44 | -$197,450.62 | ||||||||
76 | Telecommunications | $ - | ||||||||||
77 | Training | $ - | ||||||||||
78 | Travel | $5,434.39 | $ - | -$13,042.54 | ||||||||
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 | $434,406.40 | $1,114,402.33 | $71,826.97 | ||||||||
86 | 40 | CAPITAL | Advertising | $ - | ||||||||
87 | Audit fees | $ - | ||||||||||
88 | Benefits | $ - | ||||||||||
89 | Capital | $ - | ||||||||||
90 | Contractual services | $645,239.97 | $427,494.00 | -$1,121,081.93 | ||||||||
91 | Honoraria | $ - | ||||||||||
92 | Insurance | $ - | ||||||||||
93 | Legal fees | $ - | ||||||||||
94 | Office supplies | $66,227.76 | $ - | -$158,946.62 | ||||||||
95 | Other | $24,139.20 | -$57,934.08 | |||||||||
96 | Postage & frieght | $10.00 | $ - | -$24.00 | ||||||||
97 | Repairs & maintenance | $1,512.51 | $50,000.04 | $46,370.02 | ||||||||
98 | Salaries | $20,162.23 | $ - | -$48,389.35 | ||||||||
99 | Telecommunications | $ - | ||||||||||
100 | Training | $688.80 | $ - | -$1,653.12 | ||||||||
101 | Travel | $60,981.78 | $3,999.96 | -$142,356.31 | ||||||||
102 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
103 | Rentals | $ - | ||||||||||
104 | Membership fees | $ - | ||||||||||
105 | CAPITAL Total | $818,962.25 | $499,494.00 | -$1,466,015.40 | ||||||||
106 | 50 | OPSMAINT | Advertising | $ - | ||||||||
107 | Audit fees | $ - | ||||||||||
108 | Benefits | $2,822.22 | $41,999.98 | $35,226.65 | ||||||||
109 | Capital | $587.19 | $ - | -$1,409.26 | ||||||||
110 | Contractual services | $161,216.61 | $ - | -$386,919.86 | ||||||||
111 | Honoraria | $ - | ||||||||||
112 | Insurance | $2,016.00 | $ - | -$4,838.40 | ||||||||
113 | Legal fees | $ - | ||||||||||
114 | Office supplies | $77,132.37 | $ - | -$185,117.69 | ||||||||
115 | Other | $972.80 | $14,400.00 | $12,065.28 | ||||||||
116 | Postage & frieght | $7,299.38 | $ - | -$17,518.51 | ||||||||
117 | Repairs & maintenance | $20,448.79 | $54,000.00 | $4,922.90 | ||||||||
118 | Salaries | $154,518.15 | $209,999.88 | -$160,843.68 | ||||||||
119 | Telecommunications | $3,600.00 | $3,600.00 | |||||||||
120 | Training | $3,000.00 | $3,000.00 | |||||||||
121 | Travel | $20,451.23 | $ - | -$49,082.95 | ||||||||
122 | Materials & supplies | $ - | ||||||||||
123 | Rentals | $3,600.00 | $3,600.00 | |||||||||
124 | Membership fees | $ - | ||||||||||
125 | OPSMAINT Total | $447,464.74 | $330,599.86 | -$743,315.52 | ||||||||
126 | 60 | COMMUNITY | Advertising | $ - | ||||||||
127 | Audit fees | $ - | ||||||||||
128 | Benefits | $3,849.33 | $73,905.60 | $64,667.21 | ||||||||
129 | Capital | $ - | ||||||||||
130 | Contractual services | $25,680.00 | $ - | -$61,632.00 | ||||||||
131 | Honoraria | $10,400.00 | $ - | -$24,960.00 | ||||||||
132 | Insurance | $ - | ||||||||||
133 | Legal fees | $ - | ||||||||||
134 | Office supplies | $6,065.85 | $ - | -$14,558.04 | ||||||||
135 | Other | $43,048.13 | $39,240.00 | -$64,075.51 | ||||||||
136 | Postage & frieght | $40.00 | $ - | -$96.00 | ||||||||
137 | Repairs & maintenance | $3,624.00 | $3,624.00 | |||||||||
138 | Salaries | $76,968.96 | $369,528.00 | $184,802.50 | ||||||||
139 | Telecommunications | $2,625.00 | $ - | -$6,300.00 | ||||||||
140 | Training | $5,544.00 | $5,544.00 | |||||||||
141 | Travel | $54,438.28 | $5,112.00 | -$125,539.87 | ||||||||
142 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
143 | Rentals | $15,948.00 | $15,948.00 | |||||||||
144 | Membership fees | $ - | ||||||||||
145 | COMMUNITY Total | $223,115.55 | $522,393.60 | -$13,083.72 | ||||||||
146 | 70 | Contractual services | $708.96 | -$1,701.50 | ||||||||
147 | Salaries | $176.67 | -$424.01 | |||||||||
148 | 0 Total | $885.63 | -$2,125.51 | |||||||||
149 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | |||||||
150 | Benefits | $1,222.34 | $9,503.16 | $6,569.54 | ||||||||
151 | Capital | $756.00 | $ - | -$1,814.40 | ||||||||
152 | Contractual services | $21,025.00 | $ - | -$50,460.00 | ||||||||
153 | Honoraria | $ - | ||||||||||
154 | Insurance | $7,700.00 | $7,700.00 | |||||||||
155 | Legal fees | $ - | ||||||||||
156 | Office supplies | $12,706.98 | $ - | -$30,496.75 | ||||||||
157 | Other | $1,411.15 | $24,000.00 | $20,613.24 | ||||||||
158 | Postage & frieght | $35.00 | $ - | -$84.00 | ||||||||
159 | Repairs & maintenance | $17,138.59 | $4,400.00 | -$36,732.62 | ||||||||
160 | Salaries | $60,276.82 | $105,310.44 | -$39,353.93 | ||||||||
161 | Training | $3,000.00 | $3,000.00 | |||||||||
162 | Travel | $5,073.37 | $24,000.00 | $11,823.91 | ||||||||
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 | $119,645.25 | $198,773.60 | -$88,375.00 | ||||||||
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 | $2,064.84 | $15,301.26 | $10,345.65 | ||||||||
192 | Capital | $9,922.84 | $ - | -$23,814.82 | ||||||||
193 | Contractual services | $31,200.00 | $13,010.83 | -$61,869.17 | ||||||||
194 | Honoraria | $ - | ||||||||||
195 | Insurance | $1,131.00 | $36,707.44 | $33,993.04 | ||||||||
196 | Legal fees | $ - | ||||||||||
197 | Office supplies | $ - | ||||||||||
198 | Other | $16,899.57 | $13,575.55 | -$26,983.42 | ||||||||
199 | Postage & frieght | $7,119.30 | $2,091.26 | -$14,995.06 | ||||||||
200 | Repairs & maintenance | $92,665.17 | $57,775.90 | -$164,620.51 | ||||||||
201 | Salaries | $126,481.83 | $66,530.61 | -$237,025.78 | ||||||||
202 | Telecommunications | $124.85 | $124.85 | |||||||||
203 | Training | $ - | ||||||||||
204 | Travel | $5,669.07 | $1,324.90 | -$12,280.87 | ||||||||
205 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||
206 | Membership fees | $ - | ||||||||||
207 | Mortgage | $127,186.00 | $127,186.00 | |||||||||
208 | HOUSING Total | $293,153.62 | $336,083.55 | -$367,485.13 | ||||||||
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 | $1,200.00 | $1,200.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 | $15,000.00 | $15,000.00 | |||||||||
229 | Grand Total | $3,322,732.30 | $5,013,988.38 | -$2,960,569.14 | ||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to July 31, 2017 | 4 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $401,764.96 | $1,205,294.88 | $1,165,417.48 | -$39,877.40 | Taaqwiihaak Deficit $175,000 | -$592,481.86 | ||||
4 | 25 | HEALTH | $307,974.97 | $923,924.91 | $930,969.96 | $7,045.05 | FNHA Funding | -$13,335.74 | $75,000 added in FNHA funding | |||
5 | 30 | SOCDEV | $391,865.84 | $1,175,597.52 | $1,177,803.00 | $2,205.48 | -$549,379.27 | |||||
6 | 40 | CAPITAL | $694,977.67 | $2,084,933.01 | $2,099,494.00 | $14,560.99 | WWTP+Teacherage+Multiplex | $344,646.46 | Prorated Actual | $705,000 added in WWTP DAR funding | ||
7 | 50 | OPSMAINT | $368,949.84 | $1,106,849.52 | $1,030,599.86 | -$76,249.66 | -$67,825.31 | $0.00 | $175,000 added WTP funding | |||
8 | 60 | COMMUNITY | $158,564.20 | $475,692.60 | $522,393.60 | $46,701.00 | -$213,104.90 | |||||
9 | 70 | FORESTRY | $253.13 | $759.39 | -$759.39 | $103.64 | ||||||
10 | 75 | FISHERIES | $92,510.79 | $277,532.37 | $286,773.60 | $9,241.23 | Home Use not yet received | -$55,078.80 | $75,000 home use fish funding | |||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | Offset deficits in other departments | -$12,721.43 | |||||
12 | 80 | HOUSING | $204,872.78 | $614,618.34 | $523,583.55 | -$91,034.79 | CMHC RRAP revenue not yet rec'd | -$189,889.78 | ||||
13 | 90 | TREATY | $0.00 | $15,000.00 | $15,000.00 | -$6.00 | ||||||
14 | Grand Total | $2,621,734.18 | $7,865,202.54 | $8,043,583.05 | $178,380.51 | -$2,116,529.16 | ||||||
15 | $501,848.84 | $670,298.59 | ||||||||||
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 | 2,621,734.18 | ||||||||||
18 | MAP Budget are the budget numbers that Ahousaht needs to come in at or below. | 242,256.77 | ||||||||||
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 | 2016-17 | |||||||||||
21 | 2013-14 | 2014-15 | 2015-16 | Estimated | ||||||||
22 | Net Debt projected to end of year | 10,579,155 | 10,135,743 | 9,715,815 | 9,313,285 | It will take 21+ years to pay off all debt, at current rates | ||||||
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 | $31,080.33 | 25 | HEALTH | Dave | julia.atelo@ahousaht.ca | |||||
28 | Benefits | $22,903.82 | $115,274.87 | -$88,901.49 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $200.00 | $16,998.43 | $15,845.00 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $209,208.48 | $219,632.15 | -$145,974.69 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||
31 | Honoraria | $3,800.00 | -$1,745.45 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||
32 | Insurance | $1,124.00 | $ - | -$158.18 | 70 | FORESTRY | ||||||
33 | Legal fees | $62,836.25 | $62,836.25 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | |||||
34 | Office supplies | $17,533.37 | $ - | -$42,956.31 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $7,833.86 | $112,318.25 | $71,695.33 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $855.00 | $23,023.29 | $21,516.74 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $79,340.58 | $78,853.76 | |||||||||
38 | Salaries | $121,530.61 | $455,254.92 | -$8,993.62 | ||||||||
39 | Telecommunications | $917.38 | $20,396.21 | $17,832.21 | ||||||||
40 | Training | $8,952.35 | -$5,560.83 | |||||||||
41 | Travel | $15,858.44 | $12,863.45 | -$50,834.76 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $401,764.96 | $1,165,417.48 | -$42,255.99 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $224.00 | $ - | -$85.57 | ||||||||
47 | Contractual services | $81,286.92 | -$259,112.25 | |||||||||
48 | Honoraria | $500.00 | $ - | -$2,563.64 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $28,458.44 | $31,080.00 | -$82,642.16 | ||||||||
52 | Other | $18,873.71 | $5,796.00 | -$45,643.42 | ||||||||
53 | Postage & frieght | $150.00 | $ - | -$2,066.84 | ||||||||
54 | Repairs & maintenance | $799.40 | $31,500.00 | $28,623.87 | ||||||||
55 | Salaries | $125,861.37 | $361,596.00 | -$26,305.78 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $51,821.13 | $41,004.00 | -$142,977.45 | ||||||||
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 | $307,974.97 | $540,275.96 | -$463,473.26 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $2,737.30 | -$9,093.10 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $12,622.15 | -$52,657.42 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $4,345.60 | $ - | -$22,271.60 | ||||||||
72 | Other | $270,363.12 | $920,540.73 | $127,612.54 | ||||||||
73 | Repairs & maintenance | $500.88 | -$7,798.42 | |||||||||
74 | Salaries | $95,922.40 | $108,787.44 | -$161,521.52 | ||||||||
75 | Telecommunications | $ - | -$115.06 | |||||||||
76 | Training | $ - | ||||||||||
77 | Travel | $5,374.39 | $ - | -$38,947.56 | ||||||||
78 | Materials & supplies | $ - | ||||||||||
79 | Special Needs | $27,547.92 | $27,547.92 | |||||||||
80 | Gaurdian Financial Assistance | $ - | ||||||||||
81 | Admin Fee Office Supplies, Rent | $11,100.00 | $11,100.00 | |||||||||
82 | Assisted Living | $38,226.24 | $38,226.24 | |||||||||
83 | Disability | $8,200.00 | $8,200.00 | |||||||||
84 | SOCDEV Total | $391,865.84 | $1,114,402.33 | -$79,717.96 | ||||||||
85 | 40 | CAPITAL | Advertising | $ - | ||||||||
86 | Audit fees | $ - | ||||||||||
87 | Benefits | $ - | ||||||||||
88 | Capital | $ - | -$70,561.44 | |||||||||
89 | Contractual services | $608,373.71 | $427,494.00 | -$494,502.48 | ||||||||
90 | Honoraria | $ - | -$654.55 | |||||||||
91 | Insurance | $ - | ||||||||||
92 | Legal fees | $ - | ||||||||||
93 | Office supplies | $12,165.55 | $ - | -$81,196.71 | ||||||||
94 | Other | $119.20 | -$1,096.75 | |||||||||
95 | Postage & frieght | $10.00 | $ - | -$5,258.18 | ||||||||
96 | Repairs & maintenance | $1,448.21 | $50,000.04 | $41,318.40 | ||||||||
97 | Salaries | $15,730.42 | $ - | -$59,642.83 | ||||||||
98 | Telecommunications | $ - | -$565.09 | |||||||||
99 | Training | $688.80 | $ - | |||||||||
100 | Travel | $56,441.78 | $3,999.96 | -$49,177.20 | ||||||||
101 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
102 | Rentals | $ - | ||||||||||
103 | Membership fees | $ - | ||||||||||
104 | CAPITAL Total | $694,977.67 | $499,494.00 | -$703,336.82 | ||||||||
105 | 50 | OPSMAINT | Advertising | $ - | ||||||||
106 | Audit fees | $ - | ||||||||||
107 | Benefits | $2,100.32 | $41,999.98 | $34,531.34 | ||||||||
108 | Capital | $ - | -$3,372.37 | |||||||||
109 | Contractual services | $146,042.62 | $ - | -$188,528.05 | ||||||||
110 | Honoraria | $ - | ||||||||||
111 | Insurance | $2,016.00 | $ - | -$1,360.36 | ||||||||
112 | Legal fees | $ - | ||||||||||
113 | Office supplies | $70,635.28 | $ - | -$139,675.45 | ||||||||
114 | Other | $509.30 | $14,400.00 | $11,627.98 | ||||||||
115 | Postage & frieght | $4,498.38 | $ - | -$12,378.29 | ||||||||
116 | Repairs & maintenance | $15,945.10 | $54,000.00 | $17,045.67 | ||||||||
117 | Salaries | $109,952.10 | $209,999.88 | -$158,979.13 | ||||||||
118 | Telecommunications | $3,600.00 | $3,600.00 | |||||||||
119 | Training | $3,000.00 | $2,918.18 | |||||||||
120 | Travel | $17,250.74 | $ - | -$52,415.39 | ||||||||
121 | Materials & supplies | $ - | ||||||||||
122 | Rentals | $3,600.00 | $3,600.00 | |||||||||
123 | Membership fees | $ - | ||||||||||
124 | OPSMAINT Total | $368,949.84 | $330,599.86 | -$483,385.88 | ||||||||
125 | 60 | COMMUNITY | Advertising | $ - | ||||||||
126 | Audit fees | $ - | ||||||||||
127 | Benefits | $2,815.74 | $73,905.60 | $65,165.31 | ||||||||
128 | Capital | $ - | ||||||||||
129 | Contractual services | $ - | -$2,808.00 | |||||||||
130 | Honoraria | $8,300.00 | $ - | -$47,618.18 | ||||||||
131 | Insurance | $ - | ||||||||||
132 | Legal fees | $ - | ||||||||||
133 | Office supplies | $5,712.42 | $ - | -$7,075.12 | ||||||||
134 | Other | $41,141.50 | $39,240.00 | -$108,004.55 | ||||||||
135 | Postage & frieght | $20.00 | $ - | |||||||||
136 | Repairs & maintenance | $3,624.00 | $3,281.25 | |||||||||
137 | Salaries | $56,430.06 | $369,528.00 | $242,256.77 | ||||||||
138 | Telecommunications | $1,875.00 | $ - | -$5,236.36 | ||||||||
139 | Training | $5,544.00 | $5,544.00 | |||||||||
140 | Travel | $42,269.48 | $5,112.00 | -$148,777.67 | ||||||||
141 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
142 | Rentals | $15,948.00 | $15,948.00 | |||||||||
143 | Membership fees | $ - | ||||||||||
144 | COMMUNITY Total | $158,564.20 | $522,393.60 | $22,167.45 | ||||||||
145 | 70 | Contractual services | $76.46 | -$2,638.34 | ||||||||
146 | Salaries | $176.67 | -$172.89 | |||||||||
147 | 0 Total | $253.13 | -$2,811.23 | |||||||||
148 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | |||||||
149 | Benefits | $918.32 | $9,503.16 | $6,313.41 | ||||||||
150 | Capital | $756.00 | $ - | |||||||||
151 | Contractual services | $21,025.00 | $ - | -$20,083.99 | ||||||||
152 | Honoraria | $ - | ||||||||||
153 | Insurance | $7,700.00 | $7,700.00 | |||||||||
154 | Legal fees | $ - | ||||||||||
155 | Office supplies | $12,465.95 | $ - | -$21,089.49 | ||||||||
156 | Other | $1,411.15 | $24,000.00 | $18,124.33 | ||||||||
157 | Postage & frieght | $35.00 | $ - | |||||||||
158 | Repairs & maintenance | $9,664.31 | $4,400.00 | -$39,061.56 | ||||||||
159 | Salaries | $41,843.88 | $105,310.44 | -$35,566.57 | ||||||||
160 | Training | $3,000.00 | $3,000.00 | |||||||||
161 | Travel | $4,391.18 | $24,000.00 | $10,857.02 | ||||||||
162 | Materials & supplies | $3,000.00 | $3,000.00 | |||||||||
163 | Rentals | $ - | ||||||||||
164 | Membership fees | $ - | ||||||||||
165 | Admin Fee | $9,120.00 | $9,120.00 | |||||||||
166 | Telecommunications & Utilities | $6,240.00 | $6,240.00 | |||||||||
167 | FISHERIES Total | $92,510.79 | $198,773.60 | -$48,946.84 | ||||||||
168 | 77 | ECONOMIC | Advertising | $6,000.00 | $6,000.00 | |||||||
169 | Audit fees | $ - | ||||||||||
170 | Benefits | $29,754.00 | $29,754.00 | |||||||||
171 | Capital | $10,000.00 | $10,000.00 | |||||||||
172 | Contractual services | $7,500.00 | -$62,054.45 | |||||||||
173 | Honoraria | $ - | ||||||||||
174 | Insurance | $ - | ||||||||||
175 | Legal fees | $ - | ||||||||||
176 | Office supplies | $ - | ||||||||||
177 | Other | $50,000.00 | $50,000.00 | |||||||||
178 | Postage & frieght | $ - | ||||||||||
179 | Repairs & maintenance | $22,500.00 | $22,500.00 | |||||||||
180 | Salaries | $148,794.00 | $148,794.00 | |||||||||
181 | Telecommunications | $3,000.00 | $3,000.00 | |||||||||
182 | Training | $ - | ||||||||||
183 | Travel | $ - | ||||||||||
184 | Materials & supplies | $14,000.00 | $14,000.00 | |||||||||
185 | Rentals | $ - | ||||||||||
186 | Membership fees | $ - | ||||||||||
187 | ECONOMIC Total | $291,548.00 | $221,993.55 | |||||||||
188 | 80 | HOUSING | Advertising | $ - | ||||||||
189 | Audit fees | $ - | ||||||||||
190 | Benefits | $1,522.08 | $15,301.26 | $10,085.06 | ||||||||
191 | Capital | $18,688.61 | $ - | -$59,521.29 | ||||||||
192 | Contractual services | $27,550.00 | $13,010.83 | -$10,236.44 | ||||||||
193 | Honoraria | $ - | -$3,163.64 | |||||||||
194 | Insurance | $1,131.00 | $36,707.44 | $35,460.77 | ||||||||
195 | Legal fees | $ - | ||||||||||
196 | Office supplies | $ - | -$9,260.77 | |||||||||
197 | Other | $14,999.00 | $13,575.55 | -$9,096.45 | ||||||||
198 | Postage & frieght | $3,573.50 | $2,091.26 | -$8,286.01 | ||||||||
199 | Repairs & maintenance | $40,751.89 | $57,775.90 | -$40,641.86 | ||||||||
200 | Salaries | $92,731.93 | $66,530.61 | -$236,265.96 | ||||||||
201 | Telecommunications | $124.85 | $124.85 | |||||||||
202 | Training | $ - | -$1,272.82 | |||||||||
203 | Travel | $3,924.77 | $1,324.90 | -$22,264.33 | ||||||||
204 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||
205 | Membership fees | $ - | ||||||||||
206 | Mortgage | $127,186.00 | $127,186.00 | |||||||||
207 | HOUSING Total | $204,872.78 | $336,083.55 | -$224,697.94 | ||||||||
208 | 90 | TREATY | Advertising | $ - | ||||||||
209 | Audit fees | $ - | ||||||||||
210 | Benefits | $ - | ||||||||||
211 | Capital | $ - | ||||||||||
212 | Contractual services | $1,800.00 | $1,800.00 | |||||||||
213 | Honoraria | $3,000.00 | $3,000.00 | |||||||||
214 | Insurance | $ - | ||||||||||
215 | Legal fees | $9,000.00 | $9,000.00 | |||||||||
216 | Office supplies | $ - | ||||||||||
217 | Other | $1,200.00 | $1,167.27 | |||||||||
218 | Postage & frieght | $ - | ||||||||||
219 | Repairs & maintenance | $ - | ||||||||||
220 | Salaries | $ - | ||||||||||
221 | Telecommunications | $ - | ||||||||||
222 | Training | $ - | ||||||||||
223 | Travel | $ - | -$125.84 | |||||||||
224 | Materials & supplies | $ - | ||||||||||
225 | Rentals | $ - | ||||||||||
226 | Membership fees | $ - | ||||||||||
227 | TREATY Total | $15,000.00 | $14,841.44 | |||||||||
228 | Grand Total | $2,621,734.18 | $5,013,988.38 | -$1,789,623.49 | ||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to June 30, 2017 | 3 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $341,030.70 | $1,364,122.80 | $1,165,417.48 | -$198,705.32 | Taaqwiihaak Deficit $175,000 | -$653,216.12 | ||||
4 | 25 | HEALTH | $219,382.59 | $877,530.36 | $875,796.46 | -$1,733.90 | FNHA Funding | -$101,928.12 | $75,000 added in FNHA funding | |||
5 | 30 | SOCDEV | $286,880.58 | $1,147,522.32 | $1,161,952.83 | $14,430.51 | -$654,364.53 | |||||
6 | 40 | CAPITAL | $672,679.57 | $2,690,718.28 | $2,699,494.00 | $8,775.72 | WWTP+Teacherage+Multiplex $1,600,000 | $322,348.36 | Prorated Actual | $705,000 added in WWTP DAR funding | ||
7 | 50 | OPSMAINT | $266,879.87 | $1,067,519.48 | $1,030,599.86 | -$36,919.62 | -$169,895.28 | $0.00 | $175,000 added WTP funding | |||
8 | 60 | COMMUNITY | $103,919.95 | $415,679.80 | $522,393.60 | $106,713.80 | -$267,749.15 | |||||
9 | 70 | FORESTRY | $253.13 | $1,012.52 | -$1,012.52 | $103.64 | ||||||
10 | 75 | FISHERIES | $77,641.15 | $310,564.60 | $286,773.60 | -$23,791.00 | Home Use not yet received | -$69,948.44 | $75,000 home use fish funding | |||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | Offset deficits in other departments | -$12,721.43 | |||||
12 | 80 | HOUSING | $151,072.45 | $604,289.80 | $523,583.55 | -$80,706.25 | CMHC RRAP revenue not yet rec'd | -$243,690.11 | ||||
13 | 90 | TREATY | $145.35 | $581.40 | $15,000.00 | $14,418.60 | $139.35 | |||||
14 | Grand Total | $2,119,885.34 | $8,479,541.36 | $8,572,559.38 | $93,018.02 | -$2,618,378.00 | ||||||
15 | $594,616.20 | $714,379.95 | ||||||||||
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 | 2,119,739.99 | ||||||||||
18 | MAP Budget are the budget numbers that Ahousaht needs to come in at or below. | 242,256.77 | ||||||||||
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 | 2016-17 | |||||||||||
21 | 2013-14 | 2014-15 | 2015-16 | Estimated | ||||||||
22 | Net Debt projected to end of year | 10,579,155 | 10,135,743 | 9,715,815 | 9,313,285 | It will take 21+ years to pay off all debt, at current rates | ||||||
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 | $31,080.33 | 25 | HEALTH | Dave | julia.atelo@ahousaht.ca | |||||
28 | Benefits | $21,970.65 | $115,274.87 | -$88,901.49 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $200.00 | $16,998.43 | $15,845.00 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $179,120.45 | $219,632.15 | -$145,974.69 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||
31 | Honoraria | $3,800.00 | -$1,745.45 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||
32 | Insurance | $1,124.00 | $ - | -$158.18 | 70 | FORESTRY | ||||||
33 | Legal fees | $62,836.25 | $62,836.25 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | |||||
34 | Office supplies | $13,246.27 | $ - | -$42,956.31 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $7,754.86 | $112,318.25 | $71,695.33 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $825.00 | $23,023.29 | $21,516.74 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $79,340.58 | $78,853.76 | |||||||||
38 | Salaries | $98,622.95 | $455,254.92 | -$8,993.62 | ||||||||
39 | Telecommunications | $300.00 | $20,396.21 | $17,832.21 | ||||||||
40 | Training | $8,952.35 | -$5,560.83 | |||||||||
41 | Travel | $14,066.52 | $12,863.45 | -$50,834.76 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $341,030.70 | $1,165,417.48 | -$42,255.99 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $ - | -$85.57 | |||||||||
47 | Contractual services | $40,311.74 | -$259,112.25 | |||||||||
48 | Honoraria | $500.00 | $ - | -$2,563.64 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $26,417.34 | $31,080.00 | -$82,642.16 | ||||||||
52 | Other | $16,582.71 | $5,796.00 | -$45,643.42 | ||||||||
53 | Postage & frieght | $130.00 | $ - | -$2,066.84 | ||||||||
54 | Repairs & maintenance | $509.65 | $31,500.00 | $28,623.87 | ||||||||
55 | Salaries | $93,394.45 | $361,596.00 | -$26,305.78 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $41,536.70 | $41,004.00 | -$142,977.45 | ||||||||
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 | $219,382.59 | $540,275.96 | -$463,473.26 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $2,069.02 | -$9,093.10 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $10,308.25 | -$52,657.42 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $4,345.60 | $ - | -$22,271.60 | ||||||||
72 | Other | $197,469.72 | $920,540.73 | $127,612.54 | ||||||||
73 | Repairs & maintenance | $445.24 | -$7,798.42 | |||||||||
74 | Salaries | $66,903.36 | $108,787.44 | -$161,521.52 | ||||||||
75 | Telecommunications | $ - | -$115.06 | |||||||||
76 | Training | $ - | ||||||||||
77 | Travel | $5,339.39 | $ - | -$38,947.56 | ||||||||
78 | Materials & supplies | $ - | ||||||||||
79 | Special Needs | $27,547.92 | $27,547.92 | |||||||||
80 | Gaurdian Financial Assistance | $ - | ||||||||||
81 | Admin Fee Office Supplies, Rent | $11,100.00 | $11,100.00 | |||||||||
82 | Assisted Living | $38,226.24 | $38,226.24 | |||||||||
83 | Disability | $8,200.00 | $8,200.00 | |||||||||
84 | SOCDEV Total | $286,880.58 | $1,114,402.33 | -$79,717.96 | ||||||||
85 | 40 | CAPITAL | Advertising | $ - | ||||||||
86 | Audit fees | $ - | ||||||||||
87 | Benefits | $ - | ||||||||||
88 | Capital | $ - | -$70,561.44 | |||||||||
89 | Contractual services | $600,058.82 | $427,494.00 | -$494,502.48 | ||||||||
90 | Honoraria | $ - | -$654.55 | |||||||||
91 | Insurance | $ - | ||||||||||
92 | Legal fees | $ - | ||||||||||
93 | Office supplies | $12,165.55 | $ - | -$81,196.71 | ||||||||
94 | Other | $119.20 | -$1,096.75 | |||||||||
95 | Postage & frieght | $10.00 | $ - | -$5,258.18 | ||||||||
96 | Repairs & maintenance | $1,448.21 | $50,000.04 | $41,318.40 | ||||||||
97 | Salaries | $12,772.21 | $ - | -$59,642.83 | ||||||||
98 | Telecommunications | $ - | -$565.09 | |||||||||
99 | Training | $688.80 | $ - | |||||||||
100 | Travel | $45,416.78 | $3,999.96 | -$49,177.20 | ||||||||
101 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
102 | Rentals | $ - | ||||||||||
103 | Membership fees | $ - | ||||||||||
104 | CAPITAL Total | $672,679.57 | $499,494.00 | -$703,336.82 | ||||||||
105 | 50 | OPSMAINT | Advertising | $ - | ||||||||
106 | Audit fees | $ - | ||||||||||
107 | Benefits | $1,563.94 | $41,999.98 | $34,531.34 | ||||||||
108 | Capital | $ - | -$3,372.37 | |||||||||
109 | Contractual services | $114,461.67 | $ - | -$188,528.05 | ||||||||
110 | Honoraria | $ - | ||||||||||
111 | Insurance | $ - | -$1,360.36 | |||||||||
112 | Legal fees | $ - | ||||||||||
113 | Office supplies | $51,390.91 | $ - | -$139,675.45 | ||||||||
114 | Other | $217.10 | $14,400.00 | $11,627.98 | ||||||||
115 | Postage & frieght | $2,891.32 | $ - | -$12,378.29 | ||||||||
116 | Repairs & maintenance | $3,864.41 | $54,000.00 | $17,045.67 | ||||||||
117 | Salaries | $82,223.18 | $209,999.88 | -$158,979.13 | ||||||||
118 | Telecommunications | $3,600.00 | $3,600.00 | |||||||||
119 | Training | $3,000.00 | $2,918.18 | |||||||||
120 | Travel | $10,267.34 | $ - | -$52,415.39 | ||||||||
121 | Materials & supplies | $ - | ||||||||||
122 | Rentals | $3,600.00 | $3,600.00 | |||||||||
123 | Membership fees | $ - | ||||||||||
124 | OPSMAINT Total | $266,879.87 | $330,599.86 | -$483,385.88 | ||||||||
125 | 60 | COMMUNITY | Advertising | $ - | ||||||||
126 | Audit fees | $ - | ||||||||||
127 | Benefits | $2,266.19 | $73,905.60 | $65,165.31 | ||||||||
128 | Capital | $ - | ||||||||||
129 | Contractual services | $ - | -$2,808.00 | |||||||||
130 | Honoraria | $6,200.00 | $ - | -$47,618.18 | ||||||||
131 | Insurance | $ - | ||||||||||
132 | Legal fees | $ - | ||||||||||
133 | Office supplies | $4,457.65 | $ - | -$7,075.12 | ||||||||
134 | Other | $14,981.20 | $39,240.00 | -$108,004.55 | ||||||||
135 | Postage & frieght | $20.00 | $ - | |||||||||
136 | Repairs & maintenance | $3,624.00 | $3,281.25 | |||||||||
137 | Salaries | $43,717.53 | $369,528.00 | $242,256.77 | ||||||||
138 | Telecommunications | $1,500.00 | $ - | -$5,236.36 | ||||||||
139 | Training | $5,544.00 | $5,544.00 | |||||||||
140 | Travel | $30,777.38 | $5,112.00 | -$148,777.67 | ||||||||
141 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
142 | Rentals | $15,948.00 | $15,948.00 | |||||||||
143 | Membership fees | $ - | ||||||||||
144 | COMMUNITY Total | $103,919.95 | $522,393.60 | $22,167.45 | ||||||||
145 | 70 | Contractual services | $76.46 | -$2,638.34 | ||||||||
146 | Salaries | $176.67 | -$172.89 | |||||||||
147 | 0 Total | $253.13 | -$2,811.23 | |||||||||
148 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | |||||||
149 | Benefits | $732.18 | $9,503.16 | $6,313.41 | ||||||||
150 | Capital | $ - | ||||||||||
151 | Contractual services | $19,525.00 | $ - | -$20,083.99 | ||||||||
152 | Honoraria | $ - | ||||||||||
153 | Insurance | $7,700.00 | $7,700.00 | |||||||||
154 | Legal fees | $ - | ||||||||||
155 | Office supplies | $12,465.95 | $ - | -$21,089.49 | ||||||||
156 | Other | $1,205.40 | $24,000.00 | $18,124.33 | ||||||||
157 | Postage & frieght | $35.00 | $ - | |||||||||
158 | Repairs & maintenance | $9,664.31 | $4,400.00 | -$39,061.56 | ||||||||
159 | Salaries | $30,799.66 | $105,310.44 | -$35,566.57 | ||||||||
160 | Training | $3,000.00 | $3,000.00 | |||||||||
161 | Travel | $3,213.65 | $24,000.00 | $10,857.02 | ||||||||
162 | Materials & supplies | $3,000.00 | $3,000.00 | |||||||||
163 | Rentals | $ - | ||||||||||
164 | Membership fees | $ - | ||||||||||
165 | Admin Fee | $9,120.00 | $9,120.00 | |||||||||
166 | Telecommunications & Utilities | $6,240.00 | $6,240.00 | |||||||||
167 | FISHERIES Total | $77,641.15 | $198,773.60 | -$48,946.84 | ||||||||
168 | 77 | ECONOMIC | Advertising | $6,000.00 | $6,000.00 | |||||||
169 | Audit fees | $ - | ||||||||||
170 | Benefits | $29,754.00 | $29,754.00 | |||||||||
171 | Capital | $10,000.00 | $10,000.00 | |||||||||
172 | Contractual services | $7,500.00 | -$62,054.45 | |||||||||
173 | Honoraria | $ - | ||||||||||
174 | Insurance | $ - | ||||||||||
175 | Legal fees | $ - | ||||||||||
176 | Office supplies | $ - | ||||||||||
177 | Other | $50,000.00 | $50,000.00 | |||||||||
178 | Postage & frieght | $ - | ||||||||||
179 | Repairs & maintenance | $22,500.00 | $22,500.00 | |||||||||
180 | Salaries | $148,794.00 | $148,794.00 | |||||||||
181 | Telecommunications | $3,000.00 | $3,000.00 | |||||||||
182 | Training | $ - | ||||||||||
183 | Travel | $ - | ||||||||||
184 | Materials & supplies | $14,000.00 | $14,000.00 | |||||||||
185 | Rentals | $ - | ||||||||||
186 | Membership fees | $ - | ||||||||||
187 | ECONOMIC Total | $291,548.00 | $221,993.55 | |||||||||
188 | 80 | HOUSING | Advertising | $ - | ||||||||
189 | Audit fees | $ - | ||||||||||
190 | Benefits | $1,163.10 | $15,301.26 | $10,085.06 | ||||||||
191 | Capital | $16,372.61 | $ - | -$59,521.29 | ||||||||
192 | Contractual services | $9,300.00 | $13,010.83 | -$10,236.44 | ||||||||
193 | Honoraria | $ - | -$3,163.64 | |||||||||
194 | Insurance | $1,131.00 | $36,707.44 | $35,460.77 | ||||||||
195 | Legal fees | $ - | ||||||||||
196 | Office supplies | $ - | -$9,260.77 | |||||||||
197 | Other | $11,075.87 | $13,575.55 | -$9,096.45 | ||||||||
198 | Postage & frieght | $3,518.50 | $2,091.26 | -$8,286.01 | ||||||||
199 | Repairs & maintenance | $35,950.34 | $57,775.90 | -$40,641.86 | ||||||||
200 | Salaries | $69,118.45 | $66,530.61 | -$236,265.96 | ||||||||
201 | Telecommunications | $124.85 | $124.85 | |||||||||
202 | Training | $ - | -$1,272.82 | |||||||||
203 | Travel | $3,442.58 | $1,324.90 | -$22,264.33 | ||||||||
204 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||
205 | Membership fees | $ - | ||||||||||
206 | Mortgage | $127,186.00 | $127,186.00 | |||||||||
207 | HOUSING Total | $151,072.45 | $336,083.55 | -$224,697.94 | ||||||||
208 | 90 | TREATY | Advertising | $ - | ||||||||
209 | Audit fees | $ - | ||||||||||
210 | Benefits | $ - | ||||||||||
211 | Capital | $ - | ||||||||||
212 | Contractual services | $1,800.00 | $1,800.00 | |||||||||
213 | Honoraria | $3,000.00 | $3,000.00 | |||||||||
214 | Insurance | $ - | ||||||||||
215 | Legal fees | $9,000.00 | $9,000.00 | |||||||||
216 | Office supplies | $ - | ||||||||||
217 | Other | $1,200.00 | $1,167.27 | |||||||||
218 | Postage & frieght | $ - | ||||||||||
219 | Repairs & maintenance | $ - | ||||||||||
220 | Salaries | $ - | ||||||||||
221 | Telecommunications | $ - | ||||||||||
222 | Training | $ - | ||||||||||
223 | Travel | $ - | -$125.84 | |||||||||
224 | Materials & supplies | $ - | ||||||||||
225 | Rentals | $ - | ||||||||||
226 | Membership fees | $ - | ||||||||||
227 | TREATY Total | $15,000.00 | $14,841.44 | |||||||||
228 | Grand Total | $2,119,739.99 | $5,013,988.38 | -$1,789,623.49 | ||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to May 31, 2017 | 2 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $213,715.52 | $1,282,293.12 | $1,165,417.48 | -$116,875.64 | Taaqwiihaak Deficit $175,000 | -$780,531.30 | ||||
4 | 25 | HEALTH | $153,376.04 | $920,256.24 | $840,275.96 | -$79,980.28 | FNHA Funding | -$167,934.67 | $75,000 added in FNHA funding | |||
5 | 30 | SOCDEV | $182,346.48 | $1,094,078.88 | $1,114,402.33 | $20,323.45 | -$758,898.63 | |||||
6 | 40 | CAPITAL | $539,767.87 | $3,238,607.22 | $3,099,494.00 | -$139,113.22 | Last yr invoices WWTP+Teacherage+Multiplex $1,600,000 | $189,436.66 | Prorated Actual | $705,000 added in WWTP DAR funding | ||
7 | 50 | OPSMAINT | $197,345.31 | $1,184,071.86 | $1,080,599.86 | -$103,472.00 | Sonbird catchup invoices | -$239,429.84 | $0.00 | $175,000 added WTP funding | ||
8 | 60 | COMMUNITY | $74,385.94 | $446,315.64 | $522,393.60 | $76,077.96 | -$297,283.16 | |||||
9 | 70 | FORESTRY | $76.46 | $458.76 | -$458.76 | -$73.03 | ||||||
10 | 75 | FISHERIES | $59,332.21 | $355,993.26 | $198,773.60 | -$157,219.66 | -$88,257.38 | $75,000 home use fish funding | ||||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | -$12,721.43 | ||||||
12 | 80 | HOUSING | $104,777.96 | $628,667.76 | $523,583.55 | -$105,084.21 | CMHC $187,500 | -$289,984.60 | ||||
13 | 90 | TREATY | $145.35 | $872.10 | $15,000.00 | $14,127.90 | $139.35 | |||||
14 | Grand Total | $1,525,269.14 | $9,151,614.84 | $8,851,488.38 | -$300,126.46 | -$3,212,994.20 | ||||||
15 | $737,624.03 | |||||||||||
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 | 1,525,123.79 | ||||||||||
18 | MAP Budget are the budget numbers that Ahousaht needs to come in at or below. | 242,256.77 | ||||||||||
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 | 2016-17 | |||||||||||
21 | 2013-14 | 2014-15 | 2015-16 | Estimated | ||||||||
22 | Net Debt projected to end of year | 10,579,155 | 10,135,743 | 9,715,815 | 9,313,285 | It will take 21+ years to pay off all debt, at current rates | ||||||
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 | $31,080.33 | 25 | HEALTH | Dave | julia.atelo@ahousaht.ca | |||||
28 | Benefits | $10,540.02 | $115,274.87 | -$88,901.49 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $16,998.43 | $15,845.00 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | |||||
30 | Contractual services | $109,261.85 | $219,632.15 | -$145,974.69 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||
31 | Honoraria | $3,800.00 | -$1,745.45 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||
32 | Insurance | $1,124.00 | $ - | -$158.18 | 70 | FORESTRY | ||||||
33 | Legal fees | $62,836.25 | $62,836.25 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | |||||
34 | Office supplies | $7,616.77 | $ - | -$42,956.31 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $7,720.77 | $112,318.25 | $71,695.33 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $805.00 | $23,023.29 | $21,516.74 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $79,340.58 | $78,853.76 | |||||||||
38 | Salaries | $58,544.89 | $455,254.92 | -$8,993.62 | ||||||||
39 | Telecommunications | $300.00 | $20,396.21 | $17,832.21 | ||||||||
40 | Training | $8,952.35 | -$5,560.83 | |||||||||
41 | Travel | $14,002.22 | $12,863.45 | -$50,834.76 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $213,715.52 | $1,165,417.48 | -$42,255.99 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $ - | -$85.57 | |||||||||
47 | Contractual services | $32,296.09 | -$259,112.25 | |||||||||
48 | Honoraria | $250.00 | $ - | -$2,563.64 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $15,366.57 | $31,080.00 | -$82,642.16 | ||||||||
52 | Other | $12,694.15 | $5,796.00 | -$45,643.42 | ||||||||
53 | Postage & frieght | $80.00 | $ - | -$2,066.84 | ||||||||
54 | Repairs & maintenance | $290.10 | $31,500.00 | $28,623.87 | ||||||||
55 | Salaries | $61,880.63 | $361,596.00 | -$26,305.78 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $30,518.50 | $41,004.00 | -$142,977.45 | ||||||||
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 | $153,376.04 | $540,275.96 | -$463,473.26 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $1,447.54 | -$9,093.10 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $7,729.10 | -$52,657.42 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $ - | -$22,271.60 | |||||||||
72 | Other | $125,590.89 | $920,540.73 | $127,612.54 | ||||||||
73 | Repairs & maintenance | $270.24 | -$7,798.42 | |||||||||
74 | Salaries | $45,904.08 | $108,787.44 | -$161,521.52 | ||||||||
75 | Telecommunications | $ - | -$115.06 | |||||||||
76 | Training | $ - | ||||||||||
77 | Travel | $1,404.63 | $ - | -$38,947.56 | ||||||||
78 | Materials & supplies | $ - | ||||||||||
79 | Special Needs | $27,547.92 | $27,547.92 | |||||||||
80 | Gaurdian Financial Assistance | $ - | ||||||||||
81 | Admin Fee Office Supplies, Rent | $11,100.00 | $11,100.00 | |||||||||
82 | Assisted Living | $38,226.24 | $38,226.24 | |||||||||
83 | Disability | $8,200.00 | $8,200.00 | |||||||||
84 | SOCDEV Total | $182,346.48 | $1,114,402.33 | -$79,717.96 | ||||||||
85 | 40 | CAPITAL | Advertising | $ - | ||||||||
86 | Audit fees | $ - | ||||||||||
87 | Benefits | $ - | ||||||||||
88 | Capital | $ - | -$70,561.44 | |||||||||
89 | Contractual services | $475,599.22 | $427,494.00 | -$494,502.48 | ||||||||
90 | Honoraria | $ - | -$654.55 | |||||||||
91 | Insurance | $ - | ||||||||||
92 | Legal fees | $ - | ||||||||||
93 | Office supplies | $12,165.55 | $ - | -$81,196.71 | ||||||||
94 | Other | $69.20 | -$1,096.75 | |||||||||
95 | Postage & frieght | $10.00 | $ - | -$5,258.18 | ||||||||
96 | Repairs & maintenance | $513.10 | $50,000.04 | $41,318.40 | ||||||||
97 | Salaries | $8,616.52 | $ - | -$59,642.83 | ||||||||
98 | Telecommunications | $ - | -$565.09 | |||||||||
99 | Training | $ - | ||||||||||
100 | Travel | $42,794.28 | $3,999.96 | -$49,177.20 | ||||||||
101 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
102 | Rentals | $ - | ||||||||||
103 | Membership fees | $ - | ||||||||||
104 | CAPITAL Total | $539,767.87 | $499,494.00 | -$703,336.82 | ||||||||
105 | 50 | OPSMAINT | Advertising | $ - | ||||||||
106 | Audit fees | $ - | ||||||||||
107 | Benefits | $1,097.16 | $41,999.98 | $34,531.34 | ||||||||
108 | Capital | $ - | -$3,372.37 | |||||||||
109 | Contractual services | $113,131.67 | $ - | -$188,528.05 | ||||||||
110 | Honoraria | $ - | ||||||||||
111 | Insurance | $ - | -$1,360.36 | |||||||||
112 | Legal fees | $ - | ||||||||||
113 | Office supplies | $12,176.07 | $ - | -$139,675.45 | ||||||||
114 | Other | $96.00 | $14,400.00 | $11,627.98 | ||||||||
115 | Postage & frieght | $2,871.32 | $ - | -$12,378.29 | ||||||||
116 | Repairs & maintenance | $3,718.06 | $54,000.00 | $17,045.67 | ||||||||
117 | Salaries | $55,779.06 | $209,999.88 | -$158,979.13 | ||||||||
118 | Telecommunications | $3,600.00 | $3,600.00 | |||||||||
119 | Training | $3,000.00 | $2,918.18 | |||||||||
120 | Travel | $8,475.97 | $ - | -$52,415.39 | ||||||||
121 | Materials & supplies | $ - | ||||||||||
122 | Rentals | $3,600.00 | $3,600.00 | |||||||||
123 | Membership fees | $ - | ||||||||||
124 | OPSMAINT Total | $197,345.31 | $330,599.86 | -$483,385.88 | ||||||||
125 | 60 | COMMUNITY | Advertising | $ - | ||||||||
126 | Audit fees | $ - | ||||||||||
127 | Benefits | $1,608.89 | $73,905.60 | $65,165.31 | ||||||||
128 | Capital | $ - | ||||||||||
129 | Contractual services | $ - | -$2,808.00 | |||||||||
130 | Honoraria | $4,900.00 | $ - | -$47,618.18 | ||||||||
131 | Insurance | $ - | ||||||||||
132 | Legal fees | $ - | ||||||||||
133 | Office supplies | $540.29 | $ - | -$7,075.12 | ||||||||
134 | Other | $13,581.30 | $39,240.00 | -$108,004.55 | ||||||||
135 | Postage & frieght | $20.00 | $ - | |||||||||
136 | Repairs & maintenance | $3,624.00 | $3,281.25 | |||||||||
137 | Salaries | $31,933.26 | $369,528.00 | $242,256.77 | ||||||||
138 | Telecommunications | $975.00 | $ - | -$5,236.36 | ||||||||
139 | Training | $5,544.00 | $5,544.00 | |||||||||
140 | Travel | $20,827.20 | $5,112.00 | -$148,777.67 | ||||||||
141 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
142 | Rentals | $15,948.00 | $15,948.00 | |||||||||
143 | Membership fees | $ - | ||||||||||
144 | COMMUNITY Total | $74,385.94 | $522,393.60 | $22,167.45 | ||||||||
145 | 70 | Contractual services | $76.46 | -$2,638.34 | ||||||||
146 | 0 Total | $76.46 | -$172.89 | |||||||||
147 | 75 | FISHERIES | Audit fees | $2,500.00 | -$2,811.23 | |||||||
148 | Benefits | $496.40 | $9,503.16 | $2,500.00 | ||||||||
149 | Capital | $ - | $6,313.41 | |||||||||
150 | Contractual services | $19,525.00 | $ - | |||||||||
151 | Honoraria | $ - | -$20,083.99 | |||||||||
152 | Insurance | $7,700.00 | ||||||||||
153 | Legal fees | $ - | $7,700.00 | |||||||||
154 | Office supplies | $8,670.09 | $ - | |||||||||
155 | Other | $17.30 | $24,000.00 | -$21,089.49 | ||||||||
156 | Postage & frieght | $35.00 | $ - | $18,124.33 | ||||||||
157 | Repairs & maintenance | $8,630.56 | $4,400.00 | |||||||||
158 | Salaries | $19,927.77 | $105,310.44 | -$39,061.56 | ||||||||
159 | Training | $3,000.00 | -$35,566.57 | |||||||||
160 | Travel | $2,030.09 | $24,000.00 | $3,000.00 | ||||||||
161 | Materials & supplies | $3,000.00 | $10,857.02 | |||||||||
162 | Rentals | $ - | $3,000.00 | |||||||||
163 | Membership fees | $ - | ||||||||||
164 | Admin Fee | $9,120.00 | ||||||||||
165 | Telecommunications & Utilities | $6,240.00 | $9,120.00 | |||||||||
166 | FISHERIES Total | $59,332.21 | $198,773.60 | $6,240.00 | ||||||||
167 | 77 | ECONOMIC | Advertising | $6,000.00 | -$48,946.84 | |||||||
168 | Audit fees | $ - | $6,000.00 | |||||||||
169 | Benefits | $29,754.00 | ||||||||||
170 | Capital | $10,000.00 | $29,754.00 | |||||||||
171 | Contractual services | $7,500.00 | $10,000.00 | |||||||||
172 | Honoraria | $ - | -$62,054.45 | |||||||||
173 | Insurance | $ - | ||||||||||
174 | Legal fees | $ - | ||||||||||
175 | Office supplies | $ - | ||||||||||
176 | Other | $50,000.00 | ||||||||||
177 | Postage & frieght | $ - | $50,000.00 | |||||||||
178 | Repairs & maintenance | $22,500.00 | ||||||||||
179 | Salaries | $148,794.00 | $22,500.00 | |||||||||
180 | Telecommunications | $3,000.00 | $148,794.00 | |||||||||
181 | Training | $ - | $3,000.00 | |||||||||
182 | Travel | $ - | ||||||||||
183 | Materials & supplies | $14,000.00 | ||||||||||
184 | Rentals | $ - | $14,000.00 | |||||||||
185 | Membership fees | $ - | ||||||||||
186 | ECONOMIC Total | $291,548.00 | ||||||||||
187 | 80 | HOUSING | Advertising | $ - | $221,993.55 | |||||||
188 | Audit fees | $ - | ||||||||||
189 | Benefits | $804.12 | $15,301.26 | |||||||||
190 | Capital | $16,372.61 | $ - | $10,085.06 | ||||||||
191 | Contractual services | $9,300.00 | $13,010.83 | -$59,521.29 | ||||||||
192 | Honoraria | $ - | -$10,236.44 | |||||||||
193 | Insurance | $1,131.00 | $36,707.44 | -$3,163.64 | ||||||||
194 | Legal fees | $ - | $35,460.77 | |||||||||
195 | Office supplies | $ - | ||||||||||
196 | Other | $9,096.83 | $13,575.55 | -$9,260.77 | ||||||||
197 | Postage & frieght | $2,333.50 | $2,091.26 | -$9,096.45 | ||||||||
198 | Repairs & maintenance | $18,333.38 | $57,775.90 | -$8,286.01 | ||||||||
199 | Salaries | $44,583.34 | $66,530.61 | -$40,641.86 | ||||||||
200 | Telecommunications | $124.85 | -$236,265.96 | |||||||||
201 | Training | $ - | $124.85 | |||||||||
202 | Travel | $2,823.18 | $1,324.90 | -$1,272.82 | ||||||||
203 | Materials & supplies | $2,454.96 | -$22,264.33 | |||||||||
204 | Membership fees | $ - | $2,454.96 | |||||||||
205 | Mortgage | $127,186.00 | ||||||||||
206 | HOUSING Total | $104,777.96 | $336,083.55 | $127,186.00 | ||||||||
207 | 90 | TREATY | Advertising | $ - | -$224,697.94 | |||||||
208 | Audit fees | $ - | ||||||||||
209 | Benefits | $ - | ||||||||||
210 | Capital | $ - | ||||||||||
211 | Contractual services | $1,800.00 | ||||||||||
212 | Honoraria | $3,000.00 | $1,800.00 | |||||||||
213 | Insurance | $ - | $3,000.00 | |||||||||
214 | Legal fees | $9,000.00 | ||||||||||
215 | Office supplies | $ - | $9,000.00 | |||||||||
216 | Other | $1,200.00 | ||||||||||
217 | Postage & frieght | $ - | $1,167.27 | |||||||||
218 | Repairs & maintenance | $ - | ||||||||||
219 | Salaries | $ - | ||||||||||
220 | Telecommunications | $ - | ||||||||||
221 | Training | $ - | ||||||||||
222 | Travel | $ - | ||||||||||
223 | Materials & supplies | $ - | -$125.84 | |||||||||
224 | Rentals | $ - | ||||||||||
225 | Membership fees | $ - | ||||||||||
226 | TREATY Total | $15,000.00 | ||||||||||
227 | Grand Total | $1,525,123.79 | $5,013,988.38 | $14,841.44 | ||||||||
228 | -$1,789,623.49 | |||||||||||
1 | 2016-17 Fiscal Year | April 1 to March 31, 2017 | 12 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $1,260,742.74 | $1,260,742.74 | $1,165,417.48 | -$95,325.26 | Taaqwiiak Litigation | $266,495.92 | ||||
4 | 25 | HEALTH | $1,097,330.71 | $1,097,330.71 | $1,152,503.96 | $55,173.25 | $776,020.00 | $75,000 added in FNHA funding | ||||
5 | 30 | SOCDEV | $1,196,535.46 | $1,196,535.46 | $1,314,402.33 | $117,866.87 | $255,290.35 | |||||
6 | 40 | CAPITAL | $1,340,834.99 | $1,340,834.99 | $1,410,675.00 | $69,840.01 | Nov 1: $109,048 Anderson Crk $57703 Skateboard Park | $990,503.78 | Prorated Actual | $705,000 added in WWTP DAR funding | ||
7 | 50 | OPSMAINT | $806,772.59 | $806,772.59 | $441,852.86 | -$364,919.73 | Capital + O&M offset | $369,997.44 | $0.00 | $175,000 added WTP funding | ||
8 | 60 | COMMUNITY | $491,772.89 | $491,772.89 | $522,393.60 | $30,620.71 | $120,103.79 | |||||
9 | 70 | FORESTRY | $2,576.96 | $2,576.96 | -$2,576.96 | $2,427.47 | ||||||
10 | 75 | FISHERIES | $238,122.79 | $238,122.79 | $286,773.60 | $48,650.81 | $90,533.20 | $75,000 home use fish funding | ||||
11 | 77 | ECONOMIC | $63,758.25 | $63,758.25 | $291,548.00 | $227,789.75 | $51,036.82 | |||||
12 | 80 | HOUSING | $552,199.19 | $552,199.19 | $2,164,300.55 | $1,612,101.36 | Nov 1: $30,000 NAHS1, $1020384 Multiplex, $77870 Renov, $44500+$15000 Immediate needs, $40000+$12500 Authority; $399,928+$73,332 Teacherages | $157,436.63 | ||||
13 | 90 | TREATY | $145.35 | $145.35 | $15,000.00 | $14,854.65 | $139.35 | |||||
14 | Grand Total | $7,050,791.92 | $7,050,791.92 | $8,764,867.38 | $1,714,075.46 | $2,312,528.58 | ||||||
15 | $3,079,984.75 | $730,405.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 | 7,050,791.92 | ||||||||||
18 | MAP Budget are the budget numbers that Ahousaht needs to come in at or below. | 242,256.77 | ||||||||||
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 | 2016-17 | |||||||||||
21 | 2013-14 | 2014-15 | 2015-16 | Estimated | ||||||||
22 | Net Debt projected to end of year | 10,579,155 | 10,135,743 | 9,715,815 | 9,313,285 | It will take 21+ years to pay off all debt, at current rates | ||||||
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 | $3,883.62 | $35,317.00 | $31,080.33 | 25 | HEALTH | Dave | julia.atelo@ahousaht.ca | ||||
28 | Benefits | $208,882.79 | $115,274.87 | -$88,901.49 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $1,057.31 | $16,998.43 | $15,845.00 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $404,095.35 | $219,632.15 | -$145,974.69 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||
31 | Honoraria | $1,900.00 | -$1,745.45 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||
32 | Insurance | $145.00 | $ - | -$158.18 | 70 | FORESTRY | ||||||
33 | Legal fees | $10,181.17 | $62,836.25 | $62,836.25 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | ||||
34 | Office supplies | $47,637.71 | $ - | -$42,956.31 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $38,206.88 | $112,318.25 | $71,695.33 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $1,501.00 | $23,023.29 | $21,516.74 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $446.25 | $79,340.58 | $78,853.76 | ||||||||
38 | Salaries | $459,247.29 | $455,254.92 | -$8,993.62 | ||||||||
39 | Telecommunications | $6,045.02 | $20,396.21 | $17,832.21 | ||||||||
40 | Training | $13,303.75 | $8,952.35 | -$5,560.83 | ||||||||
41 | Travel | $64,209.60 | $12,863.45 | -$50,834.76 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $1,260,742.74 | $1,165,417.48 | -$42,255.99 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $14,869.24 | $ - | -$85.57 | ||||||||
47 | Contractual services | $312,929.82 | -$259,112.25 | |||||||||
48 | Honoraria | $2,350.00 | $ - | -$2,563.64 | ||||||||
49 | Insurance | $400.00 | $ - | |||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $109,891.40 | $31,080.00 | -$82,642.16 | ||||||||
52 | Other | $64,338.50 | $5,796.00 | -$45,643.42 | ||||||||
53 | Postage & frieght | $1,974.60 | $ - | -$2,066.84 | ||||||||
54 | Repairs & maintenance | $2,636.45 | $31,500.00 | $28,623.87 | ||||||||
55 | Salaries | $385,275.59 | $361,596.00 | -$26,305.78 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $202,665.11 | $41,004.00 | -$142,977.45 | ||||||||
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,097,330.71 | $540,275.96 | -$463,473.26 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $9,066.74 | -$9,093.10 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $48,402.30 | -$52,657.42 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $24,615.63 | $ - | -$22,271.60 | ||||||||
72 | Other | $799,901.72 | $920,540.73 | $127,612.54 | ||||||||
73 | Repairs & maintenance | $8,538.00 | -$7,798.42 | |||||||||
74 | Salaries | $269,283.67 | $108,787.44 | -$161,521.52 | ||||||||
75 | Telecommunications | $105.47 | $ - | -$115.06 | ||||||||
76 | Training | $900.00 | $ - | |||||||||
77 | Travel | $35,721.93 | $ - | -$38,947.56 | ||||||||
78 | Materials & supplies | $ - | ||||||||||
79 | Special Needs | $27,547.92 | $27,547.92 | |||||||||
80 | Gaurdian Financial Assistance | $ - | ||||||||||
81 | Admin Fee Office Supplies, Rent | $11,100.00 | $11,100.00 | |||||||||
82 | Assisted Living | $38,226.24 | $38,226.24 | |||||||||
83 | Disability | $8,200.00 | $8,200.00 | |||||||||
84 | SOCDEV Total | $1,196,535.46 | $1,114,402.33 | -$79,717.96 | ||||||||
85 | 40 | CAPITAL | Advertising | $ - | ||||||||
86 | Audit fees | $ - | ||||||||||
87 | Benefits | $ - | ||||||||||
88 | Capital | $64,681.32 | $ - | -$70,561.44 | ||||||||
89 | Contractual services | $1,066,268.22 | $427,494.00 | -$494,502.48 | ||||||||
90 | Honoraria | $600.00 | $ - | -$654.55 | ||||||||
91 | Insurance | $ - | ||||||||||
92 | Legal fees | $ - | ||||||||||
93 | Office supplies | $74,430.32 | $ - | -$81,196.71 | ||||||||
94 | Other | $1,139.84 | -$1,096.75 | |||||||||
95 | Postage & frieght | $7,220.00 | $ - | -$5,258.18 | ||||||||
96 | Repairs & maintenance | $7,958.17 | $50,000.04 | $41,318.40 | ||||||||
97 | Salaries | $58,638.39 | $ - | -$59,642.83 | ||||||||
98 | Telecommunications | $518.00 | $ - | -$565.09 | ||||||||
99 | Training | $ - | ||||||||||
100 | Travel | $59,380.73 | $3,999.96 | -$49,177.20 | ||||||||
101 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
102 | Rentals | $ - | ||||||||||
103 | Membership fees | $ - | ||||||||||
104 | CAPITAL Total | $1,340,834.99 | $499,494.00 | -$703,336.82 | ||||||||
105 | 50 | OPSMAINT | Advertising | $ - | ||||||||
106 | Audit fees | $ - | ||||||||||
107 | Benefits | $7,818.91 | $41,999.98 | $34,531.34 | ||||||||
108 | Capital | $3,091.34 | $ - | -$3,372.37 | ||||||||
109 | Contractual services | $172,817.38 | $ - | -$188,528.05 | ||||||||
110 | Honoraria | $ - | ||||||||||
111 | Insurance | $1,247.00 | $ - | -$1,360.36 | ||||||||
112 | Legal fees | $ - | ||||||||||
113 | Office supplies | $140,134.56 | $ - | -$139,675.45 | ||||||||
114 | Other | $2,877.12 | $14,400.00 | $11,627.98 | ||||||||
115 | Postage & frieght | $11,451.77 | $ - | -$12,378.29 | ||||||||
116 | Repairs & maintenance | $34,904.99 | $54,000.00 | $17,045.67 | ||||||||
117 | Salaries | $380,722.94 | $209,999.88 | -$158,979.13 | ||||||||
118 | Telecommunications | $3,600.00 | $3,600.00 | |||||||||
119 | Training | $369.00 | $3,000.00 | $2,918.18 | ||||||||
120 | Travel | $51,337.58 | $ - | -$52,415.39 | ||||||||
121 | Materials & supplies | $ - | ||||||||||
122 | Rentals | $3,600.00 | $3,600.00 | |||||||||
123 | Membership fees | $ - | ||||||||||
124 | OPSMAINT Total | $806,772.59 | $330,599.86 | -$483,385.88 | ||||||||
125 | 60 | COMMUNITY | Advertising | $ - | ||||||||
126 | Audit fees | $ - | ||||||||||
127 | Benefits | $8,689.85 | $73,905.60 | $65,165.31 | ||||||||
128 | Capital | $ - | ||||||||||
129 | Contractual services | $2,574.00 | $ - | -$2,808.00 | ||||||||
130 | Honoraria | $48,550.00 | $ - | -$47,618.18 | ||||||||
131 | Insurance | $ - | ||||||||||
132 | Legal fees | $ - | ||||||||||
133 | Office supplies | $6,485.53 | $ - | -$7,075.12 | ||||||||
134 | Other | $140,969.13 | $39,240.00 | -$108,004.55 | ||||||||
135 | Postage & frieght | $ - | ||||||||||
136 | Repairs & maintenance | $314.19 | $3,624.00 | $3,281.25 | ||||||||
137 | Salaries | $126,551.19 | $369,528.00 | $242,256.77 | ||||||||
138 | Telecommunications | $5,400.00 | $ - | -$5,236.36 | ||||||||
139 | Training | $5,544.00 | $5,544.00 | |||||||||
140 | Travel | $152,239.00 | $5,112.00 | -$148,777.67 | ||||||||
141 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
142 | Rentals | $15,948.00 | $15,948.00 | |||||||||
143 | Membership fees | $ - | ||||||||||
144 | COMMUNITY Total | $491,772.89 | $522,393.60 | $22,167.45 | ||||||||
145 | 70 | Contractual services | $2,418.48 | -$2,638.34 | ||||||||
146 | Salaries | $158.48 | -$172.89 | |||||||||
147 | 0 Total | $2,576.96 | -$2,811.23 | |||||||||
148 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | |||||||
149 | Benefits | $3,172.14 | $9,503.16 | $6,313.41 | ||||||||
150 | Capital | $ - | ||||||||||
151 | Contractual services | $18,410.32 | $ - | -$20,083.99 | ||||||||
152 | Honoraria | $ - | ||||||||||
153 | Insurance | $7,700.00 | $7,700.00 | |||||||||
154 | Legal fees | $ - | ||||||||||
155 | Office supplies | $19,332.03 | $ - | -$21,089.49 | ||||||||
156 | Other | $5,920.25 | $24,000.00 | $18,124.33 | ||||||||
157 | Postage & frieght | $ - | ||||||||||
158 | Repairs & maintenance | $39,839.76 | $4,400.00 | -$39,061.56 | ||||||||
159 | Salaries | $139,400.56 | $105,310.44 | -$35,566.57 | ||||||||
160 | Training | $3,000.00 | $3,000.00 | |||||||||
161 | Travel | $12,047.73 | $24,000.00 | $10,857.02 | ||||||||
162 | Materials & supplies | $3,000.00 | $3,000.00 | |||||||||
163 | Rentals | $ - | ||||||||||
164 | Membership fees | $ - | ||||||||||
165 | Admin Fee | $9,120.00 | $9,120.00 | |||||||||
166 | Telecommunications & Utilities | $6,240.00 | $6,240.00 | |||||||||
167 | FISHERIES Total | $238,122.79 | $198,773.60 | -$48,946.84 | ||||||||
168 | 77 | ECONOMIC | Advertising | $6,000.00 | $6,000.00 | |||||||
169 | Audit fees | $ - | ||||||||||
170 | Benefits | $29,754.00 | $29,754.00 | |||||||||
171 | Capital | $10,000.00 | $10,000.00 | |||||||||
172 | Contractual services | $63,758.25 | $7,500.00 | -$62,054.45 | ||||||||
173 | Honoraria | $ - | ||||||||||
174 | Insurance | $ - | ||||||||||
175 | Legal fees | $ - | ||||||||||
176 | Office supplies | $ - | ||||||||||
177 | Other | $50,000.00 | $50,000.00 | |||||||||
178 | Postage & frieght | $ - | ||||||||||
179 | Repairs & maintenance | $22,500.00 | $22,500.00 | |||||||||
180 | Salaries | $148,794.00 | $148,794.00 | |||||||||
181 | Telecommunications | $3,000.00 | $3,000.00 | |||||||||
182 | Training | $ - | ||||||||||
183 | Travel | $ - | ||||||||||
184 | Materials & supplies | $14,000.00 | $14,000.00 | |||||||||
185 | Rentals | $ - | ||||||||||
186 | Membership fees | $ - | ||||||||||
187 | ECONOMIC Total | $63,758.25 | $291,548.00 | $221,993.55 | ||||||||
188 | 80 | HOUSING | Advertising | $ - | ||||||||
189 | Audit fees | $ - | ||||||||||
190 | Benefits | $5,183.58 | $15,301.26 | $10,085.06 | ||||||||
191 | Capital | $55,210.18 | $ - | -$59,521.29 | ||||||||
192 | Contractual services | $21,310.00 | $13,010.83 | -$10,236.44 | ||||||||
193 | Honoraria | $2,900.00 | $ - | -$3,163.64 | ||||||||
194 | Insurance | $1,142.78 | $36,707.44 | $35,460.77 | ||||||||
195 | Legal fees | $ - | ||||||||||
196 | Office supplies | $11,330.82 | $ - | -$9,260.77 | ||||||||
197 | Other | $26,778.88 | $13,575.55 | -$9,096.45 | ||||||||
198 | Postage & frieght | $10,447.50 | $2,091.26 | -$8,286.01 | ||||||||
199 | Repairs & maintenance | $92,768.89 | $57,775.90 | -$40,641.86 | ||||||||
200 | Salaries | $301,118.25 | $66,530.61 | -$236,265.96 | ||||||||
201 | Telecommunications | $124.85 | $124.85 | |||||||||
202 | Training | $1,166.75 | $ - | -$1,272.82 | ||||||||
203 | Travel | $22,841.56 | $1,324.90 | -$22,264.33 | ||||||||
204 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||
205 | Membership fees | $ - | ||||||||||
206 | Mortgage | $127,186.00 | $127,186.00 | |||||||||
207 | HOUSING Total | $552,199.19 | $336,083.55 | -$224,697.94 | ||||||||
208 | 90 | TREATY | Advertising | $ - | ||||||||
209 | Audit fees | $ - | ||||||||||
210 | Benefits | $ - | ||||||||||
211 | Capital | $ - | ||||||||||
212 | Contractual services | $1,800.00 | $1,800.00 | |||||||||
213 | Honoraria | $3,000.00 | $3,000.00 | |||||||||
214 | Insurance | $ - | ||||||||||
215 | Legal fees | $9,000.00 | $9,000.00 | |||||||||
216 | Office supplies | $ - | ||||||||||
217 | Other | $30.00 | $1,200.00 | $1,167.27 | ||||||||
218 | Postage & frieght | $ - | ||||||||||
219 | Repairs & maintenance | $ - | ||||||||||
220 | Salaries | $ - | ||||||||||
221 | Telecommunications | $ - | ||||||||||
222 | Training | $ - | ||||||||||
223 | Travel | $115.35 | $ - | -$125.84 | ||||||||
224 | Materials & supplies | $ - | ||||||||||
225 | Rentals | $ - | ||||||||||
226 | Membership fees | $ - | ||||||||||
227 | TREATY Total | $145.35 | $15,000.00 | $14,841.44 | ||||||||
228 | Grand Total | $7,050,791.92 | $5,013,988.38 | -$1,789,623.49 | ||||||||
1 | 2016-17 Fiscal Year | April 1 to February 28, 2017 | 11 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $1,107,034.01 | $1,207,673.47 | $1,268,458.48 | $60,785.01 | Expected to be on budget | $112,787.19 | ||||
4 | 25 | HEALTH | $920,103.45 | $1,003,749.22 | $1,152,503.96 | $148,754.74 | FNHA Retreats revenues received but not expensed | $598,792.74 | $75,000 added in FNHA funding | |||
5 | 30 | SOCDEV | $1,094,610.27 | $1,194,120.29 | $1,314,402.33 | $120,282.04 | Expected to be on budget | $153,365.16 | ||||
6 | 40 | CAPITAL | $1,102,594.92 | $1,202,830.82 | $1,883,935.00 | $681,104.18 | Nov 1: $109,048 Anderson Crk, $399,928+$73,332 Teacherages; $57703 Skateboard Park | $752,263.71 | Prorated Actual | $705,000 added in WWTP DAR funding | ||
7 | 50 | OPSMAINT | $746,153.59 | $813,985.73 | $441,852.86 | -$372,132.87 | Nov 1: $71253; Ops & Capital Offset | $309,378.44 | $0.00 | $175,000 added WTP funding | ||
8 | 60 | COMMUNITY | $458,540.64 | $500,226.15 | $522,393.60 | $22,167.45 | Expected to be on budget | $86,871.54 | ||||
9 | 70 | FORESTRY | $2,576.96 | $2,811.23 | -$2,811.23 | Expected to be on budget | $2,427.47 | |||||
10 | 75 | FISHERIES | $227,077.07 | $247,720.44 | $286,773.60 | $39,053.16 | Expected to be on budget | $79,487.48 | $75,000 home use fish funding | |||
11 | 77 | ECONOMIC | $63,758.25 | $69,554.45 | $291,548.00 | $221,993.55 | Expected to be on budget | $51,036.82 | ||||
12 | 80 | HOUSING | $514,049.70 | $560,781.49 | $1,691,040.55 | $1,130,259.06 | Nov 1: $30,000 NAHS1, $1020384 Multiplex, $77870 Renov, $44500+$15000 Immediate needs, $40000+$12500 Authority | $119,287.14 | ||||
13 | 90 | TREATY | $145.35 | $158.56 | $15,000.00 | $14,841.44 | Expected to be on budget | $139.35 | ||||
14 | Grand Total | $6,236,644.21 | $6,803,611.87 | $8,867,908.38 | $2,064,296.51 | $1,498,380.87 | ||||||
15 | $2,265,837.04 | $738,992.37 | ||||||||||
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,236,644.21 | ||||||||||
18 | MAP Budget are the budget numbers that Ahousaht needs to come in at or below. | 242,256.77 | ||||||||||
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 | 2016-17 | |||||||||||
21 | 2013-14 | 2014-15 | 2015-16 | Estimated | ||||||||
22 | Net Debt projected to end of year | 10,579,155 | 10,135,743 | 9,715,815 | 9,313,285 | It will take 21+ years to pay off all debt, at current rates | ||||||
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 | $3,883.62 | $35,317.00 | $31,080.33 | 25 | HEALTH | Dave | julia.atelo@ahousaht.ca | ||||
28 | Benefits | $187,161.66 | $115,274.87 | -$88,901.49 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $1,057.31 | $16,998.43 | $15,845.00 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $335,139.60 | $219,632.15 | -$145,974.69 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||
31 | Honoraria | $1,600.00 | -$1,745.45 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||
32 | Insurance | $145.00 | $ - | -$158.18 | 70 | FORESTRY | ||||||
33 | Legal fees | $62,836.25 | $62,836.25 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | |||||
34 | Office supplies | $39,376.62 | $ - | -$42,956.31 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $37,237.68 | $112,318.25 | $71,695.33 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $1,381.00 | $23,023.29 | $21,516.74 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $446.25 | $79,340.58 | $78,853.76 | ||||||||
38 | Salaries | $425,561.16 | $455,254.92 | -$8,993.62 | ||||||||
39 | Telecommunications | $2,350.33 | $20,396.21 | $17,832.21 | ||||||||
40 | Training | $13,303.75 | $8,952.35 | -$5,560.83 | ||||||||
41 | Travel | $58,390.03 | $12,863.45 | -$50,834.76 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $1,107,034.01 | $1,165,417.48 | -$42,255.99 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $78.44 | $ - | -$85.57 | ||||||||
47 | Contractual services | $237,519.56 | -$259,112.25 | |||||||||
48 | Honoraria | $2,350.00 | $ - | -$2,563.64 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $104,245.31 | $31,080.00 | -$82,642.16 | ||||||||
52 | Other | $47,152.80 | $5,796.00 | -$45,643.42 | ||||||||
53 | Postage & frieght | $1,894.60 | $ - | -$2,066.84 | ||||||||
54 | Repairs & maintenance | $2,636.45 | $31,500.00 | $28,623.87 | ||||||||
55 | Salaries | $355,576.63 | $361,596.00 | -$26,305.78 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $168,649.66 | $41,004.00 | -$142,977.45 | ||||||||
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 | $920,103.45 | $540,275.96 | -$463,473.26 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $8,335.34 | -$9,093.10 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $48,269.30 | -$52,657.42 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $20,415.63 | $ - | -$22,271.60 | ||||||||
72 | Other | $726,850.84 | $920,540.73 | $127,612.54 | ||||||||
73 | Repairs & maintenance | $7,148.55 | -$7,798.42 | |||||||||
74 | Salaries | $247,783.21 | $108,787.44 | -$161,521.52 | ||||||||
75 | Telecommunications | $105.47 | $ - | -$115.06 | ||||||||
76 | Training | $ - | ||||||||||
77 | Travel | $35,701.93 | $ - | -$38,947.56 | ||||||||
78 | Materials & supplies | $ - | ||||||||||
79 | Special Needs | $27,547.92 | $27,547.92 | |||||||||
80 | Gaurdian Financial Assistance | $ - | ||||||||||
81 | Admin Fee Office Supplies, Rent | $11,100.00 | $11,100.00 | |||||||||
82 | Assisted Living | $38,226.24 | $38,226.24 | |||||||||
83 | Disability | $8,200.00 | $8,200.00 | |||||||||
84 | SOCDEV Total | $1,094,610.27 | $1,114,402.33 | -$79,717.96 | ||||||||
85 | 40 | CAPITAL | Advertising | $ - | ||||||||
86 | Audit fees | $ - | ||||||||||
87 | Benefits | $ - | ||||||||||
88 | Capital | $64,681.32 | $ - | -$70,561.44 | ||||||||
89 | Contractual services | $845,163.44 | $427,494.00 | -$494,502.48 | ||||||||
90 | Honoraria | $600.00 | $ - | -$654.55 | ||||||||
91 | Insurance | $ - | ||||||||||
92 | Legal fees | $ - | ||||||||||
93 | Office supplies | $74,430.32 | $ - | -$81,196.71 | ||||||||
94 | Other | $1,005.35 | -$1,096.75 | |||||||||
95 | Postage & frieght | $4,820.00 | $ - | -$5,258.18 | ||||||||
96 | Repairs & maintenance | $7,958.17 | $50,000.04 | $41,318.40 | ||||||||
97 | Salaries | $54,672.59 | $ - | -$59,642.83 | ||||||||
98 | Telecommunications | $518.00 | $ - | -$565.09 | ||||||||
99 | Training | $ - | ||||||||||
100 | Travel | $48,745.73 | $3,999.96 | -$49,177.20 | ||||||||
101 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
102 | Rentals | $ - | ||||||||||
103 | Membership fees | $ - | ||||||||||
104 | CAPITAL Total | $1,102,594.92 | $499,494.00 | -$703,336.82 | ||||||||
105 | 50 | OPSMAINT | Advertising | $ - | ||||||||
106 | Audit fees | $ - | ||||||||||
107 | Benefits | $6,846.25 | $41,999.98 | $34,531.34 | ||||||||
108 | Capital | $3,091.34 | $ - | -$3,372.37 | ||||||||
109 | Contractual services | $172,817.38 | $ - | -$188,528.05 | ||||||||
110 | Honoraria | $ - | ||||||||||
111 | Insurance | $1,247.00 | $ - | -$1,360.36 | ||||||||
112 | Legal fees | $ - | ||||||||||
113 | Office supplies | $128,035.83 | $ - | -$139,675.45 | ||||||||
114 | Other | $2,541.02 | $14,400.00 | $11,627.98 | ||||||||
115 | Postage & frieght | $11,346.77 | $ - | -$12,378.29 | ||||||||
116 | Repairs & maintenance | $33,874.80 | $54,000.00 | $17,045.67 | ||||||||
117 | Salaries | $338,230.76 | $209,999.88 | -$158,979.13 | ||||||||
118 | Telecommunications | $3,600.00 | $3,600.00 | |||||||||
119 | Training | $75.00 | $3,000.00 | $2,918.18 | ||||||||
120 | Travel | $48,047.44 | $ - | -$52,415.39 | ||||||||
121 | Materials & supplies | $ - | ||||||||||
122 | Rentals | $3,600.00 | $3,600.00 | |||||||||
123 | Membership fees | $ - | ||||||||||
124 | OPSMAINT Total | $746,153.59 | $330,599.86 | -$483,385.88 | ||||||||
125 | 60 | COMMUNITY | Advertising | $ - | ||||||||
126 | Audit fees | $ - | ||||||||||
127 | Benefits | $8,011.93 | $73,905.60 | $65,165.31 | ||||||||
128 | Capital | $ - | ||||||||||
129 | Contractual services | $2,574.00 | $ - | -$2,808.00 | ||||||||
130 | Honoraria | $43,650.00 | $ - | -$47,618.18 | ||||||||
131 | Insurance | $ - | ||||||||||
132 | Legal fees | $ - | ||||||||||
133 | Office supplies | $6,485.53 | $ - | -$7,075.12 | ||||||||
134 | Other | $134,974.17 | $39,240.00 | -$108,004.55 | ||||||||
135 | Postage & frieght | $ - | ||||||||||
136 | Repairs & maintenance | $314.19 | $3,624.00 | $3,281.25 | ||||||||
137 | Salaries | $116,665.29 | $369,528.00 | $242,256.77 | ||||||||
138 | Telecommunications | $4,800.00 | $ - | -$5,236.36 | ||||||||
139 | Training | $5,544.00 | $5,544.00 | |||||||||
140 | Travel | $141,065.53 | $5,112.00 | -$148,777.67 | ||||||||
141 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
142 | Rentals | $15,948.00 | $15,948.00 | |||||||||
143 | Membership fees | $ - | ||||||||||
144 | COMMUNITY Total | $458,540.64 | $522,393.60 | $22,167.45 | ||||||||
145 | 70 | Contractual services | $2,418.48 | -$2,638.34 | ||||||||
146 | Salaries | $158.48 | -$172.89 | |||||||||
147 | 0 Total | $2,576.96 | -$2,811.23 | |||||||||
148 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | |||||||
149 | Benefits | $2,923.94 | $9,503.16 | $6,313.41 | ||||||||
150 | Capital | $ - | ||||||||||
151 | Contractual services | $18,410.32 | $ - | -$20,083.99 | ||||||||
152 | Honoraria | $ - | ||||||||||
153 | Insurance | $7,700.00 | $7,700.00 | |||||||||
154 | Legal fees | $ - | ||||||||||
155 | Office supplies | $19,332.03 | $ - | -$21,089.49 | ||||||||
156 | Other | $5,386.03 | $24,000.00 | $18,124.33 | ||||||||
157 | Postage & frieght | $ - | ||||||||||
158 | Repairs & maintenance | $39,839.76 | $4,400.00 | -$39,061.56 | ||||||||
159 | Salaries | $129,137.26 | $105,310.44 | -$35,566.57 | ||||||||
160 | Training | $3,000.00 | $3,000.00 | |||||||||
161 | Travel | $12,047.73 | $24,000.00 | $10,857.02 | ||||||||
162 | Materials & supplies | $3,000.00 | $3,000.00 | |||||||||
163 | Rentals | $ - | ||||||||||
164 | Membership fees | $ - | ||||||||||
165 | Admin Fee | $9,120.00 | $9,120.00 | |||||||||
166 | Telecommunications & Utilities | $6,240.00 | $6,240.00 | |||||||||
167 | FISHERIES Total | $227,077.07 | $198,773.60 | -$48,946.84 | ||||||||
168 | 77 | ECONOMIC | Advertising | $6,000.00 | $6,000.00 | |||||||