Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

  • You will charge $995 per person for a two-day class.
  • You estimate that 30 people will attend the class, but you should keep an option to change this input.
  • Your fixed costs include $500 total to rent a room for both days, setup fees of $500 for registration, and $300 for designing a postcard for advertising.
  • You will not include 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 5,000 postcards, mail 4,000, and distribute the rest to friends and colleagues.
  • Your variable costs include the following:
    1. $9 per person for registration plus four percent of the class fee per person to handle credit card processing; assume that everyone pays by credit card
    2. $.49 per postcard for printing if you order 5,000 or more
    3. $.25 per postcard for mailing and postage
    4. $25 per person for beverages and lunch
    5. $30 per person for class handouts

Calculate and post your profits based on 30 people. Also, list any assumptions you made. In addition, calculate what your time would be worth per hour based on the number of students. BE SURE TO POST YOU EXCEL FILE.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Managerial Accounting

Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer

12th Edition

9780073526706

Students also viewed these Accounting questions

Question

'n soence,

Answered: 1 week ago