Explain how to use Excel's 'GOAL SEEK' function for solving equations.
Instruction: Price is B2 (initially20), units B3=100, fixed costs B4=500, variable unit cost B5=8, and profit B6=(B2-B5)*B3-B4. Explain how to use Goal Seek to reach profit1000, calculate the required price and distinguish target solving from price optimization or ROI analysis.
Context: This question tests the candidate's understanding of Excel's 'GOAL SEEK' function as a tool for solving equations and making informed decisions based on specific goals.
Updated
Official answer available
Read the opening below, then unlock the full answer and practical guidance.
Goal Seek is a what-if analysis tool that adjusts one input cell until a dependent formula approaches a target value. It is not a worksheet function or a general constrained optimizer.
Set up B2 as selling price (start at 20), B3 as units sold (100), B4 as fixed costs (500), B5 as variable cost per unit (8), and B6...