Explanation

Goal Seek can also determine the number of units that need to be sold to achieve a target profit.

Data

Input

Value

Quantity

100

Selling Price

₹800

Cost per Unit

₹500

Fixed Cost

₹10,000

Formula

Profit

=(B2*B3)-(B2*B4)-B5

Suppose the target is:

₹50,000 Profit

Goal Seek:

  • Set cell: Profit
  • To value: 50000
  • By changing cell: Quantity

Important

If the quantity must be a whole number, round or adjust the resulting value appropriately.

Practice

Find the quantity required for:

  • ₹30,000 profit
  • ₹50,000 profit
  • ₹75,000 profit
PreviousNext