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

D, concepts of core market?

concepts of core market?

Black box, consumer mind is a black box -discuss

consumer mind is a black box -discuss

What are the marketing objectives, What are the marketing objectives Th...

What are the marketing objectives This mix is assembled keeping in mind the needs of target customers and it varies from one organisation to another depending upon its availabl

Companys marketing audit process, Question 1: You are a marketing assi...

Question 1: You are a marketing assistant for a manufacturer of a branded range of household cleaning products: (a) Describe key factors that could be taken into account wh

Organisation''s need for additional staff, Identify FIVE factors that shoul...

Identify FIVE factors that should be taken into account when forecasting an organisation's need for additional staff. Future Operations/demand Future planned levels of org

Decision making model in organisations, Question 1 "Negotiation is a po...

Question 1 "Negotiation is a powerful method for resolving conflict which needs skill, and experience. Negotiation will be viewed as either hard or soft. It will be a positi

What is granular disintegration, What is granular disintegration In dr...

What is granular disintegration In dry climates a yet another  mechanism operates much like frost action, in this process the ground water is drawn to the surface, which on ev

Undermining the position of women - ethical aspects of ads, Q. Undermining ...

Q. Undermining the Position of Women - ethical aspects of ads? A few ads are undermine the position of aged persons, women. In a few cases women are shown as sex-object. They a

New products development process, New products development process: Id...

New products development process: Idea generation: the development of the new product starts with a generation of new ideas. There may be a number of sources of the ideas gen

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