Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving...

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

You will charge $995 per person for a two-day class.
You estimate that 30 people will attend the class, but you should keep an option to change this input.
Your fixed costs include $500 total to rent a room for both days, setup fees of $500 for registration, and $300 for designing a postcard for advertising.
You will not include 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:
1. $9 per person for registration plus four percent of the class fee per person to handle credit card processing; assume that everyone pays by credit card
2. $.49 per postcard for printing if you order 5,000 or more
3. $.25 per postcard for mailing and postage
4. $25 per person for beverages and lunch
5. $30 per person for class handouts

Calculate and post your profits based on 30 people. Also, list any assumptions you made. In addition, calculate what your time would be worth per hour based on the number of students. BE SURE TO POST YOU EXCEL FILE.

Solutions

Expert Solution

SINCE I CANNOT ATTACH EXCEL FILE. HAVE GIVEN SCREEN SHOT OF HOW TO CREATE EXCEL SO THAT YOU CAN CREATE ONE.-----------------PLEASE GIVE RATINGS ------------------------


	CALCULATIONS OF PROFIT

		(IN $)
REVENUE PER STUDENT	NO. OF STUDENTS	TOTAL REVENUE COLLECTED
995	30	29850	<----- A


CREDIT CARD PROCESSING FEES	NO. OF STUDENTS	TOTAL
9.36	30	280.80	<----- B
I.E =9 + 4% OF 9

PRINTING COST PER POST CARD	NO. OF POSTCARD PRINTED	TOTAL
0.49	5000	2450.00	<----- C

MAILING COST PER POST CARD	NO. OF POSTCARD SENT
0.25	4000	1000.00	<----- D

BEVERAGE AND LUNCH	NO. OF STUDENT	TOTAL
25	30	750.00	<----- E

CLASS HANDOUTS	NO. OF STUDENT	TOTAL
30	30	900.00	<----- F



FIXED COST	RENT	500	<----- G

FIXED COST	SETUP COST OF REGISTRATION	500	<----- H

FIXED COST	DESIGNING OF POST CARD	300	<----- I

	TOTAL NET PROFIT	23169.20	.=A-B-C-D-E-F-G-H

	NO. OF HOURS	150

	PER HOUR PROFIT	154.46	.=23169.20/150 (TOTAL NET PROFIT / NO. OF HOURS)


ASSUMPTIONS: 1. ONLY 4000 CARDS HAVE BEEN POSTED AND MAILING COST IS INCURRED ON ONLY THOSE CARDS.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Using an excel spreadsheet to present your work, calculate the projected revenue collected from federal income...

Using an excel spreadsheet to present your work, calculate the projected revenue collected from federal income taxes, state income taxes, and the local payroll tax for FY 2014 and prepare a revenue estimate for the City of Newark’s Public School System for FY 2015 based on the following information. Assume that no other deductions came from the employee’s salary other than what is listed here. Hint: New employees are not eligible for raises, which are based on performance from the...

Under normal market conditions, if your profits are greater than your average total costs, it is...

Under normal market conditions, if your profits are greater than your average total costs, it is called making a profit and new firms try to enter the industry and existing firms expand. If your profits are lower than your average total costs, firms operate at a loss, and often exit the industry or contract. If your profit matches your average total cost, it is called breaking even and most firms operate at their current capacity. However, not all industries are...

. Fixed Costs, Variable Costs, Total Costs, Revenues are used to estimate profitability. This is an...

. Fixed Costs, Variable Costs, Total Costs, Revenues are used to estimate profitability. This is an intersection with Economics and Accounting. Explain how they are derived and used for both disciplines.

Time series are particularly useful to track variables such as revenues, costs, and profits over time....

Time series are particularly useful to track variables such as revenues, costs, and profits over time. Time series models help evaluate performance and make predictions. Consider the following and respond in a minimum of 175 words: Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components? The model can be additive or multiplicative.When we do use an additive model? When do...

Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”....

Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”. As depicted below. 1 timesteps in years rate. 2 <enter timestep> <enter your rate> 3 count date interest this period total$ 4 0 30-Sep-16 <enter your total> 5 1 You will begin with the count at 0, and the date of Sept 30, 2016. For that first row, the “Interest this period” is zero, and the total is $22,000 CAD. Above the...

Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”....

Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”. As depicted below. You will begin with the count at 0, and the date of Sept 30, 2016. For that first row, the “Interest this period” is zero, and the total is $22,000 CAD. Above the columns, put the label “rate”, and in the cell below that, enter your periodically compounding rate of 19%. Put the label “Timestep in years” and in the cell...

Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”....

Create a table on a spreadsheet with columns labelled “Count”, “Date”, “Interest this Period”, and “Total”. As depicted below. You will begin with the count at 0, and the date of Sept 30, 2016. For that first row, the “Interest this period” is zero, and the total is $39,000 CAD. Above the columns, put the label “rate”, and in the cell below that, enter your periodically compounding rate of 20%. Put the label “Timestep in years” and in the cell...

If possible, calculate total profits given a price of $80, an average total cost of $30,...

If possible, calculate total profits given a price of $80, an average total cost of $30, and an output of 5. If price is above average total cost, is the firm making a profit or loss and should it operate or shut down? None of the above. Profit and it should operate. Loss and it should shut down to minimize losses. Loss and it should operate to minimize losses. Suppose that a firm is making a profit of $50 million...

Your firm’s CFO is interested in growth in profits, and CMO in growth of revenues. How...

Your firm’s CFO is interested in growth in profits, and CMO in growth of revenues. How do you arrive at the respective sustainable growth rates? Show formulas and explain in brief each input variable.

1A) The difference between a firm's total revenues and total costs when all explicit and implicit...

1A) The difference between a firm's total revenues and total costs when all explicit and implicit costs are included is the firm's: a. opportunity cost of capital. b. accounting profit. c. economic profit. d. long-run average total cost. 1B) The average fixed cost of a firm equal: a. implicit costs divided by output. b. total cost minus variable cost. c. explicit costs divided by output. d. total cost minus total variable cost divided by output.

Subjects