please answer in the excel sheet format provided in the first picture and include formulas to help learn how to do!

RETURN ON ASSETS SPREADSHEET SCMN 3710 - LOGISTICS (All dollar figures are in millions) BASE CASE 10% Inventory 20% Inventory Sales (\$) cogs($) Gross Profit (\$) \begin{tabular}{|ll|} \hline$ & 96,250 \\ \hline$ & 64,194 \\ \hline \end{tabular} Variable OH Expenses (\$) Fixed OH Expenses (\$) Total Overhead (\$) Inventory (\$) Net A/R (\$) Cash on Hand (\$) Other Current Assets (\$) Total Current Assets (\$) \begin{tabular}{|lc|} \hline$ & 17,605 \\ \hline$ & \\ \hline$ & 1,133 \\ \hline$ & 1,322 \\ \hline & \\ \hline \end{tabular} \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \end{tabular} Total Current Assets (\$) Fixed Assets (\$) Total Assets (\$) Gross Profit (\$) Total OH Cost (\$) Interest (\$) Taxes (\$) Net Income (\$) \begin{tabular}{|lr|} \hline \\ \hline & \\ \hline$ & 885 \\ \hline$ & 2,766 \\ \hline \end{tabular} Net Income (\$) Total Sales (\$) Profit Margin (\%) Total Sales (\$) Total Assets (\$) Asset Turnover (\%) Net Income (\$) Total Assets (\$) Return on Assets (\%) Inventory Turns Sales=$96,250TotalOverheadExpenses=$19,963InventoryonHand=$17,605Cash-on-Hand=$1,133FixedAssets=$24,580Interest=$885CostofGoodsSold=$64,194(40%Variable,60%Fixed)NetAccountsReceivable=$0OtherCurrentAssets=$1,322InventoryCarryingCosts=20%/yearTaxes=$2,766 Note: Data from Lowe's Annual Report dated 1/28/2022. All dollar figures are in millions. 1. Populate the spreadsheet template, calculating Net Income \$, Profit Margin %, Asset Turnover \%, Return on Assets \%, and Inventory Turns. Assume the average inventory for the year is equal to the inventory on-hand. 2. Recalculate metrics based on a 10% reduction in inventory. Assume that all inventory carrying cost reductions come out of variable OH expenses. Assume Interest \& Taxes do not change. 3. Recalculate metrics based on a 20% reduction in inventory. Assume that all inventory carrying cost reductions come out of variable OH expenses. Assume Interest \& Taxes do not change. BUSINESS FINANCIAL MODEL RETURN ON ASSETS SPREADSHEET SCMN 3710 - LOGISTICS (All dollar figures are in millions) BASE CASE 10% Inventory 20% Inventory Sales (\$) cogs($) Gross Profit (\$) \begin{tabular}{|ll|} \hline$ & 96,250 \\ \hline$ & 64,194 \\ \hline \end{tabular} Variable OH Expenses (\$) Fixed OH Expenses (\$) Total Overhead (\$) Inventory (\$) Net A/R (\$) Cash on Hand (\$) Other Current Assets (\$) Total Current Assets (\$) \begin{tabular}{|lc|} \hline$ & 17,605 \\ \hline$ & \\ \hline$ & 1,133 \\ \hline$ & 1,322 \\ \hline & \\ \hline \end{tabular} \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \\ \hline \end{tabular} \begin{tabular}{|} \hline \\ \hline \\ \hline \\ \hline \end{tabular} Total Current Assets (\$) Fixed Assets (\$) Total Assets (\$) Gross Profit (\$) Total OH Cost (\$) Interest (\$) Taxes (\$) Net Income (\$) \begin{tabular}{|lr|} \hline \\ \hline & \\ \hline$ & 885 \\ \hline$ & 2,766 \\ \hline \end{tabular} Net Income (\$) Total Sales (\$) Profit Margin (\%) Total Sales (\$) Total Assets (\$) Asset Turnover (\%) Net Income (\$) Total Assets (\$) Return on Assets (\%) Inventory Turns Sales=$96,250TotalOverheadExpenses=$19,963InventoryonHand=$17,605Cash-on-Hand=$1,133FixedAssets=$24,580Interest=$885CostofGoodsSold=$64,194(40%Variable,60%Fixed)NetAccountsReceivable=$0OtherCurrentAssets=$1,322InventoryCarryingCosts=20%/yearTaxes=$2,766 Note: Data from Lowe's Annual Report dated 1/28/2022. All dollar figures are in millions. 1. Populate the spreadsheet template, calculating Net Income \$, Profit Margin %, Asset Turnover \%, Return on Assets \%, and Inventory Turns. Assume the average inventory for the year is equal to the inventory on-hand. 2. Recalculate metrics based on a 10% reduction in inventory. Assume that all inventory carrying cost reductions come out of variable OH expenses. Assume Interest \& Taxes do not change. 3. Recalculate metrics based on a 20% reduction in inventory. Assume that all inventory carrying cost reductions come out of variable OH expenses. Assume Interest \& Taxes do not change. BUSINESS FINANCIAL MODEL