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

Characteristics of the consumer behaviour, Characteristics of the consumer ...

Characteristics of the consumer behaviour: Consumer behaviour or buyer behaviour is the process by which individuals decide whether, what, when, from whom, where and how muc

Factors affecting the choice of distribution channel, Factors affecting the...

Factors affecting the choice of distribution channel Choice of an appropriate distribution channel is very significant as pricing as well as promotion strategy are dependent up

What do you understand by market efficiency, Question: (a) What do you ...

Question: (a) What do you understand by market efficiency and why is it important? (b) Explain each form of market efficiency. (c) Give any one test of weak-form and semi

HENRY ASSAEL MODEL, Q-2 Explain Henry Assael Model of buying decision beh...

Q-2 Explain Henry Assael Model of buying decision behaviour along with the diagram”.

Describe the components of the promotion mix, Question 1: "Promotion p...

Question 1: "Promotion performs a significant and vital role in the marketing strategy of an organization." Using an organization of your choice, describe the component

Develop a quality management plan, XYZ Limited, finalist for the European Q...

XYZ Limited, finalist for the European Quality Award (EQA), has doubled its share of the quality carpet sector in recent years and now holds over 10 per cent of the world market fo

Examine the importance of using image attributes, The Mauritius Tourism Pro...

The Mauritius Tourism Promotion Authority (MTPA) has undertaken advertising in UK to support low season activity using creative ads that carries the headline So Many Reasons? in or

Explain about packaging in marketing function, Explain about packaging in m...

Explain about packaging in marketing functions of physical treatment. Packaging: Packaging has become one of the necessary services of modern marketing. This acts like a m

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