Question

In: Operations Management

Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers...

Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the hotel:

  1. We want to figure out how many rooms of each type to build based on maximizing revenue if we fill up the hotel. We expect to charge $190 for a suite that is non-smoking and $140 for a budget room that is non-smoking. Smoking room customers for both suites and budget rooms will have to pay an additional $20 per night.
  2. We can spend up to $7,500,000 on construction of our hotel. The cost to build a non-smoking budget room is $12,000. The cost to build a non-smoking suite is $15,000. It is $3,000 additional for a smoking room of either type for smoke detectors and sprinklers.
  3. We require that the number of budget rooms be at least 1.5 times the number of suites, but no more than 3 the number of suites.
  4. There needs to be at least 80 suites, but no more than 200.
  5. Industry trends recommend that smoking rooms should be less than 50% of the non-smoking room and in addition, we require our builder gives us at least 4 smoking rooms.

Solutions

Expert Solution

We will solve this linear programming problem using Excel solver as shown in below Excel screen prints.

We will setup Data -> Solver with decision variables, constraints and objective function in Excel as shown below.

Click solve to get the optimal solution as below:

Optimal solution is

Room Type Number of rooms
Suite- Smoking 4
Suite- Non-smoking 196
Budget- Smoking 0
Budget- Non-smoking 374

Revenue is $90,440


Please give thumbs up/ likes if you consider my answer useful. Thank you!


Related Solutions

Sleep-EZ Suites Inc., operates a downtown hotel property that has 600 rooms. On average, 90% of...
Sleep-EZ Suites Inc., operates a downtown hotel property that has 600 rooms. On average, 90% of Sleep-EZ Suites's rooms are occupied on weekdays, and 60% are occupied during the weekend. The manager has asked you to develop a direct labor budget for the housekeeping and restaurant staff for weekdays and weekends. You have determined that the housekeeping staff requires 40 minutes to clean each occupied room. The housekeeping staff is paid $10 per hour. The restaurant has 12 full-time staff...
Cheap Stay Inc. is considering building a budget hotel that offers clean small rooms with bathrooms....
Cheap Stay Inc. is considering building a budget hotel that offers clean small rooms with bathrooms. They anticipate that the 120 rooms will rent for 36,000 room-nights per year. The market price for equivalent rooms is $60 per night. Cheap Stay estimates that the cost of capital will be $7,900,000 and they would like an annual return on 15%. Following are the estimated annual operating costs: Variable operating costs $18 per room night Fixed Costs: Salaries and wages $450,000 Building...
Quantitative Methods in BUSN Solve this problem using Excel Solver 1. Devos Inc. is building a...
Quantitative Methods in BUSN Solve this problem using Excel Solver 1. Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the hotel: We want to figure out how many rooms...
4. Devos inc has 4 teams (A, B, C, D) and 4 (1, 2, 3, 4)...
4. Devos inc has 4 teams (A, B, C, D) and 4 (1, 2, 3, 4) potential tasks. The total amount of days each employee would need to allocate to each job is as follows: ​ Potential Tasks Team 1 2 3 4 A 28 33 21 35 B 41 43 23 37 C 48 28 33 42 D 49 27 43 46 Use Excel solver Match the team the most efficient task. What is the total number of days...
The Hotel El Politécnico has # 500 rooms. They usually have a cost per room of...
The Hotel El Politécnico has # 500 rooms. They usually have a cost per room of $ 70.00, plus a fixed cost of $ 5,000.00 per day. Each room is rented for $ 175.00 per day during the summer season. Answer the following questions using the above data: a) If the Hotel operates at 70% capacity for one day, what is the net profit (gain / loss)? b) What is the equilibrium point (B. E. P.)? in units, if it...
2. Devos Inc. makes desks that are made up of 1 top, 2 sides, and 4...
2. Devos Inc. makes desks that are made up of 1 top, 2 sides, and 4 legs. We need to make at least 15,000 desks to fulfill the demand of our customers. The costs are as follow: Make the top - $7, Buy the top - $10, Make the side - $3, Buy the side - $5, Make a leg - $2, Buy a leg - $3 1) One top requires 4 feet of wood, one side requires 2 feet...
2. Devos Inc. makes desks that are made up of 1 top, 2 sides, and 4...
2. Devos Inc. makes desks that are made up of 1 top, 2 sides, and 4 legs. We need to make at least 15,000 desks to fulfill the demand of our customers. The costs are as follow: Make the top - $7 Buy the top - $10 Make the side - $3 Buy the side - $5 Make a leg - $2 Buy a leg - $3 1) One top requires 4 feet of wood, one side requires 2 feet...
you have a small hotel serving international customers from all over the world and you need...
you have a small hotel serving international customers from all over the world and you need to find a supplier that will provide you milk, cheese, and other dairy products. What will be the advantage and disadvantage of working with a small supplier who sells most of his products to you ? What will be the advantage and disadvantage of working with a very large supplier who sells only 1% of its products to you ? Discuss in ten or...
Conference Services Inc. has leased a large office building for $4 million per year. The building...
Conference Services Inc. has leased a large office building for $4 million per year. The building is larger than the company needs: two of the building's eight stories are almost empty. A manager wants to expand one of her projects, but this will require using one of the empty floors. In calculating the net present vlaue of the proposed expansion, upper management allocates one-eighth of $4 million of building rental costs (i.e., $.5 million) to the project expansion, reasoning that...
Many hotel chains that offer free Wi-Fi service to their customers have experienced issues regarding demand...
Many hotel chains that offer free Wi-Fi service to their customers have experienced issues regarding demand for Internet bandwidth and costs. Marriott International would like to test the hypothesis that the proportion of customers that are carrying two Wi-Fi devices is equal to 0.40. A random sample of 200 Marriott customers found that 82 have two Wi-Fi devices. Marriott International would like to set the level of significance equal to 0.05. Determine the level of significance Determine the rejection region
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT