Visualize the data with Tableau

profileDtrinh22
4-Data-Analytics-ToyCase-Data1.xlsx
Home>Business & Finance homework help>Accounting homework help>Visualize the data with Tableau

Customer

Customer ID Customer Name Customer Address Customer City Customer State Customer Zip Sales Rep
386423 Big Mart 56 Hanover Dr Boston MA 02115 gray74
686236 Mastro Toys 12 2nd St New York NY 10022 gray74
874239 Toy Town 350 Hazel Ave Atlanta GA 31324 tanderson
469752 Toronto Toy Land 4 Main St Minneapolis MN 55416 mflemming17
456987 UniMart 12 State St Newark NJ 07191 gray74
123765 Marco's Games and Things 156 King's Path San Diego CA 92071 gutierrez39
835679 Tao's Toys 89 George Way Wilmington DE 19806 gray74
783674 Mega Mart 3200 N Charles St Baltimore MD 21218 anderson21
456785 All Brands Toys 22 E Broad St Cleveland OH 44127 fleming82
237542 Davidson's Toy House 37 Franklin Dr Cincinnati OH 45217 gray74
679346 House of Games 45 Denow Rd Chicago IL 60611 anderson21
666331 We Be Toys 346 E 22nd St New York NY 10020 gray74
969873 Dysart's Dolls 78 Richard's Way Cincinnati OH 45216 fleming82
127057 Toy Express 67 Johnston St Boston MA 02115 gray74
670632 The Little Shop 109 Florence Dr Atlanta GA 31327 anderson21
789573 Toy Adventure 134 Falls Rd Newark NJ 07195 gray74
467985 Big Box Store 45 Cold Spring Ave Baltimore MD 21210 anderson21
346967 Toy Haven 123 Holly Rd San Diego CA 92108 gutierrez39
236098 The Toy Barn 43 Chance Rd Los Angelas CA 90001 gutierrez39
368752 Camille's Toy Shoppe 59 Duggins Ave Wilmington DE 19899 gray74
508624 Games and Things 273 W Holly Ave Minneapolis MN 55416 fleming82
598734 The Toy Shop 1200 34th St Buffalo NY 14214 gray74
689534 Haley's Toys 705 Ferry Way Chicago IL 60611 anderson21
698236 Griffin's Toy Emporium 506 Victor Rd Los Angelas CA 90022 gutierrez39
650780 Carter Toys 654 Park Place Dover DE 19901 anderson21
522148 Parker Toys 74 Pine Street Denver CO 80201 gutierrez39
110121 Washington Ave. Toys 1001 Washington Ave Sacramento CA 94203 gutierrez39
540805 Dogwood Toys 782 Dogwood Ln Hartford CT 06101 gray74
662541 Toys Unlimited 358 Oak St Chicago IL 60601 fleming82
650470 Games and Things 223 Mabel St Phoenix AZ 85001 fleming82
980672 Toys and More 246 Magee St Beverly Hills CA 90209 gray74
882204 We Be Toys 5440 Hillcrest Ave Miami FL 33124 gutierrez39
650480 Fun Stop 21 Cumberland Ave Pensacola FL 32501 smith75
998450 Toys for Less 132 Main St Atlanta GA 30301 jones13
320508 Big Box Store 230 Right Ave Honolulu HI 96801 adams75
554045 Mike's 120 Browne St Davenport IA 52801 green24
665048 Toys for You 902 Shaw St New Orleans LA 70112 guo10
780754 Fun and Games 109 Galbreath Rd Coldwater MI 49036 gao24
907806 RTY Toys 316 Ferguson Ave Baltimore MD 21201 cortez55
413404 Mega Mart 8 Berlin Rd St Louis MO 63101 rodriguez74
155332 Games and Things 897 Russell Ave Reno NV 89501 ribeiro22
650054 Big Box Store 78 Dean Dr Walhalla ND 58282 alves20
900751 Mello Toys 932 Decker Dr Cleveland OH 44179 allison29
711928 Big Box Store 701 Crowe St Portland OR 97201 davidson20
741981 All Toys 875 Main St Logan UT 84323 gutierrez39
402608 Rita's Toys 57 First St Bellevue WA 98009 gutierrez39
756247 Super Mart 2900 Boyles St Pinedale WY 82941 gutierrez39
207316 Mega Mart 12 Boyer Ln Beaver WV 25813 smith75
342951 Arnold's Fun Factory 129 Boak St Newport RI 02840 jones13
697377 Fun Factory 1204 Maple Rd Santa Fe NM 87500 adams75
877766 Andrew's Toys 803 Ash St Indianapolis IN 46201 gutierrez39
531968 Toy Shop 190 Pine Ln Chicago IL 60601 guo10
162033 We Be Toys 1988 Barnes Dr Boston MA 02115 jones13
299808 Games and Things 103 Baker St New York NY 10022 jones13
844070 Toys and More 183 Allen St Chicago IL 60611 rodriguez74
262625 Super Mart 594 Apple Rd New York NY 10020 ribeiro22
734057 Smith and Company 1930 Abbey Ln Cincinnati OH 45216 alves20
426276 Boston Toys 120 Acre Rd Boston MA 02115 jones13
369148 Taylor's 124 Albert St Atlanta GA 31327 davidson20
761623 Games and Things 685 Harrison St Newark NJ 07195 smith75
464026 We Be Toys 86 Highland St Cleveland OH 44127 jones13
293068 Toys and More 2309 Hill Ave Cincinnati OH 45217 jones13
166091 Taylor's 129 Highview Way Newark NJ 07191 green24
460542 Extravent Toys 287 Kildoo Rd San Diego CA 92071 guo10
670619 Toys For You 192 King Ave Wilmington DE 19806 gao24
322237 Dover Toys 111 Leon Dr Dover DE 19901 cortez55
212009 Toys and More 133 Loraine St New York NY 10020 rodriguez74
363629 The Toy Shoppe 23 Moyer St Hartford CT 06101 ribeiro22
313274 Maxwell's Toy Store 1390 Moore St Atlanta GA 31324 jones13
150613 Big Box Store 2822 Morris Ave Minneapolis MN 55416 allison29
171210 Big Box Store 10 Jackson Rd El Paso TX 79936 davidson20
381482 Superstore 79 Liberty St Norwalk CA 90650 ribeiro22
588468 Super Mart 92 Mill St Houston TX 77084 ribeiro22
737362 All Toys 321 Vine St Baltimore MD 21218 jones13
558621 Game Place 99 Walnut Ln Lakewood NJ 08701 green24
496947 Big Box Store 112 Wayne St Nashville TN 23711 guo10
348953 Rachel's Toy Spot 10 Jefferson St San Diego CA 92154 gao24
644503 We Be Toys 190 Mercer St Alburquerque NM 87121 cortez55
299769 Games and Things 58 Nearwood Dr Anchorage AK 99501 rodriguez74
936655 Mega Mart 7 Forrest Rd Sacramento CA 94203 smith75
810513 Superstore 273 Round St Littleton CO 80120 jones13
412359 Toys and More 22 Scott Rd Orlando FL 32801 adams75
853235 Games and Things 109 National Ln Montpelier ID 83254 gutierrez39
664231 Game Place 290 Oak Way Springfield IL 62701 jones13
713577 All Toys 19 Painter St Des Moines IA 50301 jones13
423429 Mega Mart 2109 Park Rd Hazard KY 41701 jones13
215881 Toys and More 183 Patterson Way Duluth MN 55801 mflemming17
997332 Games and Things 19 Main St St Louis MO 63101 smith75
304862 All Toys 173 Hoyt Ave Cleveland OH 44101 gray74
733090 Toys and More 182 Parkwood Ave Logan UT 84321 smith75
625513 All Toys 112 Pearson St Milwaukee WI 53201 gray74
222550 Super Mart 1029 Pine Dr Pinedale WY 82941 gray74
803403 We Be Toys 343 Pleasentview Dr Livingston NJ 07039 tanderson
196586 Toys and More 10 Plum Rd Aberdeen SD 57401 mflemming17
794696 Fran's Toys 342 Point Rd Pittsburgh PA 15201 gray74
742393 Super Mart 193 Ridge St Oxford NC 27565 gutierrez39
958925 Games and Things 210 Riverrun Rd Ashland NH 03217 gray74
699058 Mega Mart 109 Ridgeview St Tulsa OK 74101 anderson21
643323 We Be Toys 18 Rosewood Rd Pittsburgh PA 15201 gray74
294782 Big Box Store 109 Cascade Dr Laurel MT 59044 anderson21

Note: this data was created for use in this case study and is completely fictional. Any resemblance to an existing company / corporation is purely coincidental.

Employee

Employee ID User ID Employee Name Hire Date Termination Date Work Location Job Title Medical Plan Medical Start Date Savings Plan Savings Start Date Approval Level Salary Amount Hourly Amount Type Pay Frequency Bonus
728212 anderson21 Anderson 7/18/12 N/A 100 Sales Representative D 10/16/12 D 9/16/12 $ 70,000 Salary 1st and 15th 10%
530855 baker50 Baker 2/8/05 N/A 100 Human Resources Director C 5/9/05 B 4/9/05 $ 140,000 Salary 1st and 15th 20%
818434 gosselin09 Gosselin 3/23/15 N/A 100 Accountant B 6/21/15 A 5/22/15 $ 80,000 Salary 1st and 15th no
411738 huang96 Huáng 9/6/10 N/A 100 Chief Operating Officer E 12/5/10 B 11/5/10 $ 350,000 Salary 1st and 15th 20%
443504 jenson68 Jenson 5/6/12 N/A 100 Executive Assistant B 8/4/12 C 7/5/12 $17 Hourly bi-weekly no
988985 martin69 Martin 9/12/13 N/A 100 Chief Executive Officer E 12/11/13 B 11/11/13 $ 370,000 Salary 1st and 15th 20%
140951 peacock91 Peacock 12/6/16 N/A 100 Chief Financial Officer E 3/6/17 A 2/4/17 $ 300,000 Salary 1st and 15th 20%
364970 torres69 Torres 4/8/11 N/A 100 Human Resources Associate C 7/7/11 D 6/7/11 $ 60,000 Salary 1st and 15th no
207549 zeng86 Zēng 5/25/10 N/A 100 VP of Marketing E 8/23/10 C 7/24/10 $ 180,000 Salary 1st and 15th 20%
214711 zheng79 Zhèng 2/6/02 N/A 100 VP of Sales D 5/7/02 A 4/7/02 $ 210,000 Salary 1st and 15th 20%
737865 zhu36 Zhū 9/27/08 N/A 100 Marketing Director D 12/26/08 A 11/26/08 $ 160,000 Salary 1st and 15th 20%
902531 smith75 Smith 1/19/15 N/A 100 Sales Representative E 4/19/15 B 3/20/15 $ 75,000 Salary 1st and 15th 10%
859684 jones13 Jones 5/19/17 N/A 100 Sales Representative D 8/17/17 E 7/18/17 $ 80,000 Salary 1st and 15th 10%
436069 roberts25 Roberts 4/25/16 N/A 100 Accountant D 7/24/16 C 6/24/16 $ 80,000 Salary 1st and 15th no
421536 arnold79 Arnold 7/8/09 N/A 100 Accountant A 10/6/09 C 9/6/09 $ 80,000 Salary 1st and 15th no
919592 feng42 Féng 5/6/16 N/A 200 Accountant A 8/4/16 B 7/5/16 $ 80,000 Salary 1st and 15th no
468109 gutierrez39 Gutierrez 7/18/03 N/A 200 Sales Representative D 10/16/03 D 9/16/03 $ 70,000 Salary 1st and 15th 10%
928211 masterson50 Masterson 1/21/14 N/A 200 Line Operator E 4/21/14 D 3/22/14 $12 Hourly bi-weekly no
202964 nadeau85 Nadeau 2/16/10 N/A 200 Maintenance Specialist B 5/17/10 C 4/17/10 $ 85,000 Salary 1st and 15th no
928300 smith22 Smith 1/25/13 N/A 200 Line Operator E 4/25/13 D 3/26/13 $12 Hourly bi-weekly no
734850 johnson25 Johnson 3/15/11 N/A 200 Line Operator A 6/13/11 D 5/14/11 $12 Hourly bi-weekly no
442007 brown58 Brown 3/8/14 N/A 200 Line Operator C 6/6/14 D 5/7/14 $17 Hourly bi-weekly no
516529 williams52 Williams 6/5/10 N/A 200 Line Operator D 9/3/10 C 8/4/10 $14 Hourly bi-weekly no
489483 martin20 Martin 4/5/15 N/A 200 Line Operator E 7/4/15 E 6/4/15 $13 Hourly bi-weekly no
562104 wood52 Wood 6/7/16 N/A 200 Line Operator A 9/5/16 E 8/6/16 $14 Hourly bi-weekly no
912177 scott75 Scott 12/1/09 N/A 200 Line Operator E 3/1/10 E 1/30/10 $14 Hourly bi-weekly no
480628 young68 Young 7/8/15 N/A 200 Supervisor B 10/6/15 C 9/6/15 $18 Hourly bi-weekly no
335667 jackson12 Jackson 11/12/13 N/A 200 Supervisor B 2/10/14 B 1/11/14 $18 Hourly bi-weekly no
764951 adams75 Adams 8/29/13 N/A 200 Sales Representative A 11/27/13 B 10/28/13 $ 75,000 Salary 1st and 15th 10%
651326 green24 Green 5/4/15 N/A 200 Sales Representative C 8/2/15 E 7/3/15 $ 76,000 Salary 1st and 15th 10%
243927 evans45 Evans 7/3/16 N/A 200 Accountant C 10/1/16 E 9/1/16 $ 85,000 Salary 1st and 15th no
877436 cheng50 Chéng 12/16/16 N/A 300 Supervisor A 3/16/17 D 2/14/17 $18 Hourly bi-weekly no
320589 gagné21 Gagné 7/18/13 N/A 300 Line Operator B 10/16/13 E 9/16/13 $12 Hourly bi-weekly no
738082 garcia76 García 7/2/15 N/A 300 Accountant D 9/30/15 A 8/31/15 $ 80,000 Salary 1st and 15th no
373488 jones69 Jones 4/8/09 N/A 300 Maintenance Specialist D 7/7/09 B 6/7/09 $ 130,000 Salary 1st and 15th no
600681 ng44 Ng 6/15/14 N/A 300 Line Operator E 9/13/14 E 8/14/14 $12 Hourly bi-weekly no
695004 tau69 Tau 7/12/11 N/A 300 Line Operator B 10/10/11 D 9/10/11 $12 Hourly bi-weekly no
156007 wu32 Wú 6/8/15 N/A 300 Line Operator E 9/6/15 C 8/7/15 $12 Hourly bi-weekly no
958349 wright14 Wright 8/6/15 N/A 300 Line Operator B 11/4/15 A 10/5/15 $14 Hourly bi-weekly no
732557 wang98 Wang 11/7/13 N/A 300 Line Operator E 2/5/14 C 1/6/14 $14 Hourly bi-weekly no
240663 wong74 Wong 9/22/16 N/A 300 Line Operator D 12/21/16 D 11/21/16 $12 Hourly bi-weekly no
107040 li44 Li 5/7/15 N/A 300 Line Operator E 8/5/15 A 7/6/15 $12 Hourly bi-weekly no
285683 zhang15 Zhang 6/17/14 N/A 300 Line Operator E 9/15/14 B 8/16/14 $12 Hourly bi-weekly no
512204 liu77 Liu 6/18/13 N/A 300 Line Operator E 9/16/13 B 8/17/13 $12 Hourly bi-weekly no
952375 lau12 Lau 9/8/11 N/A 300 Line Operator E 12/7/11 D 11/7/11 $12 Hourly bi-weekly no
968276 yang76 Yang 8/16/10 N/A 300 Line Operator E 11/14/10 A 10/15/10 $12 Hourly bi-weekly no
406361 huang67 Huang 5/7/11 N/A 300 Supervisor B 8/5/11 B 7/6/11 $18 Hourly bi-weekly no
964067 zhao44 Zhao 6/9/14 N/A 300 Supervisor A 9/7/14 A 8/8/14 $19 Hourly bi-weekly no
685613 guo10 Guo 4/21/07 N/A 300 Sales Representative E 7/20/07 C 6/20/07 $ 85,000 Salary 1st and 15th 10%
716897 gao24 Gao 1/15/15 N/A 300 Sales Representative A 4/15/15 A 3/16/15 $ 80,000 Salary 1st and 15th 10%
278656 tang78 Tang 3/5/09 N/A 300 Accountant A 6/3/09 E 5/4/09 $ 85,000 Salary 1st and 15th no
400347 song99 Song 10/11/16 N/A 300 Accountant D 1/9/17 C 12/10/16 $ 80,000 Salary 1st and 15th no
738090 angelon33 Angelon 7/2/15 N/A 400 Accountant D 9/30/15 A 8/31/15 $ 80,000 Salary 1st and 15th no
291210 matinez22 Martinez 10/28/14 N/A 400 Line Operator E 1/26/15 B 12/27/14 $12 Hourly bi-weekly no
695573 martinez28 Martinez 3/15/11 N/A 400 Line Operator E 6/13/11 E 5/14/11 $12 Hourly bi-weekly no
373490 paulo12 Paulo 4/8/09 N/A 400 Maintenance Specialist D 7/7/09 B 6/7/09 $ 130,000 Salary 1st and 15th no
996092 ruiz15 Ruiz 1/5/15 N/A 400 Line Operator B 4/5/15 D 3/6/15 $12 Hourly bi-weekly no
877510 soares52 Soares 12/1/16 N/A 400 Supervisor A 3/1/17 D 1/30/17 $18 Hourly bi-weekly no
492006 garcia88 Garcia 7/5/13 N/A 400 Line Operator E 10/3/13 B 9/3/13 $12 Hourly bi-weekly no
127375 lopez64 Lopez 10/11/11 N/A 400 Line Operator E 1/9/12 C 12/10/11 $12 Hourly bi-weekly no
895337 gonzalez75 Gonzalez 11/5/15 N/A 400 Line Operator A 2/3/16 E 1/4/16 $14 Hourly bi-weekly no
315734 rivera11 Rivera 6/4/15 N/A 400 Line Operator A 9/2/15 C 8/3/15 $15 Hourly bi-weekly no
517219 diaz18 Diaz 9/7/13 N/A 400 Line Operator E 12/6/13 D 11/6/13 $15 Hourly bi-weekly no
879169 vasquez88 Vasquez 7/6/08 N/A 400 Line Operator E 10/4/08 E 9/4/08 $14 Hourly bi-weekly no
433077 fernandez65 Fernandez 7/3/16 N/A 400 Supervisor C 10/1/16 D 9/1/16 $18 Hourly bi-weekly no
862486 rios43 Rios 7/5/14 N/A 400 Supervisor E 10/3/14 D 9/3/14 $19 Hourly bi-weekly no
819342 cortez55 Cortez 4/7/08 N/A 400 Sales Representative B 7/6/08 E 6/6/08 $ 80,000 Salary 1st and 15th 10%
969492 rodriguez74 Rodriguez 4/23/14 N/A 400 Sales Representative E 7/22/14 A 6/22/14 $ 75,000 Salary 1st and 15th 10%
103369 hernandez56 Hernandez 12/15/15 N/A 400 Accountant B 3/14/16 A 2/13/16 $ 80,000 Salary 1st and 15th no
917287 cardoso56 Cardoso 4/5/12 N/A 500 Line Operator E 7/4/12 D 6/4/12 $12 Hourly bi-weekly no
877522 lopez22 Lopez 1/1/12 N/A 500 Supervisor A 3/31/12 D 3/1/12 $18 Hourly bi-weekly no
373499 oliveira10 Oliveira 4/9/14 N/A 500 Maintenance Specialist D 7/8/14 B 6/8/14 $ 130,000 Salary 1st and 15th no
996123 santos11 Santos 7/30/13 N/A 500 Line Operator B 10/28/13 D 9/28/13 $12 Hourly bi-weekly no
695583 silva13 Silva 5/6/13 N/A 500 Line Operator E 8/4/13 E 7/5/13 $12 Hourly bi-weekly no
738112 sousa33 Sousa 8/1/12 N/A 500 Accountant D 10/30/12 A 9/30/12 $ 80,000 Salary 1st and 15th no
905820 pereira77 Pereira 9/8/08 N/A 500 Line Operator D 12/7/08 E 11/7/08 $13 Hourly bi-weekly no
992465 lima21 Lima 4/15/14 N/A 500 Line Operator B 7/14/14 A 6/14/14 $12 Hourly bi-weekly no
732887 carvalho23 Carvalho 7/5/15 N/A 500 Line Operator B 10/3/15 A 9/3/15 $12 Hourly bi-weekly no
910229 ferreira21 Ferreira 3/8/15 N/A 500 Line Operator E 6/6/15 A 5/7/15 $12 Hourly bi-weekly no
231815 costa40 Costa 2/12/16 N/A 500 Line Operator E 5/12/16 D 4/12/16 $12 Hourly bi-weekly no
333657 gomes25 Gomes 5/7/16 N/A 500 Line Operator E 8/5/16 D 7/6/16 $14 Hourly bi-weekly no
287819 marins68 Marins 5/9/14 N/A 500 Line Operator D 8/7/14 E 7/8/14 $14 Hourly bi-weekly no
579148 melo99 Melo 6/5/16 N/A 500 Supervisor D 9/3/16 A 8/4/16 $19 Hourly bi-weekly no
124436 barbosa24 Barbosa 1/1/16 N/A 500 Supervisor E 3/31/16 C 3/1/16 $20 Hourly bi-weekly no
485078 ribeiro22 Ribeiro 3/6/16 N/A 500 Sales Representative E 6/4/16 B 5/5/16 $ 70,000 Salary 1st and 15th 10%
297585 alves20 Alves 7/20/15 N/A 500 Sales Representative C 10/18/15 C 9/18/15 $ 70,000 Salary 1st and 15th 10%
777104 schmitz62 Schmitz 4/15/16 N/A 500 Accountant B 7/14/16 B 6/14/16 $ 80,000 Salary 1st and 15th no
728222 fleming82 Fleming 1/25/14 N/A 600 Sales Representative D 4/25/14 D 3/26/14 $ 80,000 Salary 1st and 15th 10%
527355 gray74 Gray 3/17/09 N/A 600 Sales Representative C 6/15/09 C 5/16/09 $ 85,000 Salary 1st and 15th 10%
527600 jones74 Jones 3/22/14 N/A 600 DC Line Worker E 6/20/14 C 5/21/14 $12 Hourly bi-weekly no
877813 smith24 Smith 1/1/12 N/A 600 DC Supervisor A 3/31/12 D 3/1/12 $14 Hourly bi-weekly no
728278 thomas81 Thomas 2/18/14 N/A 600 DC Line Worker E 5/19/14 D 4/19/14 $12 Hourly bi-weekly no
729000 becker21 Becker 2/25/14 N/A 600 Store Clerk E 5/26/14 D 4/26/14 $18 Hourly bi-weekly no
527412 hopper11 Hopper 2/17/13 N/A 600 Store Clerk E 5/18/13 C 4/18/13 $18 Hourly bi-weekly no
527812 davis34 Davis 3/25/15 N/A 600 Store Clerk E 6/23/15 C 5/24/15 $18 Hourly bi-weekly no
877973 mikoski82 Mikoski 9/1/14 N/A 600 Store Clerk A 11/30/14 D 10/31/14 $17 Hourly bi-weekly no
728333 landau12 Landau 8/18/15 N/A 600 Store Clerk E 11/16/15 D 10/17/15 $17 Hourly bi-weekly no
960444 allison29 Allison 6/5/15 N/A 600 Sales Representative D 9/3/15 E 8/4/15 $ 70,000 Salary 1st and 15th 10%
529223 davidson20 Davidson 7/9/10 N/A 600 Sales Representative D 10/7/10 A 9/7/10 $ 76,000 Salary 1st and 15th 10%
252858 franklin79 Franklin 8/4/14 N/A 600 Accountant C 11/2/14 E 10/3/14 $ 85,000 Salary 1st and 15th no

