Scenario: A bicycle manufacturer produces a racing bicycle and a commuting bicycle. Long-term projections indicate a minimum expected demand of at least 100 racing and 80 commuting bicycles each day....

Scenario:A bicycle manufacturer produces a racing bicycle and a commuting bicycle. Long-term projections indicate aminimum expected demand of at least 100 racing and 80 commuting bicycles each day. However, they can produceno more than 200 racing and 170 commuting bicycles each day. To satisfy a shipping contract, they must produce a total ofat least 200 bicycles each day. If each racing bicycle sold results in a $20 loss, but each commuting bicycle produces a $50 profit, how many of each type should they make daily to maximize net profits?

using excel