Determining amounts for items omitted from income statement One item is omitted in each of the following four lists of income statement data. 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 Determine the amounts of the missing items. Round your answers to the nearest dollar. Sales (b) $1,275,000 (d) $465,800 (a) Cost of merchandise sold $437,600 (c) $962,700 Gross profit 84,380 275,300 243,000 653,600 Determine the missing amount. a. b. $ C. $ d. $ Determining amounts for items omitted from income statement ? One item is omitted in each of the following four lists of the income statement data. 3. 7. Sales $465,800 (b) $1,275,000 5 Cost of goods sold (a) $437,600 (c) 5 Gross profit $84,380 $275,300 $243,000 7 (d) $962,700 $653,600 Using formulas and cell references, perform the required analysis, and input your answers into the Amounts column. Transfer the numeric results for the green entry cells (B11:B14) into the appropriate fields in CNOWv2 for grading. 3 Amounts Formulas 0 1 2 a. b. 3 4 5 6