{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Submission Guide","Fee Proposal Template","Comparator Benchmarking","Reference Guide"],"read":"whole","date_system":"1900"}

{"sheet":"Submission Guide","index":0,"n_rows":4,"n_cols":1,"rows_kept":4}
["Submission Guide"]
["As approved by UBC’s Board of Governors at their June 2023 meeting, the Office of the Provost and Vice-President Academic has delegated authority to approve fees for non-credit programming, specifically non-credit certificate programs and non-credit micro-certificate programs. Non-credit letters (including Letters of Participation, Letters of Completion, and Letters of Proficiency) do not require fee approval by the Office of the Provost and Vice-President Academic.  \n\nFaculties and Extended Learning seeking to create either a new non-credit certificate or a micro-certificate program must receive fee approval from the Office of the Provost and Vice-President Academic prior to launching their program. Faculties and Extended Learning must submit the following information: \n'- Copy of Senate proposal \n- Completed fee proposal template \n- Signed fee approval form \n\n Submissions and any questions can be sent to Alison Stuart-Crump, Senior Projects Manager, Office of the Provost and Vice-President Academic at alison.stuart-crump@ubc.ca.  \n\n "]
[]
["Last updated October 2025"]

{"sheet":"Fee Proposal Template","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[3,0,3,4],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,3],[9,0,9,1],[10,0,10,1],[11,0,11,1],[13,0,13,4],[20,0,20,4],[24,1,24,4]]}
[]
["Fee Proposal Template"]
[]
["Revenue and Enrolment Projections"]
[null,null,"Year 1","Year 2","Comments"]
["Fee Revenue",null,0,0,"Indicate proposed fees and whether fees are set per course or program"]
["Additional Learner Fees",null,0,0,"Indicate proposed additional fee(s) per learner and provide a short description of requested fee"]
["TOTAL ",null,{"$f":"C6+C7","v":0},{"$f":"D6+D7","v":0}]
[]
["Other Revenue Sources",null,0,0,"If applicable, indicate whether the funding is from an external source (e.g., industry partner, Ministry) or internal source (e.g., UBC funding call), if the funding is one-time or ongoing, and whether it is to cover development or delivery costs."]
["Number of Offerings per Year"]
["Target Enrolment per Offering"]
[]
["Development & Delivery Costs"]
["*See Reference Guide for example costs"]
[null,"Development","Year 1","Year 2"," Comments"]
["(insert)",0,0,0]
["(insert)",0,0,0]
["(insert)",0,0,0]
["TOTAL",{"$f":"SUM(B17:B19)","v":0},{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0}]
[]
["Fiscal Surplus (Deficit)",{"$f":"B20","v":0},{"$f":"C8-C20","v":0},{"$f":"D8-D20","v":0}]
["Cumulative Surplus (Deficit)",{"$f":"B20","v":0},{"$f":"B23+C22","v":0},{"$f":"C23+D22","v":0}]
[]
["Additional Information (optional): Explanation for special circumstances or other information required to explain assumptions. Where applicable, please indicate any identified risks and possible mitigation strategies.  "]

{"sheet":"Comparator Benchmarking","index":2,"n_rows":5,"n_cols":3,"rows_kept":5}
["Comparator Benchmarking"]
[]
["Please indicate other comparable programs and their associated fee(s)."]
[]
["Institution/Organization ","Program ","Fees "]

{"sheet":"Reference Guide","index":3,"n_rows":2,"n_cols":1,"rows_kept":2}
["Reference Guide "]
["In developing your financial model for your new program, you may wish to consider the following development and delivery expenses: \n\nTypical Development Expenses:\n'- Course Development and Production \n- Subject Matter Expert and faculty costs \n- Market research, analysis, and program design \n- Media (audio/video) development \n- Project management \n- Marketing \n\nTypical Delivery Expenses: \n- Course renewal \n- Administration (staff) \n- Instructor and guest lecturer costs \n- Marketing and recruitment \n- Learning Management System  \n- Student registration \n- Credit card fees \n- IT support  \n\nFiscal surplus (deficit) represents your projected revenue minus annual expenses \n\nCumulative surplus (deficit) represents last year’s cumulative surplus/deficit plus this year's projected revenue minus this year's expenses  "]