Finished Goods On-Hand

Location ID Detailed Location ID Finished Item # Description Quantity Date Received Min Level On-hold
600 New York Store 101 Sally Doll 700 3/15/17 200 yes
500 Sao Paolo Plant 101 Sally Doll 400 3/27/17 no
400 Mexico City Plant 101 Sally Doll 690 5/1/17 no
300 Shanghai Plant 101 Sally Doll 320 4/10/17 yes
200 Washington Plant 101 Sally Doll 200 3/13/17 no
600 New York Store 102 Brenda Doll 430 3/15/17 200 no
500 Sao Paolo Plant 102 Brenda Doll 600 3/27/17 yes
400 Mexico City Plant 102 Brenda Doll 600 5/1/17 no
300 Shanghai Plant 102 Brenda Doll 160 4/10/17 no
200 Washington Plant 102 Brenda Doll 300 3/13/17 no
600 New York Store 103 Lacy Doll 400 3/22/17 200 no
500 Sao Paolo Plant 103 Lacy Doll 550 3/27/17 yes
400 Mexico City Plant 103 Lacy Doll 170 5/5/17 no
300 Shanghai Plant 103 Lacy Doll 40 4/10/17 no
200 Washington Plant 103 Lacy Doll 140 3/15/17 no
600 New York Store 104 Maxwell Doll 500 3/15/17 200 no
500 Sao Paolo Plant 104 Maxwell Doll 400 4/13/17 no
400 Mexico City Plant 104 Maxwell Doll 700 5/5/17 no
300 Shanghai Plant 104 Maxwell Doll 200 4/15/17 no
200 Washington Plant 104 Maxwell Doll 170 3/16/17 yes
600 New York Store 105 Joshua Doll 450 3/15/17 200 yes
500 Sao Paolo Plant 105 Joshua Doll 500 4/13/17 no
400 Mexico City Plant 105 Joshua Doll 650 5/5/17 no
300 Shanghai Plant 105 Joshua Doll 250 4/15/17 yes
200 Washington Plant 105 Joshua Doll 200 3/19/17 yes
600 New York Store 211 Red Car 650 3/28/17 50 no
500 Sao Paolo Plant 211 Red Car 160 5/1/17 yes
400 Mexico City Plant 211 Red Car 750 5/10/17 yes
300 Shanghai Plant 211 Red Car 700 4/20/17 no
200 Washington Plant 211 Red Car 240 3/20/17 no
600 New York Store 212 Green Car 550 3/28/17 50 no
500 Sao Paolo Plant 212 Green Car 200 5/1/17 no
400 Mexico City Plant 212 Green Car 250 5/10/17 no
300 Shanghai Plant 212 Green Car 500 3/29/17 no
200 Washington Plant 212 Green Car 300 3/20/17 no
600 New York Store 213 Blue Car 500 3/22/17 50 yes
500 Sao Paolo Plant 213 Blue Car 250 5/15/17 no
400 Mexico City Plant 213 Blue Car 100 4/29/17 yes
300 Shanghai Plant 213 Blue Car 200 3/20/17 no
200 Washington Plant 213 Blue Car 520 3/22/17 yes
600 New York Store 214 Purple Car 550 3/30/17 50 no
500 Sao Paolo Plant 214 Purple Car 200 5/15/17 no
400 Mexico City Plant 214 Purple Car 150 4/25/17 no
300 Shanghai Plant 214 Purple Car 500 3/20/17 no
200 Washington Plant 214 Purple Car 500 3/29/17 no
600 New York Store 215 Yellow Car 500 3/30/17 50 yes
500 Sao Paolo Plant 215 Yellow Car 300 5/10/17 yes
400 Mexico City Plant 215 Yellow Car 240 5/15/17 no
300 Shanghai Plant 215 Yellow Car 500 4/30/17 no
200 Washington Plant 215 Yellow Car 470 4/5/17 yes
600 New York Store 301 Soccer Video Game 150 4/2/17 150 no
500 Sao Paolo Plant 301 Soccer Video Game 340 3/27/17 no
400 Mexico City Plant 301 Soccer Video Game 50 5/15/17 no
300 Shanghai Plant 301 Soccer Video Game 460 4/30/17 yes
200 Washington Plant 301 Soccer Video Game 900 4/7/17 yes
600 New York Store 302 Racing Video Game 120 4/2/17 150 yes
500 Sao Paolo Plant 302 Racing Video Game 550 3/27/17 no
400 Mexico City Plant 302 Racing Video Game 100 5/15/17 no
300 Shanghai Plant 302 Racing Video Game 820 4/10/17 no
200 Washington Plant 302 Racing Video Game 280 4/13/17 no
600 New York Store 303 Military Video Game 320 4/6/17 200 no
500 Sao Paolo Plant 303 Military Video Game 280 3/20/17 no
400 Mexico City Plant 303 Military Video Game 400 4/19/17 yes
300 Shanghai Plant 303 Military Video Game 140 4/10/17 yes
200 Washington Plant 303 Military Video Game 640 4/14/17 yes
600 New York Store 304 Football Video Game 250 4/13/17 200 no
500 Sao Paolo Plant 304 Football Video Game 275 3/18/17 no
400 Mexico City Plant 304 Football Video Game 300 4/19/17 yes
300 Shanghai Plant 304 Football Video Game 700 4/12/17 no
200 Washington Plant 304 Football Video Game 600 4/18/17 no
600 New York Store 305 Skateboarding Video Game 200 4/13/17 150 yes
500 Sao Paolo Plant 305 Skateboarding Video Game 400 3/27/17 yes
400 Mexico City Plant 305 Skateboarding Video Game 350 5/12/17 yes
300 Shanghai Plant 305 Skateboarding Video Game 650 4/12/17 yes
200 Washington Plant 305 Skateboarding Video Game 500 4/20/17 yes
600 New York Store 401 Black Scooter 500 4/5/17 200 no
500 Sao Paolo Plant 401 Black Scooter 300 3/27/17 no
400 Mexico City Plant 401 Black Scooter 350 5/8/17 yes
300 Shanghai Plant 401 Black Scooter 600 4/20/17 no
200 Washington Plant 401 Black Scooter 400 4/24/17 yes
600 New York Store 402 Pink Scooter 400 4/15/17 200 no
500 Sao Paolo Plant 402 Pink Scooter 200 3/27/17 no
400 Mexico City Plant 402 Pink Scooter 250 5/8/17 no
300 Shanghai Plant 402 Pink Scooter 600 4/20/17 no
200 Washington Plant 402 Pink Scooter 450 4/30/17 no
600 New York Store 403 Blue Scooter 450 4/15/17 200 yes
500 Sao Paolo Plant 403 Blue Scooter 300 4/11/17 no
400 Mexico City Plant 403 Blue Scooter 300 5/8/17 no
300 Shanghai Plant 403 Blue Scooter 500 4/25/17 no
200 Washington Plant 403 Blue Scooter 350 5/1/17 no
600 New York Store 404 Orange Scooter 400 4/23/17 200 no
500 Sao Paolo Plant 404 Orange Scooter 350 4/18/17 yes
400 Mexico City Plant 404 Orange Scooter 300 5/6/17 no
300 Shanghai Plant 404 Orange Scooter 400 4/25/17 yes
200 Washington Plant 404 Orange Scooter 300 5/1/17 no
600 New York Store 405 yellow Scooter 400 4/23/17 200 no
500 Sao Paolo Plant 405 yellow Scooter 300 4/23/17 no
400 Mexico City Plant 405 yellow Scooter 250 5/1/17 no
300 Shanghai Plant 405 yellow Scooter 450 4/25/17 no
200 Washington Plant 405 yellow Scooter 200 5/5/17 yes

Formulas

Formula Raw Material #1 #1 Quantity Raw Material #2 #2 Quantity Raw Material #3 #3 Quantity Raw Material #4 #4 Quantity Raw Material #5 #5 Quantity Finished Good #
Red Car 131 4 132 2 133 4 134 4 570 1 211
Green Car 131 4 132 2 133 4 134 4 573 1 212
Blue Car 131 4 132 2 133 4 134 4 571 1 213
Purple Car 131 4 132 2 133 4 134 4 574 1 214
Yellow Car 131 4 132 2 133 4 134 4 572 1 215
Sally Doll 250 1 253 1 254 2 255 2 256 2 101
Brenda Doll 251 1 253 1 254 2 255 2 256 2 102
Lacy Doll 252 1 253 1 254 2 255 2 256 2 103
Maxwell Doll 251 1 257 1 254 2 255 2 256 2 104
Joshua Doll 252 1 257 1 254 2 255 2 256 2 105
Soccer Video Game 320 1 321 1 322 1 301
Racing Video Game 320 1 321 1 322 1 302
Military Video Game 320 1 321 1 322 1 303
Football Video Game 320 1 321 1 322 1 304
Skateboarding Video Game 320 1 321 1 322 1 305
Black Scooter 440 1 441 2 442 1 575 1 401
Pink Scooter 440 1 441 2 442 1 576 1 402
Blue Scooter 440 1 441 2 442 1 571 1 403
Orange Scooter 440 1 441 2 442 1 577 1 404
yellow Scooter 440 1 441 2 442 1 572 1 405

Inventory Count

