A bicycle manufacturer makes mountain bikes and road bikes. Each mountain bike requires 2 units of steel and 6 units of aluminum in its frame and 12 special components for the hub, sprocket, and gear assembly. Each road bike requires 5 units each of steel and aluminum for its frame and 5 of the special components. Shipments are such that steel is limited to 100 units per day, aluminum is limited to 120 units per day, and the special components are limited to 180 units per day. If the profits are $300 on each mountain bike and $200 on each road bike, how many of each should be produced to yield the maximum profit? What is the maximum profit?
Use Excel to solve each linear programming problem.