eBookProblem 8-21 (Algorithmic)Round Tree Manor is a hotel that provides two types of rooms with three rental classes: Super Saver, Deluxe, and Business. The profit per night for each type of room and rental dass is as follows:RoomType 1Type IIRental ClassSuper Saver$37$18.Deluxe$40$33Business$35Type I rooms do not have wireless Internet access and are not available for the Business rental class.Round Tree's management makes a forecast of the demand by rental class for each night in the future. A linear programming model developed to maximize profit is used to determine how many reservations to accept for each rental class. The demand forecast for a particular night is 125 rentals in the Super Saver>class, 50 rentals in the Deluxe class, and 10 rentals in the Business class. Round Tree has 110 Type 1 rooms and 120 Type II rooms. b. How many reservations can be accommodated in each rental class?Rental ClassSuperSaverDeluxeBusiness# ofreservationsCAMERc. Management is considering offering a free breakfast to anyone upgrading from a Super Saver reservation to Deluxe class. If the cost of the breakfast to Round Tree is $5, should this incentive be offered?d. With a little work, an unused office area could be converted to a rental room. If the conversion cost is the same for both types of rooms, would you recommend converting the office to a Type I or a Type II room?Why?The input in the box below will not be graded, but may be reviewed and considered by your instructor.e. Could the linear programming model be modified to plan for the allocation of rental demand for the next night?What information would be needed and how would the model change?The input in the box below will not be graded, but may be reviewed and considered by your instructor.Previous

Linear programming model :Let x1 be the no. of SuperSaver rentals allocated to room type l.Let x2 be…

Answered: Round Tree Manor is a hotel that…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

