Transcribed Image Text
Unemployment among high school graduates is quite high due to arecession. City Community College is considering a new program tohelp young people get the training they need to be more employable.The college has collaborated with the municipal hospital to build anurse’s aide program, a 1-year program that would lead to immediateemployment. Initial financial analysis indicates that the totalfixed cost of the program will be $200,000, which includes the costof a 1-year rental of the facilities plus utilities, insurance, andadministrative costs. The variable cost and step cost together are$10,000 per student, which pays for faculty salary, studentlunches, and teaching materials and textbooks. The state kicks in$5,000 per student, and the tuition based on market analysis is$6,000. Given that the nurse’s aide program has never been offeredin the region before and will be under financial pressure due tocurrent funding cuts, the college’s board of trustees would like toknow how many students would need to be enrolled for the program tobreak even. The board also wants to know what other options it willhave to mitigate these financial issues if the expected enrollmentis below the break even point, given the high profile of theprogram at a time when employment and economic recovery arecritical.Consider two possibilities: (1) Funding is limited to$100,000, or (2) with the benefit of efficiencies, variable andstep costs can be reduced to $9,500. You are required to do afinancial analysis of the proposed program. Please provide aspreadsheet solution and a written explanation of yourapproach.