Question

Round Tree Manor is a hote th provides two types of room with three retai dames: Super Savec Deluxe, and Business. The profit per night for each type of room and rental cass is as Super Saver Dele Business Type 1 (Mountain View) $30 Type II (Street View) Round Tree's management makes a forecast of the demand by rental dlass for each night in the ture A linear programming model developed tomieois used to determine how many reservations to accept for each rertal dan The de forecast fr』particlar right is S0 in the Business class are the forecasted demands reservation for each rental class Round Tree has a imibed mumber of each type of room. Thee are 100 Type I rooms and 120 Type I rooms (a) Formulate and solve inew progam to dei how many reservations to accept in Super Saver rentals allocated to room type Super Saver rentals allocated to room type Deluxe rentals allocated to room type Deluxe rentals allocated to room type I Dusiness rentals allocated to room type 11 (b) For he solution in part (a) thow many reservations can be accommodated in each rentall Super Saver Business (c) with a little work, an unused ofice ata ต¡d be coveted to a rental room. lfthe conversion cost is the same for both types of rooms would you necommend converting the Type I Type It Shadom Price Convert an unused office arnea to-Select your room Explain The input in the box below will not be graded, but may be reviewed and considered by your instructor (d) Could the inear programming model be modffied to pian for the alocation of rental demand for the next night Select your answer

Answer 1

0 SWer ti ť r. .↑he type ợ 100m allo lied to different ental class ueted b iven informatton uo ype of ooms and divided in 1hree Clattes named a Profits fe, ight ィ0 each type of 100m and rental clas Typet rcom dont have in accek and GoHre- Can not be prdvidedo buiness clats Super 5aveo elux;, Businets ujiness Hormutation of inear Programmina Mode objectve funchon óubjeci o Yooms lental clats Capont

Solving formulation using Excel Solver as follows: Rental class (profit in S Super saver Deluxe Type of room 30 35 40 Rental class (Number) Super saver Delaxe Business 8 Type of room SUMB9.C9) -SUM(B10 D10) 100 120 10 SUM B9 B10) 12 13 130 60 50 15 Maximized profit (in S) -SUMPRODUCT B3:C4,B9 C10 (D4 D10

Solver Parameters Set Objective: SB$15 O Mio yalue O To: Max By Changing Variable Cells: SB$9 SCS10,SD$10 Subject to the Constraints: SB$115D$11c#SB$13:SD$ 13 SES9 SES10$GS9 $G$10 Add Change Delete Reset All Make Unconstrained Variables Non-Negative Select a Solving Method: Simplex LP GRG Nonlinear Simplex LP Options Solving Method E Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. Help Solve Close

Ca) Thu referrir Supen Sover class delure lau 50 Allccaficn Etion to ach tom type inclo ico in type 1 (cWm Supe. Save. clai) 100 (0

Solver Results Solver found a solution. All Constraints and optimality conditions are satisfied. Reports Answer Sensitivity Limits O Keep Solver Solution O Restore Original Values Return to Solver Parameters Dialog Outline Reports OK Cancel Save Scenario...