Page 379 - Computer Software Application TP - Volume 1
P. 379
COMPUTER SOFTWARE APPLICATION - CITS
3 Use Goal Seek
1 Select cell C4 (Production Cost per Unit).
2 Go to the “Data” tab in the Excel ribbon.
3 Under “Data Tools,” find and click on “What-If Analysis,” then select “Goal Seek.”
4 Set Goal Seek Parameters
In the Goal Seek dialog box:
• Set “Set cell” to the cell containing the Production Cost per Unit (C4).
• Set “To value” to the desired Target Production Cost (Rs. 500,000).
• Set “By changing cell” to the cell containing the Number of Units (B4).
364
CITS : IT & ITES - Computer Software Application - Exercise 65
