USE SOLVER TO ANSWER

Problem 1 Hotel 9 will have an overhaul and is expanding to open more rooms. They have specific goals they'd like to achieve: they want to use only 15,000 m to build all the possible rooms, and want to get a profit above $63,500. Also, the hotel currently counts with 22 labor-hours (personnel) available for new rooms and would like to avoid hiring more people. Factor Area Profit Personnel Economy 100 250 Suite 160 360 0.2 Double 280 520 0.4 Goal $ 15,000 263,500 = 22 Penalty Weight 1 1 1(+); 1 (-) 0.1 a) How many of each kind of new room must be built? b) Which goals were reached? c) From the goals not reached, by how much were they not reached