File Home Insert Draw Formulas Data Review View Help Editing A 5 v 849 Calibri 11 B x=841+ A B C 1 2 Information on Kwon Manufacturing's activities for its first month of operations follows: 3 4 a. Purchased raw materials on credit. $100,000 5 b. Materials requisitions show the following materials used for the month. 6 7 Job 201 $48,200 8 Job 202 23,600 9 Total direct materials 71,800 10 Indirect materials 8,620 11 Total materials used i $80,420 12 13 Time tickets show the following labor used for the month. 14 15 Job 201 16 Job 202 17 Total direct labor 18 Indirect labor 19 Total labor used 20 $39,200 12,600 51,800 24,200 $76,000 v Number E F G H 21 d. Applied overhead to jobs using the predetermined overhead rate 22 e Transferred Job 201 to Finished Goods Inventory. f (1) Sold Job 201 on credit for: 23 24g Incurred the following actual other overhead costs for the month. 25 26 Depreciation of factory equipment 37 Dantan Furton building Insinhlal Graded Worksheet Calculation Mode: Automatic Workbook Statistics $32,000 80% of direct materials cost $163,760 (2) Record cost of goods sold for Job 201 A 26 Depreciation of factory equipment 27 Rent on factory building (payable) 28 Factory utilities (payable) B C D $32,000 500 800 29 Expired factory insurance 3,000 30 Total other factory overhead costs $36,300 31 32 Required: 33 1. Prepare a job cost sheet for Job 201 and for Job 202 for the month. 34 35 (Use cells A4 to F30 from the given information to complete this question.) 36 37 38 Materials 39 Labor 40 Overhead 41 Total cost 42 Number Job Number 201 $48,200 202 $23,600 39,200 12,600 38,560 18,880 $125,960 $55,080 43 2. Compute gross profit on the sale of Job 201. 44 45 (Use cells A4 to F30 from the given information to complete this question.) 46 47 48 Sales 49 Cost of goods sold 50 Gross Profit 51 E Job 201 $163,760 =841+ Graded Worksheet + Calculation Mode: Automatic Workbook Statistis