Global Construction Company is planning construction of five dormitory buildings in four different neighboring university and college campuses (numbered from 1 to 4). The primary requirement for the construction is concrete, which will be supplied from three concrete production facilities to be built on sites A, B, and C. The demand, transportation costs, and facility construction costs are shown in Table 1. The management of Global would like to know which sites should be selected to build the concrete production facilities and what quantities of concrete should be supplied from each of these facilities. Campus Demand (units) From To A B с Facility Cost (P) 1 2000 1 20 10 50 A 140,000 Table 1 Dormitory Concrete Costs DEMAND IN UNITS OF CONCRETE 2 3 3000 8000 TRANSPORTATION COSTS (P/unit) 2 3 30 20 20 30 20 80 FACILITY CONSTRUCTION COSTS B 90,000 4 5000 с 160,000 4 10 60 90

Global Construction Company is planning construction of five dormitory buildings in four different neighboring university and college campuses (numbered from 1 to 4). The primary requirement for the construction is concrete, which will be supplied from three concrete production facilities to be built on sites A, B, and C. The demand, transportation costs, and facility construction costs are shown in Table 1. The management of Global would like to know which sites should be selected to build the concrete production facilities and what quantities of concrete should be supplied from each of these facilities. Campus Demand (units) From To A B с Facility Cost (P) 1 2000 1 20 10 50 A 140,000 Table 1 Dormitory Concrete Costs DEMAND IN UNITS OF CONCRETE 2 3 3000 8000 TRANSPORTATION COSTS (P/unit) 2 3 30 20 20 30 20 80 FACILITY CONSTRUCTION COSTS B 90,000 4 5000 с 160,000 4 10 60 90

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Please do not give solution in image format thanku Tech Football Strategy: Tech is playing State in the last conference game of the season. Tech is trailing State 21 to 14, with 7 seconds left in the game, when Tech scores a touchdown. Still trailing 21 to 20, Tech can either go for 2 points and win or go for 1 point to send the game into overtime. The conference championship will be determined by the outcome of this game. If Tech wins, it will go to the Sugar Bowl, with a payoff of $7.2 million; if it loses, it will go to the Gator Bowl, with a payoff of $1.7 million. If Tech goes for 2 points, there is a 33% chance it will be successful and win. If it goes for 1 point, there is a 0.98 probability of success and a tie and a 0.02 probability of failure. If the teams tie, they will play overtime, during which Tech believes it has only a 20% chance of winning because of fatigue. Use decision tree analysis to determine whether Tech should go for 1 or 2 points. Joanna came up with the…
Primarily which among the following reports will you use, to know which constraints are binding and which are not, while using Solver? a. Answer Report b. Sensitivity Report c. None of these d. Limits Report
Pls help ASAP on both
Please use Excel the problem needs to be solved by linear programming. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
1. Construct a 2-by2 contingency table to determine the total number of people who fail the screening test and will be referred for diagnostic testing in the hearing centers. 2. Construct a 2-by-2 contingency table to determine the total number of people who fail the diagnostic test, which represents the target market for hearing aid sales.
Which of the following statements is correct regarding the EMH form? Select one: None of the answers are correct If the market is weak-form efficient, then it is also semistrong and strong-form efficient. If the market is semistrong form efficient, then it is also strong form efficient If a market is strong-form efficient, it is also semistrong and weak form efficient If the market is strong-form efficient, it is also semistrong but not weak-form efficient
Please don't give image format
Need assistance, If possible please use the attached Excel format
Is my solution correct and did I fully answer the questions? (see attachment for my solution) Question: There are three factories on Momiss River. Each emits two types of pollutants, labeled P1 and P2, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1,500 to process a ton of factory 1 waste, and each ton processed reduces the amount of P1 by 0.10 ton and the amount of P2 by 0.45 ton. It costs $2,500 to process a ton of factory 2 waste, and each ton processed reduces the amount of P1 by 0.20 ton and the amount of P2 by 0.25 ton. It costs $3,000 to process a ton of factory 3 waste, and each ton processed reduces the amount of P1 by 0.40 ton and the amount of P2 by 0.50 ton. The state wants to reduce the amount of P1 in the river by at least 125 tons and the amount of P2 by at least 175 tons. a. Use Solver to determine how to minimize the cost of reducing pollution by the desired amounts. Are the LP assumptions…
Please do not give solution in image format thanku TriStar Manufacturing makes three models of fans, identified by the unimaginative names of A, B, and C. The fans are made out of nuts, bolts, wire, blades, and motors. The current inventory levels and parts list for each type of fan is shown in the table below. Profit from Fan A is $35, Fan B profit is $50, and Fan C profit is $60. TriStar Manufacturing wants to know the best product mix to maximize the revenue.
The idea that managers make decisions with incomplete information is an example of which term below? Question 33 options: satisficing bounded rationality decision criteria Management by Objectives
An engineer should not approve a project which is not safe for the public. It is an example of which type of ethics? O a. Religious Ethics O b. Personal ethics O c. Business ethics O d. Professional ethics