I need a break analysis and/or financial model for a tuition based school. School revenues are based on enrollment. So, more students, more money. The tricky part is that the student-teacher ratio is 15-1. So, a simple break even analysis doesn't work because the break even enrollment may trigger the addition of teaching staff.
I want the model to return the requisite student enrollment needed to sustain projected expenses and also automatically account for the addition of teachers to maintain student/teacher ratio.
I will develop a mathematical model that calculates the revenue, expenses, profit and number of teachers associated with running the school. The model can be delivered as a pure mathematical model or programmed in python, mathematica or excel.
$120 USD 3 gün içinde
5,0 (1 değerlendirme)
2,2
2,2
8 freelancer bu proje için ortalama $132 USD teklif veriyor
Hi, sir
I have a detail look to your project,
I have a great skill in mathematics.
I'm sure I can complete your project.
My price and period is negotiable.
We can discuss the details via chat.
Thanks.
Hi, my name is Zeeshan. I would love the opportunity to do break-even analysis of you School business. Please share more details to discuss properly.
I have completed my BS Electrical Engineering and now enrolled in MS Electrical Engineering. I have more than 3-years of experience in Engineering Management.
If you want to know more about skills, or expertise, please feel free to message me. Looking forward to working with you.
Thank you
Best regards Zeeshan
To ensure accuracy and completeness of breakeven analysis, I would need the following information:
1. Total fixed cost which would include
- rent for both office & rooms used by students. capacity per room. how many rooms currently contracted for. is there a rent increase provision? when will the rent increase takes effect
- how many hours required per class session
- salary of teachers hired
- minimum number of teachers required
- salary of office staff
- depreciation of school & office furniture & fixtures. pls indicate up to what level or how many students the current school furniture & fixtures can support.
- minimum electricity billing (there will be a variable cost component for this like number of hours aircon/heater is operational)
- minimum water bill (pls indicate number of office staff so we can calculate variable portion based on number of students)
- other operating costs
2. Variable costs
- portion of electricity and water usage (I can derive based on fixed cost info)
3. Tuition fee rate per student
- is it per subject?
- is there a miscellaneous fee component of the tuition or school fees?
- how many hours or days correspond to the tuition fee
- how's the manner of completion - is it fixed or would depend on the student's schedule to complete the course enrolled?
4. So you can use in the future the breakeven computation prepared for this engagement? which spreadsheet platform you prefer - excel, googlesheet, open office?
Looking forward for further discussion on your requirements.
I have briefly read the description on web/app development, and I can deliver as per the requirements however I need us to discuss for more clarity on the details, deadline and budget as well.