Wilson and Sons Corp. has bought a prime parcel of beachfront property and plans to build...

Wilson and Sons Corp. has bought a prime parcel of beachfront property and plans to build a luxury hotel. After meeting with the architectural team, the Wilson family has drawn up some information to make preliminary plans for construction. Excluding the suites, which are not part of this decision, the hotel will have four kinds of rooms: beachfront non-smoking, beachfront smoking, lagoon view non-smoking, and lagoon view smoking. In order to decide how many of each of the four kinds of rooms to plan for, the Wilson family will consider the following information.

After adjusting for expected occupancy, the average nightly revenue for a beachfront non-smoking room is $175. The average nightly revenue for a lagoon view non-smoking room is $130. Smokers will be charged an extra $15.
Construction costs vary. The cost estimate for a lagoon view room is $12,000 and for a beachfront room is $15,000. Air purifying systems and additional smoke detectors and sprinklers add $3000 to the cost of any smoking room. Wilson and Sons Corp. has raised $6.3 million in construction guarantees for this portion of the building.
There will be at least 100 but no more than 180 beachfront rooms.
Design considerations require that the number of lagoon view rooms be at least 50% more than beachfront rooms but no more than 150% of beachfront rooms.
Industry trends recommend that the number of non-smoking rooms be at least 50% more the number of smoking rooms.

Formulate a linear programming model to maximize revenue and solve in Excel.

Include in your answer the:

Model
Excel input
Answer report
Description of the optimal solution

Expert Solution

orchestra answered 2 years ago

Evans: Evans Enterprises has bought a prime parcel of beachfront property and plans to build a...

Evans: Evans Enterprises has bought a prime parcel of beachfront property and plans to build a luxury hotel. After meeting with the architectural team, the Evans family has drawn up some information to make preliminary plans for construction. Excluding the suites, which are not part of this decision, the hotel will have four kinds of rooms: beachfront non-smoking, beachfront smoking, lagoon view non-smoking, and lagoon view smoking. To decide how many of each of the four kinds of rooms to...

Adventures & Vacations LLC bought a parcel of land and plans to build luxury villas on...

Adventures & Vacations LLC bought a parcel of land and plans to build luxury villas on the property. The owners of the company plans to build four types of villas: deluxe non-smoking villas, deluxe villas that allow smoking, premier non-smoking villas and premier villas that allow smoking. Your team works for a consultant company that was hired to help the company plan the how many rooms of each type to build. You were given these following information by Adventures &...

21. Nick has bought a house that comes with a small beachfront. Unfortunately, the beachfront is...

21. Nick has bought a house that comes with a small beachfront. Unfortunately, the beachfront is separated from the rest of Nick’s property by Jay’s property. Nick and Jay work out an agreement that allows Nick to cross Jay’s property to get to the beachfront. What is the correct term for this arrangement? a. Lease b. Easement c. Right of access d. Mortgage 22. The Dhyana Center has rented a space in a strip mall where it offers classes and...

Mining Corp acquired a parcel of land for $4,000,000. It was estimated that the property contained...

Mining Corp acquired a parcel of land for $4,000,000. It was estimated that the property contained 300,000 tons of mineral reserves. Federal law requires that mined properties be restored to a natural condition after mining is completed. It is expected that restoration costs will total $400,000 and that the restored land could be resold for $200,000. During the year, the company extracted 25,000 tons (of which 15,000 tons were sold) of mineral reserves from the property. 1.try to record the...

Sanam has bought a property for $120,000 down payment and quarterly payments of $2100 at the...

Sanam has bought a property for $120,000 down payment and quarterly payments of $2100 at the end of every quarter for 15 years. Find the purchase price of her property if interest rate is 4% p.a. compounding quarterly.

Sanam has bought a property for $120,000 down payment andquarterly payments of $2100 at the...

Sanam has bought a property for $120,000 down payment and quarterly payments of $2100 at the end of every quarter for 15 years. Find the purchase price of her property if interest rate is 4% p.a. compounding quarterly

Hyde Park Elementary has plans to build a new playground in 2017. They received a $120,000...

Hyde Park Elementary has plans to build a new playground in 2017. They received a $120,000 government grant to be used for building the playground. They are hoping to break ground in May 2017 and complete the project by the start of school in September. Before they can start the project, however, they must dismantle the existing playground that has become unsafe based on current safety standards. They are also planning to complete soil testing once the existing playground is...

1. McDonnell-Douglas Corp. has struck a deal with a company in China to build aircraft there....

1. McDonnell-Douglas Corp. has struck a deal with a company in China to build aircraft there. What kinds of strategies should be employed by this or other firms doing business internationally? What are the benefits and problems associated with international business?

1. The Sturgeon Corp. has developed a new line of spinning reel it plans to produce...

1. The Sturgeon Corp. has developed a new line of spinning reel it plans to produce and sell in the United States. The cost of the necessary equipment will be $2.8 million plus $340,000 for installation and delivery. The equipment falls into the MACRS 7-year class. The equipment will be scrapped when the project is finished in 5 years for an estimated $700,000. Sturgeon estimates that sales in the first year of production will be 110,000 units at $30 apiece....

The Asian Carp Corp. (ACC) has developed a new line of spinning reel it plans to...

The Asian Carp Corp. (ACC) has developed a new line of spinning reel it plans to produce and sell in the United States. The cost of the necessary equipment will be $835,000 plus $37,000 for installation and delivery. The equipment falls into the MACRS 5-year class. The equipment will be scrapped in 5 years for an estimated $100,000. ACC estimates that sales in the first year of production will be $750,000, and due to intense marketing and word-of-mouth advertising, they...

Question