Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Units of product must be transported from warehouses W1 and W2 to customers C1 and C2. Because of contractual rights, the amount of product

  

Units of product must be transported from warehouses W1 and W2 to customers C1 and C2. Because of contractual rights, the amount of product shipped from W2 to C2 must be at least half of the amount of product shipped from W1 to C2. (For extra clarity on this last point, this means that if, for example, W1 were to ship 250 units to C2, then W2 would have to ship at least 125 units to C2.) The costs involved in shipping a unit from a particular warehouse to a particular customer are shown below, along with the supply available at each warehouse and the demand required by each customer. Transpo rtation Costs Cl C2 Supply (units) (S/unit) W1 15 10 350 W2 Demand (units) 7 13 300 175 330 Answer the following 4 questions to formulate and solve the transportation LP to minimize transportation costs while meeting constraints. 1) (1pt) Write down the list of decision variables. You'll need to introduce the variables, and provide a brief explanation. (For example, on one of the problems in the HW, you had to decide how many full-size ovens and how many compact ovens to produce. The variables would be F and C, where F represents the number of full-size ovens produced, etc. The letter/symbol you choose is arbitrary, but the explanations of the variables are not.) 2) (1pt) Write down the objective function, as a mathematical expression in term of the variables that you wrote above. Here you are not coding the Excel cells, but instead writing a mathematical expression, i.e. it's what you'd write on paper if you were writing the objective function. 3 (2 pts) Write down all applicable constraints as mathematical expressions in terms of the variables in part (a). Here you can use = for "greater than or equal." Your answer is not a coded cell but is instead a list of mathematical expressions, i.e. it's what you'd write on paper if you were writing the constraints. 4) (2pt) What is the minimum transportation cost achievable while still satisftying all constraints? (To receive full credit, you must properly code your workbook and solve this with Excel Solver.)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Management Science A Modeling And Cases Studies Approach With Spreadsheets

Authors: Frederick S. Hillier, Mark S. Hillier

5th Edition

978-0077825560, 78024064, 9780077498948, 007782556X, 77498941, 978-0078024061

More Books

Students also viewed these Mathematics questions

Question

Describe the typical terrorist cell.

Answered: 1 week ago