Instructions in the file
tblAccount AcctIDAcctBankNameAcctBankAccountNumAcctAdd1AcctAdd2AcctCityAcctStateAcctZIPAcctPhoneAcctContactAcctContactPhoneAcctRoutingNumAcctBalanceAcctType ACCT001Bank of PrestonA3333-4444287 Main StreetSuite 345PrestonID83271- (208) 852-1003Boyd Packer(208) 852-100512412343$0.00ACCTTP001 ACCT002First Bank of Idaho123456-9876-1234300 North 100 EastSuite AAAPrestonID83271- (208) 852-7811David Pennock(208) 852-782243242754$0.00ACCTTP002 ACCT003First Bank of Idaho55512-1255-45323300 North 100 EastSuite 808PrestonID83271- (208) 852-7811David Pennock(208) 852-782282585545$0.00ACCTTP003 ACCT004Federal First BankIDNC-2021-IAH7000 Bower BlvdSuite LLoganUT84321- (435) 750-9124Suzette Joseph(435) 750-912417364346$0.00ACCTTP003 tblCustomer CustIDCusNameCusAdd1CusAdd2CusCityCusStateCusZIPCusPhoneCusContactCusEmailCusWebAddCusFaxCusType CUS0000001A & B Market8327 Hidden Canyon Dr.LewistonUT84320- (435) 258-3459Brad
[email protected] CUS0000002Mark's Supermarket2949 State Blvd.PrestonID83271- (208) 852-0021CUSTYP002 CUS0000003Cache Valley Food Stores1010 Homer Ave.SmithfieldUT84335- (435) 535-5656CUSTYP002 CUS0000004Valley Snack and Grab1231 E Skyview Dr.FranklinID83237- (435) 755-4128Kim Neal(435) 755-9911CUSTYP002 CUS0000005Hick's Market900 North Main St.Mink CreekID83263- (208) 852-2298Barbara PipesCUSTYP002 CUS0000006Grub Stake Foods287 Harvest RunRichmondUT84333- (435) 932-3833CUSTYP002 CUS0000007Sammy's Market and Deli3050 West 200 NorthPrestonID83271- (208) 852-8659CUSTYP002 CUS0000008Stop N Shop Grocery554 North Saturn Rd.BanidaID83271- (208) 852-9134CUSTYP002 CUS0000009Bonnie & Bill's Food Village190 Sunset Rd.PrestonID83271- (208) 852-6022CUSTYP002 CUS0000010County Food Mart772 Chatham St.RirieID83443- (208) 523-6809CUSTYP002 CUS0000011Hawk Ridge Guest Ranch12878 Stonebrook Ln.DaytonID83232- (208) 852-9579Dale
[email protected](208) 852-9578CUSTYP002 CUS0000012Silver Creek Ranch503 Powerhouse Dr.NewtonUT84327- (435) 752-4165Konie
[email protected](435) 752-0009CUSTYP002 CUS0000013Calvin Hurst1420 East 17th St.PrestonID83271- (208) 852-7733CUSTYP001 CUS0000014Glenn Adams45 West 800 NorthPrestonID83271- (208) 852-0988CUSTYP001 CUS0000015Lloyd Hyde224 North Park Ln.PrestonID83271- (208) 852-7567CUSTYP001 CUS0000016Terry Isom228 North Park Ln.PrestonID83271- (208) 852-1112CUSTYP001 CUS0000017Angela Sharp466 Hummingbird Dr.SmithfieldUT84335- (435) 535-0099CUSTYP001 CUS0000018Jeremy Cordova340 North WaterPrestonID83271- (208) 852-1232CUSTYP001 CUS0000019Marsha Spencer12 Short Ave.PrestonID83271- (208) 852-4323CUSTYP001 CUS0000020Cheryl Blake300 Walnut St.PrestonID83271- (208) 852-1881CUSTYP001 tblEmployee EmpIDEmpSSNEmpFNameEmpLNameEmpAdd1EmpAdd2EmpCityEmpStateEmpZIPEmpPhoneEmpEmailEmpWithAllowEmpBDateEmpTypeEmpPayRateEmpPosition EMP00001645-22-6067HermanGillon2184 North Village TurnPrestonID83271- (208) 852-6870107-Dec-94EMPTYP02$7.00EMPPOS03 EMP00002603-77-3870IsabellePoints3577 Berkshire AvenuePrestonID83271- (208) 852-4836127-Mar-90EMPTYP02$8.00EMPPOS03 EMP00003834-60-5425MauriceHack9557 Fuselage LandingApt. #112PrestonID83271- (208) 852-4443114-Jan-94EMPTYP02$7.00EMPPOS03 EMP00004522-77-5882DannyWhitener8401 Two Gun Creek HillPrestonID83271- (208) 852-3202123-Nov-93EMPTYP02$7.50EMPPOS03 EMP00005682-40-8605MarkGooch713 Tranquility Base RidgePrestonID83271- (208)
[email protected]$7.00EMPPOS03 EMP00006237-20-2328CarolineLovato1411 Park Place PointApt. #245PrestonID83271- (208)
[email protected]$550.00EMPPOS04 EMP00007832-11-5336AaronDever4084 Manor AvenuePrestonID83271- (208) 852-5418122-Aug-93EMPTYP02$7.00EMPPOS03 EMP00008251-15-0482MartinSpringer9150 Camellia WalkPrestonID83271- (208) 852-5430118-Oct-89EMPTYP02$9.00EMPPOS02 EMP00009732-85-5305MarkYoung5967 Country Creek PathPrestonID83271- (208) 852-7465402-Oct-80EMPTYP01$0.00EMPPOS01 tblInventory InvIDInvHoneyTypeInvContainerTypeInvContainerSizeInvQtyOnHandInvSellingPriceInvCost INV00001HTYPE001Bucket48 lb12$78.00$54.60 INV00002HTYPE001Can5 lb100$20.00$13.00 INV00003HTYPE001Honey Bear10 oz150$6.99$4.20 INV00004HTYPE001Honey Bear6 oz200$4.99$3.00 INV00005HTYPE001Honey Bear8 oz170$5.79$3.48 INV00006HTYPE001Jar10 oz150$6.79$4.40 INV00007HTYPE001Jar16 oz120$10.79$7.55 INV00008HTYPE001Jar18 oz100$12.19$8.53 INV00009HTYPE001Jar22 oz130$14.99$10.49 INV00010HTYPE001Jar6 oz200$3.99$2.39 INV00011HTYPE001Jar8 oz170$5.39$3.23 INV00012HTYPE002Bucket48 lb12$78.00$54.60 INV00013HTYPE002Can5 lb100$20.00$13.00 INV00014HTYPE002Honey Bear10 oz150$6.99$4.20 INV00015HTYPE002Honey Bear6 oz200$4.99$3.00 INV00016HTYPE002Honey Bear8 oz170$5.79$3.48 INV00017HTYPE002Jar10 oz150$6.79$4.40 INV00018HTYPE002Jar16 oz120$10.79$7.55 INV00019HTYPE002Jar18 oz100$12.19$8.53 INV00020HTYPE002Jar22 oz130$14.99$10.49 INV00021HTYPE002Jar6 oz200$3.99$2.39 INV00022HTYPE002Jar8 oz170$5.39$3.23 INV00023HTYPE003Bucket48 lb12$84.00$58.80 INV00024HTYPE003Can5 lb100$22.00$14.30 INV00025HTYPE003Honey Bear10 oz150$7.99$4.80 INV00026HTYPE003Honey Bear6 oz200$5.49$3.29 INV00027HTYPE003Honey Bear8 oz170$6.19$3.72 INV00028HTYPE003Jar10 oz150$7.19$4.68 INV00029HTYPE003Jar16 oz120$11.49$8.04 INV00030HTYPE003Jar18 oz100$12.99$9.09 INV00031HTYPE003Jar22 oz130$15.79$11.05 INV00032HTYPE003Jar6 oz200$4.29$2.57 INV00033HTYPE003Jar8 oz170$5.79$3.47 tblSale SaleIDSaleCustIDSaleEmpIDSaleAcctIDSaleDate SALE000001CUS0000015EMP00006ACCT00201-May-21 SALE000002CUS0000008EMP00009ACCT00202-May-21 SALE000003CUS0000015EMP00006ACCT00203-May-21 SALE000004CUS0000003EMP00009ACCT00204-May-21 SALE000005CUS0000003EMP00006ACCT00205-May-21 SALE000006CUS0000001EMP00006ACCT00205-May-21 SALE000007CUS0000009EMP00006ACCT00207-May-21 SALE000008CUS0000019EMP00006ACCT00207-May-21 SALE000009CUS0000010EMP00006ACCT00207-May-21 SALE000010CUS0000001EMP00006ACCT00207-May-21 SALE000011CUS0000014EMP00006ACCT00209-May-21 SALE000012CUS0000006EMP00006ACCT00210-May-21 SALE000013CUS0000002EMP00009ACCT00210-May-21 SALE000014CUS0000008EMP00006ACCT00210-May-21 SALE000015CUS0000006EMP00006ACCT00212-May-21 SALE000016CUS0000006EMP00006ACCT00212-May-21 SALE000017CUS0000010EMP00009ACCT00212-May-21 SALE000018CUS0000011EMP00009ACCT00213-May-21 SALE000019CUS0000015EMP00006ACCT00214-May-21 SALE000020CUS0000010EMP00009ACCT00216-May-21 SALE000021CUS0000007EMP00006ACCT00217-May-21 SALE000022CUS0000014EMP00006ACCT00218-May-21 SALE000023CUS0000011EMP00006ACCT00218-May-21 SALE000024CUS0000005EMP00006ACCT00219-May-21 SALE000025CUS0000015EMP00006ACCT00220-May-21 SALE000026CUS0000003EMP00009ACCT00220-May-21 SALE000027CUS0000011EMP00009ACCT00220-May-21 SALE000028CUS0000013EMP00006ACCT00221-May-21 SALE000029CUS0000002EMP00006ACCT00222-May-21 SALE000030CUS0000016EMP00006ACCT00222-May-21 SALE000031CUS0000015EMP00009ACCT00222-May-21 SALE000032CUS0000002EMP00006ACCT00222-May-21 SALE000033CUS0000015EMP00009ACCT00224-May-21 SALE000034CUS0000020EMP00006ACCT00224-May-21 SALE000035CUS0000013EMP00006ACCT00226-May-21 SALE000036CUS0000008EMP00009ACCT00228-May-21 SALE000037CUS0000002EMP00009ACCT00228-May-21 SALE000038CUS0000012EMP00006ACCT00229-May-21 SALE000039CUS0000002EMP00009ACCT00231-May-21 SALE000040CUS0000009EMP00009ACCT00231-May-21 SALE000041CUS0000015EMP00009ACCT00231-May-21 SALE000042CUS0000016EMP00009ACCT00202-Jun-21 SALE000043CUS0000009EMP00009ACCT00202-Jun-21 SALE000044CUS0000003EMP00009ACCT00202-Jun-21 SALE000045CUS0000019EMP00009ACCT00202-Jun-21 SALE000046CUS0000013EMP00006ACCT00203-Jun-21 SALE000047CUS0000003EMP00006ACCT00203-Jun-21 SALE000048CUS0000005EMP00009ACCT00204-Jun-21 SALE000049CUS0000014EMP00006ACCT00204-Jun-21 SALE000050CUS0000007EMP00006ACCT00205-Jun-21 SALE000051CUS0000016EMP00006ACCT00206-Jun-21 SALE000052CUS0000013EMP00009ACCT00206-Jun-21 SALE000053CUS0000010EMP00009ACCT00206-Jun-21 SALE000054CUS0000003EMP00009ACCT00206-Jun-21 SALE000055CUS0000016EMP00009ACCT00206-Jun-21 SALE000056CUS0000017EMP00009ACCT00208-Jun-21 SALE000057CUS0000003EMP00006ACCT00208-Jun-21 SALE000058CUS0000011EMP00009ACCT00209-Jun-21 SALE000059CUS0000008EMP00006ACCT00210-Jun-21 SALE000060CUS0000005EMP00009ACCT00211-Jun-21 SALE000061CUS0000013EMP00006ACCT00212-Jun-21 SALE000062CUS0000008EMP00009ACCT00212-Jun-21 SALE000063CUS0000003EMP00009ACCT00214-Jun-21 SALE000064CUS0000010EMP00009ACCT00215-Jun-21 SALE000065CUS0000016EMP00006ACCT00216-Jun-21 SALE000066CUS0000009EMP00006ACCT00217-Jun-21 SALE000067CUS0000008EMP00009ACCT00218-Jun-21 SALE000068CUS0000008EMP00006ACCT00219-Jun-21 SALE000069CUS0000003EMP00009ACCT00219-Jun-21 SALE000070CUS0000015EMP00006ACCT00219-Jun-21 SALE000071CUS0000019EMP00006ACCT00219-Jun-21 SALE000072CUS0000012EMP00006ACCT00220-Jun-21 SALE000073CUS0000005EMP00006ACCT00221-Jun-21 SALE000074CUS0000004EMP00006ACCT00222-Jun-21 SALE000075CUS0000013EMP00006ACCT00222-Jun-21 SALE000076CUS0000020EMP00006ACCT00223-Jun-21 SALE000077CUS0000019EMP00006ACCT00224-Jun-21 SALE000078CUS0000017EMP00006ACCT00225-Jun-21 SALE000079CUS0000018EMP00006ACCT00226-Jun-21 SALE000080CUS0000006EMP00006ACCT00226-Jun-21 SALE000081CUS0000020EMP00006ACCT00226-Jun-21 SALE000082CUS0000004EMP00006ACCT00227-Jun-21 SALE000083CUS0000002EMP00009ACCT00227-Jun-21 SALE000084CUS0000014EMP00006ACCT00227-Jun-21 SALE000085CUS0000018EMP00006ACCT00228-Jun-21 SALE000086CUS0000001EMP00009ACCT00229-Jun-21 SALE000087CUS0000010EMP00009ACCT00201-Jul-21 SALE000088CUS0000018EMP00009ACCT00201-Jul-21 SALE000089CUS0000019EMP00009ACCT00202-Jul-21 SALE000090CUS0000006EMP00006ACCT00203-Jul-21 SALE000091CUS0000009EMP00006ACCT00204-Jul-21 SALE000092CUS0000012EMP00009ACCT00206-Jul-21 SALE000093CUS0000018EMP00006ACCT00207-Jul-21 SALE000094CUS0000004EMP00009ACCT00207-Jul-21 SALE000095CUS0000016EMP00009ACCT00208-Jul-21 SALE000096CUS0000017EMP00009ACCT00209-Jul-21 SALE000097CUS0000017EMP00009ACCT00209-Jul-21 SALE000098CUS0000002EMP00009ACCT00209-Jul-21 SALE000099CUS0000006EMP00009ACCT00209-Jul-21 SALE000100CUS0000012EMP00006ACCT00210-Jul-21 SALE000101CUS0000018EMP00006ACCT00212-Jul-21 SALE000102CUS0000015EMP00006ACCT00213-Jul-21 SALE000103CUS0000016EMP00006ACCT00214-Jul-21 SALE000104CUS0000014EMP00006ACCT00216-Jul-21 SALE000105CUS0000020EMP00009ACCT00218-Jul-21 SALE000106CUS0000011EMP00009ACCT00220-Jul-21 SALE000107CUS0000006EMP00006ACCT00221-Jul-21 SALE000108CUS0000018EMP00009ACCT00222-Jul-21 SALE000109CUS0000010EMP00009ACCT00222-Jul-21 SALE000110CUS0000017EMP00009ACCT00224-Jul-21 SALE000111CUS0000014EMP00009ACCT00226-Jul-21 SALE000112CUS0000012EMP00006ACCT00227-Jul-21 SALE000113CUS0000019EMP00009ACCT00228-Jul-21 SALE000114CUS0000009EMP00009ACCT00228-Jul-21 SALE000115CUS0000009EMP00009ACCT00229-Jul-21 SALE000116CUS0000011EMP00006ACCT00230-Jul-21 SALE000117CUS0000005EMP00009ACCT00201-Aug-21 SALE000118CUS0000001EMP00009ACCT00203-Aug-21 SALE000119CUS0000018EMP00006ACCT00205-Aug-21 SALE000120CUS0000006EMP00009ACCT00206-Aug-21 SALE000121CUS0000017EMP00006ACCT00207-Aug-21 SALE000122CUS0000002EMP00009ACCT00208-Aug-21 SALE000123CUS0000005EMP00006ACCT00208-Aug-21 SALE000124CUS0000009EMP00006ACCT00210-Aug-21 SALE000125CUS0000005EMP00006ACCT00212-Aug-21 SALE000126CUS0000001EMP00006ACCT00212-Aug-21 SALE000127CUS0000005EMP00006ACCT00214-Aug-21 SALE000128CUS0000015EMP00009ACCT00215-Aug-21 SALE000129CUS0000019EMP00009ACCT00216-Aug-21 SALE000130CUS0000014EMP00009ACCT00216-Aug-21 SALE000131CUS0000012EMP00006ACCT00217-Aug-21 SALE000132CUS0000005EMP00009ACCT00217-Aug-21 SALE000133CUS0000004EMP00006ACCT00218-Aug-21 SALE000134CUS0000014EMP00009ACCT00218-Aug-21 SALE000135CUS0000011EMP00006ACCT00220-Aug-21 SALE000136CUS0000011EMP00009ACCT00221-Aug-21 SALE000137CUS0000007EMP00006ACCT00223-Aug-21 SALE000138CUS0000016EMP00009ACCT00223-Aug-21 SALE000139CUS0000009EMP00009ACCT00224-Aug-21 SALE000140CUS0000012EMP00006ACCT00224-Aug-21 SALE000141CUS0000014EMP00009ACCT00224-Aug-21 SALE000142CUS0000006EMP00006ACCT00225-Aug-21 SALE000143CUS0000015EMP00009ACCT00225-Aug-21 SALE000144CUS0000014EMP00009ACCT00226-Aug-21 SALE000145CUS0000006EMP00009ACCT00226-Aug-21 SALE000146CUS0000009EMP00006ACCT00226-Aug-21 SALE000147CUS0000011EMP00009ACCT00227-Aug-21 SALE000148CUS0000017EMP00009ACCT00227-Aug-21 SALE000149CUS0000009EMP00009ACCT00228-Aug-21 SALE000150CUS0000013EMP00006ACCT00228-Aug-21 tblSale_Inventory SaleIDInvIDSaleInvQty SALE000001INV000023 SALE000001INV000092 SALE000002INV0001916 SALE000002INV0002332 SALE000003INV000111 SALE000003INV000184 SALE000004INV0001543 SALE000004INV0003041 SALE000005INV0000530 SALE000005INV0000630 SALE000005INV0002017 SALE000005INV0002413 SALE000005INV0002544 SALE000006INV0000434 SALE000006INV0000523 SALE000006INV000067 SALE000006INV0001248 SALE000006INV0001615 SALE000006INV0001912 SALE000006INV0002140 SALE000006INV0003013 SALE000006INV0003319 SALE000007INV0000117 SALE000007INV0002550 SALE000008INV000042 SALE000008INV000132 SALE000009INV000112 SALE000009INV000204 SALE000009INV0002935 SALE000010INV000039 SALE000010INV0000433 SALE000010INV0000850 SALE000010INV0001124 SALE000010INV000154 SALE000010INV0002036 SALE000010INV0002444 SALE000010INV0003322 SALE000011INV000044 SALE000012INV0000348 SALE000012INV0003031 SALE000012INV0003134 SALE000013INV000065 SALE000014INV0000127 SALE000014INV000088 SALE000014INV0001515 SALE000014INV0002023 SALE000014INV0002832 SALE000014INV0002944 SALE000015INV0000437 SALE000015INV000116 SALE000015INV0002239 SALE000015INV0002548 SALE000015INV0003210 SALE000016INV0000530 SALE000016INV0000646 SALE000016INV0000947 SALE000016INV0001011 SALE000016INV0001218 SALE000016INV000144 SALE000016INV0002425 SALE000017INV000045 SALE000017INV0000635 SALE000017INV0000822 SALE000017INV0001024 SALE000017INV0002613 SALE000017INV0002717 SALE000017INV0003340 SALE000018INV000073 SALE000018INV0000915 SALE000018INV0001723 SALE000018INV000299 SALE000018INV0003243 SALE000018INV000332 SALE000019INV000213 SALE000020INV0003225 SALE000020INV000332 SALE000021INV0000323 SALE000021INV0001915 SALE000021INV0002210 SALE000022INV000124 SALE000023INV000025 SALE000023INV000053 SALE000023INV000071 SALE000023INV0002250 SALE000023INV0002938 SALE000024INV000079 SALE000024INV0001843 SALE000024INV0001911 SALE000025INV000291 SALE000026INV0000248 SALE000026INV0001034 SALE000026INV000184 SALE000026INV0002111 SALE000026INV0002523 SALE000026INV0003044 SALE000027INV0000547 SALE000027INV000094 SALE000027INV0001223 SALE000027INV0001532 SALE000028INV000053 SALE000029INV0000447 SALE000029INV0001121 SALE000029INV0003047 SALE000030INV000154 SALE000031INV000023 SALE000032INV0000425 SALE000032INV0000539 SALE000032INV0001417 SALE000033INV000062 SALE000033INV000084 SALE000034INV000071 SALE000034INV000182 SALE000035INV000241 SALE000035INV000273 SALE000036INV0000543 SALE000036INV0001042 SALE000036INV0001145 SALE000036INV0002148 SALE000036INV0002350 SALE000036INV0002921 SALE000037INV0000116 SALE000037INV000197 SALE000038INV0000715 SALE000038INV0001422 SALE000038INV0002634 SALE000038INV0002719 SALE000038INV0003317 SALE000039INV0000827 SALE000039INV0001123 SALE000039INV0002512 SALE000040INV0000424 SALE000040INV0000623 SALE000040INV000159 SALE000040INV0002230 SALE000040INV0002341 SALE000040INV000263 SALE000041INV000103 SALE000042INV000031 SALE000042INV000061 SALE000043INV0001742 SALE000043INV0001939 SALE000044INV0001430 SALE000045INV000183 SALE000045INV000201 SALE000046INV000052 SALE000046INV000173 SALE000047INV0000133 SALE000047INV0000549 SALE000047INV0000720 SALE000047INV0001635 SALE000047INV0001738 SALE000047INV0001927 SALE000047INV000228 SALE000047INV0003232 SALE000048INV0000610 SALE000048INV0000712 SALE000048INV0001228 SALE000048INV0001523 SALE000048INV0001738 SALE000048INV0002533 SALE000048INV0002726 SALE000048INV0003227 SALE000049INV000134 SALE000049INV000262 SALE000050INV0001512 SALE000050INV0001645 SALE000050INV0001813 SALE000050INV0002316 SALE000051INV000031 SALE000051INV000124 SALE000052INV000033 SALE000052INV000171 SALE000053INV000198 SALE000053INV000242 SALE000054INV0000837 SALE000054INV0001425 SALE000055INV000153 SALE000056INV000061 SALE000056INV000201 SALE000057INV0001024 SALE000057INV0002912 SALE000058INV000269 SALE000058INV0003042 SALE000059INV0000845 SALE000059INV000135 SALE000059INV000144 SALE000059INV0001825 SALE000059INV0002313 SALE000059INV0003112 SALE000059INV0003242 SALE000060INV000065 SALE000060INV0002830 SALE000060INV000291 SALE000061INV000171 SALE000061INV000332 SALE000062INV0001123 SALE000062INV0001212 SALE000062INV0001441 SALE000062INV000207 SALE000062INV0002312 SALE000063INV0002937 SALE000063INV0003030 SALE000063INV0003240 SALE000063INV0003314 SALE000064INV000175 SALE000064INV0001848 SALE000064INV0002236 SALE000064INV000266 SALE000065INV000264 SALE000066INV0000539 SALE000066INV0000614 SALE000066INV000099 SALE000066INV000144 SALE000066INV0001545 SALE000066INV0002233 SALE000066INV0002525 SALE000066INV000308 SALE000067INV0000212 SALE000067INV0000533 SALE000067INV0000843 SALE000067INV0001043 SALE000067INV0001518 SALE000067INV0002142 SALE000067INV0003026 SALE000068INV0001236 SALE000068INV0001736 SALE000068INV0001819 SALE000068INV0002319 SALE000068INV0002721 SALE000068INV0003139 SALE000069INV000084 SALE000069INV0000942 SALE000069INV0001534 SALE000069INV0001827 SALE000069INV000194 SALE000069INV0002232 SALE000070INV000201 SALE000070INV000292 SALE000071INV000042 SALE000071INV000262 SALE000072INV0000236 SALE000072INV000055 SALE000072INV0000833 SALE000072INV0001223 SALE000072INV0001743 SALE000072INV0002023 SALE000072INV0002844 SALE000072INV0003129 SALE000073INV000145 SALE000073INV0002719 SALE000074INV000018 SALE000074INV0000528 SALE000074INV0000723 SALE000074INV0001029 SALE000074INV0001443 SALE000074INV0001832 SALE000074INV0002249 SALE000075INV000064 SALE000076INV000012 SALE000077INV000284 SALE000078INV000303 SALE000079INV000064 SALE000080INV000081 SALE000080INV0000926 SALE000080INV000159 SALE000080INV0001948 SALE000080INV0002043 SALE000080INV0002147 SALE000080INV0002421 SALE000080INV0002518 SALE000080INV0003223 SALE000081INV000254 SALE000082INV000094 SALE000082INV000117 SALE000082INV000125 SALE000082INV0002013 SALE000082INV0002325 SALE000082INV0002612 SALE000082INV0002930 SALE000082INV0003130 SALE000083INV0000141 SALE000083INV0000231 SALE000083INV0000934 SALE000083INV000184 SALE000083INV0002027 SALE000083INV0002514 SALE000083INV0002812 SALE000083INV0003135 SALE000083INV0003320 SALE000084INV000194 SALE000085INV000094 SALE000086INV000038 SALE000086INV0000619 SALE000086INV0001739 SALE000086INV0003133 SALE000087INV0000932 SALE000087INV0001539 SALE000087INV000165 SALE000087INV0002611 SALE000088INV000161 SALE000088INV000294 SALE000089INV000094 SALE000090INV0001712 SALE000090INV0002439 SALE000091INV0000222 SALE000091INV0000826 SALE000091INV0001045 SALE000091INV0001241 SALE000091INV0001339 SALE000091INV0002614 SALE000091INV0002938 SALE000091INV0003231 SALE000092INV0001947 SALE000093INV000052 SALE000093INV000193 SALE000094INV0000610 SALE000094INV0000848 SALE000094INV0000915 SALE000094INV0002047 SALE000094INV0002149 SALE000094INV0002336 SALE000094INV0002412 SALE000095INV000141 SALE000096INV000062 SALE000097INV000043 SALE000098INV000021 SALE000098INV0000542 SALE000098INV0000812 SALE000098INV0001027 SALE000098INV0001746 SALE000098INV0002044 SALE000098INV0002217 SALE000099INV0000537 SALE000099INV0000638 SALE000099INV0002150 SALE000099INV0002241 SALE000099INV0002848 SALE000100INV000036 SALE000100INV000068 SALE000100INV0000825 SALE000100INV0001220 SALE000100INV0001849 SALE000100INV0002343 SALE000100INV0002649 SALE000101INV000194 SALE000102INV000132 SALE000102INV000164 SALE000103INV000184 SALE000103INV000202 SALE000104INV000161 SALE000105INV000064 SALE000106INV0000211 SALE000106INV0000731 SALE000106INV0001932 SALE000106INV0002321 SALE000106INV0002440 SALE000106INV0003240 SALE000107INV000062 SALE000107INV000222 SALE000107INV0002534 SALE000107INV0003119 SALE000107INV0003248 SALE000108INV000303 SALE000109INV000096 SALE000109INV0001344 SALE000109INV0001542 SALE000109INV0002514 SALE000109INV0002719 SALE000109INV0002833 SALE000109INV0002924 SALE000109INV0003321 SALE000110INV000014 SALE000110INV000091 SALE000111INV000012 SALE000111INV000193 SALE000112INV0001225 SALE000112INV0003044 SALE000113INV000254 SALE000113INV000261 SALE000114INV000034 SALE000114INV0000625 SALE000114INV0001523 SALE000114INV0001715 SALE000114INV0002015 SALE000114INV0002817 SALE000114INV0002930 SALE000115INV0000237 SALE000115INV0000647 SALE000115INV0000813 SALE000115INV0002133 SALE000115INV000297 SALE000115INV0003118 SALE000116INV0000416 SALE000116INV0000723 SALE000116INV0000913 SALE000116INV0001231 SALE000116INV0002413 SALE000116INV000281 SALE000116INV0003320 SALE000117INV000113 SALE000117INV000153 SALE000117INV000233 SALE000118INV0000117 SALE000118INV000087 SALE000118INV0001425 SALE000118INV0002342 SALE000118INV000245 SALE000118INV0002827 SALE000118INV0003221 SALE000118INV000333 SALE000119INV000244 SALE000119INV000263 SALE000120INV000143 SALE000120INV0001949 SALE000120INV0002131 SALE000120INV0002346 SALE000121INV000101 SALE000121INV000303 SALE000122INV0000149 SALE000122INV0000218 SALE000122INV0001444 SALE000122INV0001744 SALE000122INV0002750 SALE000122INV0003212 SALE000123INV0000415 SALE000123INV0000833 SALE000123INV0001527 SALE000123INV0001618 SALE000123INV000195 SALE000123INV0002444 SALE000123INV0002936 SALE000123INV0003245 SALE000124INV0000241 SALE000124INV0000436 SALE000124INV0000518 SALE000124INV000077 SALE000124INV0000818 SALE000124INV0001450 SALE000124INV0001847 SALE000124INV000215 SALE000124INV0002232 SALE000124INV0002544 SALE000125INV0000921 SALE000125INV0001526 SALE000125INV0001927 SALE000125INV0003028 SALE000126INV0000339 SALE000126INV0002317 SALE000126INV000244 SALE000126INV0002524 SALE000126INV0002944 SALE000127INV0000319 SALE000127INV0000411 SALE000127INV0000637 SALE000127INV0001318 SALE000127INV0002350 SALE000127INV0002720 SALE000127INV0002939 SALE000127INV0003221 SALE000128INV000203 SALE000128INV000223 SALE000129INV000061 SALE000129INV000183 SALE000130INV000264 SALE000130INV000302 SALE000131INV0000828 SALE000131INV0002241 SALE000132INV0000233 SALE000132INV000161 SALE000132INV0002048 SALE000132INV0002517 SALE000132INV0002948 SALE000133INV0001818 SALE000133INV000229 SALE000133INV0002419 SALE000133INV0002530 SALE000133INV0002623 SALE000133INV0002730 SALE000133INV0002927 SALE000133INV0003349 SALE000134INV000044 SALE000134INV000232 SALE000135INV0000139 SALE000135INV0000239 SALE000135INV000067 SALE000135INV0001148 SALE000135INV000186 SALE000135INV0002626 SALE000135INV0002917 SALE000135INV0003210 SALE000136INV0000429 SALE000136INV0000722 SALE000136INV0001045 SALE000136INV0001432 SALE000136INV000184 SALE000136INV0002727 SALE000136INV0002829 SALE000136INV0003118 SALE000137INV000194 SALE000137INV0002446 SALE000137INV0002918 SALE000137INV0003248 SALE000138INV000033 SALE000138INV000212 SALE000139INV0001923 SALE000140INV0001144 SALE000140INV0001548 SALE000140INV0001749 SALE000140INV0002033 SALE000140INV0002314 SALE000140INV0002448 SALE000141INV000162 SALE000142INV0000550 SALE000142INV000062 SALE000142INV0000843 SALE000142INV0001419 SALE000142INV0002742 SALE000143INV000174 SALE000144INV000234 SALE000145INV0000922 SALE000145INV0001121 SALE000146INV0000336 SALE000146INV0000525 SALE000146INV0000611 SALE000146INV0001213 SALE000146INV0001418 SALE000146INV0002111 SALE000146INV0002232 SALE000147INV0000930 SALE000147INV0001620 SALE000147INV0002113 SALE000147INV000239 SALE000147INV0003239 SALE000147INV0003333 SALE000148INV000012 SALE000148INV000183 SALE000149INV0001218 SALE000149INV0001549 SALE000149INV0002046 SALE000150INV000033 SALE000150INV000301 tblHoneyType HoneyTypeHoneyTypeDescription HTYPE001Regular HTYPE002Clover HTYPE003Apple Blossom tblContainerType ContainerType Bucket Can Honey Bear Jar tblContainerSize ContainerSizeContainerOunces 10 oz10 16 oz16 18 oz18 22 oz22 48 lb640 5 lb64 6 oz6 8 oz8 tblState StateIDStateName AKALASKA ALALABAMA ARARKANSAS AZARIZONA CACALIFORNIA COCOLORADO CTCONNECTICUT DCDISTRICT OF COLUMBIA DEDELAWARE FLFLORIDA GAGEORGIA HIHAWAII IAIOWA IDIDAHO ILILLINOIS ININDIANA KSKANSAS KYKENTUCKY LALOUISIANA MAMASSACHUSETTS MDMARYLAND MEMAINE MIMICHIGAN MNMINNESOTA MOMISSOURI MSMISSISSIPPI MTMONTANA NCNORTH CAROLINA NDNORTH DAKOTA NENEBRASKA NHNEW HAMPSHIRE NJNEW JERSEY NMNEW MEXICO NVNEVADA NYNEW YORK OHOHIO OKOKLAHOMA OROREGON PAPENNSYLVANIA RIRHODE ISLAND SCSOUTH CAROLINA SDSOUTH DAKOTA TNTENNESSEE TXTEXAS UTUTAH VAVIRGINIA VTVERMONT WAWASHINGTON WIWISCONSIN WVWEST VIRGINIA WYWYOMING tblAcctType AcctTypeIDAcctTypeDescription ACCTTP001Payroll ACCTTP002Operating ACCTTP003Savings tblCustomerType CustTypeIDCustTypeDescription CUSTYP001Private CUSTYP002Commercial tblEmployeeType EmpTypeIDEmpTypeDescription EMPTYP01Salary EMPTYP02Hourly tblEmployeePosition EmpPositionIDEmpPositionDescription EMPPOS01Owner EMPPOS02Manager EMPPOS03Worker EMPPOS04Sales 1. Python program file—25%: Upload your Python program. Your teacher will evaluate it according to these criteria: a. Your program is divided into functions and each function performs one task only. b. Your program effectively uses existing Python modules such as math, random, requests, pandas, and tkinter. c. Your program performs a significant real world task. 2. Python test file—15%: Upload your Python test file. Your teacher will evaluate it according to these criteria: a. Each testable program function is covered (tested) by one test function. (Some functions, especially main and those that create GUIs are difficult to test and don't need to have a corresponding test function.) b. Each test function completely exercises (tests) its corresponding program function. In other words, the test function calls the program function multiple times with different arguments, including unusual or unexpected values. Write a program that takes input from user for End Date that they want to find out gross margin for from set of data you are using and then returns a calculated gross margin for that date to the user. Make sure to use python modules such as Math, Random, request, pandas, tkinder as much as possible. Hnt: You could use math modules while calculating your total sales, total costs, gross profit and gross margin. A test function is must, review no. 2 above. If [Inv Container Type] = "Honey Bear" THEN ([Inv Selling Price]*(1.56*[Sale Inv Qty])) - ([Inv Cost]*(1.56* [Sale Inv Qty])) ELSE (([Inv Selling Price]*[Sale Inv Qty]) - ([Inv Cost]* [Sale Inv Qty])) END