A mining company extracts gravel, the basic product it sells, from three mines, L1, L2 and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A mining company extracts gravel, the basic product it sells, from three mines, L1, L2 and L3. The weekly production of each mine is 75, 150 and 75 tons of gravel respectively. The gravel has to be transported to five main consumers, K1, K2, K3, K4 and K5 requiring for their needs 100, 60, 40, 75 and 25 tons of gravel per week respectively. The problem that concerns the company's management is the minimization of the required cost for the transportation of the product to the consumers. For this purpose a detailed cost analysis was carried out which gave the results of the following table (the numbers denote the transportation cost in € per ton of gravel). K1 K5 3 1 4 2 1 2 1. Write the transportation model and the transportation tableau. 2. Use Excel to find the optimal solution for this problem. Mines Customers K3 3 2 5 L1 L2 L3 K2 2 1 0 K4 4 4 3 Use the branch-and-bound method to find the optimal solution to this Integer Programming problem max s.t Z = 4x₁ + x₂ 2x₁ + x₂ ≤ 5 2x₁ + 3x₂ ≤5 (X₁ X₂) 20; X₁, X2 Integer NTC is a small business that receives checks from all over Cote d'Ivoire. The average daily total payments mailed by customers from each region of Cote d'Ivoire to NTC is as follows: the West, 70000 CFA Francs; the North, 50000 CFA Francs; the East, 40000 CFA Francs; the South, 60000 CFA Francs. NTC must decide where customers should mail their payments. Because NTC can earn 20% annual interest by investing these revenues, NTC would like to receive payments as quickly as possible. NTC is considering setting up operations to process payments in four cities: Abidjan, Abengourou, Korhogo, and Man. The average number of days from the time the is sent until it is cleared and deposited in NTC bank account depends on the city to which the payment is mailed, as shown in the table below. Region 1: West Region 2: North Region 3: East Region 4: South City 1 Man 268 8 City 2 Korhogo 625 2 5 5 City 3 Abengourou 8525 2 5 City 4 Abidjan 8 сл сл со 5 5 2 The annual cost for the payment processing office in a city is 50000 CFA Francs. In addition, if customers in Region 1 (West) send their checks to City 1 (Man), then no other customers from the other regions may sent their payments to City 1. 1. Formulate an Integer Programming model that NTC can use to minimize the sum of the costs due to lost interest income and running a payment processing office. 2. Use MS Excel to find the optimal solution to this IP problem. A mining company extracts gravel, the basic product it sells, from three mines, L1, L2 and L3. The weekly production of each mine is 75, 150 and 75 tons of gravel respectively. The gravel has to be transported to five main consumers, K1, K2, K3, K4 and K5 requiring for their needs 100, 60, 40, 75 and 25 tons of gravel per week respectively. The problem that concerns the company's management is the minimization of the required cost for the transportation of the product to the consumers. For this purpose a detailed cost analysis was carried out which gave the results of the following table (the numbers denote the transportation cost in € per ton of gravel). K1 K5 3 1 4 2 1 2 1. Write the transportation model and the transportation tableau. 2. Use Excel to find the optimal solution for this problem. Mines Customers K3 3 2 5 L1 L2 L3 K2 2 1 0 K4 4 4 3 Use the branch-and-bound method to find the optimal solution to this Integer Programming problem max s.t Z = 4x₁ + x₂ 2x₁ + x₂ ≤ 5 2x₁ + 3x₂ ≤5 (X₁ X₂) 20; X₁, X2 Integer NTC is a small business that receives checks from all over Cote d'Ivoire. The average daily total payments mailed by customers from each region of Cote d'Ivoire to NTC is as follows: the West, 70000 CFA Francs; the North, 50000 CFA Francs; the East, 40000 CFA Francs; the South, 60000 CFA Francs. NTC must decide where customers should mail their payments. Because NTC can earn 20% annual interest by investing these revenues, NTC would like to receive payments as quickly as possible. NTC is considering setting up operations to process payments in four cities: Abidjan, Abengourou, Korhogo, and Man. The average number of days from the time the is sent until it is cleared and deposited in NTC bank account depends on the city to which the payment is mailed, as shown in the table below. Region 1: West Region 2: North Region 3: East Region 4: South City 1 Man 268 8 City 2 Korhogo 625 2 5 5 City 3 Abengourou 8525 2 5 City 4 Abidjan 8 сл сл со 5 5 2 The annual cost for the payment processing office in a city is 50000 CFA Francs. In addition, if customers in Region 1 (West) send their checks to City 1 (Man), then no other customers from the other regions may sent their payments to City 1. 1. Formulate an Integer Programming model that NTC can use to minimize the sum of the costs due to lost interest income and running a payment processing office. 2. Use MS Excel to find the optimal solution to this IP problem.
Expert Answer:
Answer rating: 100% (QA)
Morth west corner solution The Lo L3 X 345 425 H La L1 100 125 6010 4010 L2 13 Cost CII L1 ... View the full answer
Related Book For
Posted Date:
Students also viewed these banking questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Write a method \(\max ()\) that takes the first Node in a linked list as its argument and returns the value of the maximum item in the list. Assume that all items are positive integers, and return 0...
-
A uniform narrow tube 1.80m long is open at both ends. It resonates at two successive harmonics of frequencies 275 Hz and 330 Hz. What is? (a) The fundamental frequency, and (b) The speed of sound in...
-
Jacks Lumber Yard receives 8,000 large trees each period that it subsequently processes into rough logs by stripping off the tree bark and leaves (i. e., one tree equals one log). Jacks then must...
-
Patty Hayes owned four Personal Seat Licenses (PSLs) at the Cleveland Browns Stadium. Hayess PSLs reserved four seats on the 50-yard line, at the railing, on the north side of the stadium. As the...
-
Top Quality Appliance-Long Beach has just purchased a franchise from Top Quality Appliance (TQA). TQA is a manufacturer of kitchen appliances. TQA markets its products via retail stores that are...
-
1. Why have neo-classical economists generally argued that international economic relations are not zero-sum in character? What theoretical frameworks have they used to support this argument? It's...
-
Bob Burley and his brother Buford ran the best restaurant in Dallas, Texas. Many out-of-towners would visit Dallas and go to Burleys Biscuits, Beef, and Veggies for a good wholesome meal. One thing...
-
Private Equity Investments in Banks. Which do you prefer: the Federal Reserves loosening of its controlling influence standards during the Financial Crisis to encourage private capital, or the FDICs...
-
You are interested in obtaining a sample of 50% females and 50% males. The population of CAS undergraduate majors is made up of 80% females and 20% males. How would you use Stratified Random Sampling...
-
MANM200/5/LSA/21/22 (1 hand-out) QUESTION 1 a. Assume the following quotes for pounds, U.S. dollars and euros exist today. $1.30/ $1.65/ i. ii. 1.15/ Assume no transaction costs. Based on these...
-
A wholesaler gives trade discounts 20%, 10% and 5% to his regular customers. He sent an invoice dated 8 September 2009 with cash terms 6/20, 4/30 and n/60 for the product listed at RM 16,450. The...
-
Analyze the artifacts and environment of a physical space personal to you. What do these nonverbals communicate about who you are? How does their presence affect your feelings of comfort, identity,...
-
The initial cost of a new automated conveyor system is $64,000. However, once it is installed, there will be less labor required, which will lead to a certain amount of savings annually. To maintain...
-
The following selected financial data pertain to four unidentified companies (balance sheet amounts reported in millions): Companies 1 2 3 4 Cash $ 5.1 $ 8.8 $ 6.3 $10.4 Accounts receivable 13.1 41.5...
-
A 2500-lbm car moving at 15 mi/h is accelerated at a constant rate of 15 ft/s 2 up to a speed of 50 mi/h. Calculate force and total time required?
-
The Southfork Feed Company makes a feed mix from four ingredientsoats, corn, soybeans, and a vitamin supplement. The company has 300 pounds of oats, 400 pounds of corn, 200 pounds of soybeans, and...
-
Valley United Soccer Club has 16 boys' and girls' travel soccer teams. The club has access to three town fields, which its teams practice on in the fall during the season. Field 1 is large enough to...
-
The Douglas family raises cattle on their farm in Virginia. They also have a large garden in which they grow ingredients for making two types of relish-chow-chow and tomato. These they sell in...
-
If average productivity falls, will marginal cost necessarily rise? How about average cost?
-
Say that a firm has fixed costs of $100 and constant average variable costs of $25. a. Show AFC, VC, AVC, and MC in a table. b. Graph the AFC, ATC, AVC, and MC curves. c. Explain why the curves have...
-
An economic consultant is presented with the following total product table and asked to derive a table for average variable costs. The price of labor is $10 per hour. a. Help him do so. b. Show that...
Study smarter with the SolutionInn App