Excel statement: "I completed this excel question by myself. I earned 100%. 1. Cost-volume-profit analysis (CVP) will be used to determine whether there is an economic justification for buying a Corolla Hybrid Car versus Corolla Gas Car. The analysis will focus on the cost of owning the car with battery replacement for Hybrid car and cost of gasoline consumption in the period of 6 years. @ 14,263 miles Yearly Ave. Miles per Gas $ per Gas $ in 6 Corolla Hybrid Corolla Gas per year Travel (Miles) Gallon Gallon years Car Car Hybrid Gas Yearly Ave. Travel (miles) 14,263 14,263 Consumption 14.263 53 4.16 $ 6,717.07 53 32 Non-Hybri Gas Gas Mileage (miles/gallon) Consumption 14.263 32 4.16 $ 11,125.14 Gas $ per gallon 4.16 4.16 2 Years Complementary Maintanar 0 @ 25,000 miles Yearly Ave. Miles per Gas $ per Gas $ in 6 MSRP S 22,800 $ 21,550 per year Travel (Miles) Gallon Gallon years Battery Replacement (after 6 yrs) S 5,000 $ Hybrid Gas Consumption 25,000 53 4.16 11,773.58 Car cost in 6 years: $ 27,800 $ 21,550 Non-Hybri Gas Consumption 25,000 32 4.16 $ 19,500.00 Corolla Hybrid Corolla Gas @ 14,263 miles per year Car Car Difference Corolla Hybrid Corolla Gas @ 25,000 miles per year Car Car Differrence MSRP $ 22,800 $ 21,550 MSRP 22.800 $ 21,550 Battery Replacement (after 6 yrs) $ 5,000 $ 5,000 $ Gas cost in 6 years $ 6,717.07 $ 11,125.14 Battery Replacement (after 6 yrs) $ Gas cost in 6 years $ 11,773.58 $ 19,500.00 Total Cost of Car in 6 years. $ 34,517.07 $ 32,675.14 $ 1,841.93 Total Cost of Car in 6 years: $ 39,573.58 $ 41,050.00 $ (1,476.42) Gas car total cost is $ 1,841.93 cheaper compared to Hybrid car if the yearly average travel is 14,263 miles. Hybrid will become cheaper by $ 1,476.42 versus Gas car if yearly average travel is 25,000 miles. Distance travel and gas consumption are the key justifications in buying a car. Buyers should consider a Gas car if yearly travel is below yearly average of 14,263 miles. While Hybrid car should be considered if travel is beyond the yearly average