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?

Read the overview below and complete the activities that follow.apartment complexes often look for ways to recruit new tenants and retain current tenants. although apartment complexes offer the tangible benefit of shelter to their tenants, many apartment complexes also offer additional services to tenants to encourage tenants to stay or to support the rent prices. the following scenario identifies the several service gaps of a company that runs an apartment complex as well as solutions for reducing these service gaps.concept review: customers have certain expectations about how a service should be delivered. a service gap occurs when the delivery of a service fails to meet customer expectations. there are four types of service gaps: knowledge gap, standards gap, delivery gap, and the communications gap. it is important for marketers to identify these gaps and develop strategies for minimizing them.match the example or solution to the appropriate service gap category.1. wait for repairs 5. train employees well2. understand expectations 6. incentives for tenants3. do not overpromise 7. family movie night4. empower employees 8. delayed lawn careservice gap example solutionknowledge gap standards gap delivery gap communication gap