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

Product line apprisal, How the product line appraisal is important task?

How the product line appraisal is important task?

I do not want this account, I request to be removed from your accounts. I ...

I request to be removed from your accounts. I do not wish to have your services---question #Minimum 100 words accepted#

Competitiveadvantages, importance of Balancing Customer and Competitor Orie...

importance of Balancing Customer and Competitor Orientations

Ray ban, how to draw consumer profile of a typical buyer of ray ban?

how to draw consumer profile of a typical buyer of ray ban?

Ghost shopper, Ghost Shopper Ghost shopper is a marketing expert, posin...

Ghost Shopper Ghost shopper is a marketing expert, posing as a regular consumer, who is hired to monitor and evaluate the presentation skills and salesmanship of the store's sa

Describe the role for marketing communications, Describe the role for marke...

Describe the role for marketing communications It leads to a new form of and role for marketing communications, and to a vision that an organisation's entire marketing communic

Explain the role of direct marketing, Q. Explain the Role of direct marketi...

Q. Explain the Role of direct marketing? Role of direct marketing:- a) Focus is on literate customer. b) For service marketing like insurance, Banking, telecommunication.

Product mix, "A Product mix (also called product assortment) is the set of...

"A Product mix (also called product assortment) is the set of all product lines and items that a particular seller offers for the sale to buyers". An organization with the several

Illustrate the term -a world of marketing communications, A World of Market...

A World of Marketing Communications All organisations - small and large, commercial, government, charities, educational and other not-for-profit organisations - need to communi

Explain in detail about the marketing communications, Explain in detail abo...

Explain in detail about the Marketing communications Marketing communications provides the means by which organisations and brands are presented to their audiences. Goal is to

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