Spreadsheet: 100bebf0-dd6d-4e42-b05d-0a9812595538
Sheet: Staffing Costs

NAU-CSE | NAU Cost Savings Estimate Tool
 | Course As Presently Taught |  |  |  |  |  | Course As Taught After Blended Redesign
 | YELLOW - fill in your own estimates
 | PINK-these are computed for you |  |  |  |  |  | PER STUDENT SAVINGS:
 | All estimates are PER ACADEMIC YEAR |  |  |  |  |  | TOTAL ESTIMATED COST SAVINGS PER YEAR:
Capacity
Number of Sections Per Year: |  |  |  |  |  | Number of Sections Per Year:
Approximate Number of Students Per Section: |  |  |  |  |  | Approximate Number of Students Per Section:
TOTAL STUDENTS PER YEAR: |  |  |  |  |  | TOTAL STUDENTS PER YEAR:
Staffing |  |  |  |  |  | Staffing
For each person involved in the course, fill out one line in the worksheet. |  |  |  |  |  | For each person involved in the course, fill out one line in the worksheet.
If you know the person's name, fill it in too. |  |  |  |  |  | If you know the person's name, fill it in too.
1.  Tenure Track Faculty |  |  |  |  |  | 1.  Tenure Track Faculty
 | Name | Proportion of yearly workload spent on the class |  |  |  |  | Name | Proportion of yearly workload spent on the class
 |  | (each section = .10 of yearly workload) |  |  |  |  |  | (each section = .10 of yearly workload)
TT fac 1 |  |  |  |  |  | TT fac 1
TT fac 2 |  |  |  |  |  | TT fac 2
TT fac 3 |  |  |  | Total |  | TT fac 3 |  |  |  | Total
TT fac 4 |  |  |  | workload |  | TT fac 4 |  |  |  | workload
TT fac 5 |  |  |  |  |  | TT fac 5
TT fac 6 |  |  |  |  |  | TT fac 6
TT fac 7 |  |  |  |  |  | TT fac 7
TT fac 8 |  |  |  |  |  | TT fac 8
TT fac 9 |  |  |  |  |  | TT fac 9
TT fac 10 |  |  |  |  |  | TT fac 10
2. Non TT Faculty |  |  |  |  |  | 2. Non TT Faculty
 | Name | Proportion of yearly workload spent on the class |  |  |  |  | Name | Proportion of yearly workload spent on the class
 |  | (each section = .10 of yearly workload) |  |  |  |  |  | (each section = .10 of yearly workload)
Non TT fac 1 |  |  |  |  |  | Non TT fac 1
Non TT fac 2 |  |  |  | Total |  | Non TT fac 2 |  |  |  | Total
Non TT fac 3 |  |  |  | workload |  | Non TT fac 3 |  |  |  | workload
Non TT fac 4 |  |  |  |  |  | Non TT fac 4
Non TT fac 5 |  |  |  |  |  | Non TT fac 5
Non TT fac 6 |  |  |  |  |  | Non TT fac 6
Non TT fac 7 |  |  |  |  |  | Non TT fac 7
Non TT fac 8 |  |  |  |  |  | Non TT fac 8
Non TT fac 9 |  |  |  |  |  | Non TT fac 9
Non TT fac 10 |  |  |  |  |  | Non TT fac 10
3.  [NAME] |  |  |  |  |  | 3.  [NAME]
 | Name | Number of sections taught per year |  |  |  |  | Name | Number of sections taught per year
Adj Fac 1 |  |  |  |  |  | Adj Fac 1
[NAME] |  |  |  | Total |  | [NAME] |  |  |  | Total
Adj Fac 3 |  |  |  | sections |  | Adj Fac 3 |  |  |  | sections
[NAME] |  |  |  |  |  | [NAME]
Adj Fac 5 |  |  |  |  |  | Adj Fac 5
Adj Fac 6 |  |  |  |  |  | Adj Fac 6
[NAME] |  |  |  |  |  | [NAME]
Adj Fac 8 |  |  |  |  |  | Adj Fac 8
Adj Fac 9 |  |  |  |  |  | Adj Fac 9
Adj Fac 10 |  |  |  |  |  | Adj Fac 10
4.  Graduate Teaching Assistants |  |  |  |  |  | 4.  Graduate Teaching Assistants
 | Name | Proportion of yearly workload spent on the class |  |  |  |  | Name | Proportion of yearly workload spent on the class
 |  | (each section = .10 of yearly workload) |  |  |  |  |  | (each section = .10 of yearly workload)
