I need help with 6 please help me y'all!

EX 654 Excel | Module 10 Performing What-If Analyses 5. There are several fixed costs associated with the seminar. Providing an Internet hotspot for the attendees will cost $50. The $140 lodging stipend. Constance estimates $350 in miscellaneous expenses. Enter t in the range B15:B19. Calculate the total fixed costs in cell B20. seminar speaker's fee is $900 plus a $500 travel allowance and values 6. The company must rent a conference room large enough to accommodate the num attendees. The lookup table in the range D5:E10 contains the room charges for semns 0 to 0 people, 50 to 100 people, 100 to 150 people, 150 to 200 people, and beyond 20 For example, a room that fits 0 to 50 people will cost the company $400. In cell t:23, 1 late the room rental cost by looking up the room rental fee based on the number of attende j to the seminar. (Hint: Use the VLOOKUP function with an approximate match lookup.) 7. The more people attending the seminar, the less the hotel will charge per person to cat seminar meals. In cell B24, calculate the total catering charge by using the lookup tabl D13:E16 to determine the cost per person, and then multiply that value by the numbe 8. The company also needs to pay for the hotel support staff. The larger the seminar, th the support staff fee. The lookup table in the range D19:E23 contains the staff fees i different sizes. For example, a seminar of 0 to 50 people will incur a $60 staff fee. In cel!l 825, calculate the support staff charge for the number of attendees to the seminar of 9. In cell B26, calculate the total mixed costs from the room rental, meal catering, and suppont 10. Use Goal Seek to determine what number of attendees will result in a balance of $0. Enter your 11. Create a one-variable data table of different seminar budgets. In cell G6, display the value of staff. In cell B28, calculate the balance from the conference by subtracting the sum of the variable, fixed, and mixed costs from the total revenue. conclusion in the merged cell A30, indicating how many attendees are needed to break even for a registration fee of $120. Change the value in cell B5 back to 100 cell B5. In cell H6, display the value of B7. In cell 16, display the sum of cells B12, B20, and B26. In cell 16, display the value of cell 828. In the range G7:G21, enter the number of possible attendees ranging from 20 to 300 in increments of 20. Complete the data table, showing the total revenue, total costs, and balance for each seminar size. 12. Create a CVP chart of the Total Revenue and Total Costs values in the one-variable table. Format the table so that it is easy to read, and resize it to cover the range G23:334 nstance wants to investigate the impact of different registration fees and number of attendees Attendees". In the range L7121, minar balance. In cell L6, display the value of cell B28, formatted to display the text enter attendee values ranging from 20 to 300 in increments of range M6:P6, enter registration fees of $75 to $150 in increments of $25. In the range e the two-variable data table using the number of attendees and the registration fee as the input valu es 4. Create a chart of the balances versus the number of attendees with each registration fee displayed as a separate line. Format the chart so that it is easy to interpret, and resize it to cover the range L23:P34 of the worksheet. eate scenarios for the other possible values for the input cells listed in Figure 10-48. Figure 10-48 Seminar what-if scenarios Changing Cell Attendees Registration Fee Training Material Cost Goodie Bag Cost Speaker Fee Speaker Travel Speaker Lodging Seminar 1 Seminar2 150 $85 $30 $10 $750 $420 $125 Seminar 3 100 $120 $35 $15 $900 $500 $140 75 $140 $40 $20 5950 500 $120 EX 654 Excel | Module 10 Performing What-If Analyses 5. There are several fixed costs associated with the seminar. Providing an Internet hotspot for the attendees will cost $50. The $140 lodging stipend. Constance estimates $350 in miscellaneous expenses. Enter t in the range B15:B19. Calculate the total fixed costs in cell B20. seminar speaker's fee is $900 plus a $500 travel allowance and values 6. The company must rent a conference room large enough to accommodate the num attendees. The lookup table in the range D5:E10 contains the room charges for semns 0 to 0 people, 50 to 100 people, 100 to 150 people, 150 to 200 people, and beyond 20 For example, a room that fits 0 to 50 people will cost the company $400. In cell t:23, 1 late the room rental cost by looking up the room rental fee based on the number of attende j to the seminar. (Hint: Use the VLOOKUP function with an approximate match lookup.) 7. The more people attending the seminar, the less the hotel will charge per person to cat seminar meals. In cell B24, calculate the total catering charge by using the lookup tabl D13:E16 to determine the cost per person, and then multiply that value by the numbe 8. The company also needs to pay for the hotel support staff. The larger the seminar, th the support staff fee. The lookup table in the range D19:E23 contains the staff fees i different sizes. For example, a seminar of 0 to 50 people will incur a $60 staff fee. In cel!l 825, calculate the support staff charge for the number of attendees to the seminar of 9. In cell B26, calculate the total mixed costs from the room rental, meal catering, and suppont 10. Use Goal Seek to determine what number of attendees will result in a balance of $0. Enter your 11. Create a one-variable data table of different seminar budgets. In cell G6, display the value of staff. In cell B28, calculate the balance from the conference by subtracting the sum of the variable, fixed, and mixed costs from the total revenue. conclusion in the merged cell A30, indicating how many attendees are needed to break even for a registration fee of $120. Change the value in cell B5 back to 100 cell B5. In cell H6, display the value of B7. In cell 16, display the sum of cells B12, B20, and B26. In cell 16, display the value of cell 828. In the range G7:G21, enter the number of possible attendees ranging from 20 to 300 in increments of 20. Complete the data table, showing the total revenue, total costs, and balance for each seminar size. 12. Create a CVP chart of the Total Revenue and Total Costs values in the one-variable table. Format the table so that it is easy to read, and resize it to cover the range G23:334 nstance wants to investigate the impact of different registration fees and number of attendees Attendees". In the range L7121, minar balance. In cell L6, display the value of cell B28, formatted to display the text enter attendee values ranging from 20 to 300 in increments of range M6:P6, enter registration fees of $75 to $150 in increments of $25. In the range e the two-variable data table using the number of attendees and the registration fee as the input valu es 4. Create a chart of the balances versus the number of attendees with each registration fee displayed as a separate line. Format the chart so that it is easy to interpret, and resize it to cover the range L23:P34 of the worksheet. eate scenarios for the other possible values for the input cells listed in Figure 10-48. Figure 10-48 Seminar what-if scenarios Changing Cell Attendees Registration Fee Training Material Cost Goodie Bag Cost Speaker Fee Speaker Travel Speaker Lodging Seminar 1 Seminar2 150 $85 $30 $10 $750 $420 $125 Seminar 3 100 $120 $35 $15 $900 $500 $140 75 $140 $40 $20 5950 500 $120