Maximize profits, math, Marketing Management

Assignment Help:
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?

Related Discussions:- Maximize profits, math

Mobile Wallet Payment value chain, How does the mobile wallet payment value...

How does the mobile wallet payment value chain look like? And where in the payment value chain can we place the mobile wallet service?

Brand promotion, promotion technique can benefit an organization by increas...

promotion technique can benefit an organization by increasing its sales or hitting competitive brands may leave a negative impression on the customers

What are the complexity of the communications, What are the complexity of t...

What are the complexity of the communications Exchanges which organisations enter into require the formation of relationships, though tenuous or strong. Andersson (1992) looks

Consumer preference for co-branded financial product, please confirm me whe...

please confirm me whether the topic is apt to find dependency of consumer preference on products like max-bupa,tata aia, bajaj-allianz etc..

Societal marketing concept, The Societal Marketing Concept The societa...

The Societal Marketing Concept The societal marketing concept holds that the organization should find out the needs, wants, and interests of focused markets. Then It should de

Put video games in their life cycle, considering the concept of product lif...

considering the concept of product life cycle, where would you put video games in their life cycle

Define nature of personal selling, Define the nature of personal selling wi...

Define the nature of personal selling within significant points. Nature of personal selling: There are different types of sales jobs utilize to sell the product of the

What are the ways devised in competition by theodore levitt, What are the w...

What are the ways devised in competition by Theodore Levitt? Several of the ways devised in words of Theodore Levitt to outsmart the competition are as: a. Be a customer led

Diagram, Henry Assael Model of buying decision behavior along with thediagr...

Henry Assael Model of buying decision behavior along with thediagram

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd