apply 2-1 village of scott police department - done

Upload: gagooda

Post on 12-Oct-2015

53 views

Category:

Documents


4 download

DESCRIPTION

Microsoft Excel 2010 Comprehensive

TRANSCRIPT

Vehicle Cost-per-Mile SummaryVillage of Scott Police DepartmentMonthly Vehicle Cost-per-Mile SummaryVehicle IDMiles DrivenCostper MileMaintenanceCostMileageCostTotal CostTotal Costper Mile6705432,007$0.49$242.80$983.43$1,226.23$0.619792533,1920.48446.371,532.161,978.530.629481733,8020.65472.472,471.302,943.770.778376252,0800.62432.251,289.601,721.850.838246642,4750.56369.881,386.001,755.880.716553853,2940.5352.051,647.001,999.050.618364173,6400.7417.82,548.002,965.800.819936173,3950.7390.392,376.502,766.890.817794684,0750.55442.172,241.252,683.420.66Totals27,960$3,566.18$ 16,47.24$20,041.42$0.72Highest4,075$0.70$472.47$2,548.00$2,965.80$0.83Lowest2,007$0.48$242.80$983.43$1,226.23$0.61Average3,107$0.58$396.24$1,830.58$2,226.82$0.72

Jeff QuasneyApply 2-1 Village of Scott Police Department

Sheet2

Sheet3