OpMHMvDjCLtUCdXvlhSsKvSqwdrjsnCdXvlhSsKvSqwdrjsnOpMHMvDjCvSqwdrjsnOpMHMvDjCLtUCdXvlLtUCdXvlhSsKvSqwdrjsOpMHMvDjCLtUCdXvlhSsKvSqwdrjsCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnCdXvlhSsKvSqwdrjsnOpMHMvDjCvSqwdrjsnOpMHMvDjCLtUCdXvlLtUCdXvlhSsKvSqwdrjsOpMHMvDjCLtUCdXvlhSsKvSqwdrjsCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnCdXvlhSsKvSqwdrjsnOpMHMvDjCvSqwdrjsnOpMHMvDjCLtUCdXvlLtUCdXvlhSsKvSqwdrjsOpMHMvDjCLtUCdXvlhSsKvSqwdrjsCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnCdXvlhSsKvSqwdrjsnOpMHMvDjCvSqwdrjsnOpMHMvDjCLtUCdXvlLtUCdXvlhSsKvSqwdrjsOpMHMvDjCLtUCdXvlhSsKvSqwdrjsCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnCdXvlhSsKvSqwdrjsnOpMHMvDjCvSqwdrjsnOpMHMvDjCLtUCdXvlLtUCdXvlhSsKvSqwdrjsOpMHMvDjCLtUCdXvlhSsKvSqwdrjsCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnCdXvlhSsKvSqwdrjsnOpMHMvDjCvSqwdrjsnOpMHMvDjCLtUCdXvlLtUCdXvlhSsKvSqwdrjsOpMHMvDjCLtUCdXvlhSsKvSqwdrjsCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnCdXvlhSsKvSqwdrjsnOpMHMvDjCvSqwdrjsnOpMHMvDjCLtUCdXvlLtUCdXvlhSsKvSqwdrjsOpMHMvDjCLtUCdXvlhSsKvSqwdrjsCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjsnOpMHMvDjCLtUCdXvlhSsKvSqwdrjs

---------------

Please ignore the photo above and the random letters, just focus on solving the questions below.

********** PLEASE SOLVE ALL THE QUESTIONS *****

What we need to do is: Just provide your excel spreadsheet with your decision tree and write an executive report with your recommendations on the same excel spreadsheet.

