Suppose that you are an analyst for Global, Inc. You have three factories that supply a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suppose that you are an analyst for Global, Inc. You have three factories that supply a single product to three warehouses. Your goal is to find the minimum cost solution that meets the following constraints and costs. You may solve this problem with any computer tool available to you, including Palisade Decision Tools Evolver or Excel Solver. Factories Shipping Cost per Unit from Factory to Warehouse Factory 1 has capacity of 5,000 units. Warehouse 1 Warehouse 2 Warehouse 3 Factory 2 has capacity of 7,000 units. Factory 1 3 1 999 Factory 3 has capacity of 3,000 units. Factory 2 4 2 4 Factory 3 999 Warehouses Warehouse 1 has demand of Note: "999" depicts a route that is impractical to implement. 7,000 units. Warehouse 2 has demand of 3,000 units. Warehouse 3 has demand of 5,000 -7,000 5,000 units. Warehouse Factory 1 1 7,000 -3,000 Warehouse Factory 2 2 3,000 -5,000 Factory 2 Warehouse 3 1. Increase the capacity of Factory 1 from 5,000 to 6,000. Rerun the linear programming. What effect does this have on the total cost and the optimal solution? 2. Return the capacity of Factory 1 to 5,000 and increase capacity of Factory 2 to 8,000. Rerun the linear programming. What effect does this have on the total cost and the optimal solution? What are the practical implications to a supply chain manager from this experiment? Describe any assumptions made in this model. 3. Explain the managerial implications of your solution. 4. Explain the formulation in business terms. Suppose that you are an analyst for Global, Inc. You have three factories that supply a single product to three warehouses. Your goal is to find the minimum cost solution that meets the following constraints and costs. You may solve this problem with any computer tool available to you, including Palisade Decision Tools Evolver or Excel Solver. Factories Shipping Cost per Unit from Factory to Warehouse Factory 1 has capacity of 5,000 units. Warehouse 1 Warehouse 2 Warehouse 3 Factory 2 has capacity of 7,000 units. Factory 1 3 1 999 Factory 3 has capacity of 3,000 units. Factory 2 4 2 4 Factory 3 999 Warehouses Warehouse 1 has demand of Note: "999" depicts a route that is impractical to implement. 7,000 units. Warehouse 2 has demand of 3,000 units. Warehouse 3 has demand of 5,000 -7,000 5,000 units. Warehouse Factory 1 1 7,000 -3,000 Warehouse Factory 2 2 3,000 -5,000 Factory 2 Warehouse 3 1. Increase the capacity of Factory 1 from 5,000 to 6,000. Rerun the linear programming. What effect does this have on the total cost and the optimal solution? 2. Return the capacity of Factory 1 to 5,000 and increase capacity of Factory 2 to 8,000. Rerun the linear programming. What effect does this have on the total cost and the optimal solution? What are the practical implications to a supply chain manager from this experiment? Describe any assumptions made in this model. 3. Explain the managerial implications of your solution. 4. Explain the formulation in business terms.
Expert Answer:
Answer rating: 100% (QA)
The optimal solution has changed and the cost has decreased 2 The opti... View the full answer
Related Book For
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth
Posted Date:
Students also viewed these computer network questions
-
Suppose that you are an analyst for the ABC Company, a large consulting firm with offices around the world. The company wants to build a new knowledge management system that can identify and track...
-
Suppose that you are an analyst for the Central Bank of Zanzibar. Decide how the BOP accounts are affected by the following. (a) A budget deficit financed by foreign borrowing (b) An import quota for...
-
You are an analyst for a large public pension fund and you have been assigned the task of evaluating two different external portfolio managers (Y and Z). You consider the following historical average...
-
A business has the following transactions: The business is started by receiving cash from an investor in exchange for common stock $20,000 The business purchases supplies on account $500 The...
-
Consider the following problem. Maximize Z = 5x1 + c2x2 + c3x3, Subject to and x1 ¥ 0, x2 ¥ 0, x3 ¥ 0. The estimates and ranges of uncertainty for the uncertain parameters are shown in...
-
A decibel \((\mathrm{dB})\) is a quantity, such as power \((P)\), defined in terms of a reference value \(\left(P_{\text {ref }} ight)\), as a. \(10 \log _{10}\left(\frac{P}{P_{\text {ref }}} ight)\)...
-
What are the grounds for seeking an attachment?
-
Multiple Choice Questions 1. Which one of the following managerial accounting approaches attempts to allocate manufacturing overhead in a more meaningful fashion? a. Activity-based costing b....
-
The following loan is discounted. Find (a) the discount, (b) the amount of money received, and (c) the true interest rate: P= $1090.00 r= 4 1/2% t=6 years
-
Mike Greenberg opened Kleene Window Washing Inc. on July 1, 2022. During July, the following transactions were completed. July 1 Issued 12,000 shares of common stock for $12,000 cash. 1 Purchased...
-
Amos is a registered auditor. Until November 2022 he was a director of Antics Intellectual Services (Pty) Ltd. During October 2022 Amos became seriously ill and resigned due to health reasons. He has...
-
Suppose you are the project manager leading a project that would merge the five departments into one centralized department. How will you define the problem in making a business case based on the...
-
RABBIT SNEAKERS is a company dedicated to the production and marketing of sneakers for: women, men and children, known as Z-D, Z-C and Z-N. All its sales are made in its country and currently the...
-
Q1. As a consultant to your company. Your objective is to assess that the company understands how project cash flows are evaluated and whether that evaluation fully considers the weighted average...
-
Gender-based violence has a detrimental impact on mental health, damaging the sense of self-worth and triggering depression, self-harm, PTSD, anxiety, and suicidal ideation, as well as having...
-
What is the NPV? Use Table 1 to answer questions 1-5. Assume a 8% discount rate. Round up if needed. Year Cash Flow O $23,148 O $5,000 O $469 $507 0 -$25,000 1 $8,000 2 $10,000 3 $12,000
-
The Chicago North Shore & Milwaukee Railroad was an electric railway running between the cities in its corporate title. It had passenger cars as shown in the figure, which weighed 100 kip (V1), had...
-
A non-charmed baryon has strangeness S = 2 and electric charge Q = 0. What are the possible values of its isospin I and of its third component I z ? What is it usually called if I = 1/2?
-
Suppose that you are the project leader for the development of a new Web-based course registration system for your university that replaces an old system in which students had to go to the coliseum...
-
Marcus Weber, IS project manager at ICAN Mutual Insurance Co., is reviewing the staffing arrangements for his next major project, the development of an expert system-based underwriters assistant....
-
Car dealers have realized how profitable it can be to sell automobiles by using the Web. Pretend that you work for a local car dealership that is part of a large chain such as CarMax. Create a system...
-
Steam flows steadily and isentropically through a nozzle. At an upstream section where the speed is negligible, the temperature and pressure are \(450^{\circ} \mathrm{C}\) and \(6 \mathrm{MPa}\)...
-
Space debris impact is a real concern for spacecraft. If a piece of space debris were to create a hole of \(0.001 \mathrm{in} .^{2}\) area in the hull of the International Space Station (ISS), at...
-
Oxygen discharges from a tank through a convergent nozzle. The temperature and velocity in the jet are \(-20^{\circ} \mathrm{C}\) and \(270 \mathrm{~m} / \mathrm{s}\), respectively. What is the...
Study smarter with the SolutionInn App