Painted Paradise Resort & Spa Expansions to Business Conventions Assignment: Excel Answers 2021

Painted Paradise Resort & Spa Expansions to Business Conventions Assignment: Excel Answers 2021

Question Title:

Painted Paradise Resort & Spa Expansions to Business Conventions Assignment

Full Question:

Unformatted Attachment Preview

BusinessID,Name,StreetAddress,City,State
1001,Barry?s Pet Place,808 JAYME CIRCLE ,Santa Fe,AZ
1002,Electronic Wholesalers,7538 QUEENS VIEW DRIVE ,Prescott Valley,NM
1003,Online Auctions Inc.,1818 SCALERO STREET ,Rio Rancho,AZ
1004,Eccletic Books,2920 MARINER AVENUE ,Clovis,AZ
1005,Boxes and More,5629 OLSON CIRCLE ,Prescott Valley,NM
1006,Golf Supplies Unlimited,5840 RICKY PLACE ,Los Alamos,AZ
1007,Printing Services Plus,2217 RAINBOW DRIVE ,Goodyear,AZ
1008,Computer Accessories Etc,362 SCHOON PLACE ,Mammoth,AZ
1009,Mobile Computing Specialists,7770 LINDEN DRIVE ,Safford[b],AZ
1010,Movie House Posters,6033 BRIDGET PLACE ,Los Lunas,NM
Painted Paradise Resort & Spa
Loan Analysis
$350,000
5
6.00%
$20,000
$6,379.82
4.50%
Down Payment
Loan Amount
Term (Years)
Interest Rate
Down Payment
Monthly Payment
$
$
$
$
$
$
20,000.00
25,000.00
30,000.00
35,000.00
40,000.00
45,000.00
20190502025932e05_grader_a1_hotelexpansion_alshammarymohammed.xlsx
5.00%
Interest Rates
5.50%
6.00%
6.50%
7.00%
Painted Paradise Resort & Spa
Solver for Room Scheduling
Revenue
Room
The Muisca Room
The Eldorado Room
The Pueblo Room
New Room 1
New Room 2
Capacity
500
100
25
250
125
Expenses
Fixed Costs
Utilities
Room Maintenance
Total Fixed Costs
$
$
$
250.00
150.00
400.00
Variable Costs
Staff Salaries per event $ 500.00
Total Variable Costs
$ 7,000.00
Total Expenses
$ 7,400.00
Net Income
#########
Saved Solver Models
Price
Events per Month
$ 22,500.00
3
$ 1,500.00
1
$ 1,125.00
3
$ 18,750.00
5
$ 3,750.00
2
$ 47,625.00
Create Date
By Whom
mm/dd/yyyy Firstname Lastname
Mod. Date
By Whom
Description
Create Date
Creator
Sheet Name
Mod. Description
20190502025932e05_grader_a1_hotelexpansion_alshammarymohammed.xlsx
Workbook Name
e05HotelExpansion.xlsx
Last Version Backup Name
Purpose
20190502025932e05_grader_a1_hotelexpansion_alshammarymohammed.xlsx
20190502025932e05_grader_a1_hotelexpansion_alshammarymohammed.xlsx
Office 2016 ? myitlab:grader ? Instructions
Excel Project
YO16_XL_BU05_GRADER_PS3_AS ? Hotel Conventions 1.3
Project Description:
The hotel at the Painted Paradise Resort and Spa is looking to expand its ability to hold business conventions.
You have been asked to help in a variety of ways. First, a list of businesses has been provided to you as a
comma-delimited text file. You will need to import this data into and Excel workbook so that these businesses can
be contacted later. Second, Painted Paradise is considering taking out a loan to pay for the construction of new
meeting spaces for business conventions. You have been asked to help develop a loan analysis for this project.
Lastly, the new meeting spaces will add to the three rooms already available to the hotel. You have been asked
to develop a Solver model to help determine the optimal number of events that should be scheduled in each
room in order to maximize profit. You have been told that the Eldorado Room currently has two regularly
occurring meetings per month.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Instructions
Points
Possible
1
Start Excel. Open the downloaded workbook named e05_grader_a1_HotelExpansion.xlsx. Save
the file with the name e05_grader_a1_HotelExpansion_LastFirst, using your last and
first name. If necessary, enable the content.
0.000
2
Import the data from the comma-delimited text file e05Businesses.txt into cell A1 of the
Sheet1 worksheet. Rename the sheet NewBusinesses.
10.000
3
Use the Convert Text to Columns Wizard to separate the data into columns. Use cell B1 for the
destination of the data. AutoFit the column widths.
10.000
4
On the LoanAnalysis worksheet, in cell E4, reference the monthly payment calculation in cell
B7.
8.000
5
Create a two-variable data table using the range E4:K10. Use the interest rate as the row
input for the data table. Use the down payment for the column input for the data table.
10.000
6
Format the data in cells F5:K10 as Currency. Use conditional formatting to apply a Red-YellowGreen color scale to the data.
10.000
7
The Painted Paradise Resort and Spa is considering adding two new meeting rooms, which
have yet to be named. One room will hold 250 people, while the other will hold 125. The
RoomScheduling worksheet contains a model that describes the pricing model for scheduling
conference meeting rooms. Begin to create a Solver model that will help Painted Paradise
maximize their profit by scheduling events. Use the Net Income in cell C24 as the Set
Objective cell.
7.000
8
Use the Events per Month in cells E5:E9 as the By Changing Variable Cells box.
7.000
Updated: 10/15/2017
1
Current_Instruction.docx
Office 2016 ? myitlab:grader ? Instructions
Step
9
10
11
12
Excel Project
Points
Possible
Instructions
Add a constraint that limits the number of events in each room per month to

