Below, you will find a series of exercises on linear programming. For each exercise, you are asked to:. Solve problems using the Excel Solver tool.1. A merchant goes to the market to buy oranges. It has 2,000 and its van can fit 1400 kg. On the market they have type A oranges at 1.10 and type B oranges at 1.60. He will be able to sell them at 1.20 for type A and at 1.75 for type B, and he wonders how many kilograms of each type he should buy to make the profits as high as possible.

	Cantidad	Mximo		Aos hasta el	10+ aos?		Bueno o peor?
Bono	invertida	25.0%	Rendimiento	vencimiento	(1, si, 0-no)	Valoracin	(1-yes, 0-no)
ACME Chemical	$0	$187,500	8.65%	11	1	1-Excellent	0
DynaStar	$0	$187,500	9.50%	10	1	3-Good	1
Eagle Vision	$0	$187,500	10.00%	6	0	4-Fair	1
MicroModeling	$0	$187,500	8.75%	10	1	1-Excellent	0
OptiPro	$0	$187,500	9.25%	7	0	3-Good	1
Sabre Systems	$0	$187,500	9.00%	13	1	2-Very Good	0
Total invertido:	$0	Total:	$0	Total:	$0	Total:	$0
Total disponible:	$750,000			Permitido:	$375,000	Permitido:	$262,500