BIS 155 Week 4 iLab: Summit Ridge Mountain Resort

BIS 155 Week 4 iLab: Summit Ridge Mountain Resort

Warming Hut Income, Seasonal Activities and X Games



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.


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