The instructions and all information needed is given. please answer with the formulas, VLOOKUP and pivot. I will like when completed. Thank You.

F G H 1 M N O C 1 The following is a sample Point of Sale transactions at Store9857 2 3 4 Instructions Hint W-lookup V-lookup Formula Formula 1. Insert incolumn 'H' the Pskudescription found in the Product Master table 2. Insert in column T the dass description found in the Praduct Master Table 3. Insert column Mthe Groz Profits for each transaction 4. Insert incolumn N the Gross Profit for each transaction 5. Create a new sheer labeled "Gross Profit ... 6. On that sheet insert a Pivot Table detailing the Total Gross Pruits for each Class, sort in descending order 68 On that same Pivot Table include Average Grass Profil foreach Class, lewe sorted by GP $ 8. Onare short titled Combo Chart, insert a combochart displaying Gps and GMX (sane sample below 8. This store is attempting to reallocate space to become more profitable. In a short (2 PSRS max mum paper, txplain what class you would recommend they reduce floor space and what class you would recommenc they expand flour space You must include a Pivot Table with both sand and your chart in your paper and you MUST EXPLAIN your reasoning for the space reduction and expansion based on your Pivot Tables & Chart. Tables & charts should be embedded in your text, not at the very top or very bottom of the text. Pivot Table Pivot Table Insert Chart 96003 Gross Profit S vs. Gross Margin % $400 sne 5 6 Trans DXC 7 1812092502 95000 B 1812092556 95003 9 1812092754 95000 10 1812092764 96000 11 1812092823 96000 12 1812092930 95000 13 1812092956 95003 14 1812092936 9500D 15 1812092936 95003 16 1812092936 96000 17 1812092992 95000 18 1812093002 95000 19 1812093054 20 1812093054 96COU 21 1812093054 96000 22 1812093051 95000 23 1812093057 95000 24 1812093219 95000 25 1812093219 9600D 26 1812093299 96000 27 1812093293 95000 28 78 1812093293 95000 29 1812093473 95000 30 1812093473 95003 31 1812093558 96000 32 1812093588 96000 33 1812093590 95000 34 1812093590 95000 35 1812093590 95000 36 1812093590 9600D 37 1812093590 96000 38 1812093590 95000 39 1812093590 95000 40 1812093590 95000 41 1812093590 9600D 42 1812093590 96000 13 1812093590 95000 44 1812093602 95000 SalesData057 GADSETS-COR, 75% Dale Time 9857 5/18/16 7:59:15 PM 9857 5/18/15 8:04:24 PM 9857 5/18/16 10:17:58 AM 9857 6/18/16 10:17:58 AM 9857 6/18/16 10:19:44 AM 9857 5/18/16 11:04:04 AM 9857 5/18/16 11:13:19 AM 9857 5/18/16 11:13:19 AM 9857 6/18/16 11:13:19 AM 9852 6/18/16 11:13:19 AM 9857 5/18/16 11:35:56 AM 9857 5/18/15 11:42:56 AM 9857 5/18/16 11:59:13 AM 9857 6/18/16 11:59:13 AM 9857 6/18/16 11:59:13 AM 9857 5/18/16 11:59:13 AM 9857 5/18/16 12:03:29 PM 9857 5/18/16 2:01:01 PM 9857 5/18/16 2:01:02 PM 9852 6/18/16 5:48:12 PM 9857 5/18/'16 5:48:12 PM 9857 5/18/16 5:48:17 PM 9857 5/18/15 3:28:19 PM 9857 5/18/16 9:28:15 PM 9857 6/18/16 12:02:54 PM 9857 6/18/16 12:02:54 PM 9857 5/18/15 12:06:15 PM 9857 5/18/15 12:06 15 PM 9857 5/18/16 12:06:15 PM 9857 6/18/16 12:06:15 PM 9857 6/18/16 12:06:15 PM 9857 5/18/16 12:06:15 PM 9857 5/18/15 12:06:15 PM 9857 5/18/16 12:05:15 PM 9857 6/18/10 12:06:15 PM 9852 6/18/16 12:06:15 PM 9857 5/18/16 12:06:15 PM 9857 5/18/16 12:14:03 PM Product Master + Fiscal Week PSKU Units sold Unit SilesUnit Costs 71 1159901 10 7.3 0.67 21 1553 7501 20 1.15 0.56 21 1156204 20 2.3 0.76 21 14007101 10 9.2 4.56 21 1140705 10 1.15 0.4 21 1160501 20 2.3 0.59 21 1132201 20 2.3 0.43 . 21 1132201 10 2.3 0.43 21 1132201 10 2.3 0.43 21 1132201 10 2.3 0.43 21 1137301 20 1.74 0.31 21 114601 20 1.74 0.43 21 1162404 10 1.44 0.7 21 1162404 20 1.44 0.7 21 1162404 20 1.44 0.7 21 1162104 10 1.44 0.7 21 1160705 10. 2.3 0.5 21 1144601 20 2.3 0.77 21 1144601 20 2.3 0.77 21 1151101 10 5.25 3.15 21 1151101 20 5.75 3.15 21 1151101 10 5.75 3.15 21 13994801 10 1.74 0.51 20 2.3 0.66 21 15139001 10 3.4 0.91 21 1140705 10 1.15 0.4 21 17048701 10 5.75 7.16 21 17048701 10 5.75 2.16 21 17048701 10 5.75 2.16 21 15184501 10 5.47 2.34 21 13257001 20 13.8 5.07 21 1151101 10 5.75 3.15 21 1151101 20 5.75 3.15 21 1151101 20 5.75 3.15 21 1151101 20 3.75 3.15 21 1151101 10 5.25 3.15 21 1151101 20 5.75 3.15 21 1142901 20 1.15 0.35 $25.000 753 $30 700 21 1142803 65% 525.000 $20,000 $15,000 SSX sta SO $5,000 45% 15 40 1010 SONY RATNET andere E F G H Brand Brand Type NATIONAL BRAND PRIVATE LABEL-DG HOME NATIONAL BRAND VendorID 1161 ENOZ 270317 0517 1003 1805 GLADWARE 2882 TRUELIVING 1998 RUBBERMAID 2882 2882 UNBRANDED 2882 UNBRANDED 1 1998 RUBBERMAID www 2921 STERILITE 2921 TRUELIVING 1998 RUBBERMAID 100 UN 1998 RUBBERMAID co 2921 STERILITE 1998 RUBBERMAID 2021 STERILITE A B D 1 Psku Psku Description Class Class Description 983401 ENOZ MOTH CAKE 2041 CLOSET/BATH/STORAGE-CORE 3 1124001 DG REUSABLE BAG 2028 REUSABLE BAGS 2028 REUSABLE BAGS 1125101 GLADWARE FAMILY SIZE 2029 PLASTIC/FOOD CORE SUZ 5 1125505 COLANDER 4QT/7QT 11235US COLANDEN 2029 PLASTIC/FOOD CORE en ONE 5 1125701 TAKEALONG 2PK LG RECT 2029 PLASTIC/FOOD CORE - -- Fenown 1125910 BOWLS 49OZ BLUE 2PK 2029 PLASTIC/FOOD CORE SONG 3 1126201 POPCORN/SALAD BOWL 2029 PLASTIC/FOOD CORE --- 250 1126301 SALAD/CEREAL BOWL 2029 PLASTIC/FOOD CORE dawane 2006 Decor 0 1126501 TAKEALONG SQUARE 2029 PLASTIC/FOOD CORE 499 Tur 1 1126701 RECT PITCHER 1 GAL 2029 PLASTIC/FOOD CORE 1050 2 1126801 CUTLERY TRAY 2029 PLASTIC/FOOD CORE con 3 1127001 TAKE ALONG RECTANGLE 2029 PLASTIC/FOOD CORE 4437304 TAVEMONICS 1127301 TAKEALONGS ENTREE 100 cc 4 2029 PLASTIC/FOOD CORE 210 CBWI SET 100 i dere 5 1127402 SPC BOWL SET 2029 PLASTIC/FOOD CORE 6 1127603 TAL SM BOWL 3.2 CUP 2029 PLASTIC/FOOD CORE 7 1127801 ULTRA SEAL 4.7 QT 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 8 1127901 LARGE ENTREE 3PK 2029 PLASTIC/FOOD CORE 9 1128001 TAKEALONG ROUND 3PK 2029 PLASTIC/FOOD CORE 0 1128201 24 OZ WATER BOTTLE 2029 PLASTIC/FOOD CORE 1 1130902 SMALL GLASS CANISTER 2033 GLAS/CERAMIC SERVING-CORE 2 1131501 IL MUFFIN PAN 12 CUP 2035 COOK/BAKEWARE-CORE 3 1131701 JFYFOL OVAL ROASTER GIANT 2035 COON/BAKEWARE-CORE 111701FFOL OVAL ROASTER 4 1131801 JFYFOL ROASTER W/LD SM 2035 COOK/BAKEWARE-CORE ter 5 1132101 JFYFOL CAKE/STUFFING 2PK 2035 COOK/BAKEWARE-CORE --- 6 1132201 JFYFOL LARGE RECT ROASTER 2035 COOK/BAKEWARE-CORE WAT "" 7 1132501 TL COVERED BAKING PAN 2035 COOK/BAKEWARE-CORE we 8 1132601 TL BAKE AND ROAST PAN 2035 COOK/BAKEWARE-CORE 9 9 1132701 JFYFOL RACK ROASTER W/LD 2035 COOK/BAKEWARE-CORE 0 1132801 JFYFL GNT ALL PURPSE WLID 2035 COOK/BAKEWARE-CORE 1 1133101 JFYFOL LSGNA PAN 2PK 2035 COOK/BAKEWARE-CORE 2 1133205 JIFFY FOIL CAKE PAN 2CT CANG 2035 COOK/BAKEWARE-CORE 3 1133301 TL ROUND CAKE PAN 2035 COOK/BAKEWARE-CORE so WO 4 1133601 JFYFOL LSGNA PAN GIANT www.ro WARNI 2035 COOK/BAKEWARE-CORE 5 1133701 JIFFY FOIL DEEP ROASTER 2035 COOK/BAKEWARE-CORE 6 1133901 CHICKEN FRYER NONSTICK 2035 COOK/BAKEWARE-CORE 7 1134001 DUTCH OVEN W/GLS LD W 2035 COOK/BAKEWARE-CORE 8 1134101 JIFFFY FOIL ROASTER 2PK 2035 COOK/BAKEWARE-CORE 9 1134601 JFYFOL UTILITY PAN W/LID 2035 COOK/BAKEWARE CORE 10. 0 1134701 7PC BELLY SHAPE COOKWARE 2035 COOK/BAKEWARE-CORE w 1 1134901 12 PC FLATWARE SET 2036 GADGETS-CORE 2 1125304 ACCU 1135201 BAG CLIP 2036 GADGETS-CORE C GADGETS.CODE 3 1135305 SCISSORS STAINLESS STEEL 2036 GADGETS-CORE 4 1136001 CHROME LONG TURNER 2036 GADGETS CORE SalesData9857 Product Master 321668 SMART & SIMPLE 1998 RUBBERMAID 1998 RUBBERMAID 2486 UNBRANDED 2877 TRUELIVING ' ThELIVING 273022 JIFFY FOIL JIFFT FOIL 273022 JIFFY FOIL ... 273022 JIFFY FOIL uro 273022 JIFFY FOIL ............. 2877 TRUELIVING 2877 TRUELIVING 273022 JIFFY FOIL 273022 JIFFY FOIL 273022 JIFFY FOIL 273022 JIFFY FOIL | 2877 TRUELIVING 201 INDELIVIN 273022 JIFFY FOIL S. 273022 JIFFY FOIL S. 204974 EVOLUTION www 204974 EVOLUTION www 273022 JIFFY FOIL curen 273022 JIFFY FOIL 204974 EVOLUTION 2867 TRUELIVING 2867 TRUELIVING 2867 TRUELIVING 2867 TRUELIVING PL-TRUE LIVING mene NATIONAL BRAND DARD CONTROL BRAND NATIONAL BRAND . CONTROL BRAND Sene. NATIONAL BRAND w NATIONAL BRAND PL-TRUE LIVING Munasi NATIONAL BRAND ...BRAUN NATIONAL BRAND TOMAR DAN NATIONAL BRAND NATIONAL BRAND NATIONAL BRAND PL-SMART SIMPLE NATIONAL BRAND NATIONAL BRAND CONTROL BRAND PL TRUE PL-TRUE LIVING NATIONAL BRAND WANADA NATIONAL BRAND .. NATIONAL BRAND NATIONAL BRAND PL-TRUE LIVING PL-TRUE LIVING NATIONAL BRAND NATIONAL BRAND NATIONAL BRAND NATIONAL BRAND PL-TRUE LIVING nen NATIONAL BRAND NATIONAL BRAND CONTROL BRAND CONTROL BRAND . NATIONAL BRAND ......... NATIONAL BRAND OU CONTROL BRAND id PL-TRUE LIVING PL-TRUE LIVING PL-TRUE LIVING PL-TRUE LIVING Case Pack Inner Pack Velocity 12 12 UNASSIGNED 240 24 UNASSIGNED 3 3 UNASSIGNED 6 6 UNASSIGNED an 3 3 UNASSIGNED neden 12 12 UNASSIGNED 8 8 UNASSIGNED 12 12 UNASSIGNED 6 6 UNASSIGNED wei 6 6 UNASSIGNED cu 6 6 UNASSIGNED . 6 6 UNASSIGNED 6 6 UNASSIGNED mieur 4 4 UNASSIGNED . ASSIGNED 4 4 UNASSIGNED 4 4 UNASSIGNED 4 6 6 UNASSIGNED 6 b 6 UNASSIGNED 8 8 UNASSIGNED 12 4 UNASSIGNED 4 6 6 UNASSIGNED 0 BUNDSTONE 12 12 UNASSIGNED ANSIONS 6 6 UNASSIGNED 12 12 T1000-TOP 1000 12 12 T500-TOP 500 ITE . 4 4 UNASSIGNED 6 6 UNASSIGNED 6 6 6 T500-TOP 500 ITE 6 6 UNASSIGNED 12 12 12 UNASSIGNED 15 DOROSTINED 15 UNASSIGNED 6 6 UNASSIGNED an 12 12 UNASSIGNED 15 15 UNASSIGNED wees 2 2 UNASSIGNED www. 2 2 UNASSIGNED den 12 12 UNASSIGNED 12 12 UNASSIGNED 2 2 UNASSIGNED ceu 24 6 UNASSIGNED 72 6 UNASSIGNED 72 3 UNASSIGNED 72 3 UNASSIGNED