Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hom x 0 Mail X D2L Hom X Ceng X Excel X C The f x Cour X Hom X D2L 1-1 [ X M
Hom x 0 Mail X D2L Hom X Ceng X Excel X C The f x Cour X Hom X D2L 1-1 [ X M Sout X 3 HIS 2 X HIS 2 X + V X @ about:blank ... New Tab Bank Careers and J... Post Attendee - Zo. mySNHU Login Vue whi APA Style: Home -. P In-Text Citations: A... [Solved] Perpetual I.. Introduction to Stat. Mail - Lucas, Cynthi... Excel template - Saved v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments Arial 10 B Av ... Ev ab General 00 .00 ... H51 * X V fx A B C D E F G H 15 Machinery depreciation 207,600 16 Heat, light, and power 173,000 17 Supplies 34,500 18 Property taxes 29.650 19 Miscellaneous costs 45, 180 20 Select the corresponding accounts in the dropdowns in cells B26, B28:B33, B35:B40, B44. Using formulas and cell references, perform the required analysis, and input your answers into the green cells in the C, D, and E columns. Transfer the numeric results for the green entry cells (E26, C28:031, D32:D33, C35:C40, D41, E42:E45, C47) into the appropriate fields 21 in CNOWv2 for grading. 22 23 Johnstone Manufacturing Company 24 Statement of Cost of Goods Manufactured 25 For the Month Ended March 31 Formulas 26 la 27 Direct materials: 28 29 30 31 32 33 = & Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft 100% + Type here to search 799 70OF A DI ENG 8:48 PM 10/25/2022 20Hom x 0 Mail X D2L Hom X Ceng X Excel X C The f x Cour X Hom X D2L 1-1 [ X M Sout X 3 HIS 2 X HIS 2 X + V X ... @ about:blank New Tab Bank Careers and J... Post Attendee - Zo. mySNHU Login Vue whi APA Style: Home -. P In-Text Citations: A... [Solved] Perpetual I.. Introduction to Stat. Mail - Lucas, Cynthi... Excel template - Saved v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing v Comments Arial 10 v B Av ... Ev ab General 00 .00 ... H51 fx A B C D E F G H 29 30 31 32 33 34 Factory overhead: 35 36 37 38 39 40 41 Total factory overhead 42 Total manufacturing costs incurred during March 43 Total manufacturing costs 44 45 Cost of goods manufactured 46 47 b. Cost of goods sold for March 48 49 > Data + Calculation Mode: Automatic Workbook Statistics v Give Feedback to Microsoft 100% + 199- 70OF A DI ENG 8:48 PM Type here to search 10/25/2022 20Hom x 0 Mail X D2L Hom X Ceng X Excel X C The f x Cour X Hom X D2L 1-1 [ X M Sout X 3 HIS 2 X HIS 2 X + V X @ about:blank ... New Tab Bank Careers and J... Post Attendee - Zo. mySNHU Login Vue whi APA Style: Home -. P In-Text Citations: A... [Solved] Perpetual I.. Introduction to Stat. Mail - Lucas, Cynthi... Excel template - Saved v Search (Alt + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Editing Comments Arial 10 v B Av ... Ev ab General 00 .00 ... H51 * X V fx A B C D E F G H Statement of cost of goods manufactured for a manufacturing company Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows: DATA Inventories March 1 March 31 Materials $207,600 $190,890 Work in process 430,920 504,560 Finished goods 579,510 608,850 10 11 Direct labor $3,460,000 12 Materials purchased during March 2,635,720 13 Factory overhead incurred during March: 14 Indirect labor 316,340 15 Machinery depreciation 207,600 16 Heat, light, and power 173,000 17 Supplies 34,500 18 Property taxes 29.650 19 Miscellaneous costs 45, 180 20 Select the corresponding accounts in the dropdowns in cells B26, B28:B33, B35:B40, B44. Using formulas and cell references, perform the required analysis, and input your answers into the aroon calle in the ( D and E calumne Tranefor the numeric results for the aroon entry calle (626 078-121 29-132 025.An DA1 =12.FAR C17\\into the annronristo fields E Data + Calculation Mode: Automatic Workbook Statistics Give Feedback to Microsoft 100% + Type here to search O a A DI ENG 8:47 PM 199 70OF 10/25/2022 19
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started