PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.I REPEAT, ONLY EXCEL PROBLEM 1The School of Management and Accountancy is planning to begin an online MSA (Master of Science inAccountancy) program. The initial start-up costs for computing equipment, facilities, coursedevelopment, and staff recruitment and development are P350,000. The school plans to charge tuitionof P18,000 per student per year. However, the university administration will charge the school P12,000per student for the first 100 students enrolled each year for administrative costs and its share of thetuition payments.Required:a. How many students does the school need to enroll in the first year to break even?b. If the school can enroll 75 students the first year, how much profit will it make?c. The school believes it can increase tuition to P24,000, but doing so would reduce enrollmentto 35. Should the school consider doing this?

Break even point is that point on which we will not earn any profit / Loss from the project. At that…

Answered: PROBLEM 1 The School of Management and…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Concept explainers

Question

100%

PLEASE USE EXCEL ON ANSWERING THE QUESTIONS. MAKE SURE TO TAKE A SCREENSHOT STEP BY STEP OF HOW YOU DID THE SOLUTIONS IN EXCEL. ANSWER THIS COMPLETELY TO GET AN UPVOTE. I POSTED A LOT OF THIS, IF YOU SEE THIS AGAIN, YOU CAN SEND THE SAME SOLUTIONS, I WILL STILL UPVOTE DO NOT WORRY, JUST GIVE ME THE CORRECT SOLUTIONS AND ANSWERS.

I REPEAT, ONLY EXCEL

PROBLEM 1
The School of Management and Accountancy is planning to begin an online MSA (Master of Science in
Accountancy) program. The initial start-up costs for computing equipment, facilities, course
development, and staff recruitment and development are P350,000. The school plans to charge tuition
of P18,000 per student per year. However, the university administration will charge the school P12,000
per student for the first 100 students enrolled each year for administrative costs and its share of the
tuition payments.
Required:
a. How many students does the school need to enroll in the first year to break even?
b. If the school can enroll 75 students the first year, how much profit will it make?
c. The school believes it can increase tuition to P24,000, but doing so would reduce enrollment
to 35. Should the school consider doing this?

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions