Seminární práce: Operational Research - tasks
Skrýt detaily | Oblíbený- Kvalita:70,5 %
- Typ:Seminární práce
- Univerzita:Slezská univerzita v Opavě
- Fakulta:Obchodně-podnikatelská fakulta
- Kategorie:Ekonomika
- Podkategorie:Management
- Autor:eliskabila
- Rozsah A4:9 strán
- Zobrazeno:468 x
- Stažené:0 x
- Velikost:0,1 MB
- Formát a přípona:MS Office Word (.docx)
- Jazyk:anglický
- ID projektu:3958
- Poslední úprava:11.08.2014
The Firm completes four kinds of sweet boxes. To complete the boxes, the firm uses 6 kinds of candies. Composition of sweet boxes and capacities are given in table.
Tasks:
1. Write down the mathematical model maximizing firm’s profit.
2. Solve the problem using Excel Solver or winqsb - find the optimal production program. How many of each sweet boxes will be produced?
3. Which substance is for the production crucial?
4. How the solution will be changed if:
a. Sweet box 1 profit increases up to 160 Kč and sweet box 3 profit decreases by 10%.
b. Capacity of Candy 2 increases by 1000 pieces and capacity of Candy 3 decreases by 20%.
c. Sweet box 3 composition changes into: 3 pc Candy 2, 3 pc. Candy 3, 3 pc Candy 4, 3 pc. Candy 5.
d. Candy 6 is not available.
Tasks:
1. Write down the mathematical model maximizing firm’s profit.
2. Solve the problem using Excel Solver or winqsb - find the optimal production program. How many of each sweet boxes will be produced?
3. Which substance is for the production crucial?
4. How the solution will be changed if:
a. Sweet box 1 profit increases up to 160 Kč and sweet box 3 profit decreases by 10%.
b. Capacity of Candy 2 increases by 1000 pieces and capacity of Candy 3 decreases by 20%.
c. Sweet box 3 composition changes into: 3 pc Candy 2, 3 pc. Candy 3, 3 pc Candy 4, 3 pc. Candy 5.
d. Candy 6 is not available.