The target cell is the cell which will represent the objective or goal. Lets suppose a scenario in which the production manager of a firm would presumably want to maximize the profitability of the Product during each month. The cell that measures profitability would be the target cell.