********************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?