Integrated Excel Problem $17-2($Static$)$ Based on Word problem $17-20$

Jim Company bought a machine for $$36,000$ with an estimated life of $5$ years. The residual value of the machine is $$6,000.$ Calculate the first $2$ years$$ depreciation, assuming the units$-$of$-$production method. This machine is expected to produce $120,000$ units. In year $1,$ it produced $19,000$ units, and in year $2,38,000$ units.

Cost of machine$ $36,000$Estimated life of machine$5$Residual value of machine$ $6,000$Expected machine production $($units$)120,000$Year $1$ production $($units$)19,000$Year $2$ production $($units$)38,000$