Question: Create a spreadsheet to calculate your projected total costs, total revenues, and total prots for giving a seminar on cost estimating. Use the following assumptions:

 Create a spreadsheet to calculate your projected total costs, total revenues,

and total prots for giving a seminar on cost estimating. Use the

Create a spreadsheet to calculate your projected total costs, total revenues, and total prots for giving a seminar on cost estimating. Use the following assumptions: . You will charge $500 per person for a two-day class, but you want to be able to change this input for analysis of different scenarios I You estimate that 30 people will attend the class, but you want to be able to change this input for analysis of different scenarios 0 Your xed costs include: 0 $500 to rent a room for both days 0 $400 for registration 0 $300 for designing a postcard for advertising 0 You will order 5,000 postcards. You will mail 4,000 of them and distribute the remainder to friends and colleagues - Variable costs include: 0 $5 per attendee for registration 4% of the class fee per person to handle credit card processing $.40 per postcard for printing costs $.35 per postcard for postage $25 per attendee for food and drink $30 per attendee for handouts 00000 Be sure to have input cells for any variables that might change. Calculate your prots based on these potential quantities of attendees 10, 20, 30, 40, 50, and 60. Use the Excel Scenario Manager {see demonstration video} to show the potential profits at each level of attendance. Use the Goal Seek tool in Excel to calculate the number of attendees that would be required in order to break even on the seminar

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!