just answer number 2

1. Determine the total VMT under the two plans indicated below. Find the percent reduction of PLAN 2 relative to PLAN 1, in terms of VMT and Personal Miles of Travel (PMT). Total Persons Vehicles Traveling Occupancy Average Miles Per Vehicle Per Week Plan 1 City 10,000 10,000 Suburbs 10,000 10,000 NPNP 1 2 1 2 100 120 170 200 Plan 2 City 7,000 13,000 Suburbs 5,000 15,000 1 2 1 2 90 110 150 160 2. Set Problem #1 up on a spreadsheet so that changes in the indicated values will yield immediate results of the effect of Plan 2 relative to Plan 1 in terms of VMT, PMT, vehicle occupancy, fuel savings (gallons per year), and revenue changes (dollars per year). For fuel computations, use 16 mpg as the consumption rate in urban travel and 18 mpg for suburban travel. For revenue estimates, use the tax in your area on unleaded regular gasoline. (a) Experiment with shifts in people from one-person cars to two-person cars, plotting VMT (percent reduction) as a function of the shift. (b) Plot revenue changes (percent) on the same axis