Date of Count Location Detailed Location Item # Minimum Quanitity Quantity Counted Quantity Expected Difference Counter Approver
3/14/17 600 Distribution Center 101 700 700 0 jones74 smith24
3/14/17 600 Distribution Center 102 430 430 0 jones74 smith24
3/14/17 600 Distribution Center 103 400 400 0 jones74 smith24
3/14/17 600 Distribution Center 104 500 500 0 jones74 smith24
3/14/17 600 Distribution Center 105 540 450 0 jones74 smith24
3/14/17 600 Distribution Center 211 620 650 30 jones74 smith24
3/14/17 600 Distribution Center 212 550 550 0 jones74 smith24
3/14/17 600 Distribution Center 213 500 500 0 thomas81 smith24
3/14/17 600 Distribution Center 214 550 550 0 thomas81 smith24
3/14/17 600 Distribution Center 215 500 500 0 thomas81 smith24
3/14/17 600 Distribution Center 301 150 150 0 thomas81 smith24
3/14/17 600 Distribution Center 302 120 120 0 thomas81 smith24
3/14/17 600 Distribution Center 303 270 320 50 jones74 smith24
3/14/17 600 Distribution Center 304 250 250 0 jones74 smith24
3/14/17 600 Distribution Center 305 180 200 20 jones74 smith24
3/14/17 600 Distribution Center 401 500 500 0 jones74 smith24
3/14/17 600 Distribution Center 402 400 400 0 jones74 smith24
3/14/17 600 Distribution Center 403 400 450 50 jones74 smith24
3/14/17 600 Distribution Center 404 300 400 100 jones74 smith24
3/14/17 600 Distribution Center 405 390 400 10 jones74 smith24
3/14/17 200 Washington Plant 131 500 3990 4000 10 smith22 masterson50
3/14/17 200 Washington Plant 132 500 2000 2000 0 smith22 masterson50
3/14/17 200 Washington Plant 133 500 4000 4000 0 smith22 masterson50
3/14/17 200 Washington Plant 134 500 2000 2000 0 smith22 masterson50
3/14/17 200 Washington Plant 250 500 500 500 0 smith22 masterson50
3/14/17 200 Washington Plant 251 500 550 600 50 smith22 masterson50
3/14/17 200 Washington Plant 252 500 500 500 0 smith22 masterson50
3/14/17 200 Washington Plant 253 500 1500 1500 0 smith22 masterson50
3/14/17 200 Washington Plant 254 500 3000 3000 0 smith22 masterson50
3/14/17 200 Washington Plant 255 500 2500 3000 500 smith22 masterson50
3/14/17 200 Washington Plant 256 500 3000 3000 0 smith22 masterson50
3/14/17 200 Washington Plant 257 500 2000 2000 0 smith22 masterson50
3/14/17 200 Washington Plant 320 500 2000 2000 0 smith22 masterson50
3/14/17 200 Washington Plant 321 500 2000 2000 0 smith22 masterson50
3/14/17 200 Washington Plant 322 500 2000 2000 0 smith22 masterson50
3/14/17 200 Washington Plant 440 500 1800 2000 200 smith22 masterson50
3/14/17 200 Washington Plant 441 500 4000 4000 0 smith22 masterson50
3/14/17 200 Washington Plant 442 500 1800 2000 200 smith22 masterson50
3/14/17 200 Washington Plant 570 500 1000 1000 0 smith22 masterson50
3/14/17 200 Washington Plant 571 500 1500 1500 0 smith22 masterson50
3/14/17 200 Washington Plant 572 500 1000 1500 500 smith22 masterson50
3/14/17 200 Washington Plant 573 500 800 800 0 smith22 masterson50
3/14/17 200 Washington Plant 574 500 900 900 0 smith22 masterson50
3/14/17 200 Washington Plant 575 500 700 700 0 smith22 masterson50
3/14/17 200 Washington Plant 576 500 750 750 0 smith22 masterson50
3/14/17 200 Washington Plant 577 500 500 500 0 smith22 masterson50
3/14/17 200 Washington Plant 101 200 200 0 smith22 masterson50
3/14/17 200 Washington Plant 102 300 300 0 smith22 masterson50
3/14/17 200 Washington Plant 103 140 140 0 smith22 masterson50
3/14/17 200 Washington Plant 104 170 170 0 smith22 masterson50
3/14/17 200 Washington Plant 105 200 200 0 smith22 masterson50
3/14/17 200 Washington Plant 211 240 240 0 smith22 masterson50
3/14/17 200 Washington Plant 212 300 300 0 smith22 masterson50
3/14/17 200 Washington Plant 213 520 520 0 smith22 masterson50
3/14/17 200 Washington Plant 214 500 500 0 smith22 masterson50
3/14/17 200 Washington Plant 215 470 470 0 smith22 masterson50
3/14/17 200 Washington Plant 301 900 900 0 smith22 masterson50
3/14/17 200 Washington Plant 302 280 280 0 smith22 masterson50
3/14/17 200 Washington Plant 303 640 640 0 smith22 masterson50
3/14/17 200 Washington Plant 304 600 600 0 smith22 masterson50
3/14/17 200 Washington Plant 305 500 500 0 smith22 masterson50
3/14/17 200 Washington Plant 401 400 400 0 smith22 masterson50
3/14/17 200 Washington Plant 402 450 450 0 smith22 masterson50
3/14/17 200 Washington Plant 403 350 350 0 smith22 masterson50
3/14/17 200 Washington Plant 404 300 300 0 smith22 masterson50
3/14/17 200 Washington Plant 405 200 200 0 smith22 masterson50
3/14/17 300 Shanghai Plant 131 500 1980 2000 20 ng44 cheng50
3/14/17 300 Shanghai Plant 132 500 800 1000 200 ng44 cheng50
3/14/17 300 Shanghai Plant 133 500 2000 2000 0 ng44 cheng50
3/14/17 300 Shanghai Plant 134 500 1000 1000 0 ng44 cheng50
3/14/17 300 Shanghai Plant 250 500 500 500 0 ng44 cheng50
3/14/17 300 Shanghai Plant 251 500 1000 1000 0 ng44 cheng50
3/14/17 300 Shanghai Plant 252 500 950 1000 50 ng44 cheng50
3/14/17 300 Shanghai Plant 253 500 3000 3000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 254 500 6000 6000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 255 500 5000 6000 1000 tau69 cheng50
3/14/17 300 Shanghai Plant 256 500 6000 6000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 257 500 5000 5000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 320 500 3000 3000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 321 500 3000 3000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 322 500 2900 3000 100 tau69 cheng50
3/14/17 300 Shanghai Plant 440 500 3000 3000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 441 500 6000 6000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 442 500 3000 3000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 570 500 500 500 0 tau69 cheng50
3/14/17 300 Shanghai Plant 571 500 1000 1000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 572 500 1000 1000 0 tau69 cheng50
3/14/17 300 Shanghai Plant 573 500 700 750 50 tau69 cheng50
3/14/17 300 Shanghai Plant 574 500 800 800 0 tau69 cheng50
3/14/17 300 Shanghai Plant 575 500 700 700 0 tau69 cheng50
3/14/17 300 Shanghai Plant 576 500 900 900 0 tau69 cheng50
3/14/17 300 Shanghai Plant 577 500 800 800 0 tau69 cheng50
3/14/17 300 Shanghai Plant 101 320 320 0 tau69 cheng50
3/14/17 300 Shanghai Plant 102 160 160 0 tau69 cheng50
3/14/17 300 Shanghai Plant 103 40 40 0 tau69 cheng50
3/14/17 300 Shanghai Plant 104 200 200 0 tau69 cheng50
3/14/17 300 Shanghai Plant 105 250 250 0 tau69 cheng50
3/14/17 300 Shanghai Plant 211 700 700 0 tau69 cheng50
3/14/17 300 Shanghai Plant 212 500 500 0 tau69 cheng50
3/14/17 300 Shanghai Plant 213 200 200 0 tau69 cheng50
3/14/17 300 Shanghai Plant 214 500 500 0 tau69 cheng50
3/14/17 300 Shanghai Plant 215 500 500 0 tau69 cheng50
3/14/17 300 Shanghai Plant 301 460 460 0 tau69 cheng50
3/14/17 300 Shanghai Plant 302 820 820 0 tau69 cheng50
3/14/17 300 Shanghai Plant 303 140 140 0 tau69 cheng50
3/14/17 300 Shanghai Plant 304 700 700 0 tau69 cheng50
3/14/17 300 Shanghai Plant 305 650 650 0 tau69 cheng50
3/14/17 300 Shanghai Plant 401 600 600 0 tau69 cheng50
3/14/17 300 Shanghai Plant 402 600 600 0 tau69 cheng50
3/14/17 300 Shanghai Plant 403 500 500 0 tau69 cheng50
3/14/17 300 Shanghai Plant 404 400 400 0 tau69 cheng50
3/14/17 300 Shanghai Plant 405 450 450 0 tau69 cheng50
3/14/17 400 Mexico City Plant 131 500 3900 4000 100 martinez22 soares52
3/14/17 400 Mexico City Plant 132 500 2000 2000 0 martinez22 soares52
3/14/17 400 Mexico City Plant 133 500 3000 3000 0 martinez22 soares52
3/14/17 400 Mexico City Plant 134 500 2000 2000 0 martinez22 soares52
3/14/17 400 Mexico City Plant 250 500 900 1000 100 martinez22 soares52
3/14/17 400 Mexico City Plant 251 500 500 500 0 martinez22 soares52
3/14/17 400 Mexico City Plant 252 500 500 500 0 martinez22 soares52
3/14/17 400 Mexico City Plant 253 500 1000 1500 500 martinez22 soares52
3/14/17 400 Mexico City Plant 254 500 3000 3000 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 255 500 3000 3000 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 256 500 3000 3000 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 257 500 3000 3000 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 320 500 1500 1500 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 321 500 1400 1500 100 ruiz15 soares52
3/14/17 400 Mexico City Plant 322 500 1500 1500 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 440 500 1000 1000 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 441 500 2000 2000 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 442 500 1000 1000 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 570 500 500 600 100 ruiz15 soares52
3/14/17 400 Mexico City Plant 571 500 600 600 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 572 500 500 500 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 573 500 550 550 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 574 500 550 600 50 ruiz15 soares52
3/14/17 400 Mexico City Plant 575 500 500 500 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 576 500 600 600 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 577 500 550 550 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 101 690 690 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 102 600 600 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 103 170 170 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 104 700 700 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 105 650 650 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 211 750 750 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 212 250 250 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 213 100 100 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 214 150 150 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 215 240 240 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 301 50 50 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 302 100 100 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 303 400 400 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 304 300 300 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 305 350 350 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 401 350 350 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 402 250 250 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 403 300 300 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 404 300 300 0 ruiz15 soares52
3/14/17 400 Mexico City Plant 405 250 250 0 ruiz15 soares52
3/14/17 500 Sao Paolo Plant 131 500 1000 1000 0 cardoso56 lopez22
3/14/17 500 Sao Paolo Plant 132 500 500 500 0 cardoso56 lopez22
3/14/17 500 Sao Paolo Plant 133 500 500 500 0 cardoso56 lopez22
3/14/17 500 Sao Paolo Plant 134 500 550 600 50 cardoso56 lopez22
3/14/17 500 Sao Paolo Plant 250 500 500 500 0 cardoso56 lopez22
3/14/17 500 Sao Paolo Plant 251 500 500 500 0 cardoso56 lopez22
3/14/17 500 Sao Paolo Plant 252 500 500 500 0 cardoso56 lopez22
3/14/17 500 Sao Paolo Plant 253 500 700 1000 300 cardoso56 lopez22
3/14/17 500 Sao Paolo Plant 254 500 2000 2000 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 255 500 2000 2000 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 256 500 1900 2000 100 santos11 lopez22
3/14/17 500 Sao Paolo Plant 257 500 2000 2000 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 320 500 700 700 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 321 500 700 700 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 322 500 600 700 100 santos11 lopez22
3/14/17 500 Sao Paolo Plant 440 500 500 500 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 441 500 1000 1000 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 442 500 500 550 50 santos11 lopez22
3/14/17 500 Sao Paolo Plant 570 500 500 500 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 571 500 700 700 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 572 500 800 800 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 573 500 500 500 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 574 500 600 700 100 santos11 lopez22
3/14/17 500 Sao Paolo Plant 575 500 600 600 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 576 500 550 550 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 577 500 500 500 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 101 400 400 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 102 600 600 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 103 550 550 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 104 400 400 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 105 500 500 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 211 160 160 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 212 200 200 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 213 250 250 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 214 200 200 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 215 300 300 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 301 340 340 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 302 550 550 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 303 280 280 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 304 275 275 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 305 400 400 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 401 300 300 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 402 200 200 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 403 300 300 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 404 350 350 0 santos11 lopez22
3/14/17 500 Sao Paolo Plant 405 300 300 0 santos11 lopez22

Inventory Adjustments

Date Location Detailed Location Raw Material # Finished Goods # Adjustment Adjustment Reason Approver
3/15/17 600 Distribution Center 211 smith24
3/15/17 600 Distribution Center 303 smith24
3/15/17 600 Distribution Center 305 smith24
3/15/17 600 Distribution Center 403 smith24
3/15/17 600 Distribution Center 404 smith24
3/15/17 600 Distribution Center 405 smith24
3/15/17 500 Sao Paolo Plant 134 lopez22
3/15/17 500 Sao Paolo Plant 253 lopez22
3/15/17 500 Sao Paolo Plant 256 lopez22
3/15/17 500 Sao Paolo Plant 322 lopez22
3/15/17 500 Sao Paolo Plant 442 lopez22
3/15/17 500 Sao Paolo Plant 574 lopez22
3/15/17 400 Mexico City Plant 131 soares52
3/15/17 400 Mexico City Plant 250 soares52
3/15/17 400 Mexico City Plant 253 soares52
3/15/17 400 Mexico City Plant 321 soares52
3/15/17 400 Mexico City Plant 570 soares52
3/15/17 400 Mexico City Plant 574 soares52
3/15/17 300 Shanghai Plant 131 cheng50
3/15/17 300 Shanghai Plant 132 cheng50
3/15/17 300 Shanghai Plant 252 cheng50
3/15/17 300 Shanghai Plant 255 cheng50
3/15/17 300 Shanghai Plant 322 cheng50
3/15/17 300 Shanghai Plant 573 cheng50
3/15/17 200 Washington Plant 131 masterson50
3/15/17 200 Washington Plant 251 masterson50
3/15/17 200 Washington Plant 255 masterson50
3/15/17 200 Washington Plant 440 masterson50
3/15/17 200 Washington Plant 442 masterson50
3/15/17 200 Washington Plant 572 masterson50

Invoice

