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

  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