Determine hernandez optimal shipping quantities

Assignment Help Basic Statistics
Reference no: EM13506593

Marc Hernandez's construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandez's needs, but shipping cost differ from location to location. The following table summarize the transportation costs (per ton):

To:

From

Job 1

Job 2

Job 3

Central pit

$9

$8

$7

Rock pit

$7

$11

$6

Acme pit

$4

$3

$2

The job requirements (tons) for the three jobs are 2500, 3750, and 4850, respectively. The tonnage allowance at the three pits are 3000, 4000, and 6000 tons for Central, Rock and Acme, respectively. Hernandez's optimization problem is to find the optimal shipping quantities so as to minimize total transportation costs. Formulate the problem and solve it using Solver. Report the minimum transportation cost.

Set up LP models (decision variables, objective function, and constraints) first. Then solve using a spreadsheet model.

Determine Hernandez's optimal shipping quantities so as to minimize total transportation costs.

Reference no: EM13506593

Questions Cloud

Evaluate the heat capacity of the calorimeter : A 21.8 g sample of ethanol (C2H5OH) is burned in a bomb calorimeter, according to the following reaction. If the temperature rises from 25.0°C to 62.3°C, determine the heat capacity of the calorimeter. The molar mass of ethanol is 46.07 g/mol.
Diamonds and hearts are red and clubs : Diamonds and Hearts are red and Clubs and Spades are black. Suppose you randomly select three cards from the deck. The outcome of interest is the colour of each of the selected cards.
Calculate the mce : Ventris Company found that one of its manufacturing cells had actual cycle time of 15 minutes per unit. The theoretical cycle time for this cell was nine minutes per unit.
Explain how many moles of hf must be present a ph : How many moles of HF (ka= 6.8 X 10^-4) must be present in 0.200L to form a solution with a pH of 3.25
Determine hernandez optimal shipping quantities : Determine Hernandez's optimal shipping quantities so as to minimize total transportation costs.
Explain the best oxidizing agent and the best reducing agent : Consider the following species: Ca, Br1-, Fe2+ , Cu+, Co3+. Li+. List the oxidizing agents. List the reducing agents. (Some could be both.) Which is the best oxidizing agent? Which is the best reducing agent
What is the speed of the resulting ball of clay : A 40.0g ball of clay traveling east at 4.50m/s collides and sticks together with a 40.0g ball of clay traveling north at 5.50m/s
The number of nonconforming springs in a batch : The number of nonconforming springs in a batch,denoted as X, is a binomial random variable.
What are the taxpayers options for the next year : What would you recommend this client to do next year based on the options identified - what are the taxpayers options for the next year? Identify options for each tax issue listed.

Reviews

Write a Review

Basic Statistics Questions & Answers

  Appropriate inference method

If Weight 1 is the weight (in pounds) of a random sample of five men who were accepted as models, and Weight 2 is the weight (in pounds) of a random sample of five men who were rejected as models, which of the following is the appropriate inferenc..

  Produce a model to predict employee satisfaction

What factors determine how happy workers are in their jobs and use the following data and multiple regression to produce a model to predict employee satisfaction

  Role of researcher in regression analysis

At the heart of quantitative research is regression analysis. A regression model simply measures the association of two variables - variation: the dependent variable's observed value

  A partial anova table

Their resting heart rates were measured. A partial ANOVA table is given.

  Find mean and standard deviation for number of households

Assuming that this procedure yields a binomial distribution, find the mean and the standard deviation for the number of households in this sample who have cable TV.

  Oc curve for sampling plan

What are the probabilities of accepting lots that are 10 percent, 20 percent, and 30 percent defective? Estimate the probability of accepting a lot that is 15 percent defective.

  Estimate standard error for estimated slope coefficient

The "t-statistic" for testing whether the slope parameter was unity or not was -3.6. What is the estimated standard error for the estimated slope coefficient?

  Find sample size suggested by newspaper article statement

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

  Estimate the amount of growth

In trying to estimate the amount of growth that took place in the trees recently planted by the county parks commission

  Normal distribution in the spine bone density of women

Is spine bone density is normally distributed in young women with a mean of 1.0 g/cm 2 and a standard deviation of .10 g/cm 2 , then how many young women out of 100 would you expect to have bone densities less than .85 g/cm 2 ?

  Compute the value of the test statistic

State the null hypothesis and the alternative hypothesis and compute the value of the test statistic and what is your decision regarding the null hypothesis?

  Consequences of making a type one error

In the context of this scenario, what would be the consequences of making a Type I error?

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