writing on exploring local partnerships with local companies

profilesarsoura
projections_project.xlsx
Home>Business & Finance homework help>writing on exploring local partnerships with local companies

3 Year Monthly Projections

Year 1 Year 2 Year 3
Peak Annual Revenue Peak Annual Expenses Profit % Year 1 Year 2 Year 3 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
3D 3D ACCESS $ 783,000 $ 289,600 63% $ 685,125 $ 783,000 $ 783,000 48937.5 48937.5 48937.5 48937.5 48937.5 48937.5 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250 $ 65,250
CLASSES $ 118,440 $ 63,920 46% $ 118,440 $ 118,440 $ 118,440 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870 $ 9,870
EQUIPMENT CERTIFICATION $ 28,800 $ 25,600 11% $ 28,800 $ 28,800 $ 28,800 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400 $ 2,400
Services $ 241,200 $ 120,600 50% $ 75,375 $ 180,900 $ 241,200 $ - 0 $ - 0 $ - 0 $ 5,025 $ 5,025 $ 5,025 $ 10,050 $ 10,050 $ 10,050 $ 10,050 $ 10,050 $ 10,050 $ 15,075 $ 15,075 $ 15,075 $ 15,075 $ 15,075 $ 15,075 $ 15,075 $ 15,075 $ 15,075 $ 15,075 $ 15,075 $ 15,075 $ 20,100 $ 20,100 $ 20,100 $ 20,100 $ 20,100 $ 20,100 $ 20,100 $ 20,100 $ 20,100 $ 20,100 $ 20,100 $ 20,100
Classes PAINT NIGHT $ 22,500 $ 13,750 39% $ 22,500 $ 22,500 $ 22,500 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875 $ 1,875
TEEN CLASSES $ 57,600 $ 28,800 50% $ 57,600 $ 57,600 $ 57,600 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800 $ 4,800
CHILD CLASSES $ 59,220 $ 42,770 28% $ 59,220 $ 59,220 $ 59,220 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935 $ 4,935
EQUIPMENT CERTIFICATION $ 39,600 $ 36,000 9% $ 39,600 $ 39,600 $ 39,600 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300 $ 3,300
MEDIA CLASSES $ 101,520 $ 50,760 50% $ 101,520 $ 101,520 $ 101,520 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460 $ 8,460
TOTAL $ 1,451,880 $ 671,800 54% $ 1,188,180 $ 1,391,580 $ 1,451,880 $ 84,578 $ 84,578 $ 84,578 $ 89,603 $ 89,603 $ 89,603 $ 110,940 $ 110,940 $ 110,940 $ 110,940 $ 110,940 $ 110,940 $ 115,965 $ 115,965 $ 115,965 $ 115,965 $ 115,965 $ 115,965 $ 115,965 $ 115,965 $ 115,965 $ 115,965 $ 115,965 $ 115,965 $ 120,990 $ 120,990 $ 120,990 $ 120,990 $ 120,990 $ 120,990 $ 120,990 $ 120,990 $ 120,990 $ 120,990 $ 120,990 $ 120,990
$ 635,493 $ 749,930 $ 780,080 $ 44,677.50 $ 44,677.50 $ 44,677.50 $ 47,190.00 $ 47,190.00 $ 47,190.00 $ 59,981.67 $ 59,981.67 $ 59,981.67 $ 59,981.67 $ 59,981.67 $ 59,981.67 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 62,494.17 $ 65,006.67 $ 65,006.67 $ 65,006.67 $ 65,006.67 $ 65,006.67 $ 65,006.67 $ 65,006.67 $ 65,006.67 $ 65,006.67 $ 65,006.67 $ 65,006.67 $ 65,006.67
$ 552,687 $ 641,650 $ 671,800 $ 39,900.00 $ 39,900.00 $ 39,900.00 $ 42,412.50 $ 42,412.50 $ 42,412.50 $ 50,958.33 $ 50,958.33 $ 50,958.33 $ 50,958.33 $ 50,958.33 $ 50,958.33 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 53,470.83 $ 55,983.33 $ 55,983.33 $ 55,983.33 $ 55,983.33 $ 55,983.33 $ 55,983.33 $ 55,983.33 $ 55,983.33 $ 55,983.33 $ 55,983.33 $ 55,983.33 $ 55,983.33
Quarter 1 $ 119,700.00 Quarter 2 $ 127,237.50 Quarter 3 $ 152,875.00 Quarter 4 $ 152,875.00 Quarter 1 $ 160,412.50 Quarter 2 $ 160,412.50 Quarter 3 $ 160,412.50 Quarter 4 $ 160,412.50 Quarter 1 $ 167,950.00 Quarter 2 $ 167,950.00 Quarter 3 $ 167,950.00 Quarter 4 $ 167,950.00
Year 1 $ 552,687.50 Year 2 $ 641,650.00 Year 3 $ 671,800.00

