Question: Using a linear programming framework and the data from case Exhibit 1, formulate and solve the problem of finding the cost-minimizing set of bids that

Using a linear programming framework and the data from case Exhibit 1, formulate and solve the problem of finding the cost-minimizing set of bids that meet Mars' business requirements and determines the winning suppliers. (Ignore the requirement that first bid wins in the case of ties.

Q2. In hypothesis, Mr. Ng wants to compare the solution in Q1 to other solutions in different conditions. If the following constraints are newly set in place, answer how much different is going to be from the original cost respectively. 1. If Mr. Ng ignores the condition "Mars did not want to become dependent on just a few suppliers" and rather chooses as a few suppliers as possible. 2. If Mr. Ng allows each supplier only to win at most one bid. Show 2 different calculation sheets and discuss.

Items in the auction (all items can be oversupplied): Mars display boxes: 1,000 large 2,500 medium 4,000 small . Exhibit 1 ILLUSTRATIVE EXAMPLE OF A MARS PACKAGING AUCTION . M&M display boxes: 800 large 1,500 medium 2,500 small Snickers display boxes: 400 large 750 medium 1,200 small 3 Musketeers display boxes: 100 large 100 medium 50 small First Round Bids received: 1:05 p.m. Supplier 1 bids $2,050 to supply all Mars display boxes. 1:06 p.m. Supplier 2 bids $350 to supply Snickers small display boxes. 1:10 p.m. Supplier 3 bids $1,199 to supply all large display boxes. 1:11 p.m. Supplier 1 bids $220 to supply Snickers large, and all 3 Musketeers display boxes. 1:14 p.m. Supplier 4 bids $4,639 to supply everything. 1:20 p.m. Supplier 2 bids $199 to supply 3 Musketeers medium and small display boxes. 1:26 p.m. Supplier 5 bids $1,199 to supply all M&M, and 3 Musketeers medium and small display boxes. 1:35 p.m. Supplier 6 bids $1,350 to supply Mars, M&M and 3 Musketeers small display boxes. 1:40 p.m. Supplier 3 bids $350 to supply Snickers medium display boxes. 1:41 p.m. Supplier 7 bids $2,200 to supply Mars and M&M large and medium display boxes. 1:52 p.m. Supplier 2 bids $999 to supply M&M medium and small display boxes. 1:59 p.m. Supplier 5 bids $1,700 to supply all small display boxes. 2:00p.m. Auction first round closes.

Step by Step Solution

★★★★★

3.44 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To formulate and solve the problem of finding the costminimizing set of bids that meet Mars business requirements and determine the winning suppliers ... View full answer

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!

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...

The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...

In a recombinant protein expression process the host microorganism, Pichia pastoris needs to be separated from the culture supernatant after production. A pilot scale bioreactor with a working volume...

The cost of goods sold computations for Target Company and Caesar Company are shown below. Instructions(a) Compute inventory turnover and days in inventory for each company.(b) Which company moves...

Why is transparency important in a market-based financial system? Why is it less important in a bank-based system? AppendixLO1

What are the degrees of freedom associated with ????e.

In exercise 18 the data on price ($) and the overall score for six stereo headphones tested by Consumer Reports were as follows (Consumer Reports website, March 5, 2012). Brand _______________ Price...

On July 1, 2018, Jordie Equipment Dealer issued $560,000 of 9% bonds payable that mature in five years. These bonds were issued at face value and pay interest each June 30 and December 31 Each...

f. If there were $800 of dividends declared but not yet received by Maloney Co's from their investments, what adjustment would need to be made to Maloney's revenue?

Instructions Jesse and Tim forma partnership by combining the assets of their separate businesses. Jesse contributes accounts receivable with a face amount of $15000 and equipment with a cost of...

The charter for KWVN TV, Inc. authorizes the company to issue 100,000 shares of $3, no-par preferred stock and 500,000 shares of common stock with $1 par value. During its start-up phase, KWVN -TV...

A firm CEO assumes that managers are agents who are likely to engage in self-serving opportunistic activities if left to their own devices. Which debate supports this perspective? a....

2. Your group will identify a Department of Tourism (DOT)-accredited tourism and hospitality establishment in your area. Through observation and interview, you will validate the presence or absence...

Lorch Company prepares monthly cash budgets. Relevant data from operating budgets for 2021 are as follows: January February Sales $352,000 $398,000 Direct materials purchases 121,000 110,000 Direct...

AirQual Test Corporation provides on-site air quality testing services. The company provided the following cost formulas and actual results for the month of February: 09 Fixed Component per Month...

Jones, Inc. has identified six activity cost pools: receiving, forming, assembling, testing, painting, and packing \& shipping product development, and facility management for the manufacturing...

In a certain school district, 3% of the faculty use none of their sick days in a school year. Find the probability that 5 faculty members selected at random used no sick days in a given year.

Decorum, Inc., manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summer months. Typically, sales average 400 units per month. However, in the hot summer...

a. To simplify the analysis, assume for now that there is virtually no turnaround time between flights so the next flight can begin as soon as the current flight ends. (If an immediate next flight is...

Formulate and solve a spreadsheet model for the maximum flow problem shown at the top of the next column, where node A is the source, node F is the sink, and the arc capacities are the numbers in...

Some parts of California are particularly earthquake-prone. Suppose that in one metropolitan area, 25% of all homeowners are insured against earthquake damage. Four homeowners are to be selected at...

=+62. Suppose that two components with reliabilities R1(t) and R2(t) are connected in series, but that

=+b. Then prove it in the more general case, where the two components may or may not function independently of one another. 1 2 3