The Nosmell Nutrient Compnay has placed an order for the coming month for 500 tons of nitrate, 800 tons of phosphate, and 1,200 tons of potash. The company blends these ingredients together with certain inert ingredients (that are available in unlimited supply) to make three popular fertilizer mixes that is sells to retailers around the country. Their ovjective is to maximize profits in the coming month.
The three basic fertilizers are 5-10-5, 5-10-10, and 12-10-5, the numbers representing the percentage (by weight) of nitrate, phosphate, and potash in each of the mixes. The remainder of the mixture is made up of the inert material that is available in unlimited supply. The cost of the fertilizer is (per ton): Nitrate = $280, Phosphate = 90, Potash = 179, and Inert ingredients = $20. Costs of mixing, packaging, and selling are identical for all three mizes and amount to $25 per ton. Prices for the fertilizer are (per ton): 5-10-5 = $80, 5-10-10 = 100, and 12-10-5 = $120. In addition, there is a sales commitment to deliver 400 tons of 5-10-5 from the current order.
a. Express this problem as an algebraic set of equations.
b. Set up and solbe the problem using Excel. You may use either Solver or QM.
c. What is the restrictive ingredient?
d. What is the impact if there is 10% more of this ingredient available?
e. Suppose that it costs 25% more for the additional quantity of this ingredient. How will that affect the optimal solution?
f. What are the management implications of using this technique?

Posted Date: 3/3/2012 8:36:59 PM | Location : United States

Ask an Expert

Related Discussions:- Maximize profits, math, Assignment Help, Ask Question on Maximize profits, math, Get Answer, Expert's Help, Maximize profits, math Discussions

Write discussion on Maximize profits, math
Your posts are moderated

Write your message here..

Related Questions

What is economic utility of marketing, What is economic utility of marketin... What is economic utility of marketing? Economic Utility of Marketing: The extent to that, a product satisfied customer requirements and wants is called utility. The amount

Value, what is modern and traditional value delivery approach??? what is modern and traditional value delivery approach???

TEST MARKETING, Explain the various approaches that are followed by FMCG CO... Explain the various approaches that are followed by FMCG COMPANIES IN TEST MARKETING

Seal-dip pricing, seal-dip pricing seal-dip pricing

Use of pareto principle, 1. How do you use the indicators on your car dashb... 1. How do you use the indicators on your car dashboard? It's worth taking a moment to think about how the car's performance (KPIs) is conveyed through the dashboard of the car. Thi

Factors infkuencing company strategy, factors infkuencing company strategy factors infkuencing company strategy

Advantages of making sales forecasts, Question 1: (i) Describe the sto... Question 1: (i) Describe the storage facilities for the receipt of goods from suppliers. (ii) What are the factors involved in the arrangement of food in the store? (ii

Why sales promotion is an integral part of marketing, Question 1: Why s... Question 1: Why sales promotion is an integral part of marketing? How does it differ from marketing and advertising? - Detail explanation on ‘Meaning and Importance of Sale

Needs of marketing and customers, What are the needs of marketing and custo... What are the needs of marketing and customers? Marketing surrounded through customer needs: Marketing starts along with the customer requirements and needs. Such are turned with

What is life style in the consumer behaviour, What is life style in the con... What is life style in the consumer behaviour? Life Style: This is a pattern in that people live and spend their time and money. These are depends on consumer’s learning,