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

## Fitts Department of Industrial and Systems Engineering North Carolina State University

[ Schedule | Lecture Notes | Syllabus | Wolfware Classic]

 Fall 2017 Tue and Thu 11:45 – 1:00 p.m. Cox 206
 Instructors Office Telephone Email Office Hours Michael G. Kay DAN 306 515-2008 kay@ncsu.edu Tue, Thu, 2:00-3:30 p.m., or by appointment TA: Azadeh Bahmaninezhad Burlington Labs 2158 abahman2@ncsu.edu 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). Unzip download and place files in folder (Win): 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).
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