Instructions: (10 points) Read the following scenario and complete the problem using Goal Seek. 1 (5 Points) Given the following infromation on costs and revenues, use Goal Seek to find the product volume that would result in a profit or loss of $0 (i.e., the Break-Even point). Fixed Cost| $ 60,000.00 Variable Cost $ 20.00 Price $ 30.00 Break Even Volume Total Cost $ 60,000.00 Total Revenue | $ Total Profit or Loss|$ (60,000.00) 2. Capture a screen shot of your Goal Seek dialog before you clik OK and paste it in the space below. To do this, once you have specified all the parameters, hold down the "Alt" key and press the "PrtSon" key on your keyboard. This copies only the top-most dialog to the Clipboard. Now right-click on cell B27 and choose "Paste" to place the picture in the spreadsheet. Place Clipboard Image here 3. (5 Points) Answer: What is the minimum number of units that we need to sell in order to make a profit? |units