logging in or signing up 11 17 99 Jolene Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINTLite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 97 Category: Entertainment License: All Rights Reserved Like it (0) Dislike it (0) Added: November 06, 2007 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... Premium member Presentation Transcript IE 323: IE 323 Warehouse location problemsBasic idea: 2 Basic idea Integrated plan for production and distribution: Where should production plants be located? Where should transshipment centers (warehouses) be located? How should goods be transported? Objective is to minimize total operating costIdeas should be familiar: 3 Ideas should be familiar You’ve seen: Transportation and transshipment problems Location problems Now combine these to produce an integrated logistics planHuntco example: 4 Huntco example Determine: Which plants and warehouses to operate How much to ship from each plant to each warehouse How much to ship from each warehouse to each customer Minimize total fixed costs and production and shipping costsObjective: 5 Objective Minimize total costs, which include: Fixed costs of operating plants and warehouses Variable production costs at plants Shipping costs from plants to warehouses and from warehouses to customersConstraints: 6 Constraints Don’t ship at all from plants that are closed Don’t ship more than capacity from plants that are open Amounts shipped into warehouses must equal amounts shipped out Don’t ship into or out of warehouses that are closed Meet customer requirementsInputs: 7 Inputs Unit production/shipping costs from plants to warehouses Unit shipping costs from warehouses to customers Fixed costs of operating plants Fixed costs of operating warehouses Customer requirementsDecision Variables: 8 Decision Variables Amounts shipped from plants to warehouses 0-1 variables to indicate which plants are operating Amounts shipped from warehouses to customers 0-1 variables to indicate which warehouses are operatingSpreadsheet Model (See “Steps 1-3” sheet of Excel): 9 Spreadsheet Model (See “Steps 1-3” sheet of Excel) Step 1: Enter all inputs Step 2: Enter any amounts to ship from each plant to each warehouse and from each warehouse to each customer Step 3: Enter any values in the 0-1 changing cells for which plants and warehouses to operateSee “Steps 4,5” sheet of Excel: 10 See “Steps 4,5” sheet of Excel Step 4: Calculate the amounts shipped out of the plants as row sums Step 5: Using 0-1 variables, calculate the logical upper limits for the sums in step 4: For an operating plant, this is the plant capacity For a closed plant, this is 0 See “Steps 6,7” sheet of Excel: 11 See “Steps 6,7” sheet of Excel Step 6a: Calculate an upper limit on the amount shipped out of each warehouse Total customer demand Step 6b: Using the 0-1 variables, calculate a logical upper bound on the amount shipped out of each warehouse: Bound from step 6a for an operating warehouse 0 for a closed warehouse See “Steps 6,7” sheet of Excel: 12 See “Steps 6,7” sheet of Excel Step 7a: Calculate the amounts shipped out of the warehouses as row sums Step 7b: Transpose these into a rowSee “Steps 8,9” sheet of Excel: 13 See “Steps 8,9” sheet of Excel Step 8: Calculate the amounts received by the warehouses as column sums Step 9: Calculate the amounts received by the customers as column sumsSee “Steps 10-12” sheet of Excel: 14 See “Steps 10-12” sheet of Excel Step 10: Calculate all production and shipping costs with SUMPRODUCT functions Step 11: Calculate all fixed costs with SUMPRODUCT functions Step 12: Calculate the total costSee “Optimal” sheet of Excel: 15 See “Optimal” sheet of Excel Click on Tools/Solver Fill in the Solver dialog box: See next slide Don’t forget to check the Assume Linear Model box under Options Click on SolveSolver Dialog Box: 16 Solver Dialog BoxOptimal Solution: 17 Optimal Solution Plants 2, 3, and 5 are operated Warehouses 2 and 3 are operated The plant-warehouse shipments are: P2-W2, P3-W3, P5-W3 All operating plants produce and ship their capacity The warehouse-customer shipments are: W2-C1, W3-C2, W3-C3, W3-C4Summary: 18 Summary This model combined: Transportation and transshipment analysis Location analysis It produced an integrated logistics plan for Huntco Next step would probably be to start asking “what-if” questions: Cost variation, etc. You do not have the permission to view this presentation. In order to view it, please contact the author of the presentation.
11 17 99 Jolene Download Post to : URL : Related Presentations : Share Add to Flag Embed Email Send to Blogs and Networks Add to Channel Uploaded from authorPOINTLite Insert YouTube videos in PowerPont slides with aS Desktop Copy embed code: (To copy code, click on the text box) Embed: URL: Thumbnail: WordPress Embed Customize Embed The presentation is successfully added In Your Favorites. Views: 97 Category: Entertainment License: All Rights Reserved Like it (0) Dislike it (0) Added: November 06, 2007 This Presentation is Public Favorites: 0 Presentation Description No description available. Comments Posting comment... Premium member Presentation Transcript IE 323: IE 323 Warehouse location problemsBasic idea: 2 Basic idea Integrated plan for production and distribution: Where should production plants be located? Where should transshipment centers (warehouses) be located? How should goods be transported? Objective is to minimize total operating costIdeas should be familiar: 3 Ideas should be familiar You’ve seen: Transportation and transshipment problems Location problems Now combine these to produce an integrated logistics planHuntco example: 4 Huntco example Determine: Which plants and warehouses to operate How much to ship from each plant to each warehouse How much to ship from each warehouse to each customer Minimize total fixed costs and production and shipping costsObjective: 5 Objective Minimize total costs, which include: Fixed costs of operating plants and warehouses Variable production costs at plants Shipping costs from plants to warehouses and from warehouses to customersConstraints: 6 Constraints Don’t ship at all from plants that are closed Don’t ship more than capacity from plants that are open Amounts shipped into warehouses must equal amounts shipped out Don’t ship into or out of warehouses that are closed Meet customer requirementsInputs: 7 Inputs Unit production/shipping costs from plants to warehouses Unit shipping costs from warehouses to customers Fixed costs of operating plants Fixed costs of operating warehouses Customer requirementsDecision Variables: 8 Decision Variables Amounts shipped from plants to warehouses 0-1 variables to indicate which plants are operating Amounts shipped from warehouses to customers 0-1 variables to indicate which warehouses are operatingSpreadsheet Model (See “Steps 1-3” sheet of Excel): 9 Spreadsheet Model (See “Steps 1-3” sheet of Excel) Step 1: Enter all inputs Step 2: Enter any amounts to ship from each plant to each warehouse and from each warehouse to each customer Step 3: Enter any values in the 0-1 changing cells for which plants and warehouses to operateSee “Steps 4,5” sheet of Excel: 10 See “Steps 4,5” sheet of Excel Step 4: Calculate the amounts shipped out of the plants as row sums Step 5: Using 0-1 variables, calculate the logical upper limits for the sums in step 4: For an operating plant, this is the plant capacity For a closed plant, this is 0 See “Steps 6,7” sheet of Excel: 11 See “Steps 6,7” sheet of Excel Step 6a: Calculate an upper limit on the amount shipped out of each warehouse Total customer demand Step 6b: Using the 0-1 variables, calculate a logical upper bound on the amount shipped out of each warehouse: Bound from step 6a for an operating warehouse 0 for a closed warehouse See “Steps 6,7” sheet of Excel: 12 See “Steps 6,7” sheet of Excel Step 7a: Calculate the amounts shipped out of the warehouses as row sums Step 7b: Transpose these into a rowSee “Steps 8,9” sheet of Excel: 13 See “Steps 8,9” sheet of Excel Step 8: Calculate the amounts received by the warehouses as column sums Step 9: Calculate the amounts received by the customers as column sumsSee “Steps 10-12” sheet of Excel: 14 See “Steps 10-12” sheet of Excel Step 10: Calculate all production and shipping costs with SUMPRODUCT functions Step 11: Calculate all fixed costs with SUMPRODUCT functions Step 12: Calculate the total costSee “Optimal” sheet of Excel: 15 See “Optimal” sheet of Excel Click on Tools/Solver Fill in the Solver dialog box: See next slide Don’t forget to check the Assume Linear Model box under Options Click on SolveSolver Dialog Box: 16 Solver Dialog BoxOptimal Solution: 17 Optimal Solution Plants 2, 3, and 5 are operated Warehouses 2 and 3 are operated The plant-warehouse shipments are: P2-W2, P3-W3, P5-W3 All operating plants produce and ship their capacity The warehouse-customer shipments are: W2-C1, W3-C2, W3-C3, W3-C4Summary: 18 Summary This model combined: Transportation and transshipment analysis Location analysis It produced an integrated logistics plan for Huntco Next step would probably be to start asking “what-if” questions: Cost variation, etc.