Lindsey would like to increase the average number of placements per month. Because executive placements are the most profitable, Lindsey wants to know how many executive placements she needs to reach the goal of 30 placements per month.
Use Goal Seek to set the average number of placements for all positions (cell 127) to the value of 30 by changing the average number of executive placements (cell 123).
To use the Goal Seek function in Microsoft Excel to set the average number of placements for all positions to 30 by changing the average number of executive placements, follow these steps:
1. Open the Excel spreadsheet containing the data.
2. Identify the cell that contains the average number of placements for all positions. In this case, it is cell 127.
3. Identify the cell that contains the average number of executive placements. In this case, it is cell 123.
4. Go to the "Data" tab in Excel.
5. Locate the "Forecast" group and click on the "What-If Analysis" button. From the drop-down menu, select "Goal Seek."
6. In the Goal Seek dialog box, set the "Set cell" field as cell 127 (the cell containing the average number of placements for all positions).
7. In the "To value" field, enter 30 (the target average number of placements per month).
8. In the "By changing cell" field, enter cell 123 (the cell containing the average number of executive placements).
9. Click on the "OK" button.
10. Excel will automatically calculate the average number of executive placements required to achieve the goal of 30 total placements per month, and update the value in cell 123 accordingly.