Question: Can you solve part a and b for me please? Mrs. Jones, the owner of an art gallery, needs to rent a car for her


Can you solve part a and b for me please?
Mrs. Jones, the owner of an art gallery, needs to rent a car for her upcoming business trip. A local car rental company provides her with an itemized rental quote for her to review. The information can be found in an Excel file called 'PracticeDS data car rental.xlsx ' and can be downloaded here. Your task is to help the owner with her rental expense options. a. If Mrs. Jones wants to spend the exact total amount of $500 on her projected car rental expense, the gasoline price per gallon must be (answer in 4 decimal points) (hint: use Goal Seek for this question). b. With the current fluctuation in gasoline prices, vary the prices between $4.20 per gallon and $5.80 per gallon, incremented by 20 cents and vary the estimated number of miles to drive between 325 and 450 , incremented by every 25 miles (hint: create a 2-input data table). -If the estimated number of miles driven is 325 , for a projected car rental expense of $500 the price range for gasoline must be per gallon. -If the estimated number of miles driven is 375 , for a projected car rental expense of $500 the price range for gasoline must be per gallon. Rental Car Cost Analysis
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
