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

  Distribution method of performance evaluation

Organizations using a forced distribution method of performance evaluation place predetermined percentages of employees into particular performance categories.

  Explain was the discipline reasonably related to the workers

Explain Was the discipline reasonably related to the worker's record and the severity of the conduct?

  Display the necessary elements of employment discrimination

Ozzie quits as well as files a suit against Players for employment discrimination. Can Ozzie display the necessary elements of employment discrimination

  Current decision making conditions within the organization

Find at least three recommendations that will help him improve or overcome the current decision making conditions within the organization.

  Which job pays the higher salary

The other pays pays $97,000 annually, but your salary will grow at 12%. After ten years, which job pays the higher salary?

  Global expansion through franchising for market penetration

The CEO is looking for another country in which to enter with his restaurant. He has to work within certain limitations, etc. One my suggestions will be to establish more franchises within the countries where restaurants were recently opened.

  Measuring verbal and computational skills

Measuring verbal and computational skills  to a group of applicants for a specific job.

  Holding costs - which option is more economical

Which option is more economical and what customer issues are not included in the data presented

  Methods of building high-performing teams

Construct a PowerPoint presentation that highlights the benefits of well functioning teams. Use the Library and Internet to research this topic.

  Explain various types of personnel assessments

Describe various types of personnel assessments and explain which assessments you would use for the training position candidates and why these are the most appropriate.

  Explain how else can nordstrom continue to provide

Explain How else can Nordstrom continue to provide exceptional customer service and increase brand locality

  Review of loretta wilson vs b/e aerospace

How would the plaintiff establish a prima facie case of disparate treatment? Do not quote the case. Explain it in your own words and continue reading a little farther along in the case. Explain Wilson's 3 arguments? How were they resolved?

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