Difference: SpaceBudgetPublic1 (r3 vs. r2)

EMS Space Budget Copy 1

You can play around with this spreadsheet by clicking the edit buttons at the bottom of each table. Of if you're adventurous, you can click edit for the whole page and change the underlying calculations.

Our proposed revenue streams and rates

DescriptionAmountFormattedNotes
member Dues: 25 $25.00 RIght now we only have one level of members.
Office Space / Sqft 2.5 $2.50 We may have extra offices to sublet.
Shop Space / Sqft 2.5 $2.50 Shop floor space used as work area.
Storage Space / Sqft 2.5 $2.50 Shop floor space used as storage.
Shelf Space / Linerar foot 2 $2.00 Shelf space 2 foot deep by X long.
Storage Space / Cuft 0.50 $0.50 Cuft price for storage bins.
Gallery Space / Sqft 0 $0.00 Vertical back board or shelves used for display.
Meeting room / hour 50 $50.00 Other groups can use our meeting room(s) per hour.
Classes / hour 15 $15.00 Student's cost of an hour of class.
EMS Class % 0.5 50% EMS portion of the gross class income.
Total Office Space 2900 2900 Whatever isn't shop space, not used yet.
Total Shop Space 2500 2500 Just the shop space, not used yet.
Total Space   5400 This would be used for cost / Sqft calcs.

Grants and Sponsorships Worksheet

Here you can set the income from grants and sponsorships. If you check the Counted? box then that row will end up in the total.

DescriptionCounted?Yearly ammountMonthly contribution
U of O grant   16500 0
Misc grant 1   5789 0
misc sponsorship 1   500 0
Misc sponsorship 2   0 0
    3 0
    4 0
Total Grant money / month     $0

Classes Worksheet

Here you can play around with income from classes. If you check the Counted? box then that row will end up in the total hours.We may want different prices for each class, that's not hard to do.

DescriptionCounted?Days / MoHours / ClassRoom Hours / MoEnrollmentStudent Hours / Mo
Intro to blender and 3d modeling Yes 4 2 8 5 40
Basic modeling in blender Yes 3 3 9 3 27
Modeling for 3d printers Yes 3 2 6 4 24
Intro to Inkscape for cnc Yes 2 1 2 5 10
Intro to gimp   3 3 9 3 0
Intro to the arduino   4 3 12 8 0
Total Student hours / Month           101

Budget

Now we come to the bottom line smile

DescriptionQuantityCost EachExtendedNotes
Income        
Member's Dues 23 $25.00 $575.00  
Pledges 1 $500 $500.00 $500.00 You can turn these off with a 0 just for grins.
Office 1 Rental Grants and Sponsorships 0 1 $2.50 $0.00 $0.00 Front office Same here. with windows is 156.77 Sqft
Office 2 1 Rental 129 0 $2.50 $322.50 $0.00 Middle Front office with windows is 129.38 156.77 Sqft
Office 3 2 Rental 0 129 $2.50 $0.00 $322.50 Last Middle office is 151.11 129.38 Sqft
Meeting Room Hours Office 3 Rental 2 0 $50.00 $2.50 $100.00 $0.00   Last office is 151.11 Sqft
Class student hours Meeting Room Hours 101 2 $15.00 $50.00 757.5 $100.00 Be   carfull not to double schedule our one room.
Personal Shop Work Class student hours Space 100 101 $2.50 $15.00 $250.00 $757.50   Be carfull not to double schedule our one room.
Personal Shop Storage Work Space 40 100 $2.50 $100.00 $250.00  
Shelf space by foot Personal Shop Storage Space 40 $2.00 $2.50 $80.00 $100.00  
Shelf space Cubic by foot 0 40 $0.50 $2.00 $0.00 $80.00  
Gallery Display Sqft Shelf space Cubic foot 0 $0.00 $0.50 $0.00  
Total Income Gallery Display Sqft   0   $0.00 $2,685.00 $0.00  
  Total Income       $2,685.00  
Expenses          
Rent Expenses 1   $1400   $1400.00    
Building Rent Maintenance 1 0 $1400.00 $0.00 $1400.00 On   going not one time.
Property Tax Building Maintenance 1 0 $0.00   On going not one time.
Insurance Property Tax 1 $50 0 $50.00 $0.00  
EWEB Insurance 1 $166 $50.00 $166.00 $50.00  
NWN EWEB Gas 1 $233 $166.00 $233.00 $166.00  
Trash pickup NWN Gas 0 1 $32.60 $233.00 $0.00 $233.00 Sanipac:   1 yard $32.60 /mo, 1.5 yard $46.60 / mo
Internet Trash pickup 1 0 $50 $32.60 $50.00 $0.00   Sanipac: 1 yard $32.60 /mo, 1.5 yard $46.60 / mo
Accountant Internet / CPA 0 1 0 $50.00 $0.00 $50.00  
Teachers? Accountant / CPA 0 0 $0.00 Probably   handle this as a split of class proffits.
Cleaning Teachers? / Janitorial 0 0 $0.00   Probably handle this as a split of class proffits.
Tooling Consumables Cleaning / Janitorial 1 0 0 $0.00 Drill   Bits, Sand paper etc...
Cleaning Tooling Consumables 0 1 $25.00 0 $0.00 Soap, Paper towells, garbage bags. Drill Bits, Sand paper etc...
Total Expenses Cleaning Consumables   0   $25.00 $1,899.00 $0.00   Soap, Paper towells, garbage bags.
Net Total Expenses     $786.00 $1,899.00  
Net     $786.00  

Notes:

-- ClifCox- 02 Oct 2013 15 Jan 2014

View topic | View difference side by side | History: r4 < r3 < r2 < r1 | More topic actions
 
This site is powered by FoswikiCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Eugene Maker Space Wiki? Send feedback