********************USE ONLY EXCEL SOLVER************* ********************USE ONLY EXCEL SOLVER************* **********
Posted: Fri May 20, 2022 7:57 am
********************USE ONLY EXCEL
SOLVER*************
********************USE ONLY EXCEL
SOLVER*************
********************USE ONLY EXCEL
SOLVER*************
********************USE ONLY EXCEL
SOLVER*************
A new rideshare company “Sany” has just entered the Boston
market. The company offers 2 types of rideshare services, a shared
service (called SanyShared) and a non-shared service (called
SanyPersonal). In addition, the company also offers a food delivery
service, delivering food from merchant restaurants to customers
(called SanyFood).
A Sany driver would like your help in figuring out how many of
each service he should accept. A SanyShared request takes 30
minutes to complete, and pays $5 flat. A SanyPersonal request takes
40 minutes to complete, and pays $21 flat. A SanyFood request takes
20 minutes to complete, and pays you $16.
Suppose that Sany has imposed a restriction on the number of
requests each driver can take to protect other drivers using the
platform. The number of requests a driver accepts for any service
should be an integer number. The maximum number of requests a
driver can take in one day is 20. Additionally, a driver can only
work for a total of 8 hours in the day due to a state employment
law. Formulate a linear program objective function that maximizes
earnings.
Given the success of the Sany brand in Boston, the company has
also launched a package pickup-dropoff service called SanyCourier.
Each SanyCourier request takes 20 minutes to complete, and pays $18
per request. Given this new type of request, reformulate your
optimization model to account for this.
Question: What is the maximum amount of revenue the driver can
generate in one day?
SOLVER*************
********************USE ONLY EXCEL
SOLVER*************
********************USE ONLY EXCEL
SOLVER*************
********************USE ONLY EXCEL
SOLVER*************
A new rideshare company “Sany” has just entered the Boston
market. The company offers 2 types of rideshare services, a shared
service (called SanyShared) and a non-shared service (called
SanyPersonal). In addition, the company also offers a food delivery
service, delivering food from merchant restaurants to customers
(called SanyFood).
A Sany driver would like your help in figuring out how many of
each service he should accept. A SanyShared request takes 30
minutes to complete, and pays $5 flat. A SanyPersonal request takes
40 minutes to complete, and pays $21 flat. A SanyFood request takes
20 minutes to complete, and pays you $16.
Suppose that Sany has imposed a restriction on the number of
requests each driver can take to protect other drivers using the
platform. The number of requests a driver accepts for any service
should be an integer number. The maximum number of requests a
driver can take in one day is 20. Additionally, a driver can only
work for a total of 8 hours in the day due to a state employment
law. Formulate a linear program objective function that maximizes
earnings.
Given the success of the Sany brand in Boston, the company has
also launched a package pickup-dropoff service called SanyCourier.
Each SanyCourier request takes 20 minutes to complete, and pays $18
per request. Given this new type of request, reformulate your
optimization model to account for this.
Question: What is the maximum amount of revenue the driver can
generate in one day?