Question
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
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