Optimal NC Location

ISE 453: Design of Production, Logistics, and Service Systems

Fitts Department of Industrial and Systems Engineering
North Carolina State University

[ Schedule | Lecture Notes | Syllabus | Moodle | Slides]

  Spring 2020 Tue and Thu 11:45 – 1:00 p.m.   Daniels 216
Office Hours
Michael G. Kay
DAN 306
Tue, 2:30-4:00 p.m., Thu, 1:30-3:00 p.m., or by appointment
TA: Chengyu Zhou DAN 418

Mon, Wed, 2:00-3:30 p.m.

E-reserve: W. Hopp and M. Spearman. (2008) Factory Physics (Chapter 7, Chapter 8, and Chapter 9 in library’s course reserves for ISE 453)

  1. How Far is It, calculates great circle distances
  2. Google Maps, finds actual road distances and city close to a longitude and latitude (enter location in lat-lon (Y,X) decimal degrees)
  3. OpenSolver for Excel, open source alternative to Solver to solve MILPs (Solver OK for nonlinear optimization). Win: Unzip download and place files in folder: C:\Users\[username]\AppData\Roaming\Microsoft\Excel\XLSTART, which is a trusted location and will allow OpenSolver to load at startup just like Solver (note: the folder "AppData" is usually hidden, so you need to type the folder name). Mac: Instructions for installing on Macs are at the bottom of the page.
  4. RetailWarehouseSites.xlsx, contains 13 retail warehouse locations that minimize the total person-miles from the 877 3-digit-ZIP-code population centroids covering the continental U.S.
  5. TL and LTL PPI, select Series ID=PCU484121484121 (TL) and Series ID=PCU484122484122 (LTL) for current monthly and annual PPI values
  6. FedEx LTL rates, provides one-time (spot) LTL rate quote
  7. Freight101.com, provides one-time LTL rate quotes from multiple carriers
  8. CzarLite, provides demo LTL tariff
  9. Prime Rate, current and forecasted prime lending rate (useful for determining interest rate for economic analyses)
  10. Inflation Rate, forecasted year to year change in the Consumer Price Index
  11. Inflation Calculator, adjusts any given amount of money for inflation (useful for converting historical cost estimates)
  12. Truck Costs, working paper from the FHWA’s Comprehensive TS&W Study (useful source for data on truck costs)
  13. Statistical Tables
  14. Data for Capacity Planning
  15. Kitchen Layout Sample Excel File
  16. SDPI Machine Layout and SDPI Excel Handout and DAN 407 Layout
  17. Visio Tutorial, used for facility layout (see Student-Owned Computing: Microsoft Imagine to download a copy of Visio)
  18. Storage Layout Planner, used for DSAP
  19. Material Handling Equipment, describes each type of equipment
  20. Rules of Thumb, cost estimates for material handling equipment
  21. Item Order Data, used for activity profiling