Pls use excel, and explain each step on how to use excel to solve this problem. Also provided a table below to show how to set up what i need on excel thank you God bless

$\backslash$table$[[,D,m,$Price,Quantity Sold,Occupancy,Demand,Revenue,Capacity$],[$Monday$,390,-1\mathrm{.}5,,,,,,450],[$Tuesday$,540,-1\mathrm{.}5,,,,,,450],[$Wednesday$,615,-1\mathrm{.}5,,,,,,450],[$Thursday$,630,-1\mathrm{.}5,,,,,,450],[$Friday$,330,-1\mathrm{.}5,,,,,,450],[$Saturday$,240,-1\mathrm{.}5,,,,,450,],[$Sunday$,270,-1\mathrm{.}5,,,,,450,],[$F$\_$SA$\_$SU$,900,-3,,,,,,],[$Total$,,,,,,,,],[$Occupancy ra$,,,,,,,,]]$

Class Problem for Network Management

The Hotel Deluxe has $450$ rooms and offers a fixed daily rate of $$100,$ good for any night of the week. That price, current average demands, and estimated demand curves for the various days of the week are reflected in the following table:

$\backslash$table$[[$Day$,$Price,$\backslash$table$[[$Average$],[$Demand$]],$Approximate Demand Curve$],[$Monday$,$$$100,240,$Quantity $=390-1\mathrm{.}5$ Price$],[$Tuesday$,$$$100,390,$Quantity $=540-1\mathrm{.}5$ Price$],[$Wednesday$,$$$100,465,$Quantity $=615-1\mathrm{.}5$ Price$],[$Thursday$,$$$100,480,$Quantity $=630-1\mathrm{.}5$ Price$],[$Friday$,$$$100,180,$Quantity $=330-1\mathrm{.}5$ Price$],[$Saturday$,$$$100,90,$Quantity $=240-1\mathrm{.}5$ Price$],[$Sunday$,$$$100,120,$Quantity $=270-1\mathrm{.}5$ Price$]]$

As you can see from this table, the hotel typically fills up on Wednesday and Thursday nights under the current pricing policy, and some demand is typically turned away on those nights as well, whereas there are typically rooms left empty on other nights, and the average occupancy rate is only $20\%$ on Saturdays. The overall average occupancy rate is about $60\%.($Remember that some demand is turned away on Wednesdays and Thursdays.$)$

Not surprisingly, management has ordered a comprehensive review of the current pricing policy, including the introduction of a weekend dClass Problem for Network Management

The Hotel Deluxe has $450$ rooms and offers a fixed daily rate of $$100,$ good for any night of the week. That price, current average demands, and estimated demand curves for the various days of the week are reflected in the following table:

$\backslash$table$[[$Day$,$Price,$\backslash$table$[[$Average$],[$Demand$]],$Approximate Demand Curve$],[$Monday$,$$$100,240,$Quantity $=390-1\mathrm{.}5$ Price$],[$Tuesday$,$$$100,390,$Quantity $=540-1\mathrm{.}5$ Price$],[$Wednesday$,$$$100,465,$Quantity $=615-1\mathrm{.}5$ Price$],[$Thursday$,$$$100,480,$Quantity $=630-1\mathrm{.}5$ Price$],[$Friday$,$$$100,180,$Quantity $=330-1\mathrm{.}5$ Price$],[$Saturday$,$$$100,90,$Quantity $=240-1\mathrm{.}5$ Price$],[$Sunday$,$$$100,120,$Quantity $=270-1\mathrm{.}5$ Price$]]$

As you can see from this table, the hotel typically fills up on Wednesday and Thursday nights under the current pricing policy, and some demand is typically turned away on those nights as well, whereas there are typically rooms left empty on other nights, and the average occupancy rate is only $20\%$ on Saturdays. The overall average occupancy rate is about $60\%.($Remember that some demand is turned away on Wednesdays and Thursdays.$)$

Not surprisingly, management has ordered a comprehensive review of the current pricing policy, including the introduction of a weekend discount rate for patrons staying three nights $($Friday through Sunday$).$ The hotel will therefore offer eight distinct "products" for any given week seven one$-$night products, and one three$-$night product. Market demand for the new multi$-$night product has been estimated as follows:

Weekend Discount Package

Quantity $=900-3\mathrm{.}0$ Price

$($a$)$ If obliged to charge a common rate for all one$-$day stays, regardless of the specific day of the week, but free to offer lower average daily rates for the multi$-$day package, what prices do you recommend?

$($b$)$ If you are free to charge different rates for one$-$day stays on different days of the week $($that is$,$ if the prohibition against variable pricing is lifted$),$ now what prices do you recommend? How much does the lifting of the prohibition increase average weekly revenue?