Please complete spreadsheet using exhibits. What is the revenue, variable cost, projected reduction, etc. Thank you

Exhibit 7 U.S. Beer Advertising Expenditures by Medium (in millions of dollars), 2005 Medium 2005 Network television Cable television Spot television Syndicated television Spot radio Network radio $382.3 72.1 144.3 5.5 22.4 1.2 Total Broadcast $627.8 23.2 6.6 Magazines Newspapers Newspaper supplements Outdoor 51.5 Total Print $81.3 TOTAL $709.1 Exhibit 6 Light Beer Market Shares and Dominant Brands 2005 Market Share 49% Light Beer Competitive Market Shares East Central Region Anheuser-Busch Miller Coors Other brands Imports 24% 11% 14% Total Light Beer 100% Leading Domestic Light Beer Brands East Central Region Bud Light Miller Lite Coors Light Natural Light Busch Light Michelob Ultra Milwaukee's Best Light Other domestic brands 2005 Market Share 32.9% 17.8% 14.7% 9.8% 6.4% 56% 3.4% 9.4% Total 100% Leading Imported Light Beer Brands Brand Corona Light Amstel Light Labatt Blue Light Other imported brands 2005 Market Share 57% 26% 15% 2% Total 100% Note: Market share calculations based on wholesale barrel sales. Exhibit 5 Consumption by Type of Beer and by Origin/Packaging, 2005 4. Consumption by Type of Beer Light Beer Premium Beer Popular Imported Premium Superpremium (craft and high-end domestics) EAST CENTRAL REGION 18,744,303 7,326,642 4,351,356 4,462,929 % Total 50.4% 19.7% 11.7% 12.0% 6-year CAGR +4% (4%) (5%) +6% 6.2% +9% 2,305,847 37,191,077 Total Barrels 100.0% B. Consumption by Origin/Packaging EAST CENTRAL REGION % Total Imported Domestic - Packaged Domestic - Draught 4,462,929 29,618,974 3,109,174 12.0% 79.6% 8.4% Total Barrels 37,191,077 100.0% 20691 Mountain Man Brewing Company Bringing the Brand to Light Exhibit 1 Mountain Man 2005 Income Statement Net Revenues COGS Gross Margin SG&A Other Operating Expenses $50,440,000 34,803,600 15,636,400 9,583,600 1,412,320 100.0% 69.0% 31.0% 19.0% 2.8% 9.2% 0.3% Operating Margin Other Income Net Income Before Taxes Provision for Income Taxes 4,640,480 151,320 4,791 800 1,677,130 9.5% 3.3% Net Income After Taxes $ 3,114,670 6,2% Advertising expenses were $1.35 million annually or 2.7% of total revenues Advertising expenses included radio, print, and outdoor advertising sponsorships, as well as costs to produce these media. Exhibit 2 Profile of Beer Drinkers by Beer Type by Key Demographics, 2005 Domestic Light Beer Domestic Premium Beer Mountain Man Lager Gender Male Female 59 81% 32 19 8% 20% Age 21-24 25-34 35-44 45-54 55-64 65+ 20% 24% 22% 14% 23% 23% 2% 15% 19% 32% 19% 13% 12 12% Household Income under $25k $25k-49.9k $50k-74.9k $75k-99.9k $100k+ 25% 21% 16% 24% 16% 24% 21% 15% 23% 20% 27% 25% 15% 13% Source: First two columns of data extracted from Mintel/Simmons NCS 2005 report, figure 67 BRIEFCASES I HARVARD BUSINESS SCHOOL MMB Revenue in 2005 MMB Barrel Production in 2005 Revenue per Barrel Variable Cost per Barrel Projected Reduction in MMB Revenues from shrinking market Projected loss of MM Lager sales from MM Light launch Projected Loss of Contribution Higher Variable Cost of Light Beer Contribution/Barrel of MM Lager Contribution/Barrell of MM Light # Barrels need to recover Loss in Contrib Cost of Advertising MM Light Incremental Costs SG&A for MM Light TOTAL # Barrels light needed to recover MM Light Costs TOTAL # Barrels MM Light to BE in 1 year EAST CENTRAL % Share of Market % Share of EC Beer Consumption (other prem&pop) % Share of EC Beer Consumption % Share of EC Light Beer Consumption % Share of 'Other Brand' Light Beer (minus top) Assume 0.25% Share of EC Light Beer Market to obtain projected sales of MM Light Months to Break Even Exhibit 7 U.S. Beer Advertising Expenditures by Medium (in millions of dollars), 2005 Medium 2005 Network television Cable television Spot television Syndicated television Spot radio Network radio $382.3 72.1 144.3 5.5 22.4 1.2 Total Broadcast $627.8 23.2 6.6 Magazines Newspapers Newspaper supplements Outdoor 51.5 Total Print $81.3 TOTAL $709.1 Exhibit 6 Light Beer Market Shares and Dominant Brands 2005 Market Share 49% Light Beer Competitive Market Shares East Central Region Anheuser-Busch Miller Coors Other brands Imports 24% 11% 14% Total Light Beer 100% Leading Domestic Light Beer Brands East Central Region Bud Light Miller Lite Coors Light Natural Light Busch Light Michelob Ultra Milwaukee's Best Light Other domestic brands 2005 Market Share 32.9% 17.8% 14.7% 9.8% 6.4% 56% 3.4% 9.4% Total 100% Leading Imported Light Beer Brands Brand Corona Light Amstel Light Labatt Blue Light Other imported brands 2005 Market Share 57% 26% 15% 2% Total 100% Note: Market share calculations based on wholesale barrel sales. Exhibit 5 Consumption by Type of Beer and by Origin/Packaging, 2005 4. Consumption by Type of Beer Light Beer Premium Beer Popular Imported Premium Superpremium (craft and high-end domestics) EAST CENTRAL REGION 18,744,303 7,326,642 4,351,356 4,462,929 % Total 50.4% 19.7% 11.7% 12.0% 6-year CAGR +4% (4%) (5%) +6% 6.2% +9% 2,305,847 37,191,077 Total Barrels 100.0% B. Consumption by Origin/Packaging EAST CENTRAL REGION % Total Imported Domestic - Packaged Domestic - Draught 4,462,929 29,618,974 3,109,174 12.0% 79.6% 8.4% Total Barrels 37,191,077 100.0% 20691 Mountain Man Brewing Company Bringing the Brand to Light Exhibit 1 Mountain Man 2005 Income Statement Net Revenues COGS Gross Margin SG&A Other Operating Expenses $50,440,000 34,803,600 15,636,400 9,583,600 1,412,320 100.0% 69.0% 31.0% 19.0% 2.8% 9.2% 0.3% Operating Margin Other Income Net Income Before Taxes Provision for Income Taxes 4,640,480 151,320 4,791 800 1,677,130 9.5% 3.3% Net Income After Taxes $ 3,114,670 6,2% Advertising expenses were $1.35 million annually or 2.7% of total revenues Advertising expenses included radio, print, and outdoor advertising sponsorships, as well as costs to produce these media. Exhibit 2 Profile of Beer Drinkers by Beer Type by Key Demographics, 2005 Domestic Light Beer Domestic Premium Beer Mountain Man Lager Gender Male Female 59 81% 32 19 8% 20% Age 21-24 25-34 35-44 45-54 55-64 65+ 20% 24% 22% 14% 23% 23% 2% 15% 19% 32% 19% 13% 12 12% Household Income under $25k $25k-49.9k $50k-74.9k $75k-99.9k $100k+ 25% 21% 16% 24% 16% 24% 21% 15% 23% 20% 27% 25% 15% 13% Source: First two columns of data extracted from Mintel/Simmons NCS 2005 report, figure 67 BRIEFCASES I HARVARD BUSINESS SCHOOL MMB Revenue in 2005 MMB Barrel Production in 2005 Revenue per Barrel Variable Cost per Barrel Projected Reduction in MMB Revenues from shrinking market Projected loss of MM Lager sales from MM Light launch Projected Loss of Contribution Higher Variable Cost of Light Beer Contribution/Barrel of MM Lager Contribution/Barrell of MM Light # Barrels need to recover Loss in Contrib Cost of Advertising MM Light Incremental Costs SG&A for MM Light TOTAL # Barrels light needed to recover MM Light Costs TOTAL # Barrels MM Light to BE in 1 year EAST CENTRAL % Share of Market % Share of EC Beer Consumption (other prem&pop) % Share of EC Beer Consumption % Share of EC Light Beer Consumption % Share of 'Other Brand' Light Beer (minus top) Assume 0.25% Share of EC Light Beer Market to obtain projected sales of MM Light Months to Break Even