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.© BrainMass Inc. brainmass.com March 5, 2021, 1:42 am ad1c9bdddf
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 ...
Excel's Solver Add In is used to set up the constraints of a minimal cost problem. The setup is explained.