Problem 12-07

Hi can you please help me solve this using Excel? Thanks!

Example of drop downs

regular customers/Friday night only; and regular customers/Saturday night only. The cost for each type of reservation is shown here. The anticipated demand for each type of reservation is as follows: Hanson Inn would like to determine how many rooms to make available for each type of reservation in order to maximize total revenue. a. Define the decision variables and state the objective function. Let CT= number of convention two-night rooms CF= number of convention Friday only rooms CS= number of convention Saturday only rooms RT= number of regular two-night rooms RF= number of regular Friday only rooms RS= number of regular Saturday only room b. Formulate a linear programming model for this revenue management application. CT+ZF+CS+ S.T. 1) 2) 3) 4) 5) 6) 7) 8) CT+ 9) T + 10) CT + CF CF+ CS + c. What is the optimal allocation and the anticipated total revenue? amming model for this revenue management application. CT+CF+CS+2RT+2RF+RS2 Vhat is the optimal allocation and the anticipated total rev