Details of this Paper

key west fl purchase cost spreadsheet

Description

solution


Question

Question;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

 

Paper#39395 | Written in 18-Jul-2015

Price : $27
SiteLock