Need Help?

Contact Us!

Check our Frequently Asked Questions

For fastest service please enter your question or issue in the text box below. Enter your name and email address so we can reply. Be sure to give us enough info to identify the course or order that you need help with.

You may also call us at: 561-753-0105

Welcome to SunCam

287-Engineering Methods in Microsoft Excel - Part 2: Applied Optimization

By: Kwabena Ofosu, Ph.D., PE, PTOE

Course Documents, Test Previews and other resources above may attempt to open or download Adobe PDF files. Most modern browsers have built-in PDF readers If you have problems opening this file in your browser, check your browser's or computer system's settings. You can also Download a copy of Adobe PDF reader or we can send them as an email attachment. (We cannot email streaming videos at the moment.) Send PDF Files via Email.

Course Objective

This continuing education course is written specifically for professional engineers with the objective of relating to and enhancing the practice of engineering.

Course Description

287-Engineering Methods in Microsoft Excel - Part 2: Applied Optimization

This course is part of a series on engineering methods in Microsoft Excel tailored to practicing engineers. This course series presents Microsoft Excel tools that can be used for a wide range of engineering analyses and data management. This course covers an introduction to applied optimization problems. This course presents a review of the fundamental principles followed by a real-life example encountered by a practicing engineer. The real-life examples are then formulated and implemented in Microsoft Excel and worked using the various Excel tools, spreadsheet techniques, and built-in functions. Examples from various engineering fields are used to demonstrate the concepts and methods learned throughout this course. Upon completion of this course, practitioners will be able to apply the methods learned to a variety of engineering problems, and also to identify situations in their fields of specialty where the innovative application of these tools and methods will be advantageous to their output and to their work product.

287-Engineering Methods in Microsoft Excel - Part 2: Applied Optimization
Charles E Perryman PE
01/14/2019
Verified Buyer
The course primarily uses one optimization problem: purchasing the correct number of cocoa beans from three different sources in order to minimize costs, dealing with a number of constraints. It shows how this linear programming problem can be expressed mathematically, which is important in the Excel set-up to use the Solver tool. Using the provided Excel spreadsheet and very clear screenshots, it demos how the Solver tool can be used to solve the problem. The exam also uses a provided worksheet (thank goodness) to use the Solver tool to determine how a bank should design an investment plan to maximize profits and minimize risk. I think the course would benefit from using other examples or models, such as 1) assignments of workers to jobs to minimize hours or distance traveled, or 2) transportation models to minimize shipping costs from warehouses to distribution centers. The current course examples are 100% accurate, and Dr. Ofosu has done another brilliant job showing an aspect to Excel that few know about.
Was this helpful?
 
SAVE 20%
Order the Complete Set of 3 Courses for $288.00!

You Must Use This Button to Get The Savings
Price: $112.50
Quantity:
This Course Includes FREE Software
Course Code: 100236-09
Course PDH Hours: 5
Engineering Course Approvals
  • This course is accepted for engineering continuing education credit in all states except: Ohio

About Course Approvals

Other Courses by Kwabena Ofosu, Ph.D., PE, PTOE

Course Title Rating Hours Price
175-Programming MS Excel in Visual Basic (VBA). Part 1: An Introduction
(4.6) 75 Reviews
4 $90.00
This Course Includes FREE Software
190-Web-Based Programming For Engineers - Part 1
(4.5) 33 Reviews
4 $29.95
Special Price Offer: expires at midnight on 1/25/2019
191-Web-Based Programming For Engineers - Part 2
(4.6) 12 Reviews
4 $29.95
Special Price Offer: expires at midnight on 1/25/2019
192-Web-Based Programming For Engineers - Part 3
(4.2) 17 Reviews
4 $29.95
Special Price Offer: expires at midnight on 1/25/2019




Need Help?

Contact Us!

Check our Frequently Asked Questions

For fastest service please enter your question or issue in the text box below. Enter your name and email address so we can reply. Be sure to give us enough info to identify the course or order that you need help with.

You may also call us at: 561-753-0105