Page 378 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

6 Review the Result
Excel will automatically adjust the PROFIT percentages for each quarter to achieve the target Annual Profit of
2,300,000.

TASK 2: You want to use Goal Seek to determine the number of units that need to be produced to achieve
a target production cost of 50,0000, assuming fixed costs of 20,0000 and a variable cost per unit
of 150

1 Set Up the Initial Table
Create an Excel table with the following columns:

2 Formulas
1 In cell B4 (Number of Units), enter the initial number of units (e.g., 1,000).
2 In cell C4(Production Cost per Unit), enter the formula:

3 Press Enter

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