Warehouse Site Selection Consider a small company that produces a single product in two plants and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Warehouse Site Selection Consider a small company that produces a single product in two plants and serves customers in five different regions. The company has been using a make-to-order policy of producing the product only in the quantities needed to fill the orders that have come in from the various regions. However, because of the problems caused by the sporadic production schedule, management has decided to smooth out the production rate and ship the product to one or more storage warehouses, which then will use inventory to fill the incoming regional orders. Management now needs to decide where to locate the company's new warehouse(s). There are three locations under consideration. For each location, there is a fixed monthly cost associated with leasing and operating the warehouse there. Furthermore, each potential warehouse location has a maximum capacity for monthly shipments restricted primarily by the number of trucking docks at the site. The product costs $400 to produce at Plant 1 and $300 to produce at Plant 2. The shipping cost from each plant to each potential warehouse location is shown in the first table below. The fixed leasing and operating cost (if open), the shipping costs, and the capacity (maximum monthly shipments) of each potential warehouse location are shown in the second table below. The monthly demand in each of the customer regions is expected to be 200, 225, 100, 150, and 175 units, respectively. Formulate and solve a BIP model in a spreadsheet to determine which warehouse(s) should be used and how the product should be distributed from plant to warehouse(s) to customer. Plant 1 Plant 2 WH 1 WH 2 WH 3 Shipping Costs and Capacity of the Plants Shipping Cost (per unit) WH 2 WH 3 WH 1 $25 $50 $50 $75 $75 $25 Fixed Cost (per month) $50,000 $30,000 $70,000 Fixed Cost, Shipping Costs, and Capacity of the Warehouses Shipping Cost (per unit) Region 1 $30 $55 Capacity (units/month) $70 500 400 $30 Region 2 $70 $30 Region 3 Region 4 $75 $55 $45 $45 $60 $50 Region 5 $40 $70 $55 Capacity (units/month) 700 500 1,000 Warehouse Site Selection Consider a small company that produces a single product in two plants and serves customers in five different regions. The company has been using a make-to-order policy of producing the product only in the quantities needed to fill the orders that have come in from the various regions. However, because of the problems caused by the sporadic production schedule, management has decided to smooth out the production rate and ship the product to one or more storage warehouses, which then will use inventory to fill the incoming regional orders. Management now needs to decide where to locate the company's new warehouse(s). There are three locations under consideration. For each location, there is a fixed monthly cost associated with leasing and operating the warehouse there. Furthermore, each potential warehouse location has a maximum capacity for monthly shipments restricted primarily by the number of trucking docks at the site. The product costs $400 to produce at Plant 1 and $300 to produce at Plant 2. The shipping cost from each plant to each potential warehouse location is shown in the first table below. The fixed leasing and operating cost (if open), the shipping costs, and the capacity (maximum monthly shipments) of each potential warehouse location are shown in the second table below. The monthly demand in each of the customer regions is expected to be 200, 225, 100, 150, and 175 units, respectively. Formulate and solve a BIP model in a spreadsheet to determine which warehouse(s) should be used and how the product should be distributed from plant to warehouse(s) to customer. Plant 1 Plant 2 WH 1 WH 2 WH 3 Shipping Costs and Capacity of the Plants Shipping Cost (per unit) WH 2 WH 3 WH 1 $25 $50 $50 $75 $75 $25 Fixed Cost (per month) $50,000 $30,000 $70,000 Fixed Cost, Shipping Costs, and Capacity of the Warehouses Shipping Cost (per unit) Region 1 $30 $55 Capacity (units/month) $70 500 400 $30 Region 2 $70 $30 Region 3 Region 4 $75 $55 $45 $45 $60 $50 Region 5 $40 $70 $55 Capacity (units/month) 700 500 1,000
Expert Answer:
Answer rating: 100% (QA)
Here is the BINARY LINEAR PROGRAMMING model to solve this warehouse ... View the full answer
Related Book For
Corporate Finance Core Principles and Applications
ISBN: 978-1259289903
5th edition
Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Leadership in Organizations Module Three Assignment Essay #1: Case Study: Echo Electronics Paul Sanchez is the production manager for Echo Electronics, a small company that makes and distributes...
-
Evaluate the limit or determine that it does not exist. |xx| lim (x,y)(0,0) [x] + [yl
-
For a good or service to be counted in a given year's gross domestic product (GDP), what four following criteria must be met?
-
Refer to the bond details in Problem 10-5A. Legacy issues $325,000 of 5%, four-year bonds dated January 1, 2018, that pay interest semiannually on June 30 and December 31. They are issued at...
-
How much heat must be transferred into a balloon in order to increase its internal energy by \(18 \mathrm{~J}\) if it does \(12 \mathrm{~J}\) of work on the surrounding air as it expands? (a) \(40...
-
The expected annual returns are 15% for investment 1 and 12% for investment 2. The standard deviation of the first investments return is 10%; the second investments return has a standard deviation of...
-
Consider the two vectors: A (16.1)+(19.7) B (3.68) (4.89)
-
MBA 708 Essentials of Financial Statement Analysis Week 6 Case Study: Transaction and Financial Analysis Tallulah Company has been in business for several years and is publicly traded on a major U.S....
-
You have been asked to prepare a presentation for the companys leadership team on the topic of financial statement fraud. Discuss the following: Knowing there are 3 primary financial statements, 3...
-
Regarding the Rational Method, select the correct statement: The frequency of occurrence for the peak discharge is usually lower than the frequency of the rainfall producing that event. In the...
-
A cast iron water pipe 450 mm in diameter having thickness 18 mm is supported on a span of 7 meters. Determine the maximum bending stress in the material of the pipe when the pipe is running full,...
-
17. Consider the following two investors saving into their RRSP earning 9% compounded annually throughout: Scully invests $275 at the end of every month from age 18 to age 35, then stops contributing...
-
5. A devoted skier who lives near the high sierra, a beautiful mountain range in California, wants a decision tree to help him decide whether it is worthwhile to drive his car to a ski resort in the...
-
How can I create a map of Berlin with Rstudio? I would also like to create a linear regression with the NAO values and precipitation values. The precipitation values are monthly. Therefore, all NAO...
-
Officials in charge of televising an international chess competition in South America want to determine if the average time per move for the top players has remained at 5 minutes over the last two...
-
What are three disadvantages of using the direct write-off method?
-
Your firm is contemplating the purchase of a new $625,000 computer-based order entry system. The system will be depreciated straight-line to zero over its five-year life. It will be worth $60,000 at...
-
You are researching Time Manufacturing and have found the following accounting statement of cash flows for the most recent year. You also know that the company paid $185 million in current taxes and...
-
If a U.S. firm raises funds for a foreign subsidiary, what are the disadvantages to borrowing in the United States? How would you overcome them?
-
Describe the process of valuing the entrepreneurs ownership interest in a two-stage investment. Refer to Tables 13.10 and 13.13. Data from table 13.10 Data from table 13.13 Market potential...
-
Euro Exchange Rates. The exchange rate that we consider is the amount of euros that one can purchase for one U.S. dollar. We have \(T=699\) daily observations from the period April 1, 2005, through...
-
Evaluate the current yield curve level and structure using the following screens: a. YCRV or GC to access yield curves. b. FWCV to determine implied forward rates. c. USoo03M, USoo06M, USoo09M, and...
Study smarter with the SolutionInn App