PutoSave 01 R ExcelTemplateAssignment_Cho2 (1) Protected View Excel Search bile Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing L M 4 - XB A B C D E F G H K P2.5A Analyze manufacturing accounts and determine missing amounts - Phillips Corporation's fiscal year ends on November 30. The following accounts are found in its job order cost accounting system for the first month of the new fiscal year. $16,850 Dec. 1 Beginning balance 31 Purchases Dec.31 Ending balance Raw Materials Inventory (a) Dec. 31 Requisitions 17.225 7,975 Dec. 1 Beginning balance 31 Direct materials 31 Direct labore 31 Overhead Dec. 31 Ending balance Work in Process Inventory (b) Dec. 31 Jobs completed (C) 8,400 (d) Dec.37 Orellas Finished Goods Inventory (9) Dec. 31 Cost of goods sold Dec. 1 Beginning balance Dec. 31 Jobs completed Dec. 31 Ending balance 0 (m) Factory Labor Dec. 31 Factory wages 12,025 Dec. 31 Wages assigned Manufacturing Overhead Deo. 31 Indirect materials 2,900 Dec. 31 Overhead applied 31 Indirect labor 31 Other overhead 1,245 30 Other data: 311. On December 1, two jobs were in process: Job No. 154 and Job No.156. These Jobs had combined direct 1 | 52-1 E2-5 E2-9 P2-3A P2-SACD2 O Type here to search 0 HA A B C J K L M 30 Other data: 31 1. On December 1, two jobs were in process: Job No. 154 and Job No. 155. These jobs had combined direct 32 materials costs of $9,750 and direct labor costs of $15,000. Overhead was applied at a rate that was 75% 33 of direct labor cost. 34 2. During December, Job Nos. 156, 157 and 158 were started. On December 31, Job No. 158 was unfinished. 35 This job had charges for direct materials $3,800 and direct labor $4,800 plus manufacturing overhead. All jobs, except for Job No. 158, were completed in December 373 On December 1, Job No. 153 was in the finished goods warehouse. It had a total cost of $5.000. On 38 December 31, Job No. 157 was the only job finished that was not sold. It had a cost of $4,000. 39 4. Manufacturing overhead was $1,470 underapplied in December 36 40 41 Instructions 42 List the items (a) through (m) and indicate the amount pertaining to each letter 43 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 46 (a) Beginning balance, raw materials Total requisitions Ending balance, raw materials Less purchases Beginning balance, raw materia's Value Value Value 49 53(b) Beginning work in process (Job 154 & Job 155) Direct materials Value 55 Direct labor Value 56 Overhead applied 57 58 sale Direstmates 2:9 P23A P2-SACD2 AutoSave OD R O 0 ExcelTemplateAssignment Cho2 (1) Protected View - Excel Search File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. X vf 4. E F G H I J K 59 (c) Direct materials Requisitions of raw materials Value Less: indirect materials Value Direct materials ED (d) Overhead applied Direct labor Overhead applied (75% of DL) Value Ending work in process (Job No. 158) Direct materials Value Direct labor Value Overhead applied Completed Jobs Jobs 154-157) Beginning balance, work in process Direct materials Direct labor Overhead applied Value Value Value Value File Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. 114 for A B C D E F G H 87 (9) Beginning balance, finished goods (Job 153) Value 90 (h) Jobs completed Value 92 930) Cost of goods sold Beginning finished goods Jobs completed Less: ending finished goods Cost of goods sold Value Value Value 1000) Ending finished goods (Job 157) Value Value 102 103(k) Wages assigned to work in process 104 105 (1) Indirect labor 106 Factory wages Value Less: direct labor Value Indirect labor Value 107 108 111 (m) Overhead applied 112 Direct labor Overhead applied 114 113 Value ? TE2- 1 E2-5 E2-9 | P2-3A P2-5A CD2 O Type here to search AutoSave ExcelTemplate Assignment_CHO2 (1) . Protected View Excel Search File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks V PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View J14 AB Direct labor Overhead applied Less: ending work in process Jobs completed Value Value Value 87 (9) Beginning balance, finished goods (Job 153) Value 90 (h) Jobs completed Value 930) 94 Cost of goods sold Beginning finished goods Jobs completed Less: ending finished goods Cost of goods sold Value Value Value 96 1000) Ending finished goods (Job 157) Value 102 103(k) Wages assigned to work in process | Value 104 1050 Indirect labor 106 Factory wages Value Less: direct labor Value 100 Indirect labor Value 109 110 TE2152: 5 2 -9 P23A P2-SACD2 107 * Type here to search e eler AutoSave Of B ExcelTemplateAssignment cho2 (1) - Protected View - Excel File Home Insert Page Layout Formulas Data Review View Help DYMO Label PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay 1000) Ending finished goods (Job 157) Value 102 Value 103(k) Wages assigned to work in process 104 105 () Indirect labor Factory wages Value 107 Less: direct labor Value Indirect labor Value 109 110 111(m) Overhead applied 112 Direct labor Value 113 Overhead applied ? 114 115 116 117 110 When you have completed P2-5A, consider the following additional question. 1191. Assume that requisitions changed to $17,600. Show the impact of this change on the items listed. EN968 E21|1295629 P23A P2-SACD2 Type here to search PutoSave 01 R ExcelTemplateAssignment_Cho2 (1) Protected View Excel Search bile Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View Enable Editing L M 4 - XB A B C D E F G H K P2.5A Analyze manufacturing accounts and determine missing amounts - Phillips Corporation's fiscal year ends on November 30. The following accounts are found in its job order cost accounting system for the first month of the new fiscal year. $16,850 Dec. 1 Beginning balance 31 Purchases Dec.31 Ending balance Raw Materials Inventory (a) Dec. 31 Requisitions 17.225 7,975 Dec. 1 Beginning balance 31 Direct materials 31 Direct labore 31 Overhead Dec. 31 Ending balance Work in Process Inventory (b) Dec. 31 Jobs completed (C) 8,400 (d) Dec.37 Orellas Finished Goods Inventory (9) Dec. 31 Cost of goods sold Dec. 1 Beginning balance Dec. 31 Jobs completed Dec. 31 Ending balance 0 (m) Factory Labor Dec. 31 Factory wages 12,025 Dec. 31 Wages assigned Manufacturing Overhead Deo. 31 Indirect materials 2,900 Dec. 31 Overhead applied 31 Indirect labor 31 Other overhead 1,245 30 Other data: 311. On December 1, two jobs were in process: Job No. 154 and Job No.156. These Jobs had combined direct 1 | 52-1 E2-5 E2-9 P2-3A P2-SACD2 O Type here to search 0 HA A B C J K L M 30 Other data: 31 1. On December 1, two jobs were in process: Job No. 154 and Job No. 155. These jobs had combined direct 32 materials costs of $9,750 and direct labor costs of $15,000. Overhead was applied at a rate that was 75% 33 of direct labor cost. 34 2. During December, Job Nos. 156, 157 and 158 were started. On December 31, Job No. 158 was unfinished. 35 This job had charges for direct materials $3,800 and direct labor $4,800 plus manufacturing overhead. All jobs, except for Job No. 158, were completed in December 373 On December 1, Job No. 153 was in the finished goods warehouse. It had a total cost of $5.000. On 38 December 31, Job No. 157 was the only job finished that was not sold. It had a cost of $4,000. 39 4. Manufacturing overhead was $1,470 underapplied in December 36 40 41 Instructions 42 List the items (a) through (m) and indicate the amount pertaining to each letter 43 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". 46 (a) Beginning balance, raw materials Total requisitions Ending balance, raw materials Less purchases Beginning balance, raw materia's Value Value Value 49 53(b) Beginning work in process (Job 154 & Job 155) Direct materials Value 55 Direct labor Value 56 Overhead applied 57 58 sale Direstmates 2:9 P23A P2-SACD2 AutoSave OD R O 0 ExcelTemplateAssignment Cho2 (1) Protected View - Excel Search File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. X vf 4. E F G H I J K 59 (c) Direct materials Requisitions of raw materials Value Less: indirect materials Value Direct materials ED (d) Overhead applied Direct labor Overhead applied (75% of DL) Value Ending work in process (Job No. 158) Direct materials Value Direct labor Value Overhead applied Completed Jobs Jobs 154-157) Beginning balance, work in process Direct materials Direct labor Overhead applied Value Value Value Value File Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. 114 for A B C D E F G H 87 (9) Beginning balance, finished goods (Job 153) Value 90 (h) Jobs completed Value 92 930) Cost of goods sold Beginning finished goods Jobs completed Less: ending finished goods Cost of goods sold Value Value Value 1000) Ending finished goods (Job 157) Value Value 102 103(k) Wages assigned to work in process 104 105 (1) Indirect labor 106 Factory wages Value Less: direct labor Value Indirect labor Value 107 108 111 (m) Overhead applied 112 Direct labor Overhead applied 114 113 Value ? TE2- 1 E2-5 E2-9 | P2-3A P2-5A CD2 O Type here to search AutoSave ExcelTemplate Assignment_CHO2 (1) . Protected View Excel Search File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks V PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View J14 AB Direct labor Overhead applied Less: ending work in process Jobs completed Value Value Value 87 (9) Beginning balance, finished goods (Job 153) Value 90 (h) Jobs completed Value 930) 94 Cost of goods sold Beginning finished goods Jobs completed Less: ending finished goods Cost of goods sold Value Value Value 96 1000) Ending finished goods (Job 157) Value 102 103(k) Wages assigned to work in process | Value 104 1050 Indirect labor 106 Factory wages Value Less: direct labor Value 100 Indirect labor Value 109 110 TE2152: 5 2 -9 P23A P2-SACD2 107 * Type here to search e eler AutoSave Of B ExcelTemplateAssignment cho2 (1) - Protected View - Excel File Home Insert Page Layout Formulas Data Review View Help DYMO Label PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit it's safer to stay 1000) Ending finished goods (Job 157) Value 102 Value 103(k) Wages assigned to work in process 104 105 () Indirect labor Factory wages Value 107 Less: direct labor Value Indirect labor Value 109 110 111(m) Overhead applied 112 Direct labor Value 113 Overhead applied ? 114 115 116 117 110 When you have completed P2-5A, consider the following additional question. 1191. Assume that requisitions changed to $17,600. Show the impact of this change on the items listed. EN968 E21|1295629 P23A P2-SACD2 Type here to search