Zookal Homework Help

Homework Help

  1. Business
  2. Operations Management
  3. use excel om to build a decision tree make sure...

Question: use excel om to build a decision tree make sure...

Question details

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 » Before you start building your decision tree, review the How to Build a Decision Tree in Excel OM example presentation narrated by the course developer Dr. Bob Walton.

Use Excel OM to build a decision tree. 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.

PLEASE PROVIDE THE FORMULAS

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution