Units of product must be transported from warehouses W1 and W2 to customers C1 and C2....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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.) 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.)
Expert Answer:
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these mathematics questions
-
Q1. You have identified a market opportunity for home media players that would cater for older members of the population. Many older people have difficulty in understanding the operating principles...
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
Describe the typical terrorist cell.
-
An alternator supplies a peak current of 4.68 A to a coil with a negligibly small internal resistance. The voltage of the alternator is 420-V peak at 60.0 Hz. When a capacitor of 38.0 F is placed in...
-
Explain the relationship of predetermined times to standard data.
-
The equity belongs to Paul because he is the sole owner of the business. Can you explain how the figure for equity by Thursday evening has arisen? You will need to look back at the events of Monday,...
-
American Eagle Outfitters, Inc. sells clothing, accessories, and personal care products for men and women through its retail stores. American Eagle reported the following data (in millions) for two...
-
Define Instrumentation. With neat diagram explain the instrumentation system in detail. In engineering mesurement
-
P8-5A At December 31, 2017, the trial balance of Roberto SpA contained the following amounts before adjustment. Accounts Receivable Allowance for Doubtful Accounts Sales Revenue Debit 385,000 Credit...
-
3 Suppose f(x) = and g(x) = x-8x+15 Simplify: f(x)g(x) 7 r2 _ 52 -
-
The Physical Therapy Center specializes in helping patients regain motor skills after serious accidents. The center has the following balances on December 31, 2024, before any adjustment: Accounts...
-
The total fixed cost, total variable cost, and total cost curves are shown for a company that produces custom baseball gloves. Cost (5) 800 750 700 650 500 400 950 6 OF 15 QUESTIONS COMPLETED O Type...
-
State whether each of the following payment is subject to withholding tax. If your answer is 'Yes', state the type of income and calculate the amount of withholding tax to remit the withholding tax...
-
During 2024, LeBron Corporation accepts the following notes receivable. 1. On April 1, LeBron provides services to a customer on account. The customer signs a four-month, 9% note for $5,600. 2. On...
-
The purpose of this assignment is to conduct internal and external research to determine previously attempted solutions and potential solutions that could be implemented to solve identified problem.n...
-
Determine two different Hamilton circuits in each of the following graphs. A B F G
-
Decorum, Inc., manufactures high-end ceiling fans. Their sales are seasonal with higher demand in the warmer summer months. Typically, sales average 400 units per month. However, in the hot summer...
-
Read the referenced article that fully describes the management science study summarized in the application vignette presented in Section 6.4. Briefly describe how network optimization models...
-
a. For each of the three advertising media, draw a graph of the number of sales versus the number of advertisements by plotting the sales for the five points provided by Sid Jackowitz and then...
-
True or False. The element stiffness matrices are always singular.
-
Derive the stiffness matrix of the bar element in longitudinal vibration whose cross-sectional area varies as \(A(x)=A_{0} e^{-(x / l)}\), where \(A_{0}\) is the area at the root (see Fig. 12.14)....
-
Fill in the Blank. In the finite element method, the elements are assumed to be interconnected at certain points known as ____________ .
Study smarter with the SolutionInn App