Business, 17.06.2020 19:57 legend101xD

The Ranges explosives company produces customized blasting compounds for use in the mining industry. The two ingredients for these explosives are agent A and agent B. Ranges just received an order for 1400 pounds of explosive. Agent A costs $5 per pound and agent B costs $6 per pound. The customer's mixture must contain at least 20% agent A and at least 50% agent B. The company wants to provide the least expensive mixture which will satisfy the customers requirements. Required:
a. Create an EXCEL spreadsheet of LP model showing attention to both accuracy and presentation.
b. Use Analytic Solver Platform to verify graphical solution.
c. Which constraints are binding?
d. Which constraints show slack?

e. Create a Sensitivity Report; perform an analysis by answering questions below.

1. Is the optimal solution degenerate? Explain why or why not.
2. Is the optimal solution unique? If not, identify an alternate optimal solution for the problem.
3. What is the highest value the objective function coefficient X1 can assume without changing the optimal solution?

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 19:40

The common stock of ncp paid $1.35 in dividends last year. dividends are expected to grow at an annual rate of 5.30 percent for an indefinite number of years. a. if ncp's current market price is $22.57 per share, what is the stock's expected rate of return? b. if your required rate of return is 7.3 percent, what is the value of the stock for you? c. should you make the investment? a. if ncp's current market price is $22.57 per share, the stock's expected rate of return is

Answers: 3

Answer

Business, 22.06.2019 21:00

Kendra knight took part in a friendly game of touch football. she had played before and was familiar with football. michael jewett was on her team. in the course of play, michael bumped into kendra and knocked her to the ground. he stepped on her hand, causing injury to a little finger that later required its amputation. she sued michael for damages. he defended on the ground that she had assumed the risk. kendra claimed that assumption of risk could not be raised as a defense because the state legislature had adopted the standard of comparative negligence. what happens if contributory negligence applies? what happens if the defense of comparative negligence applies?

Answers: 2

Answer

Business, 22.06.2019 22:40

Southeastern oklahoma state university's business program has the facilities and faculty to handle an enrollment of 2,000 new students per semester. however, in an effort to limit class sizes to a "reasonable" level (under 200 generally), southeastern's dean, holly lutze, placed a ceiling on enrollment of 1,600 new students. although there was ample demand for business courses last semester, conflicting schedules allowed only 1,440 new students to take business courses.the utilization rate for southeastern=%the efficiency rate for southeastern=%

Answers: 3

Answer

Business, 22.06.2019 23:00

To increase sales, robert sends out a newsletter to his customers each month, letting them know about new products and ways in which to use them. in order to protect his customers' privacy, he uses this field when addressing his e-mail. attach bcc forward to

Answers: 2

Answer

You know the right answer?

The Ranges explosives company produces customized blasting compounds for use in the mining industry....

Questions