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

Methods of setting the promotion budget, QUESTION a) "Increasingly, com...

QUESTION a) "Increasingly, companies are using direct marketing to reach carefully targeted customers more efficiently and to build stronger, more personal, one-to-one relation

301, value pricing products

value pricing products

#title.test marketing, what is test marketing ? explain the various approac...

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

Presentation on event planning group, The Company President has asked your ...

The Company President has asked your 'event planning group' to prepare a report and presentation on a possible 4 day 'get-away' for the company's TOP GUN sales leaders as of Decemb

Define the marketing communications strategies, Define the marketing commun...

Define the marketing communications strategies Currently numerous definitions refer to an integrated perspective. This view has gathered momentum over the last 10 years and is

Unfair trade practices of MRTP act, Unfair Trade Practices of MRTP Act ...

Unfair Trade Practices of MRTP Act For preventing deceptive as well as misleading advertisement MRTP Act has declared convinced trade practices as unfair. These inequitable Tra

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#

Differential between old and new concept of the marketing, Differential bet...

Differential between old and new concept of the marketing Basic of difference Old concept of the marketing New concept of the marketing

Illustrate the term market and its managing, Illustrate the term market and...

Illustrate the term market and its managing. We comprehend a market like the set of all actual and potential buyers of a service or product, and we control the marketing by ana

#title., what are the pricing objectives?

what are the pricing objectives?

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