The owner of the candy and snack manufacturing company, Boyac Tostadita S A , has asked you to investigate possible problems with the company's payroll They have given you the Income Statement for this year and the previous year and two files with payroll information The file called HR Master File contains information about each employee The file called Payroll shows in detail the payroll corresponding to 5 periods of this year You will be conducting some audit procedures for Boyac Tostadita S A and will analyze the results obtained Part 1 Review the Income Statement given to you by the owner of Boyac Tostadita S A Based on the AICPA Code of Professional Conduct prepare a 2 3 page summary of how you will proceed to address the owner's concerns and what specific steps you will take to audit this company 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 data from the payroll files, 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 Part 3 Prepare a 2 3 page analysis that discusses what you found as a result of your analysis and what internal controls you would recommend to the owner of Boyac Tostadita S A Don't forget to include in this part of the project what you developed in part 2 Boyac Tostadita S A Estado de Resultados Para el anio terminado en Diciembre 31, 2020 2019 Ventas netas (menos descuentos y devoluciones) $ 8,353,542 $ 7,998,832 Costo de las Mercancas Vendidas 3,745,623 3,621,532 Utilidad Bruta 4,607,919 4,377,300 Gastos operativos Publicidad 115,325 113,452 Gasto por Deudas Malas 65,232 62,585 Depreciacin y Amortizacin 75,210 73,565 Tarifas y Subscripciones 600 575 Seguro 60,800 60,600 Licencias y cargos 300 285 Mercadeo y Promocin 52,632 51,025 Comidas y Entretenimiento 25,030 24,345 Gastos de Oficina 14,325 14,652 Insumos de Oficina 24,003 23,458 Salarios y Sueldos 2,380,105 2,192,032 Tarifas Profesionales 39,700 38,500 Impuestos de Propiedad 19,220 19,000 Arrendamiento 85,230 84,360 Reparaciones y Mantenimiento 1,450 1,500 Envo y Entrega 770 730 Gastos de Viaje 75,830 73,560 Servicios 35,230 34,250 Arrendamiento de Equipo (Leasing) 44,000 43,750 Otros 15,320 14,756 Total Gastos Operativos 3,130,312 2,926,980 Ingreso Operativo 1,477,607 1,450,320 Gastos de Intereses 84,658 83,950 Otro Ingreso (intereses, Regalas) 5,920 5,725 Ingreso antes de Impuestos 1,398,869 1,372,095 Impuestos sobre la Renta 489,604 480,233 Ingreso Neto $ 909,265 $ 891,862 EMP ID NOMBRE APELLIDO SSN FECHA DE CONTRATACION FECHA DE TERMINACION DIRECCION POSTAL CIUDAD ESTADO 748 Juan King 9531291 8 31 2009 400 Melbourne Road San Diego CA 482 Emily Martinez 9979842 7 7 2010 110 Tudor Road San Diego CA 834 Terry Gray 9213929 4 8 2011 183 Almond Court San Diego CA 885 Phyllis Kelly 4988752 10 2 2011 10 30 2020 325 Church Road Carlsbad CA 382 Johnny Cox 4777763 6 25 2012 426 Regent Road San Diego CA 804 Kevin Williams 1301030 6 15 2013 421 The Causeway Escondido CA 373 Bruce Roberts 8959739 1 6 2014 249 Ivy Court San Diego CA 590 Frances Green 1390469 2 3 2014 411 Wharf Road San Diego CA 182 Evelyn Diaz 4701550 5 10 2014 491 Shelley Court Escondido CA 712 Martha Sanders 9320000 10 3 2014 98 Parklands Avenue Carlsbad CA 338 Amy Lewis 2267770 9 27 2015 211 Bell Drive La Mesa CA 278 Heather Miller 1817500 11 10 2016 295 Kings Road Del Mar CA 353 Charles Clark 2765340 11 18 2016 358 Sutton Road San Diego CA 330 Keith Moore 8624259 1 26 2017 68 Bramble Court San Diego CA 341 Kathryn Wood 6363057 7 15 2017 486 Preston Road San Diego CA 668 Catherine Allen 9798798 10 14 2018 160 Carr Lane Del Mar CA 431 Wayne Robinson 3572858 10 21 2018 63 Scott Court San Diego CA 212 Julie Campbell 5875948 11 15 2018 3 25 2020 232 Woodstock Road Carlsbad CA 491 Eugene Anderson 7616476 1 31 2019 492 Mill Street La Mesa CA 874 Deborah Brooks 7977825 5 15 2019 202 Windsor Street Del Mar CA 336 Brandon Nelson 6385852 6 14 2019 327 Ashley Court San Diego CA 179 Kimberly Hughes 2666315 8 2 2019 479 Orchard Road San Diego CA 217 Roger Cook 4005884 8 18 2019 236 Rectory Lane San Diego CA 962 Ralph Rodriguez 4129921 1 16 2020 73 Water Lane Carlsbad CA 381 Joshua Jenkins 9198893 6 7 2020 446 Warwick Court Escondido CA 778 Sarah Wilson 3020458 2 21 2008 141 Market Square Escondido CA 407 Alice Torres 9277267 6 7 2008 508 Kenilworth Road San Diego CA 162 Aaron Bryant 1433932 8 31 2008 449 Middle Road San Diego CA 644 Chris Turner 7620138 9 14 2008 275 Grasmere Road San Diego CA 476 Marilyn Johnson 1531344 3 9 2009 473 Park Avenue San Diego CA 710 Gerald Harris 7237065 9 24 2009 253 Norfolk Road Carlsbad CA 319 Debra Peterson 4145637 10 6 2010 258 Crown Street San Diego CA 608 Gregory White 7206123 10 27 2010 401 Vicarage Gardens Escondido CA 357 Howard Price 8204814 1 21 2011 487 Spring Gardens San Diego CA 613 Jerry Ross 7916621 7 6 2011 469 Central Avenue San Diego CA 867 Jessica Henderson 5340544 8 2 2012 208 Harrow Road La Mesa CA 682 Stephanie Sanchez 2025855 10 18 2012 493 Oaklands Drive La Mesa CA 368 Ashley Thomas 5946416 11 14 2013 427 Derwent Avenue Escondido CA 520 Ruth Russell 2640169 8 10 2014 441 Maltings Drive San Diego CA 781 Diana Watson 4645210 8 14 2014 177 Swan Court Carlsbad CA 277 Jimmy Long 9890118 10 8 2014 158 Scott Street Coronado CA 425 Carolyn Bell 8861807 10 18 2015 259 Church Drive Coronado CA 525 Diane Alexander 2711538 1 29 2016 270 Spencer Court San Diego CA 954 Todd Wright 2384281 2 24 2018 465 Coach Road Carlsbad CA 429 Betty Simmons 6314000 3 4 2018 375 East Avenue Escondido CA 964 Justin Scott 6240548 12 6 2018 207 Cumberland Road La Mesa CA 830 Tammy Patterson 1835662 7 5 2019 25 Lodge Court Julian CA 878 Nancy Jackson 2609168 12 29 2019 49 Victoria Place Julian CA 255 Bobby Adams 9524883 8 6 2020 199 Sandown Road La Mesa CA 407 Stephen Howard 4166129 10 11 2020 201 Laurel Drive La Mesa CA 825 Victor Perez 6024868 1 2 2008 260 Blind Lane San Diego CA 565 Jason Barnes 5912329 7 14 2008 396 Orchard Court San Diego CA 920 Brenda Price 7172214 10 20 2008 46 Back Street Coronado CA 576 Ernest Edwards 6466244 10 26 2008 482 Holly Lane Carlsbad CA 352 Katherine Powell 1865397 7 21 2011 412 Farm Court San Diego CA 191 Paul Rivera 6383078 2 12 2012 5 25 2020 481 Norton Road San Diego CA 531 Judith Mitchell 1305389 3 12 2012 151 Portland Street La Mesa CA 378 Robert Smith 9328577 9 17 2012 155 Cobden Street San Diego CA 599 Louis Lee 9550439 3 2 2013 276 Forest Road Coronado CA 441 Marie Young 8424636 7 8 2013 186 Hillside Street Escondido CA 522 Benjamin Lopez 6600039 1 11 2014 299 Yew Tree Court Julian CA 951 Maria Parker 8886787 5 3 2014 385 Common Road San Diego CA 149 Ruby Baker 2505994 5 17 2015 426 Regent Road San Diego CA 845 William James 3528600 7 10 2015 415 Laburnum Road Carlsbad CA 989 Philip Ramirez 7646250 8 6 2015 380 Wood Lane San Diego CA 682 Shawn Evans 8690462 9 16 2015 399 Hollies Drive San Diego CA 463 Anna Washington 5759326 11 13 2015 343 Edinburgh Road Escondido CA 763 Russell Brown 6004611 8 13 2016 509 Mill Court Julian CA 377 Joyce Morris 9258802 11 11 2016 286 Shore Road San Diego CA 989 Ryan Cooper 6143855 4 30 2017 156 Avondale Road San Diego CA 719 Gary Gonzales 7158334 6 15 2017 268 Orchard Street Escondido CA 384 Cynthia Hernandez 8752411 5 5 2018 368 Larch Court Carlsbad CA 388 Jean Ward 3976025 6 16 2018 267 Brook Lane Julian CA 117 Janice Martin 2190864 12 21 2019 31 St John's Court La Mesa CA 674 Randy Bennett 7993970 1 3 2020 127 Crown Lane San Diego CA 396 Kathleen Hall 1612091 3 13 2008 6 3 2020 104 Cotswold Court San Diego CA 996 Jesse Bailey 4516456 3 22 2009 424 West Avenue San Diego CA 814 Billy Stewart 5538360 6 18 2009 273 Herbert Road San Diego CA 656 Craig Richardson 8243780 5 16 2010 291 Elm Street Coronado CA 269 Matthew Thompson 4483030 6 15 2011 298 Milton Avenue San Diego CA 695 Barbara Murphy 9277267 6 24 2012 102 Cross Road Carlsbad CA 213 Earl Foster 8571657 8 27 2012 294 St John's Street Escondido CA 922 Elizabeth Gonzalez 5520772 12 17 2012 83 Grove Drive San Diego CA 238 Carol Davis 4688829 4 4 2014 518 Nursery Road La Mesa CA 549 Carl Phillips 6564518 10 22 2014 448 Meadow View Lane San Diego CA 618 Peter Morgan 5424756 9 4 2015 136 Spencer Road San Diego CA 217 Joe Garcia 199442 6 10 2016 476 South Drive Julian CA 247 Harry Carter 288812 7 2 2016 371 Manor Park Escondido CA 664 Michelle Griffin 7005653 9 19 2016 418 Grove Road San Diego CA 459 Walter Reed 8037668 1 23 2017 390 Windsor Drive San Diego CA 492 Margaret Hill 584101 3 26 2017 311 Hornbeam Court Julian CA 768 Douglas Perry 267456 8 24 2017 197 Fore Street La Mesa CA 829 Tina Flores 9271431 10 8 2017 191 Swift Court San Diego CA 650 Lois Coleman 9793192 5 23 2018 185 Paddock Lane San Diego CA 333 Nicole Collins 2443384 11 3 2018 7 21 2020 27 Orchid Court Del Mar CA 715 Scott Butler 4285940 4 3 2019 440 Court Road San Diego CA 579 Virginia Walker 5937630 4 18 2019 237 Park Road San Diego CA 895 Irene Jones 3468043 4 20 2019 271 Clarence Road Del Mar CA 575 Lisa Taylor 2700234 6 30 2019 398 Queens Drive Escondido CA 510 Andrea Carter 8777163 1 24 2020 485 Paddock Court Del Mar CA 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 193

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 25, 2024

