Question: SOLUTION WITH EXCEL SOLVER 2. Bir irketin rnlerini rettii 3 fabrikas vardr. Bu rnlerini, 4 farkl ehirdeki mterilerine gndermektedir. Fabrikalarn aylk retim kapasiteleri ve mterilerinin

SOLUTION WITH EXCEL SOLVER

2. Bir irketin rnlerini rettii 3 fabrikas vardr. Bu rnlerini, 4 farkl ehirdeki mterilerine gndermektedir. Fabrikalarn aylk retim kapasiteleri ve mterilerinin aylk talepleri ve her bir fabrikadan her bir mteriye bir birim rnn gnderim maliyeti aada verilmitir: Her fabrikadan her 4 mteriye minimum maliyette ne kadar rn gnderileceinin belirlenmesi istenmektedir. Bir ulatrma problemi olan bu problemi Microsoft Excel zc eklentisi ile znz. (Problemin dorusal programlama modeli aada verilmitir.) Zmin=15x11+18x12+19x13+13x14+21x21+14x22+15x23+17x24+25x31+12x32+17x33+22x34x11+x12+x13+x14180.000x21+x22+x23+x24160.000x31+x32+x33+x34450.000x11+x21+x31=160.000x12+x22+x32=190.000x13+x23+x33=250.000x14+x24+x34=150.000xij0(i=1,2,3vej=1,2,3,4)(Afabrikas)(Bfabrikas)(Cfabrikas)(musteri1)(musteri2)(musteri3)(musteri4) 2. Bir irketin rnlerini rettii 3 fabrikas vardr. Bu rnlerini, 4 farkl ehirdeki mterilerine gndermektedir. Fabrikalarn aylk retim kapasiteleri ve mterilerinin aylk talepleri ve her bir fabrikadan her bir mteriye bir birim rnn gnderim maliyeti aada verilmitir: Her fabrikadan her 4 mteriye minimum maliyette ne kadar rn gnderileceinin belirlenmesi istenmektedir. Bir ulatrma problemi olan bu problemi Microsoft Excel zc eklentisi ile znz. (Problemin dorusal programlama modeli aada verilmitir.) Zmin=15x11+18x12+19x13+13x14+21x21+14x22+15x23+17x24+25x31+12x32+17x33+22x34x11+x12+x13+x14180.000x21+x22+x23+x24160.000x31+x32+x33+x34450.000x11+x21+x31=160.000x12+x22+x32=190.000x13+x23+x33=250.000x14+x24+x34=150.000xij0(i=1,2,3vej=1,2,3,4)(Afabrikas)(Bfabrikas)(Cfabrikas)(musteri1)(musteri2)(musteri3)(musteri4)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Write HDL code for the pipelined MIPS processor. The processor should be compatible with the top-level module from HDL Example 7.13. It should support all of the instructions described in this...

GR Nike: Sweatshop Tartmas Nike, birok ynden en mkemmel kresel irkettir. 1972'de eski Oregon niversitesi atletizm yldz Phil Knight tarafndan kurulan Nike, u anda gezegendeki spor ayakkab ve giyimin...

Aadaki vakay okuduktan sonra bir SWOT Analizi oluturun. Sergiler alakasz. Metalcraft'taki program ynetimi ekibinin yeleri, yeni bir lks sedanda kullanlacak lastik havalandrma hortumunun tedarikini...

Aadaki vaka almas iin sorular ayrntlaryla ele aln (madde iaretleri olmadan) Mattel'in Geri arma Stratejisi otopsi . Mattel'in geri arma stratejisinin olumlu ve olumsuz yanlar nelerdir? Mattel'in...

BoWw N e A B Cc D E F G H 1 1 K Afarmer owns 500 hectares of land in an arid region. The government gives him up to 1,000,000 cubic metres of water for irrigation each year. In addition, he may...

In the transportation problem in Table 1, the total demand exceeds the total supply. Suppose that the penalty costs per unit of unsatisfied demand are $5, $3, and $2 for destinations 1,2, and 3,...

Grain Distribution Planning. The Moore & Harman Company is in the business of buying and selling grain. An important aspect of the companys business is arranging for the purchased grain to be shipped...

How do I formulate question 3 as a transportation problem? ADM2302 Section M, N and P Solution Assignment # 2 SOLUTION Assignment # 2 LP Formulations and Applications ADM2302 students are reminded...

Please answer the part EFGH. thanks! Question 5. (22 points) OPTIMAL PRODUCT MIX AND WHAT-IF QUESTIONS AU Electronics manufactures is the supplier of components C1, C2 and C3 for the production of...

The solution of all the questions below should definitely be with the excel solver. You can also share photos of the actions you have done in the excel solver. A)Tooleo has contracted with AutoMate...

5. Calculate the E, AG and K at 25C for the reaction, 2Mno, + 4H* + Cl2 2MN2+ + 2C10, + 2H20

Snowbird Snowboards converts regular snowboards by adding outriggers and seats so that people who use wheelchairs can snowboard. The income statement for last year, in which 500 snowboards were...

Info obtained on _ _ _ _ _ _ 4 / 2 7 / 2 0 2 5 _ _ _ _ _ _ _ _ from Yahoo Finance Price _ _ _ 9 5 . 0 9 _ _ _ _ _ _ _ _ _ _ _ Shares Outstanding _ _ _ _ _ 8 , 0 2 0 , 0 0 0 , 0 0 0 _ _ _ _ _ _ _ _ _...

Which of the following statements is false regarding management's documentation of internal control over financial reporting? a. Management needs to maintain sufficient and appropriate documentation...