3) Cherillee Toys makes a fiberglass tricycle for kids that iscomposed of three major components: a handlebar-front wheel-pedalassembly, a seat, and frame unit, and rear wheels. The company hasorders for 12,000 of these tricycles. The company does not have theresources available to manufacture everything needed for thecompletion of 12,000 tricycles so it has gathered purchaseinformation for each component.
The following table shows relevant information:
| Requirements | Cost to Manufacture | Cost to Purchase |
Component | Plastic | Time | Space |
Front | 3 | 10 | 2 | 8 | 12 |
Seat/Frame | 4 | Ă‚Â Ă‚Â 6 | 2 | 6 | Ă‚Â Ă‚Â 9 |
Rear wheel (each) | .5 | Ă‚Â Ă‚Â 2 | .1 | 1 | Ă‚Â Ă‚Â 3 |
Ă‚Â Ă‚Â Ă‚Â Ă‚Â Available | 50,000 | 160,000 | 30,000 | | |
Develop a linear programming model to advise the operationsmanager of Cherillee Toys how many of each component should bemanufactured and how many should be purchased in order to provide12,000 fully completed tricycles at the minimum cost.
PLEASE FINISH THIS PROBLEM USING EXCEL
