Use Excell QM to solve Problem:

3) Cherillee Toys makes a fiberglass tricycle for kids that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat, and frame unit, and rear wheels. The company has orders for 12,000 of these tricycles. The company does not have the resources available to manufacture everything needed for the completion of 12,000 tricycles so it has gathered purchase information for each component. The following table shows relevant information: Requirements Cost to Cost to Manufacture Plastic Purchase Component Time Space Front 2 - 12 Seat/Frame 2 Rear wheel (each) .5 .1 1 Available 50,000 160,000 30,000 Develop a linear programming model to advise the operations manager of Cherillee Toys how many of each component should be manufactured and how many should be purchased in order to provide 12,000 fully completed tricycles at the minimum cost. * ** **