Marks PC Solution

Goal Seek helps you to find a specific target from a given data. Suppose you are required to adjust either cost or price or production unit to make a certain amount of profit. In this situation, you can use Goal Seek to find out the optimum level of input to meet your target. Here you must know that the Goal Seek can only work with a single variable.  Note: This tutorial is prepared on Excel 2013. Excel 2007 and 2010 will be much similar to version 2013.  Example 1 Let's start by a simple example. Go to Excel > Open a Blank Worksheet > Input the data as shown below: The red figures are negative values. Input the figures in Sales for Product A, B and C. Enter Cost of Goods Sold in the next row. Deduct 3rd row from 2nd row to find out the Gross Profit. (i.e. =B2-B3) Enter the other expenses in the 5th row. Deduct expenses from Gross profit to find Net Profit. (i.e. =B4-B5) Important: you must find out the Gross Profit, Net Profi...