New vehicle depends on the severity of the accident

Assignment Help Operation Management

Reference no: EM13964314

Mr. Maloy has just bought a new $40,000 sport utility vehicle. Given his health conditions, he believes that there is about a 15% chance of being in an accident (that he caused) in the forthcoming year. If he is involved in an accident (he causes), the damage to his new vehicle depends on the severity of the accident (see table). Mr. Maloy is trying to decide whether he is willing to pay $600 each year to buy collision insurance with a $1500 deductible (i.e. He pays the first $1,500 in damages if he causes an accident and the insurance company pays the remainder.) Should he buy the insurance? (Note that if the accident is caused by another person that other person is responsible to pay for the damages to Mr. Maloy’s vehicle.) Therefore there are only two cases – 1. An accident he causes 2. No accident or an accident caused by someone else.

Probability of an accident (he causes) 15%

Cost of insurance $600

Deductible $1,500

Type of Accident Cost Cond. Probability

Total $40,000 5%

Very Bad $10,000 15%

Unpleasant $3,000 25%

Little Damage $1,000 55%

Please give me the excel worksheet answer with formulas

Reference no: EM13964314

Questions Cloud

Analyze and prepare to discuss at least three problems : Use the below Case Study to Identify, analyze and prepare to discuss at least three problems and/or issues related to the successful formation, development and operation of cross-cultural teams in the case context.

Economic order quantity-what is total ordering cost for year : An energy company orders railcar loads of coal at a rate of 62,500 tons per year. Delivery lead time is variable, but has averaged 5 days. The annual cost to hold inventory is $200 per ton and each order that is placed with the supplier costs $2,500 ..

Preparation of a persuasive speech : Discuss the challenges one would have in the preparation of a persuasive speech. How can one overcome these challenges? What advice would you give to your peers/colleagues?

Non-probability sampling designs ought to be preferred : “Use of a sample of 5000 is not necessarily better than one of 500”. What is your reaction to this statement? Non-probability sampling designs ought to be preferred to probability sampling designs in some cases. Explain with an example.

New vehicle depends on the severity of the accident : Mr. Maloy has just bought a new $40,000 sport utility vehicle. Given his health conditions, he believes that there is about a 15% chance of being in an accident (that he caused) in the forthcoming year. If he is involved in an accident (he causes), t..

Capital budgeting problem with six projects-binary variables : The following questions refer to a capital budgeting problem with six projects represented by binary variables a, b, c, d, e, and f.

Why it is important to balance conformity and deviance : You are part of a management team in charge of food services for a large state university in the Midwest. Recently, a survey of students, faculty, and staff was conducted to evaluate customer satisfaction with the food services provided by the univer..

Demand while lower prices result in an increased in demand : For most products, higher prices result in a decreased in demand while lower prices result in an increased in demand. Let D be the annual demand for a product in units and P be the unit selling price in dollars. The price-demand relationship can be d..

A top executive claimed that top-level management : A top executive claimed that top-level management is craft technolgy becuase the work contains intangibles, such as handing personnel, interpreting the environment, and coping with unucal situations that have to be learned through experience. If th..

User Account

All Pages