With the existing data of the products and sales, you will use Goal Seek to identify the
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Posted Date: