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

Marketing planning, Marketing planning: Meaning and definition: marke...

Marketing planning: Meaning and definition: marketing planning is a part of the process of overall planning of a business and industrial enterprise. Marketing planning includ

Value pricing, Value  Pricing   :  Value  pricing  is  a  modern  innovati...

Value  Pricing   :  Value  pricing  is  a  modern  innovative  and  individual method of pricing. Value pricing rests on the principle that the reason of pricing is not to recover

What is multi channel marketing?, After their first arrival, the telephone,...

After their first arrival, the telephone, email, fax, mobile phone and the internet were rapidly accepted in business contacts and for doing business transactions, creating fresh c

How is network play significant role in buying decision, How is network pla...

How is network play significant role in buying decision? Network: It is a kind of buying situation in which a purchaser buys a product or services for the first time to pe

Pricing objectives, Q.   Explain the objectives of a firm seek in pricing? ...

Q.   Explain the objectives of a firm seek in pricing?                                 OR Described the various pricing objectives Ans.:  A business firm has a nu

Wordings of s.j. skinner for organizational buying behaviour, What are the ...

What are the wordings of S.J. Skinner about organizational buying behaviour? In words of S.J. Skinner as, “Organisational buying behaviour consider as the actions  and  decis

Industrial market, Industrial Market All individuals or organization th...

Industrial Market All individuals or organization that produce or acquire goods or services that are incorporated into the production of other finished goods or services subseq

What are the sorting functions of discrepancy of assortment, What are the s...

What are the sorting functions of discrepancy of assortment? The sorting function of discrepancy of assortment is performed through intermediaries who include the following act

Responsibility of devising marketing communications, CASE STUDY-  Chubb Sec...

CASE STUDY-  Chubb Security Systems Chubb, an organization noted for its locks and security systems, developed a security product particularly suited to manufacturing organizat

Marketing mix., number of channel levels of panasonic

number of channel levels of panasonic

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