are these better?

JOB ORDER COSTING PROBLEM Jonckheimering The data toodete Determine the cost to date of each of the seven jobs Machine ws Materiale Completed Price Job Cost to Date Job Joti 201 co 200 Factory Labor 13.10 10 60 150 40 40 16,00 10 500 13,150 5170 yes 10 5 200 Jab 2003 Joh 207 Forfactory 7010 WS the factory och 12.50 Complete the following transactions for Jonic Industries by entering the mounts The maintenant Wwwer purchased $123.420 Date Account DHE Credit Account 8. Materials were purchased on account. $123,470 Debit Credit Date 8 Account Materials Accounts Payable 9. Materials were requisitioned (based on the information in the table above.) Date Debit Credit 4 5 3 7 8 9 0 1 2 3 54 55 36 37 38 39 10 11 42 13 14 15 46 47 48 49 50 51 52 53 Account Work in Process Factory Overhead Materials 10. Factory labor was used (based on the information in the table above.) Debit Credit Date 10 Account Work in Process Factory Overhead Wages Payable $16.610 11. Factory overhead costs were incurred on account. 54 Nate Account Credit Debit $16,610 11. Factory overhead costs were incurred on account. Debit Credit Date 11. Account Factory Overhead Accounts Payable 12. Depreciation of factory machinery and equipment: $14,270 Debit Credit Date 12 Account Factory Overhead Accumulated Depreciation $60 13. The factory overhead rate, per machine hour Machine hours used appears in the table above Debit Credit Date 13 Account Work in Process Factory Overhead 78 79 80 14 Jobs were completed Debit Credit Date 14. Account Finished Goods Work in Process 81 82 83 84 85 86 87 88 89 90 91 92 93 94 15. Jobs were shipped to customers and inventory was adjusted. Debit Credit Date 15 Account Cost of Goods Sold Finished Goods 95 16. Customers were billed on account for jobs sold. Debit Credit 96 97 98 99 100 101 102 103 104 105 106 Date 16 Account Accounts Receivable Sales 07 05 06 Determine the following amounts at the end of the first accounting period 08 based on the journal entries above. (Questions #17-21) 09 110 17 Ending balance in the Materials account 111 18 Cost so far of all uncompleted jobs 112 19. Cost of all jobs completed but not yet sold 113 20 Cost of all jobs that have been sold 114 21. Gross profit on all jobs that have been sold 115 116 (Question #22) 117 Determined during the next accounting period: 118 22. Actual factory overhead for the previous period: $21,690 119 120 Date Account Debit Credit 121 22 Cost of Goods Sold 122 Factory Overhead 123 124 125 126 127 JOB ORDER COSTING PROBLEM Instructions 2 Jonic Industries, Ineses border contesto acting custom The folosing at was doned to producten of operations Determine the cost to date of each of the seven jobs below Sales be Cythe w Job ob 201 Job 202 Job 203 Job 204 Job 205 Job 200 Job207 For gener factory Materials 60 16.350 9310 9.500 13.150 5170 1410 17 550 Factory Mac Job Cost Labor Hours Completed Price to Date 1130 10 1 10.90 10 yes 2 7670 40 yes 15810 00 yes 1 40 40 5 13.00 10 YOS H100 5 6830 25 yes 25200 7 5530 The factory watercourse be Complete the following transactions for Jonick Industries by entering the amounts. Our The transactions to one another 5123 470 8. Malons were purchased on account Date Account Debilt Credit JOB ORDER COSTING PROBLEM Instructions - Determine Jonick Industries, Inc uses a job order costing system in manufacturing custom products a. Use formulis and/or tur Use variables cell refer The following table summarizes data related to production in June, the first month of operations cDo not use "helper Cell Your formulas mayor Determine the cost to date of each of the seven jobs below. cells where you have (only if sold) (Questions #1-7) d. Use the SUM and SUM Factory Machine Sales Job Cost e Consider using the su Job Materials Labor Hours Completed Price to Date Job 201 6,680 13,130 90 1 Answer #1 using a forma Job 202 16,380 10,930 70 yes 2 Copy the formula for #1 Job 203 9,310 7,670 40 yes 32,950 3 Job 204 9,500 15,810 60 yes 4 Job 205 13,150 4,830 40 5 Job 206 5,170 13,300 30 yes 6 34,460 Job 207 7,410 25 6,830 7 yes 26,760 For general factory use 17,550 5,530 *The factory overhead rate per machine hour appears in cell L70 below Q R S T U V W X Y Z AA AB AC AD Instructions - Determine the numerical answers to questions #1-22 a Use formulas and/or functions to determine each answer b Use variables/cell references rather than typing numbers into the formulas c Do not use "helper cells" Your formulas may only reference cells where data is given OR cells where you have previously entered in answers, d. Use the SUM and SUMIF functions at least twice each e. Consider using the SUMIFS function, although it is not required #1-7) ast e Answer #1 using a formula that may be copied down to the six cells below it. Copy the formula for #1 down in order to answer #2 through #7 JOB ORDER COSTING PROBLEM Jonckheimering The data toodete Determine the cost to date of each of the seven jobs Machine ws Materiale Completed Price Job Cost to Date Job Joti 201 co 200 Factory Labor 13.10 10 60 150 40 40 16,00 10 500 13,150 5170 yes 10 5 200 Jab 2003 Joh 207 Forfactory 7010 WS the factory och 12.50 Complete the following transactions for Jonic Industries by entering the mounts The maintenant Wwwer purchased $123.420 Date Account DHE Credit Account 8. Materials were purchased on account. $123,470 Debit Credit Date 8 Account Materials Accounts Payable 9. Materials were requisitioned (based on the information in the table above.) Date Debit Credit 4 5 3 7 8 9 0 1 2 3 54 55 36 37 38 39 10 11 42 13 14 15 46 47 48 49 50 51 52 53 Account Work in Process Factory Overhead Materials 10. Factory labor was used (based on the information in the table above.) Debit Credit Date 10 Account Work in Process Factory Overhead Wages Payable $16.610 11. Factory overhead costs were incurred on account. 54 Nate Account Credit Debit $16,610 11. Factory overhead costs were incurred on account. Debit Credit Date 11. Account Factory Overhead Accounts Payable 12. Depreciation of factory machinery and equipment: $14,270 Debit Credit Date 12 Account Factory Overhead Accumulated Depreciation $60 13. The factory overhead rate, per machine hour Machine hours used appears in the table above Debit Credit Date 13 Account Work in Process Factory Overhead 78 79 80 14 Jobs were completed Debit Credit Date 14. Account Finished Goods Work in Process 81 82 83 84 85 86 87 88 89 90 91 92 93 94 15. Jobs were shipped to customers and inventory was adjusted. Debit Credit Date 15 Account Cost of Goods Sold Finished Goods 95 16. Customers were billed on account for jobs sold. Debit Credit 96 97 98 99 100 101 102 103 104 105 106 Date 16 Account Accounts Receivable Sales 07 05 06 Determine the following amounts at the end of the first accounting period 08 based on the journal entries above. (Questions #17-21) 09 110 17 Ending balance in the Materials account 111 18 Cost so far of all uncompleted jobs 112 19. Cost of all jobs completed but not yet sold 113 20 Cost of all jobs that have been sold 114 21. Gross profit on all jobs that have been sold 115 116 (Question #22) 117 Determined during the next accounting period: 118 22. Actual factory overhead for the previous period: $21,690 119 120 Date Account Debit Credit 121 22 Cost of Goods Sold 122 Factory Overhead 123 124 125 126 127 JOB ORDER COSTING PROBLEM Instructions 2 Jonic Industries, Ineses border contesto acting custom The folosing at was doned to producten of operations Determine the cost to date of each of the seven jobs below Sales be Cythe w Job ob 201 Job 202 Job 203 Job 204 Job 205 Job 200 Job207 For gener factory Materials 60 16.350 9310 9.500 13.150 5170 1410 17 550 Factory Mac Job Cost Labor Hours Completed Price to Date 1130 10 1 10.90 10 yes 2 7670 40 yes 15810 00 yes 1 40 40 5 13.00 10 YOS H100 5 6830 25 yes 25200 7 5530 The factory watercourse be Complete the following transactions for Jonick Industries by entering the amounts. Our The transactions to one another 5123 470 8. Malons were purchased on account Date Account Debilt Credit JOB ORDER COSTING PROBLEM Instructions - Determine Jonick Industries, Inc uses a job order costing system in manufacturing custom products a. Use formulis and/or tur Use variables cell refer The following table summarizes data related to production in June, the first month of operations cDo not use "helper Cell Your formulas mayor Determine the cost to date of each of the seven jobs below. cells where you have (only if sold) (Questions #1-7) d. Use the SUM and SUM Factory Machine Sales Job Cost e Consider using the su Job Materials Labor Hours Completed Price to Date Job 201 6,680 13,130 90 1 Answer #1 using a forma Job 202 16,380 10,930 70 yes 2 Copy the formula for #1 Job 203 9,310 7,670 40 yes 32,950 3 Job 204 9,500 15,810 60 yes 4 Job 205 13,150 4,830 40 5 Job 206 5,170 13,300 30 yes 6 34,460 Job 207 7,410 25 6,830 7 yes 26,760 For general factory use 17,550 5,530 *The factory overhead rate per machine hour appears in cell L70 below Q R S T U V W X Y Z AA AB AC AD Instructions - Determine the numerical answers to questions #1-22 a Use formulas and/or functions to determine each answer b Use variables/cell references rather than typing numbers into the formulas c Do not use "helper cells" Your formulas may only reference cells where data is given OR cells where you have previously entered in answers, d. Use the SUM and SUMIF functions at least twice each e. Consider using the SUMIFS function, although it is not required #1-7) ast e Answer #1 using a formula that may be copied down to the six cells below it. Copy the formula for #1 down in order to answer #2 through #7