3. excel jadval protsessorida chiziqli dasturlash masalalarini yechish grafik usuli

Shaxsiy vazifalar

Mustaqil bajarish uchun topshiriq Vazifa.
Kompaniya ikki turdagi mahsulotlarni ishlab chiqaradi: P1 va P2. Xom ashyo zahirasi va har bir turdagi ishlab chiqarishning shartli birligi uchun xom ashyo sarfi normalari 2.2-jadvalda keltirilgan. P1 turdagi mahsulotlarni sotishdan olingan foyda D1 ( pul birliklari), P2 turdagi mahsulotlarni sotishdan olingan foyda esa D2 ( pul birliklari ). Maksimal foyda olish uchun ishlab chiqarishni qanday rejalashtirish kerak?
2.2-jadval.

Variant	Xom ashyo turi	Xom ashyo zaxirasi	birlik uchun iste'mol mahsulotlar			Sotishdan olingan foyda
			P1	P2	D1		D 2
1	1 2 3 4	19 13 15 18	2 2 0 3	3 1 3 0	7		5
2	1 2 3 4	5 8 3 4	1 2 0 1	1 1 1 0	1		3
3	1 2 3 4	8 10 3 7	1 3 0 1	2 1 1 0	1		2

4	1 2 3	100 80 150	1 0 1	0 1 1	1	2
5	1 2 3 4	15 9 15 16	2 1 3 0	3 2 0 4	2	3
6	1 2 3	25 9 21	1 1 3	5 1 1	1	2
7	1 2 3	7 12 15	1 1 3	1 2 1	2	3
8	1 2 3	12 9 1	1 1 1	2 1 4	2	3
9	1 2 3	16 7 12	1 1 2	4 1 1	2	5
10	1 2 3	21 18 24	2 1 3	3 3 2	3	3
11	1 2 3	14 8 3	3 1 0	1 2 1	4	3
12	1 2 3	6 10 24	0 1 3	1 1 1	4	3
13	1 2 3	12 6 10	1 1 2	3 1 1	2	3
14	1 2 3 4	80 80 260 410	0 1 1 4	1 0 3 3	2	3

15	1 2 3 4	20 4 11 10	1 0 1 1	4 1 1 0	3	3
16	1 2 3 4	10 18 5 8	1 1 0 1	1 3 1 0	1	2
17	1 2 3	54 7 5	6 1 1	9 4 0	4	2
18	1 2 3	10 24 28	1 3 1	1 1 4	3	6
19	1 2 3	18 18 8	1 3 1	3 1 1	2	4
yigirma	bitta 2 3	yigirma sakkiz 6	to'rtta bitta 0	bitta bitta bitta	3	sakkiz
21	bitta 2 3	40 ellik 32	bitta bitta bitta	2 2 0	6	to'rtta
22	bitta 2 3	40 ellik 48	bitta bitta 2	bitta 0 3	to'rtta	sakkiz
23	bitta 2 3	90 300 168	3 0 5	6 0 to'rtta	5	o'n
24	bitta 2 3	100 40 40	2 to'rtta bitta	bitta 2 0	to'rtta	5