• BIS 155 Week 4 iLab | Summit Ridge Mountain Resort

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

  • Institution(s): Devry
  • Year Published: 2021
  • Digital Download: Instant
  • $10.00


Related Products

Tags: 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.