Question: INSTRUCTIONS: For the mathematical models either use Word Equations, or write down the formulas on a paper, take a photo you MUST upload the word

INSTRUCTIONS: For the mathematical models either use Word Equations, or write down the formulas on a paper, take a photo you MUST upload the word file and an Excel Workbook. For the optimization problems, you must use the Excel solve

INSTRUCTIONS: For the mathematical models either use Word Equations, or write down

Question 2) (30 points) Consider the following ride matching problem where at a given time of the day in a region, we have 3 customers and 4 drivers. We want to match drivers to customers to maximize the total profit of matching. The prot of matching each customer and each driver is given in the table beiow. A driver can be assigned to at most one customer, and a customer can be assigned to at most one driver. a} Formulate a mathematical optimization model to maximize the total profit for this problem. Clearly specify decision variables, objective function, and constraints. Answer: Notation and denition of the decision variables: Objective function: Constrain: b) Use Excel solver to solve this problem. What is the maximum total profit? Which Driver is not assigned to any customer? Answer: Maximum total prot: Driver that is not assigned

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!