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

Create a graph of widget sales, Q1 Create a graph of widget sales on the t...

Q1 Create a graph of widget sales on the tab "Q1-Graph" and characterize the time series.  That is, does the time series appear to include the effects of ( 1 ) cyclicality, ( 1 )

Second barrier of exchange in channels distribution, Illustrates the workin...

Illustrates the working of second barrier of exchange in channels distribution? The second barrier to smooth exchange procedure arises due to time of production and the time at

Illustrate the term -a world of marketing communications, A World of Market...

A World of Marketing Communications All organisations - small and large, commercial, government, charities, educational and other not-for-profit organisations - need to communi

Product branding, Product branding: Meaning & definition: a brand is ...

Product branding: Meaning & definition: a brand is a "name, term, symbol or design to identify the goods or services and to different them from those of the companies". A bra

Selling, bwhaviour is like smoke sellers waste useful periods in studying b...

bwhaviour is like smoke sellers waste useful periods in studying buyers behaviour conduct a reasearh on why and highlight five reasons.

Implement a crm system solution, Question: "If a decade ago, we had had...

Question: "If a decade ago, we had had a greater understanding of the business and organizational dynamics of technology, I think we would now have an even greater payback from

What points are really matters while doing marketing, What points are reall...

What points are really matters while doing marketing? Whether online or offline, there are only two objects that important: “Buying and Selling”. Fundamentally to simplify, thi

Approaches to environmental scanning, Approaches to environmental scanning:...

Approaches to environmental scanning: 1.       Systematic approach: in this approach, formats for various issues are developed and is done systematically in a step by step fa

What do you mean by business to business in e-commerce, What do you mean by...

What do you mean by Business to Business in e-commerce? B2B stands for Business to Business , it is the type of e-commerce. This is a mode of conducting business among two

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