Decision tree plugin excel

Decision trees can be used to determine the best possible alternatives and potential payoff for a new product or solving other management problems where uncertainty is present.

Your task is to build a decision tree based on the following scenario.

OM, Inc., a manufacturer of widgets, is considering the possibility of producing a new super-duper widget using 3D printing. This new project will require OM, Inc. to either purchase a high-end 3D printer or hire and train four additional employees. The market for the new widget could be either favorable or unfavorable. In the end, OM, Inc., can also decide not to develop the new widget.

Sales for favorable acceptance by customers would be 25,000 widgets selling for $90 each. With unfavorable acceptance, sales of the widgets would only be 8,000 widgets at a selling price of $90 each. The cost of the 3D printing system is $600,000. The hiring and training of four new employees would cost only $400,000. In the end, manufacturing costs should drop from $60 for each widget when manufacturing without 3D printing to $50 each when 3D printed.

The probability of favorable acceptance of the new widget is .40; the probability of unfavorable acceptance is .60

Assignment
Use Excel or Excel OM to build a decision tree. If you use Excel OM, make sure you carefully review the "Instructions & Example" provided in the OM plugin, and the example in your book. Submit your Excel decision tree along with a short explanation of what decision should be made by the company and how you arrived at your answer.

Save your assignment using a naming convention that includes your first and last name and the activity number (or description). Do not add punctuation or special characters.