Could someone help with the formulas and solution for the question and shown cells: 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.

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. Set up for Solver and solve it.

D H L 3 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. Cost to Cost to Purchase Plastic Make o co vou awn Requirements Time 10 6 Space 2 Component Front Seat/Frame Rear wheel (each) 3 $12.00 $9.00 4 $8.00 $6.00 $1.00 2 0.5 2 0.1 $3.00 Available 50000 160000 30000 10 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. Set up for Solver and solve it. 11 12 13 14 Formulation Variable Description 15 Objective Function Subject to: 16 17 18 19 20 21 22 23 24 25 26