• BIS 155 Week 1 iLab | Summit Ridge Mountain Resort
Workbook on Mountain Sports Village Shop Sales to Data

Description

Scenario/Summary

You are new to the staff of Summit Ridge Mountain Resort. One of the benefits to your employment is a free mountain ski pass. You are anxious to complete your work and enjoy a run down the mountain but know management is looking to you for important details and analysis for the ski resort overall. This week, management has asked that you begin to prepare a report for the Village Shop Sales. The report will summarize all sales of all items and include the total profit-to-date with the amount remaining to reach the profit goal. You will open the partially completed workbook, create formulas, and format your work professionally.

Deliverables

After completing the steps below, turn in one Excel 2016 workbook. Rename the workbook with your lastname_first initial_Week1_Lab. xlsx. Example: If your name were Jane Doe, your workbook would be Doe_J_Week1_Lab.xlsx.

When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity. Make certain you compare your finished work with the Grading Rubric included here.


Lab 1 -  Village Shop Sales

Step

Task

Points Possible

Points Received

Comments

1

Documentation sheet

1a

Insert new worksheet

1

1b

Rename worksheet  tab

1

1c

Enter identifying information

2

1d

Format with text wrapping & color formatting

2

2

Calculations

2a

Calculate Net Selling Price for each item

3

Calculate the Total Sales for each item

3

Calculate the Total Profit per item

3

Calculate the Average Profit % for each item

3

2b

Calculate Total Profit to Date

3

2c

Calculate the Remaining Profit Need to meet the Goal

3

3

Formatting

3a

Center the spreadsheet title rows across the selection A – R

4

3b

BIS 155 Week 1 iLab | Summit Ridge Mountain Resort

  • Institution(s): Devry
  • Year Published: 2019
  • Digital Download: Instant
  • $14.00


Related Products

Tags: BIS 155 Week 1 iLab, BIS155 Week1 iLab, BIS 155 Week 1 iLab Summit Ridge Mountain Resort, BIS 155 Week 1 Summit Ridge Mountain Resort, BIS 155 Week 1 Village Shop sales.