$!$

Required information

$[$The following information applies to the questions displayed below.$]$

University Car Wash purchased new soap dispensing equipment that cost $$231,000$ including installation. The company estimates that the equipment will have a residual value of $$25,500.$ University Car Wash also estimates it will use the machine for six years or about $12,500$ total hours. Actual use per year was as follows:

$\backslash$table$[[$Year$,$Hours Used$],[1,2,900],[2,1,800],[3,1,900],[4,2,100],[5,1,900],[6,1,900]]$

Prepare a depreciation schedule for six years using the activity$-$based method. $($Round your "Depreciation Rate" to $2$ decimal places and use this amount in all subsequent calculations.$)$

$\backslash$table$[[$UNIVERSITY CAR WASH$],[\backslash$table$[[$Depreciation Schedule$-$Activity$-$Based$],[$End of Year Amounts$]],,],[$Year$,\backslash$table$[[$Depreciation$],[$Expense$]],\backslash$table$[[$Accumulated$],[$Depreciation$]],$Book Value,$],[1,,,,],[2,,,,],[3,,,,],[4,,,,],[5,,,,]$