# Question

An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors:

The fixed cost of developing the Racer is triangularly distributed with parameters $3, $4, and $5, all in billions.

• Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000.

• The selling price in year 1 is $25,000. The year 2 selling price will be 1.05[year 1 price + $50

• (% diff1)] Where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50(–10)] = $25,725. Similarly, the year 3 price will be 1.05[year 2 price + $50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales.

• The variable cost in year 1 is triangularly distributed with parameters $10,000, $12,000, and $15,000, and it is assumed to increase by 5% each year.

Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.

The fixed cost of developing the Racer is triangularly distributed with parameters $3, $4, and $5, all in billions.

• Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000.

• The selling price in year 1 is $25,000. The year 2 selling price will be 1.05[year 1 price + $50

• (% diff1)] Where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50(–10)] = $25,725. Similarly, the year 3 price will be 1.05[year 2 price + $50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales.

• The variable cost in year 1 is triangularly distributed with parameters $10,000, $12,000, and $15,000, and it is assumed to increase by 5% each year.

Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.

## Answer to relevant Questions

The file S02_06.xlsx lists the average time (in minutes) it takes citizens of 379 metropolitan areas to travel to work and back home each day.a. Create a histogram of the daily commute times.b. Find the most representative ...The file S02_17.xlsx contains salaries of 200 recent graduates from a (fictional) MBA program. a. What salary level is most indicative of those earned by students graduating from this MBA program this year?b. Do the ...In which months of the calendar year do U.S. gasoline service stations typically have their lowest retail sales levels? In which months of the calendar year do the service stations typically have their highest retail sales ...It costs a pharmaceutical company $40,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely ...The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The ...Post your question

0