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

  Recognize at least two relevant and two irrelevant costs

Irrelevant costs associated with the decision to sign an act (make/own) as opposed to just distributing one (buy/lease)? Identify at least 2 relevant and 2 irrelevant costs.

  Find the sample size suggested by interviewing all voters

Either direction from what would have been obtained by interviewing all voters in the United States. Find the sample size suggested by this statement.

  Using of anova instead of t-tests

Describe the circumstances under which you should use ANOVA instead of t tests, and explain why t tests are inappropriate in these circumstances. Find a peer-reviewed article that reflects these circumstances, describe the research conducted (i.e...

  Profit earned in the manufacture

If profit earned in the manufacture and sale of X units of a product is P dollars where: P = 10X - 0.001X2

  One measure of the risk or volatility of an individual

one measure of the risk or volatility of an individual stock is the standard deviation of the total return capital

  Tally marks and frequency table

The following data represent glucose blood levels(mg/100ml) after a 12 hour fast for random sample of 70 women: Employ 6 classes and make a frequency distribution table.

  Confidence interval for the proportion-type of discomfort

Construct a 95% confidence interval for the proportion of all those who experience some type of discomfort.

  A sample of 3 items is selected at random from a box

a sample of 3 items is selected at random from a box containing twenty items of which 4 are defective. the expected

  Dress habits-probability research

At a board meeting of 20 businessmen, all of whom wear ties, what is the probability that:

  Alpha leval and p-level

Explain in managerial terms what is meant by "use an alpha level = .05." Do you agree with her suggestion? If so, explain why. If not, explain why and indicate the alpha level you would use instead.

  Find what sense each value can be considerd typical

Measure of average you might be inclined to report and in what sense each value can be considerd typical. (A) as vice president responsible for collective burgaining.(B) as the president the employee burgaining unit.

  Determine whether there are any significant differences

Use an ANOVA with α=.05 to determine whether there are any significant differences among the three treatment means. (both by hand and in PASW), for the hand version of problem.

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