Question $4(4$ points$)$: As STH$$s finance manager, you have been asked to evaluate the fiscal

feasibility of running STH Kids$$ Center. The question is how many children will have to be at

the center on an average day for the center to be profitable on a stand$-$alone basis. Calculate

break even quantity $($average number of children per day$)$ for different staffing levels provided

in the Excel template.

Erika Fossett believes that the Kids$$ Center will add $6$ percent to overall skier days, and families

with children between $3$ and $7$ will account for $10$ percent of total skier days including the

expected increase in volume. On average, families with children between $3$ and $7$ will enroll $\mathrm{.}25$

children in the center each day they ski. She expects to employ an average of $6$ instructors each

day the ski area is open Question $4-$ STH Kid's Center Break $]$iven

$($This is not all input information you will need to answer this question$)$

Care Hours per Day

Child$-$Care Worker Salary per Hour

Children per Child$-$Care Worker

$\backslash$table$[[8],[$$$25],[10],[,,,,,],[,,,,,],[$BEQ$],[\backslash$table$[[$Budegted$],[$Child Days$]],$Manager,$\backslash$table$[[$Child$-$Care$],[$Workers$]],$Total FC$,$CM$,\backslash$table$[[$Child Days to$],[$Break Even$]]],[30,,600,,,],[40,,800,,,],[50,,1,000,,,]]$