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/SummaryManagement 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 |
Task |
Points Possible |
Points Received |
Comments |
|
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
Related ProductsTags: BIS 155 Week 2 iLab, BIS155 Week2 iLab, BIS 155 Week 2 iLab Summit Ridge Mountain Resort, BIS 155 Week 2 Summit Ridge Mountain Resort, BIS 155 Week 2 iLab Village Shop sales. MessageAll members who signed up before 2023 are requested to register again. | |