Purchase Solution

Solver solution for minimal shipping costs

Not what you're looking for?

Ask Custom Question

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.

Attachments
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