Use EXCEL formular to answer the question since its suppose to be done in excel spreedsheet. Question $9$: A semi$-$truck with an estimated $250,000-$mile life and a $$34,000$ salvage value, was purchased on January $1,20$X$1,$ for $$376,000.$ If the semi$-$truck was run for $62,000$ miles in $20$X$1,77,000$ miles in $202,56,000$ miles in $203,$ and $71,000$ miles in $204,$ how much would the "depreciation expense be in $203"$ using an activity$-$based method? Use a manual formula.

Question $10$: Assume the same details as Question $9,$ except that you want to find how much would the semi$-$truck's "depreciation expense be in $20$X$4."$ Use a manual formula. Hint: Read Question $9$ again carefully to get to correct formula inputs.