1. Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person. 2....
Fantastic news! We've Found the answer you've been seeking!
Question:
1. Use Goal Seek to achieve a $0 balance by changing the Ticket Price per Person.
2. Beginning in cell E3, complete the series of substitution values ranging from 200 to 500 at increments of 20 students vertically down column E.
3. Enter cell references to the Total Income, Total Expenses, and Balance formulas (in that order) for a one-variable data table in cells F2, G2, and H2 respectively.
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Posted Date: