BIS 155 Week 1 iLab: Summit Ridge Mountain Resort
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 | Apply text wrapping to column headings | 4 | ||
| 3c | Change Font size and color | 2 | ||
| 3d | Change shading and borders | 2 | ||
| 3e | Format currency and percentages | 3 | ||
| 4 | Professional Appearance (Cleanup) | |||
| 4a | Tab color and names | 4 | ||
| 4b | Hide columns D-M | 4 | ||
| 4c | Custom header: Professor Names and Student Name | 5 | ||
| 4d | Page orientation | 3 | ||
| Comment: What you learned from completing this Lab | 5 | |||
| TOTAL POINTS | 60 | 0 | ||