Bike Frames

Your company produces bike frames using two different material blend, Professional grade and Standard grade. The cost per yard of the blends are $7.50 per yard for Standard and $9.00 per yard for Professional.

The material content (in percent) of your blends are given in the following table:

	Standard	Professional
Fiberglass	0.84	0.58
Carbon Fiber	0.1	0.3
Kevlar	0.06	0.12

You have a new contract to produce bike frames that require 30 total yards of material per frame. The frames must have a carbon fiber content of at least 20%, and a Kevlar content of not more than 10%. How many yards of each material blend (Standard and Professional) should go into each frame in order to minimize cost?

Can you explain show how to set up using solver in excel ?