The per-case transportation costs

Reference no: EM13862942

A logistics specialist for Charm City Inc. must distribute cases of parts from 3 factories to 3 assembly plants. The monthly supplies and demands, along with the per-case transportation costs are:

Assembly Plant

1 2 3 Supply

__________________________________________________________________

A 6, 10, 14, 200

Factory B 2, 2, 6, 400

C 2, 8, 7, 200

__________________________________________________________________

Demand 220, 320, 200

The specialist wants to distribute at least 100 cases of parts from factory B to assembly plant 2.

(a) Formulate a linear programming problem to minimize total cost for this transportation problem.

(b) Solve the linear programming formulation from part (a) by using either Excel or QM for Windows. Find and interpret the optimal solution and optimal value. Please also include the computer output with your submission.

The following questions are mathematical modeling questions. Please answer by defining decision variables, objective function, and all the constraints. Write all details of the formulation. Please do NOT solve the problems after formulating.

Reference no: EM13862942

Questions Cloud

Find the mean and standard deviation for number of facebook : According to data collected, 0.6% of Facebook users are under 13 (the site is restricted to users 13 and older) in a simple random sample of 500 children under the age of 13, find the mean and standard deviation for number of Facebook users

Unbiased estimate of the population standard deviation : The reason sample variance has a divisor of n-1 rather than n is that it makes the sample standard deviation an unbiased estimate of the population standard deviation.

Determining the decision variables : Determining(a) The decision variables (b) Determine the objective function. What does it represent?(c) Determine all the constraints. Briefly describe what each constraint represents.Note: Do NOT solve the problem after formulating.

What were the primary sources of conflict in this society : What were the primary sources of conflict in this society. How did the system of lord and vassal relations serve to provide some political stability in a society with a very small or almost non-existent state/government

The per-case transportation costs : A logistics specialist for Charm City Inc. must distribute cases of parts from 3 factories to 3 assembly plants. The monthly supplies and demands, along with the per-case transportation costs are: Assembly Plant 1 2 3 Supply

What do you believe is the logic behind warhols repetition : What do you believe is the logic behind Warhol's repetition of the image? How does his theme relate to the mass media outlets used to distribute the image of Marilyn Monroe? Justify your respond.

Estimate the average daily pollution in lake erie : Suppose that we wish to estimate the average daily pollution in Lake Erie. The daily yield, recorded for n = 50 days, produced a mean and standard deviation equal to y = 871 tons and s = 21 tons, respectively.

Define the following predicate p(x,y,z) for naturals x and y : Define the following predicate P(x,y,z) for naturals x and y and positive naturals z. If x = z, then P(x,y,z) is false.

Evaluate the various persuasive forms of leadership : Evaluate the various persuasive forms of leadership.

User Account

All Pages