Spreadsheets and number running

Been working on a spreadsheet forecasting start up costs and projected annual expenditures. I'm still missing stuff, but so far initial costs of the equipment for a 4 barrel capacity brewery and TABC permits are $9,737.92. Spreadsheet is still missing shelves, counters, and kegs (~$50 a piece used, $100 new.)

Monthly costs for brewery and cleaning/sanitizing consumables is $704.68 to make 4 barrels (120 gallons, 24 sixtels, or 960 pints) of beer worth $2,160 ($90 a sixtel) when sold to distributors. If HB660 passes, that beer is worth $4,800 (960*$5 a pint) sold for retail to customers.

The big problem seems to be rent for a commercial zoned place. At 4 barrels a month there is only $1,445 left for things like rent, gas, water, and electricity at the brewery only level. Not enough.

Brewpub would a much roomier $4,095 to work with for rent/etc but then you have to have the whole restaurant and club thing surrounding it because Texas law says a beer pub has to sell 51% food.

Kinda crazy. I don't see how there are any craft brewers surviving at all in Texas. You either need a bar in some crazy expensive place like San Antonio or Deep Ellum with the $200k startup costs, or you have to go ginormous brewery just to be able to cover non-brewing expenses. If HB660 doesn't pass in January I don't think I can do this in Texas. Looks like Colorado is in the lead now.