{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["MAX Budget","Budget Calculation","In-Kind Contribution","Budget Calculation Example"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MAX Budget","index":0,"n_rows":87,"n_cols":4,"rows_kept":87,"cut":false,"hidden":false,"merged":[[4,2,5,2],[4,3,5,4],[4,1,5,1],[7,0,9,0],[7,1,9,1],[7,2,9,2],[33,2,44,2],[81,3,82,3],[2,1,2,3],[19,0,23,0],[19,1,23,1],[19,2,23,2],[24,0,32,0],[24,1,32,1],[24,2,32,2],[10,0,12,0],[10,1,12,1],[10,2,12,2],[13,0,15,0],[13,1,15,1],[13,2,15,2],[4,0,5,0],[1,1,1,3],[0,1,0,3],[75,0,83,0],[75,1,83,1],[75,2,83,2],[60,0,71,0],[60,1,71,1],[60,2,71,2],[45,0,52,0],[45,1,52,1],[45,2,52,2],[53,0,59,0],[53,1,59,1],[53,2,59,2],[33,0,44,0],[33,1,44,1]]}
["Organization:"]
["Project Title:","MentorAbility 2.0"]
["Start & End Dates:","November 1, 2025 to May  31, 2026"]
[]
["Category Details","Example","Final Budget","Detailed Budget Description & Calculation"]
[]
["1.A.  Administrative Costs"]
["f.  Insurance",null,{"$f":"'Budget Calculation'!C8","v":0}]
[null,null,null,"Liability Insurance"]
[]
["i.  Materials and office supplies",null,{"$f":"'Budget Calculation'!C11","v":0}]
[null,null,null,"Office Supplies"]
[]
["m.  Postage and courier fees",null,{"$f":"'Budget Calculation'!C14","v":0}]
[null,null,null,"Postage and/or Courier"]
[]
["Total Administrative costs",950,{"$f":"SUM(C8:C16)","v":0},"MAXIMUM ADMIN COSTS: $950.00"]
[]
["3C.  Project Costs"]
["a.  Advertising",15000,{"$f":"'Budget Calculation'!C20","v":0}]
[null,null,null,"Social Media"]
[null,null,null,"Social Media Advertisements"]
[]
[null,null,null,"MAX: 15,000"]
["d.  Equipment lease or purchase, software, etc",1500,{"$f":"'Budget Calculation'!C27","v":0}]
[null,null,null,"Laptops (note: $999 or less per computer)"]
[null,null,null,"Adobe"]
[null,null,null,"Zoom - Business"]
[null,null,null,"MS Office Business"]
[null,null,null,"MailChimp/Simply Cast"]
[null,null,null,"Other (please specify)"]
[]
[null,null,null,"MAX: 1500"]
["f.  GST/HST/PST (automatically calculated)",null,{"$f":"'Budget Calculation'!C36","v":0},"1A.f. Insurance"]
[null,null,null,"1.A.i. Materials & Supplies"]
[null,null,null,"1.A.m. Postage & Courier"]
[null,null,null,"3.C.a. Advertising"]
[null,null,null,"3.C.d. Equipment lease"]
[null,null,null,"3.C.g. Hospitality"]
[null,null,null,"3.C.j. Professional Fees"]
[null,null,null,"3.C.m. Significant project costs"]
[null,null,null,"3.E.a. Staff Travel"]
[]
[]
[null,null,null,"This section will auto-populate"]
["g.  Hospitality",7000,{"$f":"'Budget Calculation'!C48","v":0}]
[null,null,null,"Service Provider and Jobseker Engagement"]
[null,null,null,"Employer Engagement "]
[null,null,null,"Employer Lunch & Learns"]
[null,null,null,"Other (please specify)"]
[]
[]
[null,null,null,"MAX: $7,000"]
["j.  Professional fees related to project activities",96000,{"$f":"'Budget Calculation'!C56","v":0}]
[null,null,null,"Project Coordinator (FT)"]
[null,null,null,"Facilitator (FT)"]
[null,null,null,"Financial Coordinator(max 1 day per week)"]
[]
[null,null,null,"MAX: $96,000"]
[null,null,null,"NOTE:  The RRSP and health plan rate formula will need to be adjusted based on your organizational policies and/or costs."]
["m.  Significant project costs for:  contracting, internet & other IT, postage, printing, Staff PD & telephone",{"$f":"500+2000","v":2500},{"$f":"'Budget Calculation'!C63","v":0}]
[null,null,null,"EN/FR/Other Translation"]
[null,null,null,"Plain Language"]
[null,null,null,"ASL/LSQ Interpreters"]
[null,null,null,"MAX: $500"]
[]
[null,null,null,"Provincial"]
[null,null,null,"Staff Cell"]
[null,null,null,"Internet"]
[]
[null,null,null,"MAX: $2000"]
[]
["Total Project Costs",{"$f":"SUM(B20:B72)","v":122000},{"$f":"SUM(C20:C72)","v":0}]
[]
["3E.  Travel"]
["a.  Staff, consultant, volunteer travel as per expense claims, international travel where warranted",8000,{"$f":"'Budget Calculation'!C79","v":0}]
[null,null,null,"Mileage"]
[null,null,null,"Flights"]
[null,null,null,"Hotel"]
[null,null,null,"Meals & Incidentals"]
[null,null,null,"MAX: $8,000"]
[null,null,null,"NOTE:  Mileage, meals, and incidentals must not exceed the allowable amount outlined by the National Joint Council.  These rates will change from time to time and should be verified for the time period of travel before being submitted."]
[]
[null,null,null,"https://www.njc-cnm.gc.ca/s3/en"]
["Total Travel",{"$f":"+B76","v":8000},0]
[]
["Total Costs",{"$f":"+B85+B73+B17","v":130950},{"$f":"+C85+C73+C17","v":0}]

{"sheet":"Budget Calculation","index":1,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[0,4,2,7],[4,0,5,0],[4,2,5,2],[4,3,5,3],[4,4,5,14],[4,1,5,1],[10,3,12,3],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[10,0,12,0],[10,1,12,1],[10,2,12,2],[19,3,25,3],[13,0,15,0],[13,1,15,1],[13,2,15,2],[13,3,15,3],[19,0,25,0],[19,1,25,1],[19,2,25,2],[26,0,34,0],[26,1,34,1],[26,2,34,2],[26,3,34,3],[35,0,46,0],[35,1,46,1],[35,2,46,2],[47,3,54,3],[55,0,61,0],[55,1,61,1],[55,2,61,2],[35,3,46,3],[84,4,84,11],[1,1,1,3],[2,1,2,3],[0,1,0,3],[78,0,85,0],[78,1,85,1],[78,2,85,2],[78,3,85,3],[62,0,74,0],[62,1,74,1],[62,2,74,2],[62,3,74,3],[55,3,61,3],[47,0,54,0],[47,1,54,1],[47,2,54,2]]}
[null,null,null,null,"For MB the amount of tax that can be claimed is 50% for GST and 100% for PST. Please note that the formula has been adjusted accordingly in column \"I\". Tax to be claimed will be calculated and populated automatically (cost category 3C.f)."]
["Project Title:","MentorAbility 2.0"]
["Start & End Dates:","November 1, 2025 to May 31, 2026"]
[]
["Category Details","Budget Requested","Total","50% GST/HST","Detailed Budget Description & Calculation"]
[null," 01.11.2025-31.05.2026 "]
["1.A.  Administrative Costs"]
["f.  Insurance",{"$f":"H9","v":0},{"$f":"SUM(B8:B10)","v":0},{"$f":"+I9","v":0},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Liability Insurance",null,null,{"$f":"+F9*G9","v":0},{"$f":"+H9*0.095","v":0},{"$f":"+H9+I9","v":0}]
[]
["i.  Materials and office supplies",{"$f":"H12","v":0},{"$f":"SUM(B11:B13)","v":0},{"$f":"+I12","v":0},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Office Supplies",null,null,{"$f":"+F12*G12","v":0},{"$f":"+H12*0.095","v":0},{"$f":"+H12+I12","v":0}]
[]
["m.  Postage and courier fees",{"$f":"H15","v":0},{"$f":"SUM(B14:B16)","v":0},{"$f":"+I15","v":0},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Postage and/or Courier",null,null,{"$f":"+F15*G15","v":0},{"$f":"+H15*0.095","v":0},{"$f":"+H15+I15","v":0}]
[]
["Total Administrative costs",{"$f":"SUM(B8:B16)","v":0},{"$f":"SUM(C8:C16)","v":0},{"$f":"SUM(D8:D16)","v":0}]
[]
["3C.  Project Costs"]
["a.  Advertising",{"$f":"H25","v":0},{"$f":"SUM(B20:B26)","v":0},{"$f":"+I25","v":0},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Social Media",null,null,{"$f":"+F21*G21","v":0},{"$f":"+H21*0.095","v":0},{"$f":"+H21+I21","v":0}]
[null,null,null,null,"DEAM Events",null,null,{"$f":"+F22*G22","v":0},{"$f":"+H22*0.095","v":0},0]
[null,null,null,null,"Social Media Advertisements",null,null,{"$f":"+F23*G23","v":0},{"$f":"+H23*0.095","v":0},0]
[null,null,null,null,"DEAM Social Media Campaigns",null,null,{"$f":"+F24*G24","v":0},{"$f":"+H24*0.095","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUM(H21:H24)","v":0},{"$f":"SUM(I21:I24)","v":0},{"$f":"SUM(J21:J24)","v":0}]
[]
["d.  Equipment lease or purchase, software, etc",{"$f":"H34","v":0},{"$f":"SUM(B27:B35)","v":0},{"$f":"+I34","v":0},null,"$/Mo/License","# Mos/Purchase","Sub","50% GST/HST","Total"]
[null,null,null,null,"Laptops",null,null,{"$f":"+F28*G28","v":0},{"$f":"+H28*0.095","v":0},{"$f":"+H28+I28","v":0}]
[null,null,null,null,"Adobe",null,null,{"$f":"+F29*G29","v":0},0,0]
[null,null,null,null,"Zoom - Business",null,null,0,0,0]
[null,null,null,null,"MS Office Business",null,null,0,0,0]
[null,null,null,null,"MailChimp/Simply Cast",null,null,0,0,0]
[null,null,null,null,"Other (please specify)",null,null,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H28:H33)","v":0},{"$f":"SUM(I28:I33)","v":0},{"$f":"SUM(J28:J33)","v":0}]
[]
["f.  GST/HST",{"$f":"F45","v":0},{"$f":"+F45","v":0},null,"1A.f. Insurance",{"$f":"+D8","v":0}]
[null,null,null,null,"1.A.i. Materials & Supplies",{"$f":"+D11","v":0}]
[null,null,null,null,"1.A.m. Postage & Courier",{"$f":"+D14","v":0}]
[null,null,null,null,"3.C.a. Advertising",{"$f":"+D20","v":0}]
[null,null,null,null,"3.C.d. Equipment lease",{"$f":"+D27","v":0}]
[null,null,null,null,"3.C.g. Hospitality",{"$f":"+D48","v":0}]
[null,null,null,null,"3.C.j. Professional Fees",{"$f":"+D56","v":0}]
[null,null,null,null,"3.C.m. Significant project costs",{"$f":"+D63","v":0}]
[null,null,null,null,"3.E.a. Staff Travel",{"$f":"+D79","v":0}]
[null,null,null,null,null,{"$f":"SUM(F36:F44)","v":0}]
[]
[null,null,null,null,"These will auto-populate if using the form correctly."]
["g.  Hospitality",{"$f":"I53","v":0},{"$f":"SUM(B48:B55)","v":0},{"$f":"+J53","v":0},null,"$/Event","# Events/Yr","# Yrs","Sub","50% HST","Total"]
[null,null,null,null,"Service Provider and Jobseeker Engagement",null,null,null,{"$f":"+F49*G49*H49","v":0},{"$f":"+I49*0.095","v":0},{"$f":"+I49+J49","v":0}]
[null,null,null,null,"Employer Engagement ",null,null,null,{"$f":"+F50*G50*H50","v":0},{"$f":"+I50*0.095","v":0},{"$f":"+I50+J50","v":0}]
[null,null,null,null,"Employer Lunch & Learns",null,null,null,0,{"$f":"+I51*0.095","v":0},0]
[null,null,null,null,"Other (please specify)",null,null,null,0,{"$f":"+I52*0.095","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I49:I52)","v":0},{"$f":"SUM(J49:J52)","v":0},{"$f":"SUM(K49:K52)","v":0}]
[]
[]
["j.  Professional fees related to project activities",{"$f":"N60","v":0},{"$f":"SUM(B56:B62)","v":0},0,null,"Rate/Hr","# Hrs/Wk","# Wks","Sub","EI@2.28%","CPP@5.95%","RRSP @ ??%","Health @ $??/mo","Total"]
[null,null,null,null,"Project Coordinator",null,null,null,{"$f":"+F57*G57*H57","v":0},{"$f":"+I57*0.0228","v":0},{"$f":"+I57*0.0595","v":0},null,null,{"$f":"SUM(I57:M57)","v":0}]
[null,null,null,null,"Facilitator ",null,null,null,{"$f":"+F58*G58*H58","v":0},{"$f":"+I58*0.0228","v":0},{"$f":"+I58*0.0595","v":0},null,null,{"$f":"SUM(I58:M58)","v":0}]
[null,null,null,null,"Financial Coordinator",null,null,null,0,0,0,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I57:I59)","v":0},0,0,0,0,0]
[]
[null,null,null,null,"NOTE:  The RRSP and health plan rate formula will need to be adjusted based on your organizational policies and/or costs."]
["m.  Significant project costs for:  contracting, internet & other IT, postage, printing, Staff PD & telephone",{"$f":"J74","v":0},{"$f":"SUM(B63:B75)","v":0},{"$f":"+J67","v":0},null,"$/Event","# Events/Yr","# Yrs","Sub","50% GST/HST","Total"]
[null,null,null,null,"EN/FR/Other Translation",null,null,null,{"$f":"+F64*G64*H64","v":0},{"$f":"+I64*0.095","v":0},{"$f":"+I64+J64","v":0}]
[null,null,null,null,"Plain Language",null,null,null,{"$f":"+F65*G65*H65","v":0},{"$f":"+I65*0.095","v":0},{"$f":"+I65+J65","v":0}]
[null,null,null,null,"ASL/LSQ Interpreters",null,null,null,{"$f":"+F66*G66*H66","v":0},{"$f":"+I66*0.095","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I64:I66)","v":0},{"$f":"SUM(J64:J66)","v":0},{"$f":"SUM(K64:K66)","v":0}]
[]
[null,null,null,null,"Provincial","$/Mo","# Staff (if app)","Sub","# Mos","Total"]
[null,null,null,null,"Staff Cell",null,null,{"$f":"+F70*G70","v":0},null,{"$f":"+H70*I70","v":0}]
[null,null,null,null,"Internet",null,null,{"$f":"+F71*G71","v":0},null,{"$f":"+H71*I71","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H70:H71)","v":0},null,{"$f":"+J70+J71","v":0}]
[]
[null,null,null,null,null,null,null,null,"Total Project:",{"$f":"+I67+H72","v":0}]
[]
["Total Project Costs",{"$f":"SUM(B20:B75)","v":0},{"$f":"SUM(C20:C75)","v":0},{"$f":"SUM(D20:D75)","v":0}]
[]
["3E.  Travel"]
["a.  Staff, consultant, volunteer travel as per expense claims, international travel where warranted",{"$f":"J84","v":0},{"$f":"SUM(B79:B86)","v":0},{"$f":"+K84","v":0},null,"Rate/Km","# Nights/Kms","# Trips/Yr","# Yrs","Sub","50% GST/HST","Total"]
[null,null,null,null,"Mileage",null,null,null,1,{"$f":"+G80*H80*I80*F80","v":0},{"$f":"+J80*0.095","v":0},{"$f":"+J80+K80","v":0}]
[null,null,null,null,"Flights",null,null,null,1,{"$f":"+G81*H81*I81*F81","v":0},{"$f":"+J81*0.095","v":0},{"$f":"+J81+K81","v":0}]
[null,null,null,null,"Hotel",null,null,null,1,0,{"$f":"+J82*0.095","v":0},{"$f":"+J82+K82","v":0}]
[null,null,null,null,"Meals & Incidentals",null,null,null,1,0,{"$f":"+J83*0.095","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J80:J83)","v":0},{"$f":"SUM(K80:K83)","v":0},{"$f":"SUM(L80:L83)","v":0}]
[null,null,null,null,"NOTE:  Mileage, meals, and incidentals must not exceed the allowable amount outlined by the National Joint Council.  These rates will change from time to time and should be verified for the time period of travel before being submitted."]
[null,null,null,null,"https://www.njc-cnm.gc.ca/s3/en"]
["Total Travel",{"$f":"+B79","v":0},0,0]
[]
["Total Costs",{"$f":"+B87+B76+B17","v":0},{"$f":"+C87+C76+C17","v":0},{"$f":"+D87+D76+D17","v":0}]

{"sheet":"In-Kind Contribution","index":2,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[78,0,85,0],[78,1,85,1],[78,2,85,2],[78,3,85,3],[55,0,61,0],[55,1,61,1],[55,2,61,2],[55,3,61,3],[62,0,74,0],[62,1,74,1],[62,2,74,2],[62,3,74,3],[35,0,46,0],[35,1,46,1],[35,2,46,2],[35,3,46,3],[47,0,54,0],[47,1,54,1],[47,2,54,2],[47,3,54,3],[19,0,25,0],[19,1,25,1],[19,2,25,2],[19,3,25,3],[26,0,34,0],[26,1,34,1],[26,2,34,2],[26,3,34,3],[10,0,12,0],[10,1,12,1],[10,2,12,2],[10,3,12,3],[13,0,15,0],[13,1,15,1],[13,2,15,2],[13,3,15,3],[4,0,5,0],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[4,2,5,2],[4,3,5,3],[4,4,5,14],[84,4,84,11],[4,1,5,1],[0,1,0,3],[1,1,1,3],[2,1,2,3]]}
[]
["Project Title:","MentorAbility 2.0"]
["Start & End Dates:","November 1, 2025 to May 31, 2026"]
[]
["Category Details","Budget Requested","Total","50% GST/HST","Detailed Budget Description & Calculation"]
[null," 01.11.2025-31.05.2026 "]
["1.A.  Administrative Costs"]
["f.  Insurance",{"$f":"J9","v":0},{"$f":"SUM(B8:B10)","v":0},{"$f":"+I9","v":0},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Liability Insurance",null,null,{"$f":"+F9*G9","v":0},{"$f":"+H9*0.095","v":0},{"$f":"+H9+I9","v":0}]
[]
["i.  Materials and office supplies",{"$f":"J12","v":0},{"$f":"SUM(B11:B13)","v":0},{"$f":"+I12","v":0},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Office Supplies",null,null,{"$f":"+F12*G12","v":0},{"$f":"+H12*0.095","v":0},{"$f":"+H12+I12","v":0}]
[]
["m.  Postage and courier fees",{"$f":"J15","v":0},{"$f":"SUM(B14:B16)","v":0},{"$f":"+I15","v":0},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Postage and/or Courier",null,null,{"$f":"+F15*G15","v":0},{"$f":"+H15*0.095","v":0},{"$f":"+H15+I15","v":0}]
[]
["Total Administrative costs",{"$f":"SUM(B8:B16)","v":0},{"$f":"SUM(C8:C16)","v":0},{"$f":"SUM(D8:D16)","v":0}]
[]
["3C.  Project Costs"]
["a.  Advertising",{"$f":"J25","v":0},{"$f":"SUM(B20:B26)","v":0},{"$f":"+I25","v":0},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Social Media",null,null,{"$f":"+F21*G21","v":0},{"$f":"+H21*0.095","v":0},{"$f":"+H21+I21","v":0}]
[null,null,null,null,"DEAM Events",null,null,{"$f":"+F22*G22","v":0},{"$f":"+H22*0.095","v":0},0]
[null,null,null,null,"Social Media Advertisements",null,null,{"$f":"+F23*G23","v":0},{"$f":"+H23*0.095","v":0},0]
[null,null,null,null,"DEAM Social Media Campaigns",null,null,{"$f":"+F24*G24","v":0},{"$f":"+H24*0.095","v":0},0]
[null,null,null,null,null,null,null,{"$f":"SUM(H21:H24)","v":0},{"$f":"SUM(I21:I24)","v":0},{"$f":"SUM(J21:J24)","v":0}]
[]
["d.  Equipment lease or purchase, software, etc",{"$f":"J34","v":0},{"$f":"SUM(B27:B35)","v":0},{"$f":"+I34","v":0},null,"$/Mo/License","# Mos/Purchase","Sub","50% GST/HST","Total"]
[null,null,null,null,"Laptops",null,null,{"$f":"+F28*G28","v":0},{"$f":"+H28*0.095","v":0},{"$f":"+H28+I28","v":0}]
[null,null,null,null,"Adobe",null,null,{"$f":"+F29*G29","v":0},0,0]
[null,null,null,null,"Zoom - Business",null,null,0,0,0]
[null,null,null,null,"MS Office Business",null,null,0,0,0]
[null,null,null,null,"MailChimp/Simply Cast",null,null,0,0,0]
[null,null,null,null,"Other (please specify)",null,null,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H28:H33)","v":0},{"$f":"SUM(I28:I33)","v":0},{"$f":"SUM(J28:J33)","v":0}]
[]
["f.  GST/HST",{"$f":"F45","v":0},{"$f":"+F45","v":0},null,"1A.f. Insurance",{"$f":"+D8","v":0}]
[null,null,null,null,"1.A.i. Materials & Supplies",{"$f":"+D11","v":0}]
[null,null,null,null,"1.A.m. Postage & Courier",{"$f":"+D14","v":0}]
[null,null,null,null,"3.C.a. Advertising",{"$f":"+D20","v":0}]
[null,null,null,null,"3.C.d. Equipment lease",{"$f":"+D27","v":0}]
[null,null,null,null,"3.C.g. Hospitality",{"$f":"+D48","v":0}]
[null,null,null,null,"3.C.j. Professional Fees",{"$f":"+D56","v":0}]
[null,null,null,null,"3.C.m. Significant project costs",{"$f":"+D63","v":0}]
[null,null,null,null,"3.E.a. Staff Travel",{"$f":"+D79","v":0}]
[null,null,null,null,null,{"$f":"SUM(F36:F44)","v":0}]
[]
[null,null,null,null,"These will auto-populate if using the form correctly."]
["g.  Hospitality",{"$f":"K53","v":0},{"$f":"SUM(B48:B55)","v":0},{"$f":"+J53","v":0},null,"$/Event","# Events/Yr","# Yrs","Sub","50% HST","Total"]
[null,null,null,null,"Service Provider and Jobseeker Engagement",null,null,null,{"$f":"+F49*G49*H49","v":0},{"$f":"+I49*0.095","v":0},{"$f":"+I49+J49","v":0}]
[null,null,null,null,"Employer Engagement ",null,null,null,{"$f":"+F50*G50*H50","v":0},{"$f":"+I50*0.095","v":0},{"$f":"+I50+J50","v":0}]
[null,null,null,null,"Employer Lunch & Learns",null,null,null,0,{"$f":"+I51*0.095","v":0},0]
[null,null,null,null,"Other (please specify)",null,null,null,0,{"$f":"+I52*0.095","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I49:I52)","v":0},{"$f":"SUM(J49:J52)","v":0},{"$f":"SUM(K49:K52)","v":0}]
[]
[]
["j.  Professional fees related to project activities",{"$f":"N60","v":0},{"$f":"SUM(B56:B62)","v":0},0,null,"Rate/Hr","# Hrs/Wk","# Wks","Sub","EI@2.28%","CPP@5.95%","RRSP @ ??%","Health @ $??/mo","Total"]
[null,null,null,null,"Project Coordinator",null,null,null,{"$f":"+F57*G57*H57","v":0},{"$f":"+I57*0.0228","v":0},{"$f":"+I57*0.0595","v":0},null,null,{"$f":"SUM(I57:M57)","v":0}]
[null,null,null,null,"Facilitator ",null,null,null,{"$f":"+F58*G58*H58","v":0},{"$f":"+I58*0.0228","v":0},{"$f":"+I58*0.0595","v":0},null,null,{"$f":"SUM(I58:M58)","v":0}]
[null,null,null,null,"Financial Coordinator",null,null,null,0,0,0,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I57:I59)","v":0},0,0,0,0,0]
[]
[null,null,null,null,"NOTE:  The RRSP and health plan rate formula will need to be adjusted based on your organizational policies and/or costs."]
["m.  Significant project costs for:  contracting, internet & other IT, postage, printing, Staff PD & telephone",{"$f":"J74","v":0},{"$f":"SUM(B63:B75)","v":0},{"$f":"+J67","v":0},null,"$/Event","# Events/Yr","# Yrs","Sub","50% GST/HST","Total"]
[null,null,null,null,"EN/FR/Other Translation",null,null,null,{"$f":"+F64*G64*H64","v":0},{"$f":"+I64*0.095","v":0},{"$f":"+I64+J64","v":0}]
[null,null,null,null,"Plain Language",null,null,null,{"$f":"+F65*G65*H65","v":0},{"$f":"+I65*0.095","v":0},{"$f":"+I65+J65","v":0}]
[null,null,null,null,"ASL/LSQ Interpreters",null,null,null,{"$f":"+F66*G66*H66","v":0},{"$f":"+I66*0.095","v":0},0]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I64:I66)","v":0},{"$f":"SUM(J64:J66)","v":0},{"$f":"SUM(K64:K66)","v":0}]
[]
[null,null,null,null,"Provincial","$/Mo","# Staff (if app)","Sub","# Mos","Total"]
[null,null,null,null,"Staff Cell",null,null,{"$f":"+F70*G70","v":0},null,{"$f":"+H70*I70","v":0}]
[null,null,null,null,"Internet",null,null,{"$f":"+F71*G71","v":0},null,{"$f":"+H71*I71","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"+J70+J71","v":0}]
[]
[null,null,null,null,null,null,null,null,"Total Project:",{"$f":"+I67+J72","v":0}]
[]
["Total Project Costs",{"$f":"SUM(B20:B75)","v":0},{"$f":"SUM(C20:C75)","v":0},{"$f":"SUM(D20:D75)","v":0}]
[]
["3E.  Travel"]
["a.  Staff, consultant, volunteer travel as per expense claims, international travel where warranted",{"$f":"L84","v":0},{"$f":"SUM(B79:B86)","v":0},{"$f":"+K84","v":0},null,"Rate/Km","# Nights/Kms","# Trips/Yr","# Yrs","Sub","50% GST/HST","Total"]
[null,null,null,null,"Mileage",null,null,null,1,{"$f":"+G80*H80*I80*F80","v":0},{"$f":"+J80*0.095","v":0},{"$f":"+J80+K80","v":0}]
[null,null,null,null,"Flights",null,null,null,1,{"$f":"+G81*H81*I81*F81","v":0},{"$f":"+J81*0.095","v":0},{"$f":"+J81+K81","v":0}]
[null,null,null,null,"Hotel",null,null,null,1,0,{"$f":"+J82*0.095","v":0},{"$f":"+J82+K82","v":0}]
[null,null,null,null,"Meals & Incidentals",null,null,null,1,0,{"$f":"+J83*0.095","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J80:J83)","v":0},{"$f":"SUM(K80:K83)","v":0},{"$f":"SUM(L80:L83)","v":0}]
[null,null,null,null,"NOTE:  Mileage, meals, and incidentals must not exceed the allowable amount outlined by the National Joint Council.  These rates will change from time to time and should be verified for the time period of travel before being submitted."]
[null,null,null,null,"https://www.njc-cnm.gc.ca/s3/en"]
["Total Travel",{"$f":"+B79","v":0},0,0]
[]
["Total Costs",{"$f":"+B87+B76+B17","v":0},{"$f":"+C87+C76+C17","v":0},{"$f":"+D87+D76+D17","v":0}]

{"sheet":"Budget Calculation Example","index":3,"n_rows":89,"n_cols":14,"rows_kept":89,"cut":false,"hidden":false,"merged":[[84,4,84,11],[62,0,74,0],[62,1,74,1],[62,2,74,2],[62,3,74,3],[78,0,85,0],[78,1,85,1],[78,2,85,2],[78,3,85,3],[47,0,54,0],[47,1,54,1],[47,2,54,2],[47,3,54,3],[55,0,61,0],[55,1,61,1],[55,2,61,2],[55,3,61,3],[26,0,34,0],[26,1,34,1],[26,2,34,2],[26,3,34,3],[35,0,46,0],[35,1,46,1],[35,2,46,2],[35,3,46,3],[13,0,15,0],[13,1,15,1],[13,2,15,2],[13,3,15,3],[19,0,25,0],[19,1,25,1],[19,2,25,2],[19,3,25,3],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[10,0,12,0],[10,1,12,1],[10,2,12,2],[10,3,12,3],[0,1,0,3],[0,4,2,7],[1,1,1,3],[2,1,2,3],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,14]]}
[null,null,null,null,"For MB the amount of tax that can be claimed is 50% for GST and 100% for PST. Please note that the formula has been adjusted accordingly in column \"I\". Tax to be claimed will be calculated and populated automatically (cost category 3C.f)."]
["Project Title:","MentorAbility 2.0"]
["Start & End Dates:","November 1, 2025 to May 31, 2026"]
[]
["Category Details","Budget Requested","Total","50% GST/HST","Detailed Budget Description & Calculation"]
[null," 01.11.2025-31.05.2026 "]
["1.A.  Administrative Costs"]
["f.  Insurance",{"$f":"H9","v":175},{"$f":"SUM(B8:B10)","v":175},{"$f":"+I9","v":16.625},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Liability Insurance",25,7,{"$f":"+F9*G9","v":175},{"$f":"+H9*0.095","v":16.625},{"$f":"+H9+I9","v":191.625}]
[]
["i.  Materials and office supplies",{"$f":"H12","v":175},{"$f":"SUM(B11:B13)","v":175},{"$f":"+I12","v":16.625},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Office Supplies",25,7,{"$f":"+F12*G12","v":175},{"$f":"+H12*0.095","v":16.625},{"$f":"+H12+I12","v":191.625}]
[]
["m.  Postage and courier fees",{"$f":"H15","v":175},{"$f":"SUM(B14:B16)","v":175},{"$f":"+I15","v":16.625},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Postage and/or Courier",25,7,{"$f":"+F15*G15","v":175},{"$f":"+H15*0.095","v":16.625},{"$f":"+H15+I15","v":191.625}]
[]
["Total Administrative costs",{"$f":"SUM(B8:B16)","v":525},{"$f":"SUM(C8:C16)","v":525},{"$f":"SUM(D8:D16)","v":49.875}]
[]
["3C.  Project Costs"]
["a.  Advertising",{"$f":"H25","v":14000},{"$f":"SUM(B20:B26)","v":14000},{"$f":"+I25","v":1330},null,"$/Mo","# Mos","Sub","50% GST/HST","Total"]
[null,null,null,null,"Social Media",500,7,{"$f":"+F21*G21","v":3500},{"$f":"+H21*0.095","v":332.5},{"$f":"+H21+I21","v":3832.5}]
[null,null,null,null,"DEAM Events",500,7,{"$f":"+F22*G22","v":3500},{"$f":"+H22*0.095","v":332.5},3832.5]
[null,null,null,null,"Social Media Advertisements",500,7,{"$f":"+F23*G23","v":3500},{"$f":"+H23*0.095","v":332.5},3832.5]
[null,null,null,null,"DEAM Social Media Campaigns",500,7,{"$f":"+F24*G24","v":3500},{"$f":"+H24*0.095","v":332.5},3832.5]
[null,null,null,null,null,null,null,{"$f":"SUM(H21:H24)","v":14000},{"$f":"SUM(I21:I24)","v":1330},{"$f":"SUM(J21:J24)","v":15330}]
[]
["d.  Equipment lease or purchase, software, etc",{"$f":"H34","v":1500},{"$f":"SUM(B27:B35)","v":1500},{"$f":"+I34","v":142.5},null,"$/Mo/License","# Mos/Purchase","Sub","50% GST/HST","Total"]
[null,null,null,null,"Laptops",800,1,{"$f":"+F28*G28","v":800},{"$f":"+H28*0.095","v":76},{"$f":"+H28+I28","v":876}]
[null,null,null,null,"Adobe",25,7,{"$f":"+F29*G29","v":175},16.625,191.625]
[null,null,null,null,"Zoom - Business",25,7,175,16.625,191.625]
[null,null,null,null,"MS Office Business",25,7,175,16.625,191.625]
[null,null,null,null,"MailChimp/Simply Cast",25,7,175,16.625,191.625]
[null,null,null,null,"Other (please specify)",null,null,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H28:H33)","v":1500},{"$f":"SUM(I28:I33)","v":142.5},{"$f":"SUM(J28:J33)","v":1642.5}]
[]
["f.  GST/HST",{"$f":"F45","v":3013.875},{"$f":"+F45","v":3013.875},null,"1A.f. Insurance",{"$f":"+D8","v":16.625}]
[null,null,null,null,"1.A.i. Materials & Supplies",{"$f":"+D11","v":16.625}]
[null,null,null,null,"1.A.m. Postage & Courier",{"$f":"+D14","v":16.625}]
[null,null,null,null,"3.C.a. Advertising",{"$f":"+D20","v":1330}]
[null,null,null,null,"3.C.d. Equipment lease",{"$f":"+D27","v":142.5}]
[null,null,null,null,"3.C.g. Hospitality",{"$f":"+D48","v":665}]
[null,null,null,null,"3.C.j. Professional Fees",{"$f":"+D56","v":0}]
[null,null,null,null,"3.C.m. Significant project costs",{"$f":"+D63","v":142.5}]
[null,null,null,null,"3.E.a. Staff Travel",{"$f":"+D79","v":684}]
[null,null,null,null,null,{"$f":"SUM(F36:F44)","v":3013.875}]
[]
[null,null,null,null,"These will auto-populate if using the form correctly."]
["g.  Hospitality",{"$f":"I53","v":7000},{"$f":"SUM(B48:B55)","v":7000},{"$f":"+J53","v":665},null,"$/Event","# Events/Yr","# Yrs","Sub","50% HST","Total"]
[null,null,null,null,"Service Provider and Jobseeker Engagement",900,2,1,{"$f":"+F49*G49*H49","v":1800},{"$f":"+I49*0.095","v":171},{"$f":"+I49+J49","v":1971}]
[null,null,null,null,"Employer Engagement ",900,2,1,{"$f":"+F50*G50*H50","v":1800},{"$f":"+I50*0.095","v":171},{"$f":"+I50+J50","v":1971}]
[null,null,null,null,"Employer Lunch & Learns",900,2,1,1800,{"$f":"+I51*0.095","v":171},1971]
[null,null,null,null,"Other (please specify)",800,2,1,1600,{"$f":"+I52*0.095","v":152},1752]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I49:I52)","v":7000},{"$f":"SUM(J49:J52)","v":665},{"$f":"SUM(K49:K52)","v":7665}]
[]
[]
["j.  Professional fees related to project activities",{"$f":"N60","v":85718.16},{"$f":"SUM(B56:B62)","v":85718.16},0,null,"Rate/Hr","# Hrs/Wk","# Wks","Sub","EI@2.28%","CPP@5.95%","RRSP @ ??%","Health @ $??/mo","Total"]
[null,null,null,null,"Project Coordinator",34,40,30,{"$f":"+F57*G57*H57","v":40800},{"$f":"+I57*0.0228","v":930.24},{"$f":"+I57*0.0595","v":2427.6},null,null,{"$f":"SUM(I57:M57)","v":44157.84}]
[null,null,null,null,"Facilitator ",32,20,30,{"$f":"+F58*G58*H58","v":19200},{"$f":"+I58*0.0228","v":437.76},{"$f":"+I58*0.0595","v":1142.3999999999999},null,null,{"$f":"SUM(I58:M58)","v":20780.16}]
[null,null,null,null,"Financial Coordinator",32,20,30,19200,437.76,1142.3999999999999,null,null,20780.16]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I57:I59)","v":79200},1805.76,4712.3999999999996,0,0,85718.16]
[]
[null,null,null,null,"NOTE:  The RRSP and health plan rate formula will need to be adjusted based on your organizational policies and/or costs."]
["m.  Significant project costs for:  contracting, internet & other IT, postage, printing, Staff PD & telephone",{"$f":"J74","v":2340},{"$f":"SUM(B63:B75)","v":2340},{"$f":"+J67","v":142.5},null,"$/Event","# Events/Yr","# Yrs","Sub","50% GST/HST","Total"]
[null,null,null,null,"EN/FR/Other Translation",500,1,1,{"$f":"+F64*G64*H64","v":500},{"$f":"+I64*0.095","v":47.5},{"$f":"+I64+J64","v":547.5}]
[null,null,null,null,"Plain Language",500,1,1,{"$f":"+F65*G65*H65","v":500},{"$f":"+I65*0.095","v":47.5},{"$f":"+I65+J65","v":547.5}]
[null,null,null,null,"ASL/LSQ Interpreters",500,1,1,{"$f":"+F66*G66*H66","v":500},{"$f":"+I66*0.095","v":47.5},547.5]
[null,null,null,null,null,null,null,null,{"$f":"SUM(I64:I66)","v":1500},{"$f":"SUM(J64:J66)","v":142.5},{"$f":"SUM(K64:K66)","v":1642.5}]
[]
[null,null,null,null,"Provincial","$/Mo","# Staff (if app)","Sub","# Mos","Total"]
[null,null,null,null,"Staff Cell",60,1,{"$f":"+F70*G70","v":60},7,{"$f":"+H70*I70","v":420}]
[null,null,null,null,"Internet",60,1,{"$f":"+F71*G71","v":60},7,{"$f":"+H71*I71","v":420}]
[null,null,null,null,null,null,null,null,null,{"$f":"+J70+J71","v":840}]
[]
[null,null,null,null,null,null,null,null,"Total Project:",{"$f":"+I67+J72","v":2340}]
[]
["Total Project Costs",{"$f":"SUM(B20:B75)","v":113572.035},{"$f":"SUM(C20:C75)","v":113572.035},{"$f":"SUM(D20:D75)","v":2280}]
[]
["3E.  Travel"]
["a.  Staff, consultant, volunteer travel as per expense claims, international travel where warranted",{"$f":"J84","v":7200},{"$f":"SUM(B79:B86)","v":7200},{"$f":"+K84","v":684},null,"Rate/Km","# Nights/Kms","# Trips/Yr","# Yrs","Sub","50% GST/HST","Total"]
[null,null,null,null,"Mileage",20,50,1,1,{"$f":"+G80*H80*I80*F80","v":1000},{"$f":"+J80*0.095","v":95},{"$f":"+J80+K80","v":1095}]
[null,null,null,null,"Flights",1000,2,2,1,{"$f":"+G81*H81*I81*F81","v":4000},{"$f":"+J81*0.095","v":380},{"$f":"+J81+K81","v":4380}]
[null,null,null,null,"Hotel",400,2,2,1,1600,{"$f":"+J82*0.095","v":152},{"$f":"+J82+K82","v":1752}]
[null,null,null,null,"Meals & Incidentals",150,2,2,1,600,{"$f":"+J83*0.095","v":57},657]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J80:J83)","v":7200},{"$f":"SUM(K80:K83)","v":684},{"$f":"SUM(L80:L83)","v":7884}]
[null,null,null,null,"NOTE:  Mileage, meals, and incidentals must not exceed the allowable amount outlined by the National Joint Council.  These rates will change from time to time and should be verified for the time period of travel before being submitted."]
[null,null,null,null,"https://www.njc-cnm.gc.ca/s3/en"]
["Total Travel",{"$f":"+B79","v":7200},7200,684]
[]
["Total Costs",{"$f":"+B87+B76+B17","v":121297.035},{"$f":"+C87+C76+C17","v":121297.035},{"$f":"+D87+D76+D17","v":3013.875}]