Ugulunchon. 14. The company can make more profit by keeping shipping costs to a minimum. Felicia has been put in charge of the packaging redesign project, and she needs to figure out what weight of packaging can keep even the heaviest clothing set from being overweight Perform a Goal Seek Analysis to find a packing weight that will bring the shipping weight of the Retro Fit clothing set down to 39.75 lbs. Use cell 19 as the cell to set, 39.75 as the target value, and cell FS as the changing cell. Keep the values generated by the Goal Seek Analysis as the value for cells F5, 19, and 110. 49 50 X Use Goal Seek to update a value in a cell. In the Product lookup worksheet, coll F5 should contain the number generated by the Goal Seek analysis. 51 52 Here Insert Page Layout Form Data Hew View Aro cal 11 AN A Share Comments 1 Wales Beste camera a.A WE Merce- 29 O 4 S. % Conditional Format Chand For Hub FS 56 ding Ideas D 4 Packing Weight for 56 6 Pants/Shorts 7 Dress/Skirt 8 Sweater/Vest Retro Fit 16 160 190 10 116 40 48 40 Product information Lookup Boxed Set Item Count of components Net Weighton Shipping Weight Overweight? 5 19.25 NO 5 Tem counts of Components 10 Underwear 11 Accessories 12 Clothing Set 13 Information 14 Bury Caz 95 High Society 16 Retro Fit 7 Weekend Wanderer 8 Net Weight 12 7 16 16 3 2 5 4 392 136 601 500 Bizzy Car High Society Retro Fit Weekend Wanderer Shirt/Blouse Dress/Skirt Shirt/Blouse Shirt/Blouse Clothing Set Configurations Pants/Shorts Socks Accessories Pants/Shorts Dress/Skirt Pants/Shorts Accessories Socies Sweater/Vest Underwear Graded Summary Report Documentation Product Last Orders