The owner of the candy and snack manufacturing company, Boyac Tostadita S.A., has asked you to investigate possible problems with the company's payroll. They have

The owner of the candy and snack manufacturing company, Boyac Tostadita S.A., has asked you to investigate possible problems with the company's payroll. They have given you the Income Statement for this year and the previous year and two files with payroll information. The file called "HR Master File" contains information about each employee. The file called "Payroll" shows in detail the payroll corresponding to 5 periods of this year. You will be conducting some audit procedures for Boyac Tostadita S.A. and will analyze the results obtained.

Part 1 - Review the Income Statement given to you by the owner of Boyac Tostadita S.A. Based on the AICPA Code of Professional Conduct prepare a 2-3 page summary of how you will proceed to address the owner's concerns and what specific steps you will take to audit this company.

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 data from the payroll files, 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.

Part 3 - Prepare a 2-3 page analysis that discusses what you found as a result of your analysis and what internal controls you would recommend to the owner of Boyac Tostadita S.A. Don't forget to include in this part of the project what you developed in part 2.

Boyac Tostadita S.A.
Estado de Resultados

Para el anio terminado en Diciembre 31,		2020	2019

Ventas netas (menos descuentos y devoluciones)	$ 8,353,542	$ 7,998,832
Costo de las Mercancas Vendidas		3,745,623	3,621,532
Utilidad Bruta				4,607,919	4,377,300
Gastos operativos:
Publicidad				115,325	113,452
Gasto por Deudas Malas			65,232	62,585
Depreciacin y Amortizacin		75,210	73,565
Tarifas y Subscripciones			600	575
Seguro					60,800	60,600
Licencias y cargos				300	285
Mercadeo y Promocin			52,632	51,025
Comidas y Entretenimiento			25,030	24,345
Gastos de Oficina				14,325	14,652
Insumos de Oficina			24,003	23,458
Salarios y Sueldos			2,380,105	2,192,032
Tarifas Profesionales			39,700	38,500
Impuestos de Propiedad			19,220	19,000
Arrendamiento				85,230	84,360
Reparaciones y Mantenimiento		1,450	1,500
Envo y Entrega				770	730
Gastos de Viaje				75,830	73,560
Servicios				35,230	34,250
Arrendamiento de Equipo (Leasing)		44,000	43,750
Otros					15,320	14,756
Total Gastos Operativos			3,130,312	2,926,980
Ingreso Operativo				1,477,607	1,450,320
Gastos de Intereses				84,658	83,950
Otro Ingreso (intereses, Regalas)		5,920	5,725
Ingreso antes de Impuestos			1,398,869	1,372,095
Impuestos sobre la Renta			489,604	480,233
Ingreso Neto				$ 909,265	$ 891,862

