Description
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.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Here is the last one. As always, let me know if you have any questions.
BusinessID,Name,StreetAddress,City,State
BusinessID Name
1001,Barry's Pet Place,808 JAYME CIRCLE ,Santa Fe,AZ
1001 Barry's Pet Place
1002,Electronic Wholesalers,7538 QUEENS VIEW DRIVE ,Prescott Valley,NM 1002 Electronic Wholesalers
1003,Online Auctions Inc.,1818 SCALERO STREET ,Rio Rancho,AZ
1003 Online Auctions Inc.
1004,Eccletic Books,2920 MARINER AVENUE ,Clovis,AZ
1004 Eccletic Books
1005,Boxes and More,5629 OLSON CIRCLE ,Prescott Valley,NM
1005 Boxes and More
1006,Golf Supplies Unlimited,5840 RICKY PLACE ,Los Alamos,AZ
1006 Golf Supplies Unlimited
1007,Printing Services Plus,2217 RAINBOW DRI...