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

Introduction to marketing communications, Introduction to Marketing Communi...

Introduction to Marketing Communications Marketing communications is a management process through which an organisation engages with its variety of audiences. Through understan

Give the example of direct marketing, Give the example of direct marketing ...

Give the example of direct marketing For instance, charges for packing and delivery need to be incorporated. Product may also need to be altered or adapted to the market. For i

What moral rights does an author have on his work, QUESTION 1 A compute...

QUESTION 1 A computer contract is often in written form. What provisions would you expect to find in such a contract? QUESTION 2 (a) Mr & Mrs Williams have launched a n

State the methods of price fixation, State the Methods of price fixation ...

State the Methods of price fixation Methods of fixing price can be broadly divided into the subsequent categories. 1. Cost based pricing 2. Competition based pricing 3

#title.a marketing plan and implementation, a marketing plan is as good as ...

a marketing plan is as good as its implementation discuss

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

What do you mean by promotion mix, Q. What do you mean by Promotion Mix? ...

Q. What do you mean by Promotion Mix? Promotion mix is a particular mixture of promotion tools used by a company to communicate with the audiences. There are 5 main tools sales

Define the publicity - promotion, Define the Publicity - Promotion Th...

Define the Publicity - Promotion This is a non-paid process of generating wide range of communication to contribute a favourable attitude towards product and organisation.  Y

What are the several advantages of business to business, What are the sever...

What are the several advantages of Business to Business? Some of the advantages of Business to Business are: a. Enhanced customer satisfaction b. Enhanced inventory syste

State about the measurement and evaluation, State about the Measurement and...

State about the Measurement and evaluation Consumer market uses a variety of techniques to evaluate the effectiveness of communications. In organisation market, sales volume

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