EMP_ID	NOMBRE	APELLIDO	SSN	FECHA DE CONTRATACION	FECHA DE TERMINACION	DIRECCION POSTAL	CIUDAD	ESTADO
748	Juan	King	9531291	8/31/2009		400 Melbourne Road	San Diego	CA
482	Emily	Martinez	9979842	7/7/2010		110 Tudor Road	San Diego	CA
834	Terry	Gray	9213929	4/8/2011		183 Almond Court	San Diego	CA
885	Phyllis	Kelly	4988752	10/2/2011	10/30/2020	325 Church Road	Carlsbad	CA
382	Johnny	Cox	4777763	6/25/2012		426 Regent Road	San Diego	CA
804	Kevin	Williams	1301030	6/15/2013		421 The Causeway	Escondido	CA
373	Bruce	Roberts	8959739	1/6/2014		249 Ivy Court	San Diego	CA
590	Frances	Green	1390469	2/3/2014		411 Wharf Road	San Diego	CA
182	Evelyn	Diaz	4701550	5/10/2014		491 Shelley Court	Escondido	CA
712	Martha	Sanders	9320000	10/3/2014		98 Parklands Avenue	Carlsbad	CA
338	Amy	Lewis	2267770	9/27/2015		211 Bell Drive	La Mesa	CA
278	Heather	Miller	1817500	11/10/2016		295 Kings Road	Del Mar	CA
353	Charles	Clark	2765340	11/18/2016		358 Sutton Road	San Diego	CA
330	Keith	Moore	8624259	1/26/2017		68 Bramble Court	San Diego	CA
341	Kathryn	Wood	6363057	7/15/2017		486 Preston Road	San Diego	CA
668	Catherine	Allen	9798798	10/14/2018		160 Carr Lane	Del Mar	CA
431	Wayne	Robinson	3572858	10/21/2018		63 Scott Court	San Diego	CA
212	Julie	Campbell	5875948	11/15/2018	3/25/2020	232 Woodstock Road	Carlsbad	CA
491	Eugene	Anderson	7616476	1/31/2019		492 Mill Street	La Mesa	CA
874	Deborah	Brooks	7977825	5/15/2019		202 Windsor Street	Del Mar	CA
336	Brandon	Nelson	6385852	6/14/2019		327 Ashley Court	San Diego	CA
179	Kimberly	Hughes	2666315	8/2/2019		479 Orchard Road	San Diego	CA
217	Roger	Cook	4005884	8/18/2019		236 Rectory Lane	San Diego	CA
962	Ralph	Rodriguez	4129921	1/16/2020		73 Water Lane	Carlsbad	CA
381	Joshua	Jenkins	9198893	6/7/2020		446 Warwick Court	Escondido	CA
778	Sarah	Wilson	3020458	2/21/2008		141 Market Square	Escondido	CA
407	Alice	Torres	9277267	6/7/2008		508 Kenilworth Road	San Diego	CA
162	Aaron	Bryant	1433932	8/31/2008		449 Middle Road	San Diego	CA
644	Chris	Turner	7620138	9/14/2008		275 Grasmere Road	San Diego	CA
476	Marilyn	Johnson	1531344	3/9/2009		473 Park Avenue	San Diego	CA
710	Gerald	Harris	7237065	9/24/2009		253 Norfolk Road	Carlsbad	CA
319	Debra	Peterson	4145637	10/6/2010		258 Crown Street	San Diego	CA
608	Gregory	White	7206123	10/27/2010		401 Vicarage Gardens	Escondido	CA
357	Howard	Price	8204814	1/21/2011		487 Spring Gardens	San Diego	CA
613	Jerry	Ross	7916621	7/6/2011		469 Central Avenue	San Diego	CA
867	Jessica	Henderson	5340544	8/2/2012		208 Harrow Road	La Mesa	CA
682	Stephanie	Sanchez	2025855	10/18/2012		493 Oaklands Drive	La Mesa	CA
368	Ashley	Thomas	5946416	11/14/2013		427 Derwent Avenue	Escondido	CA
520	Ruth	Russell	2640169	8/10/2014		441 Maltings Drive	San Diego	CA
781	Diana	Watson	4645210	8/14/2014		177 Swan Court	Carlsbad	CA
277	Jimmy	Long	9890118	10/8/2014		158 Scott Street	Coronado	CA
425	Carolyn	Bell	8861807	10/18/2015		259 Church Drive	Coronado	CA
525	Diane	Alexander	2711538	1/29/2016		270 Spencer Court	San Diego	CA
954	Todd	Wright	2384281	2/24/2018		465 Coach Road	Carlsbad	CA
429	Betty	Simmons	6314000	3/4/2018		375 East Avenue	Escondido	CA
964	Justin	Scott	6240548	12/6/2018		207 Cumberland Road	La Mesa	CA
830	Tammy	Patterson	1835662	7/5/2019		25 Lodge Court	Julian	CA
878	Nancy	Jackson	2609168	12/29/2019		49 Victoria Place	Julian	CA
255	Bobby	Adams	9524883	8/6/2020		199 Sandown Road	La Mesa	CA
407	Stephen	Howard	4166129	10/11/2020		201 Laurel Drive	La Mesa	CA
825	Victor	Perez	6024868	1/2/2008		260 Blind Lane	San Diego	CA
565	Jason	Barnes	5912329	7/14/2008		396 Orchard Court	San Diego	CA
920	Brenda	Price	7172214	10/20/2008		46 Back Street	Coronado	CA
576	Ernest	Edwards	6466244	10/26/2008		482 Holly Lane	Carlsbad	CA
352	Katherine	Powell	1865397	7/21/2011		412 Farm Court	San Diego	CA
191	Paul	Rivera	6383078	2/12/2012	5/25/2020	481 Norton Road	San Diego	CA
531	Judith	Mitchell	1305389	3/12/2012		151 Portland Street	La Mesa	CA
378	Robert	Smith	9328577	9/17/2012		155 Cobden Street	San Diego	CA
599	Louis	Lee	9550439	3/2/2013		276 Forest Road	Coronado	CA
441	Marie	Young	8424636	7/8/2013		186 Hillside Street	Escondido	CA
522	Benjamin	Lopez	6600039	1/11/2014		299 Yew Tree Court	Julian	CA
951	Maria	Parker	8886787	5/3/2014		385 Common Road	San Diego	CA
149	Ruby	Baker	2505994	5/17/2015		426 Regent Road	San Diego	CA
845	William	James	3528600	7/10/2015		415 Laburnum Road	Carlsbad	CA
989	Philip	Ramirez	7646250	8/6/2015		380 Wood Lane	San Diego	CA
682	Shawn	Evans	8690462	9/16/2015		399 Hollies Drive	San Diego	CA
463	Anna	Washington	5759326	11/13/2015		343 Edinburgh Road	Escondido	CA
763	Russell	Brown	6004611	8/13/2016		509 Mill Court	Julian	CA
377	Joyce	Morris	9258802	11/11/2016		286 Shore Road	San Diego	CA
989	Ryan	Cooper	6143855	4/30/2017		156 Avondale Road	San Diego	CA
719	Gary	Gonzales	7158334	6/15/2017		268 Orchard Street	Escondido	CA
384	Cynthia	Hernandez	8752411	5/5/2018		368 Larch Court	Carlsbad	CA
388	Jean	Ward	3976025	6/16/2018		267 Brook Lane	Julian	CA
117	Janice	Martin	2190864	12/21/2019		31 St John's Court	La Mesa	CA
674	Randy	Bennett	7993970	1/3/2020		127 Crown Lane	San Diego	CA
396	Kathleen	Hall	1612091	3/13/2008	6/3/2020	104 Cotswold Court	San Diego	CA
996	Jesse	Bailey	4516456	3/22/2009		424 West Avenue	San Diego	CA
814	Billy	Stewart	5538360	6/18/2009		273 Herbert Road	San Diego	CA
656	Craig	Richardson	8243780	5/16/2010		291 Elm Street	Coronado	CA
269	Matthew	Thompson	4483030	6/15/2011		298 Milton Avenue	San Diego	CA
695	Barbara	Murphy	9277267	6/24/2012		102 Cross Road	Carlsbad	CA
213	Earl	Foster	8571657	8/27/2012		294 St John's Street	Escondido	CA
922	Elizabeth	Gonzalez	5520772	12/17/2012		83 Grove Drive	San Diego	CA
238	Carol	Davis	4688829	4/4/2014		518 Nursery Road	La Mesa	CA
549	Carl	Phillips	6564518	10/22/2014		448 Meadow View Lane	San Diego	CA
618	Peter	Morgan	5424756	9/4/2015		136 Spencer Road	San Diego	CA
217	Joe	Garcia	199442	6/10/2016		476 South Drive	Julian	CA
247	Harry	Carter	288812	7/2/2016		371 Manor Park	Escondido	CA
664	Michelle	Griffin	7005653	9/19/2016		418 Grove Road	San Diego	CA
459	Walter	Reed	8037668	1/23/2017		390 Windsor Drive	San Diego	CA
492	Margaret	Hill	584101	3/26/2017		311 Hornbeam Court	Julian	CA
768	Douglas	Perry	267456	8/24/2017		197 Fore Street	La Mesa	CA
829	Tina	Flores	9271431	10/8/2017		191 Swift Court	San Diego	CA
650	Lois	Coleman	9793192	5/23/2018		185 Paddock Lane	San Diego	CA
333	Nicole	Collins	2443384	11/3/2018	7/21/2020	27 Orchid Court	Del Mar	CA
715	Scott	Butler	4285940	4/3/2019		440 Court Road	San Diego	CA
579	Virginia	Walker	5937630	4/18/2019		237 Park Road	San Diego	CA
895	Irene	Jones	3468043	4/20/2019		271 Clarence Road	Del Mar	CA
575	Lisa	Taylor	2700234	6/30/2019		398 Queens Drive	Escondido	CA
510	Andrea	Carter	8777163	1/24/2020		485 Paddock Court	Del Mar	CA