Invoice # Vendor # Invoice Date Item Item Quantity Item Cost Extended Cost Freight Cost Total Cost Processor ID Associated PO Associated Receipt Payment Terms Discount
74562 321782506 3/8/17 131 100 15 1500 200 1700 feng42 323205 774805 Net 60 none
21775 658314729 3/8/17 132 50 15 750 100 850 feng42 405605 665014 Net 15 5%
65075 658314729 3/14/17 133 50 15 750 100 850 feng42 650351 205068 Net 15 5%
54055 504796147 3/14/17 134 50 15 750 100 850 feng42 795652 700656 Net 10 5%
30892 640498345 3/8/17 250 200 20 4000 400 4400 feng42 749207 985084 Net 60 5%
31598 114058620 3/10/17 251 300 20 6000 600 6600 feng42 998053 146505 Net 30 none
10547 842895157 3/14/17 252 200 20 4000 400 4400 feng42 798350 606807 Net 30 none
48905 912086047 3/15/17 253 600 20 12000 1200 13200 feng42 504377 420447 Net 60 none
98446 667057064 3/7/17 254 500 20 10000 1000 11000 feng42 410560 980752 Net 15 5%
34870 508089512 3/10/17 255 500 20 10000 1000 11000 feng42 540576 950400 Net 10 none
90453 504796147 3/10/17 256 2000 20 40000 4000 44000 evans45 132086 110501 Net 10 5%
70648 912086047 3/10/17 257 1500 20 30000 3000 33000 evans45 321460 607802 Net 60 none
11018 321782506 3/15/17 320 400 30 12000 800 12800 evans45 305403 654650 Net 60 none
15498 108906507 3/15/17 321 450 30 13500 900 14400 evans45 609327 906503 Net 10 none
57805 504796147 3/15/17 322 450 30 13500 900 14400 evans45 650899 980605 Net 10 5%
70540 658314729 3/7/17 440 100 25 2500 200 2700 evans45 989301 885240 Net 15 5%
46570 842895157 3/7/17 441 400 25 10000 800 10800 evans45 321086 220350 Net 30 none
60873 640498345 3/10/17 442 400 25 10000 800 10800 evans45 608706 995065 Net 60 5%
54891 321782506 3/14/17 570 75 10 750 150 900 evans45 980052 306560 Net 60 none
51869 508089512 3/7/17 571 150 10 1500 300 1800 evans45 654255 306504 Net 10 none
20756 508089512 3/7/17 572 150 10 1500 300 1800 evans45 669521 201050 Net 10 none
10298 842895157 3/7/17 573 75 10 750 150 900 evans45 891247 302090 Net 30 none
13354 508089512 3/7/17 574 75 10 750 150 900 evans45 880320 305408 Net 10 none
98631 658314729 3/7/17 575 75 10 750 150 900 evans45 808604 668071 Net 15 5%
45204 508089512 3/8/17 576 75 10 750 150 900 evans45 332556 305038 Net 10 none
70554 912086047 3/10/17 577 75 10 750 150 900 evans45 980350 605068 Net 60 none
70015 912086047 3/14/17 131 60 15 900 120 1020 tang78 506795 996055 Net 60 none
65480 912086047 3/15/17 132 120 15 1800 240 2040 tang78 894632 160530 Net 60 none
30574 504796147 3/15/17 133 160 15 2400 320 2720 tang78 641589 775041 Net 10 5%
65076 667057064 3/8/17 134 160 15 2400 320 2720 tang78 223149 335047 Net 15 5%
51182 114058620 3/8/17 250 400 20 8000 800 8800 tang78 283649 421963 Net 30 none
77875 560191569 3/14/17 251 500 20 10000 1000 11000 tang78 577616 903553 Net 30 none
93499 484071188 3/14/17 252 500 20 10000 1000 11000 tang78 517699 490474 Net 10 none
84543 246761437 3/8/17 253 2000 20 40000 4000 44000 tang78 947560 550513 Net 60 none
87363 838679702 3/10/17 254 4000 20 80000 8000 88000 tang78 450055 326574 Net 60 none
52581 145751240 3/14/17 255 3000 20 60000 6000 66000 tang78 241754 888176 Net 30 5%
99505 398064250 3/15/17 256 4000 20 80000 8000 88000 song99 839886 400848 Net 10 5%
86366 835731031 3/7/17 257 1000 20 20000 2000 22000 song99 777700 233648 Net 60 none
69988 949644180 3/10/17 320 60 30 1800 120 1920 song99 455839 657405 Net 60 none
58853 525911359 3/10/17 321 60 30 1800 120 1920 song99 383349 631528 Net 10 none
43146 573426003 3/10/17 322 60 30 1800 120 1920 song99 355971 508724 Net 10 none
11879 761344326 3/15/17 440 45 25 1125 90 1215 song99 511568 608445 Net 15 none
67612 266304285 3/15/17 441 50 25 1250 100 1350 song99 711945 378076 Net 30 5%
92493 453904299 3/15/17 442 75 25 1875 150 2025 song99 642027 733501 Net 10 none
72371 189185611 3/7/17 570 150 10 1500 300 1800 song99 626749 911798 Net 10 5%
25203 311488387 3/7/17 571 200 10 2000 400 2400 song99 234101 849906 Net 15 none
82392 743296602 3/10/17 572 200 10 2000 400 2400 song99 343572 484867 Net 30 5%
18523 886855566 3/14/17 573 100 10 1000 200 1200 song99 136556 171088 Net 60 none
92746 180683546 3/7/17 574 75 10 750 150 900 song99 592472 627590 Net 30 none
90870 625430903 3/7/17 575 100 10 1000 200 1200 song99 454150 466692 Net 10 none
38535 636531627 3/7/17 576 75 10 750 150 900 song99 646490 220595 Net 60 none
37945 145751240 3/7/17 577 75 10 750 150 900 song99 540782 630399 Net 30 5%
78884 949644180 3/7/17 131 450 15 6750 900 7650 angelon33 672029 419203 Net 60 none
56971 180683546 3/8/17 132 500 15 7500 1000 8500 angelon33 938749 948037 Net 30 none
13836 625430903 3/10/17 133 500 15 7500 1000 8500 angelon33 212257 350157 Net 10 none
41510 145751240 3/14/17 134 500 15 7500 1000 8500 angelon33 662797 730615 Net 30 5%
16515 842895157 3/15/17 250 25 20 500 50 550 angelon33 831855 877919 Net 30 none
64930 508089512 3/15/17 251 25 20 500 50 550 angelon33 540429 852032 Net 10 none
64270 658314729 3/8/17 252 25 20 500 50 550 angelon33 621406 159338 Net 15 5%
57320 508089512 3/8/17 253 100 20 2000 200 2200 angelon33 872673 629485 Net 10 none
23564 266304285 3/14/17 254 250 20 5000 500 5500 angelon33 140814 384074 Net 30 5%
81849 453904299 3/14/17 255 250 20 5000 500 5500 angelon33 551885 648746 Net 10 none
99319 189185611 3/8/17 256 250 20 5000 500 5500 angelon33 427158 530028 Net 10 5%
27488 311488387 3/10/17 257 45 20 900 90 990 hernandez56 676707 128595 Net 15 none
55228 453904299 3/14/17 320 90 30 2700 180 2880 hernandez56 682857 777694 Net 10 none
83963 453904299 3/15/17 321 100 30 3000 200 3200 hernandez56 289016 758803 Net 10 none
98724 949644180 3/7/17 322 100 30 3000 200 3200 hernandez56 129602 190129 Net 60 none
38062 266304285 3/10/17 440 75 25 1875 150 2025 hernandez56 697511 815548 Net 30 5%
98450 453904299 3/10/17 441 75 25 1875 150 2025 hernandez56 858617 661535 Net 10 none
28804 453904299 3/10/17 442 75 25 1875 150 2025 hernandez56 380587 964485 Net 10 none
47146 189185611 3/15/17 570 100 10 1000 200 1200 hernandez56 872939 671613 Net 10 5%
98311 189185611 3/15/17 571 100 10 1000 200 1200 hernandez56 734204 724601 Net 10 5%
80903 949644180 3/15/17 572 100 10 1000 200 1200 hernandez56 693994 502438 Net 60 none
48839 761344326 3/7/17 573 900 10 9000 1800 10800 hernandez56 409852 172474 Net 15 none
81049 266304285 3/7/17 574 900 10 9000 1800 10800 hernandez56 703289 131887 Net 30 5%
88631 453904299 3/10/17 575 500 10 5000 1000 6000 hernandez56 224586 474872 Net 10 none
14630 189185611 3/14/17 576 400 10 4000 800 4800 hernandez56 888955 421502 Net 10 5%
18095 761344326 3/7/17 577 250 10 2500 500 3000 hernandez56 168182 284898 Net 15 none
99410 761344326 3/7/17 131 500 15 7500 1000 8500 sousa33 898293 406525 Net 15 none
46566 266304285 3/7/17 132 500 15 7500 1000 8500 sousa33 537285 745522 Net 30 5%
65465 658314729 3/7/17 133 750 15 11250 1500 12750 sousa33 388032 790081 Net 15 5%
74018 504796147 3/7/17 134 1000 15 15000 2000 17000 sousa33 112154 156360 Net 10 5%
43515 640498345 3/8/17 250 650 20 13000 1300 14300 sousa33 441859 596874 Net 60 5%
55892 114058620 3/10/17 251 650 20 13000 1300 14300 sousa33 951471 821652 Net 30 none
75922 842895157 3/14/17 252 500 20 10000 1000 11000 sousa33 931171 285517 Net 30 none
76000 912086047 3/15/17 253 700 20 14000 1400 15400 sousa33 712492 752287 Net 60 none
55508 504796147 3/15/17 254 2000 20 40000 4000 44000 sousa33 785661 780515 Net 10 5%
42890 640498345 3/8/17 255 2000 20 40000 4000 44000 sousa33 146199 650796 Net 60 5%
60820 114058620 3/8/17 256 2000 20 40000 4000 44000 sousa33 722371 763429 Net 30 none
90829 114058620 3/14/17 257 1000 20 20000 2000 22000 schmitz62 827090 710193 Net 30 none
13291 842895157 3/14/17 320 80 30 2400 160 2560 schmitz62 265858 284290 Net 30 none
51041 912086047 3/8/17 321 80 30 2400 160 2560 schmitz62 810693 250908 Net 60 none
90147 842895157 3/10/17 322 120 30 3600 240 3840 schmitz62 810028 812876 Net 30 none
51072 508089512 3/14/17 440 450 25 11250 900 12150 schmitz62 737807 481466 Net 10 none
80563 658314729 3/15/17 441 900 25 22500 1800 24300 schmitz62 294920 540858 Net 15 5%
20346 658314729 3/7/17 442 450 25 11250 900 12150 schmitz62 960397 789820 Net 15 5%
32878 842895157 3/10/17 570 650 10 6500 1300 7800 schmitz62 959408 741224 Net 30 none
43328 508089512 3/10/17 571 500 10 5000 1000 6000 schmitz62 232472 592068 Net 10 none
18361 658314729 3/10/17 572 500 10 5000 1000 6000 schmitz62 466650 838584 Net 15 5%
75418 508089512 3/15/17 573 500 10 5000 1000 6000 schmitz62 906530 335823 Net 10 none
65070 842895157 3/15/17 574 500 10 5000 1000 6000 schmitz62 856065 650456 Net 30 none
86075 508089512 3/15/17 575 750 10 7500 1500 9000 schmitz62 650472 608545 Net 10 none
69962 658314729 3/7/17 576 700 10 7000 1400 8400 schmitz62 305652 708504 Net 15 5%
44122 508089512 3/7/17 577 500 10 5000 1000 6000 schmitz62 552210 650807 Net 10 none

Location

Location ID Location Name Country Type
100 Cleveland USA Headquarters
200 Washington USA Plant
300 Shanghai China Plant
400 Mexico City Mexico Plant
500 Sao Paulo Brazil Plant
600 New York USA Store

Medical Plan

Medical Plan Plan Description Deductable
Medical A Healthy Focus Individual Advantage Plan 400
Medical B Healthy Focus Individual Essential Plan 200
Medical C Healthy Focus Family Advantage Plan 400 per family member
Medical D Healthy Focus Family Essential Plan 200 per family member
Medical E Healty Focus Basic Plan 100

Payment

Payment ID Vendor PO # Receipt # Invoice # Payment Amount Check # Payment Type Wire # Payment Date Processor ID
65405 321782506 323205 774805 74562 1700 1234 Check 3/18/17 feng42
32344 658314729 405605 665014 21775 850 ACH 8399572 3/18/17 feng42
21140 658314729 205068 65075 850 ACH 6682959 3/24/17 feng42
89053 504796147 795652 700656 54055 850 8263 Check 3/24/17 feng42
45541 640498345 749207 985084 30892 4400 ACH 3159304 3/18/17 feng42
65055 114058620 998053 146505 31598 6600 7793 Check 3/20/17 feng42
10477 842895157 798350 606807 10547 4400 Wire 7442770 3/24/17 feng42
35088 912086047 504377 420447 48905 13200 Wire 9611028 5/25/17 feng42
46155 667057064 410560 980752 98446 11000 Wire 7162741 3/17/17 feng42
65008 508089512 540576 950400 34870 11000 ACH 4118691 3/20/17 feng42
56184 504796147 132086 110501 90453 44000 6547 Check 3/20/17 evans45
31548 912086047 321460 607802 70648 33000 Wire 2693015 3/20/17 evans45
67954 321782506 305403 654650 11018 12800 5608 Check 3/25/17 evans45
11205 108906507 609327 906503 15498 14400 ACH 3496862 3/25/17 evans45
30255 504796147 650899 980605 57805 14400 9840 Check 3/25/17 evans45
78740 658314729 989301 885240 70540 2700 ACH 7931816 3/17/17 evans45
44420 842895157 321086 220350 46570 10800 Wire 8040863 3/17/17 evans45
60244 640498345 608706 995065 60873 10800 ACH 2874104 5/20/17 evans45
77810 321782506 980052 306560 54891 900 3760 Check 3/24/17 evans45
62441 508089512 654255 306504 51869 1800 ACH 8213417 3/17/17 evans45
33201 508089512 669521 201050 20756 1800 ACH 5733250 3/17/17 evans45
54400 842895157 891247 302090 10298 800 Wire 8290834 3/17/17 evans45
95520 508089512 880320 305408 13354 900 ACH 6946108 3/17/17 evans45
41014 658314729 808604 668071 13354 900 ACH 5222664 3/17/17 evans45
66254 508089512 332556 305038 45204 900 ACH 9065406 3/18/17 evans45
71001 912086047 980350 605068 70554 900 Wire 9090562 3/20/17 evans45
54044 912086047 506795 996055 70015 1000 Wire 9758261 3/24/17 tang78
60503 912086047 894632 160530 65480 2040 Wire 4672367 3/25/17 tang78
38577 504796147 641589 775041 30574 2720 9977 Check 3/25/17 tang78
24770 667057064 223149 335047 65076 2720 Wire 9879654 3/18/17 tang78
62312 114058620 283649 421963 51182 8800 2966 Check 3/18/17 tang78
95036 560191569 577616 903553 77875 11000 ACH 5020066 3/24/17 tang78
42438 484071188 517699 490474 93499 11000 Wire 7294039 3/24/17 tang78
37469 246761437 947560 550513 84543 44000 2375 Check 3/18/17 tang78
81464 838679702 326574 87363 88000 ACH 2858377 3/20/17 tang78
55769 145751240 241754 888176 52581 66000 ACH 8405146 3/24/17 tang78
25844 398064250 839886 400848 99505 88000 ACH 9332864 3/25/17 song99
73764 835731031 777700 233648 86366 22000 Wire 6368825 3/17/17 song99
33424 949644180 455839 657405 69988 1920 Wire 3424273 3/20/17 song99
45956 525911359 383349 631528 58853 1920 1506 Check 5/20/17 song99
11013 573426003 355971 508724 43146 1500 2280 Check 3/20/17 song99
70807 761344326 511568 608445 11879 1215 6906 Check 3/25/17 song99
27362 266304285 711945 378076 67612 1350 7316 Check 3/25/17 song99
12274 453904299 642027 733501 92493 2025 Wire 6566325 3/25/17 song99
17862 189185611 626749 911798 72371 1800 Wire 5000035 3/17/17 song99
35055 311488387 234101 849906 25203 2400 1487 Check 3/17/17 song99
74457 743296602 343572 484867 82392 2400 ACH 6566794 3/20/17 song99
33907 886855566 136556 171088 18523 1200 ACH 3037893 4/24/17 song99
58410 180683546 592472 627590 92746 900 2655 Check 3/17/17 song99
63127 625430903 454150 466692 90870 1200 ACH 7221968 3/17/17 song99
37452 636531627 646490 220595 38535 900 Wire 2399271 3/17/17 song99
92730 145751240 540782 630399 37945 900 ACH 4412623 3/17/17 song99
34563 949644180 672029 419203 78884 7650 Wire 4479059 3/17/17 angelon33
82874 180683546 938749 948037 56971 8500 9902 Check 3/18/17 angelon33
34828 625430903 212257 350157 13836 8500 ACH 3937362 3/20/17 angelon33
52203 145751240 662797 730615 41510 8500 ACH 2594600 3/24/17 angelon33
25061 842895157 831855 877919 16515 550 Wire 8844939 3/25/17 angelon33
67411 508089512 540429 852032 64930 550 ACH 9516623 3/25/17 angelon33
80269 658314729 621406 159338 64270 400 ACH 8045845 3/18/17 angelon33
89119 508089512 872673 629485 57320 2200 ACH 9347350 3/18/17 angelon33
24676 266304285 140814 384074 23564 5500 6110 Check 3/24/17 angelon33
88572 453904299 551885 648746 99319 5500 Wire 2640078 3/24/17 angelon33
55333 189185611 427158 530028 99319 5500 Wire 9423003 3/18/17 angelon33
98553 311488387 676707 128595 27488 990 3370 Check 3/20/17 hernandez56
66151 453904299 682857 777694 55228 2880 Wire 9743611 3/24/17 hernandez56
48910 453904299 289016 758803 83963 3200 Wire 6786263 4/25/17 hernandez56
40134 949644180 129602 190129 98724 3200 Wire 6566286 3/17/17 hernandez56
24577 266304285 697511 815548 38062 2025 4230 Check 3/20/17 hernandez56
22837 453904299 858617 661535 98450 2025 Wire 2464880 3/20/17 hernandez56
55754 453904299 380587 964485 28804 2025 Wire 4759296 3/20/17 hernandez56
65769 189185611 872939 671613 47146 1200 Wire 1679385 3/25/17 hernandez56
46769 189185611 734204 724601 98311 1200 Wire 8147507 3/25/17 hernandez56
58290 949644180 693994 502438 80903 1200 Wire 9098388 3/25/17 hernandez56
16016 761344326 409852 172474 48839 10700 2950 Check 3/17/17 hernandez56
28940 266304285 703289 131887 81049 10800 2351 Check 3/17/17 hernandez56
46337 453904299 224586 474872 88631 6000 Wire 6187365 3/20/17 hernandez56
35315 189185611 421502 14630 4800 Wire 4664130 3/24/17 hernandez56
47853 761344326 168182 284898 18095 3000 9186 Check 3/17/17 hernandez56
60191 761344326 898293 406525 99410 8500 8834 Check 3/17/17 sousa33
64680 266304285 537285 745522 46566 8500 1245 Check 3/17/17 sousa33
58965 658314729 388032 790081 65465 12750 ACH 9982887 3/17/17 sousa33
20312 504796147 112154 156360 74018 17000 3718 Check 3/17/17 sousa33
48121 640498345 441859 596874 43515 14300 ACH 8118357 3/18/17 sousa33
87975 114058620 951471 821652 55892 14300 8477 Check 3/20/17 sousa33
17780 842895157 931171 285517 75922 11000 Wire 6247429 3/24/17 sousa33
88614 912086047 712492 752287 76000 15400 Wire 9831076 3/25/17 sousa33
40953 504796147 785661 780515 55508 44000 7456 Check 3/25/17 sousa33
82196 640498345 146199 650796 42890 44000 ACH 3032260 3/18/17 sousa33
93644 114058620 722371 763429 60820 44000 7581 Check 3/18/17 sousa33
13572 114058620 827090 710193 90829 22000 3304 Check 3/24/17 schmitz62
60321 842895157 265858 284290 13291 2560 Wire 9629230 3/24/17 schmitz62
35989 912086047 810693 250908 51041 2560 Wire 6457978 3/18/17 schmitz62
17716 842895157 810028 812876 90147 3840 Wire 1132436 3/20/17 schmitz62
11852 508089512 737807 481466 51072 12150 ACH 3567120 3/24/17 schmitz62
93418 658314729 294920 540858 80563 24300 ACH 1449984 3/25/17 schmitz62
74055 658314729 960397 789820 20346 12150 ACH 2135701 3/17/17 schmitz62
30687 842895157 959408 741224 32878 7800 Wire 5811413 3/20/17 schmitz62
46127 508089512 232472 592068 43328 6000 ACH 5955487 3/20/17 schmitz62
39865 658314729 466650 838584 43328 6000 ACH 2611232 3/20/17 schmitz62
49974 508089512 906530 335823 75418 6000 ACH 1577122 3/25/17 schmitz62
80575 842895157 650456 65070 6000 Wire 2566504 3/25/17 schmitz62
40782 508089512 650472 608545 86075 6000 ACH 4656531 5/25/17 schmitz62
99863 658314729 305652 708504 69962 8400 ACH 5970844 3/17/17 schmitz62
25535 508089512 552210 650807 44122 6000 ACH 3826085 3/17/17 schmitz62

