could you please post on a spreadsheet

Saved CA A machine costing S211.200 with a four-year life and an estimated $20,000 salvage value is installed in Luther Company's factory on January 1. The factory manager estimates the machine will produce 478,000 units of product during its life. It actually produces the following urvits 122,400 in Year 1.124 200 in Year 2, 120.600 in Year 3, 119.800 in Year 4 The total number of units produced by the end of Year 4 exceeds the original estimate-this difference was not predicted (The machine cannot be depreciated below its estimated salvage value) Required: Compute depreciation for each year (and total depreciation of all years combined) for the machine under each depreciation method (Round your per unit depreciation to 2 decimal places, Round your answers to the nearest whole dollar) Complete this question by entering your answers in the tabs below. Straight une Units of Production DDB Compute depreciation for each year and total depreciation of all years combined) for the machine under the Straight Wine depreciation Stabile Depreciation Depreciation Expense CR 4 proti NOML> Dortovec 6C6 Straight line Units of Production DDB Compute depreciation for each year and total depreciation of all years combined) for the machine under the u production Year 1 Units of Production Units Depreciable Depreciation Depreciation Units per unit Expense 123,400 124 200 120.600 2 3