Prezi

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in the manual

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Financial Analysis

No description
by Cody Rice on 24 April 2013

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Financial Analysis

Financial Analysis Lady Light Brewery Equipment GRAIN HANDLING
Hobart 200 Lb grain scale
More Beer Ultimill manufactured in 2011. Explosion proof 110v electric motor, stainless steel frame and hopper

BREW HOUSE
7 BBL Custom Hot Liquor Tank - 10 KW electric element w/ analog thermometer and analog temperature control
5 BBL McCann Fabrication Inc. Stainless Steel Mash/Lauter Tun with covers, sparge arm, false bottom & sanitary fittings.
4 BBL Price Schonstrom Inc. Electric Brew Kettle/Whirlpool: 9KW/3-PHASE, copper exterior/stainless interior, top man-way, vent pipe, exhaust fan, dual outlet (standpipe and bottom), large particle filter, sample spigot, & CIP arm
Price Schonstrom Inc. 3 stage Brewery Control Panel
Vicarb 31-plate Heat Exchanger w/ sanitary tri-clamp fittings, analog thermometer, pressure gauge and sight glass - (skid mounted w/ hot wort pump)
Misc. Stainless Steel sanitary tri-clamps, ball valves, butterfly valves, piping, hose ends, CIP spray balls and fittings
Transfer hoses
Buckets of varying sizes

PUMPS
Baldor 3/4 HP Pump
Baldor 1 HP Pump
Thomsen 1 HP? Hot Wort Pump Equipment Cost Brewing Equipment - $100,000
Depreciate over 5 years - $20,000
Shipping - $1,800
Assembly - $1,000

Total - $22,800 Supplies Planned production of 10,000 barrels a year
10,000/12= 834 barrels
1 barrel = 2 kegs
1 keg = 165 bottles
Half production sold as kegs and half bottles
Ingredients: hops, malted barley, yeast
Ingredients per barrel - $70 * 10,000 = $70,000
Kegs (will be returned) - $25 * 834 = $20,850
Bottles - (834*165)/2376*$586=$33,940*12 = $407,280
Labels - $14,135 * 12 = $169,620
Office supplies estimate - $1,200

Total - $668,950 Brewery 1,940 SF warehouse in Norfolk
Rent - $1,290 per month
Estimate utilities - $210 per month

Total - $1,500 * 12 = $18,000 Marketing Items to use as promotion:
T-shirts
Wristbands
Koozies
Bottle openers
Banners
Advertising budget - $1,000 per month

Total - $1,000 * 12 = $12,000 Licenses Beer On and Off Premises and Keg - $365
Gourmet Brewing Shop - $230
Brewery and Keg - $2,215
Retail Off Premises Brewery and Keg - $185
Beer Bottler - $1,430
Beer Shipper - $95
Application fee per license - $65 * 6 = $390

Total - $4,910 Salaries An estimated 100,000 jobs in the United States are provided by Craft Brewers.

Brewers Association estimated salaries.
Brewmaster : $30,000-$50,000(Annually)
Assistant Brewers : $25,000-$35,000 (Annually)

Brew master - $45,000 (Annually)
Cody - $25,000 (Annually)
Brian - $25,000 (Annually)
Mohsin - $25,000 (Annually)
Sam and Chelsea will not work at the brewery and only receive the benefits from their ownership

Total - $120,000 Break Even Analysis Fixed cost - $147,710
Variable cost - $698,950
Cost per bottle - $1.33
Break Even Analysis -
(147710+698950)/1.33 = 636,587 bottles per year
Monthly break even - 53,049 bottles
Kegs per month - 161
6 packs per month - 4,421 Feasibility Funding from group - $10,000 per person
Each person holds 16% stake
Brew master hire condition:
Fund $15,000 for 20% stake

Cash available - $65,000

Funding from bank:
846660-65000 = $781,660 for first year
while earning a negative profit

NOT FEASIBLE
FERMENTATION
2- 4BBL Price Schonstrom Inc. Fermentation Vessels: copper exterior/stainless interior, top man-way, dish bottom, dual outlet (standpipe and bottom), stainless CIP/racking arms, sanitary tri-clamp fittings, pressure relief valves, single zone cooling jacket & individual digital temperature control
8 - 8BBL/300 FDA approved, HDPE cone bottom tanks
10 X 10 +/- Walk In Cooler
10 X 15 +/- Walk In Cooler
Foxx Equipment Glycol Chiller w/ dual zone pumps
Black Maxx 5 gallon stir plate

CONDITIONING & FILTRATION
4 BBL Price Schonstrom Inc. Conditioning Tanks: copper exterior/stainless interior, top man-way, dish bottom, stainless CIP/racking arms, sanitary tri-clamp fittings, pressure gauges, pressure relief valves, single zone cooling jacket & individual digital temperature controls
2 Tri-clamp carbonation stones
10" Stainless sanitary housing cartridge filter
12”x12” vertical plate and frame Filter
G.W. Kent single head manual keg filler

PACKAGING
4 Head counter-pressure, sparkling, bottle filler
Folding Tables
Zambelli Mfg. Pneumatic Crown Capper/Corker fully
Primera AP360 Pressure sensitive label applicator
2 station stainless steel manual Keg Washer
Tape Guns

MATERIALS HANDLING
Crown 3000 LB electric forklift w/ charging unit
Eagle Hydraulic pallet jack
2 wheel keg dolly/hand truck Profit Potential Target market -
Women over age 21 in Norfolk area - 82,000
Capture 64% of market (% people that drink) - 52,480
Profit Potential Analysis
(52480-53049bottles)*$1.33 = $-756.60 per month
See the full transcript