MANUFACTURING & DESIGN ENGINEERING CENTER

MANAGEMENT COURSES & LECTURES WITH CALCULATORS & SPREADSHEETS (XLS)

Management Realated Centers

FOR REALTED COURSES, TEXTBOOKS, LECTURES, CALCULATORS, VIDEOS, ETC. SEE THE

BUSINESS & MANAGEMENT CALCULATORS CENTER


SLOAN SCHOOL OF MANAGEMENT COURSES (SPREADSHEETS OPEN ONLINE WITH
EXCEL, iWORK-NUMBERS, IBM LOTUS SYMPHONY, NEOOFFICE, OPENOFFICE CALC, ETC.) – Sloan School of Management,
& the MIT OpenCourseWare, MIT
Multimedia Undergraduate & Graduate Management Courses (Text, Images, Animations, Simulations & Spreadsheets).
VERY VERY VERY…EXTENSIVE.
For more information see

Sloan School of Management or the

MIT OpenCourseWare

MANUFACTURING COURSES, LECTURES, TEXTBOOKS, HANDBOOKS, ETC.

MANUFACTURING CALCULATORS, SOFTWARE, SPREADSHEETS, ETC.


DESIGN & MANUFACTURING SYSTEMS II (SPREADSHEETS OPEN ONLINE WITH
EXCEL, iWORK-NUMBERS, IBM LOTUS SYMPHONY, NEOOFFICE, OPENOFFICE CALC, ETC.) – Sang-Gook Kim & ung-Hoon Chun,
Department of Mechanical Engineering & the
Laboratory for Manufacturing and Productivity (LMP),
& the MIT OpenCourseWare, MIT
Multimedia Design & Manufacturing Systems II Course (Text, Images & Spreadsheets).
VERY VERY VERY…EXTENSIVE.

Design & Manufacturing Systems II Course

“…introduces you to modern manufacturing with four areas of emphasis:
manufacturing processes, equipment/control, systems, and
design for manufacturing. The course exposes you to integration of engineering
and management disciplines for determining manufacturing rate, cost, quality and…”

Examples of “Design & Manufacturing Systems II” Course Lectures include

“…Process Planning CAD/CAM;

Design for Manufacturing;

Polymer Processing;

Injection Molding;

Thermoforming Casting;

Joining;

MEMS;

Micro/Nano Manufacturing;

Manufacturing System; etc….”

For more information see the

Department of Mechanical Engineering;

Laboratory for Manufacturing and Productivity (LMP);

Mechanical Engineering Courses or

MIT OpenCourseWare


ENGINEERING STATISTICS: NIST/SEMATECH E-HANDBOOK OF STATISTICAL METHODS – J.J. Filliben (Group Leader),
C. Croarkin & Paul Tobias (Technical Editors), Statistical Engineering Division,
Information Technology Laboratory, National Institute of Standards and Technology (NIST)
Multimedia Engineering Statistcs Handbook (Text & Images).

Engineering Statistcs Handbook

“…The goal of this handbook is to help scientists and engineers to incorporate
statistical methods in their work as efficiently as possible…”

Examples of “Engineering Statistcs: NIST/SEMATECH e-Handbook of Statistical Methods” Handbook Chapters include:

Exploratory Data Analysis
“…presents the assumptions, principles, and techniques necessary
to gain insight into data via EDA – exploratory data analysis…”

Measurement Process Characterization

Includes “…Calibration; Uncertainty analysis; Control;
Gauge R & R studies; etc…”

Production Process Characterization

“…learn how to plan and conduct a Production Process Characterization
Study (PPC) on manufacturing processes…”

Process Modeling

“…presents the background and specific analysis techniques
needed to construct a statistical model that describes
a particular scientific or engineering process…”

Process or Product Monitoring and Control

“…resents techniques for monitoring and controlling
processes and signaling when corrective actions are necessary…” etc.

For more information see

Statistical Engineering Division;

Math, Statistics, and Computational Science;

Information Technology Laboratory or

National Institute of Standards and Technology (NIST)

MANUFACTURING ENERGY COSTS CALCULATORS & APPLETS

BUSINESS ENERGY CALCULATORS, APPLETS, ANIMATIONS & SIMULATIONS