Payroll

Pay Type Date of Payment Employee ID Employee Type Hours Worked Pay Medical Savings Tax (10%) Year End Bonus Total Pay
1st and 15th 3/1/17 728212 Salary $ 2,917 400 58 $ 291.67 $ 7,000.00 $ 9,166.67
1st and 15th 3/1/17 530855 Salary $ 5,833 800 233 $ 583.33 $ 28,000.00 $ 32,216.67
1st and 15th 3/1/17 818434 Salary $ 3,333 200 167 $ 333.33 $ 2,633.33
1st and 15th 3/1/17 411738 Salary $ 14,583 100 583 $ 1,458.33 $ 70,000.00 $ 82,441.67
bi-weekly 3/1/17 443504 Hourly 80 $1,360 200 41 $ 136.00 $ 983.20
1st and 15th 3/1/17 988985 Salary $ 15,417 100 617 $ 1,541.67 $ 74,000.00 $ 87,158.33
1st and 15th 3/1/17 140951 Salary $ 12,500 100 625 $ 1,250.00 $ 60,000.00 $ 70,525.00
1st and 15th 3/1/17 364970 Salary $ 2,500 800 50 $ 250.00 $ 1,400.00
1st and 15th 3/1/17 207549 Salary $ 7,500 100 225 $ 750.00 $ 36,000.00 $ 42,425.00
1st and 15th 3/1/17 214711 Salary $ 8,750 400 438 $ 875.00 $ 42,000.00 $ 49,037.50
1st and 15th 3/1/17 737865 Salary $ 6,667 600 333 $ 666.67 $ 32,000.00 $ 37,066.67
1st and 15th 3/1/17 902531 Salary $ 3,125 100 $ 125.00 $ 312.50 $ 7,500.00 $ 2,587.50
1st and 15th 3/1/17 859684 Salary $ 3,333 400 $ 33.33 $ 333.33 $ 8,000.00 $ 10,566.67
1st and 15th 3/1/17 436069 Salary $ 3,333 400 $ 100.00 $ 333.33 $ 2,500.00
1st and 15th 3/1/17 421536 Salary $ 3,333 400 $ 100.00 $ 333.33 $ 2,500.00
1st and 15th 3/1/17 919592 Salary $ 3,333 400 133 $ 333.33 $ 2,466.67
1st and 15th 3/1/17 468109 Salary $ 2,917 600 58 $ 291.67 $ 7,000.00 $ 8,966.67
bi-weekly 3/1/17 928211 Hourly 80 $ 960 100 19 $ 96.00 $ 744.80
1st and 15th 3/1/17 202964 Salary $ 3,542 200 106 $ 354.17 $ 2,881.25
bi-weekly 3/1/17 928300 Hourly 80 $ 960 100 19 $ 96.00 $ 744.80
bi-weekly 3/1/17 734850 Hourly 80 $ 960 400 $ 19.20 $ 96.00 $ 444.80
bi-weekly 3/1/17 442007 Hourly 85 $ 1,488 800 $ 29.75 $ 148.75 $ 509.00
bi-weekly 3/1/17 516529 Hourly 80 $ 1,120 600 $ 33.60 $ 112.00 $ 374.40
bi-weekly 3/1/17 489483 Hourly 85 $ 1,138 100 $ 11.38 $ 113.75 $ 912.38
bi-weekly 3/1/17 562104 Hourly 80 $ 1,120 400 $ 11.20 $ 112.00 $ 596.80
bi-weekly 3/1/17 912177 Hourly 85 $ 1,225 100 $ 12.25 $ 122.50 $ 990.25
bi-weekly 3/1/17 480628 Hourly 80 $ 1,440 200 $ 43.20 $ 144.00 $ 1,052.80
bi-weekly 3/1/17 335667 Hourly 85 $ 1,530 200 $ 61.20 $ 153.00 $ 1,115.80
1st and 15th 3/1/17 764951 Salary $ 3,125 400 $ 125.00 $ 312.50 $ 7,500.00 $ 2,287.50
1st and 15th 3/1/17 651326 Salary $ 3,167 1200 $ 31.67 $ 316.67 $ 7,600.00 $ 9,618.33
1st and 15th 3/1/17 243927 Salary $ 3,542 800 $ 35.42 $ 354.17 $ 2,352.08
bi-weekly 3/1/17 877436 Hourly 80 $ 1,440 400 29 $ 144.00 $ 867.20
bi-weekly 3/1/17 320589 Hourly 80 $ 960 200 10 $ 96.00 $ 654.40
1st and 15th 3/1/17 738082 Salary $ 3,333 400 167 $ 333.33 $ 2,433.33
1st and 15th 3/1/17 373488 Salary $ 5,417 600 217 $ 541.67 $ 4,058.33
bi-weekly 3/1/17 600681 Hourly 80 $ 960 100 10 $ 96.00 $ 754.40
bi-weekly 3/1/17 695004 Hourly 85 $ 1,050 200 21 $ 105.00 $ 724.00
bi-weekly 3/1/17 156007 Hourly 80 $ 960 100 29 $ 96.00 $ 735.20
bi-weekly 3/1/17 958349 Hourly 80 $ 1,120 200 $ 56.00 $ 112.00 $ 752.00
bi-weekly 3/1/17 732557 Hourly 80 $ 1,120 100 $ 33.60 $ 112.00 $ 874.40
bi-weekly 3/1/17 240663 Hourly 85 $ 1,050 600 $ 21.00 $ 105.00 $ 324.00
bi-weekly 3/1/17 107040 Hourly 85 $ 979 100 $ 48.93 $ 97.85 $ 731.73
bi-weekly 3/1/17 285683 Hourly 80 $ 960 100 $ 38.40 $ 96.00 $ 725.60
bi-weekly 3/1/17 512204 Hourly 80 $ 960 100 $ 38.40 $ 96.00 $ 725.60
bi-weekly 3/1/17 952375 Hourly 80 $ 960 100 $ 19.20 $ 96.00 $ 744.80
bi-weekly 3/1/17 968276 Hourly 85 $ 1,020 100 $ 51.00 $ 102.00 $ 767.00
bi-weekly 3/1/17 406361 Hourly 80 $ 1,440 200 $ 57.60 $ 144.00 $ 1,038.40
bi-weekly 3/1/17 964067 Hourly 80 $ 1,520 400 $ 76.00 $ 152.00 $ 892.00
1st and 15th 3/1/17 685613 Salary $ 3,542 100 $ 106.25 $ 354.17 $ 8,500.00 $ 11,481.25
1st and 15th 3/1/17 716897 Salary $ 3,333 400 $ 166.67 $ 333.33 $ 8,000.00 $ 10,433.33
1st and 15th 3/1/17 278656 Salary $ 3,542 400 $ 35.42 $ 354.17 $ 2,752.08
1st and 15th 3/1/17 400347 Salary $ 3,333 400 $ 100.00 $ 333.33 $ 2,500.00
1st and 15th 3/1/17 738090 Salary $ 3,333 600 167 $ 333.33 $ 2,233.33
bi-weekly 3/1/17 291210 Hourly 80 $ 960 100 38 $ 96.00 $ 725.60
bi-weekly 3/1/17 695573 Hourly 80 $ 960 100 10 $ 96.00 $ 754.40
1st and 15th 3/1/17 373490 Salary $ 5,417 400 217 $ 541.67 $ 4,258.33
bi-weekly 3/1/17 996092 Hourly 80 $ 960 200 19 $ 96.00 $ 644.80
bi-weekly 3/1/17 877510 Hourly 85 $ 1,575 400 32 $ 157.50 $ 986.00
bi-weekly 3/1/17 492006 Hourly 80 $ 960 100 $ 38.40 $ 96.00 $ 725.60
bi-weekly 3/1/17 127375 Hourly 80 $ 960 100 $ 28.80 $ 96.00 $ 735.20
bi-weekly 3/1/17 895337 Hourly 80 $ 1,120 400 $ 11.20 $ 112.00 $ 596.80
bi-weekly 3/1/17 315734 Hourly 80 $ 1,200 400 $ 36.00 $ 120.00 $ 644.00
bi-weekly 3/1/17 517219 Hourly 85 $ 1,313 100 $ 26.25 $ 131.25 $ 1,055.00
bi-weekly 3/1/17 879169 Hourly 80 $ 1,120 100 $ 11.20 $ 112.00 $ 896.80
bi-weekly 3/1/17 433077 Hourly 80 $ 1,440 100 $ 28.80 $ 144.00 $ 1,167.20
bi-weekly 3/1/17 862486 Hourly 80 $ 1,520 100 $ 30.40 $ 152.00 $ 1,237.60
1st and 15th 3/1/17 819342 Salary $ 3,333 200 $ 33.33 $ 333.33 $ 8,000.00 $ 2,766.67
1st and 15th 3/1/17 969492 Salary $ 3,125 100 $ 156.25 $ 312.50 $ 7,500.00 $ 10,056.25
1st and 15th 3/1/17 103369 Salary $ 3,333 200 $ 166.67 $ 333.33 $ 2,633.33
bi-weekly 3/1/17 917287 Hourly 80 $ 960 100 19 $ 96.00 $ 744.80
bi-weekly 3/1/17 877522 Hourly 80 $ 1,440 400 29 $ 144.00 $ 867.20
1st and 15th 3/1/17 373499 Salary $ 5,417 400 217 $ 541.67 $ 4,258.33
bi-weekly 3/1/17 996123 Hourly 80 $ 960 200 19 $ 96.00 $ 644.80
bi-weekly 3/1/17 695583 Hourly 80 $ 960 100 10 $ 96.00 $ 754.40
1st and 15th 3/1/17 738112 Salary $ 3,333 800 167 $ 333.33 $ 2,033.33
bi-weekly 3/1/17 905820 Hourly 80 $ 1,040 600 $ 10.40 $ 104.00 $ 325.60
bi-weekly 3/1/17 992465 Hourly 80 $ 960 200 $ 48.00 $ 96.00 $ 616.00
bi-weekly 3/1/17 732887 Hourly 80 $ 960 200 $ 48.00 $ 96.00 $ 616.00
bi-weekly 3/1/17 910229 Hourly 80 $ 960 100 $ 48.00 $ 96.00 $ 716.00
bi-weekly 3/1/17 231815 Hourly 80 $ 960 100 $ 19.20 $ 96.00 $ 744.80
bi-weekly 3/1/17 333657 Hourly 85 $ 1,225 100 $ 24.50 $ 122.50 $ 978.00
bi-weekly 3/1/17 287819 Hourly 85 $ 1,225 400 $ 12.25 $ 122.50 $ 690.25
bi-weekly 3/1/17 579148 Hourly 85 $ 1,663 400 $ 83.13 $ 166.25 $ 1,013.13
bi-weekly 3/1/17 124436 Hourly 80 $ 1,600 100 $ 48.00 $ 160.00 $ 1,292.00
1st and 15th 3/1/17 485078 Salary $ 2,917 100 $ 116.67 $ 291.67 $ 7,000.00 $ 9,408.33
1st and 15th 3/1/17 297585 Salary $ 2,917 800 $ 87.50 $ 291.67 $ 7,000.00 $ 8,737.50
1st and 15th 3/1/17 777104 Salary $ 3,333 200 $ 133.33 $ 333.33 $ 2,666.67
1st and 15th 3/1/17 728222 Salary $ 3,333 600 67 $ 333.33 $ 8,000.00 $ 10,333.33
1st and 15th 3/1/17 527355 Salary $ 3,542 800 106 $ 354.17 $ 8,500.00 $ 10,781.25
bi-weekly 3/1/17 527600 Hourly 80 $ 960 100 29 $ 96.00 $ 735.20
bi-weekly 3/1/17 877813 Hourly 80 $ 1,120 400 22 $ 112.00 $ 585.60
bi-weekly 3/1/17 728278 Hourly 80 $ 960 100 19 $ 96.00 $ 744.80
bi-weekly 3/1/17 729000 Hourly 85 $ 1,575 100 32 $ 157.50 $ 1,286.00
bi-weekly 3/1/17 527412 Hourly 80 $ 1,440 100 43 $ 144.00 $ 1,152.80
bi-weekly 3/1/17 527812 Hourly 80 $ 1,440 100 43 $ 144.00 $ 1,152.80
bi-weekly 3/1/17 877973 Hourly 85 $ 1,445 400 29 $ 144.50 $ 871.60
bi-weekly 3/1/17 728333 Hourly 80 $ 1,360 100 58 $ 136.00 $ 1,065.67
1st and 15th 3/1/17 960444 Salary $ 2,917 400 $ 29.17 $ 291.67 $ 7,000.00 $ 9,195.83
1st and 15th 3/1/17 529223 Salary $ 3,167 400 $ 158.33 $ 316.67 $ 7,600.00 $ 9,891.67
1st and 15th 3/1/17 252858 Salary $ 3,542 800 $ 35.42 $ 354.17 $ 2,352.08

Purchase Order

