Business, 19.03.2021 18:10 mahkitheking16

Port Aransas Resort Company (PARC) has bought a prime parcel of beachfront property and plans to build a luxury hotel. After meeting with the architectural team, the owners have 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 owners will consider the following information. • After adjusting for expected occupancy, the average nightly revenue for a beachfront non-smoking room is $190. The average nightly revenue for a lagoon view non-smoking room is $170. Smokers will be charged an extra $15.
• Construction costs vary. The cost estimate for a lagoon view room is $19,000 and for a beachfront room is $20,000. Air purifying systems and additional smoke detectors and sprinklers add $3,000 to the cost of any smoking room. PARC has raised $6.3 million in construction funds 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 1.5 times the number of beachfront rooms, and no more than 2.5 times that number.
• Industry trends recommend that the number of smoking rooms be no more than 25% of the number of non-smoking rooms.
A. Develop the linear programming model to maximize revenue
B. Solve the LP model in Excel and submit your work including the reports.
C. What is the solution?
D. PARC is a little surprised at the results. Even though industry statistics show that the number of people requesting smoking rooms has declined, they feel that they may need more smoking rooms. Without re-solving the problem in Excel, how can they use the reports to determine the effect that adding more smoking rooms would have on their revenue?

Answers: 3

Show answers

Another question on Business

Business, 22.06.2019 19:40

The following cost and inventory data are taken from the accounting records of mason company for the year just completed: costs incurred: direct labor cost $ 90,000 purchases of raw materials $ 134,000 manufacturing overhead $ 205,000 advertising expense $ 45,000 sales salaries $ 101,000 depreciation, office equipment $ 225,000 beginning of the year end of the year inventories: raw materials $ 8,100 $ 10,300 work in process $ 5,900 $ 21,000 finished goods $ 77,000 $ 25,800 required: 1. prepare a schedule of cost of goods manufactured. 2. prepare the cost of goods sold section of mason company’s income statement for the year.

Answers: 3

Answer

Business, 23.06.2019 11:40

Anewspaper story on the effect of higher milk prices on the market for ice cream contained the following: "as a result [of the increase in milk prices], retail prices for ice cream are up 4 percent from last year. . and ice cream consumption is down 3 percent." source: john curran, "ice cream, they scream: milk fat costs drive up ice cream prices," associated press, july 23, 2001. based on the information given, what is the price elasticity of demand for ice cream?

Answers: 1

Answer

Business, 23.06.2019 15:00

An unmarried person, a divorced person, or a person legally separated from his or her spouse must choose which filling status when filling a federal income tax return?

Answers: 1

Answer

Business, 23.06.2019 18:30

Ange in supply or (ii) a movement along the supply curve. a. during a real estate boom that causes house prices to rise, more homeowners put their houses up for sale. b. many strawberry farmers open temporary roadside stands during harvest season, even though prices are usually low at that time. c. immediately after the school year begins, fewer young people are available to work. fast-food chains must raise wages, which represent the price of labor, to attract workers. d. many construction workers temporarily move to areas that have suffered hurricane damage, lured by higher wages. e. since new technologies have made it possible to build larger cruise ships (which are cheaper to run per passenger), caribbean cruise lines have offered more cabins, at lower prices, than before. 2. in the following three situations, the market is initially in equilibrium. after each event described below, does a surplus or shortage exist at the original equilibrium price? what will happen to the equilibrium price as a result? a. in 2010 there was a bumper crop of wine grapes. b. after a hurricane, florida hoteliers often find that many people cancel their upcoming vacations, leaving them with empty hotel rooms. c. after a heavy snowfall, many peop

Answers: 3

Answer

You know the right answer?

Port Aransas Resort Company (PARC) has bought a prime parcel of beachfront property and plans to bui...

Questions