Problem Set: Module 1 eBook Show Me How Office 365 1. EX.01.09.EXCEL.ALGO Financial statements of a manufacturing firm 2. EX.01.15.EXCEL.ALGO 3. PR.01.02A 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 $249,000 of materials. b. Used $179,280 of direct materials in production. c. Incurred $448,200 of direct labor wages. d. Incurred $179,300 of factory overhead. e. Transferred $757,000 of work in process to finished goods. f. Sold goods for $1,195,200. g. Sold goods with a cost of $672,300. h. Incurred $214,100 of selling expense. i. Incurred $124,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. 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. Sorensen Manufacturing Company Income Statement For the Month Ended January 31 Revenues X Cost of goods sold 672,300 Gross profit Operating expenses: Selling expenses 214,100 Administrative expenses 124,500 Total operating expenses Net income $ Check My Work Next Progress: 1/3 items 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 Feedback Check My Work a. Use "f, g, h, and i" in preparing the income statement. b. Show the transactions in T accounts for materials, work in process, and finished goods