COMMERICAL ENERGY CALCULATORS, APPLETS, ANIMATIONS & SIMULATIONS

INDUSTRIAL ENERGY CALCULATORS, APPLETS, ANIMATIONS & SIMULATIONS


ENERGY AND COST SAVINGS CALCULATORS & SPREADSHEETS FOR ENERGY-EFFICIENT PRODUCTS (SPREADSHEETS OPEN ONLINE WITH
EXCEL, iWORK-NUMBERS, IBM LOTUS SYMPHONY, NEOOFFICE, OPENOFFICE CALC, ETC.) – Federal Energy Management Program (FEMP),
Office of Energy Efficiency and Renewable Energy,
Department of Energy
VERY VERY VERY…EXTENSIVE.
For more information see

Energy- and Water-Efficient Products;

Products and Technologies;

Federal Energy Management Program or

Office of Energy Efficiency and Renewable Energy

Examples of “Energy Costs Savings Calculators & Spreadsheets for Energy-Efficient Products” include


Energy Cost Calculator for Commercial Boilers: Closed Loop, Space Heating Applications Only


Energy Cost Calculator for Commercial Heat Pumps (5.4 >=< 20 TONS)


Energy Cost Calculator for Faucets and Showerheads


Energy Cost Calculator for Commercial Ice Cube Machines

SIX SIGMA COURSES, LECTURES, TEXTBOOKS, ETC.

SIX SIGMA CALCULATORS, APPLETS, SPREADSHEETS (XLS), ETC.

LEAN MANUFACTURING COURSES, LECTURES, TEXTBOOKS, ETC.

LEAN MANUFACTURING CALCULATORS, APPLETS, SPREADSHEETS (XLS), ETCL

Lean Manufacturing & Six Sigma Realated Centers

FOR REALTED COURSES, LECTURES, TEXTBOOKS, CALCULATORS, APPLETS, SPREADSHEETS, ETC. SEE THE

BUSINESS & MANAGEMENT CALCULATORS CENTER

Lean Manufacturing Courses with Calculators & Spreadsheets (xls)


LEAN/SIX SIGMA PROCESSES – J. Cutcher-Gershenfeld,
Engineering Systems Division
& the MIT OpenCourseWare, MIT
Multimedia Lean/Six Sigma Processes Course (Text, Images & Simulations).
VERY VERY VERY…EXTENSIVE.

Examples of “Lean/Six Sigma Processes” Course Lectures include

“…Lean Thinking; Systems Change Principles;

Socio-Technical Dynamics;


Active and Passive Opposition to Lean/Six Sigma;


Team/Work Group Structure and Roles – Socio-Tech vs Lean Teams;


Knowledge-Driven Work;

Supply Chain Alignment;

Standardized Work;

Preventive Maintenance Principles;


Assembly Operations;

Machining Operations;

Continuous Flow Operations;

A Simulation Exercise Designed to Illustrate Lean Principles in Manufacturing Operations; etc…”

For more information see the

Engineering Systems Division;

Engineering Systems Division Courses or the

MIT OpenCourseWare


MANUFACTURING SYSTEMS AND SUPPLY CHAIN DESIGN
(SPREADSHEETS OPEN ONLINE WITH
EXCEL, iWORK-NUMBERS, IBM LOTUS SYMPHONY, NEOOFFICE, OPENOFFICE CALC, ETC.) – S. Graves & D. Simchi-Levi,
Sloan School of Management
& the MIT OpenCourseWare, MIT
Multimedia Manufacturing System and Supply Chain Design Course (Text, Images & Spreadsheets).
VERY VERY VERY…EXTENSIVE.

Examples of “Manufacturing System and Supply Chain Design” Course Chapters & Spreadsheets include

Lean Factory Spreadsheet;

Design of Manufacturing System;

Design and Implementation of Cellular Manufacturing in a Job Shop Environment;

Implementing Lean Manufacturing Through Factory Design;

Logistics Network Configuration;

Optimizing the Supply-Chain Configuration for New Products;


Flexibility and Capacity Planning

For more information see

Sloan School of Management Courses;

Sloan School of Management or

MIT OpenCourseWare

Six Sigma