GA 1 |  |  |  |  |  | GA 1
GA 2 |  |  |  |  |  | GA 2
GA 3 |  |  |  | Total |  | GA 3 |  |  |  | Total
GA 4 |  |  |  | workload |  | GA 4 |  |  |  | workload
GA 5 |  |  |  |  |  | GA 5
GA 6 |  |  |  |  |  | GA 6
GA 7 |  |  |  |  |  | GA 7
GA 8 |  |  |  |  |  | GA 8
GA 9 |  |  |  |  |  | GA 9
GA 10 |  |  |  |  |  | GA 10
5.  Undergraduate Peer Teaching Assistants |  |  |  |  |  | 5.  Undergraduate Peer Teaching Assistants
 | Name | Number of sections taught per year |  |  |  |  | Name | Number of sections taught per year
PTA 1 |  |  |  |  |  | PTA 1
PTA 2 |  |  |  | Total |  | PTA 2 |  |  |  | Total
PTA 3 |  |  |  | sections |  | PTA 3 |  |  |  | sections
PTA 4 |  |  |  |  |  | PTA 4
PTA 5 |  |  |  |  |  | PTA 5
PTA 6 |  |  |  |  |  | PTA 6
PTA 7 |  |  |  |  |  | PTA 7
PTA 8 |  |  |  |  |  | PTA 8
PTA 9 |  |  |  |  |  | PTA 9
PTA 10 |  |  |  |  |  | PTA 10
6.  Course Coordinator - TT Faculty Receiving Reassigned Time for Coordination |  |  |  |  |  | 6.  Course Coordinator - TT Faculty Receiving Reassigned Time for Coordination
 | Name | Proportion of yearly workload reassigned for coordination |  |  |  |  | Name | Proportion of yearly workload reassigned for coordination
7.  Course Coordinator - Non TT Faculty Receiving Reassigned Time for Coordination |  |  |  |  |  | 7.  Course Coordinator - Non TT Faculty Receiving Reassigned Time for Coordination
 | Name | Proportion of yearly workload reassigned for coordination |  |  |  |  | Name | Proportion of yearly workload reassigned for coordination
8.  Course Coordinator - Any Staff Receiving Stipend for Course Coordination |  |  |  |  |  | 8.  Course Coordinator - Any Staff Receiving Stipend for Course Coordination
 | Name | Yearly amount of stipend for coordination |  |  |  |  | Name | Yearly amount of stipend for coordination
9.  Other Staff - e.g., laboratory managers or graders |  |  |  |  |  | 9.  Other Staff - e.g., laboratory managers or graders
 | Name | Yearly amount paid for work on this course |  |  |  |  | Name | Yearly amount paid for work on this course
Staff 1 |  |  |  |  |  | Staff 1
Staff 2 |  |  |  | Total |  | Staff 2 |  |  |  | Total
Staff 3 |  |  |  | amount |  | Staff 3 |  |  |  | amount
Staff 4 |  |  |  |  |  | Staff 4
Staff 5 |  |  |  |  |  | Staff 5
Salary |  |  |  |  |  | Salary
Average amount a TT faculty member makes in your department |  |  |  |  |  | Average amount a TT faculty member makes in your department
(annual, 9-month salary plus ERE) |  |  |  |  |  | (annual, 9-month salary plus ERE)
Amount a one-year GA makes |  |  |  |  |  | Amount a one-year GA makes
Amount a peer TA makes per section |  |  |  |  | 1300 | Amount a peer TA makes per section |  |  |  |  | 1300
Average amount an instructor or lecturer makes in your department |  |  |  |  |  | Average amount an instructor or lecturer makes in your department
(annual, 9-month salary plus ERE) |  |  |  |  |  | (annual, 9-month salary plus ERE)
Average amount an adjunct instructor makes in your department per sect |  |  |  |  |  | Average amount an adjunct instructor makes in your department per sect
 |  |  | TT Faculty Costs |  |  |  |  |  | TT Faculty Costs
 |  |  | Non TT Faculty Costs |  |  |  |  |  | Non TT Faculty Costs
 |  |  | Adjunct Costs |  |  |  |  |  | Adjunct Costs
 |  |  | GTA Costs |  |  |  |  |  | GTA Costs
 |  |  | Peer TA Costs |  |  |  |  |  | Peer TA Costs
 |  |  | Coordinator Costs |  |  |  |  |  | Coordinator Costs
 |  |  | Other Staff Costs |  |  |  |  |  | Other Staff Costs
TOTAL STAFFING COST ESTIMATE: |  |  |  |  |  | TOTAL STAFFING COST ESTIMATE:
Staffing Cost Per Student |  |  |  |  |  | Staffing Cost Per Student
Notes for the reviewers: