Ask Question, Ask an Expert


Ask Computer Engineering Expert

Prepare a spreadsheet to compute your projected total costs, total revenues, and total profits for giving 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 designing a postcard for advertising.

You will not include your any of your labor costs for this estimate, but you estimate 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

e. $30 per person for class handouts

Be sure to have input cells for any variables that might change, such as the cost of postage, handouts, and so on. find out your profits based on the following number of people who attend: 10, 20, 30, 40, 50, and 60. In addition, find out what your time would be worth per hour based on the number of students. Try to use the Excel data table features 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 fro each scenario and what your time is worth.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M938010

Have any Question? 

Related Questions in Computer Engineering

Assignment -you can generally assume that code shown in the

Assignment - You can generally assume that code shown in the questions is intended to be syntactically correct, unless something in the question or one of the answers suggests otherwise. Q1. Given the following statement ...

Functions and excel tasks please respond to the following

"Functions and Excel Tasks" Please respond to the following: Identify three (3) Microsoft Excel 2013 functions that you believe to be the most useful within the application. Next, describe one (1) way in which you would ...

Suppose xyz software company has a new application

Suppose XYZ Software Company has a new application development project, with projected revenues of $1,200,000. Using the following table, calculate the ARO and ALE for each threat category that XYZ Software Company faces ...

1 what is a negative feedback loop how is it used to keep a

1. What is a negative feedback loop? How is it used to keep a project in control? 2. When a task is not being completed according to the plan, what two circumstances are likely to be involved?

1 complete the implementation of the multiarray class by

1. Complete the implementation of the MultiArray class by implementing the helper method computeFactors(). 2. 1 In this chapter, we implemented the Set ADT using a list. Implement the Set ADT using a bag created from the ...

The random class implements a random number generator which

The Random class implements a random number generator, which produces sequences of numbers that appear to be random. To generate random integers, you construct an object of the Random class, and then apply the nextInt me ...

Standards are very important part of industry benchmarks

Standards are very important part of industry benchmarks, regulations, and quality systems.  Explain the following in details: The purpose and need of standards.  Give at least three example List at least three sets of U ...

Compare and contrast the social and environmental risks and

Compare and contrast the social and environmental risks and vulnerabilities for the two counties you selected, I have selected Norman, Oklahoma and Charles County, Maryland, and summarize your findings. Describe the comm ...

1 describe the defend strategy list and describe the three

1. Describe the "defend" strategy. List and describe the three common methods. 2. Describe the "transfer" strategy. Describe how outsourcing can be used for this purpose. 3. Describe the "mitigate" strategy. What three p ...

Assignment 1system security certification and

Assignment 1 System Security Certification and Accreditation Becoming better acquainted with the history of accreditation and authorization has made you aware that you need to start planning tasks in order to complete a ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen