Item Code is a Numeric Label

Format all numbers to 1 decimal place Use comma format

1) Calculate the following: Total Sales Sales Tax Net Sales Profit Per Unit % Mark up % of Total Sales Totals (of all columns) Average (of all columns) Largest (of all columns)

OMA 231 PERFECTION FOR ELECTRONICS % Net Sales Profit Per Unit % of Total Mark Up Sales Sales Statement for November 2020 No. of Cost Sale 5% Item Total Description Items Price Per Price Per Sales Code Sales Sold Unit Unit Tax 555 WASHING MACHINE 320 106 148.5 556 DISHWASHER 216 89.2 122 557 POWER ADAPTOR 1150 5.8 9.5 558 WIRELESS SPEAKER 387 18 559 TV 564 98.2 127.5 AIR CONDITIONER 891 176 210 561 COFFEE MAKER 127 21.5 32.5 TOTALS AVERAGE LARGEST 10.5 560