Please answer ALL sections of the chart on Excel. I need the formulas for EACH section.

3. Pada Al Majeed is the general manager at the 125-room select-service Harley House Inn. She also serves as the property's revenue manager. The property primarily serves business travelers and is quite busy Monday through Thursday nights. The property is less busy on the weekends. Fadwa has just taken a call from Lawrence, a friend and the revenue manager at a hotel within her comp set. Because of an internal oversight, Lawrence's hotel is overbooked by 70 group rooms next Saturday. Lawrence would like to purchase that number of rooms from Fadwa at their previously agreed upon walk rate of $75.00 per night. Fadwa's normal ADR is $129.00 and her cost of cleaning a room is $17.00. Currently, Fadwa has 55 occupied rooms (arrivals and stayovers) on the books for that day. She forecast that she could sell, at her normal ADR, another 30 rooms by Saturday. Fadwa typically generates $8.00 in ancillary revenue from each of her occupied rooms. Before replying to Lawrence's request, she summarized her forecasted rooms salesrelated information in a chart so she could better understand the impact of accepting or rejecting Lawrence's walked guests Help Fadwa assess the potential impact on her hotel of agreeing to Lawrence's request and then answer the ques tions that follow Harley House Hotel Saturday Forecast Total rooms available for ale Current rooms sold forecast Additional rooms to be sold forecast Walk rooms requested Normal ADR Walk rooms ADR Ancillary revenue per room Room cleaning cost 125 55 30 20 $129.00 $75.00 $8.00 $17.00 Fadwa's Source of Business Calculation With Lawrence Walks Without Lawrence Walks $129.00 Next Saturday Night Rooms Sold ADR Total Rooms Revenue Estimate Daily per Room Ancillary Rescue Total Rooms plus Ancillary Reven RePOR Home Dept Cot POR Net Tool Rev SHOO 58.00 2. What would be adva's ADR if she accepted all of Lawrence's kedroom . What would be adva's RePOR the walked room What would be ada's ResPOR the walked rooms d. What would be the net totale RePOR-Room det con POR) diference in her hotels gree to take the room What would be the percentage of difference behouettes adhaee to take the were would you see the walked romance he way or