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

Explain the key factors to successful crisis management, Question 1: Th...

Question 1: The most important test for any organization comes when it is hit by a major accident or disaster. It is required to manage such emergencies intelligently and forth

How marketing research is investigated the consumer needs, How marketing re...

How marketing research is investigated the consumer needs? Marketing Research is a systematic and intensive investigation of all the phases of marketing on a continuous basis w

Test marketing, various approaches that are followed by fast moving consume...

various approaches that are followed by fast moving consumer goods companies in test marketing

Develop a strategy for work plan, Develop a strategy to help work teams imp...

Develop a strategy to help work teams implement change       1. Develop a work plan including timetable, key performance indicators, training needs, occupational health and safe

Image and voice of nursing, Purpose: The purpose of this paper is for the ...

Purpose: The purpose of this paper is for the student to reflect on the historical and current image and voice of nursing and the profession of nursing are affected. The student w

Corporate governance, Which is NOT a benefit of corporate governance?  ...

Which is NOT a benefit of corporate governance?  Prevention of fraudulent claims by contractors.

Operational beheavior.., what would you suggest to avoid delays in despatch...

what would you suggest to avoid delays in despatch of products

Conic section, The straight line y=x+3 cuts the circle x^2+y^2-6x-4y-3=0 at...

The straight line y=x+3 cuts the circle x^2+y^2-6x-4y-3=0 at points P and Q, where Q lies in the first quadrant. Calculate the coordinates of P and Q. Then, state the coordinates

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