Central Parking Services (CPS) with headquarters located in Bangalore, India provided parking solutions at various malls, office buildings, airports, residential apartments, hospitals and so on throughout India. In 2013, Poornima, Director of new initiatives at CPS, wanted the company to take a strategic direction toward using analytics to strengthen its operational decisions. The company was growing exponentially and with that came the challenge of managing the high pressure of growing demand, clients' expectations as well as driving end-customer satisfaction. The company was struggling with operational issues such as demand supply gap and waiting time at the entry and exit gates of parking lot. Pricing and manpower planning are two important decisions CPS has to make to ensure profitability of the company.

Spreadsheet Supplement for IMB451