Question

In: Accounting

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

Exercise 2: Create a spreadsheet to calculate your projected total costs, total revenues, and total profits...
Exercise 2: 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 $600 per person for a two-day class. You estimate that 30 people will 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....
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...
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...
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...
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.
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT