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

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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