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

  Case study of us navy

Mark Womer and Brian Perry were members of the U.S. Navy and were stationed in Newport, Rhode Island. On April 10, Womer allowed Perry to borrow his auto-mobile so that Perry could visit his family in New Hampshire.

  Role of the hospital ceo

Explain why a CEO needs to make financial and operational decisions in running a hospital.

  Why is research ethics vital in business

Why is research ethics vital in business? Explain the rights and obligations of the participant, researcher and research sponsor

  Differences between virtual and face-to-face presentations

Understanding the differences between virtual and face-to-face presentations is certainly becoming more important as business needs grow.

  Business transition and change management

Change management is usually seen as an add on rather than an integral part of the process of managing the transition. Why?

  Eeo regulations-compliance-values and ethics

Recognize at least five EEO regulations with which your organization must comply. Describe how your HR department manages compliance with these regulations.

  Explain and analyze the civil rights act

Explain and Analyze the Civil Rights Act of 1964 to determine which part of the act is the most difficult to enforce and Discuss the difficulties you have identified as well as steps that could be taken to address those difficulties

  The implementation of the strategy

I s the implementation of the strategy similarly everyone's responsibility?

  Explain they began by opening just one store in mexico

Explain they began by opening just one or two stores in Mexico and what do you see as the main HR related challenges he and Jennifer would have to address

  Major classes of society and their seven subsets

What is the role of a job evaluation committee in job evaluation and who should be included in the committee and describe the reason for the trend towards broad generic job descriptions versus narrow specific job descriptions.

  Third party conflict resolution choice

Read the case below and Apply what you believe to be the best strategy and explain how it must resolve the conflict.

  How can workplace culture affect women

How can workplace culture affect women experiencing sexual harrassment.

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