Reference no: EM13962523
Formulate the LP model for the problems below in EXCEL using problem solver:
1. The Big Bang explosives company produces customized blasting compounds for use in the mining industry. The four ingredients for these explosives are agents A, B, C and D. Big Bang just received an order for 2000 pounds of explosive. Agents A and C each costs $5 per pound, agent B costs $6 per pound, and agent D costs $3 per pound. The customer's mixture must contain at least 20% agent A, at least 30% agent B, and at least 15% each for agents C and D. Additionally, the customer insists that there must be at least twice as much agent B as agent C in the mix and that the poundage of agent A must be at least 40% of what's used for agent D. Finally, at least 200 pounds of each agent should be present in the finished product. The company wants to provide the least expensive mixture which will satisfy the customer's requirements.
2. A group of investors has $500,000 to invest and wants to maximize the money they will receive at the end of one year. They can invest in condos, apartments and houses. Furthermore, they wish to invest the entire amount. The profit after one year, the cost and the number of units available are shown below:
Investment Profit per unit Cost per unit Number Available
($1,000) ($1,000)
Condos 6 50 10
Apartments 12 90 5
Houses 9 100 7
Formulate the model for this problem.
|
Describe the relationship-run the simple linear regression
: Plot the data with the 2000 tuition on the x-axis and 2008 tuition on the y-axis. Describe the relationship. Are there any outliers or unusual values? Does a linear relationship between the tuition in 2000 and 2008 seem reasonable? Run the simple li..
|
|
How well were costs controlled in the assembly department
: How well were costs controlled in the Assembly Department in March? What changes, if any, should be made in the reports to give better insight into how well departmental supervisors are controlling costs?
|
|
How corporate policies can be used to improve the general
: How corporate policies can be used to improve the general outcomes of a financial organization.
|
|
What were some of the issues with respect to communication
: Identify an example of a successful team experience and one that was less than successful. What were some of the issues with respect to communication and based on this experience, what is harder manage, a team or a group? Why?
|
|
Determining the expensive mixture
: Finally, at least 200 pounds of each agent should be present in the finished product. The company wants to provide the least expensive mixture which will satisfy the customer's requirements.
|
|
How many pins should you buy and have on hand for the event
: Alabama pins commemorating the 2013 National Championship game are purchased in multiples of 50 for your college organization at $1.90 each. After the event their salvage value is just $0.75. How many pins should you buy and have on hand for the even..
|
|
Vision research has completed preliminary development
: Vision Research has completed preliminary development of a new drug, code-named ClearView that corrects nearsightedness. This revolutionary new product could be completely developed and tested in time for release next year if the FDA approves the pro..
|
|
Assume no transaction costs
: Suppose that we have N different currencies (e.g., US Dollars, Euros, etc.). For each pair of currencies, (i, j), one unit of currency i can be exchanged into rij units of currency j. Formulate this as a min-cost flow problem and provide an LP with a..
|
|
Obtain maximum capacity
: The graph below represents possible freeway routes from a city A to an airport F. Each segment of the graph has its carrying capacity indicated in cars per minute. Determine the total capacity (maximum) between A and E of the freeway system (assum..
|