Explanation

Goal Seek is commonly used in business pricing and sales planning.

Data

Input

Value

Quantity

200

Selling Price

500

Cost per Unit

300

Fixed Cost

10,000

Formulas

Revenue

=B2*B3

Variable Cost

=B2*B4

Total Cost

=B5+B6

Profit

=B5-B7

Current Profit:

₹30,000

Goal

The business wants:

₹50,000 Profit

Goal Seek:

  • Set cell: Profit
  • To value: 50000
  • By changing cell: Selling Price

Excel calculates the required selling price.

Practice

Find the selling price required to achieve:

  • ₹40,000 profit
  • ₹50,000 profit
  • ₹60,000 profit
PreviousNext