Reference no: EM13123600
Sensitivity Analysis and LP solve
Transportaton Problem (Minimal Cost)
There are three warehouses at different cities: Tauranga, Wanganui and Wellington. They have 180, 100 and 150 tons of paper available over the next week respectively. There are four publishers in Auckland, Palmerston North, Hamilton and Wellington. They have ordered 190, 70, 120 and 50 tons of paper for the next week. The costs in dollars of transportation of one ton of paper are given in the following table:
From/To Auckland Palmerston North Hamilton Wellington
Tauranga 21 42 11 54
Wanganui 45 7 33 11
Wellington 67 14 30 1
a) Formulate this problem as an LP solve using Solver in Excel
b) From the sensitivity analysis, which warehouse site should have had more paper allocated to it at the start of the week and by how much per tonne would the overall cost of transport have been reduced?
c) How much more paper could have been allocated to this warehouse without having to resolve the LP problem?
d) Instead of using road transport from Wellington to Auckland, it has been proposed that shipping the paper might be an alternative.
Work out what price the shipping company would have to meet in order for you o have to re-run your LP to find a new optimum solution
e) If you had the option of hanging the distribution of paper stored in the Warehouses, what distribution would you have started the week with?
|
Provide recommendations to the cpa about how to select
: A CPA is interested in testing the fairness of the ending inventory balance at an audit client. He has relatively little experience using statistical sampling methods and, does not like to turn anything over to random chance.
|
|
Compute the equilibrium levels of b and g
: Compute the equilibrium levels of B and G consumed and produced in the Home country under autarky. What is the corresponding value of p?
|
|
An essay on interested to sell book
: Write an Essay on why are you interested to sell book. And why should you belong to the team if selling?
|
|
Standard hours allowed for labors
: Hart Company's labor standards call for 500 direct labor hours to produce 250 units of product. During October the company worked 625 direct labor hours and produced 300 units. The standard hours allowed for October would be:
|
|
Formulate problem as an lp solve using solver in excel
: Formulate this problem as an LP solve using Solver in Excel, From the sensitivity analysis, which warehouse site should have had more paper allocated to it at the start of the week and by how much per tonne would the overall cost of transport have..
|
|
Plotting graphs and defining functions
: I have found the number of deaths in the United States due to each medical condition in each of the following years.
|
|
Confidence interval for population using historical data
: Historical data suggests a standard deviation in the first sample of 10 and a standard deviation in the second sample of 16. Find a 95% confidence interval for the population difference.
|
|
Analyticity and differentiability
: Assume that f(z) is analytic at the origin and f(0) = first derivative of f at 0 = 0. Prove that f(z) can be written in the form f(z) = [z^2]g(z), where g(z) is analytic at z = 0.
|
|
Graphing a linear equation
: Graph the linear equation for the indicated values of the independent variable.Show this on a Graph as well as the formula
|