Väiksel käsitöö vabrikul on plaan oma ettevõte rajada suuremasse asulasse. Seoses sel ära kasutada nii, et toodete valmistamisest saadav tulu oleks suurim. Käsitöö vabrikul lõng(mis tuleb täielikult ära kasutada), C lõng ja D lõng. Ettevõte valmistab hetkel ne sokid, sall ja kampsun. Alljärgnevad tabelis on toodud toodete valmistamiseks kuluv materjal ning saadav kasum ühe toote k Tooted Ressursid kogus (kg) Käpikud Villased sokid A lõng 360 0.2 0.1 B lõng 225 0.1 0.3 C lõng 400 0.2 0.2 D lõng 120 0.1 0.2 Hind 10 15
1 0.2 0.1 0.2 P1 (aeg tundides) 0.02 0.03 0.01 0.04 0.01 0.02 P2 (aeg tundides) 0.04 0.02 0.02 0.06 0.03 Päevane tootmismaht >= 200 <= 800 <= 400 Kasum (/toote kohta) 10 12 8 15 18 10 1. Koostada lineaarse planeerimise ülesanne. kitsendused tundmatud ressurss A B C D E R1 0.1 0.3 0.2 0.1 0.2 R2 0.2 0.1 0.4 0.2 0.2 R3 0.2 0.2 0.1 0
Toote C valmistamiseks kulub I operatsiooni teostamiseks tööaega 2 tundi ; II operatsiooni teostamiseks 2 tundi ja III operatsiooni teostamiseks 2 tundi. I operatsiooni teostamiseks on võimalik kasutada kuni 84 tundi, II operatsiooni 54 ja III operatsiooni teostamiseks 90 tundi. Kasumit saadakse erineva toodangu müügist vastavalt 25; 30 ja 35 € toodanguühiku kohta. Kui palju erinevaid tooteid tuleb valmistada, et tehase kasum oleks suurim? 1) Formuleerida lineaarse planeerimise ülesanne. x1 Toode A I operatsioon 3x1 + x2 x2 Toode B II operatsioon x1 + 2x2 x3 Toode C III operatsioon 4x1 + 3x2 F= 25x1+30x2+35x3 --->max 2) Lahendada MS Exceli Solveriga (Report).
Microsoft Excel 16.0 Answer Report Worksheet: [Excel_Majandusarvestuses_Solver_Forecast.xlsx]Solver (1) Report Created: 20-Dec-20 10:25:39 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.032 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegati Objective Cell (Max) Cell Name Original Value $I$13 Tootmis tellimus Kogukasum 5750 Variable Cells Cell Name Original Value $C$13 Tootmis tellimus Toode 1 50 $D$13 Tootmis tellimus Toode 2 50 $E$13 Tootmis tellimus Toode 3 100
Microsoft Excel 14.0 Sensitivity Report Worksheet: [Maj.probleem.xlsx]Sheet1 Report Created: 11.11.2012 22:13:35 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$14 muutujad x1 0 -86 1200 86 1,0000E+030 $C$14 muutujad x2 6 0 1700 1,0000E+030 64 $D$14 muutujad x3 0 -29 750 29 1,0000E+030 $E$14 muutujad x4 16 0 1000 1,0000E+030 67 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $H$14 valge v 254 0 370 1,0000E+030 116 $H$15 pruun v
Scenario Summary Current Values: Kohalik Regionaalne Changing Cells: Piletite_arv 50 50 500 Esineja 1,500 € 1,500 € 3,000 € Ruumi_rent 250 € 250 € 650 € Tehnika_rent 200 € 200 € 300 € Meened 400 € 400 € 650 € Toitlustus 1,200 € 1,200 € 2,000 € Abipersonal 900 € 900 € 1,400 € Result Cells: Kasum_Kahjum - 2,700 € - 2,700 € 9,500 € Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray. Globaalne 1000 7,500 € 1,800 € 600 € 1,100 € 2,900 €
Handbook of Meat Processing Handbook of Meat Processing Fidel Toldrá EDITOR A John Wiley & Sons, Inc., Publication Edition first published 2010 © 2010 Blackwell Publishing Blackwell Publishing was acquired by John Wiley & Sons in February 2007. Blackwell’s publishing program has been merged with Wiley’s global Scientific, Technical, and Medical business to form Wiley-Blackwell. Editorial Office 2121 State Avenue, Ames, Iowa 50014-8300, USA For details of our global editorial offices, for customer services, and for information about how to apply for permission to reuse the copyright material in this book, please see our website at www.wiley.com/ wiley-blackwell. Authorization to photocopy items for internal or personal use, or the internal or personal use of specific clients, is granted by Blackwell Publishing, provided that the base fee is paid directly to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923. F
[email protected] 06 Aug 2018 FITNESS IN SOCCER THE SCIENCE AND PRACTICAL APPLICATION Jan Van Winckel, Werner Helsen, Kenny McMillan, David Tenney, Jean-Pierre Meert, Paul Bradley [email protected] 06 Aug 2018 Isbn-number : 9789082132304 Publisher: Moveo Ergo Sum / Klein-Gelmen Proofreading: Jim Newall Quill Content |Writing, Editing and Web site services http://www.quillsites.co.uk Photos: Jean Leemans and Etienne Claessens Cover and lay-out: Dots & Bits © 2014 Jan Van Winckel Printed and bound at Manipal Technologies Ltd., India All rights reserved. No pa
Kõik kommentaarid