You work as a finance officer for a retailer You are responsible for ensuring that financial data is accurate and without errors Your task is to analyse the income statement information for the operations of the year from January to December Month Units Sold Price Income COGS ($45 per unit sold) Expenses ($4 per Profit unit sold) January February 164 $ 99,00 $ 16,236,00 $ 7,380,00 $ 656,00 $ 8,200,00 166 $99,00 $ 16,434,00 $ 7,470,00 $ 664,00 $ 8,300,00 March 158 $ 99,00 $ 15,642,00 $ 7,110,00 $ 632,00 $ 7,900,00 April 163 $ 99,00 $ 16,137,00 $ 7,335,00 $ 652,00 $ 9,454,00 May 163 $ 99,00 $ 16,137,00 $ 7,335,00 $ 652,00 $ 9,454,00 June 157 July 163 $ 99,00 $ 15,543,00 $ 7,065,00 $ 628,00 $ 9,106,00 $99,00 $ 16,137,00 $ 7,335,00 $ 652,00 $ 9,454,00 You work as a finance officer for a retailer You are responsible for ensuring that financial data is accurate and without errors Your task is to analyse the income statement information for the operations of the year from January to December This is the income report Month Units Sold Price Income COGS ($45 per unit sold) Expenses ($4 per Profit unit sold) August 157 $ 99,00 $ 15,543,00 $ 7,065,00 $ 628,00 $ 9,106,00 September 152 $ 99,00 October 158 $ 99,00 $ 15,048,00 $ 6,840,00 $ 608,00 $ $ 15,642,00 7,600,00 $ 7,110,00 $ 632,00 $ 7,900,00 November 156 $ 99,00 $ 15,444,00 $ 7,020,00 $ 624,00 $ 7,800,00 December 156 $ 99,00 $ 15,444,00 7,800,00 Total 1913 $ 189,387,00 $ 7,020,00 $ 624,00 $ $ 86,085,00 $7,652,00 $ 102,074.00 You know for a fact that the correct profit value for the year should be $ 95,650 and not $102,074 as in the report above Clearly, an error has been made and you have to fix it) Required: 1 Take the following information into a spreadsheet software (Excel, numbers or GoogleSheets) and recalculate income, COGS, Expenses and Profit) Make sure you follow the instructions) (COGS is $45 per unit sold, and Expenses are $4 per unit sold)