Question: this needs to be solved using excel and functions shown please and thank you 24. The College of Business at Tech is planning to begin

this needs to be solved using excel and functions shown please and thank you
24. The College of Business at Tech is planning to begin an online MBA program. The initial start-up cost for computing equipment, facilities, course development, and staff recruitment and development is $350,000. The tuition of $18,000 per student per year. However, the university administration will charge the college $12,000 per student for the first 100 students enrolled eachyear for administration costs and its share of the tuition payments. a) How many students does the college need to enroll for the first year to break even? b) If the college can enroll 75 students the first year, how much profit will it make? c)The college believes it can increase tuition to $24,000 but doing so would reduce enrollment to 35. Should the college consider doing thisStep by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
