Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started