cost estimation in excel spreadsheet

profileTango
Week_5.3_Assignment.xlsx.xlsx

Sheet1

Projected Revenues
# People 10 20 30 40 50 60
Price/Person $600 $600 $600 $600 $600 $600
Total $6,000 $12,000 $18,000 $24,000 $30,000 $36,000
Projected Expenses $500 $500 $500 $500 $500 $500
Room fee $400 $400 $400 $400 $400 $400
Registration Setup $300 $300 $300 $300 $300 $300
Postcard Design $50 $100 $150 $200 $250 $300
Registration Variable cost $240 $480 $720 $960 $1,200 $1,440
Credit card Processing Variable cost $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Postcard Variable Cost $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Postcard mailing & Postage $250 $500 $750 $1,000 $1,250 $1,500
Beverages and Lunch $300 $600 $900 $1,200 $1,500 $1,800
Class Handouts $5,040 $5,880 $6,720 $7,560 $8,400 $9,240
Total
Projected Profits $960 $6,120 $11,280 $16,440 $21,600 $26,760
Value of Personal time/hour $6.40 $40.80 $75.20 $109.60 $144 $178.40
Variable Costs
Registration $50 $100 $150 $200 $250 $300
Variable Costs
Registration $50 $100 $150 $200 $250 $300
Credit Card Processing $240 $480 $720 $960 $1,200 $1,440
Postcards $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Postcards mailing and postage $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Beverages and lunch $250 $500 $750 $1,000 $1,250 $1,500
Class handouts $300 $600 $900 $1,200 $1,500 $1,800
Unit Costs and other info
#postcards made $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
#postcards mailed $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Registartion/Person $5 $5 $5 $5 $5 $5
Credit card fee/person (4%*fee ($600) $24 $24 $24 $24 $24 $24
Postcards (each) $0.40 $0.40 $0.40 $0.40 $0.40 $0.40
Postcard mailing and postage (each) $0.25 $0.25 $0.25 $0.25 $0.25 $0.25
Beverages and lunch/person $25 $25 $25 $25 $25 $25
Class handouts/person $30 $30 $30 $30 $30 $30
Person hours spents 150 150 150 150 150 150