Analysis of Purchase Orders by Supplier Group and Amount
School
Dixie State University**We aren't endorsed by this school
Course
ACCT 3050
Subject
Industrial Engineering
Date
Dec 11, 2024
Pages
4
Uploaded by Nikeeyre
Tanner Eyre - Lab 6-1 6-1MA I Total Purchases by Supplier Group = Count of Purchase Order ID 1 — 277 CONTRACTORS, CONC. OFFICE, PHi AL'S LIES. CTION MAT. COMMERCIAL EQUIP. STATIONERY,OFFICE S COMPUTER HOME SUPPLY UTILITIES C DURABLE ¢ EMPLOYMENT Al OTIVE Supplier_Group AUIC RE ST PROFESSIONAL SERV! 10 0.0M 0.1M Sum of Purchase_Order_Amount_Local 0.2M 0.17M Business_Unit_D... DEPARTMENT O... v Month August Day 1 3 O—C 6-1MB Tgt“;'lu Purchases by SuppliermGroup 10 CONTRACT... OFFICE, PH... INDUSTRIAL... CONSTRUC... CHARITABL... AUTOMOTL... COMMERCI... STATIONER... COMPUTER... HOME SUP... UTILITIES-EL... DURABLE G... Supplier Group count of Pos 1 | -7/ I 00 I o7 I o.1om I o.09m I oosv B oosv B oo™ I oorm B o.o6m B oosm Il oosm Il oosm 0.0M 0.2M Total Purchase Amount Totawlm;urchases by Day @ Sum of Purchase_Order_A... ® Count of Purchase._... o ] < 0.1M Total Purchase Order Amounts 0.0M 40 100 50 Count of Purchase Orders Tikterz an this page ¥ H £ | 3 ] g 2 Y Filters » O searcn £33 data Sekds nere Ade cata Felds here Dl theugh < ort Kzl fibers 444 ariFthrough hecs here Business_Unit_D... DEPARTMENT O... vV £ Month August v Day ] 31 o——o0 Purchase_Order_ID Purchase_Order_Date Entered_By Supplier_Account_Name Supplier_Group Sum of Purchase_Order_Amount_Local AAAJGhAAEAAGD/OAAA Monday, August 12, 2019 J Barnes ASPHALT PRODUCERS INC CONTRACTORS, CONCRETE WORK 1,477.22 AAAJGhAAEAAGD/OAAA Tuesday, August 13, 2019 T Ham DALE ROGERS TRAINING CENT ~ PHOTOFINISHING LABORATORIES, PHOTO DEVEL 147.84 AAAJGhAAEAAGD/0OAAB Monday, August 12, 2019 J Harrold ATWOOD 36 CUSHING HARDWARE STORES 79.35 AAAJGhAAEAAGD/0OAAB Monday, August 12, 2019 L Bautista SOUTHWES 5262108089586 SOUTHWEST AIRLINES 31.16 AAAJGhAAEAAGD/OAAC Monday, August 12, 2019 L Bautista AGENT FEE 8900771507185 AIRLINES, AIR CARRIERS 25.00 AAAJGhAAEAAGD/OAAC Tuesday, August 13, 2019 M Henry OKC/EZ-PAY UTILITIES-ELEC/GAS/HEAT OIL/SANITARY/WTR 38.59 AAAJGhAAEAAGD/OAAD Tuesday, August 13, 2019 J Bellew ATT BILL PAYMENT TELECOMMUNICATION SERV.INCLUD. LOCAL/L.D 2,674.76 AAAJGhAAEAAGD/OAAD Tuesday, August 13, 2019 M Henry OG&E/USPAYMENTSBILLPAY UTILITIES-ELEC/GAS/HEAT OIL/SANITARY/WTR 181.75 AAAJGhAAEAAGD/OAAE Wednesday, August 07, 2019 S Bradt BEST WESTERN PLUS GUYM BEST WESTERN HOTELS 94.00 AAAJGhAAEAAGD/OAAE Tuesday, August 13, 2019 M Henry OG&E/USPAYMENTSBILLPAY UTILITIES-ELEC/GAS/HEAT OIL/SANITARY/WTR 97.47 AAAJGhAAEAAGD/OAAF Wednesday, August 07, 2019 S Bradt BEST WESTERN PLUS GUYM BEST WESTERN HOTELS 94.00 AAAJGhAAEAAGD/OAAF Tuesday, August 13, 2019 M Henry TRI COUNTY ELECTRIC COOP UTILITIES-ELEC/GAS/HEAT OIL/SANITARY/WTR 365.32 AAAJGhAAEAAGD/OAAG Wednesday, August 07,2019 S Bradt BEST WESTERN PLUS GUYM BEST WESTERN HOTELS 94.00 Total 1,504,363.55 Y Filters Search Filters on this page Add data field Filters on all pages Add data field
« > - 0] ] Analybes \ PCardD los phon Purchase Order Date wrchase Order Flzcal Year M Purchase Order Ameurt L. Lab 51 OK PLang Dats (C Measure Vabes €se-0 Dashboard ayour Default o Dewee Pravies Akomat = Sheets 3} Total Purchaas ) Show dashboarc title lotal Purchases by Supplier Group 8 8-C- | B-d @R- e- . < Raw Sappliee Group £ Suppher Ir'wu‘; Marks D 0 Jras =] sTa - g > : == — e =1 4cccs AND Scuck = Rra = ol — R ER SERY CES-AIR = €D AIRLINES =) - 2] B : g — Purchaze Order Amount Local Total Purchases by Day Purchase Details Purchase Order 1D ARAIGHAAFAAGAdARL ARAJGNAAEARGDAJARL ABAJGROAEAAGDAAALC AMAJGRAAEMAGHAJAAD adALl A0 BAJGRAAEALGEAGARP & ABAIGRAAFARGLAIARG AMAJGROACAAGBAGAR ABAJGNAAEARGLAJARY AAIGAA r Amount Purchase Orcer Amount Local & Purchase Order Date Supplier Account Name Purchase Trends Duy of Purchase Order Date Supplier Group da- Ameurt Local : a o M @ CNT(Purchaze Order L ' Show Me Weasure Nam I Count ot Purel urihans Orde
6-1MC Clipboard Dat: Total Purchases by Supplier Group Queries nsert Total Purchases by Day Calculations Sensitivity Share "PO Count by PO Amount Y B2 - 1 Business_Unit_D... Count of POs 1 _ 277 @ Sum of Purchase_Order_Amoun... @ Count of Purchase_Or... | Entered By @ Cluster1 @ Cluster2 @Cluster3 » | DEPARTMENT O... v 10 CONTRACTO... I 00V ° Month OFFICE, PHO... I 0V ” 03M August v INDUSTRIAL ... I oo § 02M L CONSTRUCTL.. I o.09m g 10 3 § Day § CHARITABLE ... B oosv ; ; £ . ] S AuTOMOTV.. I oosv g &, E : ° | 5 COMMERCIA.. B oom 2 g5 3 § STATIONERY,... I oo _g 0.1M % fi O_O @A COMPUTERS,. B o0.0sM 5 0= S HOME SUPP... Bl oosm % 3 20w L [&] PY ® o UTILITIES-ELE... Il oosm ° DURABLE GO... Bl oosm (1} EMPLOYMEN... : ® ®e ° M oom 0.0M 0 0.0M & 8o % ¢ ° 0.0M 0.2M 20 40 0 50 Total Purchase Amount Day L Count of=Purchase Order j EurchasefiOrderfiID Purchase_Order_Date Entered_By Supplier_Account_Name Supplier_Group Sum of Purchase_Order_Amount_Local ¢ AAAJGhAAEAAGb/OAAA Monday, August 12, 2019 J Barnes ASPHALT PRODUCERS INC CONTRACTORS, CONCRETE WORK 1,477.22 AAAJGhAAEAAGb/OAAA Tuesday, August 13, 2019 T Ham DALE ROGERS TRAINING CENT ~ PHOTOFINISHING LABORATORIES, PHOTO DEVEL 147.84 AAAJGhAAEAAGb/OAAB Monday, August 12, 2019 J Harrold ATWOOD 36 CUSHING HARDWARE STORES 79.35 AAAJGhAAEAAGb/OAAB Monday, August 12, 2019 L Bautista SOUTHWES 5262108089586 SOUTHWEST AIRLINES 31.16 AAAJGhAAEAAGbL/OAAC Monday, August 12, 2019 L Bautista AGENT FEE 8900771507185 AIRLINES, AIR CARRIERS 25.00 AAAJGhAAEAAGb/OAAC Tuesday, August 13, 2019 M Henry OKC/EZ-PAY UTILITIES-ELEC/GAS/HEAT OIL/SANITARY/WTR 38.59 AAAJGhAAEAAGDL/OAAD Tuesday, August 13, 2019 J Bellew ATT BILL PAYMENT TELECOMMUNICATION SERV.INCLUD. LOCAL/L.D 2,674.76 AAAJGhAAEAAGbL/OAAD Tuesday, August 13, 2019 M Henry OG&E/USPAYMENTSBILLPAY UTILITIES-ELEC/GAS/HEAT OIL/SANITARY/WTR 181.75 AAAJGhAAEAAGb/OAAE Wednesday, August 07, 2019 S Bradt BEST WESTERN PLUS GUYM BEST WESTERN HOTELS 94.00 AAAJGhAAEAAGDL/OAAE Tuesday, August 13, 2019 M Henry OG&E/USPAYMENTSBILLPAY UTILITIES-ELEC/GAS/HEAT OIL/SANITARY/WTR 97.47 AAAJGhAAEAAGbL/OAAF Wednesday, August 07, 2019 S Bradt BEST WESTERN PLUS GUYM BEST WESTERN HOTELS 94.00 AAAJGhAAEAAGbL/OAAF Tuesday, August 13, 2019 M Henry TRI COUNTY ELECTRIC COOP UTILITIES-ELEC/GAS/HEAT OIL/SANITARY/WTR 365.32 AAAJGhAAEAAGb/OAAG Wednesday, August 07, 2019 S Bradt BEST WESTERN PLUS GUYM BEST WESTERN HOTELS 94.00 Total 1,504,363.55 6-1TC Y Filters P search Filters on this v Count of Purc is (All) Entered_By is (Al) Entered_By (c is (All) Sum of Purch is (All) Add dat Filters on this p Add dat Filters on all pa Add dat
# €>e-08 Dubourd | Layout < oeft Prone See Avtomatic - Sheets ] 3 Total Purchases. 3 TotalPurchases. Purchase Datais. rchase c) Objects, 9 Horizonts Cantainer B Vertcal Contaner Flostrs. 71 Show dashboard e 8-c-m-oa- Total Purchases by Supplier Group Purchase Details Purchase Order 1D AAAIGHAAEAAGbAdARS AAAIGRAAEAAGBAJARD AARJGRAREAAGBAJARC AARJGRAAEAAGBAJARD AMAIGHMEAAGLAJARE AARIGAAEARGLAJARW TR [Emmever -] WD @ Total Purchases by Day Purchas Order Amount Loca haseOnder Enteraty Supplirhccoun Name Doy of Purchase Oder Date SupplierGroup D = Showkie Purchase Clusters i g oo £o %o so Count of Purchase Order 1D o o ot Yearof purcher 5 iness UnitDescript ountof urchase Clsters