Clint's Beverage Co produces bottled water and has provided the following information for the month of April: Units Sold during April: 82,200 Finished Goods Inventory, April 1: $ 75,000.00 Salary of CFO: $ 175,000.00 Finished Goods Inventory, April 30: $ 70,000.00 Commissions: $ 200,000.00 Advertising: $ 750,000.00 Research and development: $ 120,000.00 Cost of Goods Manufactured: $ 1,640,000.00 Depreciation on corporate office: $ 60,000.00 Unit price per sold item $45 1. Prepare a Statement of Cost of Goods Sold for the month of April. (8 pts. You must use cell references when post and a formula/calculation in the cell for any totals. Graded on formatting, correct entries, formulas/cell reference Heading Heading Heading 2. Prepare an income statement for the month of April. (13 points. You must use cell references when possible an formula/calculation in the cell for any totals. Graded on formatting, correct entries, formulas/cell references) Heading Heading Heading