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

Retailing, Evaluate the priomotional strategies that can be used by retaile...

Evaluate the priomotional strategies that can be used by retailers

Principle of efficient clint agency relationship, Q. Principle of efficient...

Q. Principle of efficient Clint Agency Relationship? Principle of efficient Clint Agency Relationship:-following points improve the CAR effective. 1) Not to advertise for Im

Consumer adoption process and its various stages, The consumer adoption pro...

The consumer adoption process and its various stages are as follows: Consumer adopts the use of product according to his needs and his own decisions. Adoption process is just li

Frederick herzberg''s dual factor, Explain the relationship between Frederi...

Explain the relationship between Frederick Herzberg's dual (two) factor motivation theory and job enrichment. Hygiene factors contain pay, status, working conditions, rules and

Music2GOMulti-player, music2GOmulti-player marketing strategy review

music2GOmulti-player marketing strategy review

Challenges facing a customer centric organization, The world is changing dr...

The world is changing dramatically with the internet becoming increasingly the panacea for all things that touch the customer and the customer-facing processes. However an enterpr

Define the concept of marketing information system, Define the concept of M...

Define the concept of Marketing Information System. Meaning of Marketing Information System : Marketing Information system is systems which consist of people, procedu

Developing and Qualifying Prospects and Accounts, Think about a specific sa...

Think about a specific sales job with a specific company that you might want to do. Then,if you were starting your own prospect list, explain in detail how you would use your own

Jaguar''s passage to india, #question.Tata Motors recently introduced the n...

#question.Tata Motors recently introduced the nano,the world''''s least expensive car for the indian market.Can Tata succeed in targeting both the very low end of the auto market a

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

What are the advantages of licensing in marketing? Licensing comprises little involvement and expense. The simply cost is signing the policing and agreement its implementatio

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