Description of this paper

key west fl purchase cost spreadsheet




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;;Equipment Depreciation;Expense;$ 30,000;5yr straight line depreciation method based on 5yr useful life;;Initial Fixed Costs;(furniture and fixtures);$ 57,500;estimated;avg of $35K-$80K cite;source;;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;;Licensing Costs (startup;cost);$ 4,368;;$3000 annual Cereal;Malt, Beverage (CMB) license, annual renewal fee-$3000;Licensing Costs (Annual);$ 4,288;;Miscellaneous;$ 100,000;rennovation, labor for contruction, construction supplies;inspections, certifications;;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;;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;;$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