Depreciation Schedule (Units-of-Production) Data: Asset # Asset name: Date acquired: Cost: Depreciation method: Salvage (residual) value: Estimated useful life (miles): 222 Truck 1/1/14 $25,000 Units-of-Production $5,000 100,000 Output: (1) Set up an Excel worksheet and include the data above in the Excel worksheet. (2) Set up a Depreciation Schedule as shown below: Year 2014 2015 2016 2017 2018 Depreciation Schedule - Units-of-Production Method Miles Depreciation Accumulated Book Value Driven Expense Depreciation 12,000 17,000 26,000 18,000 27,000