please help solve

E Spreadsheet A company is considering three vendors for purchasing a CRM system: Delphi Inc, CRM International, and Murray Analytics. The costs of the system are expected to depend on the length of time required to implement the system, which depends on such factors as the amount of customization required, Integration with legacy systems, resistance to change, and so on. Each vendor has different expertise in handling these things, which affect the cost. The costs (in millions of $) are shown below for short, medium, and long implementation durations. Use the Excel template Decision Analysis to identify what vender to select Decision Alternative Short Medium Long Delphi Inc $4.50 $5.35 $7.00 CRM International $3.95 $6.10 $7.50 Murray Analytics $4.00 $6.25 $7.95 Fill in the table below for maximum and minimum costs under each alternative. Carry out an analysis considering costs as negative numbers. Round your answers to the nearest cent Decision Alternative Maximum Minimum Delphi Inc $ CRM International $ Murray Analytics $ Calculate the amounts foregone by not adopting the optimal course of action for each possible implementation duration, Determine the maximum opportunity cost for each alternative. Fill in the table below. If your answer is zero, entero Round your answers to the nearest cant. Opportunity Loss Matrix Future events Decision Alternative Short Medium Long Maximum Delphi Inc $ CAM International $ Murray Analytics $ Conduct a decision analysis to evaluate the choice of a vendor The aggressive strategy (maximax) is to choose the select The conservative strategy (maximin) is to choose the Select The opportunity fose strategy is to choose the Select We appropriate cells in column A ork and row 7. Probabilities are optional 5 6 Payoff Table Future Events 7 Decision Alternative Low Product Demand High Product Demand Maximum Minimum B Expand existing plant Expected Value $200,000.00 $300,000.00 $300,000.00 $200,000.00 9 Build new plant $100,000.00 $450,000.00 $450,000.00 $100,000.00 10 11 12 13 Probability Maximum Expected Value 30.00 14 15 Opportunity Loss Matrix Future Events 16 Decision Alternative Low Product Demand High Product Demand Maximum 17 Expand existing plant $0.00 $150,000.00 $150,000.00 18 Build new plant $100,000.00 $0.00 $100,000.00 19 20 21 22 | Max Imak Decision Build new plant Maximin Decision Expand existing plant 25 Opportunity Loss Decision Build new plant Expected Value Decision HN/A EVPI #N/A 28 . Decision Analysis Wabook Statistics E Spreadsheet A company is considering three vendors for purchasing a CRM system: Delphi Inc, CRM International, and Murray Analytics. The costs of the system are expected to depend on the length of time required to implement the system, which depends on such factors as the amount of customization required, Integration with legacy systems, resistance to change, and so on. Each vendor has different expertise in handling these things, which affect the cost. The costs (in millions of $) are shown below for short, medium, and long implementation durations. Use the Excel template Decision Analysis to identify what vender to select Decision Alternative Short Medium Long Delphi Inc $4.50 $5.35 $7.00 CRM International $3.95 $6.10 $7.50 Murray Analytics $4.00 $6.25 $7.95 Fill in the table below for maximum and minimum costs under each alternative. Carry out an analysis considering costs as negative numbers. Round your answers to the nearest cent Decision Alternative Maximum Minimum Delphi Inc $ CRM International $ Murray Analytics $ Calculate the amounts foregone by not adopting the optimal course of action for each possible implementation duration, Determine the maximum opportunity cost for each alternative. Fill in the table below. If your answer is zero, entero Round your answers to the nearest cant. Opportunity Loss Matrix Future events Decision Alternative Short Medium Long Maximum Delphi Inc $ CAM International $ Murray Analytics $ Conduct a decision analysis to evaluate the choice of a vendor The aggressive strategy (maximax) is to choose the select The conservative strategy (maximin) is to choose the Select The opportunity fose strategy is to choose the Select We appropriate cells in column A ork and row 7. Probabilities are optional 5 6 Payoff Table Future Events 7 Decision Alternative Low Product Demand High Product Demand Maximum Minimum B Expand existing plant Expected Value $200,000.00 $300,000.00 $300,000.00 $200,000.00 9 Build new plant $100,000.00 $450,000.00 $450,000.00 $100,000.00 10 11 12 13 Probability Maximum Expected Value 30.00 14 15 Opportunity Loss Matrix Future Events 16 Decision Alternative Low Product Demand High Product Demand Maximum 17 Expand existing plant $0.00 $150,000.00 $150,000.00 18 Build new plant $100,000.00 $0.00 $100,000.00 19 20 21 22 | Max Imak Decision Build new plant Maximin Decision Expand existing plant 25 Opportunity Loss Decision Build new plant Expected Value Decision HN/A EVPI #N/A 28 . Decision Analysis Wabook Statistics