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

Test marketing, explain the various approaches that are followed by FMCG co...

explain the various approaches that are followed by FMCG companies in test marketing

Managerial implications of a swot analysis, Question 1: Prepare and dis...

Question 1: Prepare and discuss the managerial implications of a SWOT analysis of a tourist transport with which you are familiar. Question 2: In managerial terms, disc

Discuss about the product line simplification, Discuss about the product li...

Discuss about the product line simplification. In certain circumstances, a company may accept the strategy of slimming or contracting the product mix this may do so by abandoni

Products and services - core marketing concept, Products and Services ...

Products and Services Marketing Offers-Services, Products and Experiences Companies introduce needs by putting forth a value proposition, a set of benefits that the

What is customer research in scope of marketing research, What is Customer ...

What is Customer Research in scope of Marketing Research? Customer Research: Research type of this category includes investigation within the customer buying behaviour abo

Old concept or product oriented concept of the marketing, Old concept or pr...

Old concept or product oriented concept of the marketing: There is the classical concept of marketing. According to this concept, marketing is a part of the production process

Explain about the decline stage of product life cycle, Explain about the de...

Explain about the decline stage of product life cycle. Decline Stage: A stage when sales demonstrate a downfall producer decides to abandon the market except only enough.

Define the concepts of marketing research, Define the concepts of marketing...

Define the concepts of marketing research. Market Research: Marketing research is the intelligence facility of a business enterprise. This implies the careful and goal st

Component of modern concept of the marketing, Component of modern concept o...

Component of modern concept of the marketing: 1.      Customer oriented: the very first and the most important base of modern concept of marketing is that it is a customer

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