3. Develop a spreadsheet model for the gasoline usage scenario (Example1.3) using the data provided. Apply the principles of spreadsheet engineering in developing your model.(just need to solve for Total Miles gasoline usage) create formula and Gallons consumed a month (need to make a formula)

Example 1.3:

Gasoline Usage Model

Automobiles have different fuel economies (miles per gallon), and commuters drive different distances to work or school. Suppose that a state Department of Transportation (DOT) is interested in measuring the average monthly fuel consumption of commuters in a certain city. The DOT might sample a group of commuters and collect information on the number of miles driven per day, the number of driving days per month, the fuel economy of their vehicles, and additional miles driven per month for leisure and household activities. We may develop a simple descriptive model for calculating the amount of gasoline consumed, using the following symbols for the data:

G=gallonsof fuel consumed per month

m=milesdriven per day to and from work or school

d=numberof driving days per month

f =fueleconomy in miles per gallon (mpg)

a =additionalmiles for leisure and household activities per month

When developing mathematical models, it is very important to use the dimensions of the variables to ensure logical consistency. In this example, we see that

G=(mmiles/day)(ddays/month)=mdmiles/month(mmiles/day)(ddays/month)=md miles/month

Thus, the total number of miles drivenpermonth=md+a.permonth=md+a.If the vehicle getsfmiles/gallon, then the total number of gallons consumed per month is

G=(md+amiles/month)/(fmiles/gallon)(md+a)/fgallons/monthG=(md+amiles/month)/(fmiles/gallon)=(md+a)/fgallons/month

Suppose that a commuter drives 30 miles round trip to work for 20 days each month, achieves a fuel economy of 34 mpg, and drives an additional 250 miles each month.

Using formula,(G=(md+amiles/month)/(fmiles/gallon)(md+a)/fgallons/month), the number of gallons consumed is G=(3020+250)/34=25.0gallons/month