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< Posted Date: May 18, 2024 10:15 AM See More Questions Students also viewed these accounting questions Adam Kleen Enterprise (AKE) was initially set up as a convenient shop selling laundry related items by Adam Bollan. Despite having good results in the national-level examination and was even offered... Prepare the journal entries that the lessee should make to record the following transactions. 1. The lessee makes a lease payment of $80,000 to the lessor in an operating lease transaction. 2. Zander... The data shown in Table 6E.2 are x and R values for 24 samples of size n = 5 taken from a process producing bearings. The measurements are made on the inside diameter of the bearing, with only the... What information is presented in a statement of retained earnings? What information is presented in a statement of stockholders' equity? Zimmermans Bank is the only bank in the small town of St. Thomas. On a typical Friday, an average of 10 customers per hour arrives at the bank to transact business. There is one teller at the bank,... On your motorcycle program, you and your team are actively tracking the benefits identified in your benefit realization plan. You found, though, that employee satisfaction, which was in the first... Manufacturing costs for Davenport Company during 2018 were as follows: Beginning Finished Goods, January 1 Beginning Raw Materials, January 1 Beginning Work in Process, January 1 Direct Labor for the... Direct materials Fixed manufacturing overhead costs Sales price Variable manufacturing overhead Direct labor Fixed marketing and administrative costs Units produced and sold during the quarter... Suppose two children push horizontally, but in exactly opposite directions, on a third child in a sled. The first child exerts a force of 74 N, the second a force of 99 N, kinetic friction is 7.5 N,... What is community psychology (CP)? From the reading Welcome to Psychology 2e , an OpenStax in what ways do you have a better understanding of psychology? give examples and cite from the text Roberta Bondar is travelling in her space craft around a distant planet. The planet has a radius R' and she is at an altitude of 2R' above its surface, coasting at some constant speed in a circular... Which of the following are false concerning the hybridization of atomic orbitais and bonding found in carbon structures? O It accounts for the number of sigma bonds found in carbon structures. O More... A sample statistic will not change from sample to sample. Determine whether the statement is true or false. If it is false, rewrite it as a true statement. The Salsbury Company purchased equipment costing \($10.000\) at the start of the year. The equip- ment has an estimated useful life of five years and a salvage value of \($2.000\) The CEO is unsure... The Jones Company is self-insured, and consequently the company does not receive any insurance payments if it is involved in an accident. One of the Jones Company trucks was involved in a major... Hastings Company recorded the following expenditures during the year with regard to its delivery van: 1. Changed the engine oil 2. Repainted the van 3. Overhauled the engine that is expected to... Previous Question Next Question Financial Accounting The Cornerstone Of Business Decisions 2nd International Edition - ISBN: 0538473207 - Free Book Study smarter with the SolutionInn App Get In Touch About Us Contact Us Career Jobs FAQ Campus Ambassador Company Info Security Copyrights Privacy Policy Terms & Condition SolutionInn Fee Scholarship Services Sitemap Fun Definitions Become Tutor Study Help Categories Recent Questions Expert Questions Copyright © 2024 SolutionInn All Rights Reserved. Get the SolutionInn - Study Help App