Customer Customer IDCustomer NameCustomer AddressCustomer CityCustomer StateCustomer ZipSales Rep 386423Big Mart56 Hanover DrBostonMA02115gray74 686236Mastro Toys12 2nd StNew...

2 answer below »
My assignment is totally based on python please call me i will explain and deadline is on 31st may 6.00 morning


Customer Customer IDCustomer NameCustomer AddressCustomer CityCustomer StateCustomer ZipSales Rep 386423Big Mart56 Hanover DrBostonMA02115gray74 686236Mastro Toys12 2nd StNew YorkNY10022gray74 874239Toy Town350 Hazel AveAtlantaGA31324tanderson 469752Toronto Toy Land4 Main StMinneapolisMN55416mflemming17 456987UniMart12 State StNewark NJ07191gray74 123765Marco's Games and Things156 King's PathSan Diego CA92071gutierrez39 835679Tao's Toys89 George WayWilmingtonDE19806gray74 783674Mega Mart3200 N Charles StBaltimoreMD21218anderson21 456785All Brands Toys22 E Broad StClevelandOH44127fleming82 237542Davidson's Toy House37 Franklin DrCincinnati OH45217gray74 679346House of Games45 Denow RdChicagoIL60611anderson21 666331We Be Toys346 E 22nd StNew YorkNY10020gray74 969873Dysart's Dolls78 Richard's WayCincinnati OH45216fleming82 127057Toy Express67 Johnston StBostonMA02115gray74 670632The Little Shop109 Florence DrAtlantaGA31327anderson21 789573Toy Adventure134 Falls RdNewark NJ07195gray74 467985Big Box Store45 Cold Spring AveBaltimoreMD21210anderson21 346967Toy Haven123 Holly RdSan Diego CA92108gutierrez39 236098The Toy Barn43 Chance RdLos AngelasCA90001gutierrez39 368752Camille's Toy Shoppe59 Duggins AveWilmingtonDE19899gray74 508624Games and Things273 W Holly AveMinneapolisMN55416fleming82 598734The Toy Shop1200 34th StBuffaloNY14214gray74 689534Haley's Toys705 Ferry WayChicagoIL60611anderson21 698236Griffin's Toy Emporium506 Victor RdLos AngelasCA90022gutierrez39 650780Carter Toys654 Park PlaceDoverDE19901anderson21 522148Parker Toys74 Pine StreetDenver CO80201gutierrez39 110121Washington Ave. Toys1001 Washington AveSacramentoCA94203gutierrez39 540805Dogwood Toys782 Dogwood LnHartfordCT06101gray74 662541Toys Unlimited358 Oak StChicagoIL60601fleming82 650470Games and Things223 Mabel StPhoenixAZ85001fleming82 980672Toys and More246 Magee StBeverly HillsCA90209gray74 882204We Be Toys5440 Hillcrest AveMiami FL33124gutierrez39 650480Fun Stop21 Cumberland AvePensacola FL32501smith75 998450Toys for Less132 Main StAtlantaGA30301jones13 320508Big Box Store230 Right AveHonoluluHI96801adams75 554045Mike's120 Browne StDavenportIA52801green24 665048Toys for You902 Shaw StNew OrleansLA70112guo10 780754Fun and Games109 Galbreath RdColdwaterMI49036gao24 907806RTY Toys316 Ferguson AveBaltimoreMD21201cortez55 413404Mega Mart8 Berlin RdSt LouisMO63101rodriguez74 155332Games and Things897 Russell AveReno NV89501ribeiro22 650054Big Box Store78 Dean DrWalhalla ND58282alves20 900751Mello Toys932 Decker DrClevelandOH44179allison29 711928Big Box Store701 Crowe StPortlandOR97201davidson20 741981All Toys875 Main StLogan UT84323gutierrez39 402608Rita's Toys57 First StBellevueWA98009gutierrez39 756247Super Mart2900 Boyles StPinedale WY82941gutierrez39 207316Mega Mart12 Boyer LnBeaverWV25813smith75 342951Arnold's Fun Factory 129 Boak StNewportRI02840jones13 697377Fun Factory 1204 Maple RdSanta FeNM87500adams75 877766Andrew's Toys803 Ash StIndianapolis IN46201gutierrez39 531968Toy Shop190 Pine LnChicagoIL60601guo10 162033We Be Toys1988 Barnes DrBostonMA02115jones13 299808Games and Things103 Baker StNew YorkNY10022jones13 844070Toys and More183 Allen StChicagoIL60611rodriguez74 262625Super Mart594 Apple RdNew YorkNY10020ribeiro22 734057Smith and Company 1930 Abbey LnCincinnati OH45216alves20 426276Boston Toys120 Acre RdBostonMA02115jones13 369148Taylor's124 Albert StAtlantaGA31327davidson20 761623Games and Things685 Harrison StNewark NJ07195smith75 464026We Be Toys86 Highland StClevelandOH44127jones13 293068Toys and More2309 Hill AveCincinnati OH45217jones13 166091Taylor's129 Highview WayNewark NJ07191green24 460542Extravent Toys287 Kildoo RdSan Diego CA92071guo10 670619Toys For You192 King AveWilmingtonDE19806gao24 322237Dover Toys111 Leon DrDoverDE19901cortez55 212009Toys and More133 Loraine StNew YorkNY10020rodriguez74 363629The Toy Shoppe23 Moyer StHartfordCT06101ribeiro22 313274Maxwell's Toy Store1390 Moore StAtlantaGA31324jones13 150613Big Box Store2822 Morris AveMinneapolisMN55416allison29 171210Big Box Store10 Jackson RdEl PasoTX79936davidson20 381482Superstore79 Liberty StNorwalk CA90650ribeiro22 588468Super Mart92 Mill StHouston TX77084ribeiro22 737362All Toys321 Vine StBaltimoreMD21218jones13 558621Game Place99 Walnut LnLakewood NJ08701green24 496947Big Box Store112 Wayne StNashville TN23711guo10 348953Rachel's Toy Spot10 Jefferson StSan Diego CA92154gao24 644503We Be Toys190 Mercer StAlburquerque NM87121cortez55 299769Games and Things58 Nearwood DrAnchorageAK99501rodriguez74 936655Mega Mart7 Forrest RdSacramentoCA94203smith75 810513Superstore273 Round StLittletonCO80120jones13 412359Toys and More22 Scott RdOrlandoFL32801adams75 853235Games and Things109 National LnMontpelierID83254gutierrez39 664231Game Place290 Oak WaySpringfieldIL62701jones13 713577All Toys19 Painter StDes MoinesIA50301jones13 423429Mega Mart2109 Park RdHazard KY41701jones13 215881Toys and More183 Patterson WayDuluth MN55801mflemming17 997332Games and Things19 Main StSt LouisMO63101smith75 304862All Toys173 Hoyt AveClevelandOH44101gray74 733090Toys and More182 Parkwood AveLogan UT84321smith75 625513All Toys112 Pearson StMilwaukeeWI53201gray74 222550Super Mart1029 Pine DrPinedale WY82941gray74 803403We Be Toys343 Pleasentview DrLivingstonNJ07039tanderson 196586Toys and More10 Plum RdAberdeenSD57401mflemming17 794696Fran's Toys342 Point RdPittsburgh PA15201gray74 742393Super Mart193 Ridge StOxfordNC27565gutierrez39 958925Games and Things210 Riverrun RdAshlandNH03217gray74 699058Mega Mart109 Ridgeview StTulsaOK74101anderson21 643323We Be Toys18 Rosewood RdPittsburgh PA15201gray74 294782Big Box Store109 Cascade DrLaurelMT59044anderson21 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 IDUser IDEmployee NameHire DateTermination DateWork LocationJob TitleMedical PlanMedical Start DateSavings PlanSavings Start DateApproval LevelSalary AmountHourly AmountTypePay FrequencyBonus 728212anderson21Anderson7/18/12N/A100Sales RepresentativeD10/16/12D9/16/12$ 70,000Salary1st and 15th 10% 530855baker50Baker2/8/05N/A100Human Resources DirectorC5/9/05B4/9/05$ 140,000Salary1st and 15th 20% 818434gosselin09Gosselin3/23/15N/A100AccountantB6/21/15A5/22/15$ 80,000Salary1st and 15th no 411738huang96Huáng9/6/10N/A100Chief Operating OfficerE12/5/10B11/5/10$ 350,000Salary1st and 15th 20% 443504jenson68Jenson5/6/12N/A100Executive AssistantB8/4/12C7/5/12$17Hourlybi-weeklyno 988985martin69Martin9/12/13N/A100Chief Executive OfficerE12/11/13B11/11/13$ 370,000Salary1st and 15th 20% 140951peacock91Peacock12/6/16N/A100Chief Financial OfficerE3/6/17A2/4/17$ 300,000Salary1st and 15th 20% 364970torres69Torres4/8/11N/A100Human Resources AssociateC7/7/11D6/7/11$ 60,000Salary1st and 15th no 207549zeng86Zēng5/25/10N/A100VP of MarketingE8/23/10C7/24/10$ 180,000Salary1st and 15th 20% 214711zheng79Zhèng2/6/02N/A100VP of SalesD5/7/02A4/7/02$ 210,000Salary1st and 15th 20% 737865zhu36Zhū9/27/08N/A100Marketing Director D12/26/08A11/26/08$ 160,000Salary1st and 15th 20% 902531smith75Smith1/19/15N/A100Sales RepresentativeE4/19/15B3/20/15$ 75,000Salary1st and 15th 10% 859684jones13Jones5/19/17N/A100Sales RepresentativeD8/17/17E7/18/17$ 80,000Salary1st and 15th 10% 436069roberts25Roberts4/25/16N/A100AccountantD7/24/16C6/24/16$ 80,000Salary1st and 15th no 421536arnold79Arnold7/8/09N/A100AccountantA10/6/09C9/6/09$ 80,000Salary1st and 15th no 919592feng42Féng5/6/16N/A200AccountantA8/4/16B7/5/16$ 80,000Salary1st and 15th no 468109gutierrez39Gutierrez7/18/03N/A200Sales RepresentativeD10/16/03D9/16/03$ 70,000Salary1st and 15th 10% 928211masterson50Masterson1/21/14N/A200Line OperatorE4/21/14D3/22/14$12Hourlybi-weeklyno 202964nadeau85Nadeau2/16/10N/A200Maintenance SpecialistB5/17/10C4/17/10$ 85,000Salary1st and 15th no 928300smith22Smith1/25/13N/A200Line OperatorE4/25/13D3/26/13$12Hourlybi-weeklyno 734850johnson25Johnson3/15/11N/A200Line OperatorA6/13/11D5/14/11$12Hourlybi-weeklyno 442007brown58Brown3/8/14N/A200Line OperatorC6/6/14D5/7/14$17Hourlybi-weeklyno 516529williams52Williams6/5/10N/A200Line OperatorD9/3/10C8/4/10$14Hourlybi-weeklyno 489483martin20Martin4/5/15N/A200Line OperatorE7/4/15E6/4/15$13Hourlybi-weeklyno 562104wood52Wood6/7/16N/A200Line OperatorA9/5/16E8/6/16$14Hourlybi-weeklyno 912177scott75Scott 12/1/09N/A200Line OperatorE3/1/10E1/30/10$14Hourlybi-weeklyno 480628young68Young7/8/15N/A200SupervisorB10/6/15C9/6/15$18Hourlybi-weeklyno 335667jackson12Jackson11/12/13N/A200SupervisorB2/10/14B1/11/14$18Hourlybi-weeklyno 764951adams75Adams8/29/13N/A200Sales RepresentativeA11/27/13B10/28/13$ 75,000Salary1st and 15th 10% 651326green24Green5/4/15N/A200Sales RepresentativeC8/2/15E7/3/15$ 76,000Salary1st and 15th 10% 243927evans45Evans7/3/16N/A200AccountantC10/1/16E9/1/16$ 85,000Salary1st and 15th no 877436cheng50Chéng12/16/16N/A300SupervisorA3/16/17D2/14/17$18Hourlybi-weeklyno 320589gagné21Gagné7/18/13N/A300Line OperatorB10/16/13E9/16/13$12Hourlybi-weeklyno 738082garcia76García7/2/15N/A300AccountantD9/30/15A8/31/15$ 80,000Salary1st and 15th no 373488jones69Jones4/8/09N/A300Maintenance SpecialistD7/7/09B6/7/09$ 130,000Salary1st and 15th no 600681ng44Ng6/15/14N/A300Line OperatorE9/13/14E8/14/14$12Hourlybi-weeklyno 695004tau69Tau7/12/11N/A300Line OperatorB10/10/11D9/10/11$12Hourlybi-weeklyno 156007wu32Wú6/8/15N/A300Line OperatorE9/6/15C8/7/15$12Hourlybi-weeklyno 958349wright14Wright8/6/15N/A300Line OperatorB11/4/15A10/5/15$14Hourlybi-weeklyno 732557wang98Wang11/7/13N/A300Line OperatorE2/5/14C1/6/14$14Hourlybi-weeklyno 240663wong74Wong9/22/16N/A300Line OperatorD12/21/16D11/21/16$12Hourlybi-weeklyno 107040li44Li 5/7/15N/A300Line OperatorE8/5/15A7/6/15$12Hourlybi-weeklyno 285683zhang15Zhang6/17/14N/A300Line OperatorE9/15/14B8/16/14$12Hourlybi-weeklyno 512204liu77Liu6/18/13N/A300Line OperatorE9/16/13B8/17/13$12Hourlybi-weeklyno 952375lau12Lau9/8/11N/A300Line OperatorE12/7/11D11/7/11$12Hourlybi-weeklyno 968276yang76Yang8/16/10N/A300Line OperatorE11/14/10A10/15/10$12Hourlybi-weeklyno 406361huang67Huang5/7/11N/A300SupervisorB8/5/11B7/6/11$18Hourlybi-weeklyno 964067zhao44Zhao6/9/14N/A300SupervisorA9/7/14A8/8/14$19Hourlybi-weeklyno 685613guo10Guo4/21/07N/A300Sales RepresentativeE7/20/07C6/20/07$ 85,000Salary1st and 15th 10% 716897gao24Gao1/15/15N/A300Sales RepresentativeA4/15/15A3/16/15$ 80,000Salary1st and 15th 10% 278656tang78Tang3/5/09N/A300AccountantA6/3/09E5/4/09$ 85,000Salary1st and 15th no 400347song99Song10/11/16N/A300AccountantD1/9/17C12/10/16$ 80,000Salary1st and 15th no 738090angelon33Angelon7/2/15N/A400AccountantD9/30/15A8/31/15$ 80,000Salary1st and 15th no 291210matinez22Martinez10/28/14N/A400Line OperatorE1/26/15B12/27/14$12Hourlybi-weeklyno 695573martinez28Martinez3/15/11N/A400Line OperatorE6/13/11E5/14/11$12Hourlybi-weeklyno 373490paulo12Paulo4/8/09N/A400Maintenance SpecialistD7/7/09B6/7/09$ 130,000Salary1st and 15th no 996092ruiz15Ruiz1/5/15N/A400Line OperatorB4/5/15D3/6/15$12Hourlybi-weeklyno 877510soares52Soares12/1/16N/A400SupervisorA3/1/17D1/30/17$18Hourlybi-weeklyno 492006garcia88Garcia7/5/13N/A400Line OperatorE10/3/13B9/3/13$12Hourlybi-weeklyno 127375lopez64Lopez10/11/11N/A400Line OperatorE1/9/12C12/10/11$12Hourlybi-weeklyno 895337gonzalez75Gonzalez11/5/15N/A400Line OperatorA2/3/16E1/4/16$14Hourlybi-weeklyno 315734rivera11Rivera6/4/15N/A400Line OperatorA9/2/15C8/3/15$15Hourlybi-weeklyno 517219diaz18Diaz9/7/13N/A400Line OperatorE12/6/13D11/6/13$15Hourlybi-weeklyno 879169vasquez88Vasquez7/6/08N/A400Line OperatorE10/4/08E9/4/08$14Hourlybi-weeklyno 433077fernandez65Fernandez7/3/16N/A400SupervisorC10/1/16D9/1/16$18Hourlybi-weeklyno 862486rios43Rios7/5/14N/A400SupervisorE10/3/14D9/3/14$19Hourlybi-weeklyno 819342cortez55Cortez4/7/08N/A400Sales RepresentativeB7/6/08E6/6/08$ 80,000Salary1st and 15th 10% 969492rodriguez74Rodriguez4/23/14N/A400Sales RepresentativeE7/22/14A6/22/14$ 75,000Salary1st and 15th 10% 103369hernandez56Hernandez12/15/15N/A400AccountantB3/14/16A2/13/16$ 80,000Salary1st and 15th no 917287cardoso56Cardoso4/5/12N/A500Line OperatorE7/4/12D6/4/12$12Hourlybi-weeklyno 877522lopez22Lopez1/1/12N/A500SupervisorA3/31/12D3/1/12$18Hourlybi-weeklyno 373499oliveira10Oliveira4/9/14N/A500Maintenance SpecialistD7/8/14B6/8/14$ 130,000Salary1st and 15th no 996123santos11Santos7/30/13N/A500Line OperatorB10/28/13D9/28/13$12Hourlybi-weeklyno 695583silva13Silva5/6/13N/A500Line OperatorE8/4/13E7/5/13$12Hourlybi-weeklyno 738112sousa33Sousa8/1/12N/A500AccountantD10/30/12A9/30/12$ 80,000Salary1st and 15th no 905820pereira77Pereira9/8/08N/A500Line OperatorD12/7/08E11/7/08$13Hourlybi-weeklyno 992465lima21Lima4/15/14N/A500Line OperatorB7/14/14A6/14/14$12Hourlybi-weeklyno 732887carvalho23Carvalho7/5/15N/A500Line OperatorB10/3/15A9/3/15$12Hourlybi-weeklyno 910229ferreira21Ferreira3/8/15N/A500Line OperatorE6/6/15A5/7/15$12Hourlybi-weeklyno 231815costa40Costa2/12/16N/A500Line OperatorE5/12/16D4/12/16$12Hourlybi-weeklyno 333657gomes25Gomes5/7/16N/A500Line OperatorE8/5/16D7/6/16$14Hourlybi-weeklyno 287819marins68Marins5/9/14N/A500Line OperatorD8/7/14E7/8/14$14Hourlybi-weeklyno 579148melo99Melo6/5/16N/A500SupervisorD9/3/16A8/4/16$19Hourlybi-weeklyno 124436barbosa24Barbosa1/1/16N/A500SupervisorE3/31/16C3/1/16$20Hourlybi-weeklyno 485078ribeiro22Ribeiro3/6/16N/A500Sales RepresentativeE6/4/16B5/5/16$ 70,000Salary1st and 15th 10% 297585alves20Alves7/20/15N/A500Sales RepresentativeC10/18/15C9/18/15$ 70,000Salary1st and 15th 10% 777104schmitz62Schmitz4/15/16N/A500AccountantB7/14/16B6/14/16$ 80,000Salary1st and 15th no 728222fleming82Fleming1/25/14N/A600Sales RepresentativeD4/25/14D3/26/14$ 80,000Salary1st and 15th 10% 527355gray74Gray3/17/09N/A600Sales RepresentativeC6/15/09C5/16/09$ 85,000Salary1st and 15th 10% 527600jones74Jones3/22/14N/A600DC Line WorkerE6/20/14C5/21/14$12Hourlybi-weeklyno 877813smith24Smith1/1/12N/A600DC SupervisorA3/31/12D3/1/12$14Hourlybi-weeklyno 728278thomas81Thomas2/18/14N/A600DC Line WorkerE5/19/14D4/19/14$12Hourlybi-weeklyno 729000becker21Becker2/25/14N/A600Store ClerkE5/26/14D4/26/14$18Hourlybi-weeklyno 527412hopper11Hopper2/17/13N/A600Store ClerkE5/18/13C4/18/13$18Hourlybi-weeklyno 527812davis34Davis3/25/15N/A600Store ClerkE6/23/15C5/24/15$18Hourlybi-weeklyno 877973mikoski82Mikoski9/1/14N/A600Store ClerkA11/30/14D10/31/14$17Hourlybi-weeklyno 728333landau12Landau8/18/15N/A600Store ClerkE11/16/15D10/17/15$17Hourlybi-weeklyno 960444allison29Allison6/5/15N/A600Sales RepresentativeD9/3/15E8/4/15$ 70,000Salary1st and 15th 10% 529223davidson20Davidson7/9/10N/A600Sales RepresentativeD10/7/10A9/7/10$ 76,000Salary1st and 15th 10% 252858franklin79Franklin8/4/14N/A600AccountantC11/2/14E10/3/14$ 85,000Salary1st and 15th no Finished Goods On-Hand Location IDDetailed Location IDFinished Item #DescriptionQuantityDate ReceivedMin LevelOn-hold 600New York Store101Sally Doll7003/15/17200yes 500Sao Paolo Plant101Sally Doll4003/27/17no 400Mexico City Plant101Sally Doll6905/1/17no 300Shanghai Plant101Sally Doll3204/10/17yes 200Washington Plant101Sally Doll2003/13/17no 600New York Store102Brenda Doll4303/15/17200no 500Sao Paolo Plant102Brenda Doll6003/27/17yes 400Mexico City Plant102Brenda Doll6005/1/17no 300Shanghai Plant102Brenda Doll1604/10/17no 200Washington Plant102Brenda Doll3003/13/17no 600New York Store103Lacy Doll4003/22/17200no 500Sao Paolo Plant103Lacy Doll5503/27/17yes 400Mexico City Plant103Lacy Doll1705/5/17no 300Shanghai Plant103Lacy Doll404/10/17no 200Washington Plant103Lacy Doll1403/15/17no 600New York Store104Maxwell Doll5003/15/17200no 500Sao Paolo Plant104Maxwell Doll4004/13/17no 400Mexico City Plant104Maxwell Doll7005/5/17no 300Shanghai Plant104Maxwell Doll2004/15/17no 200Washington Plant104Maxwell Doll1703/16/17yes 600New York Store105Joshua Doll4503/15/17200yes 500Sao Paolo Plant105Joshua Doll5004/13/17no 400Mexico City Plant105Joshua Doll6505/5/17no 300Shanghai Plant105Joshua Doll2504/15/17yes 200Washington Plant105Joshua Doll2003/19/17yes 600New York Store211Red Car6503/28/1750no 500Sao Paolo Plant211Red Car1605/1/17yes 400Mexico City Plant211Red Car7505/10/17yes 300Shanghai Plant211Red Car7004/20/17no 200Washington Plant211Red Car2403/20/17no 600New York Store212Green Car5503/28/1750no 500Sao Paolo Plant212Green Car2005/1/17no 400Mexico City Plant212Green Car2505/10/17no 300Shanghai Plant212Green Car5003/29/17no 200Washington Plant212Green Car3003/20/17no 600New York Store213Blue Car5003/22/1750yes 500Sao Paolo Plant213Blue Car2505/15/17no 400Mexico City Plant213Blue Car1004/29/17yes 300Shanghai Plant213Blue Car2003/20/17no 200Washington Plant213Blue Car5203/22/17yes 600New York Store214Purple Car5503/30/1750no 500Sao Paolo Plant214Purple Car2005/15/17no 400Mexico City Plant214Purple Car1504/25/17no 300Shanghai Plant214Purple Car5003/20/17no 200Washington Plant214Purple Car5003/29/17no 600New York Store215Yellow Car5003/30/1750yes 500Sao Paolo Plant215Yellow Car3005/10/17yes 400Mexico City Plant215Yellow Car2405/15/17no 300Shanghai Plant215Yellow Car5004/30/17no 200Washington Plant215Yellow Car4704/5/17yes 600New York Store301Soccer Video Game1504/2/17150no 500Sao Paolo Plant301Soccer Video Game3403/27/17no 400Mexico City Plant301Soccer Video Game505/15/17no 300Shanghai Plant301Soccer Video Game4604/30/17yes 200Washington Plant301Soccer Video Game9004/7/17yes 600New York Store302Racing Video Game1204/2/17150yes 500Sao Paolo Plant302Racing Video Game5503/27/17no 400Mexico City Plant302Racing Video Game1005/15/17no 300Shanghai Plant302Racing Video Game8204/10/17no 200Washington Plant302Racing Video Game2804/13/17no 600New York Store303Military Video Game3204/6/17200no 500Sao Paolo Plant303Military Video Game2803/20/17no 400Mexico City Plant303Military Video Game4004/19/17yes 300Shanghai Plant303Military Video Game1404/10/17yes 200Washington Plant303Military Video Game6404/14/17yes 600New York Store304Football Video Game2504/13/17200no 500Sao Paolo Plant304Football Video Game2753/18/17no 400Mexico City Plant304Football Video Game3004/19/17yes 300Shanghai Plant304Football Video Game7004/12/17no 200Washington Plant304Football Video Game6004/18/17no 600New York Store305Skateboarding Video Game2004/13/17150yes 500Sao Paolo Plant305Skateboarding Video Game4003/27/17yes 400Mexico City Plant305Skateboarding Video Game3505/12/17yes 300Shanghai Plant305Skateboarding Video Game6504/12/17yes 200Washington Plant305Skateboarding Video Game5004/20/17yes 600New York Store401Black Scooter5004/5/17200no 500Sao Paolo Plant401Black Scooter3003/27/17no 400Mexico City Plant401Black Scooter3505/8/17yes 300Shanghai Plant401Black Scooter6004/20/17no 200Washington Plant401Black Scooter4004/24/17yes 600New York Store402Pink Scooter4004/15/17200no 500Sao Paolo Plant402Pink Scooter2003/27/17no 400Mexico City Plant402Pink Scooter2505/8/17no 300Shanghai Plant402Pink Scooter6004/20/17no 200Washington Plant402Pink Scooter4504/30/17no 600New York Store403Blue Scooter4504/15/17200yes 500Sao Paolo Plant403Blue Scooter3004/11/17no 400Mexico City Plant403Blue Scooter3005/8/17no 300Shanghai Plant403Blue Scooter5004/25/17no 200Washington Plant403Blue Scooter3505/1/17no 600New York Store404Orange Scooter4004/23/17200no 500Sao Paolo Plant404Orange Scooter3504/18/17yes 400Mexico City Plant404Orange Scooter3005/6/17no 300Shanghai Plant404Orange Scooter4004/25/17yes 200Washington Plant404Orange Scooter3005/1/17no 600New York Store405yellow Scooter4004/23/17200no 500Sao Paolo Plant405yellow Scooter3004/23/17no 400Mexico City Plant405yellow Scooter2505/1/17no 300Shanghai Plant405yellow Scooter4504/25/17no 200Washington Plant405yellow Scooter2005/5/17yes Formulas FormulaRaw Material #1#1 QuantityRaw Material #2#2 QuantityRaw Material #3#3 QuantityRaw Material #4#4 QuantityRaw Material #5#5 QuantityFinished Good # Red Car13141322133413445701211 Green Car13141322133413445731212 Blue Car13141322133413445711213 Purple Car13141322133413445741214 Yellow Car13141322133413445721215 Sally Doll25012531254225522562101 Brenda Doll25112531254225522562102 Lacy Doll25212531254225522562103 Maxwell Doll25112571254225522562104 Joshua Doll25212571254225522562105 Soccer Video Game320132113221301 Racing Video Game320132113221302 Military Video Game320132113221303 Football Video Game320132113221304 Skateboarding Video Game320132113221305 Black Scooter4401441244215751401 Pink Scooter4401441244215761402 Blue Scooter4401441244215711403 Orange Scooter4401441244215771404 yellow Scooter4401441244215721405 Inventory Count Date of CountLocationDetailed LocationItem #Minimum QuanitityQuantity CountedQuantity ExpectedDifferenceCounterApprover 3/14/17600Distribution Center1017007000jones74smith24 3/14/17600Distribution Center1024304300jones74smith24 3/14/17600Distribution Center1034004000jones74smith24 3/14/17600Distribution Center1045005000jones74smith24 3/14/17600Distribution Center1055404500jones74smith24 3/14/17600Distribution Center21162065030jones74smith24 3/14/17600Distribution Center2125505500jones74smith24 3/14/17600Distribution Center2135005000thomas81smith24 3/14/17600Distribution Center2145505500thomas81smith24 3/14/17600Distribution Center2155005000thomas81smith24 3/14/17600Distribution Center3011501500thomas81smith24 3/14/17600Distribution Center3021201200thomas81smith24 3/14/17600Distribution Center30327032050jones74smith24 3/14/17600Distribution Center3042502500jones74smith24 3/14/17600Distribution Center30518020020jones74smith24 3/14/17600Distribution Center4015005000jones74smith24 3/14/17600Distribution Center4024004000jones74smith24 3/14/17600Distribution Center40340045050jones74smith24 3/14/17600Distribution Center404300400100jones74smith24 3/14/17600Distribution Center40539040010jones74smith24 3/14/17200Washington Plant1315003990400010smith22masterson50 3/14/17200Washington Plant132500200020000smith22masterson50 3/14/17200Washington Plant133500400040000smith22masterson50 3/14/17200Washington Plant134500200020000smith22masterson50 3/14/17200Washington Plant2505005005000smith22masterson50 3/14/17200Washington Plant25150055060050smith22masterson50 3/14/17200Washington Plant2525005005000smith22masterson50 3/14/17200Washington Plant253500150015000smith22masterson50 3/14/17200Washington Plant254500300030000smith22masterson50 3/14/17200Washington Plant25550025003000500smith22masterson50 3/14/17200Washington Plant256500300030000smith22masterson50 3/14/17200Washington Plant257500200020000smith22masterson50 3/14/17200Washington Plant320500200020000smith22masterson50 3/14/17200Washington Plant321500200020000smith22masterson50 3/14/17200Washington Plant322500200020000smith22masterson50 3/14/17200Washington Plant44050018002000200smith22masterson50 3/14/17200Washington Plant441500400040000smith22masterson50 3/14/17200Washington Plant44250018002000200smith22masterson50 3/14/17200Washington Plant570500100010000smith22masterson50 3/14/17200Washington Plant571500150015000smith22masterson50 3/14/17200Washington Plant57250010001500500smith22masterson50 3/14/17200Washington Plant5735008008000smith22masterson50 3/14/17200Washington Plant5745009009000smith22masterson50 3/14/17200Washington Plant5755007007000smith22masterson50 3/14/17200Washington Plant5765007507500smith22masterson50 3/14/17200Washington Plant5775005005000smith22masterson50 3/14/17200Washington Plant1012002000smith22masterson50 3/14/17200Washington Plant1023003000smith22masterson50 3/14/17200Washington Plant1031401400smith22masterson50 3/14/17200Washington Plant1041701700smith22masterson50 3/14/17200Washington Plant1052002000smith22masterson50 3/14/17200Washington Plant2112402400smith22masterson50 3/14/17200Washington Plant2123003000smith22masterson50 3/14/17200Washington Plant2135205200smith22masterson50 3/14/17200Washington Plant2145005000smith22masterson50 3/14/17200Washington Plant2154704700smith22masterson50 3/14/17200Washington Plant3019009000smith22masterson50 3/14/17200Washington Plant3022802800smith22masterson50 3/14/17200Washington Plant3036406400smith22masterson50 3/14/17200Washington Plant3046006000smith22masterson50 3/14/17200Washington Plant3055005000smith22masterson50 3/14/17200Washington Plant4014004000smith22masterson50 3/14/17200Washington Plant4024504500smith22masterson50 3/14/17200Washington Plant4033503500smith22masterson50 3/14/17200Washington Plant4043003000smith22masterson50 3/14/17200Washington Plant4052002000smith22masterson50 3/14/17300Shanghai Plant1315001980200020ng44cheng50 3/14/17300Shanghai Plant1325008001000200ng44cheng50 3/14/17300Shanghai Plant133500200020000ng44cheng50 3/14/17300Shanghai Plant134500100010000ng44cheng50 3/14/17300Shanghai Plant2505005005000ng44cheng50 3/14/17300Shanghai Plant251500100010000ng44cheng50 3/14/17300Shanghai Plant252500950100050ng44cheng50 3/14/17300Shanghai Plant253500300030000tau69cheng50 3/14/17300Shanghai Plant254500600060000tau69cheng50 3/14/17300Shanghai Plant255500500060001000tau69cheng50 3/14/17300Shanghai Plant256500600060000tau69cheng50 3/14/17300Shanghai Plant257500500050000tau69cheng50 3/14/17300Shanghai Plant320500300030000tau69cheng50 3/14/17300Shanghai Plant321500300030000tau69cheng50 3/14/17300Shanghai Plant32250029003000100tau69cheng50 3/14/17300Shanghai Plant440500300030000tau69cheng50 3/14/17300Shanghai Plant441500600060000tau69cheng50 3/14/17300Shanghai Plant442500300030000tau69cheng50 3/14/17300Shanghai Plant5705005005000tau69cheng50 3/14/17300Shanghai Plant571500100010000tau69cheng50 3/14/17300Shanghai Plant572500100010000tau69cheng50 3/14/17300Shanghai Plant57350070075050tau69cheng50 3/14/17300Shanghai Plant5745008008000tau69cheng50 3/14/17300Shanghai Plant5755007007000tau69cheng50 3/14/17300Shanghai Plant5765009009000tau69cheng50 3/14/17300Shanghai Plant5775008008000tau69cheng50 3/14/17300Shanghai Plant1013203200tau69cheng50 3/14/17300Shanghai Plant1021601600tau69cheng50 3/14/17300Shanghai Plant10340400tau69cheng50 3/14/17300Shanghai Plant1042002000tau69cheng50 3/14/17300Shanghai Plant1052502500tau69cheng50 3/14/17300Shanghai Plant2117007000tau69cheng50 3/14/17300Shanghai Plant2125005000tau69cheng50 3/14/17300Shanghai Plant2132002000tau69cheng50 3/14/17300Shanghai Plant2145005000tau69cheng50 3/14/17300Shanghai Plant2155005000tau69cheng50 3/14/17300Shanghai Plant3014604600tau69cheng50 3/14/17300Shanghai Plant3028208200tau69cheng50 3/14/17300Shanghai Plant3031401400tau69cheng50 3/14/17300Shanghai Plant3047007000tau69cheng50 3/14/17300Shanghai Plant3056506500tau69cheng50 3/14/17300Shanghai Plant4016006000tau69cheng50 3/14/17300Shanghai Plant4026006000tau69cheng50 3/14/17300Shanghai Plant4035005000tau69cheng50 3/14/17300Shanghai Plant4044004000tau69cheng50 3/14/17300Shanghai Plant4054504500tau69cheng50 3/14/17400Mexico City Plant13150039004000100martinez22soares52 3/14/17400Mexico City Plant132500200020000martinez22soares52 3/14/17400Mexico City Plant133500300030000martinez22soares52 3/14/17400Mexico City Plant134500200020000martinez22soares52 3/14/17400Mexico City Plant2505009001000100martinez22soares52 3/14/17400Mexico City Plant2515005005000martinez22soares52 3/14/17400Mexico City Plant2525005005000martinez22soares52 3/14/17400Mexico City Plant25350010001500500martinez22soares52 3/14/17400Mexico City Plant254500300030000ruiz15soares52 3/14/17400Mexico City Plant255500300030000ruiz15soares52 3/14/17400Mexico City Plant256500300030000ruiz15soares52 3/14/17400Mexico City Plant257500300030000ruiz15soares52 3/14/17400Mexico City Plant320500150015000ruiz15soares52 3/14/17400Mexico City Plant32150014001500100ruiz15soares52 3/14/17400Mexico City Plant322500150015000ruiz15soares52 3/14/17400Mexico City Plant440500100010000ruiz15soares52 3/14/17400Mexico City Plant441500200020000ruiz15soares52 3/14/17400Mexico City Plant442500100010000ruiz15soares52 3/14/17400Mexico City Plant570500500600100ruiz15soares52 3/14/17400Mexico City Plant5715006006000ruiz15soares52 3/14/17400Mexico City Plant5725005005000ruiz15soares52 3/14/17400Mexico City Plant5735005505500ruiz15soares52 3/14/17400Mexico City Plant57450055060050ruiz15soares52 3/14/17400Mexico City Plant5755005005000ruiz15soares52 3/14/17400Mexico City Plant5765006006000ruiz15soares52 3/14/17400Mexico City Plant5775005505500ruiz15soares52 3/14/17400Mexico City Plant1016906900ruiz15soares52 3/14/17400Mexico City Plant1026006000ruiz15soares52 3/14/17400Mexico City Plant1031701700ruiz15soares52 3/14/17400Mexico City Plant1047007000ruiz15soares52 3/14/17400Mexico City Plant1056506500ruiz15soares52 3/14/17400Mexico City Plant2117507500ruiz15soares52 3/14/17400Mexico City Plant2122502500ruiz15soares52 3/14/17400Mexico City Plant2131001000ruiz15soares52 3/14/17400Mexico City Plant2141501500ruiz15soares52 3/14/17400Mexico City Plant2152402400ruiz15soares52 3/14/17400Mexico City Plant30150500ruiz15soares52 3/14/17400Mexico City Plant3021001000ruiz15soares52 3/14/17400Mexico City Plant3034004000ruiz15soares52 3/14/17400Mexico City Plant3043003000ruiz15soares52 3/14/17400Mexico City Plant3053503500ruiz15soares52 3/14/17400Mexico City Plant4013503500ruiz15soares52 3/14/17400Mexico City Plant4022502500ruiz15soares52 3/14/17400Mexico City Plant4033003000ruiz15soares52 3/14/17400Mexico City Plant4043003000ruiz15soares52 3/14/17400Mexico City Plant4052502500ruiz15soares52 3/14/17500Sao Paolo Plant131500100010000cardoso56lopez22 3/14/17500Sao Paolo Plant1325005005000cardoso56lopez22 3/14/17500Sao Paolo Plant1335005005000cardoso56lopez22 3/14/17500Sao Paolo Plant13450055060050cardoso56lopez22 3/14/17500Sao Paolo Plant2505005005000cardoso56lopez22 3/14/17500Sao Paolo Plant2515005005000cardoso56lopez22 3/14/17500Sao Paolo Plant2525005005000cardoso56lopez22 3/14/17500Sao Paolo Plant2535007001000300cardoso56lopez22 3/14/17500Sao Paolo Plant254500200020000santos11lopez22 3/14/17500Sao Paolo Plant255500200020000santos11lopez22 3/14/17500Sao Paolo Plant25650019002000100santos11lopez22 3/14/17500Sao Paolo Plant257500200020000santos11lopez22 3/14/17500Sao Paolo Plant3205007007000santos11lopez22 3/14/17500Sao Paolo Plant3215007007000santos11lopez22 3/14/17500Sao Paolo Plant322500600700100santos11lopez22 3/14/17500Sao Paolo Plant4405005005000santos11lopez22 3/14/17500Sao Paolo Plant441500100010000santos11lopez22 3/14/17500Sao Paolo Plant44250050055050santos11lopez22 3/14/17500Sao Paolo Plant5705005005000santos11lopez22 3/14/17500Sao Paolo Plant5715007007000santos11lopez22 3/14/17500Sao Paolo Plant5725008008000santos11lopez22 3/14/17500Sao Paolo Plant5735005005000santos11lopez22 3/14/17500Sao Paolo Plant574500600700100santos11lopez22 3/14/17500Sao Paolo Plant5755006006000santos11lopez22 3/14/17500Sao Paolo Plant5765005505500santos11lopez22 3/14/17500Sao Paolo Plant5775005005000santos11lopez22 3/14/17500Sao Paolo Plant1014004000santos11lopez22 3/14/17500Sao Paolo Plant1026006000santos11lopez22 3/14/17500Sao Paolo Plant1035505500santos11lopez22 3/14/17500Sao Paolo Plant1044004000santos11lopez22 3/14/17500Sao Paolo Plant1055005000santos11lopez22 3/14/17500Sao Paolo Plant2111601600santos11lopez22 3/14/17500Sao
Answered Same DayMay 30, 2021MITS6005

Answer To: Customer Customer IDCustomer NameCustomer AddressCustomer CityCustomer StateCustomer ZipSales...

Ximi answered on Jun 02 2021
145 Votes
charts fictional data.py
#!/usr/bin/env python
# coding: utf-8
# In[1]:
import pandas as pd
# I
n[5]:
df = pd.read_excel('fictional-project-data-0smlrhaa-d1ch3lhb.xlsx', sheet_name='Purchase Order')
# In[7]:
df.shape
# In[8]:
import seaborn as sns
sns.set()
# In[9]:
get_ipython().run_line_magic('matplotlib', 'inline')
# In[16]:
import matplotlib.pyplot as plt
plt.figure(figsize=(50, 10))
plot = sns.barplot(x='Description', y='Total Amount', data=df)
plot.figure.savefig('TotalAmount.png')
# In[18]:
df = pd.read_excel('fictional-project-data-0smlrhaa-d1ch3lhb.xlsx', sheet_name='Raw Materials On-hand')
# In[21]:
loc_qty = df.groupby('Detailed Location...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here