The SalesTrans sheet displays sales transactions for the month of September 2021. Create a Transaction_ID number for each sales transaction on the SalesTrans sheet. Place a formula in cell A5 of the SalesTrans sheet that uses the TEXT, LEFT, and RIGHT functions as well as something to join text strings. The Transaction_ID should begin with Date in DDMMYY format. The Date should be followed by the first 5 characters of the Customer_ID. The first 5 characters of the Customer_ID should be followed by the right 7 characters of the Product_ID. (For example, the Transaction_ID in cell A5 should be: 010921MB628-NBS420.) Copy the formula in cell A5 to cell range A6:A210.
AutoSave ON RO. 2 ACIS 2504 Excel Spreadsheet Project LastFirst.xlsx - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Clear G Connections Properties 21 Y + LO Currencies Era Data from Picture Flash Fill FX Data Validation Text to Remove Duplicates - Consolidate Columns HE 2 What if Analysis Group al Ungroup Subtotal Get Data Analysis Tools Data Analysis 2. Solver Reapply Y Advanced Refresh All Stocks Geography * Sort Filter Edit Links E6 fx =PROPER(RIGHT(B6, LEN(FIND(B6,"*",-1)))) ((') C D G H K Hokie Fitness Equipment & Accessories, Inc. 2 3 Date 10/1/21 5 Imported Data EGE-UAM405721M BAGS GB 7 GB-UAM34373GM Mis A GB-UAS378725'GM bags 9 GB-UAS212790"GyM DAGS 10 GB-UAL43731"Gymbres 11 GB-UAL91770'GM bags 12 GB-NRM48R779'SYM BAGS 13 GB NEM271740"GYM BAGS 14 GB-NBL468762'Gymbos 15 GE-NBL242750 MM 16 GB N3542029"GYM BAGS 17 GB-NBS453732'Gymbags 18 \" FT-FC33627404 NextracKER 19 FT-FC3435746"ATNES Tracker 20 FT-FV5462?7 NesstexKER 21 FT-FVS4457257 NextracKER 22 FT-FIW346749 Ness traxKER 23 FT-FIW385761' fiestaKER 24 FT-GV361716" Tess trackER 25 FT GV315491fNeztracker 26 FT-SGF164725 Fitness trackER 27 FT-SGF37754 litnesstraKER 22 ED SKI272 6 carUDS 29 EB-SKI420757'esBUDS 30 EB-JIP139785ear BUDS 31 EB JJP137?35* RSUDS 32 EB-P196787'erBUDS 33 EE-IF2402747"carBUDS 34 EB JF2157732carBUDS 35 CD-1970759 UDS 36 EB-JIS257737"ear SUDS 37 ? EB JJS275?1.carBUOS 38 EB-SKS163778'er BUDS 39 EE-SKS132794ear SUDS 40 EB SKS1S0286cardUDS 41 WB-V2R124M3'WATER BOTtles - 42 WR-Y2R493713 WATER BOTles Product Information GB-UAN 405721"Gym Mis GE-UAM343?35 YM BAGS GC-UAS378725'OMNOS GB-U45212790MBAGS GE-WAL43731"GyMAGS GE-UALS 1770 Mb/s GE-NBM 488779 GYM BAGS GENB271240*Mbres GC-NBL468752'GyMAGs GB-NBL242750G/ MAGA GE-N3542079 GYM Mas GE-NB5453732GM bags FT-FC3352740 "RITNESS trackER FT-FC343524G ATNess trackER FT-FV546277 fitness RACKER FT-FV5445725nThe trackFR FTFIW246249Ness trackER FT-FIW38561' fitness trackER FT-GV361716 "Te Tracker FT GV315491* Nextracker FT-SGF154225"NestracKER FT-SGF37764f1Ness trackER EB SK12726'erbos EB-SK1420257'erBUDS ER-UP139785ABUDS ED UP137235*careupS CD-UP196787'eraUDC that ER-JF2402747"BUDS EDJF2157792"carbos CD-9470759 BUDS ER-15257737*arRUDS EB-15275211 BUDS EB- SKS163778'DUDS ER-SK5132794areuds EB SK515025G careUDS WG-Y2R124743'WATER DOTUS WE-V2R492713 "WATER POT Product_ID GE-UAM 405 GE LAM343 GE-UAS378 - GE-LAU12 GB VAL43 GE-UALS1 GE-NB48R GB NBM27 GE-N3468 GENBL242 GB N35423 GE-N35453 FT-FC3352 FT FC3435 FT-FV8462 FT-FV5445 FT-FIW240 FT-FIW385 FT-GV861 FT GV3154 FT-SGF164 FT-SGF37 EB SK1272 EB-SK1420 FR-UP139 EB P137 EB-UP156 ER-JF2402 EB JF2157 CB-15470 CD FR-UD57 EBJ05275 EB- SK5163 FR-SK5132 EB SK5150 WE-Y2R120 WE-V2 R493 Warehouse_Bin Category 21 1 HVALUE FVALUE 25 WALVE 90 HVALUE 31 HVALUE 70 INVALVE 79 WALUE 40 PVALUE 62 WALVE 50 WALUE S 9 PVALUE 32 WALVE 40 VALUE 45 PVALUE 7 7 WALVE 25 VALUE 49 PVALUE 61 WALVE! 16 VALUE 91 HVALUE 25 INALUE ! 64 WALLE! 6 HVALUE 57 WALVE! 85 WALUE NI 35 PVALUE 87 WALUE 47 F WALUE 32 HVALUE 69 WALUE 37 WALUE 11 HVALUE WALUE 94 WALUE 56 PVALUE 43 WALVE! 13 7 HVALUE Product_Description Under Armour Undeniable 3.0 Medium Under Armour Undeniable 3.0 Medium Under Armour Undeniable 3.0 Small Under Armour Undeniable 3.0 Small Under Armour Undeniable 3.0 Large Under Armour Undeniable 3.0 Large Nike Brasilia & Medium Nike Brasilia & Medium Nike Brasilia & Large Nike Brasilia & Large Nike Brasilia 3 Small & Nike Brasilia & Small Fitbit Charge 3 Activity Tracker Fitbit Charge 3 Activity Tracker Fitbit Verse Smartwatch Fitbit Vers Smartwatch Fitbit Ionie Watch Fitbit lonic Watch Garmin Vivofit Activity Tracker Garmin Vivofit 3 Activity Tracker Samsung Gear Fit2 Smart Fitness Band Samsung Gear Fit2 Smart Fitness Bund Skullcandy ink'd Skullcandy Ink'd Jlab Juda Pro Bluetooth Jlab.Buds Pro Bluetooth JlsbJBuds Pro Bluetooth Jlab Fit 2.0 Bluetooth Sport Jlab Fit 2.0 Bluetooth Sport Jlab buds Pro Signature Jabbude Pro Signatura Jlab buds Pro Signatura Skullcandy SP Chups Skullcandy SP Chaps Skullcandy SP Chops YETI 20 ug Rambler Tumbler YETI 20 os. Rambler Tumblr Color Black Blue Black Blue Back Blue Black Blue Black Blue Black Blue Black Gol: Black Gold Black Blue Black White Black Pink Black Blue Black Blue Greer Black Blue Black Blue Grear Blue Bill Black Pink Blue Black Cost_per_Unit Card_Price Non_Card_Price $27.89 $44.99 $46.99 $27.89 $44.99 $46.99 $24.79 $39.95 $41.99 $24.79 $39.99 $41.99 $32.85 $32.95 $54.95 $32 85 S52.99 $54.95 $24.00 $40.00 $42.00 $24.00 $40.00 $42.00 $30.00 $50.00 $52.50 $30.00 $50.00 $52.50 $21.00 $35.00 $36.75 $2100 $35.00 $36.75 $97.47 $149.95 $157.45 $97.47 $149.95 $157,45 $12997 $199.95 $209.95 $129.97 $199.95 $209.95 $194.95 $299.95 $314.95 $194 95 $299.95 $314.95 $51.99 $79.99 $ SR3.99 $51.99 $79.99 $83.99 $116.99 $179.99 $188.99 $116.99 $179.99 $18.99 $9.59 $15.99 $16.79 $9.59 $15.95 $16.79 $11.99 $19.99 $20.99 $11.99 $19.99 $20.99 $11.99 $19.95 $20.99 $17.99 $29.99 $81.49 $ $ $17.99 $29.99 $31.49 $5.99 $9.99 $10.49 $5.99 $9.99 $ $10.49 $5.99 $9.99 $10.49 $1199 $19.95 $20.99 $11.99 $19.99 $ $20.99 $11.99 $19.99 $20.99 $18.59 $29.95 $31.49 $1859 $29.99 $31.49 Honor Code Documentation Inventory SalesTrans Customer Data Miscinfo Monthly Payment Calculator Sales Pivot Employee Schedule Database Summary Advanced + Ready 1 + 100% AutoSave ON APO... ACIS 2504 Excel Spreadsheet Project LastFirst.xlsx - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) v 11 ~ A ab Wrap Text General AYO G v SIE Conditional Format Cell Insert Delete Format Formatting es Table Styles FO) IN Analyze Data Pastc BIU 7 A Y = = = Y Merge & Center Y Find & v Sort & Filter Select H5 fx B D F G H T K L L M N O Hokie Fitness Equipment & Accessories, Inc. 2 Sales Transactions for September 2021 3 4 Transaction ID Card Type $0.00 7 1 Online 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Date Product ID Customer_ID Warehouse Bin Quantity Sold Sales Type 9/1/21 GB-NBS120 M062831 AVALUE! 2 Online 9/121 W.Y2R124 MC46295 AVA UEL 1 Oriline 9/1/21 ED SK1272 MD10BTG VALUEI Z 2 In store 9/1/21 GB-NBM271 MD27726 AVALUE! 9/1,21 ER-JP137 MRA1502 VALUE 2 Online 9/1/21 GB NE5453 XXXXCXX #VALUE! i in store 9/2/21 CM-SOL7343 MC22709 AVALUE! 1 Online 9/2/21 ER-SKI272 MC32107 VALUE 2 In-store 9/2/21 CM NDT220 MD24385 #VALUE! 1 In store 9/2/21 CM-NDT220 - MD56307 AVALUE! 1 in-store 9/2/21 WS-HF42.RO XXXXXXX VALUE 2 Oriline 9/2/21 EB J.5470 XXXXXXX #VALUE! 2 in store 9/3/21 F-GV361 MD25494 AVALUE! 1 Online 9/3/21 FT-C3362 MCS4593 VALUE 1 Online 9/3/21 WS-Y2R2GS MD2438! #VALUE! 2 In store 9/3/21 ED-JS170 ME64082 AVALUE! 1 In-store 9/3/21 HG-AFX107 XXXXXXX VALUE 1 Online 9/3/21 GB LAN843 XXXXXXX - #VALUE! 2 in store 9/4/21 CM-SOL7343 MD35019 AVALUE! 1 Online 9/4/21 WS-Y2R493 M36025 WB VALUE 3 In-store 9/4/21 FT-FVS4G2 MC39104 #VALUE! i Crline 9/9/21 GB-UM05 MC53802 AVALUE! 1 Online 9/4/21 CM-SCHRIO ME21567 VALUE 1 Online 9/4/21 FT GV3154 ME26013 AVALUE! 1 In store 9/9/21 CD-JF2402 MES8417 AVALUE 1 Online 9/421 CM-NDT425 MF6R107 VALUFI 1 Online 9/4/21 FT GV8154 MR92834 AVALUE! 1 Online 9/4/21 WL-FGR160 XOXXXOXXX AVALUE 1 Online 9/5/21 GENR5420 MA20736 VALUFI 2 In-store 9/5/21 WL FGR116 MC39104 AVALUE! 1 Online 9/5/21 WYRZES MD27726 AVALUE 3 in-store 9/5/21 W.Y2R176 MD33404 AVALLEI 1 line 9/5/21 ED SKI272 MD49:19 AVALUE! 2 Online 9/5/21 WB-HF3143 ME64082 AVALUE! 1 Orline 9/5/21 WL-BFX234 MEOR417 AVALUEI 1 Online 9/5/21 GB LIALS1 MR70078 VALUE! 2 In store 9/5/21 FT-SGF164 MR82864 AVALUE! 1 Orline 9/5/21 WL-FGR447 XXXXXXX VALUFI 1 1 in-store Category WALUE! WVALUEI WALUE! WALUE! WALUEI #VALUE! WALUE! WALUEI #VALUE! WALUE! WALUEI #VALUE! WALUE! WALLEI #VALUE! WALUE! WALLEI #VALUE! WALUE! WALLEI #VALUE! WALUE! WALUEI Cost per Unit Price per Unit $21.00 $18.50 $9.59 $24.00 $11.99 $21.00 $946.95 $9.59 $591.84 $591.84 $25.77 $5.99 $51.99 $97.47 $21.69 $5.99 $355.10 $27.89 $946.95 $18.59 $129.97 Total Sales Shipping Handling Cost Sales Taxes Total Due $0.00 $ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 32 33 34 35 36 37 38 39 40 WALUE! WALUE! WALUEI #VALUE! WALUE! WALUEI #VALUE! WALUE! ! VALLEI #VALUE! WALUE! WVALLEI ALUT WALUE! WALUE! WALUEI $710.21 $51.99 $17.99 $946.95 $51.99 $147.96 $21.00 $236.73 $21.69 $18.59 $9.59 $24.77 $236.73 $32.85 $116.99 $165.71 41 42 Inventory Sales Trans Customer Data Miscinfo Monthly Payment Calculator Sales Pivot Employee Schedule Database Summary + Ready + 100% AutoSave ON RO. 2 ACIS 2504 Excel Spreadsheet Project LastFirst.xlsx - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Clear G Connections Properties 21 Y + LO Currencies Era Data from Picture Flash Fill FX Data Validation Text to Remove Duplicates - Consolidate Columns HE 2 What if Analysis Group al Ungroup Subtotal Get Data Analysis Tools Data Analysis 2. Solver Reapply Y Advanced Refresh All Stocks Geography * Sort Filter Edit Links E6 fx =PROPER(RIGHT(B6, LEN(FIND(B6,"*",-1)))) ((') C D G H K Hokie Fitness Equipment & Accessories, Inc. 2 3 Date 10/1/21 5 Imported Data EGE-UAM405721M BAGS GB 7 GB-UAM34373GM Mis A GB-UAS378725'GM bags 9 GB-UAS212790"GyM DAGS 10 GB-UAL43731"Gymbres 11 GB-UAL91770'GM bags 12 GB-NRM48R779'SYM BAGS 13 GB NEM271740"GYM BAGS 14 GB-NBL468762'Gymbos 15 GE-NBL242750 MM 16 GB N3542029"GYM BAGS 17 GB-NBS453732'Gymbags 18 \" FT-FC33627404 NextracKER 19 FT-FC3435746"ATNES Tracker 20 FT-FV5462?7 NesstexKER 21 FT-FVS4457257 NextracKER 22 FT-FIW346749 Ness traxKER 23 FT-FIW385761' fiestaKER 24 FT-GV361716" Tess trackER 25 FT GV315491fNeztracker 26 FT-SGF164725 Fitness trackER 27 FT-SGF37754 litnesstraKER 22 ED SKI272 6 carUDS 29 EB-SKI420757'esBUDS 30 EB-JIP139785ear BUDS 31 EB JJP137?35* RSUDS 32 EB-P196787'erBUDS 33 EE-IF2402747"carBUDS 34 EB JF2157732carBUDS 35 CD-1970759 UDS 36 EB-JIS257737"ear SUDS 37 ? EB JJS275?1.carBUOS 38 EB-SKS163778'er BUDS 39 EE-SKS132794ear SUDS 40 EB SKS1S0286cardUDS 41 WB-V2R124M3'WATER BOTtles - 42 WR-Y2R493713 WATER BOTles Product Information GB-UAN 405721"Gym Mis GE-UAM343?35 YM BAGS GC-UAS378725'OMNOS GB-U45212790MBAGS GE-WAL43731"GyMAGS GE-UALS 1770 Mb/s GE-NBM 488779 GYM BAGS GENB271240*Mbres GC-NBL468752'GyMAGs GB-NBL242750G/ MAGA GE-N3542079 GYM Mas GE-NB5453732GM bags FT-FC3352740 "RITNESS trackER FT-FC343524G ATNess trackER FT-FV546277 fitness RACKER FT-FV5445725nThe trackFR FTFIW246249Ness trackER FT-FIW38561' fitness trackER FT-GV361716 "Te Tracker FT GV315491* Nextracker FT-SGF154225"NestracKER FT-SGF37764f1Ness trackER EB SK12726'erbos EB-SK1420257'erBUDS ER-UP139785ABUDS ED UP137235*careupS CD-UP196787'eraUDC that ER-JF2402747"BUDS EDJF2157792"carbos CD-9470759 BUDS ER-15257737*arRUDS EB-15275211 BUDS EB- SKS163778'DUDS ER-SK5132794areuds EB SK515025G careUDS WG-Y2R124743'WATER DOTUS WE-V2R492713 "WATER POT Product_ID GE-UAM 405 GE LAM343 GE-UAS378 - GE-LAU12 GB VAL43 GE-UALS1 GE-NB48R GB NBM27 GE-N3468 GENBL242 GB N35423 GE-N35453 FT-FC3352 FT FC3435 FT-FV8462 FT-FV5445 FT-FIW240 FT-FIW385 FT-GV861 FT GV3154 FT-SGF164 FT-SGF37 EB SK1272 EB-SK1420 FR-UP139 EB P137 EB-UP156 ER-JF2402 EB JF2157 CB-15470 CD FR-UD57 EBJ05275 EB- SK5163 FR-SK5132 EB SK5150 WE-Y2R120 WE-V2 R493 Warehouse_Bin Category 21 1 HVALUE FVALUE 25 WALVE 90 HVALUE 31 HVALUE 70 INVALVE 79 WALUE 40 PVALUE 62 WALVE 50 WALUE S 9 PVALUE 32 WALVE 40 VALUE 45 PVALUE 7 7 WALVE 25 VALUE 49 PVALUE 61 WALVE! 16 VALUE 91 HVALUE 25 INALUE ! 64 WALLE! 6 HVALUE 57 WALVE! 85 WALUE NI 35 PVALUE 87 WALUE 47 F WALUE 32 HVALUE 69 WALUE 37 WALUE 11 HVALUE WALUE 94 WALUE 56 PVALUE 43 WALVE! 13 7 HVALUE Product_Description Under Armour Undeniable 3.0 Medium Under Armour Undeniable 3.0 Medium Under Armour Undeniable 3.0 Small Under Armour Undeniable 3.0 Small Under Armour Undeniable 3.0 Large Under Armour Undeniable 3.0 Large Nike Brasilia & Medium Nike Brasilia & Medium Nike Brasilia & Large Nike Brasilia & Large Nike Brasilia 3 Small & Nike Brasilia & Small Fitbit Charge 3 Activity Tracker Fitbit Charge 3 Activity Tracker Fitbit Verse Smartwatch Fitbit Vers Smartwatch Fitbit Ionie Watch Fitbit lonic Watch Garmin Vivofit Activity Tracker Garmin Vivofit 3 Activity Tracker Samsung Gear Fit2 Smart Fitness Band Samsung Gear Fit2 Smart Fitness Bund Skullcandy ink'd Skullcandy Ink'd Jlab Juda Pro Bluetooth Jlab.Buds Pro Bluetooth JlsbJBuds Pro Bluetooth Jlab Fit 2.0 Bluetooth Sport Jlab Fit 2.0 Bluetooth Sport Jlab buds Pro Signature Jabbude Pro Signatura Jlab buds Pro Signatura Skullcandy SP Chups Skullcandy SP Chaps Skullcandy SP Chops YETI 20 ug Rambler Tumbler YETI 20 os. Rambler Tumblr Color Black Blue Black Blue Back Blue Black Blue Black Blue Black Blue Black Gol: Black Gold Black Blue Black White Black Pink Black Blue Black Blue Greer Black Blue Black Blue Grear Blue Bill Black Pink Blue Black Cost_per_Unit Card_Price Non_Card_Price $27.89 $44.99 $46.99 $27.89 $44.99 $46.99 $24.79 $39.95 $41.99 $24.79 $39.99 $41.99 $32.85 $32.95 $54.95 $32 85 S52.99 $54.95 $24.00 $40.00 $42.00 $24.00 $40.00 $42.00 $30.00 $50.00 $52.50 $30.00 $50.00 $52.50 $21.00 $35.00 $36.75 $2100 $35.00 $36.75 $97.47 $149.95 $157.45 $97.47 $149.95 $157,45 $12997 $199.95 $209.95 $129.97 $199.95 $209.95 $194.95 $299.95 $314.95 $194 95 $299.95 $314.95 $51.99 $79.99 $ SR3.99 $51.99 $79.99 $83.99 $116.99 $179.99 $188.99 $116.99 $179.99 $18.99 $9.59 $15.99 $16.79 $9.59 $15.95 $16.79 $11.99 $19.99 $20.99 $11.99 $19.99 $20.99 $11.99 $19.95 $20.99 $17.99 $29.99 $81.49 $ $ $17.99 $29.99 $31.49 $5.99 $9.99 $10.49 $5.99 $9.99 $ $10.49 $5.99 $9.99 $10.49 $1199 $19.95 $20.99 $11.99 $19.99 $ $20.99 $11.99 $19.99 $20.99 $18.59 $29.95 $31.49 $1859 $29.99 $31.49 Honor Code Documentation Inventory SalesTrans Customer Data Miscinfo Monthly Payment Calculator Sales Pivot Employee Schedule Database Summary Advanced + Ready 1 + 100% AutoSave ON APO... ACIS 2504 Excel Spreadsheet Project LastFirst.xlsx - Saved Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) v 11 ~ A ab Wrap Text General AYO G v SIE Conditional Format Cell Insert Delete Format Formatting es Table Styles FO) IN Analyze Data Pastc BIU 7 A Y = = = Y Merge & Center Y Find & v Sort & Filter Select H5 fx B D F G H T K L L M N O Hokie Fitness Equipment & Accessories, Inc. 2 Sales Transactions for September 2021 3 4 Transaction ID Card Type $0.00 7 1 Online 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Date Product ID Customer_ID Warehouse Bin Quantity Sold Sales Type 9/1/21 GB-NBS120 M062831 AVALUE! 2 Online 9/121 W.Y2R124 MC46295 AVA UEL 1 Oriline 9/1/21 ED SK1272 MD10BTG VALUEI Z 2 In store 9/1/21 GB-NBM271 MD27726 AVALUE! 9/1,21 ER-JP137 MRA1502 VALUE 2 Online 9/1/21 GB NE5453 XXXXCXX #VALUE! i in store 9/2/21 CM-SOL7343 MC22709 AVALUE! 1 Online 9/2/21 ER-SKI272 MC32107 VALUE 2 In-store 9/2/21 CM NDT220 MD24385 #VALUE! 1 In store 9/2/21 CM-NDT220 - MD56307 AVALUE! 1 in-store 9/2/21 WS-HF42.RO XXXXXXX VALUE 2 Oriline 9/2/21 EB J.5470 XXXXXXX #VALUE! 2 in store 9/3/21 F-GV361 MD25494 AVALUE! 1 Online 9/3/21 FT-C3362 MCS4593 VALUE 1 Online 9/3/21 WS-Y2R2GS MD2438! #VALUE! 2 In store 9/3/21 ED-JS170 ME64082 AVALUE! 1 In-store 9/3/21 HG-AFX107 XXXXXXX VALUE 1 Online 9/3/21 GB LAN843 XXXXXXX - #VALUE! 2 in store 9/4/21 CM-SOL7343 MD35019 AVALUE! 1 Online 9/4/21 WS-Y2R493 M36025 WB VALUE 3 In-store 9/4/21 FT-FVS4G2 MC39104 #VALUE! i Crline 9/9/21 GB-UM05 MC53802 AVALUE! 1 Online 9/4/21 CM-SCHRIO ME21567 VALUE 1 Online 9/4/21 FT GV3154 ME26013 AVALUE! 1 In store 9/9/21 CD-JF2402 MES8417 AVALUE 1 Online 9/421 CM-NDT425 MF6R107 VALUFI 1 Online 9/4/21 FT GV8154 MR92834 AVALUE! 1 Online 9/4/21 WL-FGR160 XOXXXOXXX AVALUE 1 Online 9/5/21 GENR5420 MA20736 VALUFI 2 In-store 9/5/21 WL FGR116 MC39104 AVALUE! 1 Online 9/5/21 WYRZES MD27726 AVALUE 3 in-store 9/5/21 W.Y2R176 MD33404 AVALLEI 1 line 9/5/21 ED SKI272 MD49:19 AVALUE! 2 Online 9/5/21 WB-HF3143 ME64082 AVALUE! 1 Orline 9/5/21 WL-BFX234 MEOR417 AVALUEI 1 Online 9/5/21 GB LIALS1 MR70078 VALUE! 2 In store 9/5/21 FT-SGF164 MR82864 AVALUE! 1 Orline 9/5/21 WL-FGR447 XXXXXXX VALUFI 1 1 in-store Category WALUE! WVALUEI WALUE! WALUE! WALUEI #VALUE! WALUE! WALUEI #VALUE! WALUE! WALUEI #VALUE! WALUE! WALLEI #VALUE! WALUE! WALLEI #VALUE! WALUE! WALLEI #VALUE! WALUE! WALUEI Cost per Unit Price per Unit $21.00 $18.50 $9.59 $24.00 $11.99 $21.00 $946.95 $9.59 $591.84 $591.84 $25.77 $5.99 $51.99 $97.47 $21.69 $5.99 $355.10 $27.89 $946.95 $18.59 $129.97 Total Sales Shipping Handling Cost Sales Taxes Total Due $0.00 $ $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 S0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 32 33 34 35 36 37 38 39 40 WALUE! WALUE! WALUEI #VALUE! WALUE! WALUEI #VALUE! WALUE! ! VALLEI #VALUE! WALUE! WVALLEI ALUT WALUE! WALUE! WALUEI $710.21 $51.99 $17.99 $946.95 $51.99 $147.96 $21.00 $236.73 $21.69 $18.59 $9.59 $24.77 $236.73 $32.85 $116.99 $165.71 41 42 Inventory Sales Trans Customer Data Miscinfo Monthly Payment Calculator Sales Pivot Employee Schedule Database Summary + Ready + 100%
