With the existing data of the products and sales, you will use Goal Seek to identify the values of the necessary variables to achieve the goal.

1. Identify the target sale quantity of Cushioned Socks achieve target profit of $16,500. Select cell E5. On DATA table, in the Data Tools group, click What-If Analysis, then click Goal Seek to open the Goal Seek dialog box.

2. Identify the target selling price of Running Hats in D6 to achieve target profit of $25,300 type $D$6 in the By changing cell. Click OK twice.

3. Repeat the steps above to identify the target sale quantities of compression tights and Dry-Fit Running Tee in cell C7 and C8 respectively; identify the target selling price of Sunglasses in cell D9.

Get Data (Power Query) 5 1 2 3 1 N34 in 600 4 Inventory Items 5 Cushioned Socks 6 Running Hat 7 Compression Tights 8 Dry-fit Running Tee 9 Sunglasses _0 2 -4 5 Data from Picture 8 A L Refresh All fx =CS*D5 B Stocks Qty. Kowloon Runners Club and Shop Forecast Of Product Pricing and Sales Quantities 150 Currencies 80 Price $99.00 24 32 Sort $799.00 $350.00 E Extended Price $0.00 $0.00 $0.00 $0.00 $0.00 Filter F Goal Text to Columns $16,500 $25,300 $143,000 $42,000 $45,000 G H What If Analysis I