Use excel to answer. Show all work.

Beachfront Guest House Effective May 1, 2016 Peak Rentals Off-Peak Rentals Rental Type No. Units Per Day Maximum | Per Day Maximum | Discount Rate Studio Apartment 6 149.95 112.5 1 Bedroom Suite 4 250.45 174 2 Bedroom Suite 2 450 247.55 Questions & Answers Assume all 12 units are rented as you answer the following questions: (1) Which rental type generates the most maximum revenue for peak rental periods? (2) Which rental type generates the most maximum revenue for off-peak rental periods? (3) Why is there a difference? (4) How much would the 2 Bedroom Suite Off-Peak per day rate need to be to have the same off-peak maximum revenue as the 1 Bedroom Suite?Royalty Statement Period Ending: Author: Jacobs Hardback Paperback Units Sold Gross Units Sold 1500 12492 No. of Returns 324 200 Percent Returned Pricing Retail Price 25 5.95 Price to Bookstore Net Retail Sales Royalty Information Royalty Rates D.0725 0.1 Royalty to Author Royalty per BookJ. Heaton Realty Sales Report Property Days on Market Date Listed Date Sold List Price Sold Price : of List Price 125 Amsterdam Drive 2016-01-12 350000 335000 341 North Oak Drive 2015-11-15 500250 400125 50 Macaw Crescent 2015-12-03 650725 500750 386 East Elm Street 2016-03-01 122 Saline Creek Way 2016-03-14 315000 325000 41 Chestnut Circle 2016-02-22 423500 420750 973 East Mulberry Lane 2015-11-30 375000 375000 538 North Oak Drive 2015-10-04 475000 400000 64 Chancellor Estates 2016-04-01 500999 495000A B C D E G H K Excel Formulas and Order of Precedence Date Created: Student Name Input Area: Output Area: First Value Sum of 1st and 2nd values Second Vali Difference between 4th and 1st values Third Value 3 Product of 2nd and 3rd values Fourth Valu A Quotient of 3rd and 1st values 2nd value to the power of 3rd value 1st value added to product of 2nd and 4th values and difference between sum and 3rd value Product of sum of 1st and 2nd anddifference between 4th and 3rd values Product of 1st and 2nd added toproduct of 3rd and 4th valuesDowntown Theatre Ticket Sales by Seating Section Section Available Se Seats Sold Percentage Percentage Unsold Balcony 106 84 Box Seats 25 12 Front Floor 120 114 Tier 1 40 40 Mezzanine 144 138A B C D E F G H Ashley's Tip Distribution Tuesday, March 1, 2016 11:00 a.m. - 1:30 p.m. Customer Subtotal and Tip Tip Rates Tip Amounts Customer Food Drinks Tip Left Total Recei Bartender Assistant Bartender Assistant My Net Tip 1 35 6.75 6 IN 42.5 8.45 10 3 100.18 10.25 25 38.75 6.75 7 5 51.37 8.45 12 6 16.25 5.25 3.5 7 12.95 6.75 4 65.81 8.45 14 9 112.45 25.25 30 10 35.13 6.75 9 11 62.1 12.95 14 12 84.34 12.95 20 13 12.25 2 14 25.45 6.75 5.5 15 75.12 13.5 20 16 40.44 10.25 8.85 17 13.87 0 2 18 24.75 3.5 6 19 67.33 9.75 15 20 42.44 6.75 12 Notes: (1) The bartender gets a 15%% tip based on the total drink order for each customer. (2) The server assistant gets 10%% of the total tip left by the customer.A B C D E F G NP Input Area Output Area Sale Price $ 300,000.00 Sale Price $ 300,000.00 LU Realtor Commision Rate 6%% Commission $ 300,000.06 Closing Costs Rate 7% Closing Costs 18,000.00 5 Annual Property Taxes $ 2,000.00 Title Policy Insurance 950.00 6 Months to Prorate Taxes 6 Prorated Property Taxes 12,000.00 7 Months in a Year 12 Est Existing Mortgage Payoff 100000 Est Existing Mortgage Payoff $ 100,000.00 Total Est Deductions 430,950.06 9 Estimated Net Proceeds $ 730,950.06 10 11 12 13 14 15 16 17