the first two pics are the question and sample provided by the instructor. my combo chart (last pic) is not the same as the sample combo chart and I can't seem to find out my mistake. It must be something related to gross porift percentage but i can't find it.

0 Instructions Hint V-look V-lookup Formula Formula 1. Insert in column the Psku description found in the Product Master table 2. Insert in column"" the class description found in the Product Master table 3. Insert column M the Gross Profits 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 Profits for each class, sort in descending ordet 68 On that same Pivot Table include Average Gross Profit for each Class, leave sorted by GPS 8. On a new sheet titled Combo Chart, insert a combo chart displaying GPS and GMN (see sample below) B. This store is attempting to reallocate space to become more profitable In a short 12 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 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 HLN 82 31% 82 75 511 51% 51N 51% Combo Chart Gross Profit $ vs. Gross Margin% Product Maste 100% Ad 9:06 PM 21/2022 0 SIN SEN SIN 14 Gross Profit S vs. Gross Margin % 67 GADGETS CORE 75 M 73 ON crow Profit Gross Margin 25 57 57 45 45% A5 GEN S.COM CON www M Products 72% BIU WE $ . CCA D GHMNO OSWAMACHE Gross Profit S. Gross Margin 5 SUNG 57 WWW RowLabels Sum of Gross Profit 5 Average of Gross Profit 4 MOPS/BROOMS/CLEANING-CORE $34,702 PLASTICS CORE 69% $27 135 59% QUICK CLEAN $12.957 LIGHT BULOS CORE $11.309 656 PLASTIC FOOD CORE 311.018 03 9 CLOSET/HATH/STORAGE CORE 10 COOK/RAKEWARE CORE 57018 55,756 72 11. GADGETS CORE $4,49 75% 12 SHELFUNER.CORE $2.441 67% 13 APPLIANCES-CORE $1,700 57% KITCHEN ORGANIZATION $920 15 REUSABLE BAGS 6 DINNERWARE CORE 5381 50 OLAS/CERAMIC SERVING CORE 5269 59% CLOSET/BATH/STOR NONCORE 555 60 9: OINNERWARE NONCORE 63% MOPS/BROOMS/CLEAN NONCORE $36 + Grand Total $120,706 65% Sostes Gross Profit Combo Chart PodMaster RANNO CA GADGETSCORE COGNA NOU PL D + X c a L Fing R11 Torbe She D 1 H N Gross Profit S vs. Gross Margin % 5 6 7 9 Grow Profit 20.000 Gro Mar $1000 $10.000 $1.000 10 11 12 13 14 15 16 17 18 19 20 21 DINNERWARENONCOR NOSABLES DINNERWARE-CORE COSESSORCORE ASCII SECON SHEF LINE CON ONON NIDO APPLIANCESCORT TOHEN ORGANIZATION SalesDat9857 Grow Profit Combo Chart Product Master ROOMS GEANING-CORE PLASTIC CORE GUIOX CLEAN CONTROLES.COM PLASTIC FOOD CON ROSETAT STORAGE-COR COOKWARE CORE GADGET-CORE 6 OP zo a r 0 Instructions Hint V-look V-lookup Formula Formula 1. Insert in column the Psku description found in the Product Master table 2. Insert in column"" the class description found in the Product Master table 3. Insert column M the Gross Profits 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 Profits for each class, sort in descending ordet 68 On that same Pivot Table include Average Gross Profit for each Class, leave sorted by GPS 8. On a new sheet titled Combo Chart, insert a combo chart displaying GPS and GMN (see sample below) B. This store is attempting to reallocate space to become more profitable In a short 12 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 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 HLN 82 31% 82 75 511 51% 51N 51% Combo Chart Gross Profit $ vs. Gross Margin% Product Maste 100% Ad 9:06 PM 21/2022 0 SIN SEN SIN 14 Gross Profit S vs. Gross Margin % 67 GADGETS CORE 75 M 73 ON crow Profit Gross Margin 25 57 57 45 45% A5 GEN S.COM CON www M Products 72% BIU WE $ . CCA D GHMNO OSWAMACHE Gross Profit S. Gross Margin 5 SUNG 57 WWW RowLabels Sum of Gross Profit 5 Average of Gross Profit 4 MOPS/BROOMS/CLEANING-CORE $34,702 PLASTICS CORE 69% $27 135 59% QUICK CLEAN $12.957 LIGHT BULOS CORE $11.309 656 PLASTIC FOOD CORE 311.018 03 9 CLOSET/HATH/STORAGE CORE 10 COOK/RAKEWARE CORE 57018 55,756 72 11. GADGETS CORE $4,49 75% 12 SHELFUNER.CORE $2.441 67% 13 APPLIANCES-CORE $1,700 57% KITCHEN ORGANIZATION $920 15 REUSABLE BAGS 6 DINNERWARE CORE 5381 50 OLAS/CERAMIC SERVING CORE 5269 59% CLOSET/BATH/STOR NONCORE 555 60 9: OINNERWARE NONCORE 63% MOPS/BROOMS/CLEAN NONCORE $36 + Grand Total $120,706 65% Sostes Gross Profit Combo Chart PodMaster RANNO CA GADGETSCORE COGNA NOU PL D + X c a L Fing R11 Torbe She D 1 H N Gross Profit S vs. Gross Margin % 5 6 7 9 Grow Profit 20.000 Gro Mar $1000 $10.000 $1.000 10 11 12 13 14 15 16 17 18 19 20 21 DINNERWARENONCOR NOSABLES DINNERWARE-CORE COSESSORCORE ASCII SECON SHEF LINE CON ONON NIDO APPLIANCESCORT TOHEN ORGANIZATION SalesDat9857 Grow Profit Combo Chart Product Master ROOMS GEANING-CORE PLASTIC CORE GUIOX CLEAN CONTROLES.COM PLASTIC FOOD CON ROSETAT STORAGE-COR COOKWARE CORE GADGET-CORE 6 OP zo a r