Purchase answer to see full
attachment

This question was handled by a Studyhelp247 Excel tutor and the student left a positive review. 19+ custom answers have been given to students for this question in October 2021 alone. To avoid plagiarism and maintain student privacy, we do not resell answers. Get your custom solution now. It is affordable.

Bram Eldoff, Founder, Studyhelp247.com

Consider this Excel Assignment Done
Beat its deadline and stringent requirements.

[advanced_iframe securitykey=?your key? use_shortcode_attributes_only=?true? src=?https://core.studyhelp247.com/main-site-question-post/? id=?example4? height=?350? width=?450? show_part_of_iframe=?true? show_part_of_iframe_x=?-100? show_part_of_iframe_y=?75? show_part_of_iframe_width=?450? show_part_of_iframe_height=?350? show_part_of_iframe_new_window=?_top? show_part_of_iframe_new_url=?https://core.studyhelp247.com/new-question-posting/?]

>Approximate cost: $8 per page.
>Choose your own tutor.
>Get free revision, plagiarism reports, and a list of sources.
>Release the money only after delivery

How it Works

hw

Why you should post this Excel question now.

Flawless Deliveries
Our tutors deliver fault free assignments after careful and detailed research. All instructions are followed to the letter.

100% Originality Guarantee
Every task delivered to students on our platform has 100% originality guarantee. Find plagiarism, get 100% money back.

Timely Deliveries
When you post a question here, we assure on-time delivery, or 100% money back. You cannot miss deadlines with us.

24/7 Customer Support
Our support agents are always online, ready to help you when using our platform. It only gets better.

Student-Friendly Prices
Getting quality help should not break your pocket. Find instant quality help for whatever budget you have.

Free Revisions
You can request your tutor for as many revisions as needed to ensure you are 100% satisfied with our services.

100% Privacy
Every action you take on our platform is anonymous. Once you receive your help, it is almost as if you weren?t here.

100% Refunds
If a tutor breaks any of our guarantees, you get 100% money back to ask questions in the future. No questions.

Here are other questions on different subjects that our tutors have handled with excellent results.

The first ones are ULC 148 SUNY Buffalo State College Values of the Trigonometric Functions Questions and University of New Haven Determination of a Chemical Formula Lab Report which required in-depth research and computations. The third and fourth ones are Painted Paradise Resort & Spa Expansions to Business Conventions Assignment and Grossmont College Identify and Express Your Self Concept Essay, which called for experts to help with online quizzes. All these were answered for students who were looking for study assistants for homework help 2021

Reviews from Students; Verified by Trustalyze

Studyhelp247 Exceeded my expectations.

Rated 5 out of 5
3 years ago

I believe in studyhelp247 now. Here, I found the best tutor to assist me with a complex math task. It was seamless using the site.

Avatar for SdfDsf
SdfDsf

Response from Studyhelp247

Thank you for using our platform to find academic help. We are happy that you found what you were looking for.

By far, the best source of affordable custom writing solutions.

Rated 5 out of 5
3 years ago

I came to studyhelp247 after seeing an ad and they have been great. It is quite affordable owing to the fact that there are no service fee charges.

Avatar for Student01
Student01

Response from Studyhelp247

Thank you for the great review. We are committed to providing the best platform to foster student excellennce. 🙂

Very responsive support

Rated 5 out of 5
3 years ago

I have enjoyed using studyhelp247. The support was very responsive and I received quality work

Avatar for Alsalem
Alsalem

Response from Studyhelp247

Thank you.
Our support agents are always available to assist you with any issue.

Great work done for me by Anastacia.

Rated 5 out of 5
3 years ago

Thank you for the great work that you delivered. I will be back for more. 🙂

Avatar for Elsie
Elsie

Response from Studyhelp247

Thank you for using our site.