NR 5 -15 2 100 10 TC TC_isv Kaina Pajamos Ribinės pajamos 0 0 100 -35 280 0.0 280.0 -315.0 25 0.05 98.2516346 -34.90258143 280 6993.8 279.5 50 0.1 96.51280769 -34.62127156 280 13975.0 279.0 75 0.15 94.79227807 -34.17377416 279 20943.8 278.5 100 0.2 93.09788058 -33.57929988 279 27900.0 278.0 125 0.25 91.4364575 -32.85829186 279 34843.8 277.5 150 0.3 89.81380427 -32.0321323 279 41775.0 277.0 175 0.35 88.23463014 -31.12283062 278 48693.8 276.5 200 0.4 86.70253509 -30.15269419 278 55600.0 276.0 225 0.45 85.22000342 -29.14398249 278 62493.8 275.5 250 0.5 83.78841515 -28.11854612 278 69375.0 275.0 275 0.55 82.40807579 -27.0974518 277 76243.8 274.5 300 0.6 81.07826514 -26.10059509 277 83100.0 274.0 325 0.65 79.79730579 -25.1463022 277 89943.8 273.5 350 0.7 78.5626517 -24.25092286 277 96775.0 273.0 375 0.75 77.3709974 -23.42841591 276 103593.8 272.5 400 0.8 76.21840797 -22.68992955 276 110400.0 272.0 425 0.85 75.10047016 -22.04337824 276 117193.8 271.5 450 0.9 74.01246469 -21.49301811 276 123975.0 271.0 475 0.95 72.94955976 -21.03902304 275 130743.8 270.5 500 1 71.90702573 -20.67706327 275 137500.0 270.0 Kai gaminama 1251 gaminių ir gaminio kaina bus 268 lt. 525 1.05 70.88047072 -20.39788853 275 144243.8 269.5 550 1.1 69.86609696 -20.18691765 275 150975.0 269.0 575 1.15 68.86097739 -20.02383645 274 157693.8 268.5 600 1.2 67.86335219 -19.88220569 274 164400.0 268.0 625 1.25 66.87294457 -19.72908081 274 171093.8 267.5 650 1.3 65.89129528 -19.52464493 274 177775.0 267.0 675 1.35 64.92211509 -19.22185653 273 184443.8 266.5 700 1.4 63.9716545 -18.76611319 273 191100.0 266.0 725 1.45 63.04908985 -18.09493232 273 197743.8 265.5 750 1.5 62.16692492 -17.13765007 273 204375.0 265.0 775 1.55 61.34140714 -15.81513887 272 210993.8 264.5 800 1.6 60.59295743 -14.03954448 272 217600.0 264.0 825 1.65 59.94661271 -11.71404273 272 224193.8 263.5 850 1.7 59.43248002 -8.732616148 272 230775.0 263.0 875 1.75 59.08620142 -4.979850629 271 237343.8 262.5 900 1.8 58.94942843 -0.330751673 271 243900.0 262.0 925 1.85 59.0703053 5.349420009 271 250443.8 261.5 950 1.9 59.50395991 12.20529424 271 256975.0 261.0 975 1.95 60.31300161 20.39151921 270 263493.8 260.5 1000 2 61.56802495 30.07287242 270 270000.0 260.0 1025 2.05 63.34811863 41.42435581 270 276493.8 259.5 1050 2.1 65.74137872 54.63127643 270 282975.0 259.0 1075 2.15 68.84542576 69.88931407 269 289443.8 258.5 1100 2.2 72.76792474 87.4045774 269 295900.0 258.0 1125 2.25 77.62710782 107.3936504 269 302343.8 257.5 1150 2.3 83.55229904 130.0836305 269 308775.0 257.0 1175 2.35 90.68444084 155.7121614 268 315193.8 256.5 1200 2.4 99.17662209 184.5274603 268 321600.0 256.0 1225 2.45 109.1946074 216.7883445 268 327993.8 255.5 1250 2.5 120.9173677 252.7642563 268 334375.0 255.0 1275 2.55 134.5376125 292.7352908 267 340743.8 254.5 1300 2.6 150.2623226 336.9922266 267 347100.0 254.0 1325 2.65 168.3132858 385.8365627 267 353443.8 253.5 1350 2.7 188.9276339 439.5805625 267 359775.0 253.0 1375 2.75 212.3583818 498.5473076 266 366093.8 252.5 1400 2.8 238.8749704 563.0707624 266 372400.0 252.0 1425 2.85 268.7638124 633.4958512 266 378693.8 251.5 1450 2.9 302.3288428 710.1785497 266 384975.0 251.0 1475 2.95 339.8920735 793.485992 265 391243.8 250.5 1500 3 381.794155 883.7965943 265 397500.0 250.0 1525 3.05 428.3949432 981.5001956 265 403743.8 249.5 1550 3.1 480.074075 1086.998218 265 409975.0 249.0 1575 3.15 537.2315518 1200.703845 264 416193.8 248.5 1600 3.2 600.288332 1323.042222 264 422400.0 248.0 1625 3.25 669.6869349 1454.450669 264 428593.8 247.5 1650 3.3 745.8920554 1595.378928 264 434775.0 247.0 1675 3.35 829.3911909 1746.289413 263 440943.8 246.5 1700 3.4 920.6952825 1907.65749 263 447100.0 246.0 1725 3.45 1020.339369 2079.971777 263 453243.8 245.5 1750 3.5 1128.883259 2263.734455 263 459375.0 245.0 1775 3.55 1246.912215 2459.4616 262 465493.8 244.5 1800 3.6 1375.037657 2667.683534 262 471600.0 244.0 1825 3.65 1513.897888 2888.945187 262 477693.8 243.5 1850 3.7 1664.158828 3123.806473 262 483775.0 243.0 1875 3.75 1826.514776 3372.842684 261 489843.8 242.5 1900 3.8 2001.689187 3636.644883 261 495900.0 242.0 1925 3.85 2190.435475 3915.820317 261 501943.8 241.5 1950 3.9 2393.537828 4210.992832 261 507975.0 241.0 1975 3.95 2611.812048 4522.803291 260 513993.8 240.5 2000 4 2846.106418 4851.910001 260 520000.0 240.0 2025 4.05 3097.302578 5198.989135 260 525993.8 239.5 2050 4.1 3366.316435 5564.735157 260 531975.0 239.0 2075 4.15 3654.099084 5949.861243 259 537943.8 238.5 2100 4.2 3961.637755 6355.099693 259 543900.0 238.0 2125 4.25 4289.956779 6781.202347 259 549843.8 237.5 2150 4.3 4640.118578 7228.940981 259 555775.0 237.0 2175 4.35 5013.224667 7699.107696 258 561693.8 236.5 2200 4.4 5410.416684 8192.5153 258 567600.0 236.0 2225 4.45 5832.877431 8709.997671 258 573493.8 235.5 2250 4.5 6281.83194 9252.410105 258 579375.0 235.0 2275 4.55 6758.548548 9820.629653 257 585243.8 234.5 2300 4.6 7264.339997 10415.55543 257 591100.0 234.0 2325 4.65 7800.564541 11038.10893 257 596943.8 233.5 2350 4.7 8368.627075 11689.23428 257 602775.0 233.0 2375 4.75 8969.980271 12369.89852 256 608593.8 232.5 2400 4.8 9606.125732 13081.09184 256 614400.0 232.0 2425 4.85 10278.61515 13823.82778 256 620193.8 231.5 2450 4.9 10989.05149 14599.14347 256 625975.0 231.0 2475 4.95 11739.09016 15408.09976 255 631743.8 230.5 2500 5 12530.44021 16251.78143 255 637500.0 230.0 2525 5.05 13364.86553 17131.2973 255 643243.8 229.5 2550 5.1 14244.18605 18047.78037 255 648975.0 229.0 2575 5.15 15170.27896 19002.38792 254 654693.8 228.5 2600 5.2 16145.07993 19996.30161 254 660400.0 228.0 2625 5.25 17170.58431 21030.72754 254 666093.8 227.5 ##### Sheet/List 2 ##### •Pelno funkcija: C=14*x +16*y •Apribojimai: •8x+4y<=3440 (žaliavų apribojimas) •6x+8y<=2880 (darbo apribojimas) •4x+6y<=2760 (įrengimų pajėgumo apr.) •0<=x<=420 (pardavimų kiekio aprib.) •y>=0 (min pardavimų kiekis) Tikslas: 6000 x 1apr 2apr 3apr tikslas 4apr 0 860 360 460 375 420 10 840 353 453 366 420 20 820 345 447 358 420 30 800 338 440 349 420 40 780 330 433 340 420 50 760 323 427 331 420 60 740 315 420 323 420 70 720 308 413 314 420 80 700 300 407 305 420 90 680 293 400 296 420 100 660 285 393 288 420 110 640 278 387 279 420 120 620 270 380 270 420 Surasim su Goal seek kur kertasi 1 ir 2 apribojimų kreivės 130 600 263 373 261 420 140 580 255 367 253 420 x 1apr 2apr 1apr-2apr 150 560 248 360 244 420 400 60 60 0 160 540 240 353 235 420 170 520 233 347 226 420 180 500 225 340 218 420 "Reiškia x=400, y=60 ir tikslo funkcijos reikšmė:" 6560 190 480 218 333 209 420 200 460 210 327 200 420 210 440 203 320 191 420 220 420 195 313 183 420 230 400 188 307 174 420 240 380 180 300 165 420 250 360 173 293 156 420 260 340 165 287 148 420 270 320 158 280 139 420 280 300 150 273 130 420 290 280 143 267 121 420 300 260 135 260 113 420 310 240 128 253 104 420 320 220 120 247 95 420 330 200 113 240 86 420 340 180 105 233 78 420 350 160 98 227 69 420 360 140 90 220 60 420 370 120 83 213 51 420 380 100 75 207 43 420 390 80 68 200 34 420 400 60 60 193 25 420 410 40 53 187 16 420 420 20 45 180 8 420 430 0 38 173 -1 420 440 -20 30 167 -10 420 450 -40 23 160 -19 420 460 -60 15 153 -28 420 470 -80 8 147 -36 420 480 -100 0 140 -45 420 490 -120 -8 133 -54 420 500 -140 -15 127 -63 ##### Sheet/List 3 ##### Bazinis kint Kiekis X Y S1 S2 S3 S4 Bazinis kint Kiekis Y Z S1 S2 S3 Tikslo f.:C= 0 14 16 0 0 0 0 Santykis Tikslo f.:C= 0 28 24 0 0 0 Santykis S1-medž. 3440 -8 -4 -1 0 0 0 860 S1-medž. 332 -8 -5 -1 0 0 41.5 S2-darbas 2880 -6 -8 0 -1 0 0 360 S2-darbas 290 -5 -8 0 -1 0 58 S3-įreng. 2760 -4 -6 0 0 -1 0 460 S3-įreng. 32 0 -1 0 0 -1 #DIV/0! S4-pard. 420 -1 0 0 0 0 -1 #DIV/0! "Pasirenkamas kintamasis, kurio koeficientas TF didžiausias" "Pasirenkama ta lygtis, kurioje laisvo nario ir pasirinkto kintamojo santykis yra mažiausias" Bazinis kint Kiekis X S2 S1 S2 S3 S4 Bazinis kint Kiekis S1 S2 S1 S2 S3 2333.333333 Tikslo f.:C= 5760 2 0 0 -2 0 0 Santykis Tikslo f.:C= 1162 0 6.5 -3.5 0 0 676.3285024 S1-medž. 2000 -5 0 -1 0.5 0 0 400 Y 41.5 -1 -0.625 -0.125 0 0 170 Y 360 -0.75 -1 0 -0.125 0 0 480 S2 82.5 0 -4.875 0.625 -1 0 463.7681159 S3-įreng. 600 0.5 0 0 0.75 -1 0 -1200 S3-įreng. 32 0 -1 0 0 -1 633.7681159 S4-pard. 420 -1 0 0 0 0 -1 420 nukopijuojam ir pakoreguojam formules nukopijuojam ir pakoreguojam formules Bazinis kint Kiekis X S2 S1 S2 S3 S4 Bazinis kint Kiekis X S2 S1 S2 S3 Tikslo f.:C= 6560 0 0 -0.4 -1.8 0 0 Tikslo f.:C= 1178.6 -0.4 6.25 -3.55 0 0 S1-medž. 400 -1 0 -0.2 0.1 0 0 S1-medž. 8.3 -0.2 -0.125 -0.025 0 0 Y 60 0 -1 0.15 -0.2 0 0 Y 76.275 0.15 -4.78125 0.64375 -1 0 S3-įreng. 800 0 0 -0.1 0.8 -1 0 S3-įreng. 36.15 -0.1 -1.0625 -0.0125 0 -1 S4-pard. 20 0 0 0.2 -0.1 0 -1 S4-pard. -8.3 0.2 0.125 0.025 0 0 ##### Sheet/List 4 ##### Efektyvumas Kiekis Kiekio riba Efektyvumas kai <=10 Efektyvumas kai >10 Reklamos kaina už vnt. Vis reklamos kaina Pardavimai nuo 1 vnt. Pardavimai viso Radio 1000 20 25 60 40 1700 34000 30000 600000 TV 1075 15 25 80 55 2800 42000 60000 900000 Spauda 350 5 25 70 35 1200 6000 45000 225000 Viso: 2425 40 82000 1725000 Riba: 72000 1800000 0