Question: Please help me solve this problem in excel if possible Your small remodeling business has two work vehicles. One is a small passenger car used
Please help me solve this problem in excel if possible

Your small remodeling business has two work vehicles. One is a small passenger car used for job-site visits and for other general business purposes. The other is a heavy truck used to haul equipment. The car gets 25 miles per gallon \\( (\\mathrm{mpg}) \\). The truck gets 10 \\( \\mathrm{mpg} \\). You want to improve gas mileage to save money, and you have enough money to upgrade one vehicle. The upgrade cost will be the same for both vehicles. An upgraded car will get \\( 40 \\mathrm{mpg} \\); an upgraded truck will get \\( 12.5 \\mathrm{mpg} \\). The cost of gasoline is \\( \\$ 3.65 \\) per gallon. Calculate the annual fuel savings, in gallons, for the truck and car assuming both vehicles are driven \\( \\mathbf{1 1 , 5 0 0} \\) miles per year. (Round your answers to \\( \\mathbf{2} \\) decimal places, e.g., 32.16.) Assuming an upgrade is a good idea in the first place, which one should you upgrade? Both vehicles are driven 11,500 miles per year. Truck Car
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
