QUESTION 4

1. Use the Brewery.xlsx file to answer the following question: What percentage of profit does Lager account for among the three types of beer? (rounded to 2 decimals)

   		26.13%
   		52.00%
   		25.68%
   		14.25%
   		13.76%

QUESTION 5

1. Use the Brewery.xlsx file to answer the following question: Which type of beer accounts for the most total profit?

   		Cider
   		Lager
   		Ale
   		IPA
   		Pilsner

QUESTION 6

1. Use the Brewery.xlsx file to answer the following question: Across all four locations, what percentage of total profit is made in MA?

   		75.69%
   		84.00%
   		45.26%
   		74.56%
   		84.02%

1 Type 1 ABVX B Product Name 2 Bruin 3 Hamburgler 4 Evil Squid 5 Gear Shift 6 Extended Puppy 7 Former Weasel 8 Flaming Dragon 9 Hannibal 10 Half Lord 11 Emerald Scourge 12 Ruby Persian 13 Lotus 14 Sheep Mojo 15 Subatomic Glove 16 Mud Guard 17 Rearview 18 Aching Brown 19 Flyin Squirrel 20 Valentine 21 Count Chocohol 22 Joyous Jacques 23 Black Manatee 24 Gnu Breath 25 Aardvark Boson 26 Red Salty Hoser Style Pilsner Bavarian Lager Bock Dark Lager Vienna lager Marzen Cider Cider Amber Ale IPA Red Ale American Pale Ale Hefeweisen Porter Saison Stout Brown Ale IPA Golden Ale Stout Lambic Imperial Stout Barleywine Double IPA Tripel P Lager Lager Lager Lager Lager Lager Cider Cider Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale E Unit Cost $1.05 $1.15 $3.00 $3.00 $2.50 $3.75 $2.00 $2.50 $1.05 $1.15 $1.15 $1.15 $2.00 $2.50 $2.50 $2.00 $2.00 $3.00 $2.50 $4.00 $4.25 $11.00 $25.00 $25.00 $35.00 F Unit Price $5.00 $5.50 $7.50 $6.00 $5.50 $8.00 $6.00 $5.50 $5.00 $5.50 $5.50 $5.50 $7.00 $8.00 $8.00 $6.00 $5.50 $7.50 $5.50 $9.00 $11.00 $30.00 $110.00 $125.00 $150.00 4% 6% 7% 5% 5% 5% 6% 5% 6% 5% 5% 6% 5% 7% 7% 6% 5% 7% 6% H. Unit Size (fl oz) 16 16 16 16 16 16 16 16 16 16 16 16 22 16 16 16 16 16 16 16 12 10 10 7% 11% 15% 11% 12% 1 Type 1 ABVX B Product Name 2 Bruin 3 Hamburgler 4 Evil Squid 5 Gear Shift 6 Extended Puppy 7 Former Weasel 8 Flaming Dragon 9 Hannibal 10 Half Lord 11 Emerald Scourge 12 Ruby Persian 13 Lotus 14 Sheep Mojo 15 Subatomic Glove 16 Mud Guard 17 Rearview 18 Aching Brown 19 Flyin Squirrel 20 Valentine 21 Count Chocohol 22 Joyous Jacques 23 Black Manatee 24 Gnu Breath 25 Aardvark Boson 26 Red Salty Hoser Style Pilsner Bavarian Lager Bock Dark Lager Vienna lager Marzen Cider Cider Amber Ale IPA Red Ale American Pale Ale Hefeweisen Porter Saison Stout Brown Ale IPA Golden Ale Stout Lambic Imperial Stout Barleywine Double IPA Tripel P Lager Lager Lager Lager Lager Lager Cider Cider Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale Ale E Unit Cost $1.05 $1.15 $3.00 $3.00 $2.50 $3.75 $2.00 $2.50 $1.05 $1.15 $1.15 $1.15 $2.00 $2.50 $2.50 $2.00 $2.00 $3.00 $2.50 $4.00 $4.25 $11.00 $25.00 $25.00 $35.00 F Unit Price $5.00 $5.50 $7.50 $6.00 $5.50 $8.00 $6.00 $5.50 $5.00 $5.50 $5.50 $5.50 $7.00 $8.00 $8.00 $6.00 $5.50 $7.50 $5.50 $9.00 $11.00 $30.00 $110.00 $125.00 $150.00 4% 6% 7% 5% 5% 5% 6% 5% 6% 5% 5% 6% 5% 7% 7% 6% 5% 7% 6% H. Unit Size (fl oz) 16 16 16 16 16 16 16 16 16 16 16 16 22 16 16 16 16 16 16 16 12 10 10 7% 11% 15% 11% 12%