Scenario:A bicycle manufacturer produces a racing bicycle and a commuting bicycle. Long-term projections indicate aminimumexpected demand of at least 100 racing and 80 commuting bicycles each day. They can producenot more than200 racing and 170 commuting bicycles daily. To satisfy a shipping contract, they must produce and ship a total ofat least200 bicycles every 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 be made daily to maximize net profits?

2. Solve this problem using the graphical linear programming method discussed in this module. your solution be in Excel.Your solution must show each step:

a. Determine objective function

b. Identify decision variables & constraints in a table; write the inequalities

c. Graph the inequalities; shade the feasible solutions. Is the compound inequality bounded?

d. Identify corner points (intersections)

e. Choose corner point that satisfies the objective