Projection Comparison

A - 3D Makerspace Revenue as Projected Today
Price # of members Annual Revenue Sq Ft Sq ft/person 10.6382978723
3D Corporate Monthly Membership $85 200 $204,000 5000 Max Member Access 470
Basic Membership $125 135 $202,500 5000
Student Membership $95 125 $142,500 5000 Annual Revenue $639,000
Day Pass $25 300 $90,000 5000 Annual Expenses $289,600
3D Total $639,000 Annual Profit $349,400
B - Projections Separating Evening & Morning for Basic Memberships
Price # of members Annual Revenue Sq Ft
3D Corporate Monthly Membership $85 200 $204,000 5000 Sq ft/person 10.6382978723
24/7 Premium Membership $150 50 $90,000 5000 Max Member Access 470
Basic Member Evening $100 85 $102,000 5000
Basic Member Morning $100 85 $102,000 5000
Student Membership $95 125 $142,500 5000 Annual Revenue $730,500
Day Pass $25 300 $90,000 5000 Annual Expenses $289,600
3D Total $730,500 Annual Profit $440,900
C- Projections Separating Evening & Morning for Basic & Student Memberships
Price # of members Annual Revenue Sq Ft
3D Corporate Monthly Membership $85 200 $204,000 5000 Sq ft/person 10.6382978723
24/7 Premium Membership $150 50 $90,000 5000 Max Member Access 470
Basic Member Evening $100 85 $102,000 5000
Basic Member Morning $100 85 $102,000 5000
24/7 Student Membership $100 50 $60,000 5000
Student Membership Evening $75 75 $67,500 5000
Student Membership Morning $75 75 $67,500 5000 Annual Revenue $783,000
Day Pass $25 300 $90,000 5000 Annual Expenses $289,600
3D Total $783,000 Annual Profit $493,400
D - Projections for Teen Employed Services (Priced at $30/hour & Profit Margin 50%)
Revenue Expenses
# of Corporate & Basic Members 335 Labor ($10/hr) $ 80,400
# of Hours/Month 2 COGS ($5/hr) $ 40,200 Annual Revenue $241,200
Monthly Hours of Services 670 Annual Expense $ 120,600 Annual Expenses $120,600
Annual Hours of Services 8040 Annual Profit $120,600
Annual Revenue at $30/hr $241,200
Scenario A Scenario B Scenario C Scenario D Expenses
3D ACCESS $ 639,000 $ 730,500 $ 783,000 $ 783,000 $ 289,600
CLASSES $ 118,440 $ 118,440 $ 118,440 $ 118,440 $ 63,920
EQUIPMENT CERTIFICATION $ 28,800 $ 28,800 $ 28,800 $ 28,800 $ 25,600
PAINT NIGHT $ 22,500 $ 22,500 $ 22,500 $ 22,500 $ 13,750
TEEN CLASSES $ 57,600 $ 57,600 $ 57,600 $ 57,600 $ 28,800
CHILD CLASSES $ 59,220 $ 59,220 $ 59,220 $ 59,220 $ 42,770
EQUIPMENT CERTIFICATION $ 39,600 $ 39,600 $ 39,600 $ 39,600 $ 36,000
Services $ - 0 $ - 0 $ - 0 $ 241,200 $ 120,600
MEDIA CLASSES $ 101,520 $ 101,520 $ 101,520 $ 101,520 $ 50,760
TOTAL $ 1,066,680 $ 1,158,180 $ 1,210,680 $ 1,451,880 $ 671,800
Expenses $ 551,200 $ 551,200 $ 551,200 $ 671,800
Profit $ 515,480 $ 606,980 $ 659,480 $ 780,080
Revenue Increase 0% 9% 13% 36%
Profit % Increase 0% 18% 28% 51%

Info given

Price # of members Annual Revenue Sq Ft $/sq ft % of total
3D Corporate Monthly Membership $85 200 $204,000 5000 40.8 32% Sq ft/person 10.6382978723
Basic Membership $125 135 $202,500 5000 40.5 32%
Student Membership $95 125 $142,500 5000 28.5 22% 3D Revenue $639,000
Day Pass $25 300 $90,000 5000 18 14% 3D Annual Expenses 289600
3D Total $639,000 100% Profit $349,400
Paint Monthly Membership $40 20 $9,600 2%
Evening Drop In $10 250 $30,000 5%
Classes
3D Classes 45 7 9870
Certification 90 2 2400
Paint Night 30 15 1875
Teen Classes
Toddler Classes
Media Classes

Teen Employment

New Proposed Model
Contract out work for Teen Employees
335 Basic or Corporate Memberships
Each one on average uses 2 hours/month
$30/hour
$15/hour to Teen
$15/hour to AFH
Monthly Annually
Work hours 670 8040
Paid for work $20,100 $241,200
Paid to teens $10,050 $120,600
Paid to AFH $10,050 $120,600