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 | 2017-18 | 2018-19 | Increase | Apr 01 | Program Description | |||||||||||||||||||||
4 | Renewal - 2 + 1 year renewal (last year under outside of MAP) | First Pmt | INAC Approved Aug 2015 | 96,338.00 | WCC | July 2015 | 21,220.18 | Chq# | 101 buildings renovations | NG00 | Band Admin | 570,698.40 | 619,173.00 | 643,291.00 | 8.49% | 133153.35 | x | NG00 - IGS - BAND 1 378.A0920.NG00.10659.A0000.82431 $153,971.00 | |||||||||||||||||
5 | Housing Streams 1, 2, 3, Stacy MacNeil, | Rec'd Jan 4, 2016 | Aug 2015 | 10,941.50 | 70100 | -101 | 70100 | REPAIR | EXPENSE | 873.6 | NP00 | AEA School | 3,167,152.30 | 3,347,285.00 | 3,477,667.00 | 5.69% | x | NP00 - ELEMENTARY/SECONDARY 1 378.A0920.NP00.10659.A0000.82431 $832,379.00 | |||||||||||||||||
6 | Self Governance | WCC | 85,000.00 | Sep 2015 | 7,695.00 | 70150 | -101 | 70150 | FUEL | EXPENSE | 176 | NP50 | AEA Post Secondary | 754,762.95 | 797,691.00 | 828,761.00 | 5.69% | x | NP50 - POST SECONDARY EDUCATION 1 378.A0920.NP50.10659.A0000.82431 $198,364.00 | ||||||||||||||||
7 | OSR Clawback (Blue Book) | Proj Leader | 6,000.00 | Oct 2015 | 10,067.50 | 70200 | -101 | 70200 | ADMIN | EXPENSE | 815 | NP80 | Income Assistance | 1,166,289.85 | 1,282,379.00 | 1,332,329.00 | 9.95% | x | NP80 - INCOME ASSISTANCE 1 378.A0920.NP80.10659.A0000.82431 $318,893.00 | ||||||||||||||||
8 | Community Comprehensive Plan (CCP) >$75k (Contacted Feb 17 2016 CCP Comm Comprehensive Plan Wendy Cheney or Paul Miller acting 604-868-3250) | Band Admin | 5,338.00 | Nov 2015 | 13,898.83 | 70275 | -101 | 70275 | SUPPLIES | EXP | 32,672.46 | NPC0 | Assisted Living | 95,062.40 | 104,525.00 | 108,596.00 | 9.95% | x | NPC0 - ASSISTED LIVING - BLOCK 1 378.A0920.NPC0.10659.A0000.82431 $25,992.00 | ||||||||||||||||
9 | 96,338.00 | Dec 2015 | 18,304.89 | 70350 | -101 | 70350 | CONTRACTS | EXP | 6,056.82 | NPG0 | Membership | 11,307.40 | 11,951.00 | 12,416.00 | 5.69% | 2570.4 | x | NPG0 - LTS CORE-REGIS&MEMBERSHIP 1 313.A0920.NPG0.10659.A0000.82431 $2,972.00 | |||||||||||||||||
10 | Admin | Contingency | 41,000.00 | 70375 | -101 | 70375 | EQUIPMENT | PURCHASED | 1,100.04 | NT40 | Economic Devel | 88,777.10 | 93,826.00 | 97,481.00 | 5.69% | x | NT40 - LEDSP-EcDev-Allocations 1 378.A0920.NT40.10659.A0000.82431 $19,832.20 | ||||||||||||||||||
11 | Year End Prep (reclassifications of charges - capital) | WCC Total | 82,127.90 | 2,872.10 | 70400 | -101 | 70400 | FREIGHT | EXPENSES | 1,308.00 | NTH1 | AEA O&M | 14,415.15 | 17,254.00 | 17,926.00 | 19.69% | x | NTH1 - EDU - FACILITIES O&M 1 378.A0920.NTH1.10659.A0000.82431 $3,647.35 | |||||||||||||||||
12 | Strategic Planning - updates every 6 months, community involvement | Second pmt | INAC Approved Sept 2015 | 115,303.00 | 75000 | -101 | 75000 | ADMINITRATION | FEES | 6,072.67 | NTK0 | Housing Ops | 270,063.70 | 323,250.00 | 335,841.00 | 19.69% | x | NTK0 - HOUSING 1 378.A0920.NTK0.10659.A0000.82431 $68,326.40 | |||||||||||||||||
13 | Emergency Preparedness - Emergency Response Center (Jody Kaden) | band admin | 2,806.00 | GrPacific | Oct 2015 | 5,470.48 | chq 2535 20160116 | 80350 | -101 | 80350 | WATER | TAXI | 1,075.00 | NTM0 | Capital | 405,094.70 | 484,875.00 | 503,762.00 | 19.69% | x | NTM0 - OTHER - CAPITAL 1 378.A0920.NTM0.10659.A0000.82431 $102,488.75 | ||||||||||||||
14 | Grants/ Funding In | Total | 118,109.00 | Nov 2015 | 10,108.92 | chq 2535 20160116 | 80400 | -101 | 80400 | WAGES | EXPENSE | 56,066.47 | NTM1 | Ops & Maint | 322,825.75 | 200,847.00 | 208,670.00 | -37.78% | x | NTM1 - OTHER - FACILITIES O&M 1 378.A0920.NTM1.10659.A0000.82431 $81,674.80 | |||||||||||||||
15 | HR Policy / Staff Meeting March | Contingency | 22,580.00 | Dec 2015 | 14,837.43 | chq 19 20160128 | 80450 | -101 | 80450 | EI | EXPENSE | 5,852.79 | Waste & Wastewater | 185,557.00 | 192,785.00 | ||||||||||||||||||||
16 | Community Communication Initiative- Emergency Phones | Net payment | 95,529.00 | 80500 | -101 | 80500 | CPP | EXPENSE | 771.15 | Grand Total | Grand Total | 6,866,449.70 | 7,468,613.00 | 8.77% | |||||||||||||||||||||
17 | Community Planning Initiative (CCP) | 80550 | -101 | 80550 | WCB | EXPENSE | 3,179.76 | x | Water & Wastewater Operations | ||||||||||||||||||||||||||
18 | Debt Reduction - two loans, possibly NEDC Loan | Golder | 2/22/2016 | 1337.7 | inv 744236 | 80600 | -101 | 80600 | PENSION | PLAN | 3,609.96 | 119,629.72 | NPE0 - PREVENTION PROJECTS (2015/16 Family Violence Protection ) 1 355.A093D.NPE0.10659.A0000.82431 $14,013.00 | ||||||||||||||||||||||
19 | OH&S | NPE0 | 14,013.00 | ||||||||||||||||||||||||||||||||
20 | Report prep/submissions | 12/22/2015 | 28,584.40 | INVOICE 731947 DEC 22/2015 $ 28584.40 CHEQUE # 10-002421O/S | 102 | equipment | NTMV | 95,580.00 | TBD | ||||||||||||||||||||||||||
21 | Treaty Loan - Nancy | Contingency | INAC Approved | 41,000.00 | INVOICE 20150603 JUNE 3 /2015 $ 300.00 CHEQUE # 50-000251 R | 70100 | -102 | 70100 | REPAIR | EXPENSE | 4,190.75 | New 2016-17 | 66,906.00 | ||||||||||||||||||||||
22 | Asked release Dec 2015 | 22,580.00 | 31,754.53 | INVOICE 515432 JUNE 12/2012 $ 617.50 CHEQUE # 10-000050 R | 70150 | -102 | 70150 | FUEL | EXPENSE | 1,443.41 | Total | 6,976,042.70 | 7,468,613.00 | A | 7.06% | ||||||||||||||||||||
23 | Housing | 18,420.00 | INVOICE 529411 FEB 19/2013 $ 29009.79 CHEQUE # 10-000071R | 70175 | -102 | 70175 | EQUIP | RENTAL | 264.22 | Total Education | 3,936,330.40 | 4,162,230.00 | 5.74% | ||||||||||||||||||||||
24 | Toolkit of agreements, templates | WCC | INVOICE 529411 FEB 19 2013 $ 29009.79 CHECQUE # 10-000080 O/S | 70275 | -102 | 70275 | SUPPLIES | EXP | 5,103.58 | Total Admin | 3,039,712.30 | 3,306,383.00 | 8.77% | ||||||||||||||||||||||
25 | Private Homes Repairs, Completions: Need accounting from owner | 2015 Fees | 149,240.00 | 70350 | -102 | 70350 | CONTRACTS | EXP | 5,823.65 | ||||||||||||||||||||||||||
26 | Rental Repairs | Travel | 13,340.00 | 70375 | -102 | 70375 | EQUIPMENT | PURCHASED | 4,491.71 | Cash Flow | |||||||||||||||||||||||||
27 | Rent to Own | Mileage | 4,400.00 | 70400 | -102 | 70400 | FREIGHT | EXPENSES | 778 | Apr | 1,889,559.00 | 10,705.00 | 1,900,264.00 | ||||||||||||||||||||||
28 | Boat | 1,040.00 | 70550 | -102 | 70550 | INSURANCE | EXP. | 1,186.00 | May | 619,895.00 | 8,029.00 | 627,924.00 | |||||||||||||||||||||||
29 | Capital | Accommodations | 2,550.00 | 70575 | -102 | 70575 | INTEREST | EXP. | 1.16 | June | 619,895.00 | 8,029.00 | 627,924.00 | ||||||||||||||||||||||
30 | WWTP | Meals | 2,700.00 | 80350 | -102 | 80350 | WATER | TAXI | 940 | 24,222.48 | July | 619,895.00 | 8,029.00 | 627,924.00 | |||||||||||||||||||||
31 | Anderson Creek | Total | 173,270.00 | 105 stock | Aug | 619,895.00 | 8,029.00 | 627,924.00 | |||||||||||||||||||||||||||
32 | Gym Seismic Upgrade | 70150 | -105 | 70150 | FUEL | EXPENSE | 2,307.47 | Sep | 619,895.00 | 8,029.00 | 627,924.00 | ||||||||||||||||||||||||
33 | Past Project - School Deficiencies | Estimated | 70275 | -105 | 70275 | SUPPLIES | EXP | 10,542.52 | Oct | 619,895.00 | 8,029.00 | 627,924.00 | |||||||||||||||||||||||
34 | Capital Project Officer | Cost 2016………….. $ 33,100.00 | 33,100.00 | 70350 | -105 | 70350 | CONTRACTS | EXP | 8,491.95 | Nov | 619,895.00 | 8,027.00 | 627,922.00 | ||||||||||||||||||||||
35 | Chuchimhyiip Medical Building Retrofit/Expansion | Cost 2017…………… $ 32,000.00 | 32,000.00 | 70375 | -105 | 70375 | EQUIPMENT | PURCHASED | 811.42 | Dec | 619,895.00 | 619,895.00 | |||||||||||||||||||||||
36 | FNIIP Infrastructure planning Wish List Summer planning, implement plan in Fall | Cost 2018 …………… $ 62,500.00 | 62,500.00 | 70400 | -105 | 70400 | FREIGHT | EXPENSES | 251 | Jan | 619,894.00 | 619,894.00 | |||||||||||||||||||||||
37 | Mini Mall | Cost 2019 ………….…$ 33,000.00 | 33,000.00 | 70425 | -105 | 70425 | FUEL | EXPENSE | 69.54 | Feb | |||||||||||||||||||||||||
38 | Cost 2020 ………….. $ 40,300.00 | 40,300.00 | 80350 | -105 | 80350 | WATER | TAXI | 20 | 22,493.90 | 166,346.10 | Mar | ||||||||||||||||||||||||
39 | Fisheries | 7,468,613.00 | 66,906.00 | ||||||||||||||||||||||||||||||||
40 | AFC Working Group | 7,535,519.00 | B | ||||||||||||||||||||||||||||||||
41 | Commitments to working more positive | ||||||||||||||||||||||||||||||||||
42 | Trial to be held in Ahousaht March 9 | ||||||||||||||||||||||||||||||||||
43 | 2/27/2016 | Account | Description | Debit | Credit | Company From | Company To | NPG0 - LTS CORE-REGIS&MEMBERSHIP 1 313.A0920.NPG0.10659.A0000.82431 $2,570.40 | 2,570.40 | ||||||||||||||||||||||||||
44 | Medical | 70100 | -101 | REPAIR | EXPENSE | 0.10 | 50-70100-101 | 40-70100-101 | entered Feb 29, 2016 | NG00 - IGS - BAND 1 378.A0920.NG00.10659.A0000.82431 $133,153.35 | 133,153.35 | ||||||||||||||||||||||||
45 | Chuchimhyiip Medical Building Retrofit/Expansion | 70275 | -101 | SUPPLIES | EXP | 802.57 | 50-70275-101 | 40-70275-101 | entered Feb 29, 2016 | NP00 - ELEMENTARY/SECONDARY 1 378.A0920.NP00.10659.A0000.82431 $719,833.55 | 719,833.55 | 719,833.55 | |||||||||||||||||||||||
46 | Health $500k expansion | 80350 | -101 | WATER | TAXI | 80.00 | 50-80350-101 | 40-80350-101 | entered Feb 29, 2016 | NP50 - POST SECONDARY EDUCATION 1 378.A0920.NP50.10659.A0000.82431 $171,543.60 | 171,543.60 | 171,543.60 | |||||||||||||||||||||||
47 | 80400 | -101 | WAGES | EXPENSE | 3,802.12 | 50-80400-101 | 40-80400-101 | entered Feb 29, 2016 | NP80 - INCOME ASSISTANCE 1 378.A0920.NP80.10659.A0000.82431 $275,775.70 | 275,775.70 | |||||||||||||||||||||||||
48 | Land Claim | 80450 | -101 | EI | EXPENSE | 367.76 | 50-80450-101 | 40-80450-101 | entered Feb 29, 2016 | NPC0 - ASSISTED LIVING - BLOCK 1 378.A0920.NPC0.10659.A0000.82431 $22,478.25 | 22,478.25 | ||||||||||||||||||||||||
49 | Tribunal Hearing in Tofino July 22,23,24 | 80500 | -101 | CPP | EXPENSE | 25.73 | 50-80500-101 | 40-80500-101 | entered Feb 29, 2016 | NT40 - LEDSP-EcDev-Allocations 1 378.A0920.NT40.10659.A0000.82431 $20,177.30 | 20,177.30 | ||||||||||||||||||||||||
50 | 80550 | -101 | WCB | EXPENSE | 199.81 | 50-80550-101 | 40-80550-101 | entered Feb 29, 2016 | NTF1 - WTR&SEWER-FACILITIES O&M 1 378.A0920.NTF1.10659.A0000.82431 $46,946.00 | 46,946.00 | |||||||||||||||||||||||||
51 | O&M | 80600 | -101 | PENSION | PLAN | 180.04 | 50-80600-101 | 40-80600-101 | entered Feb 29, 2016 | NTH1 - EDU - FACILITIES O&M 1 378.A0920.NTH1.10659.A0000.82431 $3,710.25 | 3,710.25 | 3,710.25 | |||||||||||||||||||||||
52 | New subdivision lots-culverts | 70350 | -102 | CONTRACTS | EXP | 553.03 | 50-70350-102 | 40-70350-102 | entered Feb 29, 2016 | NTK0 - HOUSING 1 378.A0920.NTK0.10659.A0000.82431 $69,514.70 | 69,514.70 | ||||||||||||||||||||||||
53 | Powerline over to lodge | 80350 | -102 | WATER | TAXI | 150.00 | 50-80350-102 | 40-80350-102 | entered Feb 29, 2016 | NTM0 - OTHER - CAPITAL 1 378.A0920.NTM0.10659.A0000.82431 $104,272.05 | 104,272.05 | ||||||||||||||||||||||||
54 | 70275 | -105 | SUPPLIES | EXP | 772.44 | 50-70275-105 | 40-70275-105 | entered Feb 29, 2016 | NTM1 - OTHER - FACILITIES O&M 1 378.A0920.NTM1.10659.A0000.82431 $43,191.90 | 43,191.90 | |||||||||||||||||||||||||
55 | 6,933.60 | 10440 | 10450 | NTMV - MUNICIPAL SERVICES 1 379.A096D.NTMV.10659.A0000.82431 $10,705.00 | 10,705.00 | ||||||||||||||||||||||||||||||
56 | 1/9/2016 | Staples Phone Robert Atleo | 246.21 | SOC DEV | Cell phones | 10-70225-101 | 30-70225-101 | Sub-Total: $1,623,872.05 | 1,623,872.05 | 895,087.40 | 146.1 | ||||||||||||||||||||||||
57 | 1/18/2016 | Shaw Internet Jan 2016 | 69.44 | Admin | IT/Computers | 10-70225-101 | 40-70225-101 | 2015-16 extra | 18,750.00 | ||||||||||||||||||||||||||
58 | 1/3/2016 | Telus Sim Card Housing | 16.8 | Housing | Cell phones | 10-70225-101 | 80-70225-101 | NPG0 - LTS CORE-REGIS&MEMBERSHIP 1 313.A0920.NPG0.10659.A0000.82431 $453.60 | 453.60 | 20,550.00 | |||||||||||||||||||||||||
59 | 1/3/2016 | Wal Mart Monitors Alec Dick & Greg Hayes | 306.88 | CAPITAL | IT/Computers | 10-70225-101 | 40-70225-101 | NG00 - IGS - BAND 1 378.A0920.NG00.10659.A0000.82431 $23,497.65 | 23,497.65 | 7,577.40 | |||||||||||||||||||||||||
60 | 1/9/2016 | Telus Sim Card Housing | 16.8 | Housing | Cell phones | 10-70225-101 | 80-70225-101 | NP00 - ELEMENTARY/SECONDARY 1 378.A0920.NP00.10659.A0000.82431 $127,029.45 | 127,029.45 | 127,029.45 | 40960.8 | 40,960.80 | |||||||||||||||||||||||
61 | 9/19/2016 | Home Depot Floor Cover | 60.41 | CAPITAL | Renovations | 10-70225-101 | 40-70225-101 | NP50 - POST SECONDARY EDUCATION 1 378.A0920.NP50.10659.A0000.82431 $30,272.40 | 30,272.40 | 30,272.40 | 9761.25 | 9,761.25 | |||||||||||||||||||||||
62 | 12/11/2016 | Acer Phone for Housing Dept | 166.87 | HOUSING | Cell Phones | 10-70225-101 | 80-70225-101 | NP80 - INCOME ASSISTANCE 1 378.A0920.NP80.10659.A0000.82431 $48,666.30 | 48,666.30 | 94,155.15 | |||||||||||||||||||||||||
63 | 12/11/2016 | Memory Stick 64GB | 87.34 | HOUSING | Cell Phones | 10-70225-101 | 80-70225-101 | NPC0 - ASSISTED LIVING - BLOCK 1 378.A0920.NPC0.10659.A0000.82431 $3,966.75 | 3,966.75 | 7,674.60 | |||||||||||||||||||||||||
64 | 12/29/2016 | Yates Funeral Home | 3,299.30 | 3229.3 | SOC DEV Funerals | 10-70225-101 | 40-70225-101 | NT40 - LEDSP-EcDev-Allocations 1 378.A0920.NT40.10659.A0000.82431 $3,560.70 | 3,560.70 | 1,148.70 | |||||||||||||||||||||||||
65 | 10/24/2016 | Acer 7" Tabs AGM | 671.21 | CAPITAL | IT/Computers | 10-70225-101 | 40-70225-101 | NTH1 - EDU - FACILITIES O&M 1 378.A0920.NTH1.10659.A0000.82431 $654.75 | 654.75 | 654.75 | 2543.85 | 2,543.85 | |||||||||||||||||||||||
66 | 11/8/2016 | Wal Mart Monitors Reception & Google Earth | 463.68 | CAPITAL | IT/Computers | 10-70225-101 | 40-70225-101 | NTK0 - HOUSING 1 378.A0920.NTK0.10659.A0000.82431 $12,267.30 | 12,267.30 | 47,658.30 | |||||||||||||||||||||||||
67 | 11/18/2016 | BC Backroads Software | 94.09 | CAPITAL | Google Earth Project | 10-70225-101 | 40-70225-101 | NTM0 - OTHER - CAPITAL 1 378.A0920.NTM0.10659.A0000.82431 $18,400.95 | 18,400.95 | 71,487.30 | |||||||||||||||||||||||||
68 | 11/21/2016 | Best Buy Google Earth Camera | 426.03 | CAPITAL | Google Earth Project | 10-70225-101 | 40-70225-101 | NTM1 - OTHER - FACILITIES O&M 1 378.A0920.NTM1.10659.A0000.82431 $7,622.10 | 7,622.10 | 56,969.25 | |||||||||||||||||||||||||
69 | 11/21/2016 | Home Depot Telephone Jacks | 10.73 | CAPITAL | Renovations | 10-70225-101 | 40-70225-101 | Sub-Total: $276,391.95 | 276,391.95 | 157,956.60 | 53,265.90 | 379,382.70 | |||||||||||||||||||||||
70 | 1/30/2016 | BW Chilliwack | 113.64 | Medical | Travel | 10-70225-101 | 25-70225-101 | ||||||||||||||||||||||||||||
71 | 1/30/2016 | BW Chilliwack | 113.64 | Soc Dev | Travel | 10-70225-101 | 30-70225-101 | 1,900,264.00 | 1,053,044.00 | 53,265.90 | |||||||||||||||||||||||||
72 | 12/29/2016 | Yates Funeral Home | -70.00 | Soc Dev | 10-70225-101 | 30-70225-101 | 1,106,309.90 | ||||||||||||||||||||||||||||
73 | 2/10/2016 | Amazon Cobra VHF Radios | 161.45 | Admin | IT/Computers | 10-70225-101 | 40-70225-101 | ||||||||||||||||||||||||||||
74 | 2/25/2016 | Staples Dave Jacobsen Phone | 230 | Capital | IT/Computers | 10-70225-101 | 40-70225-101 | ||||||||||||||||||||||||||||
75 | 2/25/2016 | Telus SIM Card | 16.8 | Capital | IT/Computers | 10-70225-101 | 40-70225-101 | ||||||||||||||||||||||||||||
76 | DR | CR | DR | CR | DR | CR | |||||||||||||||||||||||||||||
77 | 6501.32 | 10-70225-101 | 10410 | ||||||||||||||||||||||||||||||||
78 | 289.85 | entered Feb 29, 2016 | 10430 | 30-70225-101 | |||||||||||||||||||||||||||||||
79 | 5810.02 | entered Feb 29, 2016 | 10440 | 40-70225-101 | |||||||||||||||||||||||||||||||
80 | 287.81 | entered Feb 29, 2016 | 10480 | 80-70225-101 | |||||||||||||||||||||||||||||||
81 | 113.64 | entered Feb 29, 2016 | 10425 | 25-70225-101 | |||||||||||||||||||||||||||||||
82 | |||||||||||||||||||||||||||||||||||
83 | 1695 | 6/22/2015 | ASSOCIATED ENGINEERING (B.C.) 4,912.77 R2015/07/31 | 4,912.77 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
84 | 1661 | 6/16/2015 | ASSOCIATED ENGINEERING (B.C.) 7,935.50 R2015/07/31 | 7,935.50 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
85 | 1721 | 6/23/2015 | CANADIAN ALBERNI ENGINEERING L 3,032.96 R2015/07/3 | 3,032.96 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
86 | 2078 | 10/6/2015 | CEDAR CREEK CASKETS 1,300.00 R2015/10/31 | 1,300.00 | 10-70350-101 | 30-70350-101 | |||||||||||||||||||||||||||||
87 | 1885 | 8/6/2015 | COMMUNICATION SERVICES 1,194.50 R2015/08/31 | 1,194.50 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
88 | 1975 | 9/8/2015 | COMMUNICATION SERVICES 1,217.00 R2015/09/30 | 1,217.00 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
89 | 1632 | 5/28/2015 | COMMUNICATION SERVICES 1,392.00 R2015/06/30 | 1,392.00 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
90 | 2549 | 2/2/2016 | COMMUNICATION SERVICES 1,504.88 | 1,504.88 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
91 | 1629 | 5/28/2015 | COMMUNICATION SERVICES 1,820.18 R2015/06/30 | 1,820.18 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
92 | 2083 | 10/6/2015 | COMMUNICATION SERVICES 2,882.72 R2015/10/31 | 2,882.72 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
93 | 1534 | 5/6/2015 | COMMUNICATION SERVICES 3,485.92 R2015/05/31 | 3,485.92 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
94 | 1500 | 5/1/2015 | COMMUNICATION SERVICES 3,493.28 R2015/05/31 | 3,493.28 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
95 | 1735 | 6/29/2015 | COMMUNICATION SERVICES 4,354.76 R2015/07/31 | 4,354.76 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
96 | 2411 | 1/7/2016 | COMMUNICATION SERVICES 5,535.00 | 5,535.00 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
97 | 1946 | 8/31/2015 | COMMUNICATION SERVICES 5,614.51 R2015/09/30 | 5,614.51 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
98 | 2124 | 10/19/2015 | COMMUNICATION SERVICES 900.02 R2015/11/30 | 900.02 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
99 | 1382 | 4/2/2015 | COMMUNICATION SERVICES 996.45 R2015/04/30 | 996.45 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
100 | EFT | COMMUNICATION SERVICES 7485.24 (TV's) | 7,485.24 | 10-70350-101 | 40-70350-101 | ||||||||||||||||||||||||||||||
101 | |||||||||||||||||||||||||||||||||||
102 | 2590 | 2/10/2016 | N.E.D.C 21,252.75 | 21,252.75 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
103 | 2414 | 1/7/2016 | N.E.D.C 21,252.75 C2016/01/07 Reason: None Entered | 21,252.75 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
104 | 1671 | 6/16/2015 | N.E.D.C 21,252.75 R2015/07/31 | 21,252.75 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
105 | 1957 | 9/3/2015 | N.E.D.C 3,900.00 R2015/09/30 | 3,900.00 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
106 | 1956 | 9/3/2015 | N.E.D.C 4,781.42 R2015/09/30 | 4,781.42 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
107 | 2296 | 11/23/2015 | N.E.D.C 42,505.50 R2015/12/31 | 42,505.50 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
108 | 2069 | 10/2/2015 | N.E.D.C 5,184.58 R2015/10/31 | 5,184.58 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
109 | 2495 | 1/19/2016 | N.E.D.C 5,958.00 | 5,958.00 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
110 | 1626 | 5/26/2015 | N.E.D.C 6,863.58 R2015/06/30 | 6,863.58 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
111 | 2122 | 10/19/2015 | N.E.D.C 7,784.58 R2015/11/30 | 7,784.58 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
112 | 1921 | 8/20/2015 | NUU-CHAH-NULTH TRIBAL COUNCIL 4,357.00 R2015/09/30 | 4,357.00 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
113 | 1934 | 8/20/2015 | NUU-CHAH-NULTH TRIBAL COUNCIL 55,830.50 R2015/09/3 | 55,830.50 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
114 | 2368 | 12/15/2015 | NUU-CHAH-NULTH TRIBAL COUNCIL 7,245.00 | 7,245.00 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
115 | 2489 | 1/19/2016 | NUU-CHAH-NULTH TRIBAL COUNCIL 7,245.00 | 7,245.00 | 10-70350-101 | 77-70350-101 | |||||||||||||||||||||||||||||
116 | |||||||||||||||||||||||||||||||||||
117 | 2322 | 11/30/2015 | STAPLES BUSINESS DEPOT 1,073.08 | 1,073.08 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
118 | 1935 | 8/20/2015 | STAPLES BUSINESS DEPOT 1,185.77 R2015/09/30 | 1,185.77 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
119 | 1413 | 4/9/2015 | STAPLES BUSINESS DEPOT 1,438.04 R2015/04/30 | 1,438.04 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
120 | 2565 | 2/9/2016 | STAPLES BUSINESS DEPOT 1,490.25 | 1,490.25 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
121 | 1631 | 5/28/2015 | STAPLES BUSINESS DEPOT 2,432.14 R2015/06/30 | 2,432.14 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
122 | 1887 | 8/6/2015 | STAPLES BUSINESS DEPOT 2,671.78 R2015/09/30 | 2,671.78 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
123 | 2423 | 1/7/2016 | STAPLES BUSINESS DEPOT 5,540.53 | 5,540.53 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
124 | 2419 | 1/7/2016 | STAPLES BUSINESS DEPOT 774.29 | 774.29 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
125 | 1672 | 6/16/2015 | STAPLES BUSINESS DEPOT 954.88 R2015/07/31 | 954.88 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
126 | 1665 | 6/16/2015 | STAPLES PREFERRED CUSTOMER PRO 439.02 C2015/08/27 | 439.02 | 10-70275-101 | 40-70275-101 | |||||||||||||||||||||||||||||
127 | 1754 | 7/3/2015 | THINK COMMUNICATIONS INC. 1,890.16 R2015/07/31 | 1,890.16 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
128 | 2418 | 1/7/2016 | THINK COMMUNICATIONS INC. 2,650.28 | 2,650.28 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
129 | 1443 | 4/17/2015 | THINK COMMUNICATIONS INC. 629.70 R2015/05/31 | 629.70 | 10-70350-101 | 40-70350-101 | |||||||||||||||||||||||||||||
130 | |||||||||||||||||||||||||||||||||||
131 | 1883 | 8/6/2015 | YATES FUNERAL SERVICE & CREMAT 1,971.50 R2015/08/3 | 1,971.50 | 10-70350-101 | 30-70350-101 | |||||||||||||||||||||||||||||
132 | 2063 | 9/29/2015 | YATES FUNERAL SERVICE & CREMAT 2,736.00 C2015/09/2 | 2,736.00 | 10-70350-101 | 30-70350-101 | |||||||||||||||||||||||||||||
133 | 2065 | 9/29/2015 | YATES FUNERAL SERVICE & CREMAT 2,736.00 C2015/10/1 | 2,736.00 | 10-70350-101 | 30-70350-101 | |||||||||||||||||||||||||||||
134 | 2097 | 10/8/2015 | YATES FUNERAL SERVICE & CREMAT 3,968.00 R2015/10/3 | 3,968.00 | 10-70350-101 | 30-70350-101 | |||||||||||||||||||||||||||||
135 | |||||||||||||||||||||||||||||||||||
136 | Realloc Admin Exp to Capital, Treaty, Other Dept | -291,052.74 | 10-70350-101 | 10410 | |||||||||||||||||||||||||||||||
137 | Realloc Admin Exp to Capital, Treaty, Other Dept | -17,999.78 | 10-70275-101 | ||||||||||||||||||||||||||||||||
138 | Realloc Admin Exp to Capital, Treaty, Other Dept | 12,711.50 | 30-70350-101 | 10430 | |||||||||||||||||||||||||||||||
139 | Realloc Admin Exp to Capital, Treaty, Other Dept | 17,999.78 | 40-70275-101 | 10440 | |||||||||||||||||||||||||||||||
140 | Realloc Admin Exp to Capital, Treaty, Other Dept | 5,170.14 | 40-70350-101 | ||||||||||||||||||||||||||||||||
141 | Realloc Admin Exp to Capital, Treaty, Other Dept | 57,757.69 | 40-70350-101 | ||||||||||||||||||||||||||||||||
142 | Realloc Admin Exp to Capital, Treaty, Other Dept | 215,413.41 | 77-70350-101 | 10477 | |||||||||||||||||||||||||||||||
143 | 309,052.52 | -309,052.52 | |||||||||||||||||||||||||||||||||
144 | entered Feb 29, 2016 | ||||||||||||||||||||||||||||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to Mar 31, 2018 | 12 | MONTHS | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Var% | Month to month spending | Notes | |||||
3 | 10 | ADMIN | $1,854,755.50 | $1,854,755.50 | $1,725,417.48 | -$129,338.02 | -7.0% | 175k Taaqwiiaak; 120k Water Filtration costs; $100k Audit + $185k DISC | -7.50% | $860,508.68 | ||||
4 | 25 | HEALTH | $1,274,803.88 | $1,274,803.88 | $1,246,683.96 | -$28,119.92 | -2.2% | -2.26% | $953,493.17 | $75,000 added in FNHA funding | ||||
5 | 30 | SOCDEV | $1,225,590.77 | $1,225,590.77 | $1,204,604.33 | -$20,986.44 | -1.7% | -1.74% | $284,345.66 | |||||
6 | 40 | CAPITAL | $1,601,509.45 | $1,601,509.45 | $1,599,494.00 | -$2,015.45 | -0.1% | -0.13% | $1,251,178.24 | Prorated Actual | $705,000 added in WWTP DAR funding | |||
7 | 50 | OPSMAINT | $1,058,457.38 | $1,058,457.38 | $1,030,599.86 | -$27,857.52 | -2.6% | -2.70% | $621,682.23 | $0.00 | $175,000 added WTP funding | |||
8 | 60 | COMMUNITY | $464,169.93 | $464,169.93 | $522,393.60 | $58,223.67 | 12.5% | 11.15% | $92,500.83 | |||||
9 | 70 | FORESTRY | $4,479.55 | $4,479.55 | -$4,479.55 | $4,330.06 | ||||||||
10 | 75 | FISHERIES | $278,154.55 | $278,154.55 | $279,273.60 | $1,119.05 | 0.4% | 0.40% | $130,564.96 | $75,000 home use fish funding | ||||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | 100.00% | -$12,721.43 | |||||||
12 | 80 | HOUSING | $750,932.67 | $750,932.67 | $603,583.55 | -$147,349.12 | -19.6% | CMHC renovation funding pending | -24.41% | $356,170.11 | ||||
13 | 90 | TREATY | $42.00 | $42.00 | $15,000.00 | $14,958.00 | 35614.3% | 99.72% | $36.00 | |||||
14 | Grand Total | $8,512,895.68 | $8,512,895.68 | $8,518,598.38 | $5,702.70 | Year end capital and operational invoices caught up in March | $3,774,632.34 | |||||||
15 | $2,288,420.69 | $709,883.20 | ||||||||||||
16 | YTD Actuals = Year to Date Actuals = Actual expenses spent year to date | CONTROL #: Does this agree to cell L21 & L22 on spreadsheet | ||||||||||||
17 | Prorated Actual = Year to Date totals divided by number of months so far in the year multiplied by 12 = an estimate of what we will spend for the entire year | 8,512,895.68 | ||||||||||||
18 | MAP Budget are the budget numbers that Ahousaht needs to come in at or below. | 291,548.00 | ||||||||||||
19 | Variance is the difference between MAP Budget and Prorated Actual amount; negative amounts are bad | Print to PDF, save, then send to INAC quarterly | ||||||||||||
20 | ||||||||||||||
21 | 2014-15 | 2015-16 | 2016-17 | 2017-18 | ||||||||||
22 | Net Debt projected to end of year | 10,135,743 | 9,715,815 | 9,313,285 | 8,927,432 | |||||||||
23 | ||||||||||||||
24 | BUDGET SUMMARY | Black =Good; Red = Bad | ||||||||||||
25 | YTD Actuals | Original Budget (Funding Additions not included) | Prorated Annual Variance | ALL | rbullock@ahousaht.ca | |||||||||
26 | 10 | ADMIN | Advertising | $2,262.60 | $2,262.60 | 10 | ADMIN | Council, Rob B | ||||||
27 | Audit fees | $35,317.00 | $35,317.00 | 25 | HEALTH | Dave | julia.atelo@ahousaht.ca | |||||||
28 | Benefits | $162,917.70 | $115,274.87 | -$210,560.53 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||||
29 | Capital | $10,166.57 | $16,998.43 | -$3,334.71 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||||
30 | Contractual services | $642,969.19 | $219,632.15 | -$1,066,306.23 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||||
31 | Honoraria | $6,100.00 | -$12,200.00 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||||
32 | Insurance | $106,751.44 | $ - | -$213,502.88 | 70 | FORESTRY | ||||||||
33 | Legal fees | $26,947.15 | $62,836.25 | $8,941.95 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | ||||||
34 | Office supplies | $67,000.91 | $ - | -$134,001.82 | 77 | ECONOMIC | Council, Rob | |||||||
35 | Other | $192,685.06 | $112,318.25 | -$273,051.87 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||||
36 | Postage & frieght | $2,115.74 | $23,023.29 | $18,791.81 | 90 | TREATY | ||||||||
37 | Repairs & maintenance | $527.93 | $79,340.58 | $78,284.72 | ||||||||||
38 | Salaries | $473,672.84 | $455,254.92 | -$492,090.76 | ||||||||||
39 | Telecommunications | $74,345.23 | $20,396.21 | -$128,294.25 | ||||||||||
40 | Training | $3,136.66 | $8,952.35 | $2,679.03 | ||||||||||
41 | Travel | $85,419.08 | $12,863.45 | -$157,974.71 | ||||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||||
43 | ADMIN Total | $1,854,755.50 | $1,165,417.48 | -$2,544,093.52 | ||||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||||
45 | Audit fees | $ - | ||||||||||||
46 | Capital | $1,726.55 | $ - | -$3,453.10 | ||||||||||
47 | Contractual services | $428,955.54 | -$857,911.08 | |||||||||||
48 | Honoraria | $1,250.00 | $ - | -$2,500.00 | ||||||||||
49 | Insurance | $ - | ||||||||||||
50 | Legal fees | $ - | ||||||||||||
51 | Office supplies | $92,352.46 | $31,080.00 | -$153,624.92 | ||||||||||
52 | Other | $68,173.13 | $5,796.00 | -$130,550.26 | ||||||||||
53 | Postage & frieght | $505.00 | $ - | -$1,010.00 | ||||||||||
54 | Repairs & maintenance | $2,896.75 | $31,500.00 | $25,706.50 | ||||||||||
55 | Salaries | $414,900.61 | $361,596.00 | -$468,205.22 | ||||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||||
57 | Training | $ - | ||||||||||||
58 | Travel | $264,043.84 | $41,004.00 | -$487,083.68 | ||||||||||
59 | Healthy Baby | $6,000.00 | $6,000.00 | |||||||||||
60 | (CW) Workshops | $6,500.00 | $6,500.00 | |||||||||||
61 | Youth Activities | $20,799.96 | $20,799.96 | |||||||||||
62 | Community Workshops | $23,000.04 | $23,000.04 | |||||||||||
63 | HEALTH Total | $1,274,803.88 | $540,275.96 | -$2,009,331.80 | ||||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||||
65 | Audit fees | $ - | ||||||||||||
66 | Benefits | $6,959.50 | -$13,919.00 | |||||||||||
67 | Capital | $ - | ||||||||||||
68 | Contractual services | $22,020.55 | -$44,041.10 | |||||||||||
69 | Honoraria | $ - | ||||||||||||
70 | Legal fees | $ - | ||||||||||||
71 | Office supplies | $8,749.66 | $ - | -$17,499.32 | ||||||||||
72 | Other | $864,762.62 | $920,540.73 | -$808,984.51 | ||||||||||
73 | Postage & frieght | $120.00 | -$240.00 | |||||||||||
74 | Repairs & maintenance | $9,594.97 | -$19,189.94 | |||||||||||
75 | Salaries | $286,978.08 | $108,787.44 | -$465,168.72 | ||||||||||
76 | Telecommunications | $ - | ||||||||||||
77 | Training | $ - | ||||||||||||
78 | Travel | $26,405.39 | $ - | -$52,810.78 | ||||||||||
79 | Materials & supplies | $ - | ||||||||||||
80 | Special Needs | $27,547.92 | $27,547.92 | |||||||||||
81 | Gaurdian Financial Assistance | $ - | ||||||||||||
82 | Admin Fee Office Supplies, Rent | $11,100.00 | $11,100.00 | |||||||||||
83 | Assisted Living | $38,226.24 | $38,226.24 | |||||||||||
84 | Disability | $8,200.00 | $8,200.00 | |||||||||||
85 | SOCDEV Total | $1,225,590.77 | $1,114,402.33 | -$1,336,779.21 | ||||||||||
86 | 40 | CAPITAL | Advertising | $ - | ||||||||||
87 | Audit fees | $ - | ||||||||||||
88 | Benefits | $ - | ||||||||||||
89 | Capital | $ - | ||||||||||||
90 | Contractual services | $1,300,647.53 | $427,494.00 | -$2,173,801.06 | ||||||||||
91 | Honoraria | $ - | ||||||||||||
92 | Insurance | $ - | ||||||||||||
93 | Legal fees | $ - | ||||||||||||
94 | Office supplies | $72,715.83 | $ - | -$145,431.66 | ||||||||||
95 | Other | $43,771.62 | -$87,543.24 | |||||||||||
96 | Postage & frieght | $7,480.00 | $ - | -$14,960.00 | ||||||||||
97 | Repairs & maintenance | $1,718.91 | $50,000.04 | $46,562.22 | ||||||||||
98 | Salaries | $27,255.04 | $ - | -$54,510.08 | ||||||||||
99 | Telecommunications | $ - | ||||||||||||
100 | Training | $1,377.60 | $ - | -$2,755.20 | ||||||||||
101 | Travel | $146,542.92 | $3,999.96 | -$289,085.88 | ||||||||||
102 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||||
103 | Rentals | $ - | ||||||||||||
104 | Membership fees | $ - | ||||||||||||
105 | CAPITAL Total | $1,601,509.45 | $499,494.00 | -$2,703,524.90 | ||||||||||
106 | 50 | OPSMAINT | Advertising | $ - | ||||||||||
107 | Audit fees | $ - | ||||||||||||
108 | Benefits | $7,342.08 | $41,999.98 | $27,315.82 | ||||||||||
109 | Capital | $9,726.03 | $ - | -$19,452.06 | ||||||||||
110 | Contractual services | $250,237.60 | $ - | -$500,475.20 | ||||||||||
111 | Honoraria | $ - | ||||||||||||
112 | Insurance | $2,016.00 | $ - | -$4,032.00 | ||||||||||
113 | Legal fees | $ - | ||||||||||||
114 | Office supplies | $150,980.36 | $ - | -$301,960.72 | ||||||||||
115 | Other | $133,990.61 | $14,400.00 | -$253,581.22 | ||||||||||
116 | Postage & frieght | $33,931.72 | $ - | -$67,863.44 | ||||||||||
117 | Repairs & maintenance | $33,823.55 | $54,000.00 | -$13,647.10 | ||||||||||
118 | Salaries | $393,340.35 | $209,999.88 | -$576,680.82 | ||||||||||
119 | Telecommunications | $186.63 | $3,600.00 | $3,226.74 | ||||||||||
120 | Training | $1,460.88 | $3,000.00 | $78.24 | ||||||||||
121 | Travel | $41,421.57 | $ - | -$82,843.14 | ||||||||||
122 | Materials & supplies | $ - | ||||||||||||
123 | Rentals | $3,600.00 | $3,600.00 | |||||||||||
124 | Membership fees | $ - | ||||||||||||
125 | OPSMAINT Total | $1,058,457.38 | $330,599.86 | -$1,786,314.90 | ||||||||||
126 | 60 | COMMUNITY | Advertising | $ - | ||||||||||
127 | Audit fees | $ - | ||||||||||||
128 | Benefits | $8,780.90 | $73,905.60 | $56,343.80 | ||||||||||
129 | Capital | $ - | ||||||||||||
130 | Contractual services | $25,680.00 | $ - | -$51,360.00 | ||||||||||
131 | Honoraria | $34,525.00 | $ - | -$69,050.00 | ||||||||||
132 | Insurance | $ - | ||||||||||||
133 | Legal fees | $ - | ||||||||||||
134 | Office supplies | $12,467.13 | $ - | -$24,934.26 | ||||||||||
135 | Other | $82,921.29 | $39,240.00 | -$126,602.58 | ||||||||||
136 | Postage & frieght | $40.00 | $ - | -$80.00 | ||||||||||
137 | Repairs & maintenance | $3,624.00 | $3,624.00 | |||||||||||
138 | Salaries | $158,446.10 | $369,528.00 | $52,635.80 | ||||||||||
139 | Telecommunications | $5,561.25 | $ - | -$11,122.50 | ||||||||||
140 | Training | $5,544.00 | $5,544.00 | |||||||||||
141 | Travel | $135,748.26 | $5,112.00 | -$266,384.52 | ||||||||||
142 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||||
143 | Rentals | $15,948.00 | $15,948.00 | |||||||||||
144 | Membership fees | $ - | ||||||||||||
145 | COMMUNITY Total | $464,169.93 | $522,393.60 | -$405,946.26 | ||||||||||
146 | 70 | Contractual services | $3,677.78 | -$7,355.56 | ||||||||||
147 | Salaries | $281.77 | -$563.54 | |||||||||||
148 | Travel | $520.00 | -$1,040.00 | |||||||||||
149 | 0 Total | $4,479.55 | -$8,959.10 | |||||||||||
150 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | |||||||||
151 | Benefits | $2,384.16 | $9,503.16 | $4,734.84 | ||||||||||
152 | Capital | $756.00 | $ - | -$1,512.00 | ||||||||||
153 | Contractual services | $22,724.34 | $ - | -$45,448.68 | ||||||||||
154 | Honoraria | $ - | ||||||||||||
155 | Insurance | $6,813.27 | $7,700.00 | -$5,926.54 | ||||||||||
156 | Legal fees | $ - | ||||||||||||
157 | Office supplies | $26,091.34 | $ - | -$52,182.68 | ||||||||||
158 | Other | $4,265.75 | $24,000.00 | $15,468.50 | ||||||||||
159 | Postage & frieght | $3,355.00 | $ - | -$6,710.00 | ||||||||||
160 | Repairs & maintenance | $58,231.51 | $4,400.00 | -$112,063.02 | ||||||||||
161 | Salaries | $136,398.02 | $105,310.44 | -$167,485.60 | ||||||||||
162 | Telecommunications | $599.68 | -$1,199.36 | |||||||||||
163 | Training | $3,000.00 | $3,000.00 | |||||||||||
164 | Travel | $16,535.48 | $24,000.00 | -$9,070.96 | ||||||||||
165 | Materials & supplies | $3,000.00 | $3,000.00 | |||||||||||
166 | Rentals | $ - | ||||||||||||
167 | Membership fees | $ - | ||||||||||||
168 | Admin Fee | $9,120.00 | $9,120.00 | |||||||||||
169 | Telecommunications & Utilities | $6,240.00 | $6,240.00 | |||||||||||
170 | FISHERIES Total | $278,154.55 | $198,773.60 | -$357,535.50 | ||||||||||
171 | 77 | ECONOMIC | Advertising | $6,000.00 | $6,000.00 | |||||||||
172 | Audit fees | $ - | ||||||||||||
173 | Benefits | $29,754.00 | $29,754.00 | |||||||||||
174 | Capital | $10,000.00 | $10,000.00 | |||||||||||
175 | Contractual services | $7,500.00 | $7,500.00 | |||||||||||
176 | Honoraria | $ - | ||||||||||||
177 | Insurance | $ - | ||||||||||||
178 | Legal fees | $ - | ||||||||||||
179 | Office supplies | $ - | ||||||||||||
180 | Other | $50,000.00 | $50,000.00 | |||||||||||
181 | Postage & frieght | $ - | ||||||||||||
182 | Repairs & maintenance | $22,500.00 | $22,500.00 | |||||||||||
183 | Salaries | $148,794.00 | $148,794.00 | |||||||||||
184 | Telecommunications | $3,000.00 | $3,000.00 | |||||||||||
185 | Training | $ - | ||||||||||||
186 | Travel | $ - | ||||||||||||
187 | Materials & supplies | $14,000.00 | $14,000.00 | |||||||||||
188 | Rentals | $ - | ||||||||||||
189 | Membership fees | $ - | ||||||||||||
190 | ECONOMIC Total | $291,548.00 | $291,548.00 | |||||||||||
191 | 80 | HOUSING | Advertising | $ - | ||||||||||
192 | Audit fees | $ - | ||||||||||||
193 | Benefits | $4,743.48 | $15,301.26 | $5,814.30 | ||||||||||
194 | Capital | $32,605.44 | $ - | -$65,210.88 | ||||||||||
195 | Contractual services | $44,059.95 | $13,010.83 | -$75,109.07 | ||||||||||
196 | Honoraria | $500.00 | $ - | -$1,000.00 | ||||||||||
197 | Insurance | $1,131.00 | $36,707.44 | $34,445.44 | ||||||||||
198 | Legal fees | $ - | ||||||||||||
199 | Office supplies | $1,997.15 | $ - | -$3,994.30 | ||||||||||
200 | Other | $25,108.01 | $13,575.55 | -$36,640.47 | ||||||||||
201 | Postage & frieght | $21,989.30 | $2,091.26 | -$41,887.34 | ||||||||||
202 | Repairs & maintenance | $227,331.35 | $57,775.90 | -$396,886.80 | ||||||||||
203 | Salaries | $373,482.98 | $66,530.61 | -$680,435.35 | ||||||||||
204 | Telecommunications | $599.68 | $124.85 | -$1,074.51 | ||||||||||
205 | Training | $ - | ||||||||||||
206 | Travel | $17,384.33 | $1,324.90 | -$33,443.76 | ||||||||||
207 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||||
208 | Membership fees | $ - | ||||||||||||
209 | Mortgage | $127,186.00 | $127,186.00 | |||||||||||
210 | HOUSING Total | $750,932.67 | $336,083.55 | -$1,165,781.79 | ||||||||||
211 | 90 | TREATY | Advertising | $ - | ||||||||||
212 | Audit fees | $ - | ||||||||||||
213 | Benefits | $ - | ||||||||||||
214 | Capital | $ - | ||||||||||||
215 | Contractual services | $1,800.00 | $1,800.00 | |||||||||||
216 | Honoraria | $3,000.00 | $3,000.00 | |||||||||||
217 | Insurance | $ - | ||||||||||||
218 | Legal fees | $9,000.00 | $9,000.00 | |||||||||||
219 | Office supplies | $ - | ||||||||||||
220 | Other | $42.00 | $1,200.00 | $1,116.00 | ||||||||||
221 | Postage & frieght | $ - | ||||||||||||
222 | Repairs & maintenance | $ - | ||||||||||||
223 | Salaries | $ - | ||||||||||||
224 | Telecommunications | $ - | ||||||||||||
225 | Training | $ - | ||||||||||||
226 | Travel | $ - | ||||||||||||
227 | Materials & supplies | $ - | ||||||||||||
228 | Rentals | $ - | ||||||||||||
229 | Membership fees | $ - | ||||||||||||
230 | TREATY Total | $42.00 | $15,000.00 | |||||||||||
231 | Grand Total | $8,512,895.68 | $5,013,988.38 | |||||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to Feb 28, 2018 | 11 | MONTHS | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | |||||
3 | 10 | ADMIN | $1,692,790.71 | $1,846,680.77 | $1,540,417.48 | -$306,263.29 | 175k Taaqwiiaak; 120k Water Filtration costs; $100k Audit | -19.88% | $698,543.89 | ||||
4 | 25 | HEALTH | $1,098,954.94 | $1,198,859.93 | $1,191,510.46 | -$7,349.47 | less than 1% variance | -0.62% | $777,644.23 | $75,000 added in FNHA funding | |||
5 | 30 | SOCDEV | $1,116,174.86 | $1,217,645.30 | $1,197,087.50 | -$20,557.81 | less than 2% variance | -1.72% | $174,929.75 | ||||
6 | 40 | CAPITAL | $1,454,904.63 | $1,587,168.69 | $1,799,494.00 | $212,325.31 | 11.80% | $1,104,573.42 | Prorated Actual | $705,000 added in WWTP DAR funding | |||
7 | 50 | OPSMAINT | $947,547.67 | $1,033,688.37 | $1,030,599.86 | -$3,088.51 | less than 1% variance | -0.30% | $510,772.52 | $0.00 | $175,000 added WTP funding | ||
8 | 60 | COMMUNITY | $438,247.24 | $478,087.90 | $522,393.60 | $44,305.70 | 8.48% | $66,578.14 | |||||
9 | 70 | FORESTRY | $20.00 | $21.82 | -$21.82 | -$129.49 | |||||||
10 | 75 | FISHERIES | $263,595.74 | $287,558.99 | $286,773.60 | -$785.39 | less than 1% variance | -0.27% | $116,006.15 | $75,000 home use fish funding | |||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | 100.00% | -$12,721.43 | ||||||
12 | 80 | HOUSING | $687,538.78 | $750,042.31 | $623,583.55 | -$126,458.76 | CMHC renovation funding pending | -20.28% | $292,776.22 | ||||
13 | 90 | TREATY | $30.00 | $32.73 | $15,000.00 | $14,967.27 | 99.78% | $24.00 | |||||
14 | Grand Total | $7,699,804.57 | $8,399,786.80 | $8,498,408.05 | $98,621.24 | $2,961,541.23 | |||||||
15 | $1,475,329.58 | $708,200.67 | |||||||||||
16 | YTD Actuals = Year to Date Actuals = Actual expenses spent year to date | CONTROL #: Does this agree to cell L21 & L22 on spreadsheet | |||||||||||
17 | Prorated Actual = Year to Date totals divided by number of months so far in the year multiplied by 12 = an estimate of what we will spend for the entire year | 7,699,804.57 | |||||||||||
18 | MAP Budget are the budget numbers that Ahousaht needs to come in at or below. | 291,548.00 | |||||||||||
19 | Variance is the difference between MAP Budget and Prorated Actual amount; negative amounts are bad | Print to PDF, save, then send to INAC quarterly | |||||||||||
20 | |||||||||||||
21 | 2014-15 | 2015-16 | 2016-17 | 2017-18 | |||||||||
22 | Net Debt projected to end of year | 10,135,743 | 9,715,815 | 9,313,285 | 8,927,432 | ||||||||
23 | |||||||||||||
24 | BUDGET SUMMARY | Black =Good; Red = Bad | |||||||||||
25 | YTD Actuals | Original Budget (Funding Additions not included) | Prorated Annual Variance | ALL | rbullock@ahousaht.ca | ||||||||
26 | 10 | ADMIN | Advertising | $2,262.60 | $2,262.60 | 10 | ADMIN | Council, Rob B | |||||
27 | Audit fees | $35,317.00 | $35,317.00 | 25 | HEALTH | Dave | julia.atelo@ahousaht.ca | ||||||
28 | Benefits | $153,759.29 | $115,274.87 | -$192,243.71 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | |||||
29 | Capital | $10,166.57 | $16,998.43 | -$3,334.71 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | |||||
30 | Contractual services | $631,792.43 | $219,632.15 | -$1,043,952.71 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | |||||
31 | Honoraria | $4,000.00 | -$8,000.00 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | ||||||
32 | Insurance | $89,546.24 | $ - | -$179,092.48 | 70 | FORESTRY | |||||||
33 | Legal fees | $26,947.15 | $62,836.25 | $8,941.95 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | |||||
34 | Office supplies | $35,218.93 | $ - | -$70,437.86 | 77 | ECONOMIC | Council, Rob | ||||||
35 | Other | $178,215.43 | $112,318.25 | -$244,112.61 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | |||||
36 | Postage & frieght | $1,085.00 | $23,023.29 | $20,853.29 | 90 | TREATY | |||||||
37 | Repairs & maintenance | $527.93 | $79,340.58 | $78,284.72 | |||||||||
38 | Salaries | $420,272.84 | $455,254.92 | -$385,290.76 | |||||||||
39 | Telecommunications | $64,063.48 | $20,396.21 | -$107,730.75 | |||||||||
40 | Training | $3,136.66 | $8,952.35 | $2,679.03 | |||||||||
41 | Travel | $74,058.76 | $12,863.45 | -$135,254.07 | |||||||||
42 | Membership fees | $947.13 | $947.13 | ||||||||||
43 | ADMIN Total | $1,692,790.71 | $1,165,417.48 | -$2,220,163.94 | |||||||||
44 | 25 | HEALTH | Advertising | $ - | |||||||||
45 | Audit fees | $ - | |||||||||||
46 | Capital | $1,330.87 | $ - | -$2,661.74 | |||||||||
47 | Contractual services | $337,927.44 | -$675,854.88 | ||||||||||
48 | Honoraria | $1,250.00 | $ - | -$2,500.00 | |||||||||
49 | Insurance | $ - | |||||||||||
50 | Legal fees | $ - | |||||||||||
51 | Office supplies | $83,200.33 | $31,080.00 | -$135,320.66 | |||||||||
52 | Other | $64,033.16 | $5,796.00 | -$122,270.32 | |||||||||
53 | Postage & frieght | $445.00 | $ - | -$890.00 | |||||||||
54 | Repairs & maintenance | $2,588.65 | $31,500.00 | $26,322.70 | |||||||||
55 | Salaries | $383,432.21 | $361,596.00 | -$405,268.42 | |||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | ||||||||||
57 | Training | $ - | |||||||||||
58 | Travel | $224,747.28 | $41,004.00 | -$408,490.56 | |||||||||
59 | Healthy Baby | $6,000.00 | $6,000.00 | ||||||||||
60 | (CW) Workshops | $6,500.00 | $6,500.00 | ||||||||||
61 | Youth Activities | $20,799.96 | $20,799.96 | ||||||||||
62 | Community Workshops | $23,000.04 | $23,000.04 | ||||||||||
63 | HEALTH Total | $1,098,954.94 | $540,275.96 | -$1,657,633.92 | |||||||||
64 | 30 | SOCDEV | Advertising | $ - | |||||||||
65 | Audit fees | $ - | |||||||||||
66 | Benefits | $6,624.72 | -$13,249.44 | ||||||||||
67 | Capital | $ - | |||||||||||
68 | Contractual services | $22,020.55 | -$44,041.10 | ||||||||||
69 | Honoraria | $ - | |||||||||||
70 | Legal fees | $ - | |||||||||||
71 | Office supplies | $8,633.27 | $ - | -$17,266.54 | |||||||||
72 | Other | $779,926.82 | $920,540.73 | -$639,312.91 | |||||||||
73 | Postage & frieght | $120.00 | -$240.00 | ||||||||||
74 | Repairs & maintenance | $8,033.37 | -$16,066.74 | ||||||||||
75 | Salaries | $264,689.29 | $108,787.44 | -$420,591.14 | |||||||||
76 | Telecommunications | $ - | |||||||||||
77 | Training | $ - | |||||||||||
78 | Travel | $26,126.84 | $ - | -$52,253.68 | |||||||||
79 | Materials & supplies | $ - | |||||||||||
80 | Special Needs | $27,547.92 | $27,547.92 | ||||||||||
81 | Gaurdian Financial Assistance | $ - | |||||||||||
82 | Admin Fee Office Supplies, Rent | $11,100.00 | $11,100.00 | ||||||||||
83 | Assisted Living | $38,226.24 | $38,226.24 | ||||||||||
84 | Disability | $8,200.00 | $8,200.00 | ||||||||||
85 | SOCDEV Total | $1,116,174.86 | $1,114,402.33 | -$1,117,947.39 | |||||||||
86 | 40 | CAPITAL | Advertising | $ - | |||||||||
87 | Audit fees | $ - | |||||||||||
88 | Benefits | $ - | |||||||||||
89 | Capital | $ - | |||||||||||
90 | Contractual services | $1,166,317.16 | $427,494.00 | -$1,905,140.32 | |||||||||
91 | Honoraria | $ - | |||||||||||
92 | Insurance | $ - | |||||||||||
93 | Legal fees | $ - | |||||||||||
94 | Office supplies | $72,715.83 | $ - | -$145,431.66 | |||||||||
95 | Other | $40,726.68 | -$81,453.36 | ||||||||||
96 | Postage & frieght | $7,235.00 | $ - | -$14,470.00 | |||||||||
97 | Repairs & maintenance | $1,718.91 | $50,000.04 | $46,562.22 | |||||||||
98 | Salaries | $25,449.53 | $ - | -$50,899.06 | |||||||||
99 | Telecommunications | $ - | |||||||||||
100 | Training | $1,377.60 | $ - | -$2,755.20 | |||||||||
101 | Travel | $139,363.92 | $3,999.96 | -$274,727.88 | |||||||||
102 | Materials & supplies | $18,000.00 | $18,000.00 | ||||||||||
103 | Rentals | $ - | |||||||||||
104 | Membership fees | $ - | |||||||||||
105 | CAPITAL Total | $1,454,904.63 | $499,494.00 | -$2,410,315.26 | |||||||||
106 | 50 | OPSMAINT | Advertising | $ - | |||||||||
107 | Audit fees | $ - | |||||||||||
108 | Benefits | $6,041.92 | $41,999.98 | $29,916.14 | |||||||||
109 | Capital | $7,966.19 | $ - | -$15,932.38 | |||||||||
110 | Contractual services | $232,641.47 | $ - | -$465,282.94 | |||||||||
111 | Honoraria | $ - | |||||||||||
112 | Insurance | $2,016.00 | $ - | -$4,032.00 | |||||||||
113 | Legal fees | $ - | |||||||||||
114 | Office supplies | $147,499.77 | $ - | -$294,999.54 | |||||||||
115 | Other | $131,316.32 | $14,400.00 | -$248,232.64 | |||||||||
116 | Postage & frieght | $17,502.47 | $ - | -$35,004.94 | |||||||||
117 | Repairs & maintenance | $33,094.43 | $54,000.00 | -$12,188.86 | |||||||||
118 | Salaries | $330,507.77 | $209,999.88 | -$451,015.66 | |||||||||
119 | Telecommunications | $186.63 | $3,600.00 | $3,226.74 | |||||||||
120 | Training | $1,460.88 | $3,000.00 | $78.24 | |||||||||
121 | Travel | $37,313.82 | $ - | -$74,627.64 | |||||||||
122 | Materials & supplies | $ - | |||||||||||
123 | Rentals | $3,600.00 | $3,600.00 | ||||||||||
124 | Membership fees | $ - | |||||||||||
125 | OPSMAINT Total | $947,547.67 | $330,599.86 | -$1,564,495.48 | |||||||||
126 | 60 | COMMUNITY | Advertising | $ - | |||||||||
127 | Audit fees | $ - | |||||||||||
128 | Benefits | $8,096.97 | $73,905.60 | $57,711.66 | |||||||||
129 | Capital | $ - | |||||||||||
130 | Contractual services | $25,680.00 | $ - | -$51,360.00 | |||||||||
131 | Honoraria | $33,425.00 | $ - | -$66,850.00 | |||||||||
132 | Insurance | $ - | |||||||||||
133 | Legal fees | $ - | |||||||||||
134 | Office supplies | $12,467.13 | $ - | -$24,934.26 | |||||||||
135 | Other | $81,343.59 | $39,240.00 | -$123,447.18 | |||||||||
136 | Postage & frieght | $40.00 | $ - | -$80.00 | |||||||||
137 | Repairs & maintenance | $3,624.00 | $3,624.00 | ||||||||||
138 | Salaries | $147,756.53 | $369,528.00 | $74,014.94 | |||||||||
139 | Telecommunications | $5,336.25 | $ - | -$10,672.50 | |||||||||
140 | Training | $5,544.00 | $5,544.00 | ||||||||||
141 | Travel | $124,101.77 | $5,112.00 | -$243,091.54 | |||||||||
142 | Materials & supplies | $9,492.00 | $9,492.00 | ||||||||||
143 | Rentals | $15,948.00 | $15,948.00 | ||||||||||
144 | Membership fees | $ - | |||||||||||
145 | COMMUNITY Total | $438,247.24 | $522,393.60 | -$354,100.88 | |||||||||
146 | 70 | Travel | $20.00 | -$40.00 | |||||||||
147 | 0 Total | $20.00 | -$40.00 | ||||||||||
148 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | ||||||||
149 | Benefits | $2,384.16 | $9,503.16 | $4,734.84 | |||||||||
150 | Capital | $756.00 | $ - | -$1,512.00 | |||||||||
151 | Contractual services | $22,724.34 | $ - | -$45,448.68 | |||||||||
152 | Honoraria | $ - | |||||||||||
153 | Insurance | $6,813.27 | $7,700.00 | -$5,926.54 | |||||||||
154 | Legal fees | $ - | |||||||||||
155 | Office supplies | $24,586.59 | $ - | -$49,173.18 | |||||||||
156 | Other | $4,199.83 | $24,000.00 | $15,600.34 | |||||||||
157 | Postage & frieght | $3,355.00 | $ - | -$6,710.00 | |||||||||
158 | Repairs & maintenance | $55,449.74 | $4,400.00 | -$106,499.48 | |||||||||
159 | Salaries | $127,301.82 | $105,310.44 | -$149,293.20 | |||||||||
160 | Telecommunications | $599.68 | -$1,199.36 | ||||||||||
161 | Training | $3,000.00 | $3,000.00 | ||||||||||
162 | Travel | $15,425.31 | $24,000.00 | -$6,850.62 | |||||||||
163 | Materials & supplies | $3,000.00 | $3,000.00 | ||||||||||
164 | Rentals | $ - | |||||||||||
165 | Membership fees | $ - | |||||||||||
166 | Admin Fee | $9,120.00 | $9,120.00 | ||||||||||
167 | Telecommunications & Utilities | $6,240.00 | $6,240.00 | ||||||||||
168 | FISHERIES Total | $263,595.74 | $198,773.60 | -$328,417.88 | |||||||||
169 | 77 | ECONOMIC | Advertising | $6,000.00 | $6,000.00 | ||||||||
170 | Audit fees | $ - | |||||||||||
171 | Benefits | $29,754.00 | $29,754.00 | ||||||||||
172 | Capital | $10,000.00 | $10,000.00 | ||||||||||
173 | Contractual services | $7,500.00 | $7,500.00 | ||||||||||
174 | Honoraria | $ - | |||||||||||
175 | Insurance | $ - | |||||||||||
176 | Legal fees | $ - | |||||||||||
177 | Office supplies | $ - | |||||||||||
178 | Other | $50,000.00 | $50,000.00 | ||||||||||
179 | Postage & frieght | $ - | |||||||||||
180 | Repairs & maintenance | $22,500.00 | $22,500.00 | ||||||||||
181 | Salaries | $148,794.00 | $148,794.00 | ||||||||||
182 | Telecommunications | $3,000.00 | $3,000.00 | ||||||||||
183 | Training | $ - | |||||||||||
184 | Travel | $ - | |||||||||||
185 | Materials & supplies | $14,000.00 | $14,000.00 | ||||||||||
186 | Rentals | $ - | |||||||||||
187 | Membership fees | $ - | |||||||||||
188 | ECONOMIC Total | $291,548.00 | $291,548.00 | ||||||||||
189 | 80 | HOUSING | Advertising | $ - | |||||||||
190 | Audit fees | $ - | |||||||||||
191 | Benefits | $4,274.73 | $15,301.26 | $6,751.80 | |||||||||
192 | Capital | $29,448.24 | $ - | -$58,896.48 | |||||||||
193 | Contractual services | $44,059.95 | $13,010.83 | -$75,109.07 | |||||||||
194 | Honoraria | $300.00 | $ - | -$600.00 | |||||||||
195 | Insurance | $1,131.00 | $36,707.44 | $34,445.44 | |||||||||
196 | Legal fees | $ - | |||||||||||
197 | Office supplies | $1,997.15 | $ - | -$3,994.30 | |||||||||
198 | Other | $23,979.60 | $13,575.55 | -$34,383.65 | |||||||||
199 | Postage & frieght | $18,099.30 | $2,091.26 | -$34,107.34 | |||||||||
200 | Repairs & maintenance | $214,345.70 | $57,775.90 | -$370,915.50 | |||||||||
201 | Salaries | $332,309.10 | $66,530.61 | -$598,087.59 | |||||||||
202 | Telecommunications | $599.68 | $124.85 | -$1,074.51 | |||||||||
203 | Training | $ - | |||||||||||
204 | Travel | $16,994.33 | $1,324.90 | -$32,663.76 | |||||||||
205 | Materials & supplies | $2,454.96 | $2,454.96 | ||||||||||
206 | Membership fees | $ - | |||||||||||
207 | Mortgage | $127,186.00 | $127,186.00 | ||||||||||
208 | HOUSING Total | $687,538.78 | $336,083.55 | -$1,038,994.01 | |||||||||
209 | 90 | TREATY | Advertising | $ - | |||||||||
210 | Audit fees | $ - | |||||||||||
211 | Benefits | $ - | |||||||||||
212 | Capital | $ - | |||||||||||
213 | Contractual services | $1,800.00 | $1,800.00 | ||||||||||
214 | Honoraria | $3,000.00 | $3,000.00 | ||||||||||
215 | Insurance | $ - | |||||||||||
216 | Legal fees | $9,000.00 | $9,000.00 | ||||||||||
217 | Office supplies | $ - | |||||||||||
218 | Other | $30.00 | $1,200.00 | $1,140.00 | |||||||||
219 | Postage & frieght | $ - | |||||||||||
220 | Repairs & maintenance | $ - | |||||||||||
221 | Salaries | $ - | |||||||||||
222 | Telecommunications | $ - | |||||||||||
223 | Training | $ - | |||||||||||
224 | Travel | $ - | |||||||||||
225 | Materials & supplies | $ - | |||||||||||
226 | Rentals | $ - | |||||||||||
227 | Membership fees | $ - | |||||||||||
228 | TREATY Total | $30.00 | $15,000.00 | $14,940.00 | |||||||||
229 | Grand Total | $7,699,804.57 | $5,013,988.38 | -$10,385,620.76 | |||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to Jan 31, 2018 | 10 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $1,611,684.39 | $1,934,021.27 | $1,540,417.48 | -$393,603.79 | 175k Taaqwiiaak; 120k Water Filtration costs; $100k Audit | $617,437.57 | ||||
4 | 25 | HEALTH | $847,435.32 | $1,016,922.38 | $1,236,336.96 | $219,414.58 | $526,124.61 | $75,000 added in FNHA funding | ||||
5 | 30 | SOCDEV | $1,013,108.78 | $1,215,730.54 | $1,189,570.66 | -$26,159.87 | $71,863.67 | |||||
6 | 40 | CAPITAL | $1,396,008.67 | $1,675,210.40 | $1,799,494.00 | $124,283.60 | $1,045,677.46 | Prorated Actual | $705,000 added in WWTP DAR funding | |||
7 | 50 | OPSMAINT | $890,914.74 | $1,069,097.69 | $1,030,599.86 | -$38,497.83 | $454,139.59 | $0.00 | $175,000 added WTP funding | |||
8 | 60 | COMMUNITY | $409,274.80 | $491,129.76 | $522,393.60 | $31,263.84 | $37,605.70 | |||||
9 | 70 | FORESTRY | $4,459.55 | $5,351.46 | -$5,351.46 | $4,310.06 | ||||||
10 | 75 | FISHERIES | $229,197.62 | $275,037.14 | $286,773.60 | $11,736.46 | $81,608.03 | $75,000 home use fish funding | ||||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | -$12,721.43 | ||||||
12 | 80 | HOUSING | $623,137.57 | $747,765.08 | $623,583.55 | -$124,181.53 | CMHC renovation funding pending | $228,375.01 | ||||
13 | 90 | TREATY | $24.00 | $28.80 | $15,000.00 | $14,971.20 | $18.00 | |||||
14 | Grand Total | $7,025,245.44 | $8,430,294.53 | $8,535,717.71 | $105,423.19 | $2,286,982.10 | ||||||
15 | $800,770.45 | $711,309.81 | ||||||||||
16 | YTD Actuals = Year to Date Actuals = Actual expenses spent year to date | CONTROL #: Does this agree to cell L21 & L22 on spreadsheet | ||||||||||
17 | Prorated Actual = Year to Date totals divided by number of months so far in the year multiplied by 12 = an estimate of what we will spend for the entire year | 7,025,245.44 | ||||||||||
18 | MAP Budget are the budget numbers that Ahousaht needs to come in at or below. | 291,548.00 | ||||||||||
19 | Variance is the difference between MAP Budget and Prorated Actual amount; negative amounts are bad | Print to PDF, save, then send to INAC quarterly | ||||||||||
20 | ||||||||||||
21 | 2014-15 | 2015-16 | 2016-17 | 2017-18 | ||||||||
22 | Net Debt projected to end of year | 10,135,743 | 9,715,815 | 9,313,285 | 8,927,432 | |||||||
23 | ||||||||||||
24 | BUDGET SUMMARY | Black =Good; Red = Bad | ||||||||||
25 | YTD Actuals | Original Budget (Funding Additions not included) | Prorated Annual Variance | ALL | rbullock@ahousaht.ca | |||||||
26 | 10 | ADMIN | Advertising | $2,262.60 | $2,262.60 | 10 | ADMIN | Council, Rob B | ||||
27 | Audit fees | $35,317.00 | $35,317.00 | 25 | HEALTH | Dave | julia.atelo@ahousaht.ca | |||||
28 | Benefits | $135,095.62 | $115,274.87 | -$154,916.37 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $9,296.94 | $16,998.43 | -$1,595.45 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $629,673.81 | $219,632.15 | -$1,039,715.47 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||
31 | Honoraria | $4,000.00 | -$8,000.00 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||
32 | Insurance | $72,341.04 | $ - | -$144,682.08 | 70 | FORESTRY | ||||||
33 | Legal fees | $26,947.15 | $62,836.25 | $8,941.95 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | ||||
34 | Office supplies | $31,339.58 | $ - | -$62,679.16 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $171,532.28 | $112,318.25 | -$230,746.31 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $935.00 | $23,023.29 | $21,153.29 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $527.93 | $79,340.58 | $78,284.72 | ||||||||
38 | Salaries | $384,723.90 | $455,254.92 | -$314,192.88 | ||||||||
39 | Telecommunications | $64,063.48 | $20,396.21 | -$107,730.75 | ||||||||
40 | Training | $3,136.66 | $8,952.35 | $2,679.03 | ||||||||
41 | Travel | $78,071.00 | $12,863.45 | -$143,278.55 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $1,611,684.39 | $1,165,417.48 | -$2,057,951.30 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $1,048.82 | $ - | -$2,097.64 | ||||||||
47 | Contractual services | $198,880.14 | -$397,760.28 | |||||||||
48 | Honoraria | $1,250.00 | $ - | -$2,500.00 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $75,488.23 | $31,080.00 | -$119,896.46 | ||||||||
52 | Other | $53,876.91 | $5,796.00 | -$101,957.82 | ||||||||
53 | Postage & frieght | $415.00 | $ - | -$830.00 | ||||||||
54 | Repairs & maintenance | $2,386.00 | $31,500.00 | $26,728.00 | ||||||||
55 | Salaries | $351,857.20 | $361,596.00 | -$342,118.40 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $162,233.02 | $41,004.00 | -$283,462.04 | ||||||||
59 | Healthy Baby | $6,000.00 | $6,000.00 | |||||||||
60 | (CW) Workshops | $6,500.00 | $6,500.00 | |||||||||
61 | Youth Activities | $20,799.96 | $20,799.96 | |||||||||
62 | Community Workshops | $23,000.04 | $23,000.04 | |||||||||
63 | HEALTH Total | $847,435.32 | $540,275.96 | -$1,154,594.68 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $6,065.60 | -$12,131.20 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $21,811.55 | -$43,623.10 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $8,633.27 | $ - | -$17,266.54 | ||||||||
72 | Other | $699,226.32 | $920,540.73 | -$477,911.91 | ||||||||
73 | Postage & frieght | $120.00 | -$240.00 | |||||||||
74 | Repairs & maintenance | $7,192.21 | -$14,384.42 | |||||||||
75 | Salaries | $244,137.99 | $108,787.44 | -$379,488.54 | ||||||||
76 | Telecommunications | $ - | ||||||||||
77 | Training | $ - | ||||||||||
78 | Travel | $25,921.84 | $ - | -$51,843.68 | ||||||||
79 | Materials & supplies | $ - | ||||||||||
80 | Special Needs | $27,547.92 | $27,547.92 | |||||||||
81 | Gaurdian Financial Assistance | $ - | ||||||||||
82 | Admin Fee Office Supplies, Rent | $11,100.00 | $11,100.00 | |||||||||
83 | Assisted Living | $38,226.24 | $38,226.24 | |||||||||
84 | Disability | $8,200.00 | $8,200.00 | |||||||||
85 | SOCDEV Total | $1,013,108.78 | $1,114,402.33 | -$911,815.23 | ||||||||
86 | 40 | CAPITAL | Advertising | $ - | ||||||||
87 | Audit fees | $ - | ||||||||||
88 | Benefits | $ - | ||||||||||
89 | Capital | $ - | ||||||||||
90 | Contractual services | $1,122,872.00 | $427,494.00 | -$1,818,250.00 | ||||||||
91 | Honoraria | $ - | ||||||||||
92 | Insurance | $ - | ||||||||||
93 | Legal fees | $ - | ||||||||||
94 | Office supplies | $72,715.83 | $ - | -$145,431.66 | ||||||||
95 | Other | $40,653.18 | -$81,306.36 | |||||||||
96 | Postage & frieght | $7,235.00 | $ - | -$14,470.00 | ||||||||
97 | Repairs & maintenance | $1,718.91 | $50,000.04 | $46,562.22 | ||||||||
98 | Salaries | $20,162.23 | $ - | -$40,324.46 | ||||||||
99 | Telecommunications | $ - | ||||||||||
100 | Training | $1,377.60 | $ - | -$2,755.20 | ||||||||
101 | Travel | $129,273.92 | $3,999.96 | -$254,547.88 | ||||||||
102 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
103 | Rentals | $ - | ||||||||||
104 | Membership fees | $ - | ||||||||||
105 | CAPITAL Total | $1,396,008.67 | $499,494.00 | -$2,292,523.34 | ||||||||
106 | 50 | OPSMAINT | Advertising | $ - | ||||||||
107 | Audit fees | $ - | ||||||||||
108 | Benefits | $5,498.85 | $41,999.98 | $31,002.28 | ||||||||
109 | Capital | $7,966.19 | $ - | -$15,932.38 | ||||||||
110 | Contractual services | $224,166.27 | $ - | -$448,332.54 | ||||||||
111 | Honoraria | $ - | ||||||||||
112 | Insurance | $2,016.00 | $ - | -$4,032.00 | ||||||||
113 | Legal fees | $ - | ||||||||||
114 | Office supplies | $140,877.67 | $ - | -$281,755.34 | ||||||||
115 | Other | $124,832.33 | $14,400.00 | -$235,264.66 | ||||||||
116 | Postage & frieght | $17,432.47 | $ - | -$34,864.94 | ||||||||
117 | Repairs & maintenance | $32,064.63 | $54,000.00 | -$10,129.26 | ||||||||
118 | Salaries | $301,411.23 | $209,999.88 | -$392,822.58 | ||||||||
119 | Telecommunications | $186.63 | $3,600.00 | $3,226.74 | ||||||||
120 | Training | $3,000.00 | $3,000.00 | |||||||||
121 | Travel | $34,462.47 | $ - | -$68,924.94 | ||||||||
122 | Materials & supplies | $ - | ||||||||||
123 | Rentals | $3,600.00 | $3,600.00 | |||||||||
124 | Membership fees | $ - | ||||||||||
125 | OPSMAINT Total | $890,914.74 | $330,599.86 | -$1,451,229.62 | ||||||||
126 | 60 | COMMUNITY | Advertising | $ - | ||||||||
127 | Audit fees | $ - | ||||||||||
128 | Benefits | $7,483.76 | $73,905.60 | $58,938.08 | ||||||||
129 | Capital | $ - | ||||||||||
130 | Contractual services | $25,680.00 | $ - | -$51,360.00 | ||||||||
131 | Honoraria | $31,825.00 | $ - | -$63,650.00 | ||||||||
132 | Insurance | $ - | ||||||||||
133 | Legal fees | $ - | ||||||||||
134 | Office supplies | $11,008.86 | $ - | -$22,017.72 | ||||||||
135 | Other | $79,835.30 | $39,240.00 | -$120,430.60 | ||||||||
136 | Postage & frieght | $40.00 | $ - | -$80.00 | ||||||||
137 | Repairs & maintenance | $3,624.00 | $3,624.00 | |||||||||
138 | Salaries | $137,927.17 | $369,528.00 | $93,673.66 | ||||||||
139 | Telecommunications | $4,511.25 | $ - | -$9,022.50 | ||||||||
140 | Training | $5,544.00 | $5,544.00 | |||||||||
141 | Travel | $110,963.46 | $5,112.00 | -$216,814.92 | ||||||||
142 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
143 | Rentals | $15,948.00 | $15,948.00 | |||||||||
144 | Membership fees | $ - | ||||||||||
145 | COMMUNITY Total | $409,274.80 | $522,393.60 | -$296,156.00 | ||||||||
146 | 70 | Contractual services | $3,677.78 | -$7,355.56 | ||||||||
147 | Salaries | $281.77 | -$563.54 | |||||||||
148 | Travel | $500.00 | -$1,000.00 | |||||||||
149 | 0 Total | $4,459.55 | -$8,919.10 | |||||||||
150 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | |||||||
151 | Benefits | $2,261.62 | $9,503.16 | $4,979.92 | ||||||||
152 | Capital | $756.00 | $ - | -$1,512.00 | ||||||||
153 | Contractual services | $22,724.34 | $ - | -$45,448.68 | ||||||||
154 | Honoraria | $ - | ||||||||||
155 | Insurance | $6,813.27 | $7,700.00 | -$5,926.54 | ||||||||
156 | Legal fees | $ - | ||||||||||
157 | Office supplies | $23,736.82 | $ - | -$47,473.64 | ||||||||
158 | Other | $4,132.68 | $24,000.00 | $15,734.64 | ||||||||
159 | Postage & frieght | $2,266.70 | $ - | -$4,533.40 | ||||||||
160 | Repairs & maintenance | $33,044.94 | $4,400.00 | -$61,689.88 | ||||||||
161 | Salaries | $118,468.64 | $105,310.44 | -$131,626.84 | ||||||||
162 | Training | $3,000.00 | $3,000.00 | |||||||||
163 | Travel | $14,992.61 | $24,000.00 | -$5,985.22 | ||||||||
164 | Materials & supplies | $3,000.00 | $3,000.00 | |||||||||
165 | Rentals | $ - | ||||||||||
166 | Membership fees | $ - | ||||||||||
167 | Admin Fee | $9,120.00 | $9,120.00 | |||||||||
168 | Telecommunications & Utilities | $6,240.00 | $6,240.00 | |||||||||
169 | FISHERIES Total | $229,197.62 | $198,773.60 | -$259,621.64 | ||||||||
170 | 77 | ECONOMIC | Advertising | $6,000.00 | $6,000.00 | |||||||
171 | Audit fees | $ - | ||||||||||
172 | Benefits | $29,754.00 | $29,754.00 | |||||||||
173 | Capital | $10,000.00 | $10,000.00 | |||||||||
174 | Contractual services | $7,500.00 | $7,500.00 | |||||||||
175 | Honoraria | $ - | ||||||||||
176 | Insurance | $ - | ||||||||||
177 | Legal fees | $ - | ||||||||||
178 | Office supplies | $ - | ||||||||||
179 | Other | $50,000.00 | $50,000.00 | |||||||||
180 | Postage & frieght | $ - | ||||||||||
181 | Repairs & maintenance | $22,500.00 | $22,500.00 | |||||||||
182 | Salaries | $148,794.00 | $148,794.00 | |||||||||
183 | Telecommunications | $3,000.00 | $3,000.00 | |||||||||
184 | Training | $ - | ||||||||||
185 | Travel | $ - | ||||||||||
186 | Materials & supplies | $14,000.00 | $14,000.00 | |||||||||
187 | Rentals | $ - | ||||||||||
188 | Membership fees | $ - | ||||||||||
189 | ECONOMIC Total | $291,548.00 | $291,548.00 | |||||||||
190 | 80 | HOUSING | Advertising | $ - | ||||||||
191 | Audit fees | $ - | ||||||||||
192 | Benefits | $4,027.20 | $15,301.26 | $7,246.86 | ||||||||
193 | Capital | $21,947.04 | $ - | -$43,894.08 | ||||||||
194 | Contractual services | $44,059.95 | $13,010.83 | -$75,109.07 | ||||||||
195 | Honoraria | $100.00 | $ - | -$200.00 | ||||||||
196 | Insurance | $1,131.00 | $36,707.44 | $34,445.44 | ||||||||
197 | Legal fees | $ - | ||||||||||
198 | Office supplies | $1,732.74 | $ - | -$3,465.48 | ||||||||
199 | Other | $23,339.99 | $13,575.55 | -$33,104.43 | ||||||||
200 | Postage & frieght | $16,834.30 | $2,091.26 | -$31,577.34 | ||||||||
201 | Repairs & maintenance | $195,775.79 | $57,775.90 | -$333,775.68 | ||||||||
202 | Salaries | $297,429.47 | $66,530.61 | -$528,328.33 | ||||||||
203 | Telecommunications | $124.85 | $124.85 | |||||||||
204 | Training | $ - | ||||||||||
205 | Travel | $16,760.09 | $1,324.90 | -$32,195.28 | ||||||||
206 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||
207 | Membership fees | $ - | ||||||||||
208 | Mortgage | $127,186.00 | $127,186.00 | |||||||||
209 | HOUSING Total | $623,137.57 | $336,083.55 | -$910,191.59 | ||||||||
210 | 90 | TREATY | Advertising | $ - | ||||||||
211 | Audit fees | $ - | ||||||||||
212 | Benefits | $ - | ||||||||||
213 | Capital | $ - | ||||||||||
214 | Contractual services | $1,800.00 | $1,800.00 | |||||||||
215 | Honoraria | $3,000.00 | $3,000.00 | |||||||||
216 | Insurance | $ - | ||||||||||
217 | Legal fees | $9,000.00 | $9,000.00 | |||||||||
218 | Office supplies | $ - | ||||||||||
219 | Other | $24.00 | $1,200.00 | $1,152.00 | ||||||||
220 | Postage & frieght | $ - | ||||||||||
221 | Repairs & maintenance | $ - | ||||||||||
222 | Salaries | $ - | ||||||||||
223 | Telecommunications | $ - | ||||||||||
224 | Training | $ - | ||||||||||
225 | Travel | $ - | ||||||||||
226 | Materials & supplies | $ - | ||||||||||
227 | Rentals | $ - | ||||||||||
228 | Membership fees | $ - | ||||||||||
229 | TREATY Total | $24.00 | $15,000.00 | $14,952.00 | ||||||||
230 | Grand Total | $7,025,245.44 | $5,013,988.38 | |||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to Dec 31, 2017 | 9 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $1,426,591.75 | $1,902,122.33 | $1,540,417.48 | -$361,704.85 | 175k Taaqwiiaak; 120k Water Filtration costs; $100k Audit | $432,344.93 | ||||
4 | 25 | HEALTH | $724,293.41 | $965,724.55 | $1,181,163.46 | $215,438.91 | $402,982.70 | $75,000 added in FNHA funding | ||||
5 | 30 | SOCDEV | $894,050.45 | $1,192,067.27 | $1,182,053.83 | -$10,013.44 | -$47,194.66 | |||||
6 | 40 | CAPITAL | $1,291,148.06 | $1,721,530.75 | $1,799,494.00 | $77,963.25 | $940,816.85 | Prorated Actual | $705,000 added in WWTP DAR funding | |||
7 | 50 | OPSMAINT | $748,577.94 | $998,103.92 | $1,030,599.86 | $32,495.94 | $311,802.79 | $0.00 | $175,000 added WTP funding | |||
8 | 60 | COMMUNITY | $380,724.55 | $507,632.73 | $522,393.60 | $14,760.87 | $9,055.45 | |||||
9 | 70 | FORESTRY | $4,459.55 | $5,946.07 | -$5,946.07 | $4,310.06 | ||||||
10 | 75 | FISHERIES | $213,606.59 | $284,808.79 | $286,773.60 | $1,964.81 | $66,017.00 | $75,000 home use fish funding | ||||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | -$12,721.43 | ||||||
12 | 80 | HOUSING | $541,001.69 | $721,335.59 | $623,583.55 | -$97,752.04 | CMHC renovation funding pending | $146,239.13 | ||||
13 | 90 | TREATY | $21.00 | $28.00 | $15,000.00 | $14,972.00 | $15.00 | |||||
14 | Grand Total | $6,224,474.99 | $8,299,299.99 | $8,473,027.38 | $173,727.39 | $1,486,211.65 | ||||||
15 | $638,876.67 | $706,085.62 | ||||||||||
16 | YTD Actuals = Year to Date Actuals = Actual expenses spent year to date | CONTROL #: Does this agree to cell L21 & L22 on spreadsheet | ||||||||||
17 | Prorated Actual = Year to Date totals divided by number of months so far in the year multiplied by 12 = an estimate of what we will spend for the entire year | 6,224,474.99 | ||||||||||
18 | MAP Budget are the budget numbers that Ahousaht needs to come in at or below. | 291,548.00 | ||||||||||
19 | Variance is the difference between MAP Budget and Prorated Actual amount; negative amounts are bad | Print to PDF, save, then send to INAC quarterly | ||||||||||
20 | ||||||||||||
21 | 2014-15 | 2015-16 | 2016-17 | 2017-18 | ||||||||
22 | Net Debt projected to end of year | 10,135,743 | 9,715,815 | 9,313,285 | 8,927,432 | |||||||
23 | ||||||||||||
24 | BUDGET SUMMARY | Black =Good; Red = Bad | ||||||||||
25 | YTD Actuals | Original Budget (Funding Additions not included) | Prorated Annual Variance | ALL | rbullock@ahousaht.ca | |||||||
26 | 10 | ADMIN | Advertising | $2,262.60 | $2,262.60 | 10 | ADMIN | Council, Rob B | ||||
27 | Audit fees | $35,317.00 | $35,317.00 | 25 | HEALTH | Dave | julia.atelo@ahousaht.ca | |||||
28 | Benefits | $115,618.65 | $115,274.87 | -$115,962.43 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $9,296.94 | $16,998.43 | -$1,595.45 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $568,265.86 | $219,632.15 | -$916,899.57 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||
31 | Honoraria | $4,000.00 | -$8,000.00 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||
32 | Insurance | $55,089.23 | $ - | -$110,178.46 | 70 | FORESTRY | ||||||
33 | Legal fees | $26,947.15 | $62,836.25 | $8,941.95 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | ||||
34 | Office supplies | $27,312.43 | $ - | -$54,624.86 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $143,610.63 | $112,318.25 | -$174,903.01 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $935.00 | $23,023.29 | $21,153.29 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $527.93 | $79,340.58 | $78,284.72 | ||||||||
38 | Salaries | $335,949.58 | $455,254.92 | -$216,644.24 | ||||||||
39 | Telecommunications | $64,063.48 | $20,396.21 | -$107,730.75 | ||||||||
40 | Training | $3,136.66 | $8,952.35 | $2,679.03 | ||||||||
41 | Travel | $71,838.21 | $12,863.45 | -$130,812.97 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $1,426,591.75 | $1,165,417.48 | -$1,687,766.02 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $1,048.82 | $ - | -$2,097.64 | ||||||||
47 | Contractual services | $157,020.63 | -$314,041.26 | |||||||||
48 | Honoraria | $1,250.00 | $ - | -$2,500.00 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $65,348.92 | $31,080.00 | -$99,617.84 | ||||||||
52 | Other | $47,934.41 | $5,796.00 | -$90,072.82 | ||||||||
53 | Postage & frieght | $415.00 | $ - | -$830.00 | ||||||||
54 | Repairs & maintenance | $2,318.50 | $31,500.00 | $26,863.00 | ||||||||
55 | Salaries | $304,830.92 | $361,596.00 | -$248,065.84 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $144,126.21 | $41,004.00 | -$247,248.42 | ||||||||
59 | Healthy Baby | $6,000.00 | $6,000.00 | |||||||||
60 | (CW) Workshops | $6,500.00 | $6,500.00 | |||||||||
61 | Youth Activities | $20,799.96 | $20,799.96 | |||||||||
62 | Community Workshops | $23,000.04 | $23,000.04 | |||||||||
63 | HEALTH Total | $724,293.41 | $540,275.96 | -$908,310.86 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $5,318.68 | -$10,637.36 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $19,417.35 | -$38,834.70 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $8,633.27 | $ - | -$17,266.54 | ||||||||
72 | Other | $617,795.76 | $920,540.73 | -$315,050.79 | ||||||||
73 | Postage & frieght | $120.00 | -$240.00 | |||||||||
74 | Repairs & maintenance | $5,545.80 | -$11,091.60 | |||||||||
75 | Salaries | $211,297.75 | $108,787.44 | -$313,808.06 | ||||||||
76 | Telecommunications | $ - | ||||||||||
77 | Training | $ - | ||||||||||
78 | Travel | $25,921.84 | $ - | -$51,843.68 | ||||||||
79 | Materials & supplies | $ - | ||||||||||
80 | Special Needs | $27,547.92 | $27,547.92 | |||||||||
81 | Gaurdian Financial Assistance | $ - | ||||||||||
82 | Admin Fee Office Supplies, Rent | $11,100.00 | $11,100.00 | |||||||||
83 | Assisted Living | $38,226.24 | $38,226.24 | |||||||||
84 | Disability | $8,200.00 | $8,200.00 | |||||||||
85 | SOCDEV Total | $894,050.45 | $1,114,402.33 | -$673,698.57 | ||||||||
86 | 40 | CAPITAL | Advertising | $ - | ||||||||
87 | Audit fees | $ - | ||||||||||
88 | Benefits | $ - | ||||||||||
89 | Capital | $ - | ||||||||||
90 | Contractual services | $1,047,110.78 | $427,494.00 | -$1,666,727.56 | ||||||||
91 | Honoraria | $ - | ||||||||||
92 | Insurance | $ - | ||||||||||
93 | Legal fees | $ - | ||||||||||
94 | Office supplies | $68,710.98 | $ - | -$137,421.96 | ||||||||
95 | Other | $40,183.64 | -$80,367.28 | |||||||||
96 | Postage & frieght | $7,170.00 | $ - | -$14,340.00 | ||||||||
97 | Repairs & maintenance | $1,718.91 | $50,000.04 | $46,562.22 | ||||||||
98 | Salaries | $20,162.23 | $ - | -$40,324.46 | ||||||||
99 | Telecommunications | $ - | ||||||||||
100 | Training | $1,377.60 | $ - | -$2,755.20 | ||||||||
101 | Travel | $104,713.92 | $3,999.96 | -$205,427.88 | ||||||||
102 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
103 | Rentals | $ - | ||||||||||
104 | Membership fees | $ - | ||||||||||
105 | CAPITAL Total | $1,291,148.06 | $499,494.00 | -$2,082,802.12 | ||||||||
106 | 50 | OPSMAINT | Advertising | $ - | ||||||||
107 | Audit fees | $ - | ||||||||||
108 | Benefits | $4,676.92 | $41,999.98 | $32,646.14 | ||||||||
109 | Capital | $7,966.19 | $ - | -$15,932.38 | ||||||||
110 | Contractual services | $207,180.17 | $ - | -$414,360.34 | ||||||||
111 | Honoraria | $ - | ||||||||||
112 | Insurance | $2,016.00 | $ - | -$4,032.00 | ||||||||
113 | Legal fees | $ - | ||||||||||
114 | Office supplies | $119,145.15 | $ - | -$238,290.30 | ||||||||
115 | Other | $64,044.20 | $14,400.00 | -$113,688.40 | ||||||||
116 | Postage & frieght | $16,662.09 | $ - | -$33,324.18 | ||||||||
117 | Repairs & maintenance | $31,097.80 | $54,000.00 | -$8,195.60 | ||||||||
118 | Salaries | $263,633.68 | $209,999.88 | -$317,267.48 | ||||||||
119 | Telecommunications | $186.63 | $3,600.00 | $3,226.74 | ||||||||
120 | Training | $3,000.00 | $3,000.00 | |||||||||
121 | Travel | $31,969.11 | $ - | -$63,938.22 | ||||||||
122 | Materials & supplies | $ - | ||||||||||
123 | Rentals | $3,600.00 | $3,600.00 | |||||||||
124 | Membership fees | $ - | ||||||||||
125 | OPSMAINT Total | $748,577.94 | $330,599.86 | -$1,166,556.02 | ||||||||
126 | 60 | COMMUNITY | Advertising | $ - | ||||||||
127 | Audit fees | $ - | ||||||||||
128 | Benefits | $6,498.16 | $73,905.60 | $60,909.28 | ||||||||
129 | Capital | $ - | ||||||||||
130 | Contractual services | $25,680.00 | $ - | -$51,360.00 | ||||||||
131 | Honoraria | $31,075.00 | $ - | -$62,150.00 | ||||||||
132 | Insurance | $ - | ||||||||||
133 | Legal fees | $ - | ||||||||||
134 | Office supplies | $10,583.80 | $ - | -$21,167.60 | ||||||||
135 | Other | $75,600.00 | $39,240.00 | -$111,960.00 | ||||||||
136 | Postage & frieght | $40.00 | $ - | -$80.00 | ||||||||
137 | Repairs & maintenance | $3,624.00 | $3,624.00 | |||||||||
138 | Salaries | $123,250.74 | $369,528.00 | $123,026.52 | ||||||||
139 | Telecommunications | $4,207.50 | $ - | -$8,415.00 | ||||||||
140 | Training | $5,544.00 | $5,544.00 | |||||||||
141 | Travel | $103,789.35 | $5,112.00 | -$202,466.70 | ||||||||
142 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
143 | Rentals | $15,948.00 | $15,948.00 | |||||||||
144 | Membership fees | $ - | ||||||||||
145 | COMMUNITY Total | $380,724.55 | $522,393.60 | -$239,055.50 | ||||||||
146 | 70 | Contractual services | $3,677.78 | -$7,355.56 | ||||||||
147 | Salaries | $281.77 | -$563.54 | |||||||||
148 | Travel | $500.00 | -$1,000.00 | |||||||||
149 | 0 Total | $4,459.55 | -$8,919.10 | |||||||||
150 | 75 | FISHERIES | Audit fees | $2,500.00 | $2,500.00 | |||||||
151 | Benefits | $1,951.38 | $9,503.16 | $5,600.40 | ||||||||
152 | Capital | $756.00 | $ - | -$1,512.00 | ||||||||
153 | Contractual services | $22,724.34 | $ - | -$45,448.68 | ||||||||
154 | Honoraria | $ - | ||||||||||
155 | Insurance | $6,813.27 | $7,700.00 | -$5,926.54 | ||||||||
156 | Legal fees | $ - | ||||||||||
157 | Office supplies | $24,649.75 | $ - | -$49,299.50 | ||||||||
158 | Other | $3,679.51 | $24,000.00 | $16,640.98 | ||||||||
159 | Postage & frieght | $2,266.70 | $ - | -$4,533.40 | ||||||||
160 | Repairs & maintenance | $33,044.94 | $4,400.00 | -$61,689.88 | ||||||||
161 | Salaries | $103,184.99 | $105,310.44 | -$101,059.54 | ||||||||
162 | Training | $3,000.00 | $3,000.00 | |||||||||
163 | Travel | $14,535.71 | $24,000.00 | -$5,071.42 | ||||||||
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 | $213,606.59 | $198,773.60 | -$228,439.58 | ||||||||
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 | $3,521.37 | $15,301.26 | $8,258.52 | ||||||||
193 | Capital | $16,513.14 | $ - | -$33,026.28 | ||||||||
194 | Contractual services | $44,059.95 | $13,010.83 | -$75,109.07 | ||||||||
195 | Honoraria | $ - | ||||||||||
196 | Insurance | $1,131.00 | $36,707.44 | $34,445.44 | ||||||||
197 | Legal fees | $ - | ||||||||||
198 | Office supplies | $1,475.70 | $ - | -$2,951.40 | ||||||||
199 | Other | $22,925.52 | $13,575.55 | -$32,275.49 | ||||||||
200 | Postage & frieght | $14,884.30 | $2,091.26 | -$27,677.34 | ||||||||
201 | Repairs & maintenance | $168,633.04 | $57,775.90 | -$279,490.18 | ||||||||
202 | Salaries | $253,444.82 | $66,530.61 | -$440,359.03 | ||||||||
203 | Telecommunications | $124.85 | $124.85 | |||||||||
204 | Training | $ - | ||||||||||
205 | Travel | $14,412.85 | $1,324.90 | -$27,500.80 | ||||||||
206 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||
207 | Membership fees | $ - | ||||||||||
208 | Mortgage | $127,186.00 | $127,186.00 | |||||||||
209 | HOUSING Total | $541,001.69 | $336,083.55 | -$745,919.83 | ||||||||
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 | $21.00 | $1,200.00 | $1,158.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 | $21.00 | $15,000.00 | $14,958.00 | ||||||||
230 | Grand Total | $6,224,474.99 | $5,013,988.38 | |||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to Nov 30, 2017 | 8 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $1,266,417.53 | $1,899,626.30 | $1,640,417.48 | -$259,208.82 | 175k Taaqwiiaak; 120k Water Filtration costs | $272,170.71 | ||||
4 | 25 | HEALTH | $630,412.88 | $945,619.32 | $1,125,989.96 | $180,370.64 | $309,102.17 | $75,000 added in FNHA funding | ||||
5 | 30 | SOCDEV | $786,158.98 | $1,179,238.47 | $1,074,537.00 | -$104,701.47 | -$155,086.13 | |||||
6 | 40 | CAPITAL | $1,210,740.54 | $1,816,110.81 | $1,799,494.00 | -$16,616.81 | $860,409.33 | Prorated Actual | $705,000 added in WWTP DAR funding | |||
7 | 50 | OPSMAINT | $701,807.33 | $1,052,711.00 | $1,030,599.86 | -$22,111.13 | $265,032.18 | $0.00 | $175,000 added WTP funding | |||
8 | 60 | COMMUNITY | $341,745.78 | $512,618.67 | $522,393.60 | $9,774.93 | -$29,923.32 | |||||
9 | 70 | FORESTRY | $2,459.17 | $3,688.76 | -$3,688.76 | $2,309.68 | ||||||
10 | 75 | FISHERIES | $184,569.25 | $276,853.88 | $286,773.60 | $9,919.72 | $36,979.66 | $75,000 home use fish funding | ||||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | -$12,721.43 | ||||||
12 | 80 | HOUSING | $461,265.86 | $691,898.79 | $623,583.55 | -$68,315.24 | $66,503.30 | |||||
13 | 90 | TREATY | $21.00 | $31.50 | $15,000.00 | $14,968.50 | $15.00 | |||||
14 | Grand Total | $5,585,598.32 | $8,378,397.48 | $8,410,337.05 | $31,939.57 | $847,334.98 | ||||||
15 | $598,521.40 | $700,861.42 | ||||||||||
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 | 5,585,598.32 | ||||||||||
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 | $675,034.75 | 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 | $130,051.53 | $115,274.87 | -$144,828.19 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $9,139.16 | $16,998.43 | -$1,279.89 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $483,726.86 | $219,632.15 | -$747,821.57 | 50 | OPSMAINT | Alec | alec.dick@ahousaht.ca | ||||
31 | Honoraria | $4,000.00 | -$8,000.00 | 60 | COMMUNITY | Dave, Robert | julia.atelo@ahousaht.ca; robert.atleo@ahousaht.ca | |||||
32 | Insurance | $37,332.42 | $ - | -$74,664.84 | 70 | FORESTRY | ||||||
33 | Legal fees | $26,947.15 | $62,836.25 | $8,941.95 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | ||||
34 | Office supplies | $26,588.18 | $ - | -$53,176.36 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $123,498.77 | $112,318.25 | -$134,679.29 | 80 | HOUSING | Patti | caroline.atleo@ahousaht.ca | ||||
36 | Postage & frieght | $915.00 | $23,023.29 | $21,193.29 | 90 | TREATY | ||||||
37 | Repairs & maintenance | $527.93 | $79,340.58 | $78,284.72 | ||||||||
38 | Salaries | $306,779.42 | $455,254.92 | -$158,303.92 | ||||||||
39 | Telecommunications | $56,857.67 | $20,396.21 | -$93,319.13 | ||||||||
40 | Training | $3,136.66 | $8,952.35 | $2,679.03 | ||||||||
41 | Travel | $56,916.78 | $12,863.45 | -$100,970.11 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $1,266,417.53 | $1,165,417.48 | -$1,367,417.58 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $1,048.82 | $ - | -$2,097.64 | ||||||||
47 | Contractual services | $124,385.67 | -$248,771.34 | |||||||||
48 | Honoraria | $750.00 | $ - | -$1,500.00 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $62,500.69 | $31,080.00 | -$93,921.38 | ||||||||
52 | Other | $40,877.54 | $5,796.00 | -$75,959.08 | ||||||||
53 | Postage & frieght | $415.00 | $ - | -$830.00 | ||||||||
54 | Repairs & maintenance | $1,674.10 | $31,500.00 | $28,151.80 | ||||||||
55 | Salaries | $272,119.20 | $361,596.00 | -$182,642.40 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $126,641.86 | $41,004.00 | -$212,279.72 | ||||||||
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 | $630,412.88 | $540,275.96 | -$720,549.80 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $4,855.22 | -$9,710.44 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $18,237.95 | -$36,475.90 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $8,621.19 | $ - | -$17,242.38 | ||||||||
72 | Other | $544,738.20 | $920,540.73 | -$168,935.67 | ||||||||
73 | Postage & frieght | $65.00 | -$130.00 | |||||||||
74 | Repairs & maintenance | $4,273.76 | -$8,547.52 | |||||||||
75 | Salaries | $189,837.22 | $108,787.44 | -$270,887.00 | ||||||||
76 | Telecommunications | $ - | ||||||||||
77 | Training | $ - | ||||||||||
78 | Travel | $15,530.44 | $ - | -$31,060.88 | ||||||||
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 | $786,158.98 | $1,114,402.33 | -$457,915.63 | ||||||||
86 | 40 | CAPITAL | Advertising | $ - | ||||||||
87 | Audit fees | $ - | ||||||||||
88 | Benefits | $ - | ||||||||||
89 | Capital | $ - | ||||||||||
90 | Contractual services | $977,880.03 | $427,494.00 | -$1,528,266.06 | ||||||||
91 | Honoraria | $ - | ||||||||||
92 | Insurance | $ - | ||||||||||
93 | Legal fees | $ - | ||||||||||
94 | Office supplies | $68,710.98 | $ - | -$137,421.96 | ||||||||
95 | Other | $40,113.27 | -$80,226.54 | |||||||||
96 | Postage & frieght | $7,170.00 | $ - | -$14,340.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 | $1,377.60 | $ - | -$2,755.20 | ||||||||
101 | Travel | $93,813.92 | $3,999.96 | -$183,627.88 | ||||||||
102 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
103 | Rentals | $ - | ||||||||||
104 | Membership fees | $ - | ||||||||||
105 | CAPITAL Total | $1,210,740.54 | $499,494.00 | -$1,921,987.08 | ||||||||
106 | 50 | OPSMAINT | Advertising | $ - | ||||||||
107 | Audit fees | $ - | ||||||||||
108 | Benefits | $4,186.44 | $41,999.98 | $33,627.10 | ||||||||
109 | Capital | $7,966.19 | $ - | -$15,932.38 | ||||||||
110 | Contractual services | $197,526.34 | $ - | -$395,052.68 | ||||||||
111 | Honoraria | $ - | ||||||||||
112 | Insurance | $2,016.00 | $ - | -$4,032.00 | ||||||||
113 | Legal fees | $ - | ||||||||||
114 | Office supplies | $113,737.30 | $ - | -$227,474.60 | ||||||||
115 | Other | $63,597.95 | $14,400.00 | -$112,795.90 | ||||||||
116 | Postage & frieght | $16,662.09 | $ - | -$33,324.18 | ||||||||
117 | Repairs & maintenance | $29,670.58 | $54,000.00 | -$5,341.16 | ||||||||
118 | Salaries | $235,922.08 | $209,999.88 | -$261,844.28 | ||||||||
119 | Telecommunications | $186.63 | $3,600.00 | $3,226.74 | ||||||||
120 | Training | $3,000.00 | $3,000.00 | |||||||||
121 | Travel | $30,335.73 | $ - | -$60,671.46 | ||||||||
122 | Materials & supplies | $ - | ||||||||||
123 | Rentals | $3,600.00 | $3,600.00 | |||||||||
124 | Membership fees | $ - | ||||||||||
125 | OPSMAINT Total | $701,807.33 | $330,599.86 | -$1,073,014.80 | ||||||||
126 | 60 | COMMUNITY | Advertising | $ - | ||||||||
127 | Audit fees | $ - | ||||||||||
128 | Benefits | $5,794.45 | $73,905.60 | $62,316.70 | ||||||||
129 | Capital | $ - | ||||||||||
130 | Contractual services | $25,680.00 | $ - | -$51,360.00 | ||||||||
131 | Honoraria | $25,075.00 | $ - | -$50,150.00 | ||||||||
132 | Insurance | $ - | ||||||||||
133 | Legal fees | $ - | ||||||||||
134 | Office supplies | $8,427.80 | $ - | -$16,855.60 | ||||||||
135 | Other | $63,209.18 | $39,240.00 | -$87,178.36 | ||||||||
136 | Postage & frieght | $40.00 | $ - | -$80.00 | ||||||||
137 | Repairs & maintenance | $3,624.00 | $3,624.00 | |||||||||
138 | Salaries | $113,556.60 | $369,528.00 | $142,414.80 | ||||||||
139 | Telecommunications | $3,525.00 | $ - | -$7,050.00 | ||||||||
140 | Training | $5,544.00 | $5,544.00 | |||||||||
141 | Travel | $96,437.75 | $5,112.00 | -$187,763.50 | ||||||||
142 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
143 | Rentals | $15,948.00 | $15,948.00 | |||||||||
144 | Membership fees | $ - | ||||||||||
145 | COMMUNITY Total | $341,745.78 | $522,393.60 | -$161,097.96 | ||||||||
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,852.12 | $9,503.16 | $5,798.92 | ||||||||
152 | Capital | $756.00 | $ - | -$1,512.00 | ||||||||
153 | Contractual services | $22,361.35 | $ - | -$44,722.70 | ||||||||
154 | Honoraria | $ - | ||||||||||
155 | Insurance | $7,700.00 | $7,700.00 | |||||||||
156 | Legal fees | $ - | ||||||||||
157 | Office supplies | $21,722.42 | $ - | -$43,444.84 | ||||||||
158 | Other | $3,084.04 | $24,000.00 | $17,831.92 | ||||||||
159 | Postage & frieght | $2,266.70 | $ - | -$4,533.40 | ||||||||
160 | Repairs & maintenance | $26,643.75 | $4,400.00 | -$48,887.50 | ||||||||
161 | Salaries | $92,550.86 | $105,310.44 | -$79,791.28 | ||||||||
162 | Training | $3,000.00 | $3,000.00 | |||||||||
163 | Travel | $13,332.01 | $24,000.00 | -$2,664.02 | ||||||||
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 | $184,569.25 | $198,773.60 | -$170,364.90 | ||||||||
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 | $3,238.26 | $15,301.26 | $8,824.74 | ||||||||
193 | Capital | $14,235.14 | $ - | -$28,470.28 | ||||||||
194 | Contractual services | $43,455.00 | $13,010.83 | -$73,899.17 | ||||||||
195 | Honoraria | $ - | ||||||||||
196 | Insurance | $1,131.00 | $36,707.44 | $34,445.44 | ||||||||
197 | Legal fees | $ - | ||||||||||
198 | Office supplies | $1,475.70 | $ - | -$2,951.40 | ||||||||
199 | Other | $21,774.66 | $13,575.55 | -$29,973.77 | ||||||||
200 | Postage & frieght | $11,284.30 | $2,091.26 | -$20,477.34 | ||||||||
201 | Repairs & maintenance | $136,665.71 | $57,775.90 | -$215,555.52 | ||||||||
202 | Salaries | $214,181.72 | $66,530.61 | -$361,832.83 | ||||||||
203 | Telecommunications | $124.85 | $124.85 | |||||||||
204 | Training | $ - | ||||||||||
205 | Travel | $13,824.37 | $1,324.90 | -$26,323.84 | ||||||||
206 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||
207 | Membership fees | $ - | ||||||||||
208 | Mortgage | $127,186.00 | $127,186.00 | |||||||||
209 | HOUSING Total | $461,265.86 | $336,083.55 | -$586,448.17 | ||||||||
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 | $21.00 | $1,200.00 | $1,158.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 | $21.00 | $15,000.00 | $14,958.00 | ||||||||
230 | Grand Total | $5,585,598.32 | $5,013,988.38 | |||||||||
1 | 2017-18 Fiscal Year | April 1, 2017 to Oct 31, 2017 | 7 | MONTHS | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Dept# | Dept | YTD Actuals | Prorated Actual | Budget | Expected Year End Variance | Month to month spending | Notes | ||||
3 | 10 | ADMIN | $1,129,266.77 | $1,935,885.89 | $1,640,417.48 | -$295,468.41 | 175k Taaqwiiaak; 120k Water Filtration costs | $135,019.95 | ||||
4 | 25 | HEALTH | $535,188.22 | $917,465.52 | $1,070,816.46 | $153,350.94 | $213,877.51 | $75,000 added in FNHA funding | ||||
5 | 30 | SOCDEV | $676,200.32 | $1,159,200.55 | $1,050,353.50 | -$108,847.05 | -$265,044.79 | |||||
6 | 40 | CAPITAL | $1,113,294.85 | $1,908,505.46 | $1,999,494.00 | $90,988.54 | $762,963.64 | Prorated Actual | $705,000 added in WWTP DAR funding | |||
7 | 50 | OPSMAINT | $653,032.22 | $1,119,483.81 | $1,030,599.86 | -$88,883.95 | $216,257.07 | $0.00 | $175,000 added WTP funding | |||
8 | 60 | COMMUNITY | $307,119.68 | $526,490.88 | $522,393.60 | -$4,097.28 | -$64,549.42 | |||||
9 | 70 | FORESTRY | $2,459.17 | $4,215.72 | -$4,215.72 | $2,309.68 | ||||||
10 | 75 | FISHERIES | $157,294.36 | $269,647.47 | $286,773.60 | $17,126.13 | $9,704.77 | $75,000 home use fish funding | ||||
11 | 77 | ECONOMIC | $0.00 | $291,548.00 | $291,548.00 | -$12,721.43 | ||||||
12 | 80 | HOUSING | $413,203.33 | $708,348.57 | $623,583.55 | -$84,765.02 | $18,440.77 | |||||
13 | 90 | TREATY | $18.00 | $30.86 | $15,000.00 | $14,969.14 | $12.00 | |||||
14 | Grand Total | $4,987,076.92 | $8,549,274.72 | $8,530,980.05 | -$18,294.67 | $248,813.58 | ||||||
15 | $1,002,716.48 | $710,915.00 | ||||||||||
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 | 4,987,076.92 | ||||||||||
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 | $537,883.99 | 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 | $120,849.90 | $115,274.87 | -$126,424.93 | 30 | SOCDEV | Robert | robert.atleo@ahousaht.ca | ||||
29 | Capital | $9,060.27 | $16,998.43 | -$1,122.11 | 40 | CAPITAL | Alec, Rob B | alec.dick@ahousaht.ca | ||||
30 | Contractual services | $424,888.45 | $219,632.15 | -$630,144.75 | 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 | $37,332.42 | $ - | -$74,664.84 | 70 | FORESTRY | ||||||
33 | Legal fees | $26,947.15 | $62,836.25 | $8,941.95 | 75 | FISHERIES | Luke | luke.swan@ahousaht.ca | ||||
34 | Office supplies | $25,833.73 | $ - | -$51,667.46 | 77 | ECONOMIC | Council, Rob | |||||
35 | Other | $107,015.63 | $112,318.25 | -$101,713.01 | 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 | $270,233.72 | $455,254.92 | -$85,212.52 | ||||||||
39 | Telecommunications | $54,460.69 | $20,396.21 | -$88,525.17 | ||||||||
40 | Training | $3,136.66 | $8,952.35 | $2,679.03 | ||||||||
41 | Travel | $44,623.15 | $12,863.45 | -$76,382.85 | ||||||||
42 | Membership fees | $947.13 | $947.13 | |||||||||
43 | ADMIN Total | $1,129,266.77 | $1,165,417.48 | -$1,093,116.06 | ||||||||
44 | 25 | HEALTH | Advertising | $ - | ||||||||
45 | Audit fees | $ - | ||||||||||
46 | Capital | $1,019.57 | $ - | -$2,039.14 | ||||||||
47 | Contractual services | $108,060.88 | -$216,121.76 | |||||||||
48 | Honoraria | $750.00 | $ - | -$1,500.00 | ||||||||
49 | Insurance | $ - | ||||||||||
50 | Legal fees | $ - | ||||||||||
51 | Office supplies | $58,680.84 | $31,080.00 | -$86,281.68 | ||||||||
52 | Other | $33,372.79 | $5,796.00 | -$60,949.58 | ||||||||
53 | Postage & frieght | $355.00 | $ - | -$710.00 | ||||||||
54 | Repairs & maintenance | $1,537.10 | $31,500.00 | $28,425.80 | ||||||||
55 | Salaries | $240,284.57 | $361,596.00 | -$118,973.14 | ||||||||
56 | Telecommunications | $12,999.96 | $12,999.96 | |||||||||
57 | Training | $ - | ||||||||||
58 | Travel | $91,127.47 | $41,004.00 | -$141,250.94 | ||||||||
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 | $535,188.22 | $540,275.96 | -$530,100.48 | ||||||||
64 | 30 | SOCDEV | Advertising | $ - | ||||||||
65 | Audit fees | $ - | ||||||||||
66 | Benefits | $4,395.46 | -$8,790.92 | |||||||||
67 | Capital | $ - | ||||||||||
68 | Contractual services | $13,686.15 | -$27,372.30 | |||||||||
69 | Honoraria | $ - | ||||||||||
70 | Legal fees | $ - | ||||||||||
71 | Office supplies | $6,371.80 | $ - | -$12,743.60 | ||||||||
72 | Other | $467,665.73 | $920,540.73 | -$14,790.73 | ||||||||
73 | Postage & frieght | $65.00 | -$130.00 | |||||||||
74 | Repairs & maintenance | $2,594.92 | -$5,189.84 | |||||||||
75 | Salaries | $167,532.08 | $108,787.44 | -$226,276.72 | ||||||||
76 | Telecommunications | $ - | ||||||||||
77 | Training | $ - | ||||||||||
78 | Travel | $13,889.18 | $ - | -$27,778.36 | ||||||||
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 | $676,200.32 | $1,114,402.33 | -$237,998.31 | ||||||||
86 | 40 | CAPITAL | Advertising | $ - | ||||||||
87 | Audit fees | $ - | ||||||||||
88 | Benefits | $ - | ||||||||||
89 | Capital | $ - | ||||||||||
90 | Contractual services | $901,471.62 | $427,494.00 | -$1,375,449.24 | ||||||||
91 | Honoraria | $ - | ||||||||||
92 | Insurance | $ - | ||||||||||
93 | Legal fees | $ - | ||||||||||
94 | Office supplies | $66,670.98 | $ - | -$133,341.96 | ||||||||
95 | Other | $27,723.13 | -$55,446.26 | |||||||||
96 | Postage & frieght | $1,710.00 | $ - | -$3,420.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 | $1,377.60 | $ - | -$2,755.20 | ||||||||
101 | Travel | $92,666.78 | $3,999.96 | -$181,333.60 | ||||||||
102 | Materials & supplies | $18,000.00 | $18,000.00 | |||||||||
103 | Rentals | $ - | ||||||||||
104 | Membership fees | $ - | ||||||||||
105 | CAPITAL Total | $1,113,294.85 | $499,494.00 | -$1,727,095.70 | ||||||||
106 | 50 | OPSMAINT | Advertising | $ - | ||||||||
107 | Audit fees | $ - | ||||||||||
108 | Benefits | $3,690.03 | $41,999.98 | $34,619.92 | ||||||||
109 | Capital | $7,966.19 | $ - | -$15,932.38 | ||||||||
110 | Contractual services | $184,754.59 | $ - | -$369,509.18 | ||||||||
111 | Honoraria | $ - | ||||||||||
112 | Insurance | $2,016.00 | $ - | -$4,032.00 | ||||||||
113 | Legal fees | $ - | ||||||||||
114 | Office supplies | $111,914.67 | $ - | -$223,829.34 | ||||||||
115 | Other | $63,399.65 | $14,400.00 | -$112,399.30 | ||||||||
116 | Postage & frieght | $12,122.74 | $ - | -$24,245.48 | ||||||||
117 | Repairs & maintenance | $29,181.63 | $54,000.00 | -$4,363.26 | ||||||||
118 | Salaries | $210,399.99 | $209,999.88 | -$210,800.10 | ||||||||
119 | Telecommunications | $3,600.00 | $3,600.00 | |||||||||
120 | Training | $3,000.00 | $3,000.00 | |||||||||
121 | Travel | $27,586.73 | $ - | -$55,173.46 | ||||||||
122 | Materials & supplies | $ - | ||||||||||
123 | Rentals | $3,600.00 | $3,600.00 | |||||||||
124 | Membership fees | $ - | ||||||||||
125 | OPSMAINT Total | $653,032.22 | $330,599.86 | -$975,464.58 | ||||||||
126 | 60 | COMMUNITY | Advertising | $ - | ||||||||
127 | Audit fees | $ - | ||||||||||
128 | Benefits | $5,182.34 | $73,905.60 | $63,540.92 | ||||||||
129 | Capital | $ - | ||||||||||
130 | Contractual services | $25,680.00 | $ - | -$51,360.00 | ||||||||
131 | Honoraria | $16,875.00 | $ - | -$33,750.00 | ||||||||
132 | Insurance | $ - | ||||||||||
133 | Legal fees | $ - | ||||||||||
134 | Office supplies | $8,427.80 | $ - | -$16,855.60 | ||||||||
135 | Other | $59,150.78 | $39,240.00 | -$79,061.56 | ||||||||
136 | Postage & frieght | $40.00 | $ - | -$80.00 | ||||||||
137 | Repairs & maintenance | $3,624.00 | $3,624.00 | |||||||||
138 | Salaries | $103,862.46 | $369,528.00 | $161,803.08 | ||||||||
139 | Telecommunications | $3,150.00 | $ - | -$6,300.00 | ||||||||
140 | Training | $5,544.00 | $5,544.00 | |||||||||
141 | Travel | $84,751.30 | $5,112.00 | -$164,390.60 | ||||||||
142 | Materials & supplies | $9,492.00 | $9,492.00 | |||||||||
143 | Rentals | $15,948.00 | $15,948.00 | |||||||||
144 | Membership fees | $ - | ||||||||||
145 | COMMUNITY Total | $307,119.68 | $522,393.60 | -$91,845.76 | ||||||||
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,641.16 | $9,503.16 | $6,220.84 | ||||||||
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 | $14,311.25 | $ - | -$28,622.50 | ||||||||
158 | Other | $2,612.44 | $24,000.00 | $18,775.12 | ||||||||
159 | Postage & frieght | $3,355.00 | $ - | -$6,710.00 | ||||||||
160 | Repairs & maintenance | $23,808.15 | $4,400.00 | -$43,216.30 | ||||||||
161 | Salaries | $81,831.23 | $105,310.44 | -$58,352.02 | ||||||||
162 | Training | $3,000.00 | $3,000.00 | |||||||||
163 | Travel | $7,654.13 | $24,000.00 | $8,691.74 | ||||||||
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 | $157,294.36 | $198,773.60 | -$115,815.12 | ||||||||
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,891.73 | $15,301.26 | $9,517.80 | ||||||||
193 | Capital | $14,030.72 | $ - | -$28,061.44 | ||||||||
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,429.97 | $ - | -$2,859.94 | ||||||||
199 | Other | $21,558.77 | $13,575.55 | -$29,541.99 | ||||||||
200 | Postage & frieght | $9,924.30 | $2,091.26 | -$17,757.34 | ||||||||
201 | Repairs & maintenance | $125,843.60 | $57,775.90 | -$193,911.30 | ||||||||
202 | Salaries | $182,167.93 | $66,530.61 | -$297,805.25 | ||||||||
203 | Telecommunications | $124.85 | $124.85 | |||||||||
204 | Training | $ - | ||||||||||
205 | Travel | $12,525.31 | $1,324.90 | -$23,725.72 | ||||||||
206 | Materials & supplies | $2,454.96 | $2,454.96 | |||||||||
207 | Membership fees | $ - | ||||||||||
208 | Mortgage | $127,186.00 | $127,186.00 | |||||||||
209 | HOUSING Total | $413,203.33 | $336,083.55 | -$490,323.11 | ||||||||
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 | $18.00 | $1,200.00 | $1,164.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 | $18.00 | $15,000.00 | $14,964.00 | ||||||||
230 | Grand Total | $4,987,076.92 | $5,013,988.38 | |||||||||
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.2 | ||||||||