BIS 155 WEEK 6 LAB 6 LATEST-DEVRY
Visit Below Link, To Download This Course:
BIS 155 Week 6 Lab 6 Latest-DeVry
BIS155
BIS 155 Week 6 Lab 6 Latest-DeVry
Lab Overview
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 tickets, and X Game tickets and pricing.
The Sales Department for Luxury Condominiums wants to know how
increasing their rental pricing by varying percentages will affect the existing
pricing. The manager would like to know how that will increase the Summit Ridge
Mountain Resort’s total revenue. A one-variable data table might be good to
create these results.
The supervisor in charge of setting prices for lift tickets
also needs some help. She wants to price the lift tickets so that they are
affordable but yet offer the resort a chance to improve its net income at the
end of the season. A one-variable data table might be able to answer this
question.
Resort Management has a target income for the X Games.They need help determining the best combination of pricing and quantity of
tickets to sell for the X Games to be a success. A two-variable data table
might be best to display these results.
And there are more puzzling questions. Resort Management has
reviewed variables such as lift ticket prices, restaurant revenues, retail
revenues, maintenance costs, and payroll. They would like you to create a
Scenario Summary to determine optimistic, mid-range, and pessimistic scenarios
for the resort. The Operations Manager would like to know how these changes
might affect revenue, expenses, and net income. A Scenario Summary would
be a good choice for this analysis.
Last, all of the Warming Hut Management need a little help with
some investigation on their data. They have quite a bit of data collected but
need some assistance making sense of it. It may be time to polish your skills
with Pivot Tables, because the management has many questions and concerns. Your
boss is confident about your ability to be creative and customize some
Pivot Tables that are unique to each Hut.
What-If questions need solid answers. It is time to provide
a professional response.
Deliverables
NOTE
Submit your assignment to the Dropbox, located at the top of
this page. For instructions on how to use the Dropbox, read these step-by-step instructions.
(See the Syllabus section “Due Dates for Assignments &
Exams” for due dates.)
After completing the steps below, turn in one Excel 2016
workbook. Rename the workbook with your lastname_first initial_Week6_Lab. xlsx.
Example: If your name were Jane Doe, your workbook would be
Doe_J_Week6_Lab.xlsx.
Comments
Post a Comment