| ASSUMPTIONS |
|
description/notes |
link/source |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Equipment (bbl system) |
15 |
base assumption |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Brews Per Year |
200 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| bbl brewed per year |
$ 3,000 |
15bbl system brewed 200 times |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Location Size |
4000-6000sqft |
min size |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Estimated Sales |
$ 1,582,700 |
based off estimated 2013 on island beer only sales for roughly 3000 bbls |
income statement |
excludes “other” and “beer products”, “tour”, “door”, “to go”, “shirt”, “event” |
|
|
|
|
|
|
|
| FIXED COSTS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Brew Equipment & Installation |
$ 150,000 |
based off study that Steve sent around |
http://www.academia.edu/8777214/Below_Deck_Brewing_A_Feasibility_Study_of_Opening_a_Microbrewery_2011_Contents |
|
|
|
|
|
| Equipment Depreciation Expense |
$ 30,000 |
5yr straight line depreciation method based on 5yr useful life |
http://www.inc.com/guides/201110/how-to-calculate-depreciation-and-amortization.html |
|
|
|
|
|
|
|
|
| Initial Fixed Costs (furniture and fixtures) |
$ 57,500 |
estimated |
avg of $35K-$80K cite source: |
http://www.franchisechatter.com/2013/08/29/franchise-costs-2013-detailed-estimates-of-world-of-beer-franchise-costs-2013-fdd/ |
| Legal Fees (Annual) |
$ 10,000 |
estimated |
$250/hr x 20 hrs. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Legal Fees (startup cost) |
$ 20,000 |
estimated |
$250/hr x 40 hrs. |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Yearly Insurance |
$ 68,976 |
Keli has citation ($5478 x 12mos) |
Commercial Policy covering O&E, liability, liquor legal, cyber, A&B, property, equipment breakdown, employee dishonesty, auto coverage |
|
|
|
|
| 903 Duval St Key West FL- Buy Option |
$ 4,500,000 |
|
http://keywestlistings.com/idx/mls-119227-903_duval_st_key_west_fl_33040 |
|
|
|
|
|
|
|
|
|
| Licensing Costs (startup cost) |
$ 4,368 |
|
http://www.leg.state.fl.us/Statutes/index.cfm?App_mode=Display_Statute&Search_String=&URL=0500-0599/0563/Sections/0563.06.html |
|
|
|
|
|
$3000 annual Cereal, Malt, Beverage (CMB) license, annual renewal fee-$3000 |
|
|
| Licensing Costs (Annual) |
$ 4,288 |
|
http://www.leg.state.fl.us/Statutes/index.cfm?App_mode=Display_Statute&Search_String=&URL=0500-0599/0563/Sections/0563.06.html |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Miscellaneous |
$ 100,000 |
rennovation, labor for contruction, construction supplies, inspections, certifications |
http://smallbusiness.chron.com/average-startup-costs-bar-18667.html |
|
|
|
|
|
|
|
|
|
| Technology |
$ 5,000 |
budget for basic computer, software, quickbooks, website |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Property Maintenance&Repair |
$ 6,000 |
budget for basic plumbing, electric, carpenter, etc |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Adv. & Marketing |
$ 10,000 |
budget for basic local sponsorships, annual events, promotional items |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Real Estate Tax |
$ 14,047 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| VARIABLE COSTS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Direct Labor |
/bbl |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| full time |
$ 12.00 |
8 employees, as in Nantucket ($45k salary), avg brewer/employee |
http://www.craftbeer.com/brewers_banter/getting-a-boot-in-the-brewhouse-door-2 |
|
|
|
|
|
|
|
|
| part time |
$ 0.61 |
based off existing Cisco spend per barrell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total |
$ 12.61 |
total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Direct Materials |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Addititives |
$ 0.18 |
based off existing Cisco spend per barrell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Grain&Brewing Materials |
$ 28.58 |
based off existing Cisco spend per barrell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Hops |
$ 2.05 |
based off existing Cisco spend per barrell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Yeast |
$ 0.26 |
based off existing Cisco spend per barrell |
|
|
|
|
151.95892 |
|
|
|
|
|
|
|
|
|
|
| Gas (Co2&O2) |
$ 0.25 |
based off existing Cisco spend per barrell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Dextrose |
$ 0.03 |
based off existing Cisco spend per barrell |
|
|
|
|
9862 |
|
|
|
|
|
|
|
|
|
|
| Corks |
$ 0.55 |
based off existing Cisco spend per barrell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Growlers |
$ 0.32 |
based off existing Cisco spend per barrell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Manufacturing Overhead |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Cleaning |
$ 0.39 |
based off existing Cisco spend per barrell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Sewerage & Utilities |
$ 3.22 |
based off existing Cisco spend per barrell |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Administrative Overhead |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Taxes (Excise,State&Fed) |
$ 21.88 |
|
|
|
|
903 Duval Street Key West Fl 33040 |
Price $4,500,000 |
http://keywestlistings.com/idx/mls-119227-903_duval_st_key_west_fl_33040 |
$14.88 per barrel- state excise tax, $7 federal-= 21.88 |
| Miscellaneous |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TOTAL VARIABLE COSTS |
$ 83 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| * note: Title- negotiable |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Terms: Seller finance possible |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Get The Answer