Asset turnover Financial statement data for the years ending December 31, 20Y3 and 20Y2, for Lawson Company follow: 20Y3 20Y2 Sales $885,500 $682,000 Total assets: Beginning of year 350,000 270,000 End of year 420,000 350,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the asset turnover for 20Y3 and 2072. Round your answers to one decimal place. 20Y3 20Y2 Asset turnover b. Is the change in the asset turnover from 20Y2 to 20Y3 favorable or unfavorable? Favorable Unfavorable A B D E Asset turnover Financial statement data for the years ending December 31, 20Y3 and 20Y2, for Lawson Company follow: 20Y3 $885,500 20Y2 $682,000 Sales Total assets: Beginning of year End of year 350,000 420,000 270,000 350,000 Using formulas and cell references, perform the required analysis, and input your answers into the 20Y3 and 20Y2 columns. Transfer the numeric results for the green entry cells (B14:C14) into the appropriate fields in CNOWv2 for grading. Formulas 20Y3 20Y2 20Y3 20Y2 Asset turnover