Workbook on Mountain Sports Village Shop Sales to Data
Description
Scenario/SummaryYou 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
Related ProductsTags: 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. MessageAll members who signed up before 2023 are requested to register again. | |||