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

Why is ensuring important for marketers, Why is ensuring important for mark...

Why is ensuring important for marketers? Ensuring the important for marketers in marketing : Marketers require ensuring that when adding benefits to a product, the cost

Retail management, what is the significance of retail as an industry

what is the significance of retail as an industry

Market segmentation, the ways in which the concept of segmentation, targeti...

the ways in which the concept of segmentation, targeting and positioning would be applied in improving profitability

Elaborate the term packaging, Elaborate the term packaging? Even after...

Elaborate the term packaging? Even after the branding and development of product that product desires arise to fulfil all the other aspects of marketing mix. But most physical

Basis for market segmentation, Q.   Describe how can a company divide a ma...

Q.   Describe how can a company divide a market into segments? O R Explain basis for market segmentation? Ans. :  Market may be segmented by using several relevant

MBA, Will the pricing and product policy of a multinational firm be differe...

Will the pricing and product policy of a multinational firm be different in a developed and an underdeveloped country? Justify your answer.

Marketing and Sales Management, Exploring the marketing and sales strategie...

Exploring the marketing and sales strategies utilised by your organisation or one you have researched, determine to what extent the marketing concept has been adopted. How have sa

Caselets, 1.Considering the concept of product life cycle, where would you ...

1.Considering the concept of product life cycle, where would you put video games in their life cycle? 2. Should video game companies continue to alter their products to include oth

What role does copy play in a campaign, Problem 1: What role does copy ...

Problem 1: What role does copy play in a campaign? Why copy has to be written with great knowledge and skill. All relevant points required to be addressed from Unit 6 com

Development of market segmentation, Problem 1: The development of marke...

Problem 1: The development of market segmentation and target marketing reflect the movement away from production orientation towards marketing orientation. Discuss. Problem

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