Clint's Beverage Co produces bottled water and has provided the following information for the month of April: Units Sold during April: Finished Goods Inventory, April 1: $ 82,200 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: Depreciation on corporate office: $ 1,640,000.00 $ 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 possible and a formula/calculation in the cell for any totals. Graded on formatting, correct entries, formulas/cell references) Heading Heading Heading 2. Prepare an income statement for the month of April. (13 points. You must use cell references when possible and a formula/calculation in the cell for any totals. Graded on formatting, correct entries, formulas/cell references) Heading Heading Heading