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

Communication plan, i need a plan for pop up shops in airports and hotels f...

i need a plan for pop up shops in airports and hotels for cosmetic products, also budgeting for 2 years

Role of advertising agencies in distribution channels, What is the role of ...

What is the role of advertising agencies in distribution channels? Advertising agencies: Such facilitating agencies help within facilitating negotiation, through creating

Distinguish between visible and non-visible cultures, Each country or regio...

Each country or region has a specific culture which is due to similarities in religion, language, beliefs and values. This could result in a "cultural challenge for international m

What are the advantages of public relations, What are the Advantages of Pub...

What are the Advantages of Public Relations? Advantages of Public Relations are as illustrated below: a) This helps in building and having relations along with local comm

Demand level for the company, A company manufactures sailboats. Actual Dem...

A company manufactures sailboats. Actual Demand for the company's sailboat during each season is 2006 through 2009 were as follows: Season        2006             2007

Explain the marketing communications mix, Explain the Marketing Communicati...

Explain the Marketing Communications Mix Marketing communications mix comprises a set of tools (disciplines) which can be used in various combinations and different degrees of

Calculate total cash interest payment, Jump Up Corporation issued five-year...

Jump Up Corporation issued five-year, 5% bonds with a face value of $800,000 on January 1, 2011.  Interest is paid annually on December 31.  The market rate of interest on this dat

Wordings of s.j. skinner for organizational buying behaviour, What are the ...

What are the wordings of S.J. Skinner about organizational buying behaviour? In words of S.J. Skinner as, “Organisational buying behaviour consider as the actions  and  decis

Environmental scanning, Environmental scanning: Future is unpredicta...

Environmental scanning: Future is unpredictable, but the marketer can obtain appraisals of what is most probable. To monitor changes in the marketing environment effectively

State the concept of product and its classification, State the Concept of p...

State the Concept of product and its classification Product refers to the goods and services which are offered by organisation for sale. Here the marketers have to recognise th

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