Develop a linear programming formulation which includes

Assignment Help Basic Statistics
Reference no: EM13580697

Question: Suppose an auto company has three plants in cities A, B and C and two major distribution centers in D, E, F and G. The capacities of the three plants during the next quarter are 100, 200 and 150 cars. The quarterly demands of the four distribution centers are 80, 90, 120 and 160 cars. The transportation costs (which depend on the mileage, transport company etc) between the plants and the distribution centers is as follows:

Cost Table

Dist Center D

Dist Center E

Dist Center F

Dist Center G

Plant A

4

8

10

9

Plant B

10

4

15

1

Plant C

5

12

11

10

Answer the following questions:

(a) Develop a Linear Programming Formulation which includes decision variables, objective function and constraints. State what your decision variables, objective function and constraints stand for.

(b)  Solve this problem with Excel-solver add-in. Determine which plant should supply how many cars to which outlet so that the total cost is minimum.  Copy and paste the Excel Output to show your work.

Reference no: EM13580697

Questions Cloud

Swatville sluggers is a small manufacturer of baseball bats : swatville sluggers is a small manufacturer of baseball bats made from highquality 3-by-3-inch blocks of wood. once the
By how much would audience contact increase if an extra 100 : the westchester chamber of commerce periodically sponsors public service seminars and programs. currently promotional
Show that if a surface is given in the forn zx ythen the : show that if a surface is given in the forn zx ythen the measure of curvature k can be expressed as kzxxzyy - zxy21 zx2
Use chi-square test to test if the two attributes : 1. distinguish between classification and tabulation of data. what are the types of classification of data?2. calculate
Develop a linear programming formulation which includes : question suppose an auto company has three plants in cities a b and c and two major distribution centers in d e f and
1 write a one page paper about the educational : 1. write a one page paper about the educational preparedness of a nurse. what kind of education does a person needs to
Calculate the labour force participation rate labour : 1. suppose the economy is described by the following behavioural equationsconsumption c 1500.8yd where yd disposable
At the 001 level of significance use the five step p-value : homers pizza which predominantly delivers within the certain distance has just changed its delivery process in an
Distinguish between classification and tabulation of data : 1. distinguish between classification and tabulation of data. what are the types of classification of data?2. calculate

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd