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

  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