SIX SIGMA SPREADSHEETS (SPREADSHEETS OPEN ONLINE WITH
EXCEL, iWORK-NUMBERS, IBM LOTUS SYMPHONY, NEOOFFICE, OPENOFFICE CALC, ETC.) – American Society for Quality (ASQ)
VERY VERY VERY…EXTENSIVE.

Some examples from over “15” Six Sigma Calculators (Six Sigma Black Belt Calculators) include:

Process Capability Calculator;

Failure Modes & Effects Analysis Calculator;

Wilcoxon-Mann-Whitney Rank Sum Test Calculator;

SIPOC Diagram Calculator;

Process Flow Chart Calculator; etc…”

For more information see

Six Sigma or the

American Society for Quality (ASQ)

WAREHOUSE & DISTRIBUTION CALCULATORS, ANIMATIONS, SPREADSHEEETS (XLS), ETC.

MATERIAL HANDLING COURSES, TEXTBOOKS, LECTURES, CALCULATORS, ANIMATIONS, VIDEOS, ETC.

WAREHOUSE COURSES, TEXTBOOKS, LECTURES, CALCULATORS, ANIMATIONS, VIDEOS, ETC.

LOGISTICS COURSES, TEXTBOOKS, LECTURES, CALCULATORS, ANIMATIONS, VIDEOS, ETC.

OPERATIONS RESEARCH COURSES, TEXTBOOKS, LECTURES, CALCULATORS, ANIMATIONS, VIDEOS, ETC.

Warehouse, Distribution, Logistics Courses & Textbooks


WAREHOUSE & DISTRIBUTION SCIENCE – J.J. Bartholdi, III, & S.T. Hackman,
Supply Chain & Logistics Institute,
School of Industrial and Systems Engineering,
Georgia Institute of Technology
Multimedia Warehouse & Distribution Science Textbook (Text & Images).
VERY VERY VERY…EXTENSIVE.

Warehouse & Distribution Science Textbook

“…The topic of this book is the science of warehouse layout and operations. We say
“science” because we develop mathematical and computer models…”

Examples of “Warehouse & Distribution Science” Textbook Parts & Chapters include

Part I: Issues, Equipment, Processes
“…Warehouse Rationale;

Material Flow;

Warehouse Operations; etc…”

Part II: Layout

“…Layout of a Unit-load Area;

The Geometry of Slotting; etc…”

Part III: Order-picking;

Part VI: Measuring Warehouse Efficiency; etc.

For more information see

Warehouse & Distribution Science;

J.J. Bartholdi, III or the

Supply Chain & Logistics Institute

Material Handling Courses & Lessons


MATERIAL HANDLING EQUIPMENT TAXONOMY – M.G. Kay &
Edward P. Fitts,
Department of Industrial and Systems Engineering,
College of Engineering,
North Carolina State University
Multimedia Material Handling Equipment Lessons (Text & Images).
VERY VERY EXTENSIVE.

Material Handling Equipment Taxonomy

“…is intended to provide a finite amount of information about the
most common types of material handling equipment to students unfamiliar
with material handling terminology…”

Examples of “Material Handling Equipment” Subject Categories include

“…Transport Equipment (Conveyors, Cranes, Industrial Trucks);

Positioning Equipment;

Unit Load Formation Equipment;

Storage Equipment;

Identification and Communication Equipment…”

For more information see

Michael G. Kay’s Home Page or the

Department of Industrial and Systems Engineering

Warehouse, Distribution Courses & Lessons with Calculators & Spreadsheets (xls)


WAREHOUSE & DISTRIBUTION COMPUTATIONAL TOOLS (SPREADSHEETS OPEN ONLINE WITH
EXCEL, iWORK-NUMBERS, IBM LOTUS SYMPHONY, NEOOFFICE, OPENOFFICE CALC, ETC.) – J.J. Bartholdi, III,
Supply Chain & Logistics Institute,
School of Industrial and Systems Engineering,
Georgia Institute of Technology
Multimedia Warehouse & Distribution Computational Tools (Text, Images & Applets).
VERY VERY VERY…EXTENSIVE.
For more information see

Warehouse & Distribution Science;

J.J. Bartholdi, III or the

Supply Chain & Logistics Institute

Logistics & Operations Research

FOR MORE LOGISTICS & OPERATIONS RESEARCH COURSES, CALCULAOTRS, ETC. SEE THE

