Applied Technology, Inc. (ATI), produces bicycle frames using two fiberglass materials that improve the strength-to-weight ratio of the frames. The cost of standard grade material is $7.50 per yard and the cost of professional grade material is $9.00 per yard. The standard and professional grade materials contain different amounts of fiberglass, carbon fiber, and Kevlar as shown in the following table: Material Standard Grade Professional Grade Fiberglass 84% 58% Carbon fiber 10% 30% Kevlar 6% 12% ATI signed a contract with a bicycle manufacturer to produce new frames with a carbon fiber content of at least 20% and a Kevlar content of not greater than 10%. To meet the required weight specification, a total of 30 yards of material must be used for each frame. a) Formulate a linear program to determine the number of yards of each grade of fiber- glass material that ATI should use in each frame in order to minimize total cost. Define the decision variables and indicate the purpose of each constraint. b) Use the graphical solution procedure to determine the feasible region. What are the coordinates of each extreme point? (you can graph this on outside paper and send a photo). c) Compute the total cost at each extreme point. What is the optimal solution. d) Use the Excel solver to find the optimal solution of the problem. Is it the same as your graphical solution?