Searcy Digit X D21 1-2 P X Ceng X Excel X D2L Explo X H Hand X Mind X AICP, X My H X * Probl X My H X + X G n about:blank . .. Excel template - Saved v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing v Comments Arial 10 B vavAv ... Ev General 00 .00 .. . B18 X V fx Sorensen Manufacturing Company B G H M N O Q R S T U Financial statements of a manufacturing firm A The following events took place for Sorensen Manufacturing Company during January. the first month of its operations as a 3 producer of digital video monitors: DATA 6 Materials purchased $234,000 Direct materials used in production 168,480 8 Direct labor wages 421,200 9 Factory overhead 168,500 10 Work in process transferred to finished goods 711,400 11 ales revenue 1.123,200 12 Cast of goods sold 631,800 13 ling expense 201,200 14 dministration expense 117,000 15 Select the corresponding accounts in the dropdowns in cells B21:823, 825:828, 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 results for the green entry cells (D21:D23, C25:026, D27:028, 031:033) into the appropriate fields in CNOVW2 for grading. 17 18 19 Income Statement 20 For the Month Ended January 31 Formulas 21 23 Operating expenses: 25 26 27 Total operating expenses 28 29 30 Inventory balances on January 31: 31 Material: 32 Work in process 33 Finished goods 34 35 36 > E Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft - 60% + 89 F Mostly sunny Q Search W 12:20 PM FO 6/27/2023