George and Jane are thinking of introducing three reservation packages: Standard, Deluxe and Premium. Guests who...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
George and Jane are thinking of introducing three reservation packages: Standard, Deluxe and Premium. Guests who choose a Deluxe package would be entitles to a free breakfast and have priority access to the newly installed wood fired spa. A Premium package would also include a free breakfast and priority access to the spa, plus a free wine tour. With 6 treehouses in total and assuming full occupancy, the maximum number of bookings per month is 180. Based on estimated demand, George and Jane would expect at most 150 Standard reservations per month, and a maximum of 30 Premium reservations per month. They would like to limit the total number of Deluxe and Premium reservations to 60. Each Standard reservation is expected to generate a profit of $25. Profits per night for Deluxe and Premium reservations are $35 and $40, respectively. George and Jane interested in maximising the monthly profit. (a) (4 marks) Formulate a linear programming model for The Treetop Retreat. In doing so, clearly indicate the following: •What are the decision variables? Define them precisely. •What is the objective? Using your decision variables, formulate the objective function. •What are the constraints? Using your decision variables, formulate these constraints. (b) (3 marks) Use EXCEL Solver to obtain a solution to the linear programming model from part (a), together with an Answer Report and a Sensitivity Report. Provide a copy of your EXCEL spreadsheet and of the two Solver reports in this Appendix. EXCEL Instructions: All EXCEL output should bear your e-mail ID. To ensure this, you will need to save your EXCEL file as 'E-mail ID The Treetop Retreat.xlsx' BEFORE you run Solver. In addition, your constraint names should begin with your initials, eg MK Total bookings. Refer to Activity 4D and 4E for detailed instructions on how to set up your spreadsheet and use Solver. You can set up your own spreadsheet, or use the LP Solver template, available from the course learnooline website. (c) (3 marks) Suppose that the profit per Premium reservation turns out to be $38 instead of $40. Would the solution obtained in part (b) still be optimal? Which of the Solver reports helps you answer this question and how? How would the solution change, if at all? Explain briefly and include a copy of your new Answer Report ONLY, if needed to describe the outcome of the proposed change. (d) (3 marks) Return all parameters to their values from part (b). What if the profit per Deluxe reservation turns out to be $45 instead of $35? Would the solution obtained in part (b) still be optimal? Which of the Solver reports helps you answer this question and how? How would the solution change, if at all? Explain briefly and include a copy of your new Answer Report ONLY, if needed to describe the outcome of the proposed change. (e) (3 marks) Return all parameters to their values from part (b). Suppose that The Treetop Retreat increases the limit on Deluxe and Premium packages combined to 80. Would the solution obtained in part (b) still be optimal? Which of the Solver reports helps you answer this question and how? Explain briefly and attach your new Answer Report ONLY, if needed to describe the outcome of the proposed change. George and Jane are thinking of introducing three reservation packages: Standard, Deluxe and Premium. Guests who choose a Deluxe package would be entitles to a free breakfast and have priority access to the newly installed wood fired spa. A Premium package would also include a free breakfast and priority access to the spa, plus a free wine tour. With 6 treehouses in total and assuming full occupancy, the maximum number of bookings per month is 180. Based on estimated demand, George and Jane would expect at most 150 Standard reservations per month, and a maximum of 30 Premium reservations per month. They would like to limit the total number of Deluxe and Premium reservations to 60. Each Standard reservation is expected to generate a profit of $25. Profits per night for Deluxe and Premium reservations are $35 and $40, respectively. George and Jane interested in maximising the monthly profit. (a) (4 marks) Formulate a linear programming model for The Treetop Retreat. In doing so, clearly indicate the following: •What are the decision variables? Define them precisely. •What is the objective? Using your decision variables, formulate the objective function. •What are the constraints? Using your decision variables, formulate these constraints. (b) (3 marks) Use EXCEL Solver to obtain a solution to the linear programming model from part (a), together with an Answer Report and a Sensitivity Report. Provide a copy of your EXCEL spreadsheet and of the two Solver reports in this Appendix. EXCEL Instructions: All EXCEL output should bear your e-mail ID. To ensure this, you will need to save your EXCEL file as 'E-mail ID The Treetop Retreat.xlsx' BEFORE you run Solver. In addition, your constraint names should begin with your initials, eg MK Total bookings. Refer to Activity 4D and 4E for detailed instructions on how to set up your spreadsheet and use Solver. You can set up your own spreadsheet, or use the LP Solver template, available from the course learnooline website. (c) (3 marks) Suppose that the profit per Premium reservation turns out to be $38 instead of $40. Would the solution obtained in part (b) still be optimal? Which of the Solver reports helps you answer this question and how? How would the solution change, if at all? Explain briefly and include a copy of your new Answer Report ONLY, if needed to describe the outcome of the proposed change. (d) (3 marks) Return all parameters to their values from part (b). What if the profit per Deluxe reservation turns out to be $45 instead of $35? Would the solution obtained in part (b) still be optimal? Which of the Solver reports helps you answer this question and how? How would the solution change, if at all? Explain briefly and include a copy of your new Answer Report ONLY, if needed to describe the outcome of the proposed change. (e) (3 marks) Return all parameters to their values from part (b). Suppose that The Treetop Retreat increases the limit on Deluxe and Premium packages combined to 80. Would the solution obtained in part (b) still be optimal? Which of the Solver reports helps you answer this question and how? Explain briefly and attach your new Answer Report ONLY, if needed to describe the outcome of the proposed change.
Expert Answer:
Related Book For
Quantitative Methods for Business
ISBN: 978-0324651751
11th Edition
Authors: David Anderson, Dennis Sweeney, Thomas Williams, Jeffrey cam
Posted Date:
Students also viewed these general management questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Find the direction cosines and angles of, and demonstrate that the sum of the squares of the direction cosines is 1. u = 5i + 3j - k
-
After the amount due on a sale of $28,000, terms 2/10, n/eom, is received from a customer within the discount period, the seller consents to the return of the entire shipment for a cash refund. The...
-
Explain the significance of the purchase order to adequate internal control over purchase transactions.
-
Revenue Recognition Each of the following situations relates to the recognition of revenue: a. A store sells a gift card in December that will be given as a Christmas present. The card is not...
-
1. What evidence was presented in this case that the staff members from different units at Tymco might have become better acquainted. 2. What should Maria do next to improve the chances that the home...
-
See attached image to answer questions: Use the information you have to complete the information that should be in the blue cells. Calculate the breakeven point on the new product. What decision rule...
-
A Divine Mission Business Wars Podcast Describe Dr. Kelloggs business model as best as you can from the information provided in the episode (i.e., V, P, & C). How do the sanatorium and his mail-order...
-
Evaluate the determinant of the matrix. 5 3 A = 8 2 3 4
-
Compute and present a Sales Budget 2.Determine production volume 3.Compute the estimate manufacturing costs and operating expenses a.Purchases (material) budget b.Personnel budget c.Overhead budget...
-
What is the advantage of using dashboards to measure the performance of marketing activities? How the marketing performance enhance ? Discuss
-
You recently opened a brand-new function centre. Prior to opening you and the WHS representative completed a hazard identification and risk assessment of the premises. You've been open a month now...
-
Question 1 The average credit card debt for college seniors is $3262. If the debt is normally distributed with a standard deviation of $1100, find these probabilities. a) The senior owes less than...
-
The following financial statements were drawn from the records of Matrix Shoes: Balance Sheets Assets Cash As of December 31 Year 2 Year 1 Accounts receivable Merchandise inventory Notes receivable...
-
Find the work done in pumping all the oil (density S = 50 pounds per cubic foot) over the edge of a cylindrical tank that stands on one of its bases. Assume that the radius of the base is 4 feet, the...
-
The River City Fire Department (RCFD) fights fires and provides a variety of rescue operations in the River City metropolitan area. The RCFD staffs 13 ladder companies, 26 pumper companies, and...
-
The president of a small manufacturing firm has been concerned about the continual growth in manufacturing costs over the past several years. The following is a time series of the cost per unit (in...
-
Foster Drugs, Inc., handles a variety of health and beauty aid products. A particular hair conditioner product costs Foster Drugs $2.95 per unit. The annual holding cost rate is 20%. An...
-
Effects of FIFO and Weighted Average} Sheepskin Company sells to colleges and universities a special paper that is used for diplomas. Sheepskin typically makes one purchase of the special paper each...
-
Examine the cash flow measures in requirement 2 of the review problem in this chapter. Discuss the meaning of these ratios. Computing Cash Flows from Operating Activities: Indirect Method
-
During 20x7, Arizona Company issued $500,000 in long-term bonds at 96, repaid $75,000 of bonds at face value, paid interest of $40,000, and paid dividends of $25,000. Prepare the cash flows from the...
Study smarter with the SolutionInn App