La pluja Excel Home Insert Draw Page Layout Formulas Data Review View Help ] X Cut In Copy - Format Painter Clipboard Calibri 11 AA - 2 Wrap Text General BIUDO - A Merge & Center $ - % & Conditional Formats Cell Formatting Table - Eyes Alignment Thes fi 1. Using the table I started for you below, compute the depreciation expense, accumulated depreciation and book value for all H K Font X B D Watkins Production purchased a new computerized machine at a cost of $450,000. The machine has a residual value of $64,000 and an expected life of 5 years. The actual machine hours were a total of 154,400 over the 5 years. Each year the hours were: 55,000 in year 1, 50,000 in year 2,30,000 in year 3, 13,000 in year 4, and 6,900 in year 5. 1. Compute the depreciation cost per machine hour (need to use a formula in the cell for the calculation), 2 points 1. Using the table I started for you below, compute the depreciation expense, accumulated depreciation and book value for all 5 years of the machine's expected life using the units of production method of depreciation (need to use a formula in the cells to show the calculations behind the values) (16 points) End of Year Depreciation Expense Accumulated Depreciation Book Value 0 $ 450,000 1 2 3 4 5