c. If Cabinetmaker 1 has additional hours available, would the optimal solution change? If required, round your answers to three decimal places. If your answer is zero, enter "0". Explain. ✓ because Cabinetmaker 1 has dual value Yes ✓ of No -1.84 ✔ ✓ of Therefore, each additional hour of time for cabinetmaker 1 will reduce total cost by $ d. If Cabinetmaker 2 has additional hours available, would the optimal solution change? If required, round your answers to three decimal places. If your answer is zero, enter "0". Use a minus sign to indicate the negative figure. Explain. ✔ because Cabinetmaker 2 has a slack 1.84 ✔ per hour, up to a maximum of 30 X hours. Alternatively, the dual value is 50 ✓ hours. 0.00 ✓ which means that adding one hour to this constraint will decrease total cost by $ 0.00 ✓.
Even though independent gasoline stations have been having a difficult time, lan Langella has been thinking about starting his own independent gasoline station. lan's problem is to decide how large his station should be. The annual returns will depend on both the size of his station and a number of marketing factors related to the oil industry and demand for gasoline. After a careful analysis, lan developed the following table: States of Nature Size of First Station Good Market Fair Market Poor Market $40,000 $90,000 $18,000 $27,000 - $8,000 - $22,000 Small Medium $105,000 $27,500 Large Very Large - $36,000 - $180,000 $320,000 $26,000 For example, if lan constructs a small station and the market is good, he will realize a profit of $40,000. This exercise contains only parts b, c, and d. b) Using the decision making under uncertainty with the criterion of Maximax The appropriate decision will be
The Dahlia Medical Center has 31 labor rooms, 18 combination labor and delivery rooms, and 5 delivery rooms. All of these facilities operate around the clock. Time spent in labor rooms varies from hours to days, with an average of about a day. The average uncomplicated delivery requires about one hour in the delivery room. The average time in a combination labor-delivery room is about 24 hours. During an exceptionally busy three-day period, 109 healthy babies were born at Dahlia Medical Center. 60 babies were born in separate labor and delivery rooms and 49 were born in combined labor and delivery rooms. Which of the facilities (labor rooms, combination labor and delivery rooms, or delivery rooms) had the greatest utilization rate? had the highest utilization rate of %. (Enter your response as a percent rounded to two decimal places.) The combination labor and delivery rooms labor rooms delivery rooms
PharmaPlus operates a chain of 30 pharmacies. The pharmacies are staffed by licensed pharmacists and pharmacy technicians. The company currently employs 85 full-time-equivalent pharmacists (combination of full time and part time) and 175 full-time-equivalent technicians. Each spring management reviews current staffing levels and makes hiring plans for the year. A recent forecast of the prescription load for the next year shows that at least 250 full-time-equivalent employees (pharmacists and technicians) will be required to staff the pharmacies. The personnel department expects 10 pharmacists and 30 technicians to leave over the next year. To accommodate the expected attrition and prepare for future growth, management states that at least 15 new pharmacists must be hired. In addition, PharmaPlus’s new service quality guidelines specify no more than two technicians per licensed pharmacist. The average salary for licensed pharmacists is $40 per hour and the average salary for technicians…
Bob and Dora Sweet wish to start investing $1,000 each month. The Sweets are looking at five investment plans and wish to maximize their expected return each month. Assume interest rates remain fixed and once their investment plan is selected they do not change their mind. The investment plans offered are: Fidelity 9.1% return per year Optima 16.1% return per year CaseWay 7.3% return per year Safeway 5.6% return per year National 12.3% return per year Since Optima and National are riskier, the Sweets want a limit of 30% per month of their total investments placed in these two investments. Since Safeway and Fidelity are low risk, they want at least 40% of their investment total placed in these investments.Formulate the LP model for this problem, using the standard LP format. Remember to define the objective function, the decision variables, and label the constraint functions. There is no need to solve the problem. Note:- Do not provide handwritten solution. Maintain…
Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here: Cabinetmaker 1 Cabinetmaker 2 Cabinetmaker 3 Hours required to complete all the oak cabinets 47 40 27 Hours required to complete all the cherry cabinets 64 51 36 Hours available 40 30 35 Cost per hour $34 $41 $52 For example, Cabinetmaker 1 estimates it will take 47 hours to complete all the oak cabinets and 64 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 40 hours available for the final…
Georgia Cabinets manufactures kitchen cabinets that are sold to local dealers throughout the Southeast. Because of a large backlog of orders for oak and cherry cabinets, the company decided to contract with three smaller cabinetmakers to do the final finishing operation. For the three cabinetmakers, the number of hours required to complete all the oak cabinets, the number of hours required to complete all the cherry cabinets, the number of hours available for the final finishing operation, and the cost per hour to perform the work are shown here: Hours required to complete all the oak cabinets Hours required to complete. all the cherry cabinets Hours available Cost per hour Min s.t. 01 Let O₁ O₂ 01 01 For example, Cabinetmaker 1 estimates it will take 50 hours to complete all the oak cabinets and 60 hours to complete all the cherry cabinets. However, Cabinetmaker 1 only has 40 hours available for the final finishing operation. Thus, Cabinetmaker 1 can only complete 40/50 = 0.8, or 80%,…
The Dahlia Medical Center has 35 labor rooms, 18 combination labor and delivery rooms, and 2 delivery rooms. All of these facilities operate around the clock. Time spent in labor rooms varies from hours to days, with an average of about a day. The average uncomplicated delivery requires about one hour in the delivery room. The average time in a combination labor-delivery room is about 24 hours. During an exceptionally busy three-day period,109 healthy babies were born at Dahlia Medical Center. 57babies were born in separate labor and delivery rooms and 52 were born in combined labor and delivery rooms. Which of the facilities (labor rooms, combination labor and delivery rooms, or delivery rooms) had the greatest utilization rate? The ________________% had the highest utilization rate of_____________% (Enter your response as a percent rounded to two decimal places.)
Mark has a company that produces tables and chairs, both having two different models. The product models and related information are given in the following table. Wood costs 3000 $ per cubic meter and 200 m3 of wood are available for the upcoming month. The cost of labor is 40 $/hour and there are 6000 hours of labor available in a month. Mark sells his products to a big chain retail company. The company purchases all products whatever Mark produces. Mark formulates an LP as follows to determine the optimal monthly production plan such that he maximizes the total profit. Decision Variables: X1 : number of basic tables to be produced. X2 : number of elegant tables to be produced. X3 : number of basic chairs to be produced. X4 :number of elegant chairs to be produced. Max Z = 140 X1 + 345 X2 + 120 X3 + 260 X4 ( maximize total profit) Subject to 0.11 X1 + 0.13 X2 + 0.06 X3 + 0.07 X4 ≤ 200 (constraint on the available amount of wood) 2 X1 + 4.5 X2 + 1.5 X3 + 4 X4 ≤ 6000…
the excel file president’s inn guest database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed- and-breakfast inn during one month. room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. guests staying for seven days or more receive a 10% discount. modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
BRIGHT BOOK STORE Bright Books is a book store chain established 10 years ago in northern Michigan. Bright Books has had great success in Michigan and Ohio and is beginning to expand into other states. Most recently, executives have decided to open a store in Orlando, Florida. Approximately 20% of Orlando's population is over the age of 55. Orlando's Hispanic/Latino population is growing and is currently 18.2% of the city's total population. The manager who has been chosen to open the store is Carmen Flux. Carmen, a graduate of a Human Resource Management program, is excited about her organization's commitment to diversity initiatives in employment as well as its more recent strategic focus on offering products that best meet the needs of the surrounding community. For example, knowing that many of the residents are retirees and that planning for several new retirement communities in the area is currently underway, she plans to hire employees who understand what the customers want in…
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS