Ford is going to produce a new vehicle, the Pioneer, and wants to determine the amount of annual capacity it should build. Ford's goal is to maximize the profit from this vehicle over the next five years. Each vehicle will sell for $19,000 and incur a variable production cost of $16,000. Building one unit of annual capacity will cost $2000. Each unit of capacity will also cost $1000 per year to maintain, even if the capacity is unused. Demand for the Pioneer is unknown but marketing estimates the distribution of annual demand to be as shown in the file P06 46.xlsx. Assume that the number of units sold during a year is the minimum of capacity and annual demand. Which capacity level should Ford choose? Do you think EMV is the appropriate criterion? ---- (Want a detailed solution with Excel sheet)

Demand distribution for new vehicle

Demand Probability

40,000 0.25

90,000 0.50

130,000 0.25