Spreadsheet-modeling

This project aims to explore 4 different strategies to increase the business profit of Studio Starfire via:

• Price Sensitivity Analysis – Analysis of class prices against demand to optimise class price chargeable to students.

• Optimising Class Mix – Optimise number of class types and runs in the timetable to maximise profits.

• Expansion Model Analysis – Determine if it is viable to set up a new branch at a new location.

• Analysis of Customer Relation Strategies – Explore marketing strategies to increase class enrolment rate.