Ncii Guided Pathways Roi Model Final February 2018

Partial file snippet.

Sheet 1: ROI Model - Semester Schools

	
	
	
	
	
	
	
	
	
	
		NCII's Guided Pathways Return-on-Investment Model  
		

		

		

	
	
		

		For Colleges on the Semester System 
		

		

		

	
	
		Note 1: This model is designed as an order of magnitude demonstration, rather than a detailed cost model. 
		

		

		

		

		

		

		

		

		

	
	
		             It can be helpful, however, in visualizing the costs and returns of guided pathways reforms, and also to do "what-if" modeling of
		

		

		

		

		

		

		

		

		

	
	
		             how changes to your guided pathways approach might affect the ROI.
		

		

		

		

		

		

		

		

		

	
	
		Note 2: The cost sections (2 & 3) are intended for you to measure the incremental costs of doing things differently under a guided pathways model.
		

		

		

		

		

		

		

		

		

	
	
		           While determining whether a given cost is "incremental" is somewhat subjective, we suggest thinking of your current cost structure as your 
		

		

		

		

		

		

		

		

		

	
	
		            baseline, and to only assign incremental costs that are clearly related to guided pathways type reforms.
		

		

		

		

		

		

		

		

		

	
	
		Note 3: The costs listed in sections 2 & 3 are examples of what costs could be associated with guided pathways type reforms; they are not 
		

		

		

		

		

		

		

		

		

	
	
		               intended to be an exhaustive list that you require you to fill in amounts for each cost / line (see Note 2 on incremental costs).
		

		

		

		

		

		

		

		

		

	
	
		           
		

		

		

		

		

		

		

		

		

	
	
		Section 1: Entering New Student Cohort at the College (Fall / Spring)
		

		

		

		

		

		

		

		

		

	
	
		

		A. Description
		B. Students Served
		

		

		

		

		

		

		

	
	
		1
		New FTEIC Students in Entering Cohort in a Given Academic Year
		700
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		Section 2: Staffing of Guided Pathways Related Efforts
		

		

		

		

		

		

		

		

		

	
	
		

		A. Position Title
		B. No. of Hourly Employees
		C. Hourly Rate
		D. Annual Hours Per Employee
		E. FTE for  Work
		F. Annual Salary
		G. Annual Benefits Cost
		H. Fixed Annual Budget for Support Type
		I. Total Cost for Support Type
	
	
		

		Example - Hourly
		6
		$10.00 
		80
		

		

		

		

		$4,800 
	
	
		

		Example - FTE
		

		

		

		0.5
		$66,000
		$26,400
		

		$46,200 
	
	
		

		Example - Annual Budget
		

		

		

		

		

		

		$18,400
		$18,400 
	
	
		1
		New or expanded advisors
		0
		$0.00 
		0
		0
		$0
		$0
		$0
		$0 
	
	
		2
		New or expanded completion coaches or retention specialists
		0
		$0.00 
		0
		0
		$0
		$0
		$0
		$0 
	
	
		3
		New or expanded career counseling staff
		0
		$0.00 
		0
		0
		$0
		$0
		$0
		$0 
	
	
		4
		New or expanded IR staff
		0
		$0.00 
		0
		0
		$0
		$0
		$0
		$0 
	
	
		5
		Coordination time (e.g. assigned Dean or staff member)
		0
		$0.00 
		0
		0
		$0
		$0
		$0
		$0 
	
	
		6
		Other Faculty / Staff Release time / Stipends to support work
		0
		$0.00 
		0
		0
		$0
		$0
		$250,000
		$250,000 
	
	
		

		

		

		

		

		

		

		

		Total Guided Pathways-Related Incremental Staffing Costs: 
		$250,000
	
	
		

		

		

		

		

		

		

		

		

		

	
	
		Section 3:  Incremental Fixed Costs on Guided Pathways
		

		

		

		

		

		

		

		

		

	
	
		

		A. Item
		B. Annual Cost/Budget
		

		

		

		

		

		

		

	
	
		

		Example
		$5,000
		

		

		

		

		

		

		

	
	
		1
		Technology Fees - Software, licenses, etc.
		$0
		

		

		

		

		

		

		

	
	
		2
		Technology Services - Costs to Implement / Support
		$0
		

		

		

		

		

		

		

	
	
		3
		Guided Pathways Related Travel (including conference fees)
		$0
		

		

		

		

		

		

		

	
	
		4
		Professional Dev. Costs for External Speakers / Content Experts
		$0
		

		

		

		

		

		

		

	
	
		5
		Subscription Fees for Guided Pathways Projects / Consultant Fees
		$0
		

		

		

		

		

		

		

	
	
		6
		Training for Advisors / Faculty / Staff on Guided Pathways
		$0
		

		

		

		

		

		

		

	
	
		7
		External Evaluator Costs to Assess Guided Pathways Impact
		$0
		

		

		

		

		

		

		

	
	
		8
		Other Fixed Cost #1
		$0
		

		

		

		

		

		

		

	
	
		9
		Other Fixed Cost #2
		$0
		

		

		

		

		

		

		

	
	
		

		Total for Incremental Fixed Costs: 
		$0 
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		Section 4: Incremental Cost Summary
		

		

		

		

		

		

		

		

		

	
	
		

		A. Item
		B. Annual Cost/Budget
		

		

		

		

		

		

		

	
	
		1
		Staffing of Guided Pathways Efforts
		$250,000
		

		

		

		

		

		

		

	
	
		2
		Incremental Fixed Costs
		$0
		

		

		

		

		

		

		

	
	
		

		Total Incremental Guided Pathways Related Costs: 
		$250,000 
		

		

		

		

		

		

		

	
	
		

		Incremental Costs Per Student: 
		$357 
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		Section 5: Funding Assumptions per FTE & Unit
		

		

		

		

		

		

		

		

		

	
	
		

		A. Description
		B. Value
		

		

		

		

		

		

		

	
	
		1
		Tuition Cost for 24 semester units (roughly equal to 1 FTE)
		$2,376
		

		

		

		

		

		

		

	
	
		2
		Apportionment per FTE 
		$1,850
		

		

		

		

		

		

		

	
	
		

		Total Funding per FTE:
		$4,226
		

		

		

		

		

		

		

	
	
		

		Funding per Unit:
		$176
		

		

		

		

		

		

		

	
	
		

		

		 
		

		

		

		

		

		

		

	
	
		Section 6: Incremental Units from Cohorts After Guided Pathways Reforms
		

		

		

		

		

		

		

		

		

	
	
		

		A. Description
		B. Value
		

		

		

		

		

		

		

	
	
		1
		Number of Students in New Student Cohort (from Section 1 above)
		700
		

		

		

		

		

		

		

	
	
		2
		Average Number of Total Semester Units Attempted Per Entering New Student Over 3-Year Period (for the last entering cohort for whom three years of data is available
		20.0
		

		

		

		

		

		

		

	
	
		3
		Improvement Goal - Enter a Percentage Increase in 3-year Average Total Attempted Units You Hope to Achieve due to Guided Pathways reforms
		20.0%
		

		

		

		

		

		

		

	
	
		4
		Average Number of Total Units Attempted Per Entering New Student Over 3-Year Period If Improvement Goal from #3 is hit (calculated automatically)
		24.0
		

		

		

		

		

		

		

	
	
		5
		Modeled Incremental Total Units Generated from New Students After Improvement Goal is Hit
		2,800.0
		

		

		

		

		

		

		

	
	
		6
		Potential Revenue from Incremental FTE
		$493,033
		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

	
	
		Section 7: Cost / Benefit of Guided Pathways Reforms and ROI Estimate
		

		

		

		

		

		

		

		

		

	
	
		

		A. Description
		B. Value
		

		

		

		

		

		

		

	
	
		1
		Annualized Cost of Program from Section 5
		$250,000
		

		

		

		

		

		

		

	
	
		2
		Potential Revenue from Section 8
		$493,033
		

		

		

		

		

		

		

	
	
		3
		Profit Margin on Potential Revenue*
		60%
		

		

		

		

		

		

		

	
	
		4
		Net Revenue after Profit Margin Calculation
		$295,820
		

		

		

		

		

		

		

	
	
		5
		Net Profit = Net Revenue - Annualized Cost
		$45,820
		

		

		

		

		

		

		

	
	
		6
		Estimate of Return on Investment (ROI)
		18%
		

		

		

		

		

		

		

	
	
		

		*Note: The "profit margin" calculation is to acknowledge that the incremental revenue generated is not without incremental costs - see the instructions document for a deeper exploration of this issue.

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet roi model semester schools ncii s guided pathways returnoninvestment for colleges on the system note this is designed as an order of magnitude demonstration rather than a detailed cost it can be helpful however in visualizing costs and returns reforms also to do quot whatif modeling how changes your approach might affect sections amp are intended you measure incremental doing things differently under while determining whether given somewhat subjective we suggest thinking current structure baseline only assign that clearly related type listed examples what could associated with they not exhaustive list require fill amounts each line see section entering new student cohort at college fall spring description b students served fteic academic year staffing efforts position title no hourly employees c rate d annual hours per employee e fte work f salary g benefits h fixed budget support i total example or expanded advisors completion coaches retention specialists career counseling staf...

Related files

Share

Help

NCII's Guided Pathways Return-on-Investment Model
	For Colleges on the Semester System
Note 1: This model is designed as an order of magnitude demonstration, rather than a detailed cost model.
It can be helpful, however, in visualizing the costs and returns of guided pathways reforms, and also to do "what-if" modeling of
how changes to your guided pathways approach might affect the ROI.
Note 2: The cost sections (2 & 3) are intended for you to measure the incremental costs of doing things differently under a guided pathways model.
While determining whether a given cost is "incremental" is somewhat subjective, we suggest thinking of your current cost structure as your
baseline, and to only assign incremental costs that are clearly related to guided pathways type reforms.
Note 3: The costs listed in sections 2 & 3 are examples of what costs could be associated with guided pathways type reforms; they are not
intended to be an exhaustive list that you require you to fill in amounts for each cost / line (see Note 2 on incremental costs).

Section 1: Entering New Student Cohort at the College (Fall / Spring)
	A. Description	B. Students Served
1	New FTEIC Students in Entering Cohort in a Given Academic Year	700

Section 2: Staffing of Guided Pathways Related Efforts
	A. Position Title	B. No. of Hourly Employees	C. Hourly Rate	D. Annual Hours Per Employee	E. FTE for Work	F. Annual Salary	G. Annual Benefits Cost	H. Fixed Annual Budget for Support Type	I. Total Cost for Support Type
	Example - Hourly	6	$10.00	80					$4,800
	Example - FTE				0.5	$66,000	$26,400		$46,200
	Example - Annual Budget							$18,400	$18,400
1	New or expanded advisors	0	$0.00	0	0	$0	$0	$0	$0
2	New or expanded completion coaches or retention specialists	0	$0.00	0	0	$0	$0	$0	$0
3	New or expanded career counseling staff	0	$0.00	0	0	$0	$0	$0	$0
4	New or expanded IR staff	0	$0.00	0	0	$0	$0	$0	$0
5	Coordination time (e.g. assigned Dean or staff member)	0	$0.00	0	0	$0	$0	$0	$0
6	Other Faculty / Staff Release time / Stipends to support work	0	$0.00	0	0	$0	$0	$250,000	$250,000
								Total Guided Pathways-Related Incremental Staffing Costs:	$250,000

Section 3: Incremental Fixed Costs on Guided Pathways
	A. Item	B. Annual Cost/Budget
	Example	$5,000
1	Technology Fees - Software, licenses, etc.	$0
2	Technology Services - Costs to Implement / Support	$0
3	Guided Pathways Related Travel (including conference fees)	$0
4	Professional Dev. Costs for External Speakers / Content Experts	$0
5	Subscription Fees for Guided Pathways Projects / Consultant Fees	$0
6	Training for Advisors / Faculty / Staff on Guided Pathways	$0
7	External Evaluator Costs to Assess Guided Pathways Impact	$0
8	Other Fixed Cost #1	$0
9	Other Fixed Cost #2	$0
	Total for Incremental Fixed Costs:	$0

Section 4: Incremental Cost Summary
	A. Item	B. Annual Cost/Budget
1	Staffing of Guided Pathways Efforts	$250,000
2	Incremental Fixed Costs	$0
	Total Incremental Guided Pathways Related Costs:	$250,000
	Incremental Costs Per Student:	$357

Section 5: Funding Assumptions per FTE & Unit
	A. Description	B. Value
1	Tuition Cost for 24 semester units (roughly equal to 1 FTE)	$2,376
2	Apportionment per FTE	$1,850
	Total Funding per FTE:	$4,226
	Funding per Unit:	$176

Section 6: Incremental Units from Cohorts After Guided Pathways Reforms
	A. Description	B. Value
1	Number of Students in New Student Cohort (from Section 1 above)	700
2	Average Number of Total Semester Units Attempted Per Entering New Student Over 3-Year Period (for the last entering cohort for whom three years of data is available	20.0
3	Improvement Goal - Enter a Percentage Increase in 3-year Average Total Attempted Units You Hope to Achieve due to Guided Pathways reforms	20.0%
4	Average Number of Total Units Attempted Per Entering New Student Over 3-Year Period If Improvement Goal from #3 is hit (calculated automatically)	24.0
5	Modeled Incremental Total Units Generated from New Students After Improvement Goal is Hit	2,800.0
6	Potential Revenue from Incremental FTE	$493,033

Section 7: Cost / Benefit of Guided Pathways Reforms and ROI Estimate
	A. Description	B. Value
1	Annualized Cost of Program from Section 5	$250,000
2	Potential Revenue from Section 8	$493,033
3	Profit Margin on Potential Revenue*	60%
4	Net Revenue after Profit Margin Calculation	$295,820
5	Net Profit = Net Revenue - Annualized Cost	$45,820
6	Estimate of Return on Investment (ROI)	18%
	*Note: The "profit margin" calculation is to acknowledge that the incremental revenue generated is not without incremental costs - see the instructions document for a deeper exploration of this issue.

Related files

Share

Share to social media

Help

Login Area