Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Scenario: As a senior financial advisor you have decided to develop materials, then market and hold a two day investment seminar. You plan to do

Scenario: As a senior financial advisor you have decided to develop materials, then market and hold a two day investment seminar. You plan to do all the work within the next six months. You want to create a good cost estimate for this project. Below are some of your assumptions: You will charge $600 per person for the two-day event. You estimate that 30 people will attend. Your fixed costs include $750 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 expect that you will spend at least 150 hours developing materials, managing the project, and giving the actual presentations. You would like to know what your time is worth given different scenarios. You will order 5,000 postcards, mail 4,000, and distribute the rest to clients and colleagues. Your variable costs include the following: 1) $10 per person for registration plus 4 percent of the seminar fee per person to handle credit card processing. Assume everyone pays by credit card 2) $.90 per postcard if you order 5,000 or more 3) $.85 per postcard for mailing and postage 4) $25 per person for beverages and lunch 5) $30 per person for handouts Using Excel, create a spreadsheet to calculate your projected total costs, total revenues, and total profits given the preceding information. Be sure to have input cells for any variables that might change, such as the cost of postage, handouts, and so on. Calculate your profits and your hourly wage based on the following number of people attending: 10,20,30,40,50, and 60.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management

Authors: Chuck Williams

4th Edition

978-0324316797, 0324316798

More Books

Students also viewed these General Management questions