Solved by verified expert :ASSUMPTIONSEquipment (bbl system)Brews Per Yearbbl brewed per yearLocation SizeEstimated SalesFIXED COSTSBrew Equipment & InstallationEquipment Depreciation Expense15200$3,0004000-6000sqft$1,582,700$57,500$10,000$20,000$68,976$4,500,000Licensing Costs (startup cost)Licensing Costs (Annual)MiscellaneousTechnologyProperty Maintenance&RepairAdv. & MarketingReal Estate Tax* note: Title- negotiableTerms: Seller finance possiblelink/source15bbl system brewed 200 timesmin sizebased off estimated 2013 on island beer only sales for roughly 3000 bbls$150,000 based off study that Steve sent around$30,000 5yr straight line depreciation method based on 5yr useful lifeInitial Fixed Costs (furniture and fixtures)Legal Fees (Annual)Legal Fees (startup cost)Yearly Insurance903 Duval St Key West FL- Buy OptionVARIABLE COSTSDirect Laborfull timepart timeTotalDirect MaterialsAddititivesGrain&Brewing MaterialsHopsYeastGas (Co2&O2)DextroseCorksGrowlersManufacturing OverheadCleaningSewerage & UtilitiesAdministrative OverheadTaxes (Excise,State&Fed)MiscellaneousTOTAL VARIABLE COSTSdescription/notesbase assumption$4,368$4,288$100,000$5,000$6,000$10,000$14,047income statementexcludes "other" and "beer products", "tour", "door", "to go", "shirt", "event"http://www.academia.edu/8777214/Below_Deck_Brewing_A_Feasibility_Study_of_Opening_a_Microbrewery_2011_Contentshttp://www.inc.com/guides/201110/how-to-calculate-depreciation-and-amortization.htmlhttp://www.franchisechatter.com/2013/08/29/franchise-costs-2013-detailed-estimates-of-world-of-beer-franchise-costs-2013-fdd/avg of $35K-$80K cite source:$250/hr x 20 hrs.$250/hr x 40 hrs.Commercial Policy covering O&E, liability, liquor legal, cyber, A&B, property, equipment breakdown, employee dishonesty, auto coveragehttp://keywestlistings.com/idx/mls-119227-903_duval_st_key_west_fl_33040http://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-$3000estimatedestimatedestimatedKeli has citation ($5478 x 12mos)http://www.leg.state.fl.us/Statutes/index.cfm?App_mode=Display_Statute&Search_String=&URL=0500-0599/0563/Sections/0563.06.htmlrennovation, labor for contruction, construction supplies, inspections, certificationshttp://smallbusiness.chron.com/average-startup-costs-bar-18667.htmlbudget for basic computer, software, quickbooks, websitebudget for basic plumbing, electric, carpenter, etcbudget for basic local sponsorships, annual events, promotional items/bbl$12.00 8 employees, as in Nantucket ($45k salary), avg brewer/employee$0.61 based off existing Cisco spend per barrell$12.61 total$0.18$28.58$2.05$0.26$0.25$0.03$0.55$0.32based off existing Cisco spend per barrellhttp://www.craftbeer.com/brewers_banter/getting-a-boot-in-the-brewhouse-door-2151.958929862$0.39 based off existing Cisco spend per barrell$3.22 based off existing Cisco spend per barrell$21.88$83903 Duval Street Key West Fl 33040Price $4,500,000http://keywestlistings.com/idx/mls-119227-903_duval_st_key_west_fl_33040$14.88 per barrel- state excise tax, $7 federal-= 21.88
