Financial statements of a manufacturing firm The following events took place for Sorensen Manufacturing Company during January, the first month of its operations as a producer of digital video monitors: a. Purchased $233,000 of materials. b. Used $167,760 of direct materials in production. c. Incurred $419,400 of direct labor wages. d. Incurred $167,800 of factory overhead. e. Transferred $708,300 of work in process to finished goods. f. Sold goods for $1,118,400. g. Sold goods with a cost of $629,100. h. Incurred $200,400 of selling expense. i. Incurred $116,500 of administrative expense. 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. Financial statements of a manufacturing firm The following events took place for Sorensen Manufacturing Company during January, the first month of its operations as a producer of digital video monitors: Select the corresponding accounts in the dropdowns in cells B21:B23, B25:B26, B28. Using formulas and cell references, berform the required analysis, and input your answers into the green cells in the C and D columns. Transfer the numeric esults for the green entry cells (D21:D23, C25. C26, D27:D28, C31:C33) into the appropriate fields in CNOWV2 for grading. Select the corresponding accounts in the dropdowns in cells B21B23,B25.B26,B28. Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the C and D columns. Transfer the numeric results for the green entry cells (D21:D23, C25.C26, D27:D28, C31.C33) into the appropriate fields in CNOWv2 for grading