Thoni Manufacturing has gathered information from materials requisition sheets and labor time sheets for several jobs worked on during the last month and needs to calculate the job costs. Click here to view the Excel dataset. Part 1 Your answer is correct. What is the total amount of direct materials added to work in process during the month? You will find the data in the materials tab of the data worksheet. (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of direct materials $ 674467.99 Part 2 What is the total amount of direct labor added to work in process during the month? You will find the data in the labor tab of the data worksheet. You will need to use the VLOOKUP function to find employee wage rates in the wage rate tab of the worksheet. Remember that time data is expressed in hours and minutes, while the wage rate is expressed on an hourly basis. You will need to convert minutes worked to their decimal equivalent before making the direct labor calculation. You may find the HOUR and MINUTE functions helpful for this calculation (HOUR(cell reference) + MINUTE(cell reference))/60. (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of direct labor $ Part 3 Your Answer Correct Answer Your answer is incorrect. Thoni Manufacturing uses direct labor hours to apply manufacturing overhead. The predetermined overhead rate is $200/DLH. What is the total amount of manufacturing overhead applied to work in process during the month? (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of manufacturing overhead applied ta $ D E Job Number Direct Material Direct Labor Applied Overhead Total Job Costs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 12300 12301 12302 12303 12304 12305 12308 12307 12308 12309 12310 12311 12312 12313 12314 12315 12316 12317 12318 12319 12320 12321 12322 12323 12324 12325 12326 12327 12328 12329 12330 12331 12332 12333 12334 12335 12338 12337 12338 12339 12340 12341 12342 12343 12344 12345 12348 12347 12348 12349 12350 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Requisition Ticket 2874 2875 2876 2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890 2891 2892 2893 2894 2895 2896 2897 2898 2899 2900 2901 2902 2903 2904 2905 2906 2907 2908 2909 2910 2911 2912 2913 2914 2915 2916 Job Number 12303 12344 12328 12306 12301 12331 12346 12306 12335 12311 12314 12333 12339 12307 12303 12333 12335 12343 12320 12311 12341 12301 12341 12314 12321 12320 12320 12322 12341 12303 12332 12347 12343 12346 12321 12319 12339 12349 12313 12336 12339 12334 12340 Material Cost 831.20 28.58 567.19 772.34 1,067.91 636.09 347.82 710.03 187.20 726.89 524.08 1,015.45 1,191.69 354.21 1,090.38 764.84 54.42 473.08 1,018.35 333.64 1,444.92 983.88 1,459.12 586.16 471.42 43.47 1,348.61 1,499.51 521.23 1,118.16 372.11 1,101.29 1,200.16 611.19 1,205.69 15.02 924.42 1,098.96 699.63 1,329.68 1,326.05 899.54 618.57 innrn D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Time Ticket Start Time End Time 1438 9:53 AM 11:54 AM 1439 11:34 AM 12:53 PM 1440 9:53 AM 9:55 AM 1441 7:29 AM 12:58 PM 1442 7:41 AM 7:49 AM 1443 8:46 AM 8:56 AM 1444 11:19 AM 12:53 PM 1445 11:49 AM 11:57 AM 1446 8:14 AM 11:48 AM 1447 10:43 AM 10:47 AM 1448 7:01 AM 10:59 AM 1449 10:16 AM 11:36 AM 1450 8:57 AM 8:58 AM 1451 8:42 AM 10:43 AM 1452 8:28 AM 8:52 AM 1453 8:17 AM 11:27 AM 1454 11:03 AM 12:30 PM 1455 11:00 AM 12:58 PM 1456 11:01 AM 12:18 PM 1457 7:57 AM 8:58 AM 1458 9:13 AM 12:23 PM 1459 8:42 AM 9:42 AM 1460 10:49 AM 12:59 PM 1461 9:59 AM 12:59 PM 1462 9:45 AM 12:51 PM 1463 10:59 AM 12:59 PM 1464 8:16 AM 8:51 AM 1465 8:46 AM 8:59 AM 1466 7:49 AM 7:55 AM 1467 11:21 AM 11:42 AM 1468 7:03 AM 8:30 AM 1469 10:55 AM 12:59 PM 1470 9:11 AM 12:54 PM 1471 10:28 AM 12:48 PM 1472 8:14 AM 10:28 AM 1473 9:59 AM 10:59 AM 1474 11:47 AM 12:51 PM 1475 8:27 AM 10:59 AM 1476 10:28 AM 10:30 AM 1477 8:23 AM 11:28 AM 1478 11:26 AM 12:43 PM 1479 7:26 AM 9:30 AM 1480 10:03 AM 12:18 PM 1481 9:21 AM 9:48 AM 1482 8:47 AM 11:54 AM 1483 7:38 AM 8:56 AM 1484 8:40 AM 10:45 AM 1485 8:52 AM 11:54 AM 1486 11:49 AM 12:52 PM 1487 11:54 AM 12:54 PM Time Worked 2:01 1:19 0:02 5:29 0:08 0:10 1:34 0:08 3:34 0:04 3:58 1:20 0:01 2:01 0:24 3:10 1:27 1:58 1:17 1:01 3:10 1:00 2:10 3:00 3:06 2:00 0:35 0:13 0:06 0:21 1:27 2:04 3:43 2:20 2:14 1:00 1:04 2:32 0:02 3:05 1:17 2:04 2:15 0:27 3:07 1:18 2:05 3:02 1:03 1:00 Job Number 12343 12330 12330 12349 12322 12350 12332 12307 12333 12318 12312 12346 12340 12325 12309 12318 12317 12317 12321 12335 12345 12340 12330 12304 12338 12321 12337 12343 12328 12336 12325 12300 12347 12347 12333 12309 12345 12331 12329 12322 12331 12318 12301 12347 12311 12300 12337 12341 12302 12327 Employee 1025 1007 1102 1043 1100 1015 1120 1055 1070 1027 1038 1039 1070 1080 1042 1010 1010 1037 1014 1067 1062 1094 1011 1047 1104 1079 1093 1032 1073 1010 1107 1047 1007 1035 1008 1094 1057 1061 1034 1109 1035 1115 1058 1036 1015 1094 1085 Scree 1092 B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Employee Number 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 Hourly Wage Rate $21.50 $ 14.00 $19.50 $23.00 $ 18.00 $ 20.00 $ 20.00 $ 10.50 $ 12.25 $23.00 $ 14.00 $ 14.00 $ 20.00 $ 18.00 $21.50 $ 25.00 $ 16.00 $ 23.00 $ 12.75 $ 11.00 $ 10.10 $23.00 $ 20.00 $ 25.00 $21.50 $ 14.00 $21.50 $ 12.25 $ 18.00 $ 16.50 $23.00 $ 14.00 $ 16.00 $ 18.00 $ 11.00 $ 25.00 $ 20.00 $ 21.50 $ 12.25 $ 19.50 $ 16.00 $ 20.00 $ 14.00 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 40 41 42 43 44 Thoni Manufacturing has gathered information from materials requisition sheets and labor time sheets for several jobs worked on during the last month and needs to calculate the job costs. Click here to view the Excel dataset. Part 1 Your answer is correct. What is the total amount of direct materials added to work in process during the month? You will find the data in the materials tab of the data worksheet. (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of direct materials $ 674467.99 Part 2 What is the total amount of direct labor added to work in process during the month? You will find the data in the labor tab of the data worksheet. You will need to use the VLOOKUP function to find employee wage rates in the wage rate tab of the worksheet. Remember that time data is expressed in hours and minutes, while the wage rate is expressed on an hourly basis. You will need to convert minutes worked to their decimal equivalent before making the direct labor calculation. You may find the HOUR and MINUTE functions helpful for this calculation (HOUR(cell reference) + MINUTE(cell reference))/60. (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of direct labor $ Part 3 Your Answer Correct Answer Your answer is incorrect. Thoni Manufacturing uses direct labor hours to apply manufacturing overhead. The predetermined overhead rate is $200/DLH. What is the total amount of manufacturing overhead applied to work in process during the month? (Round answer to 2 decimal places, e.g. 1,524.54.) Total amount of manufacturing overhead applied ta $ D E Job Number Direct Material Direct Labor Applied Overhead Total Job Costs 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 12300 12301 12302 12303 12304 12305 12308 12307 12308 12309 12310 12311 12312 12313 12314 12315 12316 12317 12318 12319 12320 12321 12322 12323 12324 12325 12326 12327 12328 12329 12330 12331 12332 12333 12334 12335 12338 12337 12338 12339 12340 12341 12342 12343 12344 12345 12348 12347 12348 12349 12350 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 Requisition Ticket 2874 2875 2876 2877 2878 2879 2880 2881 2882 2883 2884 2885 2886 2887 2888 2889 2890 2891 2892 2893 2894 2895 2896 2897 2898 2899 2900 2901 2902 2903 2904 2905 2906 2907 2908 2909 2910 2911 2912 2913 2914 2915 2916 Job Number 12303 12344 12328 12306 12301 12331 12346 12306 12335 12311 12314 12333 12339 12307 12303 12333 12335 12343 12320 12311 12341 12301 12341 12314 12321 12320 12320 12322 12341 12303 12332 12347 12343 12346 12321 12319 12339 12349 12313 12336 12339 12334 12340 Material Cost 831.20 28.58 567.19 772.34 1,067.91 636.09 347.82 710.03 187.20 726.89 524.08 1,015.45 1,191.69 354.21 1,090.38 764.84 54.42 473.08 1,018.35 333.64 1,444.92 983.88 1,459.12 586.16 471.42 43.47 1,348.61 1,499.51 521.23 1,118.16 372.11 1,101.29 1,200.16 611.19 1,205.69 15.02 924.42 1,098.96 699.63 1,329.68 1,326.05 899.54 618.57 innrn D E F 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 Time Ticket Start Time End Time 1438 9:53 AM 11:54 AM 1439 11:34 AM 12:53 PM 1440 9:53 AM 9:55 AM 1441 7:29 AM 12:58 PM 1442 7:41 AM 7:49 AM 1443 8:46 AM 8:56 AM 1444 11:19 AM 12:53 PM 1445 11:49 AM 11:57 AM 1446 8:14 AM 11:48 AM 1447 10:43 AM 10:47 AM 1448 7:01 AM 10:59 AM 1449 10:16 AM 11:36 AM 1450 8:57 AM 8:58 AM 1451 8:42 AM 10:43 AM 1452 8:28 AM 8:52 AM 1453 8:17 AM 11:27 AM 1454 11:03 AM 12:30 PM 1455 11:00 AM 12:58 PM 1456 11:01 AM 12:18 PM 1457 7:57 AM 8:58 AM 1458 9:13 AM 12:23 PM 1459 8:42 AM 9:42 AM 1460 10:49 AM 12:59 PM 1461 9:59 AM 12:59 PM 1462 9:45 AM 12:51 PM 1463 10:59 AM 12:59 PM 1464 8:16 AM 8:51 AM 1465 8:46 AM 8:59 AM 1466 7:49 AM 7:55 AM 1467 11:21 AM 11:42 AM 1468 7:03 AM 8:30 AM 1469 10:55 AM 12:59 PM 1470 9:11 AM 12:54 PM 1471 10:28 AM 12:48 PM 1472 8:14 AM 10:28 AM 1473 9:59 AM 10:59 AM 1474 11:47 AM 12:51 PM 1475 8:27 AM 10:59 AM 1476 10:28 AM 10:30 AM 1477 8:23 AM 11:28 AM 1478 11:26 AM 12:43 PM 1479 7:26 AM 9:30 AM 1480 10:03 AM 12:18 PM 1481 9:21 AM 9:48 AM 1482 8:47 AM 11:54 AM 1483 7:38 AM 8:56 AM 1484 8:40 AM 10:45 AM 1485 8:52 AM 11:54 AM 1486 11:49 AM 12:52 PM 1487 11:54 AM 12:54 PM Time Worked 2:01 1:19 0:02 5:29 0:08 0:10 1:34 0:08 3:34 0:04 3:58 1:20 0:01 2:01 0:24 3:10 1:27 1:58 1:17 1:01 3:10 1:00 2:10 3:00 3:06 2:00 0:35 0:13 0:06 0:21 1:27 2:04 3:43 2:20 2:14 1:00 1:04 2:32 0:02 3:05 1:17 2:04 2:15 0:27 3:07 1:18 2:05 3:02 1:03 1:00 Job Number 12343 12330 12330 12349 12322 12350 12332 12307 12333 12318 12312 12346 12340 12325 12309 12318 12317 12317 12321 12335 12345 12340 12330 12304 12338 12321 12337 12343 12328 12336 12325 12300 12347 12347 12333 12309 12345 12331 12329 12322 12331 12318 12301 12347 12311 12300 12337 12341 12302 12327 Employee 1025 1007 1102 1043 1100 1015 1120 1055 1070 1027 1038 1039 1070 1080 1042 1010 1010 1037 1014 1067 1062 1094 1011 1047 1104 1079 1093 1032 1073 1010 1107 1047 1007 1035 1008 1094 1057 1061 1034 1109 1035 1115 1058 1036 1015 1094 1085 Scree 1092 B 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 Employee Number 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 Hourly Wage Rate $21.50 $ 14.00 $19.50 $23.00 $ 18.00 $ 20.00 $ 20.00 $ 10.50 $ 12.25 $23.00 $ 14.00 $ 14.00 $ 20.00 $ 18.00 $21.50 $ 25.00 $ 16.00 $ 23.00 $ 12.75 $ 11.00 $ 10.10 $23.00 $ 20.00 $ 25.00 $21.50 $ 14.00 $21.50 $ 12.25 $ 18.00 $ 16.50 $23.00 $ 14.00 $ 16.00 $ 18.00 $ 11.00 $ 25.00 $ 20.00 $ 21.50 $ 12.25 $ 19.50 $ 16.00 $ 20.00 $ 14.00 1024 1025 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040 1041 1042 40 41 42 43 44