Question

The owner of the candy and snack manufacturing company, Boyac Tostadita S.A., has asked you to investigate possible problems with the company's payroll. They have

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Introductory Financial Accounting For Business

Students also viewed these Accounting questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

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	193 Step by Step Solution There are 3 Steps involved in it Step: 1 Get Instant Access to Expert-Tailored Solutions See step-by-step solutions with expert insights and AI powered tools for academic success Step: 2 Step: 3 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 Introductory Financial Accounting For Business Authors: Thomas Edmonds, Christopher Edmonds, Mark Edmonds, Jennifer Edmonds, Philip Olds 2nd Edition 1260575306, 978-1260575309 More Books Students also viewed these Accounting questions Question ★★★★★ Information taken from Giles Corporation's May accounting records follows. Required: Direct materials used.......................................$150,000 Direct... Answered: 1 week ago Question ★★★★★ As discussed in the Management Representation Letter section of this chapter, Section 302 of SOX requires the CEO and CFO of public companies to sign a certification statement when the financial... Answered: 1 week ago Question ★★★★★ =+a) Fit the linear model from Exercise 40 to this entire time period. Answered: 1 week ago Question ★★★★★ Under IAS 39, the IASB financial instrument standard in effect at the time, loans receivable were valued at amortized cost. That is, valuation was based on expected future receipts from the loan... Answered: 1 week ago Question ★★★★★ Which one of the following statements concerning NASDAQ is correct? The NASDAQ Capital Market has the most stringent listing requirements of any of the NASDAQ companies. NASDAQ is actually comprised... Answered: 1 week ago Question ★★★★★ A company purchases a 6,072-square-foot building for $450,000. The building has two separate rental units, Unit A, which has the desirable location on the corner and contains 792 square feet, will be... Answered: 1 week ago Question ★★★★★ Which of the following statements regarding the completed contract method is NOT true? a) The company makes different entries to recognize revenue than under percentage-of-completion method. b) The... Answered: 1 week ago Question ★★★★★ 4. Mr. Buyer bought a car from Mr. Seller, a dealer of cars under the following terms: (1) down payment of P500,000; (ii) entire balance is to be paid on December 24, 2004; (iii) a chattel mortgage... Answered: 1 week ago Question ★★★★★ 00:19:58 Question #15 of 25 Qu A client who is primarily concerned that inflation might erode the purchasing power of his annuity income would NOT be a good candidate for ik NR han Pleas such surrel... Answered: 1 week ago Question ★★★★★ Post the following February journal entries to the general ledger and calculate the ending balances using the T accounts provided. (Post entries in the order displayed in the problem statement.) Feb.... Answered: 1 week ago Question ★★★★★ Jean-Paul has invested in 1,000 shares of the H.A.L. Computer Corporation. The shares were selling at $60 each when the company announced a 3-for-1 stock split. What is the value of Jean-Paul's... Answered: 1 week ago Question ★★★★★ What strategies can HR leaders employ to foster a culture of continuous learning and skill development in response to the accelerating pace of technological change ? Answered: 1 week ago Question ★★★★★ Values: What is important to me? Answered: 1 week ago Question ★★★★★ Purpose: What do we seek to achieve with our behaviour? Answered: 1 week ago Previous Question Next Question View Answer in SolutionInn App Services Sitemap Fun Definitions Become Tutor Study Help Categories Recent Questions Expert Questions Company Info Security Copyrights Privacy Policy Terms & Conditions SolutionInn Fee Scholarship Get In Touch About Us Contact Us Career Jobs FAQ Campus Ambassador Secure Payment Download Our App © 2024 SolutionInn. All Rights Reserved