1:2 Problem Set x xCompageNoww X [) Excel Online Six X 45 MindTap - Cang x + O about blank Excel template - Saved y Search (Alt . Q) Home Insert Draw Page Layout Formulas Data Review View Help Editing y 17 10 B General . . . Financial statements of a manufacturing firm The following events look place for Sorensen Manufacturing Company during January. the first month of its operations as a producer of digital video monitors DATA Materials purchased 1267,000 Direct materials used in production 192, 240 Direct labor wages 180,COO Factory overhead 102,200 10 Work in process transferred to finished goods 811, 700 Sales revenue 201,600 12 Cost of goods sold 720,900 13 Seling experian 229 600 Administrative expense 133, 570 15 Select the corresponding accounts in the dropdowns in cells B21:825, 825:626, 828, 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 16 results for the green entry cells (D21:D23, C25:025, D27.D28, C31:033) into the appropriate fields in CNOWv2 for grading. 17 Sorensen Manufacturing Company 19 Income Statement 20 For the Month Ended January 31 Formulas 22 23 24 Operaling experiogs: 25 26 Total operating expenses Inventory belances on January 31: b. Materials Work In process Finished goods