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)

madule .5 xl Excel - File Home Inset Page Layout Formulas t Revw view Help Tell me what you want to do e share Cut AurtoSum Calibri Insert Delete Formet ort Find& Fornat Painter Farmatting Table ClearFilter Selert lcnt Agnment Number Lditing D11 1 Table 0.5 Eastview Police Academ Percent Correct this oage Grade in Points All Shests ut a check here Eastview Only 1-Low Trainees 10 Trainees Weeks 11 Room cost per person per weelk 12 Food cost perperson per week 13 People per classroom 14 Cost estimate per classroom per week 1,00000 15 nstrutor per dlassroom per week 16 Academy materials per person total5,000.00 5 11000 $ 950 0500 1, 975, 00 These logical formulas are suppliec 11,000 1,500016,500 50,000 18 Total Check TRUE 24 TRUE TRUE .. Exercise 0.2 Exerose 0.3 Exercise 8.5 Grace Worksheet Ready 12/6 2018