1. Use Goal Seek to attain a $0 balance by changing the Ticket Price per Person.

You are watching: Use goal seek to achieve a $0 balance by changing the ticket price per person

2. Beginning in cell E3, finish the series of substitution values varying from 200 to 500 at increments of 20 students vertically dvery own column E.

3. Get in cell recommendations to the Total Income, Total Expenses, and Balance formulas (in that order) for a one-variable information table in cells F2, G2, and H2 respectively.

See more: What Does Endow Mean In The Bible, What Does Endow Mean

*
Group Clear Reapply Cutting edge Columns Queries & Connections Ungroup -- Subtotal Existing Connections Properties Text tog- Get From Data what-if Analysis Sort Filter Forecast All Edit Links Analysis- Sheet Get & Transform Data Queries & Connections Sort & Filter File Tools Foreactors Anayze A1 / fr Valentines Day Ball Valentines Day Ball One-Variable Data Table: Attendees Input Section 4 No. of Attendees 5 % Attendees Using Valet 6 Cost per Chair Setup 50% 2.00 19.95 Valet Parking per Car 8 Caterers Meal Cost per Human 20.95 9 Ticket Price per Human 10 $75.00 Limitations 12 Maximum Attendees 13 Maximum Parking Stalls 14 Minimum Ticket Price 15 Maximum Ticket Price 16 17 18 Student Club Contributions 19 Ticket Revenue 20 Total Income 21 240 $50.00 100.00 Income 8,500 $38,500 Two-Variable Documents Table: Attendees and Price Per Ticket Budget + 100%">
*


Who are the experts?Experts are tested by lutz-heilmann.info as professionals in their topic location. We testimonial their content and use your feedearlier to keep the high quality high.
Step1: Downpack and also open up the file called exploring_e06_grader_Capstone2.xlsx. Step2: Use Goal Seek to achieve a $0 balance by transforming the Ticket Price per Human being. Go to File tab on the Ribbon. Select the option “Goal Seek” from t…View the full answer
*

Transcribed photo text: Documents Home Insert Draw Page Layout Formulas Documents Recheck out View Tell me what you want to execute From Text/CSV Recent Sources From Web From Table Range 《> Group Clear Reuse State-of-the-art Columns Queries & Connections Unteam -- Subtotal Existing Connections Properties Text tog- Get From File what-if Analysis Sort Filter Foreactors All Edit Links Analysis- Sheet Get & Transcreate Data Queries & Connections Sort & Filter Data Tools Forecast Anayze A1 / fr Valentine's Day Ball Valentine's Day Ball One-Variable Data Table: Attendees Input Section 4 No. of Attendees 5 % Attendees Using Valet 6 Cost per Chair Setup 50% 2.00 19.95 Valet Parking per Car 8 Caterer's Meal Cost per Human being 20.95 9 Ticket Price per Person 10 $75.00 Limitations 12 Maximum Attendees 13 Maximum Parking Stalls 14 Minimum Ticket Price 15 Maximum Ticket Price 16 17 18 Student Club Contributions 19 Ticket Revenue 20 Total Income 21 240 $50.00 100.00 Income 8,500 $38,500 Two-Variable File Table: Attendees and Price Per Ticket Budget + 100%