Math Linear Programming
posted by jeremy on .
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 handlebarfront wheelpedal 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/

There are no variables nor constraints stated...yet....
I suspect the variables will be the three assemblies, and the only constraint implied is that the number of these cannot exceed 12000 each.
There is not enought stated to determine what the problem is.