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 are focus and drawback of product concept, What are focus and drawback... What are focus and drawback of product concept? Product Concept: Focus: The focus of the firms subsequent the product concept is onto the production of greater products

What is integrated marketing, What is integrated marketing? Integrated... What is integrated marketing? Integrated Marketing: The duty of a marketer is to diverse marketing activities and assembles completely integrated marketing programs to pro

Give an overview about corporate orientation to marketplace, Give an overvi... Give an overview about corporate orientation to marketplace. Marketing is the deliverance of satisfaction at a profit. This is a social and managerial procedure whereby indi

7p''s in hotel industry, i want to add the 7p''s in hotel industry i want to add the 7p''s in hotel industry

Advertising campaigns , advertising campaigns and there work in developing ... advertising campaigns and there work in developing awareness among public

Test marketing, approaches of fmcg companies in test marketing approaches of fmcg companies in test marketing

Marketing Strategy for market leaders, Explain Marketing Strategy for marke... Explain Marketing Strategy for market leaders with example.

Concept of the marketing, Concept of the marketing: Generally, marke... Concept of the marketing: Generally, marketing is understood to mean the sale and purchase of goods and services but it is narrow thinking to understand it so. The term mark

What are the levels of market segmentation, What are the levels of market s... What are the levels of market segmentation? About the Levels of Market Segmentation: The number of possible segments which will result by a segmentation analysis can be a

Competition oriented pricing, Competition Oriented pricing : competitive or... Competition Oriented pricing : competitive oriented pricing methods are regular in a competitive economy. The methods in this category rest on  the  principle  of  competitive  par