File Home Insert Page Layout Formulas Duta Review View Help QuickBooks Tell me what you want to do Arial 10.A 2 Wrap Test General WS Pacte BIV- S- insert Delete Format Mege Center Alignment Conditional Formas Cel Formatting Table Styles Set Clipboard Font Number CA 12 A 0 E F G H 1 custid custame state 22101 Deidre Mecullough MAINE 3 23411 Reagan Litach MASSACHUSETTS 4 23770 Paloma Vega MASSACHUSETTS 623088 Mchael Hart CONNECTICUT 6. 2400) Rity Sale MAINE 724069 Daphne Graves NEW HAMPSHRE B 23611 Cutan Kane NEW HAMPSHRE 9 24007 Rooney Homan MASSACHUSETTS 10.25105 Lake Malone MAINE 11 23452 5mon Cars MATE 12 23878 Chart Home MARIE 13 23419 Quinn Fredecke NEW HAMPSHRE 1423418 Hava Burgess MASSACHUSETTS 15 23914 Macey Prince CONNECTICUT 16 23294 Samuel Aya NEW HAMPSHRE 17 23450 Laws Hall MASSACHUSETTS 10 23001 Uss Charles CONNECTICUT 19 23405 Ebony Kit VERMONT 20 2026 Riban sa MASSACHUSETTS 21 23945 Audrey Wigs CONECTICUT 29 2372 Calle Cart

Online 39 1/1/2021 + POOB102 Relat 92 1/2/2021 PURA100 Online 132 1202021 PURA200 Ret 102 1/2/2021 OOPSBOD Online 57 1/2/2021 POODI 105 Direct 54 1/32023 PURA250 Online 176 1/2/2021 OOPS 100 Dec 65 1/3/2021 PURA200 Direct 119 1/32021 OOPS800 Online 191 1/4/2021 POOB103 Online 32 14/2021 OOPS.800 Rotar 150 15/2021 POOB101 O 100 2020 OOP5200 Oline 15/2021 POO8104 Online 1/5/2021 POOB Road 12 16/2020 PURASO Online 183 2020 DODE 102 Red 132 17.2021 POO 101 Real 112 2021 POO 105 Online 1 21 PODL103 64 19:20 DURAN 210 !! Typer toth O 23 Snow showers 5) Create 6 new columns which will contain calculated and referenced values (Columns 1 - N) G H M N Sede Costas 192 11/2021 560.00 135 112021 270.00 $385 105 112021 38160 7033 39 1/1/2021 117.00 254 12/2021 23000 414 13222021 190.00 39 102 12.2021 25400 105 1/2/2021 513 54 10/2021 4200 total productName 9590 1152200 5523 Pool-Gabelle 5722 255 65 PureSot Pet Woe-200 79270 32700 PSA Pe Wipes 117.00 Oos San Remo 100 ) 134 Poto-256 396.00 190 00 PreSot Pet W-100 4063 2020 Pe So Wipe - 2004 $45 50 the Ope San Remo 2009 1367 3600 Pobo. a. Total Cost = Units Sold Unit Cost (in the Product Ledger) b. Total Pretax = Unit Sold Retail Price (in the Product Ledger) c. Discount = Total Pretax Discount Percentage (only applies >=144 units sold) d. Total with Tax = Total Pretax - Discount + State Tax (