SPREADSHEET ANALYSIS

The Turquoise Oasis Spa serves resort guests with a full range of services from traditional and alternative massage to aromatherapy and detoxification therapy. The spa is open seven days a week. Meda Rodate, the spa manager, would like a workbook that allows her to summarize and compare the sales of each therapist and services used for each day the spa is open.

The Turquoise Oasis Spa serves resort guests with a full range of services from traditional and alternative massage to aromatherapy and detoxification therapy. The spa is open seven days a week. Meda Rodate, the spa manager, would like a workbook that allows her to summarize and compare the sales of each therapist and services used for each day the spa is open.

The sales team at the Painted Treasures Gift Shop would like to review its staff’s sales after some of the new staff members have finished a sales training program. You have been given the data for May 2018 and more data will be added in the future. The sales team wants you to review the data, perform some data analyses, and answer some specific questions. This will help the sales team determine how well the staff is performing, and who needs further training.

The Red Bluff Golf Course & Pro Shop generates revenue through its golfers, golfer services, and pro shop sales. Aleeta Herriott, the pro shop manager, receives revenue data on a monthly basis. She would like to have some reports developed that will help to track sales and to analyze her profit margins. She has a workbook started with some sample data and wants you to continue developing some reports. These reports will help Aleeta make educated decisions about the business, such as which items ...

The Red Bluff Golf Course & Pro Shop generates revenue through its golfers, golfer services, and pro shop sales. Aleeta Herriott, the pro shop manager, receives revenue data on a monthly basis. She would like to have some reports developed that will help to track sales and to analyze her profit margins. She has a workbook started with some sample data and wants you to continue developing some reports. These reports will help Aleeta make educated decisions about the business, such as which it...

The Turquoise Oasis Spa managers, Irene Kai and Meda Rodate, are pleased with your work and would like to see you continue to improve the spa spreadsheets. They want to use charts to learn more about the spa. Meda has given you a spreadsheet with some data and would like you to develop some charts. Visualizing the data with charts will provide knowledge about the spa for decision-making purposes.

Lesa Martin, a member of the support/coordination staff for the conference center at Painted Paradise Golf Resort and Spa, has created a worksheet to keep track of the renovations being made to the three rooms that are used for conferences and the two technology centers that are used for computer-based presentations and interactive sessions. The technology centers are equipped with workstations, are networked, and have Internet accessibility. This spreadsheet is simple and designed only for Lesa...

The marketing manager of the Painted Paradise Golf Resort & Spa, Timothy Smith, has created a spreadsheet of the first six months (first two quarters) of advertising expenses for the various amenities of the resort. He is planning to display the data at the next Board of Directors meeting and wants to create a few charts to make the figures easier to view and the presentation more visually appealing.