The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

Complete the balance sheet and sales information in the table that follows for $1.$ White Industries. Do not round intermediate calculations. Round your answers to the nearest whole dollar.

$\backslash$table$[[$Partial Income,$\backslash$table$[[$Statement$],[$Information$]],],[$Sales$,$$$,],[$Cost of goods sold,$$,]]$

Balance Sheet

$\backslash$table$[[$Cash$,$$$,$Accounts payable,$

$1$ Balance Sheet Analysis

$2$

$\backslash$table$[[3,$Total assets turnover,$2\mathrm{.}00],[4,$Gross profit margin on sales,$30\mathrm{.}00\%$