Question: Question 2) (25 points) Consider the following ride matching problem where at a given time of the day In a region, we have 3 customers

Question 2) (25 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 profit of matching each customer and each driver is given in the table below. M uriver 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 definition of the decision variables: b) Use Excel solver to solve this problem. What is the maximum fotal profit? Which Driver is not assigned to any customer? Answer: Maximum total profit: 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!

Quetion 3 (45 poisty conoder a tranuportation problen. There ere a set of uppless and a set of We wart to detemine a shoment pun sa uasty customer' demand in the month of Apri, We do not huve demand...

Question 2) (25 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...

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...

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...

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...

Question 3) (20 points) Consider the following ride matching problem where at a given time of the day in a region, we have 4 customers and 3 drivers. We want to match drivers to customers to maximize...

Question 2 ) ( 2 5 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...

XYZ uses a standard costing system in the manufacture of its single product. The 34,000 units of direct materials purchased and used cost $105,000, and 2 units of direct materials are required to...

What are the differences between quantitative and qualitative factors that may be present in a decision model?

which interpersonel skill involves leading with consistent values and compassion

2. The force of interest 8 is a function of time and at any time t, measured in years, is given by the formula: 8(t) = 0.02 +0.0020 8(t) = 0.03 +0.005t Osts5 5 st s 10 a) Calculate the discount...