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

.brand promotion, hitting competitive brands may leave a negative impressio...

hitting competitive brands may leave a negative impression on the customers? Justify your answer.

Define the market intelligent enterprise, Question 1: Leading edge comp...

Question 1: Leading edge companies are driving to increase profits from high yield customers. They aim to acquire and retain profitable customers and get them to spend more. Th

Explain the term- length of purchase decision time, Explain the term- Lengt...

Explain the term- Length of purchase decision time Length of time taken to reach a decision is much greater in organisation market. This means that intensity of any media pl

What are the durable goods, What are the Durable Goods   Durable good...

What are the Durable Goods   Durable goods are products that are used for a long period i.e., for months or years together. Illustrations of such goods are refrigerator, car,

Prepare a presentation on new products, Question 1 (a) Relate the impor...

Question 1 (a) Relate the importance of well linking any visual aid to its specific message and explain the functions that visual aids can have. (b) The marketing officer of

Cyclical or stable earnings, When founded, when listed • Major lines of bus...

When founded, when listed • Major lines of business • Market share • Ranking within industry (e.g., largest of four companies...) • Exports • Major institutional owners (if any), p

What is demographic segmentation, What is Demographic Segmentation? D...

What is Demographic Segmentation? Demographic Segmentation: This characteristic as like age, sex, income, marital status, occupation as well as education are most frequen

Explain about the promotion strategies, Explain about the Promotion Strateg...

Explain about the Promotion Strategies. Promotion Strategies: The promotion strategies of a global marketing organization comprise advertising, promotion, sales, publicit

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