PO # Location Item Description Item Quantity Unit Cost Total Amount Vendor # Creator ID Creation Date Creation Time Approver ID Approver Date Approver Time
323205 200 131 Toy Car Wheels 100 $15.00 1500 321782506 gutierrez39 3/8/17 5:50 young68 3/9/17 4:05
405605 200 132 Toy Car Doors 50 $15.00 750 658314729 gutierrez39 3/8/17 12:08 young68 3/9/17 3:40
650351 200 133 Toy Car Window 50 $15.00 750 658314729 gutierrez39 3/14/17 5:07 young68 3/15/17 10:45
795652 200 134 Toy Car Lights 50 $15.00 750 504796147 gutierrez39 3/14/17 5:12 young68 3/15/17 10:22
749207 200 250 Doll Red Hair 200 $20.00 4000 640498345 gutierrez39 3/8/17 11:07 young68 3/9/17 3:05
998053 200 251 Doll Black Hair 300 $20.00 6000 114058620 gutierrez39 3/10/17 11:54 young68 3/11/17 3:41
798350 200 252 Doll Blond Hair 200 $20.00 4000 842895157 gutierrez39 3/14/17 9:36 young68 3/15/17 11:50
504377 200 253 Doll Dress 600 $20.00 12000 912086047 gutierrez39 3/15/17 3:56 young68 3/16/17 7:10
410560 200 254 Doll Legs 500 $20.00 10000 667057064 gutierrez39 3/7/17 7:45 young68 3/8/17 1:20
540576 200 255 Doll Arms 500 $20.00 10000 508089512 adams75 3/10/17 4:45 young68 3/11/17 6:50
132086 200 256 Doll Eyes 2000 $20.00 40000 504796147 adams75 3/10/17 7:12 young68 3/11/17 5:02
321460 200 257 Doll Pants Outfit 1500 $20.00 30000 912086047 adams75 3/10/17 2:46 young68 3/11/17 4:22
305403 200 320 Video Game Case 400 $30.00 12000 321782506 adams75 3/15/17 11:00 jackson12 3/16/17 5:23
609327 200 321 Video Game Disk 450 $30.00 13500 108906507 adams75 3/15/17 8:06 jackson12 3/16/17 10:30
650899 200 322 Video Game Label 450 $30.00 13500 504796147 adams75 3/15/17 4:56 jackson12 3/16/17 7:58
989301 200 440 Scooter Base 100 $25.00 2500 658314729 adams75 3/7/17 3:04 jackson12 3/8/17 6:52
321086 200 441 Scooter Wheels 400 $25.00 10000 842895157 green24 3/7/17 1:23 jackson12 3/8/17 5:38
608706 200 442 Scooter Handlebars 400 $25.00 10000 640498345 green24 3/10/17 5:20 jackson12 3/11/17 3:20
980052 200 570 Red Paint 75 $10.00 750 321782506 green24 3/14/17 10:56 jackson12 3/15/17 11:51
654255 200 571 Blue Paint 150 $10.00 1500 508089512 green24 3/7/17 9:25 jackson12 3/8/17 11:56
669521 200 572 Yellow Paint 150 $10.00 1500 508089512 green24 3/7/17 3:25 jackson12 3/8/17 12:27
891247 200 573 Green Paint 75 $10.00 750 842895157 green24 3/7/17 2:44 jackson12 3/8/17 4:02
880320 200 574 Purple Paint 75 $10.00 750 508089512 green24 3/7/17 12:10 jackson12 3/8/17 7:50
808604 200 575 Black Paint 75 $10.00 750 658314729 green24 3/7/17 1:50 jackson12 3/8/17 6:06
332556 200 576 Pink Paint 75 $10.00 750 508089512 green24 3/8/17 7:05 jackson12 3/9/17 7:56
980350 200 577 Orange Paint 75 $10.00 750 912086047 green24 3/10/17 8:43 cheng50 3/11/17 7:33
506795 300 131 Toy Car Wheels 60 $15.00 900 912086047 guo10 3/14/17 6:00 cheng50 3/15/17 12:36
894632 300 132 Toy Car Doors 120 $15.00 1800 912086047 guo10 3/15/17 7:52 cheng50 3/16/17 9:23
641589 300 133 Toy Car Window 160 $15.00 2400 504796147 guo10 3/15/17 1:40 cheng50 3/16/17 4:35
223149 300 134 Toy Car Lights 160 $15.00 2400 667057064 guo10 3/8/17 06:30 cheng50 3/9/17 09:34
283649 300 250 Doll Red Hair 400 $20.00 8000 114058620 guo10 3/8/17 13:54 cheng50 3/9/17 23:23
577616 300 251 Doll Black Hair 500 $20.00 10000 560191569 guo10 3/14/17 05:50 cheng50 3/15/17 13:07
517699 300 252 Doll Blond Hair 500 $20.00 10000 484071188 guo10 3/14/17 20:19 cheng50 3/15/17 15:32
947560 300 253 Doll Dress 2000 $20.00 40000 246761437 guo10 3/8/17 23:56 cheng50 3/9/17 06:03
450055 300 254 Doll Legs 4000 $20.00 80000 838679702 guo10 3/10/17 00:39 huang67 3/11/17 02:56
241754 300 255 Doll Arms 3000 $20.00 60000 145751240 guo10 3/14/17 14:21 huang67 3/15/17 18:07
839886 300 256 Doll Eyes 4000 $20.00 80000 398064250 guo10 3/15/17 01:41 huang67 3/16/17 22:04
777700 300 257 Doll Pants Outfit 1000 $20.00 20000 835731031 guo10 3/7/17 02:48 huang67 3/8/17 05:13
455839 300 320 Video Game Case 60 $30.00 1800 949644180 guo10 3/10/17 16:18 huang67 3/11/17 06:13
383349 300 321 Video Game Disk 60 $30.00 1800 525911359 guo10 3/10/17 19:25 huang67 3/11/17 08:02
355971 300 322 Video Game Label 60 $30.00 1800 573426003 guo10 3/10/17 14:33 huang67 3/11/17 12:28
511568 300 440 Scooter Base 45 $25.00 1125 761344326 guo10 3/15/17 22:29 huang67 3/16/17 20:03
711945 300 441 Scooter Wheels 50 $25.00 1250 266304285 gao24 3/15/17 20:39 huang67 3/16/17 20:02
642027 300 442 Scooter Handlebars 75 $25.00 1875 453904299 gao24 3/15/17 20:08 zhao44 3/16/17 14:14
626749 300 570 Red Paint 150 $10.00 1500 189185611 gao24 3/7/17 22:56 zhao44 3/8/17 21:15
234101 300 571 Blue Paint 200 $10.00 2000 311488387 gao24 3/7/17 23:43 zhao44 3/8/17 18:16
343572 300 572 Yellow Paint 200 $10.00 2000 743296602 gao24 3/10/17 17:51 zhao44 3/11/17 09:26
136556 300 573 Green Paint 100 $10.00 1000 886855566 gao24 3/14/17 12:12 zhao44 3/15/17 06:00
592472 300 574 Purple Paint 75 $10.00 750 180683546 gao24 3/7/17 14:58 zhao44 3/8/17 22:57
454150 300 575 Black Paint 100 $10.00 1000 625430903 gao24 3/7/17 10:17 zhao44 3/8/17 08:23
646490 300 576 Pink Paint 75 $10.00 750 636531627 gao24 3/7/17 16:45 soares52 3/8/17 18:43
540782 300 577 Orange Paint 75 $10.00 750 145751240 gao24 3/7/17 05:54 soares52 3/8/17 17:59
672029 400 131 Toy Car Wheels 450 $15.00 6750 949644180 cortez55 3/7/17 22:45 soares52 3/8/17 15:56
938749 400 132 Toy Car Doors 500 $15.00 7500 180683546 cortez55 3/8/17 18:48 soares52 3/9/17 08:35
212257 400 133 Toy Car Window 500 $15.00 7500 625430903 cortez55 3/10/17 11:20 soares52 3/11/17 16:56
662797 400 134 Toy Car Lights 500 $15.00 7500 145751240 cortez55 3/14/17 08:14 soares52 3/15/17 22:28
831855 400 250 Doll Red Hair 25 $20.00 500 842895157 cortez55 3/15/17 08:53 soares52 3/16/17 13:36
540429 400 251 Doll Black Hair 25 $20.00 500 508089512 cortez55 3/15/17 06:37 soares52 3/16/17 02:24
621406 400 252 Doll Blond Hair 25 $20.00 500 658314729 cortez55 3/8/17 06:02 fernandez65 3/9/17 22:08
872673 400 253 Doll Dress 100 $20.00 2000 508089512 cortez55 3/8/17 21:55 fernandez65 3/9/17 14:38
140814 400 254 Doll Legs 250 $20.00 5000 266304285 cortez55 3/14/17 16:59 fernandez65 3/15/17 03:47
551885 400 255 Doll Arms 250 $20.00 5000 453904299 cortez55 3/14/17 16:22 fernandez65 3/15/17 19:06
427158 400 256 Doll Eyes 250 $20.00 5000 189185611 cortez55 3/8/17 19:31 fernandez65 3/9/17 08:03
676707 400 257 Doll Pants Outfit 45 $20.00 900 311488387 cortez55 3/10/17 06:46 fernandez65 3/11/17 01:55
682857 400 320 Video Game Case 90 $30.00 2700 453904299 cortez55 3/14/17 00:17 fernandez65 3/15/17 01:28
289016 400 321 Video Game Disk 100 $30.00 3000 453904299 cortez55 3/15/17 03:34 rios43 3/16/17 09:10
129602 400 322 Video Game Label 100 $30.00 3000 949644180 rodriguez74 3/7/17 15:36 rios43 3/8/17 19:12
697511 400 440 Scooter Base 75 $25.00 1875 266304285 rodriguez74 3/10/17 23:48 rios43 3/11/17 10:01
858617 400 441 Scooter Wheels 75 $25.00 1875 453904299 rodriguez74 3/10/17 13:53 rios43 3/11/17 19:43
380587 400 442 Scooter Handlebars 75 $25.00 1875 453904299 rodriguez74 3/10/17 19:01 rios43 3/11/17 13:41
872939 400 570 Red Paint 100 $10.00 1000 189185611 rodriguez74 3/15/17 22:47 rios43 3/16/17 15:21
734204 400 571 Blue Paint 100 $10.00 1000 189185611 rodriguez74 3/15/17 16:24 rios43 3/16/17 05:24
693994 400 572 Yellow Paint 100 $10.00 1000 949644180 rodriguez74 3/15/17 10:45 rios43 3/16/17 19:58
409852 400 573 Green Paint 900 $10.00 9000 761344326 rodriguez74 3/7/17 00:46 rios43 3/8/17 12:11
703289 400 574 Purple Paint 900 $10.00 9000 266304285 rodriguez74 3/7/17 03:20 rios43 3/8/17 20:53
224586 400 575 Black Paint 500 $10.00 5000 453904299 rodriguez74 3/10/17 00:08 lopez22 3/11/17 06:37
888955 400 576 Pink Paint 400 $10.00 4000 189185611 rodriguez74 3/14/17 12:27 lopez22 3/15/17 17:28
168182 400 577 Orange Paint 250 $10.00 2500 761344326 rodriguez74 3/7/17 00:24 lopez22 3/8/17 08:27
898293 500 131 Toy Car Wheels 500 $15.00 7500 761344326 allison29 3/7/17 03:27 lopez22 3/8/17 08:53
537285 500 132 Toy Car Doors 500 $15.00 7500 266304285 allison29 3/7/17 12:02 lopez22 3/8/17 15:00
388032 500 133 Toy Car Window 750 $15.00 11250 658314729 allison29 3/7/17 00:48 lopez22 3/8/17 13:23
112154 500 134 Toy Car Lights 1000 $15.00 15000 504796147 allison29 3/7/17 07:23 lopez22 3/8/17 08:14
441859 500 250 Doll Red Hair 650 $20.00 13000 640498345 allison29 3/8/17 12:44 lopez22 3/9/17 21:40
951471 500 251 Doll Black Hair 650 $20.00 13000 114058620 allison29 3/10/17 16:20 melo99 3/11/17 06:27
931171 500 252 Doll Blond Hair 500 $20.00 10000 842895157 allison29 3/14/17 21:59 melo99 3/15/17 04:46
712492 500 253 Doll Dress 700 $20.00 14000 912086047 allison29 3/15/17 14:13 melo99 3/16/17 16:46
785661 500 254 Doll Legs 2000 $20.00 40000 504796147 allison29 3/15/17 18:56 melo99 3/16/17 23:36
146199 500 255 Doll Arms 2000 $20.00 40000 640498345 allison29 3/8/17 17:20 melo99 3/9/17 01:36
722371 500 256 Doll Eyes 2000 $20.00 40000 114058620 allison29 3/8/17 20:47 melo99 3/9/17 08:24
827090 500 257 Doll Pants Outfit 1000 $20.00 20000 114058620 allison29 3/14/17 17:27 melo99 3/15/17 07:25
265858 500 320 Video Game Case 80 $30.00 2400 842895157 allison29 3/14/17 19:13 melo99 3/15/17 07:11
810693 500 321 Video Game Disk 80 $30.00 2400 912086047 allison29 3/8/17 02:20 melo99 3/9/17 16:04
810028 500 322 Video Game Label 120 $30.00 3600 842895157 davidson20 3/10/17 08:09 barbosa24 3/11/17 13:35
737807 500 440 Scooter Base 450 $25.00 11250 508089512 davidson20 3/14/17 20:08 barbosa24 3/15/17 12:39
294920 500 441 Scooter Wheels 900 $25.00 22500 658314729 davidson20 3/15/17 06:06 barbosa24 3/16/17 11:09
960397 500 442 Scooter Handlebars 450 $25.00 11250 658314729 davidson20 3/7/17 06:39 barbosa24 3/8/17 20:11
959408 500 570 Red Paint 650 $10.00 6500 842895157 davidson20 3/10/17 17:57 barbosa24 3/11/17 19:14
232472 500 571 Blue Paint 500 $10.00 5000 508089512 davidson20 3/10/17 10:16 barbosa24 3/11/17 10:02
466650 500 572 Yellow Paint 500 $10.00 5000 658314729 davidson20 3/10/17 12:42 barbosa24 3/11/17 13:01
906530 500 573 Green Paint 500 $10.00 5000 508089512 davidson20 3/15/17 4:55 barbosa24 3/16/17 8:56
856065 500 574 Purple Paint 500 $10.00 5000 842895157 davidson20 3/15/17 5:52 barbosa24 3/16/17 4:56
650472 500 575 Black Paint 750 $10.00 7500 508089512 davidson20 3/15/17 2:20 barbosa24 3/16/17 1:22
305652 500 576 Pink Paint 700 $10.00 7000 658314729 davidson20 3/7/17 1:33 barbosa24 3/8/17 4:07
552210 500 577 Orange Paint 500 $10.00 5000 508089512 davidson20 3/7/17 8:17 barbosa24 3/8/17 5:05

Raw Materials On-hand

Location ID Detailed Location ID Raw Item # Description Quantity Date Received
200 Washington Plant 131 Toy Car Wheels 4000 3/1/17
200 Washington Plant 132 Toy Car Doors 2000 3/1/17
200 Washington Plant 133 Toy Car Window 4000 3/1/17
200 Washington Plant 134 Toy Car Lights 2000 3/1/17
200 Washington Plant 250 Doll Red Hair 300 3/1/17
200 Washington Plant 251 Doll Black Hair 500 3/1/17
200 Washington Plant 252 Doll Blond Hair 500 3/1/17
200 Washington Plant 253 Doll Dress 1500 3/1/17
200 Washington Plant 254 Doll Legs 3000 3/1/17
200 Washington Plant 255 Doll Arms 3000 3/1/17
200 Washington Plant 256 Doll Eyes 3000 3/1/17
200 Washington Plant 257 Doll Pants Outfit 2000 3/1/17
200 Washington Plant 320 Video Game Case 2000 3/1/17
200 Washington Plant 321 Video Game Disk 2000 3/1/17
200 Washington Plant 322 Video Game Label 2000 3/1/17
200 Washington Plant 440 Scooter Base 2000 3/1/17
200 Washington Plant 441 Scooter Wheels 4000 3/1/17
200 Washington Plant 442 Scooter Handlebars 2000 3/1/17
200 Washington Plant 570 Red Paint 1000 3/1/17
200 Washington Plant 571 Blue Paint 1500 3/1/17
200 Washington Plant 572 Yellow Paint 1500 3/1/17
200 Washington Plant 573 Green Paint 800 3/1/17
200 Washington Plant 574 Purple Paint 900 3/1/17
200 Washington Plant 575 Black Paint 700 3/1/17
200 Washington Plant 576 Pink Paint 750 3/1/17
200 Washington Plant 577 Orange Paint 500 3/1/17
300 Shanghai Plant 131 Toy Car Wheels 2000 3/1/17
300 Shanghai Plant 132 Toy Car Doors 1000 3/1/17
300 Shanghai Plant 133 Toy Car Window 2000 3/1/17
300 Shanghai Plant 134 Toy Car Lights 1000 3/1/17
300 Shanghai Plant 250 Doll Red Hair 500 3/1/17
300 Shanghai Plant 251 Doll Black Hair 1000 3/1/17
300 Shanghai Plant 252 Doll Blond Hair 1000 3/1/17
300 Shanghai Plant 253 Doll Dress 3000 3/1/17
300 Shanghai Plant 254 Doll Legs 6000 3/1/17
300 Shanghai Plant 255 Doll Arms 6000 3/1/17
300 Shanghai Plant 256 Doll Eyes 6000 3/1/17
300 Shanghai Plant 257 Doll Pants Outfit 5000 3/1/17
300 Shanghai Plant 320 Video Game Case 3000 3/1/17
300 Shanghai Plant 321 Video Game Disk 3000 3/1/17
300 Shanghai Plant 322 Video Game Label 3000 3/1/17
300 Shanghai Plant 440 Scooter Base 3000 3/1/17
300 Shanghai Plant 441 Scooter Wheels 6000 3/1/17
300 Shanghai Plant 442 Scooter Handlebars 3000 3/1/17
300 Shanghai Plant 570 Red Paint 500 3/1/17
300 Shanghai Plant 571 Blue Paint 1000 3/1/17
300 Shanghai Plant 572 Yellow Paint 1000 3/1/17
300 Shanghai Plant 573 Green Paint 750 3/1/17
300 Shanghai Plant 574 Purple Paint 800 3/1/17
300 Shanghai Plant 575 Black Paint 700 3/1/17
300 Shanghai Plant 576 Pink Paint 900 3/1/17
300 Shanghai Plant 577 Orange Paint 800 3/1/17
400 Mexico City Plant 131 Toy Car Wheels 4000 3/1/17
400 Mexico City Plant 132 Toy Car Doors 2000 3/1/17
400 Mexico City Plant 133 Toy Car Window 3000 3/1/17
400 Mexico City Plant 134 Toy Car Lights 2000 3/1/17
400 Mexico City Plant 250 Doll Red Hair 100 3/1/17
400 Mexico City Plant 251 Doll Black Hair 500 3/1/17
400 Mexico City Plant 252 Doll Blond Hair 500 3/1/17
400 Mexico City Plant 253 Doll Dress 1500 3/1/17
400 Mexico City Plant 254 Doll Legs 3000 3/1/17
400 Mexico City Plant 255 Doll Arms 3000 3/1/17
400 Mexico City Plant 256 Doll Eyes 3000 3/1/17
400 Mexico City Plant 257 Doll Pants Outfit 3000 3/1/17
400 Mexico City Plant 320 Video Game Case 1500 3/1/17
400 Mexico City Plant 321 Video Game Disk 1500 3/1/17
400 Mexico City Plant 322 Video Game Label 1500 3/1/17
400 Mexico City Plant 440 Scooter Base 1000 3/1/17
400 Mexico City Plant 441 Scooter Wheels 2000 3/1/17
400 Mexico City Plant 442 Scooter Handlebars 1000 3/1/17
400 Mexico City Plant 570 Red Paint 300 3/8/17
400 Mexico City Plant 571 Blue Paint 600 3/8/17
400 Mexico City Plant 572 Yellow Paint 400 3/8/17
400 Mexico City Plant 573 Green Paint 450 3/8/17
400 Mexico City Plant 574 Purple Paint 600 3/8/17
400 Mexico City Plant 575 Black Paint 150 3/8/17
400 Mexico City Plant 576 Pink Paint 120 3/8/17
400 Mexico City Plant 577 Orange Paint 150 3/8/17
500 Sao Paolo Plant 131 Toy Car Wheels 1000 3/1/17
500 Sao Paolo Plant 132 Toy Car Doors 500 3/1/17
500 Sao Paolo Plant 133 Toy Car Window 500 3/1/17
500 Sao Paolo Plant 134 Toy Car Lights 500 3/1/17
500 Sao Paolo Plant 250 Doll Red Hair 200 3/1/17
500 Sao Paolo Plant 251 Doll Black Hair 200 3/1/17
500 Sao Paolo Plant 252 Doll Blond Hair 200 3/1/17
500 Sao Paolo Plant 253 Doll Dress 1000 3/1/17
500 Sao Paolo Plant 254 Doll Legs 2000 3/1/17
500 Sao Paolo Plant 255 Doll Arms 2000 3/1/17
500 Sao Paolo Plant 256 Doll Eyes 2000 3/1/17
500 Sao Paolo Plant 257 Doll Pants Outfit 2000 3/1/17
500 Sao Paolo Plant 320 Video Game Case 700 3/1/17
500 Sao Paolo Plant 321 Video Game Disk 700 3/1/17
500 Sao Paolo Plant 322 Video Game Label 700 3/1/17
500 Sao Paolo Plant 440 Scooter Base 500 3/1/17
500 Sao Paolo Plant 441 Scooter Wheels 1000 3/1/17
500 Sao Paolo Plant 442 Scooter Handlebars 500 3/1/17
500 Sao Paolo Plant 570 Red Paint 400 3/8/17
500 Sao Paolo Plant 571 Blue Paint 700 3/8/17
500 Sao Paolo Plant 572 Yellow Paint 800 3/8/17
500 Sao Paolo Plant 573 Green Paint 500 3/8/17
500 Sao Paolo Plant 574 Purple Paint 300 3/8/17
500 Sao Paolo Plant 575 Black Paint 400 3/8/17
500 Sao Paolo Plant 576 Pink Paint 450 3/8/17
500 Sao Paolo Plant 577 Orange Paint 475 3/8/17