MATHEMATICS CALCULATOR CENTER: LOGISTICS & OPERATIONS RESEARCH

SOME EXAMPLES OF COURSES


DECISION SCIENCE – MANAGEMENT SCIENCE – OPERATIONS RESEARCH – H. Arsham, Division of Economics,
Finance and Management Science,
Merrick School of Business,
University of Baltimore
Multimedia Decision Science, Management Science & Operations Research Course (Text & Images).
VERY VERY VERY…EXTENSIVE.

Examples of “Decision Science, Management Science & Operations Research” Course Chapters include

“…Linear Optimization with Sensitivity;

Integer Optimization and the Network Models;


Tools for LP Modeling Validation;

Time Series Analysis and Forecasting;

Linear Algebra and LP Connections;

Construction of the Sensitivity Region for LP Models;

Zero Sagas in Four Dimensions;

Systems Simulation; etc…”

For more information see

Hossein Arsham’s Home Page or the

Merrick School of Business


LINEAR PROGRAMMING: FOUNDATIONS AND EXTENSIONS – R.J. Vanderbei,
Department of Operations Research and Financial Engineering,
School of Engineering and Applied Science (SEAS),
Princeton Universtiy
Multimedia Linear Programming Textbook,
Introductory Graduate Lectures, Exercises, etc. (Text, Images & Applets).
VERY VERY VERY…EXTENSIVE.

Examples of “Linear Programming: Foundations and Extension” Course Lectures include

“…The Simplex Method;

Degeneracy;

Efficiency;

Duality;


Self-Dual Simplex Method;

Parametric Simplex Method; etc…”

For more information see

Robert J. Vanderbei’s Home Page or the

Department of Operations Research and Financial Engineering


PRACTICAL OPTIMIZATION: A GENTLE INTRODUCTION – J.W. Chinneck,
Department of Systems & Computer Engineering,
Carleton University, Canada
Multimedia Practical Optimization Course (Text, Images & Animations).
VERY VERY VERY…EXTENSIVE.

Practical Optimization: A Gentle Introduction

“…is the art and science of allocating scarce resources to the best
possible effect. Optimization techniques are called into play every day in
questions of industrial planning, resource allocation, scheduling,
decision-making, etc…”

Examples of “Practical Optimization: A Gentle Introduction” Course Chapters include

“…Introduction to Linear Programming;

Towards the Simplex Method for Efficient Solution of Linear Programs;

The Mechanics of the Simplex Method;

Solving General Linear Programs;


Sensitivity Analysis;

Linear Programming in Practice;

PERT for Project Planning and Scheduling;

Dynamic Programming; etc…”

Examples of “Algorithm Animations” Subject Categories include

“…Linear Programming Animations;

Network Animations;

Integer Programming Animations;

Yeuristics for Discrete Optimization Animations; etc…”

For more information see

John W. Chinneck’s Home Page or the

Department of Systems & Computer Engineering


NONLINEAR PROGRAMMING (REAL PLAYER) – Robert Freund,
Sloan School of Management,
& the MIT OpenCourseWare, MIT
Multimedia Nonlinear Programming Course (Text, Images, Videos/Movies & Audio/Sound).
VERY VERY VERY…EXTENSIVE.

Nonlinear Programming Course

“…introduces students to the fundamentals of nonlinear optimization theory
and methods. Topics include unconstrained and constrained optimization,
linear and quadratic programming, Lagrange and conic duality theory,
interior-point algorithms and theory, Lagrangian relaxation,
generalized programming…”

Examples of “Nonlinear Programming” Course Video Lectures include

“…Newton’s Method Video Lecture;

Duality Theory Video Lecture;

Semidefinite Optimization Video Lecture…”

Examples of “Nonlinear Programming” Course Lectures include

“…Convex Unconstrained Optimization Optimality Condition;

Newton’s Method;

Steepest Descent Method;

Constrained Optimization Optimality Conditions;

Projection Methods for Equality Constrained Problems;

Penalty Methods;

Interior-Point Methods for Linear Optimization;

Analysis of Convex Sets; etc…”

For more information see

MIT OpenCourseWare: Sloan School of Management Courses;

Sloan School of Management or the

MIT OpenCourseWare