Complete the data table with cell B5 as the column input cell, showing the total revenue, total costs, and balance under different numbers of attendees.
Complete the data table with cell B5 as the column input cell, showing the total revenue, total costs, and balance under different numbers of attendees.
13.Create a CVP chart of the Total Revenue and Total Costs values using the data from the range G5:I16, the one-variable table, and then format the chart as follows:
a) Move and resize the chart to cover the range G18:J29.
b) Change the chart title to CVP Analysis.
c) Change the scale of the horizontal axis to go from 0 to 500 in 100-unit increments.
14.Brenda wants to investigate the impact of different registration fees and number of attendees on the seminar balance. In cell L6, display the value of cell B29 formatted to display the text Attendees. In the range L7:L16, enter attendee values ranging from 50 to 500 in increments of 50. In the range M6:P6, enter registration fees of $200, $300, $400, and $500.
15.Create a two-variable data table in the range L6:P16, using cell B6 as the row input cell and cell B5 as the column input cell.
AutoSave On NP_EX_8_Seminar - Saved - Search (Alt+Q) Jay File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share Queries & Connections ? Solver 16 A Y WA ra A1 A2 Sort EE Outline Stocks Clear Ye Reapply Filter Advanced Sort & Filter Get Data e Get & Transform Data Currencies Properties Refresh All Edit Links Queries & Connections Text to Columns Es G What If Forecast Analysis Sheet Forecast Data Types Data Tools Analyze G . K L M N O P Q R S T U W Balance Analysis Fee Fee Balance ($48.950) Break-Even Analysis Attendees Total Revenue Total Costs 200 $100,000 $51,050 50 100 150 200 250 300 350 400 4501 500 G4 Xv fx Break-Even Analysis A B C D E F F 3 4 Revenue . Room Fees 5 Attendees 200 Attendee Charge 6 Registration Fee per Attendee $500 $ 0 $1,500 7 Total Revenue $100,000 100 $1,750 8 200 $1,800 9 Variable Costs 300 $1,850 $ 10 Training Materials $150 400 $1,9001 11 Supplemental Materials $75 500 $2,000 12 Total Variable Costs $11,250 13 Meal Catering 14 Fixed Costs Attendee: Charge (per person) 15 Computing Costs $1,400 0 $150 16 Speaker Fees $2,400 100 $140 17 Speakers Travel $2,000 200 $130 18 Speakers Lodging $950 300 $1201 19 Miscellaneous $5,000 400 $110 20 Total Fixed Costs $11,750 500 $100 21 22 Mixed Costs Seminar Support 23 Room Costs $1,800 Attendee Charge 24 Meal Costs $26,000 0 $150 25 Support Costs $250 100 $200 26 Total Mixed Costs $28,050 2001 $250 27 300 $300 28 Cost per Attendee $255 400 $350 29 Balance ($48,950) 500 $500 30 31 32 33 34 Documentation Budget Effect of the Registration Fee on Attendance Attendance $0) 1.000 $100 819 1,200 $200 670 1,000 $300 549 $400 449 SDD $500 368 $600 301 500 $700 247 $800 202 400 $900 165 $1,000 135 200 $1,100 111 $1.200 91 $1,300 74 $0 $5DD $1,000 $1,400 61 Registration Fee $1,500 50 Ready 3 70% Type here to search | 0 0 a X 6:14 PM 11/22/2021 38F F 69 AutoSave On NP_EX_8_Seminar - Saved - Search (Alt+Q) Jay File Home Insert Draw Page Layout Formulas Data Review View Help Comments Share Queries & Connections ? Solver 16 A Y WA ra A1 A2 Sort EE Outline Stocks Clear Ye Reapply Filter Advanced Sort & Filter Get Data e Get & Transform Data Currencies Properties Refresh All Edit Links Queries & Connections Text to Columns Es G What If Forecast Analysis Sheet Forecast Data Types Data Tools Analyze G . K L M N O P Q R S T U W Balance Analysis Fee Fee Balance ($48.950) Break-Even Analysis Attendees Total Revenue Total Costs 200 $100,000 $51,050 50 100 150 200 250 300 350 400 4501 500 G4 Xv fx Break-Even Analysis A B C D E F F 3 4 Revenue . Room Fees 5 Attendees 200 Attendee Charge 6 Registration Fee per Attendee $500 $ 0 $1,500 7 Total Revenue $100,000 100 $1,750 8 200 $1,800 9 Variable Costs 300 $1,850 $ 10 Training Materials $150 400 $1,9001 11 Supplemental Materials $75 500 $2,000 12 Total Variable Costs $11,250 13 Meal Catering 14 Fixed Costs Attendee: Charge (per person) 15 Computing Costs $1,400 0 $150 16 Speaker Fees $2,400 100 $140 17 Speakers Travel $2,000 200 $130 18 Speakers Lodging $950 300 $1201 19 Miscellaneous $5,000 400 $110 20 Total Fixed Costs $11,750 500 $100 21 22 Mixed Costs Seminar Support 23 Room Costs $1,800 Attendee Charge 24 Meal Costs $26,000 0 $150 25 Support Costs $250 100 $200 26 Total Mixed Costs $28,050 2001 $250 27 300 $300 28 Cost per Attendee $255 400 $350 29 Balance ($48,950) 500 $500 30 31 32 33 34 Documentation Budget Effect of the Registration Fee on Attendance Attendance $0) 1.000 $100 819 1,200 $200 670 1,000 $300 549 $400 449 SDD $500 368 $600 301 500 $700 247 $800 202 400 $900 165 $1,000 135 200 $1,100 111 $1.200 91 $1,300 74 $0 $5DD $1,000 $1,400 61 Registration Fee $1,500 50 Ready 3 70% Type here to search | 0 0 a X 6:14 PM 11/22/2021 38F F 69