Receipt

Receipt ID Location Date Time Item # Item Quantity Truck # Receiver ID Vendor # PO Number
774805 200 3/15/17 09:04 131 100 1030 young68 321782506 323205
665014 200 3/15/17 10:27 132 50 1186 young68 658314729 405605
205068 200 3/8/17 11:15 133 50 5650 young68 658314729 650351
700656 200 3/10/17 13:14 134 50 6057 young68 504796147 795652
985084 200 3/10/17 11:22 250 200 6504 young68 640498345 749207
146505 200 3/14/17 14:00 251 300 6455 young68 114058620 998053
606807 200 3/15/17 09:36 252 200 6505 young68 842895157 798350
420447 200 3/20/17 08:22 253 600 1024 young68 912086047 504377
980752 200 3/14/17 15:24 254 500 7708 young68 667057064 410560
950400 200 3/17/17 10:11 255 500 5470 young68 508089512 540576
110501 200 3/15/17 14:32 256 2000 3204 young68 504796147 132086
607802 200 3/14/17 10:38 257 1500 5520 young68 912086047 321460
654650 200 3/8/17 12:35 320 400 3506 jackson12 321782506 305403
906503 200 3/15/17 12:59 321 450 5042 jackson12 108906507 609327
980605 200 3/20/17 15:20 322 450 7855 jackson12 504796147 650899
885240 200 3/20/17 15:16 440 100 8840 jackson12 658314729 989301
220350 200 3/14/17 14:15 441 400 3302 jackson12 842895157 321086
995065 200 3/15/17 13:34 442 400 7980 jackson12 640498345 608706
306560 200 3/10/17 15:03 570 75 1011 jackson12 321782506 980052
306504 200 3/17/17 14:38 571 150 5708 jackson12 508089512 654255
201050 200 3/17/17 16:40 572 150 9806 jackson12 508089512 669521
302090 200 3/17/17 12:08 573 75 3020 jackson12 842895157 891247
305408 200 3/8/17 14:23 574 75 5068 jackson12 508089512 880320
668071 200 3/10/17 16:46 575 75 1040 jackson12 658314729 808604
305038 200 3/10/17 16:57 576 75 9065 jackson12 508089512 332556
605068 200 3/15/17 15:55 577 75 9807 jackson12 912086047 980350
996055 300 3/15/17 10:32 131 60 3140 cheng50 912086047 506795
160530 300 3/8/17 09:49 132 120 1444 cheng50 912086047 894632
775041 300 3/10/17 12:47 133 160 9995 cheng50 504796147 641589
335047 300 3/10/17 08:25 134 160 8906 cheng50 667057064 223149
421963 300 3/14/17 11:19 250 400 4287 cheng50 114058620 283649
903553 300 3/15/17 11:03 251 500 9695 cheng50 560191569 577616
490474 300 3/20/17 12:41 252 500 7284 cheng50 484071188 517699
550513 300 3/14/17 10:51 253 2000 1602 cheng50 246761437 947560
326574 300 3/17/17 12:04 254 4000 3403 huang67 838679702 450055
888176 300 3/15/17 08:36 255 3000 3202 huang67 145751240 241754
400848 300 3/14/17 13:17 256 4000 8870 huang67 398064250 839886
233648 300 3/8/17 11:38 257 1000 4918 huang67 835731031 777700
657405 300 3/15/17 13:01 320 60 7065 huang67 949644180 455839
631528 300 3/20/17 12:08 321 60 5838 huang67 525911359 383349
508724 300 3/20/17 11:10 322 60 7092 huang67 573426003 355971
608445 300 3/14/17 10:32 440 45 7088 huang67 761344326 511568
378076 300 3/15/17 12:51 441 50 1902 huang67 266304285 711945
733501 300 3/10/17 16:35 442 75 8186 zhao44 453904299 642027
911798 300 3/17/17 12:03 570 150 3823 zhao44 189185611 626749
849906 300 3/17/17 15:44 571 200 2709 zhao44 311488387 234101
484867 300 3/17/17 10:42 572 200 5176 zhao44 743296602 343572
171088 300 3/8/17 08:12 573 100 2562 zhao44 886855566 136556
627590 300 3/10/17 10:01 574 75 5174 zhao44 180683546 592472
466692 300 3/10/17 09:51 575 100 8278 zhao44 625430903 454150
220595 300 3/15/17 12:12 576 75 7245 zhao44 636531627 646490
630399 300 3/15/17 14:19 577 75 3102 zhao44 145751240 540782
419203 400 3/8/17 10:59 131 450 5463 soares52 949644180 672029
948037 400 3/10/17 14:05 132 500 5277 soares52 180683546 938749
350157 400 3/10/17 13:39 133 500 2143 soares52 625430903 212257
730615 400 3/14/17 13:50 134 500 7108 soares52 145751240 662797
877919 400 3/15/17 09:54 250 25 7410 soares52 842895157 831855
852032 400 3/20/17 10:04 251 25 6562 soares52 508089512 540429
159338 400 3/14/17 11:23 252 25 4536 fernandez65 658314729 621406
629485 400 3/17/17 09:48 253 100 9644 fernandez65 508089512 872673
384074 400 3/15/17 14:53 254 250 7759 fernandez65 266304285 140814
648746 400 3/14/17 14:58 255 250 4389 fernandez65 453904299 551885
530028 400 3/8/17 15:56 256 250 6459 fernandez65 189185611 427158
128595 400 3/15/17 13:27 257 45 5339 fernandez65 311488387 676707
777694 400 3/20/17 12:26 320 90 4013 fernandez65 453904299 682857
758803 400 3/20/17 15:12 321 100 6958 rios43 453904299 289016
190129 400 3/14/17 13:44 322 100 8835 rios43 949644180 129602
815548 400 3/15/17 15:46 440 75 9589 rios43 266304285 697511
661535 400 3/10/17 13:14 441 75 7731 rios43 453904299 858617
964485 400 3/17/17 10:35 442 75 6529 rios43 453904299 380587
671613 400 3/17/17 13:03 570 100 6400 rios43 189185611 872939
724601 400 3/17/17 15:23 571 100 1326 rios43 189185611 734204
502438 400 3/8/17 14:02 572 100 1909 rios43 949644180 693994
172474 400 3/10/17 09:57 573 900 5304 rios43 761344326 409852
131887 400 3/10/17 10:02 574 900 5362 rios43 266304285 703289
474872 400 3/15/17 15:00 575 500 3421 rios43 453904299 224586
421502 400 3/15/17 10:28 576 400 1072 rios43 189185611 888955
284898 400 3/8/17 11:54 577 250 3243 rios43 761344326 168182
406525 500 3/10/17 10:46 131 500 6053 lopez22 761344326 898293
745522 500 3/10/17 11:20 132 500 7551 lopez22 266304285 537285
790081 500 3/14/17 12:28 133 750 2122 lopez22 658314729 388032
156360 500 3/15/17 15:13 134 1000 3372 lopez22 504796147 112154
596874 500 3/20/17 12:19 250 650 2795 lopez22 640498345 441859
821652 500 3/14/17 10:23 251 650 1378 melo99 114058620 951471
285517 500 3/17/17 16:07 252 500 2368 melo99 842895157 931171
752287 500 3/15/17 10:23 253 700 4758 melo99 912086047 712492
780515 500 3/14/17 08:13 254 2000 8220 melo99 504796147 785661
650796 500 3/8/17 10:43 255 2000 6609 melo99 640498345 146199
763429 500 3/15/17 14:24 256 2000 8608 melo99 114058620 722371
710193 500 3/20/17 16:48 257 1000 4675 melo99 114058620 827090
284290 500 3/20/17 10:17 320 80 4789 melo99 842895157 265858
250908 500 3/14/17 08:57 321 80 2575 melo99 912086047 810693
812876 500 3/15/17 14:42 322 120 2740 barbosa24 842895157 810028
481466 500 3/10/17 09:23 440 450 6756 barbosa24 508089512 737807
540858 500 3/17/17 16:33 441 900 3621 barbosa24 658314729 294920
789820 500 3/17/17 16:07 442 450 6852 barbosa24 658314729 960397
741224 500 3/17/17 08:50 570 650 3965 barbosa24 842895157 959408
592068 500 3/8/17 15:53 571 500 4050 barbosa24 508089512 232472
838584 500 3/10/17 09:35 572 500 9334 barbosa24 658314729 466650
335823 500 3/10/17 16:37 573 500 5540 barbosa24 508089512 906530
650456 500 3/10/17 4:55 574 500 1114 barbosa24 842895157 856065
608545 500 3/10/17 8:56 575 750 5745 barbosa24 508089512 650472
708504 500 3/10/17 7:23 576 700 1245 barbosa24 658314729 305652
650807 500 3/10/17 1:54 577 500 3582 barbosa24 508089512 552210

Sales

