AutoSave CH 2 ExcelTemplateAssignment CO2 (1) - Protected View Excel Search File Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickBooks O 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 X vf 4. A B C D 1 P2-5A Analyze manufacturing accounts and determine missing amounts 2 Phillips Corporation's fiscal year ends on November 30. The following accounts are found in its job 3 order cost accounting system for the first month of the new fiscal year. Dec. 1 Beginning balance 31 Purchases Dec.31 Ending balance Raw Materials Inventory (a) Dec. 31 Requisitions 17 225 7,975 $16,850 Work in Process Inventory (b) Dec. 31 Jobs completed Dec. 1 Beginning balance 31 Direct materials 31 Direct labor 31 Overhead Deo. 31 Ending balance (@) 8,400 Finished Goods Inventory Dec. 31 Jobs completed Dec. 31 Ending balance Dec. 31 0) Deo. 31 Factory wages Factory Labor 12,025 Dec. 31 Wages assigned Manufacturing Overhead 2,900 Deo. 31 Overhead applied Dec 31 Indirect materials 31 Indirect labor 31 Other overhead (1) 1,245 Other data: 11. On December 1, two jobs were in process Job No. 154 and Job No.155. These jobs had combined direct 21255 |29|PA P2-5A CD20 O Type here to search celemei moSave OD 2 ExcelTemplateAssignment.Cho2 (1) Protected View - Excel Search 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. Enable Ed A B C D E F G H I LI KILL Other data: 1. On December 1, two jobs were in process: Job No. 154 and Job No. 155. These jobs had combined direct materials costs of $9,750 and direct labor costs of $15,000. Overhead was applied at a rate that was 75% of direct labor cost. - 2. During December, Job Nos. 156, 157 and 158 were started. On December 31, Job No. 158 was unfinished. 5 This job had charges for direct materials $3,800 and direct labor $4,800 plus manufacturing overhead. All 6 Jobs, except for Job No. 158, were completed in December 3713. 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. 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 mate Value Value Value 53 (b) Beginning work in process (Job 154 & Job 155) Direct materials Value Direct labor Value Overhead applied 2. 59 (c) Direct materials 22.1 2.5 2.9 P23A P2.SACD2 O Type here to search @element AutoSave 00 R O N Excel TemplateAssignment Cho2 (1) Protected View - Excel File Home Insert Page Layout Formulas Data Review View HelpDYMO Label PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in 114 B Requisitions of raw materials Less: indirect materials Direct materials Value Value 65 (d) Overhead applied Direct labor Overhead applied (75% of DL) Value 71 (e) Ending work in process (Job No. 158) Direct materials Direct labor Value Overhead applied Value 78 (0) 80 Completed Jobs (Jobs 154-157) Beginning balance, work in process Direct materials Direct labor Overhead applied Less: ending work in process Jobs completed Value Value Value Value Value ? Value 87 (9) Beginning balance, finished goods (Job 153) 88 12:125 29 P2.3A P2-SACD2 O Type here to search ce O PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to st A114 90 (h) Jobs completed Value 93 () Value Cost of goods sold Beginning finished goods Jobs completed Less: ending finished goods Cost of goods sold Value Value 1000) Ending finished goods (Job 157) Value 103(k) Wages assigned to work in process Value 105 (0) Indirect labor Factory wages Less: direct labor Indirect labor Value Value Value 112 111 (m) Overhead applied Direct labor Value Overhead applied 116 117 118 When you have completed P2-5A, consider the following additional question. 1191. Assume that requisitions changed to $17,600. Show the impact of this 120 change on the items listed. 121 | 82- 1625 82- 9P2-3A P2-5A CD2 T Type here to search