Econo-tankers for short run-low and demand routes

Assignment Help Basic Statistics
Reference no: EM1396409

I need to know what the constraints our? for this problem so i can solve it by excel solver. The problem is: The Two-Rivers Oil Company near Pittsburgh transports gasoline to its distributors by truck. The company recently contracted to supply gasoline distributors in souther Ohio, and it has 600,000 available to spend on the necessary expansion of its fleet of gasoline tank trucks. Three models of gasoline tank trucks are available. Super Tank, Regular Line, Econo-Tanker. Super Tank capacity gallons are 5,000 purchase cost is 67,000 and Monthly operating cost are 550. Regulare capacity gallons are 2,500 purchase caost is 55,000 and the monthly operating cost is 425. Econo-Tanker capacity gallons are 1000 purchase cost is 46,000 and the monthly operating cost is 350. The company estimates that the monthly demand for the region will be 550,000 gallons of gasoline. Because of the size and speed differences of the trucks the number of delieveries or round trips possible per month for each truck model will vary. Trip capacities are estimated at 15 trips per month for the super tanker, 20 trips per month for the regular line, and 25 trips for the Econo Tanker. Based on maintenance and driver availability the firm does not want to add more than 15 new vehicles to its flee. In, addition, the company has decided to purchase at least three of the new Econo-Tankers for use on short-run, low-demand routes. As a final constraint, the conpany deos not want more than half the new models to be Super Tankers.

Reference no: EM1396409

Questions Cloud

Determine the volume of plasmid dna in ul : The final elution of your miniprep plasmid DNA has a concentration of 250 ng/uL. You need to load 500 ng on an agarose gel to be able to see the DNA.
Multiple regression models using excel : Managers at Beta Technologies, Inc., have collected current annual salary figures and potentially related data for a random sample of 52 of the company's full-time employees.
Identify key problems blockbuster having success : Identify the key problems Blockbuster is having with achieving success with its recent acquisition of Movie link. Provide specific recommendations on Explain how Blockbuster should rectify these problems.
Interpreting regression output : A researcher used stepwise regression to create regression models to predict BirthRate (births per 1,000) using five predictors
Econo-tankers for short run-low and demand routes : In, addition, the company has decided to purchase at least three of the new Econo-Tankers for use on short-run, low-demand routes. As a final constraint, the conpany deos not want more than half the new models to be Super Tankers.
Portal for selective export of mrna out of the nucleus : What is the portal for selective export of mRNA out of the nucleus? When microtubules grow out of a centrosome, which end is oriented away from the centrosome?
Evaluate the effect of global factors : Explain how does the number of data points available affect confidence intervals? Evaluate the effect of global factors also the role of competitive intelligence on your previous analysis.
Completing regression analyses : Consider the following data on 20 chemical reactions, with Y = chromatographic retention time (seconds) and X = molecular weight (gm/mole).
Estimate interview in test audience screening panel : Assume you are participating in the test audience screening panel which should estimate Rachel Reid interview video, "Women in Afghanistan Turn to Self-Immolation Over Abuse.

Reviews

Write a Review

 

Basic Statistics Questions & Answers

  To test the claim using chi-square test for goodness of fit

Conduct a statistical test to determine if the sample is representative of the population.

  Tree diagram for a probability experiment

Tree diagram for a probability experiment - Identify the sample space of the probability experiment and determine the number of outcomes in the event. Show a tree diagram if it is appropriate.

  Probability of drawing red and black balls

If an urn is selected at random and a ball is drawn, find the probability it will be red.

  Solving question using normal distribution having mean

Normal distribution has mean of 80 and standard deviation of 14. Find out the value above which 80 percent of values will occur.

  Calculate the test statistic value for population mean

A sample of 81 business managers on the West Coast had an average breakfast cost of $7.65. 13. At a = 0.05, what is the test value?

  Distribution with density function

Suppose x follows a distribution with density function: f(x)=C*abs(x-2), 0 =

  Expectation and variance of random variable

Expectation and variance of a random variable and let X be a random variable with the following probability distribution:

  Hypotheses test for mean of the population

Formulate the hypotheses to test to see if the mean of the population is at least 12 ounces.

  Probability for defective random sample

Suppose 1.5 percent of the antennas on new Nokia cell phones are defective. For a random sample of 200 antennas, find the probability that:

  Probability of student-sophomore and chemistry major

43 students, 22are sophomores, 28are chemistry majors, and 11are neither. What are the probability that the student is both a sophomore and a chemistry major?

  Estimating the true proportion of students

To estimate the true proportion of students who abstain from alcohol at LBCC, you will need to take a simple random sample.

  Power calculations with single sample z test

Why do we do power calculations with single sample z test? A) Because we can use Z area tables to calculate the power. B) Because comparing a sample mean against a population mean is very powerful

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