excel for industrial engineering


The objective of this homework is for the student to gain experience in network design and to develop intuition about the complexity of network problems.


1. Develop several heuristic approaches (at least 2) to solve the network design problem described in below.

You are working for a logistics company, which is planning to open three distribution centers in the US. These distribution centers will serve customers located in the capitals of 48 continental states + DC. You are managing a team of industrial engineers whose task is to divide 49 states/DC into three groups (one group for each distribution center) and, for each group of states, determine a tour that will start in one state (this is the state where the distribution center will be open) and travel every other state within the group and come back to the starting state. Note that the location of the distribution center really does not matter since the tour you are designing “touches” each state within the group only once. Your goal, of course, is to minimize the total distance of three tours (one for each group of states).

You can calculate the length of tours using the Excel file by simply entering the state abbreviations in three columns (each column represents a group of states) according to the sequence in your tours. The excel file will automatically update the graph of the tours and tour length calculations as you enter states.

2. Test your approaches using the Excel file. Identify the best approach. Try to describe the reasons why your approaches worked / did not work.


Write a 2-page, not including the title page (maximum + any appendices) report addressing the following topics (note the percentage of the grade for each component):

1. (40%) Describe your heuristic approaches and how you developed them.

2. (30%) Discuss the results of your network design. Include the resulting routes both as a list and shown on the map.

3. (30%) Describe other ways to improve the logistics/transportation costs. Provide a preliminary economic analysis to support your suggestions.

Evner: Ingeniørarbejde, Excel, Industriel Ingeniør Videnskab

Se mere: excel for engineers tutorial, mechanical engineering formulas in excel, engineering calculations using microsoft excel, microsoft excel for engineers, excel for engineers pdf, excel for engineers course, excel engineering spreadsheets, mechanical engineering spreadsheets, work industrial engineering, industrial engineering work, write report work bakery, write report mechanical engineering, write report work package, report work shifts excel, part time backend report work excel, crystal report work projects, crystal report work asp net projectsn, a2billing calls report work, social engine status update dont work, update yootheme work ie8

Om arbejdsgiveren:
( 15 bedømmelser ) Columbia, United States

Projekt ID: #15770166

3 freelancere byder i gennemsnit $27 på dette job


HI, I am experienced engineer Relevant Skills and Experience please award me this project Proposed Milestones $25 USD - xls worksheet

$25 USD på 1 dag
(6 bedømmelser)

A proposal has not yet been provided

$30 USD på 1 dag
(9 bedømmelser)

I have tried two models, and would like to start on the write up after awarding the project Relevant Skills and Experience excel programming, engineering designs and optimizations of problems Proposed Milestones $25 Flere

$25 USD på 1 dag
(0 bedømmelser)