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

Management of marketing efforts, Management of marketing efforts: Th...

Management of marketing efforts: The company wants to design and put into action the marketing mix that will be the best achieve this objective in this target markets. The r

Modules in market implementation evaluation and controlling, How many types...

How many types of modules are included in Market Implementation Evaluation and Controlling? The five modules of MIEV or Market Implementation, Evaluation and Controlling are

Short brief on drivers that influence customer behaviour, Question: Q1....

Question: Q1. Name and give a short brief on drivers that influence customer behaviour. Q2. Name and give a short brief on what do consumers want? Q3. Explain in your own

Identify the knowledge needs of an organisation, Question 1: (a) ‘Know...

Question 1: (a) ‘Knowledge is more than just an accumulation of bits of information.' Explain this statement in the light of the knowledge pyramid and the different types of

Implication for marketing discipline, Question 1: (a) Describe the mai...

Question 1: (a) Describe the main stages in the buying decision process that customers typically go through, and explain the relevance of this process to a company marketing

Entrepreneurship, 1) What are the stages described in the model of the entr...

1) What are the stages described in the model of the entrepreneurial process? What are the factors that give birth to a new enterprise and influence how it develops from an idea to

Brand building process, Brand building process: Having understood the...

Brand building process: Having understood the basis of the brand equity, let us now turn to the brand building process. As we saw earlier, brands are built over a period of t

Market defense, Market Defense  is the strategic actions that try to minim...

Market Defense  is the strategic actions that try to minimize or deter threatening activities by existing or potential competitors. Strategic moves can deter all or a few of the p

Influence of environment in marketing, Influence of environment: 1.   ...

Influence of environment: 1.       Opportunity: an event in the environment that may be favourable to a company may be suitably exploited by it for the overall benefit of the

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