{"id":77582,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/key-west-fl-purchase-cost-spreadsheet"},"modified":"2017-08-18T07:19:34","modified_gmt":"2017-08-18T07:19:34","slug":"key-west-fl-purchase-cost-spreadsheet","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/key-west-fl-purchase-cost-spreadsheet\/","title":{"rendered":"key west fl purchase cost spreadsheet"},"content":{"rendered":"

<\/a> <\/p>\n

\n\n\n\n\n\n\n\n\n <\/colgroup>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
ASSUMPTIONS<\/td>\n<\/td>\ndescription\/notes<\/td>\nlink\/source<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Equipment (bbl system)<\/td>\n15<\/td>\nbase assumption<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Brews Per Year<\/td>\n200<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
bbl brewed per year<\/td>\n$ 3,000<\/td>\n15bbl system brewed 200 times<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Location Size<\/td>\n4000-6000sqft<\/td>\nmin size<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Estimated Sales<\/td>\n$ 1,582,700<\/td>\nbased off estimated 2013 on island beer only sales for roughly 3000 bbls<\/td>\nincome statement<\/td>\nexcludes \u201cother\u201d and \u201cbeer products\u201d, \u201ctour\u201d, \u201cdoor\u201d, \u201cto go\u201d, \u201cshirt\u201d, \u201cevent\u201d<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
FIXED COSTS<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Brew Equipment & Installation<\/td>\n$ 150,000<\/td>\nbased off study that Steve sent around<\/td>\nhttp:\/\/www.academia.edu\/8777214\/Below_Deck_Brewing_A_Feasibility_Study_of_Opening_a_Microbrewery_2011_Contents<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Equipment Depreciation Expense<\/td>\n$ 30,000<\/td>\n5yr straight line depreciation method based on 5yr useful life<\/td>\nhttp:\/\/www.inc.com\/guides\/201110\/how-to-calculate-depreciation-and-amortization.html<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Initial Fixed Costs (furniture and fixtures)<\/td>\n$ 57,500<\/td>\nestimated<\/td>\navg of $35K-$80K cite source:<\/td>\nhttp:\/\/www.franchisechatter.com\/2013\/08\/29\/franchise-costs-2013-detailed-estimates-of-world-of-beer-franchise-costs-2013-fdd\/<\/a><\/td>\n<\/tr>\n
Legal Fees (Annual)<\/td>\n$ 10,000<\/td>\nestimated<\/td>\n$250\/hr x 20 hrs.<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Legal Fees (startup cost)<\/td>\n$ 20,000<\/td>\nestimated<\/td>\n$250\/hr x 40 hrs.<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Yearly Insurance<\/td>\n$ 68,976<\/td>\nKeli has citation ($5478 x 12mos)<\/td>\nCommercial Policy covering O&E, liability, liquor legal, cyber, A&B, property, equipment breakdown, employee dishonesty, auto coverage<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
903 Duval St Key West FL- Buy Option<\/td>\n$ 4,500,000<\/td>\n<\/td>\nhttp:\/\/keywestlistings.com\/idx\/mls-119227-903_duval_st_key_west_fl_33040<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Licensing Costs (startup cost)<\/td>\n$ 4,368<\/td>\n<\/td>\nhttp:\/\/www.leg.state.fl.us\/Statutes\/index.cfm?App_mode=Display_Statute&Search_String=&URL=0500-0599\/0563\/Sections\/0563.06.html<\/a><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n$3000 annual Cereal, Malt, Beverage (CMB) license, annual renewal fee-$3000<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Licensing Costs (Annual)<\/td>\n$ 4,288<\/td>\n<\/td>\nhttp:\/\/www.leg.state.fl.us\/Statutes\/index.cfm?App_mode=Display_Statute&Search_String=&URL=0500-0599\/0563\/Sections\/0563.06.html<\/a><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Miscellaneous<\/td>\n$ 100,000<\/td>\nrennovation, labor for contruction, construction supplies, inspections, certifications<\/td>\nhttp:\/\/smallbusiness.chron.com\/average-startup-costs-bar-18667.html<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Technology<\/td>\n$ 5,000<\/td>\nbudget for basic computer, software, quickbooks, website<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Property Maintenance&Repair<\/td>\n$ 6,000<\/td>\nbudget for basic plumbing, electric, carpenter, etc<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Adv. & Marketing<\/td>\n$ 10,000<\/td>\nbudget for basic local sponsorships, annual events, promotional items<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Real Estate Tax<\/td>\n$ 14,047<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
VARIABLE COSTS<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Direct Labor<\/td>\n\/bbl<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
full time<\/td>\n$ 12.00<\/td>\n8 employees, as in Nantucket ($45k salary), avg brewer\/employee<\/td>\nhttp:\/\/www.craftbeer.com\/brewers_banter\/getting-a-boot-in-the-brewhouse-door-2<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
part time<\/td>\n$ 0.61<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Total<\/td>\n$ 12.61<\/td>\ntotal<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Direct Materials<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Addititives<\/td>\n$ 0.18<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Grain&Brewing Materials<\/td>\n$ 28.58<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Hops<\/td>\n$ 2.05<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Yeast<\/td>\n$ 0.26<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n151.95892<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Gas (Co2&O2)<\/td>\n$ 0.25<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Dextrose<\/td>\n$ 0.03<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n9862<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Corks<\/td>\n$ 0.55<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Growlers<\/td>\n$ 0.32<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Manufacturing Overhead<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Cleaning<\/td>\n$ 0.39<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Sewerage & Utilities<\/td>\n$ 3.22<\/td>\nbased off existing Cisco spend per barrell<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Administrative Overhead<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Taxes (Excise,State&Fed)<\/td>\n$ 21.88<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n903 Duval Street Key West Fl 33040<\/td>\nPrice $4,500,000<\/td>\nhttp:\/\/keywestlistings.com\/idx\/mls-119227-903_duval_st_key_west_fl_33040<\/td>\n$14.88 per barrel- state excise tax, $7 federal-= 21.88<\/td>\n<\/tr>\n
Miscellaneous<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
TOTAL VARIABLE COSTS<\/td>\n$ 83<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
* note: Title- negotiable<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Terms: Seller finance possible<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/fieldset>\n
<\/div>\n
\nAttachments<\/legend>\n
\n key_west_fl_purchase_cost_spreadsheet.xlsx<\/a> (15.6 KB)\n <\/div>\n
\n Click here to have a similar paper done for you by one of our writers within the set deadline at a discounted<\/a>\u2026<\/i>\n <\/div>\n<\/fieldset>\n","protected":false},"excerpt":{"rendered":"

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 Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-77582","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/77582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=77582"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/77582\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=77582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=77582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=77582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}