Spreadsheet to compute projected total costs and profits

Assignment Help Data Structure & Algorithms
Reference no: EM1380141

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. 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 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.

Reference no: EM1380141

Questions Cloud

Design a representation of display screen : Create a form that lists possible potatoes and toppings in a manner that is easy for counter servers and kitchen crew to scan, and can also be used as input for the inventory reorder system.
Communication diary : Choose two of these communications that you feel were poorly constructed or did not get the message across and analyse why this was the case.
Creating an object oriented data model : Create an object oriented data model, including all appropriate notations, to represent the given situation. In a particular region there are a number of gardens.
Sql statements : Suppose that the tables T1 and T2 have a 1:1 relationship. Suppose that T2 has the foreign key. Demonstrate the SQL statements necessary to move the foreign key to T1.
Spreadsheet to compute projected total costs and profits : Prepare a spreadsheet to compute your projected total costs, total revenues, and total profits for giving seminar on cost estimating.
Identifying flaws in the design : Identify flaws in design of the Report of Consumers that follows. What assumptions about users and tasks did you make in order to assess this design?
Formula to compute number of address bus conductors : If an address bus needs to be able to address 8-devices, how many conductors will be needed? What if each of those devices also requires to be able to talk back to the I/O control device?
Creating the table showing decimal value : Assume if the last digit of a 2's complement binary number is 0, then number is even. If the last two digits of a 2's complement binary number are 00
Construct an annotated bibliography : Construct an annotated bibliography - Should employers screen potential employees on the basis of lifestyle, physical appearance or personality tests?

Reviews

Write a Review

 

Data Structure & Algorithms Questions & Answers

  Linear-time algorithm to find odd-length cycle in graph

Give a linear-time algorithm to find an odd-length cycle in a directed graph. You may not suppose that graph is strongly connected.

  Write algorithm find intersection of two singly-linked list

Write an algorithm (pseudocode) to find the intersection of two singly-linked lists. Assume that the data in each list are in nondecreasing order.

  Explain compression algorithms are often used in forensics

"Compression algorithms are often used in forensics. Suppose you are involved in a case and have been asked by the lawyer to explain, in general terms.

  Dynamic-programming algorithm for rod-cutting problem

Consider a modification of the rod-cutting problem in which, in addition to a price pi for each rod, each cut incurs a fixed cost of c. Give a dynamic-programming algorithm to solve this modified problem.

  Write algorithm to prompt for and accept four numbers

Write the algorithm which will prompt for and accept four numbers, sort them into ascending sequence and display them to screen. Your algorithm is to include module called Order _two_numbers.

  How output of leaky bucket policer can be fed in second

Illustrate how output of the leaky bucket policer can be fed into second leaky bucket policer so that two leaky buckets in series police average rate, peak rate, and burst size.

  Designing an algorithm for task-array of person numbers

You have been allotted task of designing an algorithm for following task. Someone has built the array of person numbers of all n students enrolled in 331 this fall.

  Algorithm to keep track of sufficient information

Your algorithm must keep track of sufficient information so that, for any computer Cb it is possible to retrieve in O(n) time a sequence of communications by which Cb could have become infected.

  Write down the algorithm to insert an item

Write down the sample code to create a Linked List and allocate storage space for a node Write down the algorithm to insert an item At the beginning of a linked list

  Graph in which every node is pivotal for at least two nodes

Give an example of a graph in which every node is pivotal for at least two di fferent pairs of nodes. Explain your answer.

  Create list of major steps to follow to get input

Create a list of major steps to follow to get input, process, and output desired information (software requirements). Refine the list to include individual refined steps (algorithm).

  Creating a table of xml documents

Make a table of XML documents with a type of XML. Use a primary key so add a field of type INT that is an identity. Insert many records into XML field in this new table.

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