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 $232,000 of materials. b. Used $167,040 of direct materials in production. c. Incurred $417,600 of direct labor wages. d. Incurred $167,000 of factory overhead. e. Transferred $705,300 of work in process to finished goods. f. Sold goods for $1,113,600. g. Sold goods with a cost of $626,400. h. Incurred $199,500 of selling expense. i. Incurred $116,000 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. X Open spreadsheet Using the information given, complete the following: a. Prepare the January income statement for Sorensen Manufacturing Company. Round your answers to the nearest dollar. DATA Materials purchased Direct materials used in production Direct labor wages Factory overhead Work in process transferred to finished goods Sales revenue Cost of goods sold Selling expense Administrative expense $232,000 167,040 417,600 167,000 705,300 1,113,600 626,400 199,500 116,000 Select the corresponding accounts in the dropdowns in cells B21:B23, 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:023, C25:C26, D27:D28, C31:C33) into the appropriate fields in CNOWV2 for grading. Sorensen Manufacturing Company Income Statement For the Month Ended January 31 Formulas a. Operating expenses: Total operating expenses Inventory balances on January 31: b. Materials Work in process Finished goods a. Prepare the January income statement for Sorensen Manufacturing Company. Round your answers to the nearest dollar. Sorensen Manufacturing Company Income Statement For the Month Ended January 31 Operating expenses: Total operating expenses b. Determine the inventory balances at the end of the first month of operations. Round your answers to the nearest dollar. Sorensen Manufacturing Company Inventory Balances For the Month Ended January 31 Inventory balances on January 31: Materials Work in process Finished goods