Explore BrainMass

Explore BrainMass

    Solver solution for minimal shipping costs

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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


    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 ...

    Solution Summary

    Excel's Solver Add In is used to set up the constraints of a minimal cost problem. The setup is explained.