Insert Draw Page Layout Formulas Data Review View Developer A 7 clear GO Clear Reapply Advanced rnal 18. Connections Properties Edit Links fx Refresh Stocks Geography ZU Sort Filter Text to Columns X CD Tots Toys makes a plastic tricycle 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. Current schedules yield the following information. Plastic Requirements Time 10 Space Component Front Seat/Frame Rear wheel (each) Available Cost to Make $8.00 $6.00 $1.00 Cost to Purchase $12.00 $9.00 $3.00 0.5 50000 160000 0.1 30000 The company obviously does not have the resources available to manufacture everything needed for the completion of 12000 tricycles so has gathered purchase information for each component. Develop a linear programming model to tell the company how many of each component should be manufactured and how many should be purchased in order to provide 12000 fully completed tricycles at the minimum cost. Formulate it for Solver and find the optimal solution, To make To purchase Front Seat/Frame Rear wheel Front Seat/Frame Rear wheel 12000 6000 Obj fun coeff Obj fun MIN 102000 Insert Draw Page Layout Formulas Data Review View Developer A 7 clear GO Clear Reapply Advanced rnal 18. Connections Properties Edit Links fx Refresh Stocks Geography ZU Sort Filter Text to Columns X CD Tots Toys makes a plastic tricycle 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. Current schedules yield the following information. Plastic Requirements Time 10 Space Component Front Seat/Frame Rear wheel (each) Available Cost to Make $8.00 $6.00 $1.00 Cost to Purchase $12.00 $9.00 $3.00 0.5 50000 160000 0.1 30000 The company obviously does not have the resources available to manufacture everything needed for the completion of 12000 tricycles so has gathered purchase information for each component. Develop a linear programming model to tell the company how many of each component should be manufactured and how many should be purchased in order to provide 12000 fully completed tricycles at the minimum cost. Formulate it for Solver and find the optimal solution, To make To purchase Front Seat/Frame Rear wheel Front Seat/Frame Rear wheel 12000 6000 Obj fun coeff Obj fun MIN 102000