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 |
BIS 155 Week 4 iLab | Summit Ridge Mountain Resort
Related ProductsTags: BIS 155 Week 4 iLab, BIS155 Week4 iLab, BIS 155 Week 4 iLab Summit Ridge Mountain Resort, BIS 155 Week 4 Summit Ridge Mountain Resort, BIS 155 Week 4 iLab Warming Hut. MessageAll members who signed up before 2023 are requested to register again. | ||