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

Test Marketing, what is test marketing? explain the various approaches that...

what is test marketing? explain the various approaches that are followed by FMCG companies in test marketing.

Segment interrelationships and super -segments, Segment interrelationships ...

Segment interrelationships and super -segments In selecting more than one segment to serve, the company a company would-be wise to enter one segment at a time without revealing

What are affective measures of customer satisfaction, What are affective me...

What are affective measures of customer satisfaction? Affective Measures of Customer Satisfaction Measurement: A consumer’s attitude as liking or disliking towards a produ

What is sales research in scope of marketing research, What is Sales Resear...

What is Sales Research in scope of Marketing Research? Sales Research: Sales research comprises decision concerning selection of store channels, sales; territories force

States the term product line and discuss in brief, States the term Product ...

States the term Product Line and discuss in brief. Product Line: This is a group of products which is closely related since they perform a similar function, targeted at s

Describe the six components of business models, Question 1 How does e-busin...

Question 1 How does e-business differ from the traditional business mechanism? Question 2 Describe the six components of business models Question 3 What is virtual private ne

Explain the various stages of the product cycle, Question 1: Explain th...

Question 1: Explain the various stages of the product cycle and explain why it is necessary to follow the procedures regarding this cycle. Question 2: (i) Explain the

What is cross-cultural consumer analysis, Question 1: (a) Discuss Freud...

Question 1: (a) Discuss Freudian Theory of Personality and its application to the understanding of consumer behaviour. (b) For the following personality market segments, desc

What are the financial intermediaries, What are the financial intermediarie...

What are the financial intermediaries? Financial intermediaries: Credit companies, banks and other businesses which help finance transactions or cover against the risks

Advantages of the advertising, Advantages of the advertising: 1.       ...

Advantages of the advertising: 1.       It increases the sales volume: advertising increases the sales volume of the product. Hence mass production is possible. This leads, to

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