Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 2 - Using the financial statement file and the payroll data file perform some analytical tests. You will need to develop some analytical tests

Part 2 - Using the financial statement file and the payroll data file perform some analytical tests. You will need to develop some analytical tests using the Income Statement data using Excel. It can be horizontal and/or vertical analysis, financial ratios, etc. You will need to carry out any analytical tests on the payroll file data, which you deem necessary, using IDEA. Remember that there are tutorial videos about IDEA both in the course and on its website that may be useful to you. Write a 1-2 sentence explanation for each analysis you are performing and print the results along with the history log when you have completed the analysis in IDEA for delivery this week.

Archivo de datos sobre nomina

EMP_ID Fecha de pago de Nmina Tarifa de Pago Deducciones Porcentuales Horas Regulares Horas Extras Salario Bruto Deducciones Salario Neto
117 11/2/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
117 11/16/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
117 11/30/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
117 12/14/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
117 12/28/2020 24.95 0.2077 80 0 1996.00 414.57 1581.43
149 11/2/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
149 11/16/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
149 11/30/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
149 12/14/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
149 12/28/2020 16.85 0.2857 80 0 1348.00 385.12 962.88
162 11/2/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
162 11/16/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
162 11/30/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
162 12/14/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
162 12/28/2020 20.25 0.1552 80 0 1620.00 251.42 1368.58
179 11/2/2020 12.16 0.0347 80 0 972.80 33.76 939.04
179 11/16/2020 12.16 0.0347 80 3 1009.28 35.02 974.26
179 11/30/2020 12.16 0.0347 80 0 972.80 33.76 939.04
179 12/14/2020 12.16 0.0347 80 0 972.80 33.76 939.04
179 12/28/2020 12.16 0.0347 80 0 972.80 33.76 939.04
182 11/2/2020 16.64 0.1475 80 10 1497.60 220.90 1276.70
182 11/16/2020 16.64 0.1475 80 0 1331.20 196.35 1134.85
182 11/30/2020 16.64 0.1475 80 0 1331.20 196.35 1134.85
182 12/14/2020 16.64 0.1475 80 0 1331.20 196.35 1134.85
182 12/28/2020 16.64 0.1475 80 0 1331.20 196.35 1134.85
191 11/2/2020 12.31 0.1653 80 0 984.80 162.79 822.01
191 11/16/2020 12.31 0.1653 80 0 984.80 162.79 822.01
191 11/30/2020 12.31 0.1653 80 0 984.80 162.79 822.01
191 12/14/2020 12.31 0.1653 80 0 984.80 162.79 822.01
191 12/28/2020 12.31 0.1653 80 0 984.80 162.79 822.01
212 11/2/2020 12.62 0.1949 0 0 0.00 0.00 0.00
212 11/16/2020 12.62 0.1949 0 0 0.00 0.00 0.00
212 11/30/2020 12.62 0.1949 0 0 0.00 0.00 0.00
212 12/14/2020 12.62 0.1949 0 0 0.00 0.00 0.00
212 12/28/2020 12.62 0.1949 0 0 0.00 0.00 0.00
213 11/2/2020 12.2 0.1433 80 0 976.00 139.86 836.14
213 11/16/2020 12.2 0.1433 80 0 976.00 139.86 836.14
213 11/30/2020 12.2 0.1433 80 0 976.00 139.86 836.14
213 12/14/2020 12.2 0.1433 80 0 976.00 139.86 836.14
213 12/28/2020 12.2 0.1433 80 0 976.00 139.86 836.14
217 11/2/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 11/2/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
217 11/16/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 11/16/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
217 11/30/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 11/30/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
217 12/14/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 12/14/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
217 12/28/2020 23.91 0.2163 80 0 1912.80 413.74 1499.06
217 12/28/2020 24.9 0.3199 80 0 1992.00 637.24 1354.76
238 11/2/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
238 11/16/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
238 11/30/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
238 12/14/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
238 12/28/2020 17.44 0.3754 80 0 1395.20 523.76 871.44
247 11/2/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
247 11/16/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
247 11/30/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
247 12/14/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
247 12/28/2020 13.5 0.0195 80 0 1080.00 21.06 1058.94
254 11/2/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
254 11/16/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
254 11/30/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
254 12/14/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
254 12/28/2020 18.25 0.1254 80 0 1460.00 183.08 1276.92
255 11/2/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
255 11/16/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
255 11/30/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
255 12/14/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
255 12/28/2020 24.23 0.1828 80 0 1938.40 354.34 1584.06
269 11/2/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
269 11/16/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
269 11/30/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
269 12/14/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
269 12/28/2020 24.32 0.3129 80 0 1945.60 608.78 1336.82
277 11/2/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
277 11/16/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
277 11/30/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
277 12/14/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
277 12/28/2020 24.32 0.178 80 0 1945.60 346.32 1599.28
278 11/2/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
278 11/16/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
278 11/30/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
278 12/14/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
278 12/28/2020 13.93 0.0683 80 0 1114.40 76.11 1038.29
319 11/2/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
319 11/16/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
319 11/30/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
319 12/14/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
319 12/28/2020 17.7 0.1803 80 0 1416.00 255.30 1160.70
330 11/2/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
330 11/16/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
330 11/30/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
330 12/14/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
330 12/28/2020 23.51 0.2654 80 10 2115.90 561.56 1554.34
333 11/2/2020 16.44 0.3093 0 0 0.00 0.00 0.00
333 11/16/2020 16.44 0.3093 0 0 0.00 0.00 0.00
333 11/30/2020 16.44 0.3093 0 0 0.00 0.00 0.00
333 12/14/2020 16.44 0.3093 0 0 0.00 0.00 0.00
333 12/28/2020 16.44 0.3093 0 0 0.00 0.00 0.00
336 11/2/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
336 11/16/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
336 11/30/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
336 12/14/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
336 12/28/2020 20.33 0.3483 80 0 1626.40 566.48 1059.92
338 11/2/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
338 11/16/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
338 11/30/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
338 12/14/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
338 12/28/2020 24.84 0.3465 80 0 1987.20 688.56 1298.64
341 11/2/2020 12.45 0.3879 80 0 996.00 386.35 609.65
341 11/16/2020 12.45 0.3879 80 0 996.00 386.35 609.65
341 11/30/2020 12.45 0.3879 80 0 996.00 386.35 609.65
341 12/14/2020 12.45 0.3879 80 0 996.00 386.35 609.65
341 12/28/2020 12.45 0.3879 80 0 996.00 386.35 609.65
352 11/2/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
352 11/16/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
352 11/30/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
352 12/14/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
352 12/28/2020 23.81 0.3105 80 0 1904.80 591.44 1313.36
353 11/2/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
353 11/16/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
353 11/30/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
353 12/14/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
353 12/28/2020 20.14 0.1432 80 0 1611.20 230.72 1380.48
357 11/2/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
357 11/16/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
357 11/30/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
357 12/14/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
357 12/28/2020 16.23 0.3752 80 0 1298.40 487.16 811.24
368 11/2/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
368 11/16/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
368 11/30/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
368 12/14/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
368 12/28/2020 18.29 0.2184 80 0 1463.20 319.56 1143.64
373 11/2/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
373 11/16/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
373 11/30/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
373 12/14/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
373 12/28/2020 18.09 0.2109 80 0 1447.20 305.21 1141.99
377 11/2/2020 24.56 0.2163 80 25 2578.80 557.79 2021.01
377 11/16/2020 24.56 0.2163 80 30 2701.60 584.36 2117.24
377 11/30/2020 24.56 0.2163 80 35 2824.40 610.92 2213.48
377 12/14/2020 24.56 0.2163 80 20 2456.00 531.23 1924.77
377 12/28/2020 24.56 0.2163 80 25 2578.80 557.79 2021.01
378 11/2/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
378 11/16/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
378 11/30/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
378 12/14/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
378 12/28/2020 18.09 0.2034 80 0 1447.20 294.36 1152.84
381 11/2/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
381 11/16/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
381 11/30/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
381 12/14/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
381 12/28/2020 19.24 0.3534 80 0 1539.20 543.95 995.25
382 11/2/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
382 11/16/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
382 11/30/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
382 12/14/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
382 12/28/2020 16.71 0.2868 80 0 1336.80 383.39 953.41
384 11/2/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
384 11/16/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
384 11/30/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
384 12/14/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
384 12/28/2020 13.81 0.2574 80 0 1104.80 284.38 820.42
388 11/2/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
388 11/16/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
388 11/30/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
388 12/14/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
388 12/28/2020 13.44 0.1884 80 0 1075.20 202.57 872.63
396 11/2/2020 14.85 0.3117 80 0 1188.00 370.30 817.70
396 11/16/2020 14.85 0.3117 0 0 0.00 0.00 0.00
396 11/30/2020 14.85 0.3117 0 0 0.00 0.00 0.00
396 12/14/2020 14.85 0.3117 0 0 0.00 0.00 0.00
396 12/28/2020 14.85 0.3117 0 0 0.00 0.00 0.00
407 11/2/2020 21.38 0.1565 80 0 1710.40 267.68 1442.72
407 11/2/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
407 11/16/2020 21.38 0.1565 80 2 1753.16 274.37 1478.79
407 11/16/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
407 11/30/2020 21.38 0.1565 80 6 1838.68 287.75 1550.93
407 11/30/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
407 12/14/2020 21.38 0.1565 80 0 1710.40 267.68 1442.72
407 12/14/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
407 12/28/2020 21.38 0.1565 80 0 1710.40 267.68 1442.72
407 12/28/2020 14.99 0.2919 80 0 1199.20 350.05 849.15
425 11/2/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
425 11/16/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
425 11/30/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
425 12/14/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
425 12/28/2020 23.89 0.2614 80 0 1911.20 499.59 1411.61
429 11/2/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
429 11/16/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
429 11/30/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
429 12/14/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
429 12/28/2020 18.36 0.3475 80 0 1468.80 510.41 958.39
431 11/2/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
431 11/16/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
431 11/30/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
431 12/14/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
431 12/28/2020 19.81 0.2312 80 0 1584.80 366.41 1218.39
441 11/2/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
441 11/16/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
441 11/30/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
441 12/14/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
441 12/28/2020 24.98 0.3631 80 0 1998.40 725.62 1272.78
459 11/2/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 11/16/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 11/30/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 11/30/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 12/14/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
459 12/28/2020 17.66 0.3544 80 0 1412.80 500.70 912.10
463 11/2/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
463 11/16/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
463 11/30/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
463 12/14/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
463 12/28/2020 22.93 0.1895 80 0 1834.40 347.62 1486.78
476 11/2/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
476 11/16/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
476 11/30/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
476 12/14/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
476 12/28/2020 19.37 0.2015 80 0 1549.60 312.24 1237.36
482 11/2/2020 15.56 0.2334 80 0 1244.80 290.54 954.26
482 11/16/2020 15.56 0.2334 80 7 1353.72 315.96 1037.76
482 11/30/2020 15.56 0.2334 80 7 1353.72 315.96 1037.76
482 12/14/2020 15.56 0.2334 80 0 1244.80 290.54 954.26
482 12/28/2020 15.56 0.2334 80 0 1244.80 290.54 954.26
491 11/2/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
491 11/16/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
491 11/30/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
491 12/14/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
491 12/28/2020 14.43 0.1799 80 0 1154.40 207.68 946.72
492 11/2/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
492 11/16/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
492 11/30/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
492 12/14/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
492 12/28/2020 20.43 0.2602 80 0 1634.40 425.27 1209.13
510 11/2/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
510 11/16/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
510 11/30/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
510 12/14/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
510 12/28/2020 13.05 0.0736 80 0 1044.00 76.84 967.16
520 11/2/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
520 11/16/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
520 11/30/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
520 12/14/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
520 12/28/2020 24.52 0.2125 80 0 1961.60 416.84 1544.76
522 11/2/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
522 11/16/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
522 11/30/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
522 12/14/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
522 12/28/2020 23.36 0.1441 80 0 1868.80 269.29 1599.51
525 11/2/2020 14.34 0.3292 80 0 1147.20 377.66 769.54
525 11/16/2020 14.34 0.3292 80 3 1190.22 391.82 798.40
525 11/30/2020 14.34 0.3292 80 8 1261.92 415.42 846.50
525 12/14/2020 14.34 0.3292 80 8 1261.92 415.42 846.50
525 12/28/2020 14.34 0.3292 80 0 1147.20 377.66 769.54
531 11/2/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
531 11/16/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
531 11/30/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
531 12/14/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
531 12/28/2020 21.57 0.182 80 0 1725.60 314.06 1411.54
549 11/2/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
549 11/16/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
549 11/30/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
549 12/14/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
549 12/28/2020 17.53 0.2852 80 0 1402.40 399.96 1002.44
565 11/2/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
565 11/16/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
565 11/30/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
565 12/14/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
565 12/28/2020 13.53 0.0197 80 0 1082.40 21.32 1061.08
575 11/2/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
575 11/16/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
575 11/30/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
575 12/14/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
575 12/28/2020 13.8 0.2148 80 0 1104.00 237.14 866.86
576 11/2/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
576 11/16/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
576 11/30/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
576 12/14/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
576 12/28/2020 24.96 0.2897 80 0 1996.80 578.47 1418.33
579 11/2/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
579 11/16/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
579 11/30/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
579 12/14/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
579 12/28/2020 19.42 0.1609 80 0 1553.60 249.97 1303.63
590 11/2/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
590 11/16/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
590 11/30/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
590 12/14/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
590 12/28/2020 16.88 0.3863 80 0 1350.40 521.66 828.74
599 11/2/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
599 11/16/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
599 11/30/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
599 12/14/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
599 12/28/2020 24.24 0.1696 80 0 1939.20 328.89 1610.31
608 11/2/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
608 11/16/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
608 11/30/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
608 12/14/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
608 12/28/2020 21.59 0.3619 80 0 1727.20 625.07 1102.13
613 11/2/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
613 11/16/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
613 11/30/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
613 12/14/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
613 12/28/2020 20.83 0.066 80 0 1666.40 109.98 1556.42
618 11/2/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
618 11/16/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
618 11/30/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
618 12/14/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
618 12/28/2020 13.82 0.2726 80 0 1105.60 301.39 804.21
644 11/2/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
644 11/16/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
644 11/30/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
644 12/14/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
644 12/28/2020 24.01 0.2059 80 0 1920.80 395.49 1525.31
650 11/2/2020 21.95 0.1147 80 5 1865.75 214.00 1651.75
650 11/16/2020 21.95 0.1147 80 6 1887.70 216.52 1671.18
650 11/30/2020 21.95 0.1147 80 5 1865.75 214.00 1651.75
650 12/14/2020 21.95 0.1147 80 5 1865.75 214.00 1651.75
650 12/28/2020 21.95 0.1147 80 6 1887.70 216.52 1671.18
656 11/2/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
656 11/16/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
656 11/30/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
656 12/14/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
656 12/28/2020 19.94 0.1017 80 0 1595.20 162.23 1432.97
664 11/2/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
664 11/16/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
664 11/30/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
664 12/14/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
664 12/28/2020 13.62 0.2104 80 0 1089.60 229.25 860.35
668 11/2/2020 17.91 0 80 0 1432.80 0.00 1432.80
668 11/16/2020 17.91 0 80 0 1432.80 0.00 1432.80
668 11/30/2020 17.91 0 80 0 1432.80 0.00 1432.80
668 12/14/2020 17.91 0 80 0 1432.80 0.00 1432.80
668 12/28/2020 17.91 0 80 0 1432.80 0.00 1432.80
674 11/2/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
674 11/16/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
674 11/30/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
674 12/14/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
674 12/28/2020 18.18 0.0353 80 0 1454.40 51.34 1403.06
682 11/2/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 11/2/2020 16.1 0.295 80 0 1288.00 379.96 908.04
682 11/16/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 11/16/2020 16.1 0.295 80 0 1288.00 379.96 908.04
682 11/30/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 11/30/2020 16.1 0.295 80 0 1288.00 379.96 908.04
682 12/14/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 12/14/2020 16.1 0.295 80 0 1288.00 379.96 908.04
682 12/28/2020 14.56 0.1488 80 0 1164.80 173.32 991.48
682 12/28/2020 16.1 0.295 80 0 1288.00 379.96 908.04
695 11/2/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 11/2/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 11/16/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 11/30/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 12/14/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
695 12/28/2020 15.67 0.2693 80 0 1253.60 337.59 916.01
710 11/2/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
710 11/16/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
710 11/30/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
710 12/14/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
710 12/28/2020 13.3 0.1616 80 0 1064.00 171.94 892.06
712 11/2/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
712 11/16/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
712 11/30/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
712 12/14/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
712 12/28/2020 19.92 0.3844 80 0 1593.60 612.58 981.02
715 11/2/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
715 11/16/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
715 11/30/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
715 12/14/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
715 12/28/2020 15.76 0.0237 80 0 1260.80 29.88 1230.92
719 11/2/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
719 11/16/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
719 11/30/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
719 12/14/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
719 12/28/2020 16.79 0.1646 80 0 1343.20 221.09 1122.11
748 11/2/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
748 11/16/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
748 11/30/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
748 12/14/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
748 12/28/2020 18.29 0.3631 80 0 1463.20 531.29 931.91
763 11/2/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
763 11/16/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
763 11/30/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
763 12/14/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
763 12/28/2020 23.77 0.2886 80 0 1901.60 548.80 1352.80
768 11/2/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
768 11/16/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
768 11/30/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
768 12/14/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
768 12/28/2020 17.9 0.018 80 0 1432.00 25.78 1406.22
778 11/2/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
778 11/16/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
778 11/30/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
778 12/14/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
778 12/28/2020 17.68 0.1059 80 0 1414.40 149.78 1264.62
781 11/2/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
781 11/16/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
781 11/30/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
781 12/14/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
781 12/28/2020 24.39 0.0915 80 0 1951.20 178.53 1772.67
804 11/2/2020 18.73 0.3908 80 0 1498.40 585.57 912.83
804 11/16/2020 18.73 0.3908 80 6 1610.78 629.49 981.29
804 11/30/2020 18.73 0.3908 80 0 1498.40 585.57 912.83
804 12/14/2020 18.73 0.3908 80 0 1498.40 585.57 912.83
804 12/28/2020 18.73 0.3908 80 0 1498.40 585.57 912.83
814 11/2/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
814 11/16/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
814 11/30/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
814 12/14/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
814 12/28/2020 21.27 0.1593 80 0 1701.60 271.06 1430.54
825 11/2/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
825 11/16/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
825 11/30/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
825 12/14/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
825 12/28/2020 21.6 0.3542 80 0 1728.00 612.06 1115.94
829 11/2/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
829 11/16/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
829 11/30/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
829 12/14/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
829 12/28/2020 16.22 0.2078 80 0 1297.60 269.64 1027.96
830 11/2/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
830 11/16/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
830 11/30/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
830 12/14/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
830 12/28/2020 22.93 0.2872 80 0 1834.40 526.84 1307.56
834 11/2/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
834 11/16/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
834 11/30/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
834 12/14/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
834 12/28/2020 24.98 0.1365 80 0 1998.40 272.78 1725.62
845 11/2/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
845 11/16/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
845 11/30/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
845 12/14/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
845 12/28/2020 22.91 0.3513 80 0 1832.80 643.86 1188.94
867 11/2/2020 13.52 0.1006 80 0 1081.60 108.81 972.79
867 11/16/2020 13.52 0.1006 80 0 1081.60 108.81 972.79
867 11/30/2020 13.52 0.1006 80 0<

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cornerstones of Managerial Accounting

Authors: Mowen, Hansen, Heitger

3rd Edition

324660138, 978-0324660135

More Books

Students also viewed these Accounting questions

Question

Determine miller indices of plane X z 2/3 90% a/3

Answered: 1 week ago

Question

Understand how "cause and effect" is established by experimentation

Answered: 1 week ago

Question

Learn the basic tools of psychological research

Answered: 1 week ago

Question

Why do we need scientific methods?

Answered: 1 week ago