Please recreate the attached calculations in Excel. Provide explanations and calculations in EXCEL.. You MUST develop an active Excel sheet to show me how you arrive at the answers provided for this analysis using EXCEL . Once you have completed the spreadsheet, up load it here for my review and grading. YOU MUST SHOW ALL OF YOUR WORK.

a. First, compute the yearly expected price of diesel fuel for both assumption 1 (relatively low prices) and assumption 2 (high prices) from the forecasts that follow. GIVEN INFORMATION TO COMPUTE A.

Probability (same for each year)	Price of Diesel Fuel per Gallon
	Year 1	Year 2	Year 3
.1	$ .80	$ .90	$1.00
.2	1.00	1.10	1.10
.3	1.10	1.20	1.30
.2	1.30	1.45	1.45
.2	1.40	1.55	1.60

Forecast for assumption 2 (high fuel prices):

Probability (same for each year)	Price of Diesel Fuel per Gallon
	Year 1	Year 2	Year 3
.1	$1.20	$1.50	$1.70
.3	1.30	1.70	2.00
.4	1.80	2.30	2.50
.2	2.20	2.50	2.80

Kennedy Trucking Company investment decision based on probability analysis) (LO13-1) Five years ago, Kennedy Trucking Company was considering the purchase of 60 new diesel trucks that were 15 percent more fuel-efficient than the ones the firm is now using. Mr. Hoffman, the president, had found that the company uses an average of 10 million gallons of diesel fuel per year at a price of $1.25 per gallon. If he can cut fuel consumption by 15 percent, he will save $1,875,000 per year (1,500,000 gallons times $1.25). Kennedy Trucking Company investment decision based on probability analysis) (LO13-1) Five years ago, Kennedy Trucking Company was considering the purchase of 60 new diesel trucks that were 15 percent more fuel-efficient than the ones the firm is now using. Mr. Hoffman, the president, had found that the company uses an average of 10 million gallons of diesel fuel per year at a price of $1.25 per gallon. If he can cut fuel consumption by 15 percent, he will save $1,875,000 per year (1,500,000 gallons times $1.25). Kennedy Trucking Company investment decision based on probability analysis) (LO13-1) Five years ago, Kennedy Trucking Company was considering the purchase of 60 new diesel trucks that were 15 percent more fuel-efficient than the ones the firm is now using. Mr. Hoffman, the president, had found that the company uses an average of 10 million gallons of diesel fuel per year at a price of $1.25 per gallon. If he can cut fuel consumption by 15 percent, he will save $1,875,000 per year (1,500,000 gallons times $1.25). Kennedy Trucking Company investment decision based on probability analysis) (LO13-1) Five years ago, Kennedy Trucking Company was considering the purchase of 60 new diesel trucks that were 15 percent more fuel-efficient than the ones the firm is now using. Mr. Hoffman, the president, had found that the company uses an average of 10 million gallons of diesel fuel per year at a price of $1.25 per gallon. If he can cut fuel consumption by 15 percent, he will save $1,875,000 per year (1,500,000 gallons times $1.25)