'ou have been hired as a consultant to determine how cost effective ybrid cars are in the light of increasing gas prices. art 1 Build a mathematical formula showing the number of years it will take PAYBACK) for the extra cost of the hybrid car to pay for itself (given its igher fuel efficiency) as a function of the following variables: The price f the hybrid car (PRICE-H), the MPG of the hybrid car (MPG-H), the rice of its regular (non-hybrid) counterpart (PRICE-R), the MPG of its egular counterpart (MPG-R), the average distance driven per year (DIST), nd the price of gas (GAS). Use the exact names of the variables as given. our formula should show an equal sign, with PAYBACK on the left and te other variables on the right. In addition to showing the formula itself, Iso show how you derived the formula and where it came from. By what easoning? Once you have figured out the formula manually, build it in MS-Word sing the Equation capability under "Insert". 'onsider the following facts (don't argue with whether they are true or ot): - the hybrid car costs $35,000, and goes 40miles/ gallon - its regular (non-hybrid) counterpart costs $25,000, and goes 30 miles/gallon - you drive 20,000 miles/year on the average. 'ut this formula, as well as all the facts given above, into an Excel preadsheet. Use the spreadsheet to answer the following questions. Part 2 How long would the hybrid car take to pay for its extra cost (in light of the savings it will generate over time due to its higher fuel efficiency) if the price of gas were $6/ gallon? Show all your work utilizing the spreadsheet above. Part 3 At what current gas price would the hybrid car pay for itself in 3 years? Part 4 How sensitive is the payback period to the changes in the (average) distance driven per year? Answer this question by changing (increasing and decreasing) the values of DIST to show what relative (percentagewise) impact those changes have on PAYBACK. The document you turn in should show the answers to questions 1/2/3/4 above. Show everything in a single Word document and, as usual, convert the Word document into PDF format before turning it in. Do NOT upload any Excel spreadsheets. As a consultant, you need to help your client understand your calculations and conclusions. Explain everything in detail to be convincing. Do not pull rabbits out of a hat! Use LOGIC, not MAGIC!!! "You can tell gas prices are going up in California. Prius owners are getting that smug look again!" Jay Leno