Question

3. Find What if analysis using solver, Calculate the value of profit and profit per unit where selling price is Maximum of Rs. 20 and Making cost should be minimum of Rs. 2

Answer 1

Step-by-step explanation:

The tutorial explains how to use Goal Seek in Excel 2016, 2013 and 2010 to get the formula result you want by changing an input value.

What-If Analysis is one of the most powerful Excel features and one of the least understood. In most general terms, What-If Analysis allows you to test out various scenarios and determine a range of possible outcomes. In other words, it enables you to see the impact of making a certain change without changing the real data. In this particular tutorial, we will focus on one of Excel's What-If Analysis tools - Goal Seek.