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

Geometry, excircle? excircle?

Explain fully why and how government intervenes, QUESTION a) Explain fu... QUESTION a) Explain fully why and how government intervenes in the foreign exchange market b) "Changes in the equilibrium exchange rate between a pair of currencies relies o

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

Production concept, The Production Concept The manufacture concept hol... The Production Concept The manufacture concept holds that consumers will favour products that are available and extremely affordable and that management  should,  then,  focus

How is customer satisfaction affected in marketing, How is customer satisfa... How is customer satisfaction affected in marketing? As demonstrated in figure, customer satisfaction is affected by perceived quality of service and product attributes, benefit

Description of algebra, In algebra, it seems appropriate that a sequence of... In algebra, it seems appropriate that a sequence of content designed to help mother and father better comprehend Algebra's primary ideas should start with a description of Algebra

What is direct marketing, What is Direct Marketing Growing utilisation ... What is Direct Marketing Growing utilisation of direct marketing by organisations over recent years has been significant. It signals a shift in focus from mass to personalised

Describe the six components of business models, Question 1 How does e-busin... Question 1 How does e-business differ from the traditional business mechanism? Question 2 Describe the six components of business models Question 3 What is virtual private ne

Factors affecting pricing decisions, Factors affecting pricing decisions: ... Factors affecting pricing decisions: the pricing decisions are influenced by the many factors. The price policies should be consistent with the pricing objectives. The influence f

Marketing plan-introducing eco-friendly product, Marketing plan - Introduci... Marketing plan - Introducing Eco-Friendly Product Based on a selected company, a student is required to conduct a systemic and detailed marketing plan of a new product offering