Cans | ||||
Large | Medium | Small | Maximum | |
Metal (kg)/batch | 9 | 6 | 5 | 120 |
Machines’ Time (hr)/batch | 4.4 | 4.2 | 4 | 90 |
Profit/batch | $50 | $45 | $42 |
Let L = number of Large cans produced
M = number of Medium cans produced
S = number of Small cans produced
Formulate and solve for the recommended production quantities for all the three different types cans by maximizing the profit. Use Excel solver to find your answers. Report the optimal value of L
Transportation Costs ($) | ||||
Factories/Warehouse (W) | W1 | W2 | W3 | |
Orlando | 4 | 3 | 7 | |
Tampa | 7 | 6 | 4 | |
Port St. Lucie | 3 | 6 | 6 | |
The factory at Orlando has a capacity of 15,000 units.
The factory at Tampa has a capacity of 18,000 units.
The factory at Port St. Lucie has a capacity of 8,000 units.
The requirements of the warehouses are:
Warehouse | Requirement (Bottles) |
W1 | 18,000 |
W2 | 12,000 |
W3 | 5,000 |
How many decision variables do you have in this problem?
6 points
How many constraints do you have in this problem? (ignore the sign constraints)
What is the optimal minimum cost for this problem? Use Excel Solver to find your solution.
What is the optimal value for the route Orlando – W1, that is how many units should be sent from Orlando to location W1 in order to minimize the total transportation cost?
What is the optimal value for the route Orlando – W2, that is how many units should be sent from Orlando to location W2 in order to minimize the total transportation cost?
What is the optimal value for the route Tampa – W1, that is how many units should be sent from Tampa to location W1 in order to minimize the total transportation cost?
What is the optimal value for the route Tampa – W2, that is how many units should be sent from Tampa to location W2 in order to minimize the total transportation cost?
What is the optimal value for the route Port St. Lucie- W3, that is how many units should be sent from Port St. Lucie to location W3 in order to minimize the total transportation cost?
Distributor | |||
Plant | A | B | C |
P1 | 0.8 | 0.5 | 1 |
P2 | 0.7 | 0.65 | 0.8 |
P3 | 0.5 | 0.45 | 0.7 |
Attached is the Sensitivity report for this problem. What is the optimal minimized cost?
What is the new minimum cost of transportation if we increase the demand of distributor B to be 2600. Use the shadow price for Demand B in the constraints table to estimate the new cost.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more
Recent Comments