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

What are the advantages of exporting in marketing, What are the advantages ...

What are the advantages of exporting in marketing? The advantages of exporting are illustrated in below: • Manufacturing is home based therefore, this is less risky than ove

Creative skills and new ideas in ads, Creative Skills and New Ideas:- Crea...

Creative Skills and New Ideas:- Creativity is the major element of advertising. If the ad-agency is competent of generating new ideas which are creative and profitable then such a

Assignment, A manufacture of hardware products wants enter into new markets...

A manufacture of hardware products wants enter into new markets overseas. They are initially planning to market its products and establishing sales organizations in India, Banglade

What is the role of marketing information system, What is the role of marke...

What is the role of marketing information system in marketing environment? The subsystem of Marketing Information System is interrelated and interdependent so as to meet the ne

Henry assael model on buying decision behaviour, discuss the henry assael m...

discuss the henry assael model on buying decision behaviour

What is the importance of customer care, Question: When the customer pa...

Question: When the customer pays for a product or service, it is assumed that the product will work correctly or that the service received is as promised. Ideally, the customer

Major factors influencing buying behaviour, Major factors influencing buyin...

Major factors influencing buying behaviour: A consumer's buying behaviour is influenced by cultural, social, personal, and the psychological factors. Cultural factors exert

#, market testing

market testing

Describe the seven core value groups, Problem a) Name and explain the...

Problem a) Name and explain the five determinants that are pertinent to an individual's purchase situation. b) Explain a purchase repertoire (or evoked set) and criticall

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