![scottbrandon653](/avatars/33883.jpg)
scottbrandon653
18.01.2021 •
Business
Develop an Excel model for the following LP transportation problem. Solve the problem using Solver and match the correct answer to the questions. Warehouse City E City F City G City H Warehouse Supply A 0.53 0.21 0.52 0.41 4500 B 0.31 0.37 0.41 0.28 5000 C 0.56 0.32 0.56 0.33 4000 D 0.41 0.54 0.34 0.52 5500 City Demand 4,400 3,500 5,500 5,600 Match the correct answer to the following questions: 1. What is the value of the objective function
Solved
Show answers
More tips
- F Food and Cooking Do Aphrodisiacs Really Work? Separating Fact from Fiction...
- C Computers and Internet Log-in: what is it and why do you need it?...
- S Style and Beauty Secrets of Tying a Pareo: 5 Ways...
- F Food and Cooking Everything You Need to Know About Pasta...
- C Computers and Internet How to Choose a Monitor?...
- H Horoscopes, Magic, Divination Where Did Tarot Cards Come From?...
- S Style and Beauty How to Make Your Lips Fuller? Ideas and Tips for Beautiful Lips...
- C Computers and Internet How to Learn to Type Fast?...
Answers on questions: Business
- B Business What does a notational analyst do? O A. Helps people plan healthy diets. B. Analyzes sports games in order to help coaches plan out strategy. C. Helps people design exercise...
- B Business The store receives an order for a 50° stand. The employee does not have a template for a 50° stand and does not have a protractor. Can the employee use the existing templates...
- B Business Sam filed a discrimination case against his employer with the Equal Employment Opportunity Commission (EEOC). The EEOC sent a notice of charge to Sam s employer. In this...
- B Business One million hours of labor are available for making cars in the North, and another 1 million hours of labor are available for world, let s assume that two-thirds of the...
- B Business Maureen ,a talented painter ,started a business making handmade furniture with customized designs painted on each .because she know notting about marketing .you d advise...
- M Mathematics Someone tell me the answer please...
- M Mathematics Please help Please........
- M Mathematics There are s repairmen in a manufacturing system to fix broken machines. We want to simulate the system to compare employment policies s = 1, 2, · · ·, 5. We want to form...
- M Mathematics Part A 85 out of 350 books in the library are about Mysteries. What percent of the books are Mystery books? part b What percent of the books are not Mystery books? Write...
- M Mathematics What is the Answer me to This math problem? 3-2=1=5-3=12?...
Ответ:
The objective function is:
Minimization (Z) = 0.53Xae + 0.21Xaf + 0.52Xag + 0.41Xah + 0.31Xbe + 0.37Xbf + 0.41Xbg + 0.28Xbh + 0.56Xce + 0.32Xcf + 0.56Xcg + 0.33Xch + 0.41Xde + 0.54Xdf + 0.34Xdg + 0.52Xdh
Explanation:
Solution:
We are asked to find the value of the objective function in this data given.
So,
Let Xae be the number of units shipping from warehouse A to city E.
Similarly, we have Xaf, Xag, Xah
Let Xbe be the number of units shipping from warehouse B to city E .
Similarly, we have Xbf, Xbg, Xbh
Let Xce be the number of units shipping from warehouse C to city E .
Similarly, we have Xcf, Xcg, Xch
Let Xde be the number of units shipping from warehouse D to city E .
Similarly, we have Xdf, Xdg, Xdh
Furthermore,
0.53 is the shipping cost of 1 unit from warehouse A to City E.
So, the shipping cost of Xae units from warehouse A to City E is 0.53Xae.
Similarly, we have other corresponding costs.
Hence,
The objective function is:
Minimization (Z) = 0.53Xae + 0.21Xaf + 0.52Xag + 0.41Xah + 0.31Xbe + 0.37Xbf + 0.41Xbg + 0.28Xbh + 0.56Xce + 0.32Xcf + 0.56Xcg + 0.33Xch + 0.41Xde + 0.54Xdf + 0.34Xdg + 0.52Xdh
Ответ:
B
Explanation:
because it says collaborative.