Question: In Mars Inc. case in Assignment 4, we examined procurement auction problems. For each bid (indicated by Bid ID 2'), you defined a binary decision

In Mars Inc. case in Assignment 4, we examinedIn Mars Inc. case in Assignment 4, we examined
In Mars Inc. case in Assignment 4, we examined procurement auction problems. For each bid (indicated by Bid ID 2'), you defined a binary decision variable: X _ 1 if bid ID 2' is accepted 1 0 othenNise 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): BidID 123456789101112 Supplier|0123142563725 BidChosenllOlOOlOllO 0|0 In the current allocation, Supplier 2 has submitted 3 bids but has only won 1. MARS INC INPUT PARAMETERS Bid Id UI J 10 11 12 NN W 10 W W Supplier ID 7 2 un Bid Amount 2,050 $ 350 S 1,199 S 220 $ 4,639 S 199 S 1,199 S 1,350 S 350 $ 2,200 999 S 1,700 DECISION VARIABLES Bid chosen 1 1 0 1 0 0 1 0 1 0 0 0 OBJECTIVE Minimize Total Procurement Cost $ 4,169 CONSTRAINTS Num procured >= 1 Mars M S M&M M 1 1 PPPPPPPPPPPP Snickers M 1 S 1 L 1 3M M H H H H 1

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!