PLEASE ANSWER THE WAY THE EXCEL SHEET IS SET UP. NOT THE QUESTIONS

Chapter 10 Serial Problem Part 1 Annual Depreciation Expense-Office Equipment Annual Depreciation Expense - Computer Equipment \begin{tabular}{|r|} \hline$1,600 \\ \hline$5,000 \\ \hline \end{tabular} Part 2 Office Equipment Accumulated Depreciation Office Equipment (book Value) \begin{tabular}{|r|r|} \hline 12/31/22 & 12/31/21 \\ \hline$6,000 & \\ \hline$6,250 & \\ \hline$13,750 & \\ \hline \end{tabular} Computer Equipment Accumulated Depreciation Computer Equipment (book Value) \begin{tabular}{|r|r|} \hline 12/31/22 & 12/31/21 \\ \hline$6,250 & \\ \hline$2,000 & \\ \hline$13,750 & \\ \hline \end{tabular} Part 3 Total Asset Turnover = Net Sales / Average Total Assets Net Sales Total Assets 12/31/2021 Total Assets 03/31/2022 Average Total Assets Total Asset Turnover \begin{tabular}{|l|l} \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline & \\ \hline \end{tabular} Estimated annual Total Asset Turnover Industry Standard Total Asset Turnover \begin{tabular}{|l|l} \hline 0.00 & times \\ \hline 2.50 & times \\ \hline \end{tabular} How does Business Solutions compare to the industry? 1. Assume that Business Solutions does not acquire additional office equipment or computer equipment in 2022. Compute amounts for the year ended December 31, 2022, for Depreciation Expense-Office Equipment and for Depreciation Expense-Computer Equipment (assume use of the straight-line method). 2. Given the assumptions in part 1, what is the book value of both the office equipment and the computer equipment as of December 31 , 2022? 3. Compute the three-month total asset turnover for Business Solutions as of March 31, 2022. Use total revenue for the numerator and average the December 31, 2021, total assets and the March 31, 2022, total assets for the denominator. Interpret its total asset turnover if competitors average 2.5 for annual periods. (Round turnover to two decimals.)