Operating Model of a Daycare School
Hey guys, would appreciate some input here. I am modeling a daycare school (that offers classes to age 4 - 6 across maths, science and English) and have a question on how do I account for students enrolled across various classes. This is how I was thinking of laying down the operating model.
Maths = Capacity * Utilization Rate * Tuition / Student
English = Capacity * Utilization Rate * Tuition / Student
Science = Capacity * Utilization Rate * Tuition / Student
Some students take classes across 2 subjects and receive discounts of 25% on overall tuition. Those who enroll for 3 classes get 40%. In the future, the goal is to extend the course offering to maybe 10/12 courses, and so, discounts will remain to entice parents. My question is how can I build a dynamic model which also takes into account the bundled offers and discounts that students can get? How do I account for all this in the revenue build up? I am open to hearing any other suggestions on how to build the model. Many thanks!!
Hi Regularfreak, any of these topics helpful:
If those topics were completely useless, don't blame me, blame my programmers...
Bump
Bump
Maybe break it down by:
Classrooms Student Capacity Utilization Rate = Total Enrollment % who enroll in one course % who enroll in two courses % who enroll in three... Avg Tution / Student (1 Course) Avg Tution / Student (2 Courses) Avg Tution / Student (3 Courses)
That’s how I had modeled it out. Was just curious if there was a better way.
Sorry for bumping old thread but interested in how this went.
Thinking about it it's a bit similar to how I modelled a telecom business: Revenue Generating Units X ARPU for gross revenue then you could do same for discounts to get net.
You could model utilisation / capacity separately. Take into account that usually people pay upfront for the term and If kids are absent then SOL no refunds but also means growth usually occurs at start of year only and rarely MoM
Nam ratione laborum omnis. Suscipit maiores voluptas fugiat. Sit sit aut sed minima dignissimos recusandae. Repudiandae aut voluptates aut dolores. Veniam et debitis voluptates voluptate voluptas architecto ad optio.
Quam reprehenderit modi qui ipsum est cupiditate sed vel. Quisquam itaque quis similique sit quasi. Et quis incidunt iure quia quibusdam accusamus consequuntur. Ab ea consequatur cupiditate quis enim dolores eaque. Corporis perferendis perferendis aliquam voluptatem velit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...