Question

The Winterville homeless shelters, including the potential new facility, are located in the same neighborhood as a facility that provides evening meals at no cost for needy individuals all week, year-round. The cost per meal is $7. Historically, all families and 70% of the single individuals have taken advantage of this service. Others come as well, and the facility has found it effective to plan for usage to be a total of 110% of the capacity of the family shelter and 90% of the capacity of the single-person shelter. With the new shelter’s capacity for 200 more individuals, the 110% ratio is uncertain. In Worksheet 8.1, examine the effect if the ratio falls by 10 percentage points or increases by 10 percentage points for each group. Show the change from the current annual cost.

Winterville Meal Center Sensitivity Analysis: Planning Ratio Change From Facts Total Current Capacity Increased Capacity 200 100 100 100 70% 100% Meal Utilization from Facility Current Planning Ratio 90% 111)% 10% 10% Planning increment Cost per Meal $7.00 $7.00 Solution Current Utilization Current Cost Annualized Annual Cost Anticipated Capacity Low Planning Ratio Meal Utilization Cost per Meal Annualized Annual Cost Anticipated Capacity Current Planning Ratio Meal Utilization Cost per Meal Annualized Annual Cost Anticipated Capacity High Planning Ratio Meal Utilization Cost per Meal Annualized Annual Cost

Answer 1

Home nsert Pege Layout FormulasD w Viesw Develope Σ AutoSum Copy . fill B | 11. аз. s'쇼 iFiF 쁘Merge & Center. $. % , +0:2 Conditional Format Neutral Check Cell Insert Delete Format Seet & Find & Flr- Select Format Fainter 2Clear formatting T B5 Table Clpboard Cells Alignment Editin sinele ychanee 100 Meal util 90% 110% Plan incre. CP Meal 7.00 7.00 the Current capacity for single person has been given as 200, therefore the planning % points were varied from 80% to 100% to identify the changes in cost & the eresut are as below: Single Family cU 2 weeks 52 weeks 16 458640 280280 Antic. Cap 19 160 100 21 Meal Utili 7 per week 7 per week CP Meal 52 Weeks 52 Weeks Antic. Cap 120 100% 120 Meal Utili 7 per week 7 per week CP Meal 31 52 Weeks 52 Weeks SD9600 3057 Thus cost very from 407680 to 509600 in singles & from 254800 to 305760 in families 35 ส Planning % changes 10% & will cuse costohanges in singles 1 1.11% & in ldmilies 9.09% ト H Sheet1, ! Ready