Applied technology, Inc. (ATI), produces bicycle frames using two fiberglass materials that improve the strength to weight ratio for the frames. The cost of the standard grade material is $7.50 per yard and the cost of the professional grade material is $9 per yard. The standard and professional grade materials contain different amounts of fiberglass, carbon fiber, and Kevlar as shown in the following table:
Standard Grade Professional Grade
Fiberglass 84% 58%
Carbon Fiber 10% 30%
Kevlar 6% 12%
ATI signed a contract with a bicycle manufacturer to produce a new frame 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 fiberglass 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 the extreme points?
c. compute the total cost at each extreme point. what is the optimal solution? use the graphical method and excel.