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