Problems 12-41 should be prepared in a Word document with embedded Excel spreadsheets for relevant calculations and supporting schedules. You still need to post your Excel worksheet to show support for your calculations. Note, you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail. Suggestion: To complete all parts of the problems correctly you should start each assignment with preparing an Excel workbook. The response for Problem 12-41 should be a minimum of 250 words.

12-41

The following partial organization chart is an extension of Exhibit 121 for Aloha Hotels and Resorts. Waikiki Sands Hotel Grounds and Maintenance Department Front Desk Housekeeping and Custodial Department Food andBeverageDepartmentHospitalityDepartmentBellStafGuestServicesRecreationalServicesDepartmentEach of the hotels five main departments is managed by a director (e.g., director of hospitality). The Front Desk subunit, which is supervised by the front desk manager, handles the hotels reservations, room assignments, guest payments, and key control. The Bell Staff, managed by the bell captain, is responsible for greeting guests, front door service, assisting guests with their luggage, and delivering room-service orders. The Guest Services subunit, supervised by the manager of Guest Services, is responsible for assisting guests with local transportation arrangements, advising guests on tourist attractions, and such conveniences as valet and floral services.

Required: As an outside consultant, write a memo to the hotels general manager suggesting a responsibility center designation for each of the subunits shown in the organization chart above. Justify your choices.