ROW 1: 4408 35 29 73 63 85 49 70 2290374449 40 3 19 49 89 398 ROW 2: 538 679 389 38 870 75 038 1037 15 432 50 49 75 77 2 996 Row 3: 2 2 0 2 991 461 05 28 94497173799654693978316047 Row 4: 34 0 8 4 35 22 92 556 6 4 42 95536 566 36 58 375 3776702 Row 5: 59 7 4 3 4 6 791 48 8 712 394 3 4 4 8 1 35 16 8 9 850 7943970 Row 6: 34 15870790 2 3 8 5 4 7 8 3 6 0 4 1 701 6 6 8 7 8 8 9 6 5 8 6 4 5 6 7 Row 7: 762 2408301 8 6 3 9 19 1795 1 9 5 4 1 09433 9 6 5 3 2 8 7 2 8 6 Row 8: 60362 817705 435 4127346 8 978 2 9 2465 89 129 3002 ROW 9: 1103132713698 309 445 620808 919 89243 4 6 5 6 6 13 Row 10: 28 8 8 82 16 20 60 4415 42 5940 171 86 38790470 16 5 28 Row 11: 57370 39 39 0 0 1 0 57 7 9 9 2 6 4 58 37 5 8 8 0 25530 26 34 18 Row 12: 354306 56 35 12 77 22 16 16 0 9 6 2 6 6 80371 1290 38 969 Row 13: 20 77715750135 998 1 0 8 8 8 24 1 8 8 906 0 1 5 5 6 6 8 0 796 ROW 14: 76 826 671 38 33 855 366 31 31 1 3443501 256 24 43927 Row 15: 6 4 5 6 8 19 10 31 8 52 53 55 9370166 70 221 26 5 6 7 8 6 4 6 9 Row 16: 9 6 7 9 7 19 0362 856 0 2 4 1 1 8 0 71 1 9 9 1 7 6 18 22 376 8633 Row 17: 36 605 72 5 9 8 710 776 43 90 6 8 8 4 1 900 46 6 8 8 479 2 8 47 Row 18: 7905346 62 2131 290 487 5 3 2607333 2 6 2 5742098 85 Ventron Engineering The Ventron Engineering Company has just been awarded a development contract by the US Army Aviation Systems Command to design, develop, and demonstrate critical components of a new rotor system. The system will be part of the Heavy Lift Helicopter program which is currently receiving much attention in the industry. An integral part of the rotor system is the blade spar. The blade spar is a metal tube which runs the length of and provides strength to the helicopter blade. Due to the unusual length and size of the Heavy Lift Helicopter blade, Ventron is unable to produce a single-piece blade spar of the required dimensions, using existing extrusion equipment and material. The engineering department has prepared two alternatives for developing the blade spar: sectioning, and improvement of the extrusion process. Ventron is faced with a decision as to which process it should select. Sectioning This process involves joining several shorter lengths of extruded metal into a blade spar of sufficient length. This work will require extensive testing and rework over a 12-month period at a cost of $150.000 per month. While this process will definitely produce an adequate blade spar, it merely represents an extension of existing technology Extrusion In order to extrude the blade spar as a single piece it will be necessary to modify the extrusion press at a monthly cost of $ 160.000 and to improve the material used at a monthly cost of $50,000. Each of these steps would require six months of steady work. If successful, this process would produce a blade spar of superior quality at a lower overall cost. Unfortunately, as opposed to sectioning, there is some risk that Ventron will be unable to perfect the process. After studying the technical problems, the engineering department feels there is a nine in ten chance of perfecting the material. However, the other possibility (a one in ten chance) is that at the end of the six- month development effort it will know that a satisfactory material cannot be developed within any reasonable time and cost framework and it will have to rely on sectioning. The engineers believe there is a three in four chance of successfully modifying the press, but a one in four chance that at the end of a six-month press development project the extrusion process will have to be abandoned, because a press with the necessary capabilities will be shown to be infeasible. Development of the blade spar must be completed within 18 months in order to avoid holding up the rest of the contract. It has also been determined that if necessary, the sectioning work could be done on an accelerated basis in a six-month period at a monthly cost of $400,000. The Director of Engineering, Dr. Smith, is most interested in the opportunity provided by this contract to explore new technology in the sion process. He feels that if Ventron is successful in producing the blade spar as a single piece Ventron's reputation in the field will be greatly enhanced. In addition, it would be able to complete development of the blade spar well under budget. After a preliminary review of the problem, Ventron's President, Bill Walters, has not yet reached a final decision. Like Dr. Smith, he is intrigued by the possibility of successfully developing the extrusion process. He feels that this would give Ventron an excellent chance at some additional contracts. He is concerned, however, about the possibility of wasting money on unsuccessful development or of being forced to do sectioning on an accelerated basis. Ventrons contract with the Army is for a fixed total amount spread over several years. Walters wants to minimize the expenditures on the blade spar portion to free up money for technical developments on other components of the rotor system, which would improve Ventron's position for future business, both defense and commercial. Exhibit 1 Risk report: Blade spar development Cost/month Probability of Time required for Total Cost ($000) Success effort (months) ($000) Extrusion development Material development .......... Press modification 50 160 0.9 0.75 6 6 300 960 Sectioning Normal basis ..... Accelerated 150 400 1.0 1.0 12 6 1.800 2.400 ROW 1: 4408 35 29 73 63 85 49 70 2290374449 40 3 19 49 89 398 ROW 2: 538 679 389 38 870 75 038 1037 15 432 50 49 75 77 2 996 Row 3: 2 2 0 2 991 461 05 28 94497173799654693978316047 Row 4: 34 0 8 4 35 22 92 556 6 4 42 95536 566 36 58 375 3776702 Row 5: 59 7 4 3 4 6 791 48 8 712 394 3 4 4 8 1 35 16 8 9 850 7943970 Row 6: 34 15870790 2 3 8 5 4 7 8 3 6 0 4 1 701 6 6 8 7 8 8 9 6 5 8 6 4 5 6 7 Row 7: 762 2408301 8 6 3 9 19 1795 1 9 5 4 1 09433 9 6 5 3 2 8 7 2 8 6 Row 8: 60362 817705 435 4127346 8 978 2 9 2465 89 129 3002 ROW 9: 1103132713698 309 445 620808 919 89243 4 6 5 6 6 13 Row 10: 28 8 8 82 16 20 60 4415 42 5940 171 86 38790470 16 5 28 Row 11: 57370 39 39 0 0 1 0 57 7 9 9 2 6 4 58 37 5 8 8 0 25530 26 34 18 Row 12: 354306 56 35 12 77 22 16 16 0 9 6 2 6 6 80371 1290 38 969 Row 13: 20 77715750135 998 1 0 8 8 8 24 1 8 8 906 0 1 5 5 6 6 8 0 796 ROW 14: 76 826 671 38 33 855 366 31 31 1 3443501 256 24 43927 Row 15: 6 4 5 6 8 19 10 31 8 52 53 55 9370166 70 221 26 5 6 7 8 6 4 6 9 Row 16: 9 6 7 9 7 19 0362 856 0 2 4 1 1 8 0 71 1 9 9 1 7 6 18 22 376 8633 Row 17: 36 605 72 5 9 8 710 776 43 90 6 8 8 4 1 900 46 6 8 8 479 2 8 47 Row 18: 7905346 62 2131 290 487 5 3 2607333 2 6 2 5742098 85 Ventron Engineering The Ventron Engineering Company has just been awarded a development contract by the US Army Aviation Systems Command to design, develop, and demonstrate critical components of a new rotor system. The system will be part of the Heavy Lift Helicopter program which is currently receiving much attention in the industry. An integral part of the rotor system is the blade spar. The blade spar is a metal tube which runs the length of and provides strength to the helicopter blade. Due to the unusual length and size of the Heavy Lift Helicopter blade, Ventron is unable to produce a single-piece blade spar of the required dimensions, using existing extrusion equipment and material. The engineering department has prepared two alternatives for developing the blade spar: sectioning, and improvement of the extrusion process. Ventron is faced with a decision as to which process it should select. Sectioning This process involves joining several shorter lengths of extruded metal into a blade spar of sufficient length. This work will require extensive testing and rework over a 12-month period at a cost of $150.000 per month. While this process will definitely produce an adequate blade spar, it merely represents an extension of existing technology Extrusion In order to extrude the blade spar as a single piece it will be necessary to modify the extrusion press at a monthly cost of $ 160.000 and to improve the material used at a monthly cost of $50,000. Each of these steps would require six months of steady work. If successful, this process would produce a blade spar of superior quality at a lower overall cost. Unfortunately, as opposed to sectioning, there is some risk that Ventron will be unable to perfect the process. After studying the technical problems, the engineering department feels there is a nine in ten chance of perfecting the material. However, the other possibility (a one in ten chance) is that at the end of the six- month development effort it will know that a satisfactory material cannot be developed within any reasonable time and cost framework and it will have to rely on sectioning. The engineers believe there is a three in four chance of successfully modifying the press, but a one in four chance that at the end of a six-month press development project the extrusion process will have to be abandoned, because a press with the necessary capabilities will be shown to be infeasible. Development of the blade spar must be completed within 18 months in order to avoid holding up the rest of the contract. It has also been determined that if necessary, the sectioning work could be done on an accelerated basis in a six-month period at a monthly cost of $400,000. The Director of Engineering, Dr. Smith, is most interested in the opportunity provided by this contract to explore new technology in the sion process. He feels that if Ventron is successful in producing the blade spar as a single piece Ventron's reputation in the field will be greatly enhanced. In addition, it would be able to complete development of the blade spar well under budget. After a preliminary review of the problem, Ventron's President, Bill Walters, has not yet reached a final decision. Like Dr. Smith, he is intrigued by the possibility of successfully developing the extrusion process. He feels that this would give Ventron an excellent chance at some additional contracts. He is concerned, however, about the possibility of wasting money on unsuccessful development or of being forced to do sectioning on an accelerated basis. Ventrons contract with the Army is for a fixed total amount spread over several years. Walters wants to minimize the expenditures on the blade spar portion to free up money for technical developments on other components of the rotor system, which would improve Ventron's position for future business, both defense and commercial. Exhibit 1 Risk report: Blade spar development Cost/month Probability of Time required for Total Cost ($000) Success effort (months) ($000) Extrusion development Material development .......... Press modification 50 160 0.9 0.75 6 6 300 960 Sectioning Normal basis ..... Accelerated 150 400 1.0 1.0 12 6 1.800 2.400