Print this page Manufacturing Operations Spreadsheets
John Andrew, P.E.
Course Outline
Manufacturing Operations Spreadsheets is a brief summary of important planning and operating calculations used in manufacturing systems with manual and automated assembly and machining processes.
This online course describes manufacturing management operations. Major topics are:
1. Factory layout.
2. Manufacturing financial calculations.
3. A manufacturing plan.
4. Quality control considerations.
5. Factory building.
6. Manufacturing equipment and materials.
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;
- Read 36 steps required to make a manufacturing business plan;
- 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;18. Review typical manufacturing equipment;
- See automated assembly cells;
- Calculate the pay-back period of an industrial robot assembly cell; and
- Obtain several
web links to manufacturing related WEB pages.
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 and control.
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
This 5 Professional Development Hour (PDH) online course has series of inputs of manufacturing data and solved output equations in an Excel format. The student will type numerical values for production parameters and Excel will perform the calculations. For example, the proposed, cost of a product is typed into labeled input cells and the quantity to be produced will be calculated automatically for any desired profit.
Any input parameter can be found for a target value of an Excel calculated item by using the "Goal Seek" tool in Excel.
The Excel Workbook spread sheets are:
Tab 1 Factory
Tab 2 Money
Tab 3 MFG Plan
Tab 4 Quality Control
Tab 5 Building
Tab 6 Equipment
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
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: http://www.phdinc.com
Fanuc Industrial Robots can be found at: http://www.fanuc.co.jp/en/product/robot/index.html
See http://www.automationdirect.com for information about event driven control systems.
For information about the Human-Machine-Interface shown above see http://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: http://www.designtoolinc.com
The United States Patent and Trademark Office Home Page at http://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.
