Week 1 to Week 7 iLab All Exercises Bundled:
BIS 155 Week 1 iLab | Summit Ridge Mountain Resort
Workbook on Mountain Sports Village Shop Sales to Data
BIS 155 Week 2 iLab | Summit Ridge Mountain Resort
Workbook on Mountain Sports Village Shop Sales to Data.
BIS 155 Week 3 iLab | Summit Ridge Mountain Resort
Analyze the claim made by the Condos at Summit Ridge Mountain.
BIS 155 Week 4 iLab | Summit Ridge Mountain Resort
Warming Hut Income, Seasonal Activities and X Games.
BIS 155 Week ..
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 re..
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..
Analyze the claim made by the Condos at Summit Ridge Mountain.
Description
Scenario/Summary
You are becoming more confident in your new position at
Summit Ridge Mountain Resort. You are still meeting new coworkers and slowly
but surely being asked to use more of your Excel skills for different
departments at the resort. The manager handling sales for all of the condos in
the Summit Ridge Mountain Village needs some help with his sales analysis. This
report needs to clearly list and summarize ..
Warming Hut Income, Seasonal Activities and X Games
Description
Scenario/Summary
Summit Ridge Mountain Resort has three full-service warming huts on its majestic mountains.
The Summit View, the Bunny Den, and the Mogul Hill Samurai warming huts are rest stops that provide skiing customers a
place to relax, eat, and warm up. At the end of the month, the manager of each warming hut prepares a worksheet that summarizes
the monthly income.
Please note that during the summer months,..
Detailed analysis concerning Stay A While Longer Apartments
Description
Scenario/Summary
Summit Ridge Mountain Resorts has decided to expand. Because of the popularity of the resort among the business community and families, Summit Ridge has decided to purchase some apartments for guests and seasonal employees to have an extended stay. Because these will prove to be a long-term investment, Summit Ridge has decided to put all complexes on a remodeling rotation to ensure the apartments each h..
SRMR Income Statement Variables and Warming Hut Sales - changes in Condominium Rental Fees, Ski Lift Tickets, and X Game Tickets and Pricing.
Description
Scenario/Summary
This week it seems like everyone needs an answer to a question. The Accounting Manager for Operations has asked you to update some analysis prepared earlier in the year. In an attempt to predict year-end changes in net income, you have been asked to prepare some reports on changes in condominium rental fees, ski lift ticke..
Week 6 iLab 7 - Analysis of a Business Scenario and Do 3 Different Types of Analysis on a Memo Template
Description
Scenario/Summary
The
purpose of this exercise is to use the Excel skills you have acquired thus far,
and apply them to an analysis of a business scenario, of your choice. This will
consist of preparing the groundwork in Excel (importing data, preparing the
analysis using tables, charts, graphs, pivot tables, etc.) and preparing a memo
to your management, explaining your thre..
Utilizing "expert" features in Excel such as text importing (outstanding condo sales results for Jesse Gonzales), cell protection and macro generation (X Game Calculator).
Description
Scenario/Summary
Your manager could not be happier with the help you’ve provided to all of those departments requesting Excel assistance within the resort. He is now very confident handing over complex tasks to your capable hands. This week he is requesting that you exercise some expert skills. It seems he h..