Hi there. I'm struggling with which Excel formulas to use and was wondering if you would help solve this (sensitivity analysis) so I can apply it to other homework problems, as they are similar. Thank you!

Eastviews police department hires a new class of 50 trainees every quarter to begin the 3-month police academy program. Four nearby communities have struggled in running their own police academies, partly due to their own city funding but also because their class size is much smaller (ranging from 5 to 15 trainees in each city). Eastviews newspaper recently ran a story about the citys intent to build a new training facility for the police academy. The four communities want to partner with Eastview to have Eastview provide their academy program rather than hosting it themselves. Using the information in Worksheet 8.3, analyze how the cost would vary from the lowest enrollment to the highest enrollment if Eastview and the four surrounding communities cooperated on a joint academy. The academy provides room and board to all trainees for a period of 11 weeks.

Eastview Police Academy Sensitivity Analysis: Multiple-Community Partnership

		Eastview Only	All-Low	All-High
Trainees		50	5	15
Room Cost per week	$110.00
Food Cost per person per week	$94.50
People per Classroom	55
Cost Per Classroom week week week	$1,000.00
Instructor Per Classroom week week	$1,500.00
Academy Materials per person total	$5,000.00
Total

(Chen 59)

Chen, Greg G. Budget Tools: Financial Methods in the Public Sector, 2nd Edition. CQ Press, 11/2014. VitalBook file.