Answers Market
  • Our services
    • How it works.
  • How it works.
  • Frequently asked questions
  • Guarantees
  • My account
  • Order now
Order Now
Mathematics

Integer Linear Programming Question: I do need to see the Excel and Solver solutions so I can figure out how to solve this.

2 min read
Posted on 
March 14th, 2023
Home Mathematics Integer Linear Programming Question: I do need to see the Excel and Solver solutions so I can figure out how to solve this.

Rowntown Cab Company has 70 drivers that it must schedule in three 8-hour shifts. However, the demand for cabs in the metropolitan area varies dramatically according to time of the day. The slowest period is between midnight and 4:00 A.M. the dispatcher receives few calls, and the calls that are received have the smallest fares of the day. Very few people are going to the airport at that time of the night or taking other long distance trips. It is estimated that a driver will average $80 in fares during that period. The largest fares result from the airport runs in the morning. Thus, the drivers who sart their shift during the period from 4:00 A.M. to 8:00 A.M. average $500 in total fares, and drivers who start at 8:00 A.M. average $420. Drivers who start at noon average $300, and drivers who start at 4:00 P.M. average $270. Drivers who start at the beginning of the 8:00 P.M. to midnight period earn an average of $210 in fares during their 8-hour shift.
To retain customers and acquire new ones, Rowntown must maintain a high customer service level. To do so, it has determined the minimum number of drivers it needs working during every 4-hour time segment- 10 from midnight to 4:00 A.M. 12 from 4:00 to 8:00 A.M. 20 from 8:00 A.M. to noon, 25 from noon to 4:00 P.M., 32 from 4:00 to 8:00 P.M., and 18 from 8:00 P.M. to midnight.
a. Formulate and solve an integer programming model to help Rowntown Cab schedule its drivers.
b. If Rowntown has a maximum of only 15 drivers who will work the late shift from midnight to 8:00 A.M., reformulate the model to reflect this complication and solve it
c. All the drivers like to work the day shift from 8:00 A.M. to 4:00 P.M., so the company has decided to limit the number of drivers who work this 8-hour shift to 20. Reformulate the model in (b) to reflect this restriction and solve it.

Don't use plagiarized sources. Get Your Custom Essay on
Integer Linear Programming Question: I do need to see the Excel and Solver solutions so I can figure out how to solve this.
Just from $13/Page
Order Essay

Order an Essay Now & Get These Features For Free:

Turnitin Report

Formatting

Title Page

Citation

Outline

Place an Order
Share
Tweet
Share
Tweet
Calculate the price
Pages (275 words)
$0.00
Answers Market
Company
  • Frequently asked questions
  • How it works.
  • Guarantees
Legal
  • Guarantees
  • Money Back Guarantee
  • Revision policy
  • Terms and conditions
  • Plagiarism free guarantee
  • Fair use policy
  • Privacy Policy
How Our Service is Used:
Answers Market essays are NOT intended to be forwarded as finalized work as it is only strictly meant to be used for research and study purposes. Answers Market does not endorse or condone any type of plagiarism.
Subscribe
No Spam
  • How it works.
© 2023 Answers Market. All rights reserved.
Answers Market will be listed as ‘Answers Market’ on your bank statement.