Question: 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

Use Excell QM to solve Problem:

Use Excell QM to solve Problem: 3) Cherillee Toys

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. * ** **

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!