The purpose of this case is to calculate a budget when there is somewhat but not too complicated set of assumptions. Following the process discussed in the class slides, construct a 1-page operating budget for the Bay Area Regional Health Inequities Initiative.

The Bay Area Regional Health Inequities Initiative (BARHII) is a coalition of the San Francisco Bay Area's eleven public health departments committed to advancing health equity. BARHII conducts three types of training activities: Health Equities Training, Data Management Training, and Build Environment Training. Each program is managed by a separate program manager who does not run the training. Faculty for training programs are hired on a per-session basis, based on the actual number of trainees in session and budgeted trainee-to-faculty ratio. All funding is provided by participating public health departments on a per-trainee basis.

	Health Equities	Data Management	Built Environment
# training sessions	5	2	8
Length of each training session (in weeks)	10	20	5
Average # trainees per session	50	30	20
# trainee-weeks	2500	1,200	800
# trainees	250	60	160
Trainee to faculty ratio	25:1	10:1	10:1
# faculty needed	2	3	2
Average faculty salary	$60,000	$65,000	$55,000
Books/workbooks per trainee	2	2	5
Average price per book/workbook	$15	$20	$10
# Program directors needed	1	1	1
Program director salary	$40,000	$40,000	$40,000

*The agency anticipates that its administrative and general costs would total $88,200 for the year

Budgeting Memo Template

Bay Regional Health Inequities Initiative: Budget

	Health Equities	Data Management	Built Environment	TOTAL Cost
Program Directors
# x $price	$	$	$
				$
Faculty
# x times x $price	$
#x times x $price		$
# x times x $price			$
				$
Workbooks
# x ? x $price	$
# x ? x $price		$
# x ? x $price			$
				$
Program Related Expenses	$	$	$	$
Administrative and General (A&G)				$
Total Expense				$
Program expense per trainee	$	$	$
A&G expense per trainee	$	$	$
Total expense per trainee	$	$	$

JUST CALCULATION PAGE/Program expenses per trainee, A& G expenses per trainee and total expenses per trainee?