Create a spreadsheet to calculate your projected total costs

Assignment Help Management Information Sys

Reference no: EM131858970

Problem

Create a spreadsheet to calculate your projected total costs, 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 costs 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 5,000 postcards, mail 4,000, and distribute the rest to friends and colleagues.

• Your variable costs include the following:

a. -$5 per person for registration plus four percent of the class fee per person to handle credit card processing; assume everyone pays by credit card.

b. $.40 per postcard for printing if you order 5,000 or more.

c. $.25 per postcard for mailing and postage. d. $25 per person for beverages and lunch.

d. $30 per person for class handouts. Be sure to have input cells for any variables that might change, such as the cost of post-age, handouts, 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. Try to use the Excel data table feature showing the profits 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: EM131858970

Questions Cloud

Analytical review of rar companys trial balance : Analytical Review of Trial Balance for Audit Planning - Audit process Plan and identify key balance sheet and Income statement items

Describe the key differences between a vehicle search : Describe the key differences between a vehicle search under the Carroll doctrine and a vehicle search under the search

Describe the gift-giving situation : Describe the gift-giving situation facing the consumer and the nature of the gift-giving relationship; write a minimum of 5-6 sentences in response to this.

Effort to collect valid and reliable information : How do the components of research "fit" together in an effort to collect valid and reliable information.

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

Discuss your views on the justification for punishment : Discuss your views on the justification for punishment. If you knew for certain that prison did not deter

Compare and contract paper of plato vs aristotle : How much would it be for a compare and contract paper of Plato vs Aristotle. using one of my beliefs from my first paper which was Knowledge.

Write a brief report of what you learned from your research : Research online information, textbooks, and local classes for using the cost management features. Write a brief report of what you learned from your research.

Describe the basic training and development process : As a consultant working with a company, I have been having trouble in my training effectiveness. Front-line employees have been taking the courses to improve.

User Account

All Pages