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

Reasons of channels distribution in economic system, What are the reasons o...

What are the reasons of channels of distribution in economic system? Channels of distribution in any specified economic system emerge due to the following reasons: Effici

#titsecondary source, list out the secondary sources of information while p...

list out the secondary sources of information while pursuing market research?

What is influence of the human resource information system, What is influen...

What is influence of the human resource information system? Affect of Human Resource Information System (HRIS): Firms have invested upon the software for P+R as Oracle, S

Steps in mis design, Steps in MIS design: 1.       Define the system: ...

Steps in MIS design: 1.       Define the system: the system for which design is to be made has to be defined; in the terms of elements, the relationship and its boundries. Th

Trignometry, 2(cosx+cos2x)+sin2x(1+cos2x)=2sinx

2(cosx+cos2x)+sin2x(1+cos2x)=2sinx

Differentiating between Services and Goods, Differentiate between Services ...

Differentiate between Services and Goods and explain the areas in which the attributes of services create needs in the marketing mix?

Describe the marketing audit in detail, Question 1: Describe the market...

Question 1: Describe the marketing audit in detail. Characteristics of marketing audit Components of marketing audit Question 2: Explain consumer research p

State the objectives of marketing communications, State the Objectives of m...

State the Objectives of marketing communications Objectives of this module are to:   Examine concept of exchange in the marketing context;   Assess role of promotion in t

Explain benefits of undertaking market segmentation, Question: a) The ...

Question: a) The consumer electronics firm for which you work is about to launch a new model of mobile telephone (cell phone and hand phone). This will be a very basic model o

Oligopoly market, Oligopoly Market The majority of the world’s diamonds com...

Oligopoly Market The majority of the world’s diamonds comes from Country A and Country B. Suppose that the marginal cost of mining a diamond is $1,000 per diamond and that the dema

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