Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Suppose that supplier 2 says that they will give a total disount of 200 dollars if they win at least 2 out of 3

In Mars Inc. case in Assignment 4, we examined procurement auction problems. For each bid (indicated by Bid MARS INC INPUT PARAMETERS Bid Id Supplier ID Bid Amount $ DECISION VARIABLES Bid chosen OBJECTIVE Total 

1) Suppose that supplier 2 says that they will give a total disount of 200 dollars if they win at least 2 out of 3 bids. What additional decision variables, linear constraints and changes to the objective function would you introduce in the yes no model to accommodate this discount?

2) Now suppose that the original model has a different additional constraint: supplier 2 should win at least 2 out of 3 bids or none. What additional decision variables, linear constraints and changes to the objective function would you introduce in the yes no model to accommodate this discount?

In Mars Inc. case in Assignment 4, we examined procurement auction problems. For each bid (indicated by Bid ID i), you defined a binary decision variable: Xi = Bid ID Supplier ID When we set our objective function to minimize the total procurement cost, the optimal solution ob- tained was as follows (the Solver model is also implemented in the excel file Mars_finished.xlsx under tabs a and b): 1 1 Bid Chosen 1 (1 if bid ID i is accepted 10 otherwise 221 3 4 5 4 0 o wi 0 HE 1 1 8 9 10 11 12 6 7 2 5 6 3 7 2 5 0 1 0 1 0 0 0 In the current allocation, Supplier 2 has submitted 3 bids but has only won 1.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Im ready to address the information youve provided about the Mars Inc procurement auction problem Ill combine my understanding of the prompt data and ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting and Reporting a Global Perspective

Authors: Michel Lebas, Herve Stolowy, Yuan Ding

4th edition

978-1408066621, 1408066629, 1408076861, 978-1408076866

More Books

Students also viewed these General Management questions

Question

Calculate the number of neutrons of 239Pu.

Answered: 1 week ago

Question

Which kinds of advertising in which media influence you most? Why?

Answered: 1 week ago