{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","PRBC Section A","PRBC Section B","WASC Section C"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Instructions","index":0,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["New Program Cost Analysis Instructions"]
["Complete this form to initiate review of New Certificates, New Concentrations or Minors and New Degree Programs by Undergraduate Academic Programs Office and the PRBC."]
["To ensure timely review, it is recommended that program proposals be received by PRBC no later than October 15 (for fall review) and March 15 (for spring review)."]
["Once all required signatures are obtained, submit completed form to the Undergraduate Academic Programs Office (CP-950)."]
["For assistance completing the form contact Alyssa Adamson in the Office of the Provost & Vice President for Academic Affairs.  "]
["* Sections A and B are required for PRBC review of any New Certificate or New Concentration/Minor request;  Also complete Section C for a new Degree Program."]
["Only enter or edit information in green highlighted cells to preserve the formulas built into this document to facilitate the calculation of the requested information. "]
[]
["Section A"]
["Retention is reported as % of initial cohort year."]
["Page 2 (2):  For on-line programs; enter the distance learning fee amount per unit to be requested or enter $0. "]
["Page 2 (3):  Enter student fee revenue amount based on if request is for undergraduate, credential, or graduate and other post-baccalaureate program."]
["Page 2 (5):  Enter amount of other specialized funding or external support available for program (by head or in total)"]
["Page 2:  Please provide a description of the assumptions you used for completing the information requested on page 1."]
[]
["Section B",null,null,null,null," "]
["Calculations automatically add base adjustments to following year current baseline."]
["Year 1 - 5 FTEF needed will automatically populate; enter FTEF department can cover by reallocating existing faculty resources (and how this can be accomplished); new FTEF requested as a result of FTES growth will automatically calculate based on number entered for existing FTEF."]
["Department Current Baseline Budget:   Pull from 6/30 CFS Revenue/Expenditure Summary Report for department for the fiscal year just completed; adjust for any baseline changes to department in current fiscal year.  Year 2 - 5 baseline amounts = year 1 baseline plus any additional baseline added in prior year."]
["Department faculty baseline covers full-time faculty only;  part-time faculty are funded on a one-time basis each year.  If reallocating existing FTEF enter $0 in one-time requested faculty salaries field; for this analysis additional FTEF requested appears as one-time funding."]
["Department Current One-time Budget (revised budget minus baseline budget):  One-time funds expected from operating fund (THEFD) during the current fiscal year. "]
["The noted benefits percents will be added to any additional faculty and staff salaries requested."]
["Dean and VPAA Approval signatures are required on this paperwork.  However, to expedite needed reviews and approvals, Library and IT sections can either be completed and signed by respective units OR an email from individuals authorized to respond for IT and the Library answering the questions asked may be attached to this analysis in lieu of signatures on this form. Allow minimum of 2 weeks for Library and IT review and response; submit copy of new course/program proposal to the Library and IT with the completed Cost Analysis Form for their review."]
[]
["Section C",null,null,null," "]
["This section addresses an external audience, thus the faculty and staff totals are presented in a way that differs from what appears in Section B."]
["Most fields on this page will pre-populate from Section A & B information; requested staff FTE is the only item to add on this page."]
["The faculty payroll rate is annual initial full-time faculty budget divided by divided by baselined full-time faculty FTEF and the part-time faculty rate is the rate at which the SFR Funding model allocates one-time funds; can be adjusted to actual cost for 100% self-funded programs."]
["Summer rate per unit is based on actual paid from most recent summer."]
["Only include staff in this section if additional requested."]
["Form Updated 3/24/23 pda"]
[]
[" "]
[]
[]
[]
[" "]

{"sheet":"PRBC Section A","index":1,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[51,5,51,12],[55,0,55,12],[51,0,51,3],[54,0,54,12],[20,0,20,12],[21,0,22,0],[21,3,22,3],[21,4,22,4],[21,6,22,6],[21,9,22,9],[21,10,22,10],[21,11,22,11],[21,12,22,12],[21,1,22,1],[47,0,47,3],[21,8,22,8],[21,7,22,7],[40,7,43,8],[49,0,49,3],[21,5,22,5],[50,0,50,3],[21,2,22,2],[25,0,26,0],[27,0,29,0],[30,0,33,0],[34,0,38,0],[48,0,48,3],[2,3,2,12],[3,3,3,12],[4,3,4,12],[5,3,5,12],[6,3,6,12]]}
["New Program Cost Analysis 2023-24 (Section A)",null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!A31","v":"Form Updated 3/24/23 pda"}]
["Fields to Enter"]
[null,null,"Title"]
[null,null,"College Name"]
[null,null,"Department Name"]
[null,null,"Preparer Name"]
[null,null,"Request Date"]
[]
[null,"This request is for (check one):"]
[null," ","New Concentration/Minor*",null,null,null,null,null,"Substantive Change"]
[null,null,"New Degree Program (Complete Section C )",null,null,null,null,null,"New Department"]
[null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null," ",null," "]
[null,"Type (check one):",null,null,null,null,null,null,"Program offered (check one):"]
[null,null,"Undergraduate",null,null,null,null,null,null,"Academic Year"]
[null,null,"Credential",null,null,null,null,null,null,"12-Month"]
[null,null,"Graduate and Other Post-Baccalaureate",null,null,null,null,null," ","Academic Year and 12-Month Combined"]
[]
[]
[]
["PROJECTED CAMPUS REVENUES FOR THE FIRST THREE YEARS (Section A)"]
[" ","Cohorts","% Continuing From Prior Year*","Student head count","Fall + Spring Semester Total Units Per Student","Summer Units (12-month program only)","AY FTES (annualized); show as rebenched for graduate program request (/30 for UG; /24 for GRAD)","Budgeted SFR (rebenched) for College (use values in table ** below)","FTEF Needed to Support Program","Campus Revenue Per Cohort (FTES x Marginal Cost) (1)","Distance Learning  Fee Revenue to Department (2) ","Student Fee (3), Misc. Course Fee (4) (2 semesters if AY, 3 semesters if 12-month) and Other Supplemental (5) Revenue","Subtotal"]
[]
[]
["24/25","Cohort 1"," ",null,null,null,{"$f":"D25*(E25/G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G25/H25)","v":{"$error":"#DIV/0!"}},{"$f":"G25*$E$48","v":{"$error":"#DIV/0!"}},{"$f":"(D25*E25*$E$49)+(D25*F25*E49)","v":0},{"$f":"D25*L24*($E$50+$E$51)+E52","v":0},{"$f":"SUM(J25+K25+L25)","v":{"$error":"#DIV/0!"}}]
["25/26","Cohort 1",null,{"$f":"ROUNDDOWN(SUM(D25*C26),0)","v":0},null,null,{"$f":"D26*(E26/G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G26/H26)","v":{"$error":"#DIV/0!"}},{"$f":"G26*$E$48","v":{"$error":"#DIV/0!"}},{"$f":"(D26*E26*$E$49)+(D26*F26*E49)","v":0},{"$f":"D26*L24*($E$50+$E$51)","v":0},{"$f":"SUM(J26+K26+L26)","v":{"$error":"#DIV/0!"}}]
[null,"Cohort 2"," ",null,null,null,{"$f":"D27*(E27/G24)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"G27*$E$48","v":{"$error":"#DIV/0!"}},{"$f":"(D27*E27*$E$49)+(D27*F27*E49)","v":0},{"$f":"D27*L24*($E$50+$E$51)","v":0},{"$error":"#DIV/0!"}]
["26/2","Cohort 1",null,{"$f":"ROUNDDOWN(SUM(D25*C28),0)","v":0},null,null,{"$f":"D28*(E28/G24)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"(D28*E28*$E$49)+(D28*F28*E49)","v":0},{"$f":"D28*L24*($E$50+$E$51)","v":0},{"$error":"#DIV/0!"}]
[null,"Cohort 2",null,{"$f":"ROUNDDOWN(SUM(D27*C29),0)","v":0},null,null,{"$f":"D29*(E29/G24)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"(D29*E29*$E$49)+(D29*F29*E49)","v":0},{"$f":"D29*L24*($E$50+$E$51)","v":0},{"$error":"#DIV/0!"}]
[null,"Cohort 3"," ",null,null,null,{"$f":"D30*(E30/G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G30/H30)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(D30*E30*$E$49)+(D30*F30*E49)","v":0},{"$f":"D30*L24*($E$50+$E$51)","v":0},{"$error":"#DIV/0!"}]
["27/28","Cohort 1",null,{"$f":"ROUNDUP(SUM(D25*C31),0)","v":0},null,null,{"$f":"D31*(E31/G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G31/H31)","v":{"$error":"#DIV/0!"}},{"$f":"G31*$E$48","v":{"$error":"#DIV/0!"}},{"$f":"(D31*E31*$E$49)+(D31*F31*E49)","v":0},{"$f":"D31*L24*($E$50+$E$51)","v":0},{"$f":"SUM(J31+K31+L31)","v":{"$error":"#DIV/0!"}}]
[null,"Cohort 2",null,{"$f":"ROUNDDOWN(SUM(D27*C32),0)","v":0},null,null,{"$f":"D32*(E32/G24)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"(D32*E32*$E$49)+(D32*F32*E49)","v":0},{"$f":"D32*L24*($E$50+$E$51)","v":0},{"$error":"#DIV/0!"}]
[null,"Cohort 3",null,{"$f":"ROUNDDOWN(SUM(D30*C33),0)","v":0},null,null,{"$f":"D33*(E33/G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G33/H33)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(D33*E33*$E$49)+(D33*F33*E49)","v":0},{"$f":"D33*L24*($E$50+$E$51)","v":0},{"$error":"#DIV/0!"}]
[null,"Cohort 4"," ",null,null,null,{"$f":"D34*(E34/G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G34/H34)","v":{"$error":"#DIV/0!"}},{"$f":"G34*$E$48","v":{"$error":"#DIV/0!"}},{"$f":"(D34*E34*$E$49)+(D34*F34*E49)","v":0},{"$f":"D34*L24*($E$50+$E$51)","v":0},{"$f":"SUM(J34+K34+L34)","v":{"$error":"#DIV/0!"}}]
["28/29","Cohort 1",null,{"$f":"ROUNDDOWN(SUM(D25*C35),0)","v":0},null,null,{"$f":"D35*(E35/G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G35/H35)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(D35*E35*$E$49)+(D35*F35*E49)","v":0},{"$f":"D35*L24*($E$50+$E$51)","v":0},{"$error":"#DIV/0!"}]
[null,"Cohort 2",null,{"$f":"ROUNDDOWN(SUM(D27*C36),0)","v":0},null,null,{"$f":"D36*(E36/G24)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"(D36*E36*$E$49)+(D36*F36*E49)","v":0},{"$f":"D36*L24*($E$50+$E$51)","v":0},{"$error":"#DIV/0!"}]
[null,"Cohort 3",null,{"$f":"ROUNDDOWN(SUM(D30*C37),0)","v":0},null,null,{"$f":"D37*(E37/G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G37/H37)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"(D37*E37*$E$49)+(D37*F37*E49)","v":0},{"$f":"D37*L24*($E$50+$E$51)","v":0},{"$error":"#DIV/0!"}]
[null,"Cohort 4",null,{"$f":"ROUNDDOWN(SUM(D34*C38),0)","v":0},null,null,{"$f":"D38*(E38/G24)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"G38*$E$48","v":{"$error":"#DIV/0!"}},{"$f":"(D38*E38*$E$49)+(D38*F38*E49)","v":0},{"$f":"D38*L24*($E$50+$E$51)","v":0},{"$f":"SUM(J38+K38+L38)","v":{"$error":"#DIV/0!"}}]
[null,"Cohort 5"," ",null,null,null,{"$f":"D39*(E39/G24)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(G39/H39)","v":{"$error":"#DIV/0!"}},{"$f":"G39*$E$48","v":{"$error":"#DIV/0!"}},{"$f":"(D39*E39*$E$49)+(D39*F39*E49)","v":0},{"$f":"D39*L24*($E$50+$E$51)","v":0},{"$f":"SUM(J39+K39+L39)","v":{"$error":"#DIV/0!"}}]
["Total",null,null,{"$f":"SUM(D25:D39)","v":0},{"$f":"SUM(E25:E39)","v":0},{"$f":"SUM(F25:F39)","v":0},{"$f":"SUM(G25:G39)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(J25:J39)","v":{"$error":"#DIV/0!"}},0,0,{"$f":"SUM(M25:M39)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Total Units Cohort 1",{"$f":"SUM(E25+E26+E28+E31+E35+F25+F26+F28+F31+F35)","v":0},null,null,"22-23 Baseline Budgeted SFR (Rebenched) By College **",null,"ARTS",18.100000000000001,"HHD",20.6]
[null,null,null,"Total Units Cohort 2",{"$f":"SUM(E27+E29+E32+E36+F27+F29+F32+F36)","v":0},null,null,null,null,"CCOM",23.1,"HSS",25.1]
[null,null,null,"Total Units Cohort 3",{"$f":"SUM(E30+E33+E37+F30+F33+F37)","v":0},null,null,null,null,"ECS",17.399999999999999,"MCBE",22.7]
[null,null,null,"Total Units Cohort 4",{"$f":"SUM(E34+E38+F34+F38)","v":0},null,null,null,null,"EDUC",18,"NSM",20.7]
[null,null,null,"Total Units Cohort 5",{"$f":"SUM(E39+F39)","v":0},null,null,null,null,null,null,null,"NOTE:  for 100% self-funded programs only may use Dept SFR"]
[null,null,null,null,{"$f":"SUM(E41:E45)","v":0},null,null,null,null," ",null," "]
[" ",null,null,null,null,null,null,"- 1 -"]
["(1) State Support per FTES (use campus actual for current fiscal year at $5,938 - unless new program separately budgeted at higher rate)",null,null,null,5938," "," ",null,null,null,null," "]
["(2) Distance Learning Fee per unit @ $33",null,null,null,0,null,null,null," "]
["(3) 2022/23 Student Fee Revenue (6.1 units or more ) per semester after 1/3 SUG adjustment: $1,914 Undergraduate, $2,220 Credential, $2,392 Graduate and Other Post-Baccalaureate Programs***",null,null,null,null,null,null," "]
["(4) Miscellaneous Course Fees per head per semester @",null,null,null,29.11]
["(5) Other Specialized Funding or Supplemental Revenue (lump sum reported in cohort 1, year 1)",null,null,null,null,"Specify Source of Other Funds:   "]
[null,"*** Does not factor in higher fees paid by International Students"]
[]
["Explain the following assumptions: 1) the estimated number of new students each year, 2) annual retention rates, 3) total number of units necessary to complete the degree, and 4) number of units taken during each academic year. Consult Assessment and Institutional Effectiveness to estimate annual retention rates for the proposed program:\n"]
[]
[" ",null,null,null,null,null,null,"- 2 -"]
[]
[]
[]
[]
[null,null,null," "]

{"sheet":"PRBC Section B","index":2,"n_rows":98,"n_cols":12,"rows_kept":98,"cut":false,"hidden":false,"merged":[[97,0,97,7],[86,2,86,7],[80,2,80,7],[34,2,34,3],[70,2,70,3],[22,2,22,3],[74,0,74,7],[58,2,58,3],[46,2,46,3],[1,1,1,7],[10,2,10,3],[3,3,3,4],[4,5,4,7],[5,5,9,7]]}
["Projected Operational Budget PRBC Review (Section B)",null,null,null,null,null,{"$f":"+'PRBC Section A'!L1","v":"Form Updated 3/24/23 pda"}]
["Title:  ",{"$f":"'PRBC Section A'!D3","v":0}]
["Fields to Enter"]
["Projected FTEF Needed",null,null,"(specify FTEF new vs reallocated)"]
[null,null,"FTEF Needed to Support Program","Additional FTEF Requested","Reallocation of Existing FTEF","If a reallocation, please specify how this will be accomplished"]
[{"$f":"'PRBC Section A'!A25","v":"24/25"},null,{"$f":"SUM('PRBC Section A'!I25)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C6-E6)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'PRBC Section A'!A26","v":"25/26"},null,{"$f":"SUM('PRBC Section A'!I26:I27)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C7-E7)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null," "]
[{"$f":"'PRBC Section A'!A28","v":"26/2"},null,{"$f":"SUM('PRBC Section A'!I28:I30)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C8-E8)","v":{"$error":"#DIV/0!"}},null,null,null,null,null," "," "]
[{"$f":"'PRBC Section A'!A31","v":"27/28"},null,{"$f":"SUM('PRBC Section A'!I31:I34)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C9-E9)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null," "]
[{"$f":"'PRBC Section A'!A35","v":"28/29"},null,{"$f":"SUM('PRBC Section A'!I35:I39)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C10-E10)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null," "]
["Other Operating expenses",null,"Description",null,"Department Current Baseline Budget (exclude benefits)","Department Current One-time Budget ***** (exclude benefits)","Additional Baseline Requested (include benefits***; requesting addition to Base Budget in next year)","One-time Requested (include benefits***)"]
[{"$f":"'PRBC Section A'!A25","v":"24/25"},null,"Baseline","One-time"]
["Additional Faculty Salaries *","FTEF",0,0,0,0,{"$f":"$C13*64860*1.51","v":0},{"$f":"$D13*64860*1.51","v":0}]
["Summer Instruction (12-month program only)******","Units",0,0,0,0,{"$f":"SUM(64860/30)*$C14*1.0145","v":0},{"$f":"SUM(64860/30)*$D14*1.0145","v":0}]
["Additional Staff Salaries ***","Amount",0,0,0,0,{"$f":"$C15*1.55","v":0},{"$f":"$D15*1.55","v":0}]
["Curriculum Development **","Units",0,0,0,0,{"$f":"64860/$C16*1.51","v":{"$error":"#DIV/0!"}},{"$f":"64860/$C16*1.51","v":{"$error":"#DIV/0!"}}]
["Graduate Assistants ***, ****","FTEF",0,0,0,0,{"$f":"$C17*(1213.5*2)*1.0765","v":0},{"$f":"$D17*(1213.5*2)*1.0765","v":0}]
["Materials & Supplies (OE & E)",null,0,0,0,0,{"$f":"$C18","v":0},{"$f":"$D18","v":0}]
["Student Assistants",null,0,0,0,0,{"$f":"$C19","v":0},{"$f":"$D19","v":0}]
["Equipment",null,0,0,0,0,{"$f":"C20","v":0},{"$f":"D20","v":0}]
["Marketing",null,null,null,0,0,0,0]
["Facilities Improvement / Renovation Costs",null,0,0,0,0,{"$f":"C22","v":0},{"$f":"D22","v":0},null,null,null," "]
[" ",null,"Total",null,{"$f":"SUM(E13:E22)","v":0},0,{"$error":"#DIV/0!"},{"$f":"SUM(H13:H22)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'PRBC Section A'!A26","v":"25/26"},null,"Baseline","One-time"]
["Additional Faculty Salaries *","FTEF",0,0,0,0,{"$f":"$C25*64860*1.53","v":0},{"$f":"$D25*64860*1.53","v":0}]
["Summer Instruction (12-month program only)******","Units",0,0,0,0,{"$f":"SUM(64860/30)*$C26*1.0145","v":0},{"$f":"SUM(64860/30)*$D26*1.0145","v":0}]
["Additional Staff Salaries ***","Amount",0,0,0,0,{"$f":"$C27*1.57","v":0},{"$f":"$D27*1.57","v":0}]
["Curriculum Development *, ***","Units",0,0,0,0,{"$f":"64860/$C28*1.53","v":{"$error":"#DIV/0!"}},{"$f":"64860/$C28*1.53","v":{"$error":"#DIV/0!"}}]
["Graduate Assistants ***, ****","FTEF",0,0,0,0,{"$f":"$C29*(1213.5*2)*1.0765","v":0},{"$f":"$D29*(1213.5*2)*1.0765","v":0}]
["Materials & Supplies (OE & E)",null,0,0,0,0,{"$f":"$C30","v":0},{"$f":"$D30","v":0}]
["Student Assistants",null,0,0,0,0,{"$f":"$C31","v":0},{"$f":"$D31","v":0}]
["Equipment",null,0,0,0,0,{"$f":"C32","v":0},{"$f":"D32","v":0}]
["Marketing",null,null,null,0,0,0,0]
["Facilities Improvement / Renovation Costs",null,0,0,0,0,{"$f":"C34","v":0},{"$f":"D34","v":0}]
[null,null,"Total",null,{"$f":"SUM(E25:E34)","v":0},0,{"$error":"#DIV/0!"},{"$f":"SUM(H25:H34)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'PRBC Section A'!A28","v":"26/2"},null,"Baseline","One-time"]
["Additional Faculty Salaries *","FTEF",0,0,0,0,{"$f":"$C37*64860*1.55","v":0},{"$f":"$D37*64860*1.55","v":0}]
["Summer Instruction (12-month program only)******","Units",0,0,0,0,{"$f":"SUM(64860/30)*$C38*1.0145","v":0},{"$f":"SUM(64860/30)*$D38*1.0145","v":0}]
["Additional Staff Salaries ***","Amount",0,0,0,0,{"$f":"$C39*1.59","v":0},{"$f":"$D39*1.59","v":0}]
["Curriculum Development **","Units",0,0,0,0,{"$f":"64860/$C40*1.55","v":{"$error":"#DIV/0!"}},{"$f":"64860/$C40*1.55","v":{"$error":"#DIV/0!"}}]
["Graduate Assistants ***, ****","FTEF",0,0,0,0,{"$f":"$C41*(1213.5*2)*1.0765","v":0},{"$f":"$D41*(1213.5*2)*1.0765","v":0}]
["Materials & Supplies (OE & E)",null,0,0,0,0,{"$f":"$C42","v":0},{"$f":"$D42","v":0}]
["Student Assistants",null,0,0,0,0,{"$f":"$C43","v":0},{"$f":"$D43","v":0}]
["Equipment",null,0,0,0,0,{"$f":"C44","v":0},{"$f":"D44","v":0}]
["Marketing",null,null,null,0,0,0,0]
["Facilities Improvement / Renovation Costs",null,0,0,0,0,{"$f":"C46","v":0},{"$f":"D46","v":0}]
[null,null,"Total",null,{"$f":"SUM(E37:E46)","v":0},0,{"$error":"#DIV/0!"},{"$f":"SUM(H37:H46)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'PRBC Section A'!A31","v":"27/28"},null,"Baseline","One-time"]
["Additional Faculty Salaries *","FTEF",0,0,0,0,{"$f":"$C49*64860*1.57","v":0},{"$f":"$D49*64860*1.57","v":0}]
["Summer Instruction (12-month program only)******","Units",0,0,0,0,{"$f":"SUM(64860/30)*$C50*1.0145","v":0},{"$f":"SUM(64860/30)*$D50*1.0145","v":0}]
["Additional Staff Salaries ***","Amount",0,0,0,0,{"$f":"$C51*1.61","v":0},{"$f":"$D51*1.61","v":0}]
["Curriculum Development **","Units",0,0,0,0,{"$f":"64860/$C52*1.57","v":{"$error":"#DIV/0!"}},{"$f":"64860/$C52*1.57","v":{"$error":"#DIV/0!"}}]
["Graduate Assistants ***, ****","FTEF",0,0,0,0,{"$f":"$C53*(1213.5*2)*1.0765","v":0},{"$f":"$D53*(1213.5*2)*1.0765","v":0}]
["Materials & Supplies (OE & E)",null,0,0,0,0,{"$f":"$C54","v":0},{"$f":"$D54","v":0}]
["Student Assistants",null,0,0,0,0,{"$f":"$C55","v":0},{"$f":"$D55","v":0}]
["Equipment",null,0,0,0,0,{"$f":"C56","v":0},{"$f":"D56","v":0}]
["Marketing",null,null,null,0,0,0,0]
["Facilities Improvement / Renovation Costs",null,0,0,0,0,{"$f":"C58","v":0},{"$f":"D58","v":0}]
[null,null,"Total",null,{"$f":"SUM(E49:E58)","v":0},0,{"$error":"#DIV/0!"},{"$f":"SUM(H49:H58)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'PRBC Section A'!A35","v":"28/29"},null,"Baseline","One-time"]
["Additional Faculty Salaries *","FTEF",0,0,0,0,{"$f":"$C61*64860*1.59","v":0},{"$f":"$D61*64860*1.59","v":0}]
["Summer Instruction (12-month program only)******","Units",0,0,0,0,{"$f":"SUM(64860/30)*$C62*1.0145","v":0},{"$f":"SUM(64860/30)*$D62*1.0145","v":0}]
["Additional Staff Salaries ***","Amount",0,0,0,0,{"$f":"$C63*1.63","v":0},{"$f":"$D63*1.63","v":0}]
["Curriculum Development **","Units",0,0,0,0,{"$f":"64860/$C64*1.59","v":{"$error":"#DIV/0!"}},{"$f":"64860/$C64*1.59","v":{"$error":"#DIV/0!"}}]
["Graduate Assistants ***, ****","FTEF",0,0,0,0,{"$f":"$C65*(1213.5*2)*1.0765","v":0},{"$f":"$D65*(1213.5*2)*1.0765","v":0}]
["Materials & Supplies (OE & E)",null,0,0,0,0,{"$f":"$C66","v":0},{"$f":"$D66","v":0}]
["Student Assistants",null,0,0,0,0,{"$f":"$C67","v":0},{"$f":"$D67","v":0}]
["Equipment",null,0,0,0,0,{"$f":"C68","v":0},{"$f":"D68","v":0}]
["Marketing",null,null,null,0,0,0,0]
["Facilities Improvement / Renovation Costs",null,0,0,0,0,{"$f":"C70","v":0},{"$f":"D70","v":0}]
[null,null,"Total",null,{"$f":"SUM(E61:E70)","v":0},0,{"$error":"#DIV/0!"},{"$f":"SUM(H61:H70)","v":{"$error":"#DIV/0!"}}]
[" ",null,null,null,null,"Funding Requested:",{"$f":"SUM(G23+G35+G47+G59+G71)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H23+H35+H47+H59+H71)","v":{"$error":"#DIV/0!"}}]
["* In year after initial request, salary only portion to be added to department Current Baseline Budget; benefits are applied to"]
["   University Benefits Pool."]
["NOTE: Approval of programs requesting additional resources does not constitute approval of additional resources at the University Level."]
["Chair"]
[" ",null,"Chair Name"," ","Signature",null,null,"Date"]
[]
[]
["Dean",null,null," "]
["If funding beyond current department resources is requested, please specify amount to be funded and source of these funds:",null,"The additional faculty costs noted will be addressed through the annual enrollment funding allocation to the college; no additional funds requested."]
[]
[" "]
[" ",null,"Dean Name"," ","Signature",null,null,"Date"]
[null,null,null,null,null," "]
["Provost/VPAA",null,null," "]
["If funding support beyond current department/college resources is requested, please specify amount to be funded and source of these funds:"]
[]
[" ",null,"Dr. Amir Dabirian"]
[" ",null,"Provost/VPAA Name",null,"Signature",null,null,"Date"]
[]
["Note:  New DNP faculty is funded at full professor rate of $98,000 plus 50% benefit."]
["* Use new faculty funding rate of $64,860 (30 units) for additional FTEF requested plus benefits"]
["** Use lecturer replacement rate of $64,860 (30 units) for additional FTEF requested plus benefits"]
["*** Benefits rates for years 1, 2, 3, 4 and 5 are 51%, 53%, 55%, 57%, 59%for faculty and 55%, 57%, 59%, 61%, 63% for staff "]
["**** Baseline amounts include FT faculty and Chair's budgets; Part-time faculty, TA's and most GA's are one-time funded by PTF funds"]
["***** Use current graduate assistant rate of $1,214 per month plus 7.65% for benefits",null,null,null,null,null,null," "]
["****** For 100% self-funded 12-month programs only, include summer faculty salaries funded from summer fee revenue ($64,860 plus 1.45% medicare benefit)"]

{"sheet":"WASC Section C","index":3,"n_rows":67,"n_cols":6,"rows_kept":67,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,1,1,5]]}
["Projected Program Revenue & Expense External Review (Section C)"]
["Title:",{"$f":"'PRBC Section A'!D3","v":0}]
[{"$f":"'PRBC Section B'!A12","v":"24/25"}]
["Revenue",null,null,null,null,{"$f":"SUM('PRBC Section A'!M25)","v":{"$error":"#DIV/0!"}}]
["Operating expenses"]
[null,"Payroll: AY Faculty (1)","FTEF",{"$f":"SUM('PRBC Section B'!C6)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((64860*D6)*1.51,0)","v":{"$error":"#DIV/0!"}}]
[null,"Payroll: Summer Faculty (2)","# Units",{"$f":"SUM('PRBC Section B'!C14)","v":0},{"$f":"SUM(64860/30*D7)*1.0145","v":0}]
[null,"Payroll: Staff (3)","FTE",0,{"$f":"SUM(D8*40998)*1.55","v":0}]
[null,"Curriculum Development (4)","# Units",{"$f":"SUM('PRBC Section B'!C16)","v":0},{"$f":"SUM(D9*64860/30)*1.51","v":0}," "]
[null,"Student/Graduate Assistants",null,null,{"$f":"SUM('PRBC Section B'!H17+'PRBC Section B'!H19)","v":0}]
[null,"Supplies",null,null,{"$f":"SUM('PRBC Section B'!G18:H18)","v":0}," "]
[null,"Equipment (5)",null,null,{"$f":"SUM('PRBC Section B'!G20:H20)","v":0}]
[null,"Marketing",null,null,{"$f":"SUM('PRBC Section B'!G21:H21)","v":0}," "]
[null,"Other Campus Expenses (6)",null,null,{"$f":"((89548932.82+5543360.32-6324409-200000)/37469.17)*('PRBC Section A'!G25+'PRBC Section A'!I25)","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,"Total",{"$f":"SUM(E6:E14)","v":{"$error":"#DIV/0!"}}]
["Net Income",null,null,null,null,{"$f":"F4-E15","v":{"$error":"#DIV/0!"}}]
[{"$f":"'PRBC Section B'!A24","v":"25/26"}]
["Revenue",null,null,null,null,{"$f":"SUM('PRBC Section A'!M26+'PRBC Section A'!M27)","v":{"$error":"#DIV/0!"}}]
["Operating expenses"]
[null,"Payroll: AY Faculty ","FTEF",{"$f":"SUM('PRBC Section B'!C7)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((64860*D20)*1.53,0)","v":{"$error":"#DIV/0!"}}]
[null,"Payroll: Summer Faculty","# Units",{"$f":"SUM('PRBC Section B'!C26)","v":0},{"$f":"SUM(64860/30*D21)*1.0145","v":0}]
[null,"Payroll: Staff ","FTE",0,{"$f":"SUM(D22*40998)*1.57","v":0}]
[null,"Curriculum Development","# Units",{"$f":"SUM('PRBC Section B'!C28)","v":0},{"$f":"SUM(D23*64860/30)*1.53","v":0}]
[null,"Student/Graduate Assistants",null,null,{"$f":"SUM('PRBC Section B'!H29+'PRBC Section B'!H31)","v":0}," "]
[null,"Supplies",null,null,{"$f":"SUM('PRBC Section B'!G18+'PRBC Section B'!G30+'PRBC Section B'!H30)","v":0}]
[null,"Equipment",null,null,{"$f":"SUM('PRBC Section B'!G20+'PRBC Section B'!G32+'PRBC Section B'!H32)","v":0}," "]
[null,"Marketing",null,null,{"$f":"SUM('PRBC Section B'!G21+'PRBC Section B'!G33+'PRBC Section B'!H33)","v":0}," "]
[null,"Other Campus Expenses ",null,null,{"$f":"((89548932.82+5543360.32-6324409-200000)/37469.17)*('PRBC Section A'!G26+'PRBC Section A'!G27+'PRBC Section A'!I26+'PRBC Section A'!I27)","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,"Total",{"$f":"SUM(E20:E28)","v":{"$error":"#DIV/0!"}}]
["Net Income",null,null,null,null,{"$f":"F18-E29","v":{"$error":"#DIV/0!"}}]
[{"$f":"'PRBC Section B'!A36","v":"26/2"}]
["Revenue",null,null,null,null,{"$f":"SUM('PRBC Section A'!M28:M30)","v":{"$error":"#DIV/0!"}}]
["Operating expenses"]
[null,"Payroll: AY Faculty ","FTEF",{"$f":"SUM('PRBC Section B'!C8)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((64860*D34)*1.55,0)","v":{"$error":"#DIV/0!"}}]
[null,"Payroll: Summer Faculty","# Units",{"$f":"SUM('PRBC Section B'!C38)","v":0},{"$f":"SUM(64860/30*D35)*1.0145","v":0}]
[null,"Payroll: Staff ","FTE",0,{"$f":"SUM(D36*40998)*1.59","v":0}]
[null,"Curriculum Development","# Units",{"$f":"SUM('PRBC Section B'!C40)","v":0},{"$f":"SUM(D37*64860/30)*1.55","v":0}]
[null,"Student/Graduate Assistants",null,null,{"$f":"SUM('PRBC Section B'!H41+'PRBC Section B'!H43)","v":0}]
[null,"Supplies",null,null,{"$f":"SUM('PRBC Section B'!G18+'PRBC Section B'!G30+'PRBC Section B'!G42+'PRBC Section B'!H42)","v":0}]
[null,"Equipment",null,null,{"$f":"SUM('PRBC Section B'!G20+'PRBC Section B'!G32+'PRBC Section B'!G44+'PRBC Section B'!H44)","v":0}]
[null,"Marketing",null,null,{"$f":"SUM('PRBC Section B'!G21+'PRBC Section B'!G33+'PRBC Section B'!G45+'PRBC Section B'!H45)","v":0}]
[null,"Other Campus Expenses ",null,null,{"$f":"((89548932.82+5543360.32-6324409-200000)/37469.17)*('PRBC Section A'!G28+'PRBC Section A'!G29+'PRBC Section A'!G30+'PRBC Section A'!I28+'PRBC Section A'!I29+'PRBC Section A'!I30)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Total",{"$f":"SUM(E34:E42)","v":{"$error":"#DIV/0!"}}]
["Net Income"," ",null,null,null,{"$f":"F32-E43","v":{"$error":"#DIV/0!"}}]
[{"$f":"'PRBC Section B'!A48","v":"27/28"}]
["Revenue",null,null,null,null,{"$f":"SUM('PRBC Section A'!M31:M34)","v":{"$error":"#DIV/0!"}}]
["Operating expenses"]
[null,"Payroll: AY Faculty ","FTEF",{"$f":"SUM('PRBC Section B'!C9)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((64860*D48)*1.57,0)","v":{"$error":"#DIV/0!"}}]
[null,"Payroll: Summer Faculty","# Units",{"$f":"SUM('PRBC Section B'!C50)","v":0},{"$f":"SUM(64860/30*D49)*1.0145","v":0}]
[null,"Payroll: Staff ","FTE",0,{"$f":"SUM(D50*40998)*1.61","v":0}]
[null,"Curriculum Development","# Units",{"$f":"SUM('PRBC Section B'!C52)","v":0},{"$f":"SUM(D51*64860/30)*1.57","v":0}]
[null,"Student/Graduate Assistants",null,null,{"$f":"SUM('PRBC Section B'!H53+'PRBC Section B'!H55)","v":0}]
[" ","Supplies",null,null,{"$f":"SUM('PRBC Section B'!G18+'PRBC Section B'!G30+'PRBC Section B'!G42+'PRBC Section B'!G54+'PRBC Section B'!H54)","v":0}]
[null,"Equipment",null,null,{"$f":"SUM('PRBC Section B'!G20+'PRBC Section B'!G32+'PRBC Section B'!G44+'PRBC Section B'!G56+'PRBC Section B'!G68+'PRBC Section B'!H68)","v":0}]
[null,"Marketing",null,null,{"$f":"SUM('PRBC Section B'!H57)","v":0}]
[null,"Other Campus Expenses ",null,null,{"$f":"((89548932.82+5543360.32-6324409-200000)/37469.17)*('PRBC Section A'!G31+'PRBC Section A'!G32+'PRBC Section A'!G33+'PRBC Section A'!G34+'PRBC Section A'!I31+'PRBC Section A'!I32+'PRBC Section A'!I33+'PRBC Section A'!I34)","v":{"$error":"#DIV/0!"}}," "]
[null,null,null,"Total",{"$f":"SUM(E48:E56)","v":{"$error":"#DIV/0!"}}]
["Net Income",null,null,null,null,{"$f":"F46-E57","v":{"$error":"#DIV/0!"}}]
["Footnotes:",null,null,null,"4-Year Total",{"$f":"SUM(F16+F30+F44+F58)","v":{"$error":"#DIV/0!"}}]
["(1) AY faculty payroll @ $64,860 plus benefits adjusted for time base"]
["(2) Summer faculty payroll @ $6,162 per unit taught plus 1.045% benefits added"]
["(3) Staff payroll @ $40,998 plus benefits adjusted for time base",null,null,null,null," "]
["(4) Curriculum development: conversion to on-line delivery $2,162 per unit plus benefits ",null,null,null,null," "]
["(1, 3 and 4) Benefits rates for years 1, 2, 3 and 4 are 51%, 53%, 55%, 57% for faculty and 55%, 57%, 59%, 61% for staff "]
["(5) Equipment costs include: secondary storage, webcams, microphones, headphones, misc. other"]
["(6) Other campus expenses include: facilities and facility maintenance, IT, Library, administration and academic/student services"]
[{"$f":"+'PRBC Section B'!G1","v":"Form Updated 3/24/23 pda"},null,"- 7 -"]