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.

Skills: Engineering, Excel, Industrial Engineering

See more: 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, write report summary, write report marriage, experience write report project, excel civil engineering, industrial engineering hiring cebu, write report txt form java, microsoft access graph aggregate report, write project work arabic, write report letter, biztalk 2004 write report, industrial engineering freelance work, part time backend report work excel

About the Employer:
( 15 reviews ) Columbia, United States

Project ID: #15770166

3 freelancers are bidding on average $27 for this job


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

$25 USD in 1 day
(6 Reviews)

A proposal has not yet been provided

$30 USD in 1 day
(9 Reviews)

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 More

$25 USD in 1 day
(0 Reviews)