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

Service offered by ad-agency, Service Offered by Ad-agency :- These days ad...

Service Offered by Ad-agency :- These days ad agencies give wide range of services like planning and preparation of ad and execution of ad with selection of media, sales promotion,

Features of marketing information system, Features of Marketing Information...

Features of Marketing Information System: 1.  Data are regularly collected. They are contionously updated as environmental conditions change. 2. The data are converted into

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

"How has your iPhone changed your career?", "How has your iPhone changed yo...

"How has your iPhone changed your career?" Please respond to the following: Identify two (2) technological innovations that have changed the fundamental manner in which companies

Strategic aspects in international human resource management, Question 1: ...

Question 1: Explain how effective management of expatriates is increasingly been recognised as a major determinant of success or failure for international businesses. Quest

#titsecondary source, list out the secondary sources of information while p...

list out the secondary sources of information while pursuing market research?

What are the characteristics of a knowledge worker, Question 1: (a) Wh...

Question 1: (a) What are the characteristics of a knowledge worker and how do they differ from those of the traditional worker? (b) Using relevant examples, illustrate how

How the personal characteristics of the buyer influence, Question 1: Co...

Question 1: Consider that you are the manager of front-line customer-service employees in a tourism/hospitality organisation. From this perspective, elaborate on the strategie

Sales volume and market share of the company, Question:   XYZ Company ...

Question:   XYZ Company is producing and marketing cotton textiles to local markets. Currently, because of stiff competition its sales volume is decreasing from time to time.

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