Question

calculating excess - mileage fees
a math student is analyzing a lease agreement that includes a clause for excess - mileage fees. if the lease allows for 12,000 miles per year and the student plans to drive 14,000 miles in one year, how should they set up their spreadsheet to calculate the excess mileage fee for that year, given the fee is $0.20 per mile over the limit?
=12000·(14000·(
=\frac{12000}{(14000·0.20)}
=(14000 - 12000)
=14000·0.20 - 12

Explanation:

Step1: Calculate excess miles

First, find the number of miles over the limit. Subtract the allowed miles from the planned miles.
$$14000 - 12000$$

Step2: Calculate excess - mileage fee

Multiply the excess miles by the fee per mile. The formula for the excess - mileage fee \(F\) is \(F=(14000 - 12000)\times0.20\). In spreadsheet terms, if we assume cell \(A1 = 14000\) (planned miles) and cell \(B1=12000\) (allowed miles), and cell \(C1 = 0.20\) (fee per mile), the formula would be \((A1 - B1)\times C1\).

Answer:

\(=(14000 - 12000)\times0.20\) (the correct formula among the given options is \(=(14000 - 12000)\) followed by multiplying by \(0.20\) which is not fully shown in the given options, but if we consider the structure of spreadsheet formulas for this problem, the part \(=(14000 - 12000)\) is the first - step in building the formula for calculating excess miles before multiplying by the per - mile fee. If we assume the options are cut - off, the most relevant formula start for calculating the excess - mileage fee from the given options is \(=(14000 - 12000)\))