please show work if you can!!

5C Ch 9 Problem 31 Depreciation (Proted File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do O PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable ! F20 1 Lone Star Industries purchased the following items of equipment, with the 2 following purchase information Machine B is an ore crushing machine, 3 it is able to crush 100,000 tons of ore before it needs to be replaced. 4 Production in Year 1 was 5,000 tons, and was 25,000 tons in Year 2 Machine Machine Machine C 8 Date Acquired 1/1/15 10/1/15 6/1/15 10 Cost of the Asset 11 Delivery Freight 12 Installation Cost 10,000 400 653 382,000 20,000 19,053 23,400 260 1,600 13 5 years 6 years 14 Useful Life 15 Residual Value = 5% of Cost 16 17 Method of Depreciation Straight Line Units of Production Double Declining Balance 20 Calculate the Depreciable cost 21 22 Calculate the Depreciation for 23 the first year of operation 24 Calculate the Depreciation for 25 the second year of operation 26 27 use the space below for your calculations, round amounts to the nearest whole dollar 30 Sheet1 Type here to search O @