Use Excel SOLVER

A company produces bicycle frames using two fiber glass materials that improve the strength to weight ratio of the frames. The cost of standard grade material is 750 per yard and the cost of professional grade material is 900 per yard. The standard and professional grade materials contain two different amount of fiberglass, carbon fibre and Kevlar as given Standard Grade Professional Grade Fibre Glass 84% 58% Carbon Fibre 10% 30% Kevlar 6% 12% The company signed the contract with a bicycle manufacturer to produce a new frame with a carbon fibre content of at least 20% and Kevlar content of not more than 10%. To meet the required weight specification a total of 30 yards of material must be used for each frame. Formulate an LPP to determine the size of each grade of fiberglass materials that the company should use in each frame to minimize the total cost. If the company is offered professional grade at 800 per yard, will the optimal solution change. What effect will the further lowering of price have on the optimal solution