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.

User Account

All Pages