Decision tree project, Risk Management

Assignment Help:

You work for a company that sells expensive equipment to other companies. The marketing director has closed on a substantial sale (for your company) but the customer has requested that the sale be done on a credit basis instead of being paid in full on delivery. In order to evaluate this request, you make the following assumptions:

  • If we deny the credit request, there is a 20% chance the customer will buy the machine with cash anyway.
  • If we grant the credit request, there is a 70% chance that the customer will be a good credit risk.
  • If we grant credit and the customer is a good credit risk, then the bill will be paid in full.

The issue that requires some analysis comes if we grant the credit request and the customer turns out to be a bad credit risk. In this case, your company has two options. First, we could continue to send the customer a bill and hope eventually to be paid. Under this option, we would receive all of the money with a probability of 10%, we would get only half the money with a probability of 20%, and we would get nothing with a probability of 70%. The second option would be to more actively pursue the collection of the amount owed. To take the necessary actions would cost the company about 20% of the amount the customer owes, regardless of what amount is eventually collected, as a payment to the company pursuing the collection. As before, the customer might pay all, half or nothing. The probabilities of these three outcomes are 30%, 50% and 20%, respectively. The machine the customer is considering sells for $80,000 and costs us $45,000 to make. Note that this means that the collection cost of the second option would be $20,000.

1.) Create a decision tree representation for this problem in Excel. What are the decision nodes, what are the chance nodes.

2.) What is the expected value of this customer order? What decisions lead to this value?

3.) Suppose that the probability that the customer will buy without being offered credit changes. Create a data table to show what decisions should be made for different probabilities.

4.) Suppose that the cost of the credit collection process changes. Create a data table to show what decisions should be made for different costs.

5.) Consider the first option for collections. Suppose that the probability for the customer paying in full ranges from 0% to 40%, and that the probability that they pay half ranges from 0% to 50%. Create a two-way data table and determine the value of the potential sale under the various possible conditions.

Part Two

In order to make a more informed decision, you decide to collect some sample information by talking to local CPA that knows a little about your potential customer. They can tell you that they think the customer is "strong" or "weak." They also tell you that out of the companies that were good risks, they rated 75% of them as strong. Of the companies that were bad risks, they rated only 15% as strong.

Assume that the collection probabilities of the two options are not affected by the sample information about the customer.

1.) Calculate the probability that the CPA will rate the customer strong. The probability of a weak rating.

2.) If the CPA gives you a strong rating, what are the probabilities about whether the customer is a good or bad credit risk. What are the probabilities if the CPA rates the customer as weak.

3.) Create a decision tree that incorporates the sample information. What are the best decisions to make? What is the expected value of the potential customer.

4.) What would you be willing to pay the CPA for the information about the customer?


Related Discussions:- Decision tree project

What is a safe system of work, Question 1: Employers should conduct pro...

Question 1: Employers should conduct proper health risk assessment in order to identify and control health risks before they lead to losses. Describe the four stages involved i

Steps that a project manager include in risk management, Risk management is...

Risk management is an important aspect of managing a project in order to ensure that the project objectives are completed successfully and with the minimum of undesirable events. T

Disaster recovery plan, Devise a disaster recovery plan • Business Impact A...

Devise a disaster recovery plan • Business Impact Analysis • Treatment Strategies: o Risk Avoidance o Risk Reduction o Risk Transfer o Risk Retention • Ingredients of a disaster re

Explain in brief about the default risk, Explain in brief about the Default...

Explain in brief about the Default Risk It's that portion of an investment's total risk which results from changes in the financial integrity of the investment. For instance

What is risk appetite?, QUESTION 1 A. Answer all of the following (a...

QUESTION 1 A. Answer all of the following (a) What is risk appetite? (b) List any two risk responses (c) What does ITIL stand for? (d) What is a business case? (

Risk Analysis & Modelling , Fire Risk model 1 1. Introduction The new All...

Fire Risk model 1 1. Introduction The new All-Scotland Fire Authority wishes to maximise the effectiveness of the service it provides to the Public, given the reduced budget it w

What is material safety data sheet, Q. What is Material Safety Data Sheet ?...

Q. What is Material Safety Data Sheet ? 1. Material Safety Data Sheet is a formal document containing important information about the characteristics and actual or potential ha

Consumptive use and non-consumptive uses, (i) Describe your notion of "mari...

(i) Describe your notion of "marine biodiversity" with an appropriate illustration? (ii) Name the different levels at which marine biodiversity can be depicted in the marine en

Explain role of the project manage, Question 1: Explain role of the pro...

Question 1: Explain role of the project manager throughout a project life cycle with reference to the following. (a) Setting up a project team (and the factors he has to con

Certification, what will be the number one credential for risk management?

what will be the number one credential for risk management?

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd