1. C-town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $15 per barrel while Burning River sells for $5 per barrel. Producing a barrel of Expansion Draft takes 8 pounds of corn and 7 pounds of hops. Producing a barrel of Burning River requires 4 pounds of corn, 12 pounds of rice, and 6 pounds of hops. The brewery has 770 pounds of corn, 410 pounds of rice, and 350 pounds of hops.

Assuming a linear relationship, use the Excel Solver to determine the optimal mix of Expansion Draft and Burning River that maximizes C-town's revenue. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.)

Decision for expansion draft ____

Decision for burning river _____

Total sales _____

b)

Corn (Resources Used)

Rice

Hops

2.A company has a factory that is designed so that it is most efficient (average unit cost is minimized) when producing 28,500 units of output each month. However, it has an absolute maximum output capability of 35,000 units per month, and can produce as little as 7,000 units per month without corporate headquarters shifting production to another plant. If the factory produces 22,120 units in October, what is the capacity utilization rate in October for this factory? (Round your answer to 1 decimal place.)

Capacity utilization rate ____ %