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. Please note that each tricycle requires two rear wheels, the front wheel is included in the front wheel-pedal assembly. The company has orders for 15,000 of these tricycles. Current schedules yield the following information: component plastic time space cost to manufacture cost to purchase front 2 11 2 7 11 seat/frame 3 7 2 6 10 rear 0.5 2.5 0.2 2 5 available 60000 180000 35000     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 15,000 fully completed tricycles at the minimum cost. Use Excel's Solver to obtain the optimal solution. How many of each component should be manufactured vs. purchased? What is the overall cost? What are the binding constraints? Upload a screenshot of the spreadsheet that you used to solve this problem.

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. Please note that each tricycle requires two rear wheels, the front wheel is included in the front wheel-pedal assembly. The company has orders for 15,000 of these tricycles. Current schedules yield the following information:

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 15,000 fully completed tricycles at the minimum cost.

Use Excel's Solver to obtain the optimal solution. How many of each component should be manufactured vs. purchased? What is the overall cost? What are the binding constraints?

Upload a screenshot of the spreadsheet that you used to solve this problem.