Custome
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 gutie
ez39
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 gutie
ez39
236098 The Toy Barn 43 Chance Rd Los Angelas CA 90001 gutie
ez39
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 Fe
y Way Chicago IL 60611 anderson21
698236 Griffin's Toy Emporium 506 Victor Rd Los Angelas CA 90022 gutie
ez39
650780 Carter Toys 654 Park Place Dover DE 19901 anderson21
522148 Parker Toys 74 Pine Street Denver CO 80201 gutie
ez39
110121 Washington Ave. Toys 1001 Washington Ave Sacramento CA 94203 gutie
ez39
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 gutie
ez39
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 Gal
eath 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 gutie
ez39
402608 Rita's Toys 57 First St Bellevue WA 98009 gutie
ez39
756247 Super Mart 2900 Boyles St Pinedale WY 82941 gutie
ez39
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 gutie
ez39
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 A
ey 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 Ha
ison 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 Mo
is 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 Fo
est 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 gutie
ez39
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 gutie
ez39
958925 Games and Things 210 Rive
un 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 to
es69 To
es 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 gutie
ez39 Gutie
ez 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
own58 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 fe
eira21 Fe
eira 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 ba
osa24 Ba
osa 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 Approve
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