Really struggling with setting up Excel Solver and all the constraints for these questions. Can you also please provide an actual excel spreadsheet with your findings and the equations on how to solve the problems below. $$Hotel Room Pricing A hotel has $500$rooms$.$ During a typical week in the holiday season, the hotel is busy on Monday, Tuesday, Wednesday, and Thursday nights, primarily with business people, but there is generally space available on Friday, Saturday, and Sunday nights. Hotel management provided the following demand estimates, as shown in Table $8\mathrm{.}1$: Assume linear demand demands. functions over the range of all non$-$negative room rates and demands. Room Rate Days Estimated Demand $$160$ Mon, Tue, Wed, Thur $500$ Fri, Sat, Sun $200$ $$175$ Mon, Tue, Wed, Thur $350$ Fri, Sat, Sun $125$ Assignment $1.$ What is the revenue$-$maximizing room rate if the hotel posts only a single rate good for any day of the week? What weekly occupancy results? $2.$ What are the revenue$-$maximizing room rates if the hotel posts a "mid$-$week" rate good for the peak demand period $($MTWT$),$and a different "weekend" rate good for Friday, Saturday, or Sunday. What is the new weekly occupancy? What is the revenue increase? $3.$ Another option is for the hotel to offer a discounted weekly rate in order to attract vacationers who will stay for the full week. Management estimates that demand will be $40$per week at $$900/$week and $160$per week at $$800/$week$.$Again assume a linear demand curve. $4.$ If the hotel posts a weekly rate and a single daily rate $($good for any night$),$what are the revenue$-$maximizing prices? What is the occupancy rate? What is the revenue gain? $5.$ If the hotel posts three rates: a mid$-$week rate, a weekend rate, and a weekly rate, what are the revenue$-$maximizing prices? What is the occupancy rate? What is the revenue gain?