Order ID Order Date Customer ID Item # Quantity Price Promotion Freight Total Price Promised Date Special Order Approver ID Approval Date Shipped Date
297449 3/7/17 686236 101 20 $18.00 none $40.00 $400.00 4/7/17 yes gray74 3/10/17 3/12/17
891809 3/7/17 469752 101 100 $18.00 none $200.00 $2,000.00 4/7/17 no davidson20 3/13/17 3/15/17
845636 3/7/17 456987 101 60 $18.00 none $120.00 $1,200.00 4/7/17 no fleming82 3/13/17 3/18/17
562751 3/12/17 262625 101 50 $18.00 none $100.00 $1,000.00 4/12/17 no fleming82 3/17/17 3/19/17
495177 3/15/17 150613 101 175 $18.00 none $350.00 $3,500.00 4/15/17 no gray74 3/21/17 3/22/17
435805 3/15/17 171210 101 200 $18.00 none $400.00 $4,000.00 4/15/17 no allison29 3/16/17 3/18/17
650884 3/15/17 381482 101 400 $18.00 none $800.00 $8,000.00 4/15/17 no allison29 3/20/17 3/22/17
166543 3/18/17 803403 101 80 $18.00 none $160.00 $1,600.00 4/18/17 yes allison29 3/23/17 4/2/17
603006 3/8/17 789573 102 60 $18.00 none $120.00 $1,200.00 4/8/17 no allison29 3/12/17 3/14/17
424500 3/8/17 467985 102 50 $18.00 none $100.00 $1,000.00 4/8/17 no davidson20 3/12/17 3/14/17
361980 3/18/17 794696 102 150 $18.00 5% $300.00 $2,850.00 4/18/17 no davidson20 3/22/17 3/24/17
451790 3/7/17 123765 103 80 $18.00 none $160.00 $1,600.00 4/7/17 no fleming82 3/11/17 3/13/17
879393 3/10/17 540805 103 60 $18.00 none $120.00 $1,200.00 4/10/17 yes davidson20 3/17/17 3/19/17
875611 3/18/17 742393 103 125 $18.00 none $250.00 $2,500.00 4/18/17 no allison29 3/23/17 3/25/17
188672 3/11/17 650054 104 75 $18.00 5% $150.00 $1,425.00 4/11/17 no fleming82 3/14/17 3/16/17
439867 3/11/17 711928 104 140 $18.00 none $280.00 $2,800.00 4/11/17 no fleming82 3/17/17 3/19/17
533992 3/18/17 196586 104 90 $18.00 none $180.00 $1,800.00 4/18/17 no fleming82 4/17/17 4/25/17
685011 3/11/17 155332 105 50 $18.00 none $100.00 $1,000.00 4/11/17 no davidson20 3/16/17 3/22/17
903166 3/11/17 900751 105 65 $18.00 none $130.00 $1,300.00 4/11/17 no fleming82 3/16/17 3/18/17
906826 3/12/17 734057 105 45 $18.00 none $90.00 $900.00 4/12/17 yes fleming82 3/16/17 3/18/17
470269 3/18/17 222550 105 60 $18.00 none $120.00 $1,200.00 4/18/17 yes fleming82 3/23/17 4/3/17
347507 3/18/17 958925 204 60 $20.00 none $180.00 $1,380.00 4/18/17 no fleming82 3/22/17 3/25/17
748962 3/7/17 386423 211 300 $20.00 none $900.00 $6,900.00 4/7/17 no fleming82 3/11/17 3/13/17
789536 3/8/17 670632 211 30 $20.00 none $90.00 $690.00 4/8/17 yes allison29 3/28/17 4/4/17
851691 3/8/17 346967 211 200 $20.00 none $600.00 $4,600.00 4/8/17 no davidson20 3/12/17 3/14/17
538363 3/10/17 598734 211 80 $20.00 none $240.00 $1,840.00 4/10/17 no gray74 3/13/17 3/25/17
834887 3/12/17 761623 211 70 $20.00 none $210.00 $1,610.00 4/12/17 no davidson20 3/17/17 3/19/17
375669 3/15/17 460542 211 30 $20.00 none $90.00 $690.00 4/15/17 no davidson20 3/18/17 3/20/17
811308 3/17/17 299769 211 60 $20.00 none $180.00 $1,380.00 4/17/17 no gray74 3/23/17 3/25/17
192195 3/11/17 907806 212 120 $20.00 none $360.00 $2,760.00 4/11/17 yes gray74 3/15/17 3/17/17
787447 3/12/17 531968 212 100 $20.00 none $300.00 $2,300.00 4/12/17 no allison29 3/16/17 3/18/17
878464 3/12/17 162033 212 150 $20.00 none $450.00 $3,450.00 4/12/17 yes gray74 3/15/17 3/17/17
374508 3/12/17 369148 212 60 $20.00 none $180.00 $1,380.00 4/12/17 no allison29 3/17/17 3/19/17
918398 3/17/17 936655 212 70 $20.00 none $210.00 $1,610.00 4/17/17 no gray74 3/24/17 4/3/17
796183 3/18/17 294782 212 80 $20.00 none $240.00 $1,840.00 4/18/17 no gray74 3/22/17 4/3/17
858373 3/7/17 783674 213 150 $20.00 5% $450.00 $3,277.50 4/7/17 no fleming82 3/10/17 3/12/17
151650 3/8/17 127057 213 180 $20.00 none $540.00 $4,140.00 4/8/17 yes allison29 3/13/17 3/15/17
136173 3/8/17 368752 213 80 $20.00 none $240.00 $1,840.00 4/8/17 no fleming82 3/11/17 3/13/17
703002 3/12/17 299808 213 90 $20.00 none $270.00 $2,070.00 4/12/17 no allison29 3/15/17 3/17/17
144248 3/12/17 464026 213 75 $20.00 none $225.00 $1,725.00 4/12/17 no allison29 3/17/17 3/19/17
425821 3/15/17 644503 213 40 $20.00 none $120.00 $920.00 4/15/17 no gray74 3/21/17 3/23/17
639808 3/11/17 413404 214 150 $20.00 none $450.00 $3,450.00 4/11/17 yes allison29 3/15/17 3/17/17
331480 3/12/17 844070 214 80 $20.00 none $240.00 $1,840.00 4/12/17 no davidson20 3/15/17 3/17/17
654316 3/15/17 348953 214 100 $20.00 none $300.00 $2,300.00 4/15/17 no davidson20 3/18/17 3/28/17
320654 3/7/17 456785 215 500 $20.00 none $1,500.00 $11,500.00 4/7/17 no gray74 3/11/17 3/13/17
781206 3/15/17 588468 215 500 $20.00 none $1,500.00 $11,500.00 4/15/17 no davidson20 3/20/17 3/21/17
886346 3/17/17 810513 215 80 $20.00 none $240.00 $1,840.00 4/17/17 yes gray74 3/24/17 3/26/17
951264 3/7/17 835679 301 90 $25.00 none $90.00 $2,340.00 4/7/17 yes fleming82 3/10/17 3/12/17
226057 3/7/17 237542 301 300 $25.00 none $300.00 $7,800.00 4/7/17 no gray74 3/11/17 3/13/17
469530 3/10/17 650780 301 150 $25.00 5% $150.00 $3,705.00 4/10/17 no allison29 3/15/17 3/17/17
270550 3/10/17 522148 301 160 $25.00 none $160.00 $4,160.00 4/10/17 no allison29 3/17/17 3/19/17
703747 3/10/17 650470 301 60 $25.00 none $60.00 $1,560.00 4/10/17 no davidson20 3/15/17 3/19/17
919359 3/11/17 780754 301 40 $25.00 none $40.00 $1,040.00 4/11/17 yes allison29 3/14/17 3/16/17
142455 3/11/17 756247 301 100 $25.00 none $100.00 $2,600.00 4/11/17 no allison29 3/17/17 3/19/17
253625 3/15/17 322237 301 60 $25.00 none $60.00 $1,560.00 4/15/17 no fleming82 3/18/17 3/22/17
422494 3/17/17 713577 301 160 $25.00 none $160.00 $4,160.00 4/17/17 no davidson20 3/22/17 3/24/17
160400 3/7/17 874239 302 150 $25.00 none $150.00 $3,900.00 4/7/17 no allison29 3/12/17 3/14/17
945942 3/7/17 679346 302 40 $25.00 none $40.00 $1,040.00 4/7/17 no allison29 3/10/17 3/12/17
313958 3/8/17 969873 302 150 $25.00 none $150.00 $3,900.00 4/8/17 yes allison29 3/12/17 3/14/17
411891 3/8/17 236098 302 230 $25.00 none $230.00 $5,980.00 4/8/17 no fleming82 3/11/17 3/12/17
470794 3/10/17 698236 302 100 $25.00 none $100.00 $2,600.00 4/10/17 no gray74 3/14/17 3/16/17
725746 3/15/17 212009 302 65 $25.00 none $65.00 $1,690.00 4/15/17 no davidson20 3/19/17 3/24/17
194967 3/17/17 412359 302 150 $25.00 none $150.00 $3,900.00 4/17/17 no allison29 3/23/17 3/25/17
374544 3/18/17 643323 302 75 $25.00 none $75.00 $1,950.00 4/18/17 no davidson20 3/24/17 3/26/17
621116 3/7/17 666331 303 90 $25.00 none $90.00 $2,340.00 4/7/17 no davidson20 3/10/17 3/20/17
333981 3/10/17 508624 303 70 $25.00 none $70.00 $1,820.00 4/10/17 no gray74 3/13/17 3/15/17
359632 3/10/17 689534 303 300 $25.00 none $300.00 $7,800.00 4/10/17 no fleming82 3/13/17 3/15/17
598160 3/10/17 110121 303 80 $25.00 none $80.00 $2,080.00 4/10/17 yes allison29 3/17/17 3/25/17
948718 3/10/17 662541 303 40 $25.00 none $40.00 $1,040.00 4/10/17 no davidson20 3/16/17 3/18/17
837894 3/15/17 670619 303 45 $25.00 none $45.00 $1,170.00 4/15/17 no davidson20 3/21/17 3/23/17
268111 3/15/17 363629 303 150 $25.00 none $150.00 $3,900.00 4/15/17 yes gray74 3/18/17 3/20/17
970733 3/17/17 423429 303 75 $25.00 none $75.00 $1,950.00 4/17/17 no davidson20 3/23/17 3/24/17
916366 3/10/17 980672 304 50 $25.00 none $50.00 $1,300.00 4/10/17 no fleming82 3/15/17 3/17/17
567239 3/17/17 664231 304 130 $25.00 none $130.00 $3,380.00 4/17/17 no allison29 3/21/17 3/23/17
993038 3/11/17 882204 305 100 $25.00 none $100.00 $2,600.00 4/11/17 no fleming82 3/16/17 3/18/17
846328 3/11/17 207316 305 100 $25.00 5% $100.00 $2,470.00 4/11/17 yes gray74 3/17/17 3/21/17
545259 3/11/17 877766 305 200 $25.00 none $200.00 $5,200.00 4/11/17 yes davidson20 3/15/17 3/17/17
536388 3/12/17 426276 305 40 $25.00 none $40.00 $1,040.00 4/12/17 no davidson20 3/17/17 3/19/17
246941 3/15/17 737362 305 20 $25.00 none $20.00 $520.00 4/15/17 no gray74 3/20/17 3/22/17
791348 3/17/17 853235 305 30 $25.00 none $30.00 $780.00 4/17/17 yes allison29 3/24/17 3/29/17
972030 3/11/17 650480 401 30 $20.00 none $120.00 $720.00 4/11/17 no fleming82 3/16/17 3/18/17
959223 3/15/17 558621 401 150 $20.00 none $600.00 $3,600.00 4/15/17 no davidson20 3/20/17 3/22/17
323714 3/17/17 215881 401 45 $20.00 none $180.00 $1,080.00 4/17/17 no davidson20 3/22/17 3/23/17
319194 3/11/17 998450 402 40 $20.00 none $160.00 $960.00 4/11/17 no fleming82 3/15/17 3/17/17
688832 3/11/17 402608 402 400 $20.00 none $1,600.00 $9,600.00 4/11/17 no allison29 3/26/17 3/28/17
855952 3/11/17 342951 402 200 $20.00 none $800.00 $4,800.00 4/11/17 no davidson20 3/16/17 3/18/17
418479 3/15/17 166091 402 120 $20.00 none $480.00 $2,880.00 4/15/17 no allison29 3/19/17 3/21/17
215679 3/15/17 496947 402 15 $20.00 5% $60.00 $342.00 4/15/17 yes allison29 4/1/17
476342 3/18/17 625513 402 40 $20.00 none $160.00 $960.00 4/18/17 no fleming82 3/22/17 3/24/17
569629 3/18/17 699058 402 500 $20.00 none $2,000.00 $12,000.00 4/18/17 no gray74 3/21/17 3/31/17
558982 3/11/17 320508 403 45 $20.00 none $180.00 $1,080.00 4/11/17 no gray74 3/14/17 3/16/17
692472 3/11/17 697377 403 300 $20.00 none $2,400.00 $8,400.00 4/11/17 no davidson20 3/15/17 3/17/17
520555 3/18/17 733090 403 20 $20.00 none $80.00 $480.00 4/18/17 no fleming82 3/21/17 3/23/17
348038 3/11/17 554045 404 50 $20.00 none $200.00 $1,200.00 4/11/17 no gray74 3/14/17 3/29/17
104687 3/18/17 997332 404 85 $20.00 none $340.00 $2,040.00 4/18/17 no davidson20 3/24/17 3/25/17
382993 3/11/17 665048 405 120 $20.00 none $480.00 $2,880.00 4/11/17 no allison29 3/14/17 3/19/17
985955 3/11/17 741981 405 200 $20.00 none $800.00 $4,800.00 4/11/17 no fleming82 3/17/17 3/20/17
280936 3/15/17 293068 405 80 $20.00 none $320.00 $1,920.00 4/15/17 no allison29 3/19/17 3/21/17
537443 3/15/17 313274 405 125 $20.00 none $500.00 $3,000.00 4/15/17 yes gray74 3/21/17 3/23/17
812411 3/18/17 304862 405 150 $20.00 none $600.00 $3,600.00 4/18/17 no fleming82 3/22/17 3/24/17

Savings Plan

Savings Plan Plan Description Percentage
Savings A Supreme Savings Plan 5
Savings B High Compensation Savings Plan 4
Savings C Catch Up Savgings Plan 3
Savings D Preferred Savings Plan 2
Savings E Basic Savings Plan 1

Vendor

Vendor ID Vendor Name Address City State Zip Billing Address Billing City Billing State Billing Zip Phone Main Contact Email Payment Terms Payment Method Status Status Change Date Discount Level Discount Period
658314729 Jefferson Group 4650 State Street Los Angeles CA 93544 4650 State Street Los Angeles CA 93544 213-951-4610 Huge Stephens [email protected] Net 15 ACH good 1/1/17 5% 2017
842895157 TGE Inc. 15 South Street Austin TX 78704 15 South Street Austin TX 78704 512-605-4507 Lisa Roberts [email protected] Net 30 Wire good 1/1/17 none none
508089512 Insight Co. 705 Main Street Cleveland OH 44113 705 Main Street Cleveland OH 44113 216-724-3044 Marissa Sell [email protected] Net 10 ACH good 1/1/17 none none
912086047 Standard Inc. 2214 Pine Road Allentown PA 18104 2214 Pine Road Allentown PA 18104 610-782-3005 Roger Maxwell [email protected] Net 60 Wire good 1/1/17 none none
321782506 Wright Group 24 Beach Road Charleston SC 29484 24 Beach Road Charleston SC 29484 843-562-1489 Emile Lopez [email protected] Net 60 Check good 1/1/17 none none
640498345 City Group 982 Main Steet Jacksonville FL 32218 982 Main Steet Jacksonville FL 32218 904-156-0677 Sarah Bellingham [email protected] Net 60 ACH good 1/1/17 5% March
108906507 Simple Co. 2570 George Street Tacoma WA 98405 2570 George Street Tacoma WA 98405 253-885-1608 George Lin [email protected] Net 10 ACH good 1/1/17 none none
504796147 Winger Inc. 10 Fifth street Rapid City SD 57701 10 Fifth street Rapid City SD 57701 605-970-8906 Simon Able [email protected] Net 10 Check good 1/1/17 5% March
667057064 Poll LLC 9876 Evens Avenue Houston TX 77004 9876 Evens Avenue Houston TX 77004 281-460-5530 Karen Limon [email protected] Net 15 Wire good 1/1/17 5% 2017
114058620 Signer LLC 92 Murry Street Albany NY 12084 92 Murry Street Albany NY 12084 518-483-8990 Walter Orange [email protected] Net 30 Check good 1/1/17 none none
560191569 Stark Industries 8 Center Street Biloxi MS 39530 8 Center Street Biloxi MS 39530 228-650-0565 Mary Thompson [email protected] Net 30 ACH good 1/1/17 none none
484071188 EDC Co. 23 Oxford Road Ashland NH 3217 23 Oxford Road Ashland NH 3217 603-908-5247 David Lewis [email protected] Net 10 Wire good 1/1/17 none none
246761437 Lennox Inc. 349 Hillside Drive Portland OR 97201 349 Hillside Drive Portland OR 97201 503-640-6807 Richard Martinez [email protected] Net 60 Check good 1/1/17 none none
838679702 Haften Inc. 109 Monroe Street Camden SC 29020 109 Monroe Street Camden SC 29020 803-530-4420 Daniel Clark [email protected] Net 60 ACH good 1/1/17 none none
145751240 Warren LLC 469 Somerset Drive Austin TX 78701 469 Somerset Drive Austin TX 78701 512-605-0685 Anthony Jones [email protected] Net 30 ACH good 1/1/17 5% March
398064250 Orange Group 890 Mill Road Nashville TN 37201 890 Mill Road Nashville TN 37201 615-560-4751 Dorothy White [email protected] Net 10 ACH good 1/1/17 5% March
835731031 Millstone Inc. 13 Spring Street Logan UT 84321 13 Spring Street Logan UT 84321 435-992-1057 Brian Adams [email protected] Net 60 Wire good 1/1/17 none none
949644180 Funroad LLC 209 Cedar Street Little Rock AR 72201 209 Cedar Street Little Rock AR 72201 501-480-2005 Edward Turner [email protected] Net 60 Wire good 1/1/17 none none
525911359 Teller Co. 182 Central Avenue Beverly Hills CA 90209 182 Central Avenue Beverly Hills CA 90209 310-780-0545 Jason Campbell [email protected] Net 10 Check good 1/1/17 none none
573426003 Reedman Group 109 Shady Lane Hartford CT 6101 109 Shady Lane Hartford CT 6101 860-605-4475 Sharon Rogers [email protected] Net 10 Check good 1/1/17 none none
761344326 Infinity Inc. 451 Westminster Drive Dover DE 19901 451 Westminster Drive Dover DE 19901 302-114-5562 Gary Reed [email protected] Net 15 Check good 1/1/17 none none
266304285 Terra Co. 5 King Street Miami FL 33124 5 King Street Miami FL 33124 786-925-3350 Eric Cooper [email protected] Net 30 Check good 1/1/17 5% 2017
453904299 Welton LLC 562 Magnolia Avenue Springfield IL 62701 562 Magnolia Avenue Springfield IL 62701 413-508-3058 Gregory Howard [email protected] Net 10 Wire good 1/1/17 none none
189185611 Rejuvinate Group 4512 Sunset Drive Des Moines IA 50301 4512 Sunset Drive Des Moines IA 50301 515-660-0085 Pamela Peterson [email protected] Net 10 Wire good 1/1/17 5% 20.17
311488387 Intellect Co. 680 Madison Street Duluth MN 55801 680 Madison Street Duluth MN 55801 218-605-6966 Janet Long [email protected] Net 15 Check good 1/1/17 none none
743296602 Gains Inc. 89 Maiden Road New York NY 10048 89 Maiden Road New York NY 10048 212-058-6085 Tyler Hughes [email protected] Net 30 ACH good 1/1/17 5% March
886855566 Market LLC 13 Grove Street Cleveland OH 44101 13 Grove Street Cleveland OH 44101 216-663-3058 Victoria Powell [email protected] Net 60 ACH good 1/1/17 none none
180683546 Rowens Group 246 Durham Road Beaver WV 53201 246 Durham Road Beaver WV 53201 304-991-0530 Megan Coleman [email protected] Net 30 Check good 1/1/17 none none
625430903 Large Co. 103 Lafayette Street Pinedale WY 82941 103 Lafayette Street Pinedale WY 82941 307-605-6558 Lawrence Prince [email protected] Net 10 ACH good 1/1/17 none none
636531627 Morgan Inc. 490 Evergreen Drive Aberdeen SD 57402 490 Evergreen Drive Aberdeen SD 57402 305-908-0654 Sean Sanders [email protected] Net 60 Wire good 1/1/17 none none
mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected] mailto:[email protected]

Product Master

Finished Items Description Suggested Distributor Price
Black Scooter Scooter superscoop board two wheel 250W Black $42.40
Blue Car Remote control car electrical Blue $33.82
Blue Scooter Scooter superscoop board two wheel 250W Blue $42.50
Brenda Doll Fashion doll female blonde 18in $22.72
Football Video Game 2 Player Football HD $38.54
Green Car Remote control car electrical Green $33.82
Joshua Doll Fashion doll male brunette 18in $22.72
Lacy Doll Fashion doll female red 18in $22.72
Maxwell Doll Fashion doll male blonde 18in $22.72
Military Video Game Multiplayer Military HD $43.22
Orange Scooter Scooter superscoop board two wheel 250W Orange $42.50
Pink Scooter Scooter superscoop board two wheel 250W Pink $42.50
Purple Car Remote control car electrical Purple $33.82
Racing Video Game Single Player Racing HD $43.55 Note: this data was created for purposes of this case study and is completely fictional. Any resemblance to data from a real company / corporation is purely coincidental.
Red Car Remote control car electrical Red $33.82
Sally Doll Fashion doll female black 18in $22.72
Skateboarding Video Game 2 Player Skatepark HD $38.54
Soccer Video Game Muliplayer Soccer HD $43.22
Yellow Car Remote control car electrical Yellow $33.82
Yellow Scooter Scooter superscoop board two wheel 250W Yellow $42.50