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
-
Suppose that a CEO's goal is to increase profitability and output from her company by bolstering its sales force and that it is known that profits as a function of output are = 40q 2q2 (in millions...
-
Bailey Construction Company purchases a bulldozer on December 20, 2021. An ice storm delays delivery until December 24. Because of the holidays, the equipment is not used until January 2.
-
10. ROLE REVERSAL Write an exam question that distinguishes between these three important Fifth Amendment protections: procedural due process, the Takings Clause, and substantive due process.
-
Cost-plus, target return on investment pricing, Vend-o-licious makes candy bars for vending machines and sells them to vendors in cases of 30 bars. Although Vend-o-licious makes a variety of candy,...
-
Motorcycle Manufacturers, Inc., projected sales of 54,200 machines for the year. The estimated January 1 inventory is 6,550 units, and the desired December 31 inventory is 7,160 units. The budgeted...
-
It is now January 2018. The year 2017 finished well. The finalized year-end financial statements for 2017 are provided in the excel file associated with this assignment. Randolf and Tenisa at Comfy...
-
Forten Company's current year income statement, comparative balance sheets, and additional information follow. For the year, (1) all sales are credit sales, (2) all credits to Accounts Receivable...
-
The Fashion Shoe Company operates a chain of women's shoe shops that carry many styles of shoes that are all sold at the same price. Sales personnel in the shops are paid a sales commission on each...
-
Martinez Company's relevant range of production is 7,500 units to 12,500 units. When it produces and sells 10,000 units, its average costs per unit are as follows: Average Cost per Unit Direct...
-
Simplify: 4-63+728
-
Wexpro, Incorporated, produces several products from processing 1 ton of clypton, a rare mineral. Material and processing costs total $ 7 8 , 0 0 0 per ton, one - fourth of which is allocated to...
-
n May 20, Montero Company paid $276,000 to acquire 135 shares (4%) of ORD Corporation as a long-term investment. On ugust 5, Montero sold one-tenth of the ORD shares for $28,500. 1. Prepare entries...
-
115 minutes remaining 10 OF 10 QUESTIONS REMAINING Time 120 You will use the following information for the next six problems 11-61. Eldorado's is a US fast food chain which imports supplies. from...
-
On average there are four traffic accidents in a city during one hour of rush-hour traffic. Use the Poisson distribution to calculate the probability that in one such hour there arc (a) No accidents...
-
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...
-
Taking the closing balance sheet from the example above prepare a balance sheet and profit and loss account for the third year of trading incorporating the following transactions: 1. The owner...
-
Sid's business during the next month is even better than in the first. Sid purchased a further 200 of diesel and had just filled his tank with 35 worth before finishing on the last day of the month....
-
Prepare a cash flow statement for the above business as at the end of year 2 to create the comparative figures for the above statement
Study smarter with the SolutionInn App