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

small - scale industry products, What pricing strategy would you suggest t...

What pricing strategy would you suggest to a small - Scale Industry Products

What target market options recommend to all golf, All Golf was the first re...

All Golf was the first retail store devoted exclusively to selling Golf equipment and clothing in a medium-sized northern city. Sales were low for the first year, and then the stor

Markets, Markets The concepts of relationships and exchange lead to th...

Markets The concepts of relationships and exchange lead to the concept of a market. A market is the set of real and potential purchaser of a product. 1). originally a "mark

Selection criteria of every tool - direct marketing, Selection Criteria of ...

Selection Criteria of every tool Key criteria governing an organisation's selection and use of every tool are: 1.  Degree of control required over the delivery of the messa

Selection of an advertising agency by rates charged, Q. Selection of an adv...

Q. Selection of an advertising agency by Rates Charged? Rates Charged :- The rates offered by the advertising agency must be quite responsible. These rates must suits the pock

Describe the advantage of direct marketing, Question 1: Describe why th...

Question 1: Describe why the three segments of the very young, the working women and the elders need different advertising strategies now. Introduction Seven Sub cla

Societal marketing concept, 1.  Tell me what topics you have chosen to writ...

1.  Tell me what topics you have chosen to write about....Choose any one of the three and tell me if you could ever see a career for yourself in that company.... Even if your answe

What is structural realignment, What is Structural realignment Marketi...

What is Structural realignment Marketing communications agencies are attempting to adjust the way they can best serve interests of their clients. One of the results is structu

Define the media-frequency in advertisement, Q. Define the Media-Frequency ...

Q. Define the Media-Frequency in advertisement? Media-Frequency: Media-frequency demotes to average number of times the audience is exposed to media-vehicle in a specific per

Distinguish between quantitative and qualitative research, Question: Ma...

Question: Marketing Research plays a crucial role in any company. However, Marketing research is a time consuming and expensive process and therefore, requires careful plannin

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