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

Explain the awareness to creative advertising, Question: You have just ...

Question: You have just won a National Best Creative award from Association Advertising Agencies and is being interviewed by a journalist. (a) He asks, according to you a

Product planning and development, Product planning and development: In...

Product planning and development: In the modern competitive situation, producers try to bring out suitable products, which are closer to and more attractive than the substitut

What are cognitive measurement of customer satisfaction, What are cognitive...

What are cognitive measurement of customer satisfaction? Cognitive Measures of Customer Satisfaction Measurement: A cognitive tools is defined as an appraisal or conclusio

Miss, What is Blackberrys situational analysis and market position

What is Blackberrys situational analysis and market position

Explain the product life cycle concept, Problem : a) A Mauritian consum...

Problem : a) A Mauritian consumer goods firm is deciding whether to enter the United States market or the Asian market. Show why it should take into account different marketing

What are the ways to indirect or direct export or production, What are the ...

What are the ways to indirect or direct export or production within a foreign country? There are a variety of ways in that organizations can enter foreign markets. The major wa

Marketing Management, what are the significant factors that have led to the...

what are the significant factors that have led to the success of shoppers’ stop

What moral rights does an author have on his work, QUESTION 1 A compute...

QUESTION 1 A computer contract is often in written form. What provisions would you expect to find in such a contract? QUESTION 2 (a) Mr & Mrs Williams have launched a n

Nature of the marketing, Nature of the marketing: 1.      Specialized ...

Nature of the marketing: 1.      Specialized business function: in the early days, the selling function did not call for any specialized skills as the sales could have been a

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