Solver solution for minimal shipping costs
Not what you're looking for?
SE Appliances manufactures refrigerators in Richmond, Charlotte, and Atlanta. Refrigerators then must be shipped to meet demand in Washington, New York, and Miami. The table below lists the shipping costs, supply, and demand information.
How many units should be shipped from each plant to each retail store in order to minimize shipping costs?
Your response should be at least 200 words in length. You are required to use at least your textbook as source material for your response. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations.
Purchase this Solution
Solution Summary
Excel's Solver Add In is used to set up the constraints of a minimal cost problem. The setup is explained.
Solution Preview
Hello Student,
To help you toward completing this solution, I am providing a numeric solution in Excel using Solver and explanations to support completing your 200-wrod essay.
Note that Solver is a free Add-In and may need to be enabled in your installation of Excel.
Attachment temp.png shows Solver setup and the final solution, in case there is any issue loading in Excel. Note that initial parameters of the ...
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Know Your Linear Equations
Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.
Multiplying Complex Numbers
This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Probability Quiz
Some questions on probability