Posted by **jeremy** on Tuesday, February 26, 2008 at 4:23am.

I need to find out the constraints and the variables so that I can input and solve in excel or management scientist. I don't know how to configure this information, can someone help me?

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

As indicated in the table below, the company obviously does not have the resources available to manufacture everything needed for the completion of 12000 tricycles, so it has arranged to purchase additional components, as necessary. 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.

Component Plastic Time Space Man$ Pur.$

Front/ 3 / 10/ 2 / 8/ 12

Frame/ 4 / 6/ 2 / 6/ 9

Wheel/ .5 / 2/ .1 / 1/ 3

AVAILABLE /50,000 /160,000 /30,000/

## Answer this Question

## Related Questions

- linear programming app - write the constraints as linear inequalities and ...
- College Algebra - Maximize the objective function C = 4x + 5y with the ...
- programming - Consider the following input and output: INPUT: (((5 + 1) – (7 – 4...
- business math - It's a lot of words, but short questions. I got most of it, but ...
- Linear Programming - Maximize P = 16x + 80y subject to these constraints: 2x + ...
- Math/Management - FuelMotion is an oil company that owns two oil processing ...
- Linear Programming - Tab 1: Linear Program: 50 points Consider the Linear ...
- Programming Logic - I need help creating a program to compare the value in input...
- math - i need help with patterns and equations i cant find the rule it goes like...
- VBA EXCEL - I was wondering I have 3 input boxes and with one of them I need the...