Warming Hut Income, Seasonal Activities and X Games
Description
Scenario/Summary
Summit Ridge Mountain Resort has three full-service warming huts on its majestic mountains. The Summit View, the Bunny Den, and the Mogul Hill Samurai warming huts are rest stops that provide skiing customers a place to relax, eat, and warm up. At the end of the month, the manager of each warming hut prepares a worksheet that summarizes the monthly income.
Please note that during the summer months, Summit Ridge conducts activities such as zip lining, nature photography tours, off-trail biking, and hiking. As the assistant to the general manager of Summit Ridge Mountain Resort, you will need to consolidate each warming hut’s data into one worksheet so that decisions such as inventory, purchasing, and profitability can be assessed in order to manage the business well. In this lab, you will also apply other data management tools that are part of the overall management of an organization.
Deliverables
After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week4_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week4_Lab.xlsx.
Lab 4 Mountain Consolidation | ||||
Step | Task | Points Possible | Points Received | Comments |
1 | Data Consolidation | |||
1a – g | Group Sheets & format | 7 | ||
2 | 3D Formulas | |||
2a, b | Create 3-D cell references to complete Summary table | 5 | ||
2c | Create Grand totals | 4 | ||
2d | Insert Comment | 2 | ||
2e | Data validation with Error Alert | 3 | ||
3 | Comparison Worksheet | |||
3a | Create cell references | 2 | ||
3b | Create totals for seasons | 2 | ||
3c | Create & Format the Chart | 5 | ||
4 | X Games Calculator | |||
4a | Ticket Type drop down list | 4 | ||
4b | VLOOKUP for ticket price | 2 | ||
4c | Validation with error message for quantity | 2 | ||
4d, e, f | Format & add clip art | 4 | ||
5 | Documentation Sheet | |||
5a, b | Format sheet & tabs | 3 | ||
5c | Author set to student name | 2 | ||
5d | Describe how to protect | 3 | ||
5e | Make a recommendation | 5 | ||
Comment: What you learned from completing this Lab | 5 | |||
TOTAL POINTS | 60 | 0 |