1) Conduct a Break even analysis (G4:17) using a 1-Variable data table to determine the number of attendees that must attend each seminar in order for them to Break even. Determine the exact amount of attendees using analysis that you have learned in this module and include a chart that shows the Break even analysis. Use best practices when creating a Chart. (20 marks) 2) Granite Life would also like to forecast Net Income based on the number of attendees ranging from 20 to 300 in increments of 20 and Registration fees ranging from $75 to $150. Create a 2-Variable data table in (L5:P17) that shows the various Net Income level for each combination of Attendees and Registration Fees. (15 marks) Granite Life Cost Structure Variable Costs per attendee Training Materials Registration Fee Supplemental Materials Meal Catering $35 $95 $15 $1.5 Fixed Costs Computing Costs Speaker Fees Speakers Travel Speakers Lodging Miscellaneous Room Costs Support Costs $50 $900 $500 $140 $350 $2,500 $800 B D E F G H I J K L M N 2 Seminar Budget Projections 3 Break Even Analysis Balance Analysis 1 $95 $95 $35 $15 $1 $50 4 Revenue 5 Attendees 6 Registration Fee per Attendee 7 Total Revenue 8 9 Variable Costs 10 Training Materials 11 Supplemental Materials 12 Meal Catering 13 Total Variable Costs 14 15 Fixed Costs 16 Computing Costs 17 Speaker Fees 18 Speakers Travel 19 Speakers Lodging 20 Miscellaneous 21 Room Costs 22 Support Costs 23 Total Fixed Costs 24 25 Total Costs 26 Net Income 27 28 $50 $900 $500 $140 $350 $2,500 $800 $5,240 $5,290 ($5,195) Documentation Budget + 1) Conduct a Break even analysis (G4:17) using a 1-Variable data table to determine the number of attendees that must attend each seminar in order for them to Break even. Determine the exact amount of attendees using analysis that you have learned in this module and include a chart that shows the Break even analysis. Use best practices when creating a Chart. (20 marks) 2) Granite Life would also like to forecast Net Income based on the number of attendees ranging from 20 to 300 in increments of 20 and Registration fees ranging from $75 to $150. Create a 2-Variable data table in (L5:P17) that shows the various Net Income level for each combination of Attendees and Registration Fees. (15 marks) Granite Life Cost Structure Variable Costs per attendee Training Materials Registration Fee Supplemental Materials Meal Catering $35 $95 $15 $1.5 Fixed Costs Computing Costs Speaker Fees Speakers Travel Speakers Lodging Miscellaneous Room Costs Support Costs $50 $900 $500 $140 $350 $2,500 $800 B D E F G H I J K L M N 2 Seminar Budget Projections 3 Break Even Analysis Balance Analysis 1 $95 $95 $35 $15 $1 $50 4 Revenue 5 Attendees 6 Registration Fee per Attendee 7 Total Revenue 8 9 Variable Costs 10 Training Materials 11 Supplemental Materials 12 Meal Catering 13 Total Variable Costs 14 15 Fixed Costs 16 Computing Costs 17 Speaker Fees 18 Speakers Travel 19 Speakers Lodging 20 Miscellaneous 21 Room Costs 22 Support Costs 23 Total Fixed Costs 24 25 Total Costs 26 Net Income 27 28 $50 $900 $500 $140 $350 $2,500 $800 $5,240 $5,290 ($5,195) Documentation Budget +