Computing projected total cost and total revenues

Assignment Help Business Management
Reference no: EM1376456

Make a spreadsheet to compute 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:
1. $5 per person for registration plus 4 percent of the class fee per person to handle credit card processing: assuming everyone pays credit card
2. $0.40 per postcard if you order 5000 or more
3. $0.25 per postcard for mailing and postage
4. $25 per person for peverages and lunch
5. $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.

Reference no: EM1376456

Questions Cloud

Comparing lifestyle : Provide similarities and differences the work and lifestyle of a farmer, a factory worker, and a schoolteacher.
Managing project scope : List the skills that will enable project manager to most effectively manage change. As firms identify the synergistic results of integrating processes, project management is typically integrated with which six management components?
Analyzing outcomes : Determine what criteria do you use to examine outcomes against? What if you only had enough resources for three projects and two had to wait for more resources to become available?
Describe the merits of current research : Discover an instance where someone had made a claim about a connection in seemingly random events such as sports, health, or political section of a newspaper, in a magazine, or in any other source.
Computing projected total cost and total revenues : Make a spreadsheet to compute projected total revenues, total profits and total cost for giving a seminar on cost estimating. Below are some of your assumptions:
Discussion on safety of genetically modified foods : Are genetically modified foods a legitimate safety hazard and should government bureaues such as FDA take action to need safety testing?
Job description and duties for business analyst title : Suppose you are starting a new Business Anaylst team at work and you require some suggestions to get started.
Use of trigger words : How do you believe co employees handle conditions when someone uses one of their trigger words? Do you have responsibility to change your language
Understanding the nonverbal behavior : Explain a nonverbal behavior and suggest at least 3-different meanings that could be assigned to that behavior.

Reviews

Write a Review

Business Management Questions & Answers

  Person based and job based approach for job evaluation

Why would you use a Person Based Approach for job evaluation instead of a Job Based approach and how would you go about obtaining the information for a Person Based Approach?

  Make this assignment according to the apa guidelines

Make this assignment according to the APA guidelines found in the GCU APA Style Guide and located on the Student Success Center

  Show the organizational politics discussion

Organizational Politics Discussion - how you will use this information to help you become a more effective leader. Include one APA reference.

  Organizational change for smart pump iv technology

Explain possible organizational and individual barriers to change and find possible factors that may influence the change.

  Show various change strategies model

Various change strategies model depend on the how versed in change the organization you are trying to change is and the level of change management employees have previously experienced.

  Concept of economic darwinism

What might it have done differently and how does this example relate to the concept of economic Darwinism?

  Outline the employee orientation program

Earliest employee contacts with the training function is through an orientation program, designed distribute information to new employees quickly and efficiently

  Does arrow have an ethical responsibility to pay a higher

Who wins? Does Arrow have an ethical responsibility to pay a higher price, based upon such an unexpected change in circumstances?

  From the e-activity define the retail strategy

From the e-Activity define the retail strategy discussed in the blog you found. Suggest a retail industry that you could apply this strategy to.

  Explain successful entrepreneurial teams are comprised

Explain Successful entrepreneurial teams are comprised of these types of people because similarities in knowledge and skill ensure harmony and consistency in their new business

  Explaining cross-cultural motivational leadership

Is Hofstede's cultural dimensions model an adequate and thorough paradigm for cross-cultural motivational leadership?

  Show perceptions and stereotyping

The perception is that he is gay just because he is a male nurse. As a leader there is no way after a short meeting you can determine this fact. The statement is wrong in so many ways and is very illegal.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd