Hi! I do not understand the beginning of this assignment at all. If someone could just answer question 2 and 3, I would greatly appreciate it!

AutoSave OFF W YO19_Excel_BU05_Assessment2_Hotel_Conventions_Instructions - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Table Design Layout Tell me Share Comments Arial "AI Aa to AJ AaBbDae AaBbCcDdEe v AaBb CcD AaBbCcDdE Heading 1 Heading 2 Paste B I Uab X, X ADA Emphasis Normal Dictate Styles Pane Sensitivity Project Description: The hotel at the Painted Paradise Resort & Spa wants 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 an 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. Steps to Perform: Step Instructions Points Possible 1 0 Start Excel. Open the downloaded file named Excel_BU05_A2_HotelConventions.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 2 0 A list of businesses has been provided in a text file. These businesses need to be contacted but first the data needs to be imported into Excel and transformed. Establish a connection to the text file Excel BUO5_A2_Businesses.txt. 3 6.4 The City/State data is organized with the city name, then the state abbreviation. For example, Prescott Valley NM where Prescott Valley is the city and NM is the state. Split the City/State column into two individual columns, City and State. Remove the City/State field, if necessary 4 Close & Load the data to cell A1 of the NewBusinesses worksheet. 1.6 5 3.2 You have been asked to create a two-variable data table that analyzes the changes in monthly payments as the hotel considers different interest rates and down payments. On the LoanAnalysis worksheet, in cell E4, reference the monthly payment calculation in cell B7 6 4 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. Page 1 of 2 587 words English (United States) O Focus ES + 139% Name BusinessID StreetAddress City/State 1001 Computer Accessories Etc 362 SCHOON PLACE Mammoth-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 1085 Boxes and More 5629 OLSON CIRCLE Prescott Valley-NM 1006 Movie House Posters 6033 BRIDGET PLACE Los Lunas- NM 1007 Printing Services Plus 2217 RAINBOW DRIVE Goodyear-AZ 1008 Barry's Pet Place 808 JAYME CIRCLE Santa Fe-AZ 1009 Mobile Computing Specialists 7770 LINDEN DRIVE Safford-AZ 1010 Golf Supplies Unlimited 5840 RICKY PLACE Los Alamos- AZ AutoSave OFF BESU Excel BU05 A2 Hotel Conventions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments X Calibri (Body) ' Insert v 11 v Conditional Formatting Text IM WE 28 O 3 Format as Table DX Delete v Paste B I U A $ % ) .00 0 * Ideas 00 Sensitivity Cell Styles Sort & Filter E Format Find & Select A1 fx B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 NewBusinesses Loan Analysis RoomScheduling Documentation + 1 + 100% AutoSave OFF HESU- Excel_BU05 A2 Hotel Conventions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments X Calibri (Body) . AF ab Insert v 14 Conditional Formatting v V Text 4Y -O WE INS 3 Format as Table Paste B A I U $ % ) DX Delete v Hi Format .00 0 V Ideas 00 Sort & Filter Sensitivity Cell Styles Find & Select A1 fx Painted Paradise Resort & Spa A F G H 1 L M N o P Q Q R S s T U B D E Painted Paradise Resort & Spa Loan Analysis $375,000 Interest Rates 6.00% 6 5.00% 5.50% 6.50% 7.0096 7.50% 6.50% $25,000 $5,883.48 in Payment $ $ $ $ $ 20,000.00 25,000.00 30,000.00 35,000.00 40,000.00 45,000.00 $ 1 2 3 Loan Amount 4 Term (Years) 5 Interest Rate 6 6 Down Payment 7 Monthly Payment 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 NewBusinesses LoanAnalysis RoomScheduling Documentation + 1 + 100% AutoSave OFF HESU- Excel BU05 A2_HotelConventions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments X Calibri (Body) Insert v v 11 Conditional Formatting . General Ayu Oy 3 WE INS Format as Table v Paste B I U A $ % ) DX Delete v Hi Format .00 0 * Ideas Sensitivity 00 Sort & Filter Cell Styles Find & Select F11 fx B D E F G H 1 1 J j K L L M M N o P Q Q R 1 Painted Paradise Resort & Spa Solver for Room Scheduling 2 3 Revenue 4 Capacity 5 6 Room The Muisca Room The Eldorado Room The Pueblo Room New Room 1 New Room 2 Price 500 $ 100 $ 25 $ 250 $ 125 $ $ 7 Events per Month 1 1 1 1 1 7,500.00 1,500.00 375.00 3,750.00 1,875.00 15,000.00 8 9 Utilities Room Maintenance $ $ $ 280.00 170.00 450.00 10 11 12 Expenses 13 Fixed Costs 14 15 16 Total Fixed Costs 17 18 Variable Costs 19 20 Total Variable Costs 21 22 Total Expenses 23 Staff Salaries per event $ $ 550.00 2.750.00 $ 3,200.00 $ 11,800.00 24 Net Income 25 26 Saved Solver Models 27 28 29 30 31 32 33 34 35 36 NewBusinesses LoanAnalysis RoomScheduling Documentation + 1 + 100% AutoSave OFF HESU- Excel_BU05 A2 Hotel Conventions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments X Calibri (Body) "Ai Insert v v 11 Date Conditional Formatting Format as Table Cell Styles WE Ayu Oy 3 Paste B I U . * DX Delete v Hi Format $ % ) .00 20 Ideas Sensitivity ES E 00 Sort & Filter Find & Select A6 . X fx mm/dd/yyyy A B D E F G H H 1 K L M Painted Paradise 1 2 3 RESORT & SPA 4 5 Create Date By Whom 6 mm/dd/yyyy.Firstname Lastname 7 Mod. Date By Whom 8 9 Description Workbook Name e05 HotelExpansion.xlsx Last Version Backup Name Mod. Description 10 11 Sheet Name Creator Purpose 12 13 14 15 16 17 18 19 Create Date 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 NewBusinesses LoanAnalysis RoomScheduling Documentation + 1 W + 100% AutoSave OFF W YO19_Excel_BU05_Assessment2_Hotel_Conventions_Instructions - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Table Design Layout Tell me Share Comments Arial "AI Aa to AJ AaBbDae AaBbCcDdEe v AaBb CcD AaBbCcDdE Heading 1 Heading 2 Paste B I Uab X, X ADA Emphasis Normal Dictate Styles Pane Sensitivity Project Description: The hotel at the Painted Paradise Resort & Spa wants 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 an 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. Steps to Perform: Step Instructions Points Possible 1 0 Start Excel. Open the downloaded file named Excel_BU05_A2_HotelConventions.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 2 0 A list of businesses has been provided in a text file. These businesses need to be contacted but first the data needs to be imported into Excel and transformed. Establish a connection to the text file Excel BUO5_A2_Businesses.txt. 3 6.4 The City/State data is organized with the city name, then the state abbreviation. For example, Prescott Valley NM where Prescott Valley is the city and NM is the state. Split the City/State column into two individual columns, City and State. Remove the City/State field, if necessary 4 Close & Load the data to cell A1 of the NewBusinesses worksheet. 1.6 5 3.2 You have been asked to create a two-variable data table that analyzes the changes in monthly payments as the hotel considers different interest rates and down payments. On the LoanAnalysis worksheet, in cell E4, reference the monthly payment calculation in cell B7 6 4 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. Page 1 of 2 587 words English (United States) O Focus ES + 139% Name BusinessID StreetAddress City/State 1001 Computer Accessories Etc 362 SCHOON PLACE Mammoth-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 1085 Boxes and More 5629 OLSON CIRCLE Prescott Valley-NM 1006 Movie House Posters 6033 BRIDGET PLACE Los Lunas- NM 1007 Printing Services Plus 2217 RAINBOW DRIVE Goodyear-AZ 1008 Barry's Pet Place 808 JAYME CIRCLE Santa Fe-AZ 1009 Mobile Computing Specialists 7770 LINDEN DRIVE Safford-AZ 1010 Golf Supplies Unlimited 5840 RICKY PLACE Los Alamos- AZ AutoSave OFF BESU Excel BU05 A2 Hotel Conventions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments X Calibri (Body) ' Insert v 11 v Conditional Formatting Text IM WE 28 O 3 Format as Table DX Delete v Paste B I U A $ % ) .00 0 * Ideas 00 Sensitivity Cell Styles Sort & Filter E Format Find & Select A1 fx B C 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 NewBusinesses Loan Analysis RoomScheduling Documentation + 1 + 100% AutoSave OFF HESU- Excel_BU05 A2 Hotel Conventions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments X Calibri (Body) . AF ab Insert v 14 Conditional Formatting v V Text 4Y -O WE INS 3 Format as Table Paste B A I U $ % ) DX Delete v Hi Format .00 0 V Ideas 00 Sort & Filter Sensitivity Cell Styles Find & Select A1 fx Painted Paradise Resort & Spa A F G H 1 L M N o P Q Q R S s T U B D E Painted Paradise Resort & Spa Loan Analysis $375,000 Interest Rates 6.00% 6 5.00% 5.50% 6.50% 7.0096 7.50% 6.50% $25,000 $5,883.48 in Payment $ $ $ $ $ 20,000.00 25,000.00 30,000.00 35,000.00 40,000.00 45,000.00 $ 1 2 3 Loan Amount 4 Term (Years) 5 Interest Rate 6 6 Down Payment 7 Monthly Payment 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 NewBusinesses LoanAnalysis RoomScheduling Documentation + 1 + 100% AutoSave OFF HESU- Excel BU05 A2_HotelConventions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments X Calibri (Body) Insert v v 11 Conditional Formatting . General Ayu Oy 3 WE INS Format as Table v Paste B I U A $ % ) DX Delete v Hi Format .00 0 * Ideas Sensitivity 00 Sort & Filter Cell Styles Find & Select F11 fx B D E F G H 1 1 J j K L L M M N o P Q Q R 1 Painted Paradise Resort & Spa Solver for Room Scheduling 2 3 Revenue 4 Capacity 5 6 Room The Muisca Room The Eldorado Room The Pueblo Room New Room 1 New Room 2 Price 500 $ 100 $ 25 $ 250 $ 125 $ $ 7 Events per Month 1 1 1 1 1 7,500.00 1,500.00 375.00 3,750.00 1,875.00 15,000.00 8 9 Utilities Room Maintenance $ $ $ 280.00 170.00 450.00 10 11 12 Expenses 13 Fixed Costs 14 15 16 Total Fixed Costs 17 18 Variable Costs 19 20 Total Variable Costs 21 22 Total Expenses 23 Staff Salaries per event $ $ 550.00 2.750.00 $ 3,200.00 $ 11,800.00 24 Net Income 25 26 Saved Solver Models 27 28 29 30 31 32 33 34 35 36 NewBusinesses LoanAnalysis RoomScheduling Documentation + 1 + 100% AutoSave OFF HESU- Excel_BU05 A2 Hotel Conventions - Saved to my Mac Home Insert Draw Page Layout Formulas Data Review View Developer Tell me Share Comments X Calibri (Body) "Ai Insert v v 11 Date Conditional Formatting Format as Table Cell Styles WE Ayu Oy 3 Paste B I U . * DX Delete v Hi Format $ % ) .00 20 Ideas Sensitivity ES E 00 Sort & Filter Find & Select A6 . X fx mm/dd/yyyy A B D E F G H H 1 K L M Painted Paradise 1 2 3 RESORT & SPA 4 5 Create Date By Whom 6 mm/dd/yyyy.Firstname Lastname 7 Mod. Date By Whom 8 9 Description Workbook Name e05 HotelExpansion.xlsx Last Version Backup Name Mod. Description 10 11 Sheet Name Creator Purpose 12 13 14 15 16 17 18 19 Create Date 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 NewBusinesses LoanAnalysis RoomScheduling Documentation + 1 W + 100%