Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

table {mso-displayed-decimal-separator:.; mso-displayed-thousand-separator:,;} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;}

table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl21 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none;} .xl22 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none;} .xl24 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none;} .xl25 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:center; background:white; mso-pattern:black none;} .xl26 {color:black; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; vertical-align:middle; background:white; mso-pattern:black none;} .xl27 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl28 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none;} .xl31 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:#F4B084; mso-pattern:black none;} .xl32 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl33 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:center; background:white; mso-pattern:black none;} .xl34 {font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl35 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; background:white; mso-pattern:black none; padding-left:18px; mso-char-indent-count:2;} .xl36 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#F4B084; mso-pattern:black none;} .xl37 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl40 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; background:white; mso-pattern:black none;} .xl41 {font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:center; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl42 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal; padding-right:18px; mso-char-indent-count:2;} .xl44 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; padding-left:9px; mso-char-indent-count:1;} .xl45 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal; padding-left:9px; mso-char-indent-count:1;} .xl46 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal; padding-left:18px; mso-char-indent-count:2;} .xl60 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; background:white; mso-pattern:black none;} .xl61 {color:black; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:204; background:white; mso-pattern:black none;} .xl64 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none; background:#F4B084; mso-pattern:black none;} .xl65 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right;} .xl66 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none;} .xl67 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; vertical-align:middle; background:white; mso-pattern:black none;} .xl68 {font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; border-top:.5pt solid windowtext; border-right:none; border-bottom:none; border-left:none; background:#A9D08E; mso-pattern:black none;} .xl69 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; background:#A9D08E; mso-pattern:black none; padding-left:9px; mso-char-indent-count:1;} .xl70 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; background:#A9D08E; mso-pattern:black none; padding-left:18px; mso-char-indent-count:2;} .xl71 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; background:#A9D08E; mso-pattern:black none;} .xl72 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; background:#A9D08E; mso-pattern:black none;} .xl73 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:#A9D08E; mso-pattern:black none;} .xl75 {color:windowtext; font-size:10.0pt; font-family:Arial, sans-serif; mso-font-charset:0; text-align:right; border-top:.5pt solid windowtext; border-right:none; border-bottom:1.0pt solid windowtext; border-left:none; background:#A9D08E; mso-pattern:black none;} .xl76 {font-family:Arial, sans-serif; mso-font-charset:0; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl77 {font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:center; vertical-align:middle; background:white; mso-pattern:black none;} .xl86 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:center; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none; white-space:normal;} .xl87 {color:windowtext; font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:center; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none;} .xl90 {font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:left; vertical-align:middle; background:white; mso-pattern:black none; white-space:normal;} .xl92 {font-size:10.0pt; font-weight:700; font-family:Arial, sans-serif; mso-font-charset:204; text-align:center; vertical-align:middle; border-top:none; border-right:none; border-bottom:.5pt solid windowtext; border-left:none; background:white; mso-pattern:black none; white-space:normal;}

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
Direct labor $3,460,000
Materials purchased during March 2,635,720
Factory overhead incurred during March:
Indirect labor 316,340
Machinery depreciation 207,600
Heat, light, and power 173,000
Supplies 34,500
Property taxes 29,650
Miscellaneous costs 45,180
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:C31, D32:D33, C35:C40, D41, E42:E45, C47) into the appropriate fields in CNOWv2 for grading.
Johnstone Manufacturing Company
Statement of Cost of Goods Manufactured
For the Month Ended March 31 Formulas
a.
Direct materials:
Factory overhead:
Total factory overhead
Total manufacturing costs incurred during March
Total manufacturing costs
Cost of goods manufactured
b. Cost of goods sold for March

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles

Authors: John J Wild, Ken Shaw

24th edition

1259916960, 978-1259916960

More Books

Students also viewed these Accounting questions

Question

1. Too understand personal motivation.

Answered: 1 week ago