EMS Space Budget
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
%EDITTABLE{ format="| label | text, 6 | label | label |" changerows="off" }%
| Description | Amount | Formatted | Notes |
| member Dues: | 25 | RIght now we only have one level of members. | |
| Office Space / Sqft | 2.5 | We may have extra offices to sublet. | |
| Shop Space / Sqft | 2.5 | Shop floor space used as work area. | |
| Storage Space / Sqft | 2.5 | Shop floor space used as storage. | |
| Shelf Space / Linerar foot | 2 | Shelf space 2 foot deep by X long. | |
| Storage Space / Cuft | 0.50 | Cuft price for storage bins. | |
| Gallery Space / Sqft | 0 | Vertical back board or shelves used for display. | |
| Meeting room / hour | 50 | Other groups can use our meeting room(s) per hour. | |
| Classes / hour | 15 | Student's cost of an hour of class. | |
| EMS Class % | 0.5 | EMS portion of the gross class income. | |
| Total Office Space | 2900 | Whatever isn't shop space, not used yet. | |
| Total Shop Space | 2500 | Just the shop space, not used yet. | |
| Total Space | 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.
%EDITTABLE{ format="| text, 40 | checkbox, 1, Yes | text, 6, 0 | label, 0, %$nopCALC{%$nopGRANTS2%}% |" changerows="off" }%
| Description | Counted? | Yearly ammount | Monthly contribution |
| U of O grant | 16500 | ||
| Misc grant 1 | Yes | 5789 | |
| misc sponsorship 1 | 500 | ||
| Misc sponsorship 2 | 0 | ||
| 3 | |||
| 4 | |||
| Total Grant money / month |
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.
%EDITTABLE{ format="| text, 40 | checkbox, 1, Yes | text, 2, 0 | text, 2, 0 | label, 0, %$nopCALC{%$nopCLASS1%}% | text, 2, 0 | label, 0, %$nopCALC{%$nopCLASS2%}% |" changerows="off" }%
| Description | Counted? | Days / Mo | Hours / Class | Room Hours / Mo | Enrollment | Student Hours / Mo |
| Intro to blender and 3d modeling | Yes | 4 | 2 | 5 | ||
| Basic modeling in blender | Yes | 3 | 3 | 3 | ||
| Modeling for 3d printers | Yes | 3 | 2 | 4 | ||
| Intro to Inkscape for cnc | Yes | 2 | 1 | 5 | ||
| Intro to gimp | 3 | 3 | 3 | |||
| Intro to the arduino | 4 | 3 | 8 | |||
| Total Student hours / Month |
Pledges:
I didn't add the edit table options to this one because it doesn't seem like this info will change that much. You can just subtract $500 from the bottom line if you want to ignore it.
| Members | Amount | Effective Additional Dues |
| Clif | $100.00 | |
| Mark DW | $100.00 | |
| Bob M | $125.00 | |
| Darrell | $100.00 | |
| Cord | $35.00 | |
| Weston | $75.00 | |
| Greg | $45.00 | |
| Rick | $50.00 | |
| Kevin | $100.00 | |
| Total Pledges |
Budget
Now we come to the bottom line :-)
%EDITTABLE{ format="| Label | text, 3 | text, 6 | label | text, 50 |" changerows="off" }%
| Description | Quantity | Cost Each | Extended | Notes |
| Income | ||||
| Member's Dues | 23 | How many do we have again? | ||
| Pledges | 1 | You can turn these off with a 0 just for grins. | ||
| Grants and Sponsorships | 1 | Same here. | ||
| Office 1 Rental | 0 | Front office with windows is 156.77 Sqft | ||
| Office 2 Rental | 129 | Middle office is 129.38 Sqft | ||
| Office 3 Rental | 0 | Last office is 151.11 Sqft | ||
| Meeting Room Hours | 2 | |||
| Class student hours | Be carfull not to double schedule our one room. | |||
| Personal Shop Work Space | 100 | |||
| Personal Shop Storage Space | 40 | |||
| Shelf space by foot | 40 | |||
| Shelf space Cubic foot | 0 | |||
| Gallery Display Sqft | 0 | |||
| Total Income | ||||
| Expenses | ||||
| Rent | 1 | $1400 | ||
| Building Maintenance | 1 | 0 | On going not one time. | |
| Property Tax | 1 | 0 | ||
| Insurance | 1 | $50 | ||
| EWEB | 1 | $166 | ||
| NWN Gas | 1 | $233 | ||
| Trash pickup | 0 | $32.60 | Sanipac: 1 yard $32.60 /mo, 1.5 yard $46.60 / mo | |
| Internet | 1 | $50 | ||
| Accountant / CPA | 0 | 0 | ||
| Teachers? | 0 | 0 | Probably handle this as a split of class proffits. | |
| Cleaning / Janitorial | 0 | 0 | ||
| Tooling Consumables | 1 | 0 | Drill Bits, Sand paper etc... | |
| Cleaning Consumables | 0 | $25.00 | Soap, Paper towells, garbage bags. | |
| Total Expenses | ||||
| Net | ' |
Notes:
- See Business Model Ideas for more info.
- Info on Spreadsheet Plugin: http://foswiki.org/Extensions/SpreadSheetPlugin
- Info on Edit Table plugin: http://foswiki.org/Extensions/EditTablePlugin
-- Main.ClifCox - 02 Oct 2013