Create a spreadsheet to calculate your projected total costs, total revenues, an
ID: 3728759 • Letter: C
Question
Create a spreadsheet to calculate your projected total costs, total revenues, and total profits forgiving 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 peoples will attend the class, but you want to change this input.
• Your fixed costs include $500 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 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/registration plus 4% of the class fee per person to handle credit card processing; assume that everyone pays by credit card
b) $.40/postcard if you order 5,000 or more;
c) $.35/postcard for mailing and postage
d) $25/person for beverages and lunch
e) $30/person for class handouts
Explanation / Answer
please find below the excel data for the above question for 10,20,30 students
Cost per person $600.00 Room rental $500.00 Setup fees and registration $400.00 Postcard design for advertising $300.00 Labour (hours) 150 Postcards ordered 5000 Mailed postcards 4000 Registration cost per person $5.00 Credit card handling fee 4.% Lunch and beverages $25.00 Class handouts $30.00 Cost per postcard $0.35 Mailing cost per postcard 0.25$ People Revenue Costs Profits Profits Labour p/h 10 $6,000.00 $5,040.00 $960 $6.40/h 20 $12,000 $5,880.00 $6,120.00 $40.80/h 30 $18,000 $6,720 $11,280 $75Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.