Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving a seminar on cost estimating. I have provided a template to help you get started. (Note: You will need to list your variable costs where designated.) Cost Estimate Template

Make the following assumptions:

• You will charge $600 per person for a two-day class.
• You estimate that 30 people will attend the class, but you want to change this input in case your estimates are off.
• Your fixed costs 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 your labor costs in this estimate, but you expect to 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 for each of the scenarios.
• You will order 5,000 postcards, mail 4,000, and distribute the rest to friends and colleagues.
• Your variable costs include the following:

a. $5 per person for registration plus 4 percent of the class fee per person to handle credit card processing; assume that everyone pays by credit card b. $.40 per postcard for printing if you order 5,000 or more c. $.35 per postcard for mailing and postage d. $25 per person for beverages and lunch e. $30 per person for class handouts Be sure to account for any variables that might change based on the number of people, such as the cost of postage and handouts. Calculate your profits based on each of the following numbers of people who might attend: 10, 20, 30, 40, 50, and 60. Try to use the Excel data table feature to show the profits 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. Highlight the profits for each scenario.

**You need to use formulas for your calculations; do not just enter the costs in each cell. The formulas in each cell will show when you click on the cell.

BELOW is the template that must be used!!

AutoSave OFF NESU = Home Insert Draw Page Layout Formulas Data Review View Data Mining Times New Roman 12 A ab Wrap Text [C Paste BI U v Av Merge & Center D23 x fox c B C D E F G 10 20 30 40 50 60 A 1 Your Name 2 3 Projected Revenues 4 # people 5 Price/Person 6 Total 7 8 Projected Expenses 9 Room Fee 10 Registration Setup Fee 11 Postcard Design 12 Registration Variable Costs 13 Credit Card Processing Variable Costs 14 Postcard Variable Costs 15 Postcard Mailing and Postage 16 Beverages and Lunch 17 Class Handouts 18 Total 19 20 Projected Profits 21 Value of Personal Time/Hour 22 23 Variable Costs 24 (List them here) 25 26 27 28 29 30 31 Unit Costs and Other Info 32 # of Postcards Made 33 # of Postcards Mailed 34 Registration/Person 35 Credit Card Fee/Person-4% * Fee ($600) 36 Postcards (Each) 37 Postcard Mailing and Postage (Each) 38 Beverages and Lunch/Person 39 Class Handouts/Person 40 Person Hours Spent 41 Sheet1 +