Print this page Manufacturing Operations Spreadsheets
John Andrew, P.E.
Course Outline
This online course describes manufacturing management operations.
Major topics are:
1. Manufacturing Business Plan Example
2. Automation Summary
3. Factory Layout
4. Break Even Analysis
The course includes
a multiple-choice quiz at the end, which is designed to enhance the understanding
of the course materials.
Learning Objective
At the conclusion of this course the student will:
- Compare: small batch, repetitive, and continuous manufacturing;
- Know the four phases of the life cycle of a typical product;
- See essential elements of a factory graphically depicted;
- Perform product sales, break-even analyses;
- Make capital investment calculations;
- Examine the effect of inflation;
- Use Excel to calculate present values of investments;
- Select equipment by the equivalent annual cost method;
- Estimate: Labor, materials, and factory costs;
- Perform “Make-or-Buy” decisions;
- Examine a typical semi-automated factory layout;
- Estimating assembly cell floor area;
- Understand the importance of product drawings as applied to manufacturing;
- Review a state of the art assembly cell;
- Compare manual and automated assembly cells;
- Calculate assembly / machining line cycle time balance;
- See automated assembly cells; and
- Calculate the pay-back period of an industrial robot assembly cell.
Intended Audience
The information will be especially useful to students, entrepreneurs, engineers, and innovators who want to update their knowledge base concerning some of the most important elements of manufacturing planning.
Benefit to Attendees
Attendee of this course will be able to plan and make important financial evaluations of manual and automated manufacturing systems.
Course Introduction
The market place for industrial products today demands innovation, improved designs, high reliability, quality, and low prices. This means rapid prototyping and production systems that are agile and able to change more rapidly. The basic components of manufacturing systems are outlined in the course.
Course Content
You need to download and study the following spreadsheet:
Manufacturing Operations Spreadsheets
DISCLAMER: "This spreadsheet is provided for illustrative teaching purpose only, and is not intended for use in any specific project. Anyone making use of theinformation contained in this spreadsheet does so at his/her own risk and assumes any and all resulting liability arising therefrom."
Course Summary
A brief and to the point manufacturing summary is provided in these notes and spreadsheet calculations that will provide information that can be used to plan automated and semi-automated assembly and machine cells and to make critical financial calculations.
Related Links
For additional technical information related to this subject, please visit the following websites:
Advanced Automation provides, designs, manufactures, and integrates custom automation systems at: http://www.aautomation.com/
Information about pick and place grippers can be obtained from: www.phdinc.com.
Fanuc Industrial Robots can be found at:
http://www.fanuc.co.jp/en/product/robot/index.html
See www.automationdirect.com for information about event driven control systems.
For information about the Human-Machine-Interface shown above see www.rousselet-robatel.com
Information about laser sensors and vision systems can be found at: http://world.keyence.com
More vibrating bowel part feeders at: www.designtoolinc.com
The United States Patent and Trademark Office Home Page at www.uspto.gov
Provides links to information about all aspects pertaining to invention patents.
Quiz
Once you finish studying the above course content, you need to take a quiz to obtain the PDH credits.
DISCLAIMER: The materials contained in the online course are not intended as a representation or warranty on the part of PDH Center or any other person/organization named herein. The materials are for general information only. They are not a substitute for competent professional advice. Application of this information to a specific project should be reviewed by a registered architect and/or professional engineer/surveyor. Anyone making use of the information set forth herein does so at their own risk and assumes any and all resulting liability arising therefrom.
