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

Total outsourcing of cis for wv8, WV8 is a large not for profit (NFP) publi...

WV8 is a large not for profit (NFP) public sector organisation responsible for organising the operation of publicly financed schools within its region. WV8 receives its income sole

Dettol, its relation with plc

its relation with plc

Marketing mix, what is the relationship between 4ps of marketing mix?

what is the relationship between 4ps of marketing mix?

Evaluate the concept of the product life cycle, Question 1: Evaluate th...

Question 1: Evaluate the concept of the "product life cycle" (PLC) as a strategic management tool. Use examples to show how components of the marketing mix alter and change in

Discuss the formulation of sales strategy, Problem 1: Discuss the formu...

Problem 1: Discuss the formulation of Sales strategy in brief. Definition of sales Strategy Formulation of Sales Strategy Transportation Problem 2: Compa

What are the problems with green marketing, What are the problems with gree...

What are the problems with green marketing? Problems with green marketing: During using green marketing the firms should overcome a number of potential problems. Those proble

Marketing audit and objectives, What is Marketing Audit, Marketing Audit is...

What is Marketing Audit, Marketing Audit is periodical assessment of marketing performance of a product. It is done with specific objectives in order to create awareness and improv

Canon comany, 3.2 Explain how distribution of Canon is arranged to provide ...

3.2 Explain how distribution of Canon is arranged to provide customer convenience

Effectiveness of marketing methods, 1.  How important do you feel the follo...

1.  How important do you feel the following attributes are for a bakery 1: Very Important       5: Not important at all Variety of Products                1 2 3 4 5

State the objectives of marketing communications, State the Objectives of m...

State the Objectives of marketing communications Objectives of this module are to:   Examine concept of exchange in the marketing context;   Assess role of promotion in t

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