Business, 12.03.2021 15:50 mangociruelo9402

Swiftcar Rental Company is a local rental car company that serves the Buffalo-Niagara area. The management team is considering to incorporate the network management framework into its booking system. To begin with, the management team attempts to identify the optimal booking schedule for weekends (i. e., from Friday to Sunday) to maximize its revenue performance. In total, Swiftcar Rental Company has 100 full-size sedans, and all sedans are available for those three days (i. e., the capacity for Friday, Saturday, and Sunday will be 100 for each and every day.) The rental prices for Friday, Saturday, and Sunday are $89, $69, and $59 respectively. If a consumer asks for two-consecutive-day booking, then this customers will receive a 10% discount on the total price. For three-consecutive-day booking, the discount will be 30% over the total price. Particularly, demands and prices for all booking periods areas shown in the following table: Booking Period Price Demand
Friday Only 89 35
Saturday Only 69 12
Sunday Only 59 8
Friday-Saturday 142 55
Saturday-Sunday 115 35
Friday-Sunday Price 152 107
a. Write down the optimization Model for this Swiftcar Rental Company including decision variables, objective function, and constraints.
b. Based on the Optimization Model, please build an Excel model and provide one printout of your formula-view snapshot for your Excel model. • To get a formula-view of your spreadsheet, you need to go to Excel’s "Formula" tab and click "Show Formulas"; alternatively, you can press CTRL + ` (grave accent) to show your formulas. • To check the correctness of your Excel model, you can key in an arbitrary (i. e., nonoptimal) booking schedule: 15 bookings for Friday Only, 3 for Saturday Only, 8 for Sunday Only, 5 for Friday-Saturday, 12 for Saturday-Sunday, and 80 for Friday-Sunday. Under this arbitrary booking schedule, Swiftcar Rental Company will exhaust its capacity for all three days (i. e., the number of bookings for each day will be equal to the company’s capacity—100 full-size sedans). The revenue generated under this booking schedule is $16,264.
c. Use the Excel Solver to solve this problem and report the optimal booking schedule and the corresponding revenue performance.
d. Swiftcar Rental Company is considering a marketing campaign to increase the demand for Sunday Only booking requests by 30 (i. e. from 8 booking requests to 38 booking requests). It has been estimated that such campaign will cost $1,500. Should Swiftcar Rental Company implement such marketing campaign? Please show your analysis. • Hint: generate and use Sensitivity Report in the Excel solver.

Answers: 3

Show answers

Another question on Business

Business, 21.06.2019 19:20

Which of the following accurately describes a surplus? a. consumer demand for a certain car is below the number of cars that are produced. b. the production costs for a certain car are below the sale price of that car. c. a reduction in the cost of steel enables a car company to reduce the sale price of its cars. d. a car company tries to charge too high a price for a car and has to reduce the price. 2b2t

Answers: 1

Answer

Business, 22.06.2019 19:00

Read the scenario. alfonso is 19 years old and has a high school diploma. recently, he was promoted to assistant manager at the fast-food restaurant where he has worked since the age of sixteen. his dream is to become the restaurant’s manager. what is his best option for achieving his dream? he should find another job and work his way up to a higher position. he should hope that his manager transfers to another location and that he is his replacement. he should attend classes at the local college to receive training in management. he should work hard, work longer hours, and remain assistant manager.

Answers: 2

Answer

Business, 22.06.2019 20:40

Which of the following is true concerning the 5/5 lapse rule? a) the 5/5 lapse rule deems that a taxable gift has been made where a power to withdraw in excess of $5,000 or five percent of the trust assets is lapsed by the powerholder. b) the 5/5 lapse rule only comes into play with a single beneficiary trust. c) amounts that lapse under the 5/5 lapse rule qualify for the annual exclusion. d) gifts over the 5/5 lapse rule do not have to be disclosed on a gift tax return.

Answers: 1

Answer

Business, 22.06.2019 22:40

Crowding out is a phenomenon focused upon most by the macroeconomists of whereby a government deficit interest rates, which in turn private investment spending. this group also believed that fiscal policy is the only thing that can lower natural unemployment. is just as effective in countering recessions as monetary policy. can be used most of the time, but monetary policy becomes a better option when velocity is fluctuating. should be used only if the central bank follows a monetary policy rule. faces problematic lags in propagating changes throughout the economy.

Answers: 3

Answer

You know the right answer?

Swiftcar Rental Company is a local rental car company that serves the Buffalo-Niagara area. The mana...

Questions