please answer questions one and two. Thank You

Instructions Hint V-lookup V-lookup Formula Formula Pivot Table Pivot Table 1. Insert in column "H" the Psku description found in the Product Master table 2. Insert in column "T" the class description found in the Product Master table 3. Insert column M the Gross Profit $ for each transaction 4. Insert in column N the Gross Profit % for each transaction 5. Create a new sheet labeled "Gross Profit" 6. On that sheet insert a Pivot Table detailing the Total Gross Profit $ for each Class, sort in descending order 6B On that same Pivot Table include Average Gross Profit % for each Class, leave sorted by GP $ 8. On a new sheet titled Combo Chart, insert a combo chart displaying GP$ and GM% (see sample below) 8. This store is attempting to reallocate space to become more profitable. In a short (2 pages maximum) paper, explain what class you would recommend they reduce floor space and what class you would recommend they expand floor space. You must include a Pivot Table with both $ and % 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. Insert Chart G F G H - J K L M A B D E The following is a sample Point of Sale transactions at Store 9857. TransID DC Store Date Time FiscalWeel PSKU Units Sold Unit Sales Unit Cost $ 1812092502 96000 9857 6/18/16 7:59:15 PM 21 1159901 10 2.3 0.67 1812092566 96000 9857 6/18/16 8:04:24 PM 21 15537501 20 1.15 0.56 1812092764 96000 9857 6/18/16 10:17:58 AM 21 1156304 20 2.3 0.76 1812092764 96000 9857 6/18/16 10:17:58 AM 21 14007101 10 9.2 4.56 1812092823 96000 9857 6/18/16 10:49:44 AM 21 1140706 10 1.15 0.4 1812092930 96000 9857 6/18/16 11:04:04 AM 21 1160501 20 2.3 0.59 1812092936 96000 9857 6/18/16 11:13:19 AM 21 1132201 20 2.3 0.43 1812092936 96000 9857 6/18/16 11:13:19 AM 21 1132201 10 2.3 0.43 1812092936 96000 9857 6/18/16 11:13:19 AM 21 1132201 10 2.3 0.43 1812092936 96000 9857 6/18/16 11:13:19 AM 21 1132201 10 2.3 0.43 - 1812092992 96000 9857 6/18/16 11:35:56 AM 21 1137301 20 1.74 0.31 1812093002 96000 9857 6/18/16 11:42:56 AM 21 1148601 20 1.74 0.43 1812093054 96000 9857 6/18/16 11:59:13 AM 21 1162404 10 1.44 0.7 1812093054 96000 9857 6/18/16 11:59:13 AM 21 1162404 20 1.44 0.7 1812093054 96000 9857 6/18/16 11:59:13 AM 21 1162404 20 1.44 0.7 1812093054 96000 9857 6/18/16 11:59:13 AM 21 1162404 10 1.44 0.7 B 1812093057 96000 9857 6/18/16 12:03:29 PM 21 1163705 10 2.3 0.5 1812093119 96000 9857 6/18/16 2:01:01 PM 21 1144601 20 2.3 0.77 1812093119 96000 9857 6/18/16 2:01:01 PM 21 1144601 20 2.3 0.77 1812093293 96000 9857 6/18/16 5:48:12 PM 21 1151101 10 5.75 3.15 1812093293 96000 9857 6/18/16 5:48:12 PM 21 1151101 20 5.75 3.15 B 1812093293 96000 9857 6/18/16 5:48:12 PM 21 1151101 10 5.75 3.15 1812093473 96000 9857 6/18/16 8:28:15 PM 21 13994801 10 1.74 0.51 1812093473 96000 9857 6/18/16 8:28:15 PM 21 1142803 20 2.3 0.66 1812093588 96000 9857 6/18/16 12:02:54 PM 21 15139001 10 3.4 0.91 1812093588 96000 9857 6/18/16 12:02:54 PM 21 1140706 10 1.15 0.4 1812093590 96000 9857 6/18/16 12:06:15 PM 21 17048701 10 5.75 2.16 1812093590 96000 9857 6/18/16 12:06:15 PM 21 17048701 10 5.75 2.16 1812093590 96000 9857 6/18/16 12:06:15 PM 21 17048701 10 5.75 2.16 5 1812093590 96000 9857 6/18/16 12:06:15 PM 21 15184501 10 5.47 2.34 1812093590 96000 9857 6/18/16 12:06:15 PM 21 13257001 20 13.8 5.87 1812093590 96000 9857 6/18/16 12:06:15 PM 21 1151101 10 5.75 3.15 1812093590 96000 9857 6/18/16 12:06:15 PM 21 1151101 20 5.75 3.15 1812093590 96000 9857 6/18/16 12:06:15 PM 21 1151101 20 5.75 3.15 1812093590 96000 9857 6/18/16 12:06:15 PM 21 1151101 20 5.75 3.15 Sales Data9857 Product Master + E F H Psku B Psku Description . 983401 ENOZ MOTH CAKE . 1124001 DG REUSABLE BAG 1125101 GLADWARE FAMILY SIZE 1125505 COLANDER 4QT/7QT 1125701 TAKEALONG ZPK LG RECT 1125910 BOWLS 490Z BLUE 2 PK 1126201 POPCORN/SALAD BOWL 1126301 SALAD/CEREAL BOWL 0 1126501 TAKEALONG SQUARE 1 1126701 RECT PITCHER 1 GAL 2 1126801 CUTLERY TRAY 3 3 1127001 TAKE ALONG RECTANGLE 4 1127301 TAKEALONGS ENTREE 5 1127402 8PC BOWL SET 6 1127603 TAL SM BOWL 3.2 CUP 7 1127801 ULTRA SEAL 4.7 QT 8 1127901 LARGE ENTREE 3PK 9 1128001 TAKEALONG ROUND 3PK 0 1128201 24 OZ WATER BOTTLE 1 1130902 SMALL GLASS CANISTER 2 1131501 TL MUFFIN PAN 12 CUP 3 1131701 JFYFOL OVAL ROASTER GIANT 4 1131801 JFYFOL ROASTER W/LD SM 5 1132101 JFYFOL CAKE/STUFFING 2PK 6 1132201 JFYFOL LARGE RECT ROASTER 7 1132501 TL COVERED BAKING PAN 8 1132601 TL BAKE AND ROAST PAN 9 1132701 JFYFOL RACK ROASTER W/LD 0 1132801 JFYFL GNT ALL PURPSE WUD 1 1133101 JFYFOL LSGNA PAN 2PK 2 2 1133205 JIFFY FOIL CAKE PAN 2CT 3 1133301 TL ROUND CAKE PAN 4 1133601 JFYFOL LSGNA PAN GIANT 5 1133701 JIFFY FOIL DEEP ROASTER 6 1133901 CHICKEN FRYER NONSTICK C D D Class Class Description 2041 CLOSET/BATH/STORAGE-CORE 2028 REUSABLE BAGS 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2029 PLASTIC/FOOD CORE 2033 GLAS/CERAMIC SERVING-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE 2035 COOK/BAKEWARE-CORE VendorID Brand 1161 ENOZ 270317 1805 GLADWARE 2882 TRUELIVING 1998 RUBBERMAID 2882 2882 UNBRANDED 2882 UNBRANDED 1998 RUBBERMAID 2921 STERILITE 2921 TRUELVING 1998 RUBBERMAID 1998 RUBBERMAID 2921 STERILITE 1998 RUBBERMAID 2921 STERILITE 321668 SMART & SIMPLE 1998 RUBBERMAID 1998 RUBBERMAID 2486 UNBRANDED 2877 TRUELIVING 273022 JIFFY FOIL 273022 JIFFY FOIL 273022 JIFFY FOIL 273022 JIFFY FOIL 2877 TRUELIMING 2877 TRUELING 273022 JIFFY FOIL 273022 JIFFY FOIL 273022 JIFFY FOIL 273022 JIFFY FOIL 2877 TRUELIVING 273022 JIFFY FOIL 273022 JIFFY FOIL 204974 EVOLUTION G Brand Type NATIONAL BRAND PRIVATE LABEL-DG HOME NATIONAL BRAND PL-TRUE LIVING NATIONAL BRAND CONTROL BRAND NATIONAL BRAND CONTROL BRAND NATIONAL BRAND NATIONAL BRAND PL-TRUE LIVING NATIONAL BRAND NATIONAL BRAND NATIONAL BRAND NATIONAL BRAND NATIONAL BRAND PL-SMART SIMPLE NATIONAL BRAND NATIONAL BRAND CONTROL BRAND PL-TRUE LIVING NATIONAL BRAND NATIONAL BRAND NATIONAL BRAND NATIONAL BRAND PL-TRUE LIVING PL-TRUE LIVING NATIONAL BRAND NATIONAL BRANC NATIONAL BRAND NATIONAL BRAND PL-TRUE LIVING NATIONAL BRAND NATIONAL BRAND CONTROL BRAND Case Pack Inner Pack Velocity 12 12 UNASSIGNED 240 24 UNASSIGNED 3 3 UNASSIGNED 6 6 UNASSIGNED 3 3 UNASSIGNED 12 12 UNASSIGNED 8 8 UNASSIGNED 12 12 UNASSIGNED 6 6 UNASSIGNED 6 6 UNASSIGNED 6 6 6 UNASSIGNED 6 6 UNASSIGNED 6 6 UNASSIGNED 4 4 UNASSIGNED 4 4 UNASSIGNED 4 4 UNASSIGNED 6 6 UNASSIGNED 6 6 UNASSIGNED 8 8 8 UNASSIGNED 12 4 UNASSIGNED 6 6 UNASSIGNED 12 12 UNASSIGNED 6 6 UNASSIGNED 12 12 T1000-TOP 1000 ITEM 12 12 T500-TOP 500 ITEM 4 4 UNASSIGNED 6 6 UNASSIGNED 6 6 T500-TOP 500 ITEM 6 6 6 UNASSIGNED 12 12 UNASSIGNED 15 15 UNASSIGNED 6 6 6 UNASSIGNED 12 12 UNASSIGNED 15 15 UNASSIGNED 2 2 UNASSIGNED Sales Data9857 Product Master +