Please help me with these using excel.

6. Scott Haner is the general manager at the City Center Hra 500.com franchised hocheating Sliema options regarding the allocation of 100 unsold guest rooms for the third weekend of next month. His property group mom ales department believes (but is not positive that it can sell 80 group room for that date at a rate of $16500 per room. The hotel POM believes that if the 100 rooms are listed on the Deals This Hotel" pove of the franchisor operated website, with a 10% discount of the hotel'normal $99999 rack, room could sell through the franchisor CRS website. The wale would apply only to buyers willing to agree that the room would be billed to the guests at the time of purchase and could not be cancelled. Uberhothotels.com, a third party Internet sales site operator la willing to pay the hotel $160.00 for each room it purchases but wants a commitment from the hotel that it would be able to buy and then resell up to 100 room. I believes that it can do so if it lists the rooms as open to all buyers and at a rate of $179.99 per night (plus its estimated txes and its service fees). Scott already lus 200 rooms sold for this specific night at the hotel's rack rate. He has summarised the information about his various sales options below. Scott's Saturday Night 300 200 Estimated on Sales Rooms mailable Remonty served Chummel Group sales CRS sale (20% discount of ac rate) Third party merchant HO 50 Estimated ADR $165.00 $13.99 100 $160.00 Asume that each distribution channel produces as projected. Complete Scott's RPAR estimate worksheet and answer the questions that follow RevPAR Estimate Worksheet: City Center Planta Prepared By Scott Distribution Channel Group Sales CRS Sale Third-Party Merchant Previou Book Revenue 200 $9.99 $15.99 $15.95 $25.99 ( 330 Chapter 8 Revenue Management for Hotels (Ca) Distribution Channel Estimate Channel Rem Contributi Total Rex R Group Sales CRS Sale Third Party Merchant Tal Ros Sold ADR RPAR Based upon his last estimates of each channel's performance, which chand would produce the highest ADR Mased upon his best estimates of each channel's performance, which channel would produce the lowest ADR2 ad upon his bestemte of each channel's performance, which can weld generate the highest