Workbook on Mountain Sports Village Shop Sales to Data

Note: There are two versions of this iLab in order to learn one point from two different angles.

Description

Scenario/Summary

Management at Summit Ridge Mountain Resort is very pleased with your initial report. This week, management has asked that you add to the prior analysis and incorporate some visual images concerning the Village Shop sales. This new analysis will require the use of new formulas, new functions, and several charts to graphically depict the report findings. This updated Excel workbook will be used for a presentation to the board of directors.

### Deliverables

Submit one workbook. When submitting the workbook, provide a comment in the comments area explaining what you learned from completing this lab activity. File naming convention: If your name is Jane Doe, then your file should be named very similar to Doe_J_Week2_Lab.xlsx. Make certain you compare your finished work with the Grading Rubric included here.

Lab 2 Shop Analysis

Step

Points Possible

Documentation sheet completed

5

1

Daily Item Totals worksheet

1a

Copy Daily Sales to new worksheet

2

1b

SUM function for items

2

SUM function for dates

2

1c

Formula percentage of sales

3

1d

Statistical functions for sales

3

1e

Formula profit per item

2

2

Create Bar Chart

2a

2D Bar Chart

5

2b

On new worksheet

2

2c

Title andÂ tabÂ named

2

3

Create Pie Chart

3a

Pie Chart

5

3b

On new worksheet

2

3c

Title andÂ tabÂ named

2

# BIS 155 Week 2 iLab | Summit Ridge Mountain Resort | v1 & v2

• Institution(s): Devry
• Year Published: 2021

\$5.00

\$10.00

\$10.00

\$10.00

\$10.00

\$10.00

\$10.00

\$65.00

\$5.00

\$5.00

\$5.00

\$5.00

\$5.00

\$5.00

\$5.00

\$45.00

\$5.00

\$5.00

\$5.00

\$5.00

\$5.00

\$5.00

\$5.00

\$45.00

\$20.00

\$20.00

\$20.00

\$35.00

\$10.00