APIDO develops private fitness clubs in small towns. RAPIDO buys or leases a local hotel or motel, then renovates to provide a gym, swimming pool, sauna, Jacuzzi, and a small caféwhere patrons can buy juices, smoothies, and other healthy snacks. RAPIDO only develops clubs in towns where it has no competitors. The main product is a one-month membership, which gives patrons unlimited use of the gym and other club facilities. So far RAPIDO has opened 24 such clubs in different towns.
You have just started working for RAPIDO, and your new boss, Karen, gives you a copy of an Excel spreadsheet containing data collected last year on RAPIDO's 24 existing clubs. She asks you to use the data to complete the following important and time-sensitive tasks: