please comment on Brands performance based on above data.

G H K 1. Please use Excel to do the following table. For row "Total", columns "Qty", "Sell thru %", "Sales", "Sale Mix "", "Cost", "GP". "Qey" 5 and "Cost", please use formuls to show the calculations in the spreadsheet and save the file in your name M Receiving Season to date from Mar 2 to 22) 9 Brand 10 ABS Qty Cost Qty Sell thru % Sales Sale Mix % 150 Stock On Hand Qay 540,610 Cost OP% Cost 39 13% 25,489 11.19% 133 580,460 75 24% imm 42.280 18.56% 11 Plenty 12 Jill Stuart 13 Theory 14 Laundry 111 58 13.221 20.653 30,122 180 527-389 559,807 754,900 71 23% 61,370 26.96% 231 604,550 109 64 21% 58,512 25.60% 28.005 167 724,778 656,545 229 84.600 59 19% 40,096 17.61% 18.389 170 15 66,211 16 Total 923 2,645,120 308 100% 227,747 100.00% 110,390 17 615 2,534,730 18 19 20 Base on the below list weekly sales figures to calculate the season to date sales report 21 All the above yellow highlighted cells has to be calculated by equation 22 23 24 Data 25 Sales on Mar 2-8 Sales on Mar 9-15 Sales 20 Brand Qty Sales GPS Cost Qty Qty 27 ABS 9,543 5,136 4,408 12,490 5,371 7,119 28 Plenty 23,480 6,100 5,140 11,240 11,974 11,506 29 Jill Stuart 25,430 14,513 9,300 10,917 18,430 9,031 4,120 50,490 24.236 2,013 26,254 2,107 30 Theory 31 Laundry 3,044 27 4.381 7,425 17,260 9,725 7,535 32 103 138 33 Total 112,315 55,674 56,641 67,503 37,580 30,013 Please comment on Brands performance based on above data. Answer 15 23 30 B 20 40 20 50 8 GPS 5% 9% 14% 13% 10% 52% Cost 4 12 21 6 24 67 Sales on Mar 16-22 GPS 3,454 7,500 17,510 3,902 15,411 47,839 1,762 3,553 7.704 2,146 1.038 24,103 N Cest 1,884 4,007 1,806 1,750 6473 23,73 G H K 1. Please use Excel to do the following table. For row "Total", columns "Qty", "Sell thru %", "Sales", "Sale Mix "", "Cost", "GP". "Qey" 5 and "Cost", please use formuls to show the calculations in the spreadsheet and save the file in your name M Receiving Season to date from Mar 2 to 22) 9 Brand 10 ABS Qty Cost Qty Sell thru % Sales Sale Mix % 150 Stock On Hand Qay 540,610 Cost OP% Cost 39 13% 25,489 11.19% 133 580,460 75 24% imm 42.280 18.56% 11 Plenty 12 Jill Stuart 13 Theory 14 Laundry 111 58 13.221 20.653 30,122 180 527-389 559,807 754,900 71 23% 61,370 26.96% 231 604,550 109 64 21% 58,512 25.60% 28.005 167 724,778 656,545 229 84.600 59 19% 40,096 17.61% 18.389 170 15 66,211 16 Total 923 2,645,120 308 100% 227,747 100.00% 110,390 17 615 2,534,730 18 19 20 Base on the below list weekly sales figures to calculate the season to date sales report 21 All the above yellow highlighted cells has to be calculated by equation 22 23 24 Data 25 Sales on Mar 2-8 Sales on Mar 9-15 Sales 20 Brand Qty Sales GPS Cost Qty Qty 27 ABS 9,543 5,136 4,408 12,490 5,371 7,119 28 Plenty 23,480 6,100 5,140 11,240 11,974 11,506 29 Jill Stuart 25,430 14,513 9,300 10,917 18,430 9,031 4,120 50,490 24.236 2,013 26,254 2,107 30 Theory 31 Laundry 3,044 27 4.381 7,425 17,260 9,725 7,535 32 103 138 33 Total 112,315 55,674 56,641 67,503 37,580 30,013 Please comment on Brands performance based on above data. Answer 15 23 30 B 20 40 20 50 8 GPS 5% 9% 14% 13% 10% 52% Cost 4 12 21 6 24 67 Sales on Mar 16-22 GPS 3,454 7,500 17,510 3,902 15,411 47,839 1,762 3,553 7.704 2,146 1.038 24,103 N Cest 1,884 4,007 1,806 1,750 6473 23,73