Create a spreadsheet to calculate your projected total cost, total revenues, and total profits for giving a seminar on cost estimating. Below are some of your assumptions:
- You will charge $600 per person for a two-day class
- You estimate that 30 people will register for and attend the class, but you want to change this input.
- Your fixed cost include $500 total to rent a room for both days, setup fees of $400 for registration, and $300 for designing a postcard for advertising.
- You will not include any of your labor costs for this estimate, but you estimate that you will spend at least 150 hours developing materials, managing the project, and giving the actual class. You would like to know what your time is worth given different scenarios.
- You will order 5000 postcards, mail 4000 and distribute the rest to friends and colleagues.
- Your variables costs include the following:
i. $5 per person for registration plus 4 percent of the class fee per person to handle credit card processing: assuming everyone pays credit card
ii. $0.40 per postcard if you order 5000 or more
iii. $0.25 per postcard for mailing and postage
iv. $25 per person for beverages and lunch
v. $30 per person for class handout
Be sure to have input cells for any variables that might change, such as the cost of postage, handout, and so on. Calculate your profits based on the following number of people who attend: 10, 20, 30, 40, 50, and 60. In addition, calculate what your time would be worth per hour based on the number of students. If you are unfamiliar with data tables, just repeat the calculations for each possibility of 10,20,30,40,50, and 60 students. Print your results on one page, highlighting the profits for each scenario and what your time is worth.
This tutorial provides guidelines on creating a spreadsheet to calculate projected total costs, total revenues, and total profits for giving a seminar on cost estimating.