Page 377 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

4 Set Goal Seek Parameters
In the Goal Seek dialog box:

• Set “Set cell” to the cell containing the SUM of Net Sales (D8).
• Set “To value” to the desired Target PROFIT (23,00,000).
• Set “By changing cell” to the cell containing the initial PROFIT percentage for Q4 (B6).

5 Run Goal Seek
Click “OK” in the Goal Seek dialog box. Excel will perform calculations to find the required PROFIT percentage
for each quarter to achieve the target Annual Profit.

362
CITS : IT & ITES - Computer Software Application - Exercise 65