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. 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 ta $ 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 Data 1 - Job Cost Totals Data 2 - Materials Requisition Job Number Direct Material Direct Labor Applied Overhead Total Job Costa 12300 12301 12302 12303 12304 12306 12300 12307 12308 12300 12310 12311 12312 12313 12314 12315 12316 12317 12318 12319 12320 12321 12302 12323 12324 12325 12326 12327 12328 12329 12330 12391 12332 12333 12334 12335 12336 12337 12338 12330 12340 12341 12342 12343 12344 12345 12346 12 12340 12349 12350 - Materials Requisitions Data 3 - Labor Time Tickets Time Ticket Stars Tint End Time Time World Engless 1438 0:53AM11.4 AM 12:33 1025 143 11 AM 12:53 PM 100P 1440 SAM SAM DOR 1102 1441 29 AM 128 PM 520 100 1442 47 AM 7:40 AM DOB T100 1443 SAM SAM 10 1444 119 AM 12:53 PM 134 1120 1445 149 AM 11:57AM 000 1055 14 8:14 AM 11:46 3:34 14:47 10:43 AM 10.TAN 04 2 192 144 TOTAM 10:59 AM 150 2012 10 149 10-16 AM 11:36 AM 120 1000 1490 8 STAM 856 AM 091 1000 1455 8:42 AM 10:43 AM 2.01 1080 1499 20 AM 8AM 024 1042 1493 8:17AM112 AM 1090 1454 11AM 12PM 121 1090 1488 T:00 AM 1256 150 103 149 11AM 12PU 117 1914 1457 T-5 AM SAM 101 100 140 8 13 AM 12237 3.10 TO 145 8:42 AM AN 100 09 1460 10:49 AM 12:00 PM 210 011 5461 9-5 AM 12:00 PM 3:00 12001 1462 45 AM 12:51 PM 300 1104 1453 105 AM 1259 200 1915 1466 16 AM SAN 35 TO 1000 AM SAM 013 1012 1480 749 AM 7:55 AM 0:00 1073 1467 TAMA 021 1010 14 TOJAMAN 127 1102 1400 10-55 AM 12:50 104 2200 104 1470 AM 12:54 2.0 1234 TOT 1071 1028 AM 170. 1999 1472 8:14 AM 10:28 AM 1008 1473 05 AM 10-DAN 100 ION 1674 1247 AM 12:51 PM 1:54 1002 1415 827 AM 10:30 AM 232 1231 T041 1478 10 24 AM 10 30 AM DO TO 1077 823 AM 11:25 AM 305 1109 1478 1128 AM 1243 PM 17 2:30 1005 1470 T20 AM 1:30 AM 204 15 SUNG 10-AM 12:13 PM 10 1481 21 AMBAM 103 1482 47 11 AM 103 14 MAM AM 115 1454 840 AM 15.45 AM 205 23 105 1485 852 AM 11:34 AM 3:03 12 1050 49 AM 12:47 PM 103 100 1487 11 AM 1254 PM 100 1400 123 AM 12:57 PM 134 2014 TO 1 03 AM 11:36 AM 3.33 1230 1073 1400 8:OPAMOA 100 10 1401 AM 12:53 PM 300 12:30 1023 11 AM 11:05 AM DO 10 143 AM1 AM 023 10 5404 7:51 AMAN 997 1003 100 O SAM DAAN 001 1005 14 7:05 AMDAM 35 1054 1491 7 STAM 11:58 AM 401 2004 1073 9.30 AM 10:54 AM 104 10 1400 140 AM 11:43 AM 003 100 1500 TODAM TANZAN 003 100 1501 TOTAM 12:09 PM 102 120 100 1502 9:59 AM 000 2010 1503 1123 AM 12:45 PM 111 1058 1504 T 10 AM 124 10 949 AM 11AM 209 1057 500 SAM11 STAN 05 2009 1100 1907 737 AM 10-SSAN 12 TOM 150 10:40 AM 19:59 AM 13 1972 1900 14 AM 10:49 AM 1:35 1004 1510 90AM 11 AM 200 1015 1511 10 MM 120 PM 222 19 1512 946 AM 11:58 AM 211 1513 31 AM ADAM 400 20 1120 1514 8 AM 10 1040 1515 803 AM 815 02 1510 10 AM 11 SDAN 100 1007 1517 RAMSAN 8:00 tod 151 10:30 AM 12:02 2.22 1048 1519 727 AM 123 1910 1920 10-51 AM 12:52 PM 201 12:00 100 1521 944 AM ABAN DO 119 1922 16 AM 30 AM 10 12338 100 1923 9:25 AM 9:28 AM es 10 1524 7.DO AMAN 1084 1923 ROBAMANI 2:32 1100 15 620 AM 10:21 AM 201 23 1615 hoc 1412 UN 12:17 Student
