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

Working of first barrier of exchange in intermediaries, Define the working ...

Define the working of first barrier of exchange in intermediaries. The primary barrier for smooth exchange results by the fact which sources of supply and centres for demand ar

Promotion mix, Developing a promotion mix is contingent on many factors, in...

Developing a promotion mix is contingent on many factors, including the type of product and the product''s attributes. Which of the four promotional methods-advertising, personal s

Buying process, what is proposal solicitation in buying process

what is proposal solicitation in buying process

How you will evaluate the broadcast of ads, How you will evaluate the broad...

How you will evaluate the broadcast, print & support media. Evaluation of Advertising Media: PRINT MEDIA:- Print media is as well known as press advertising. It is one of th

Discuss data analysis phase on shortly, Discuss data analysis phase on shor...

Discuss data analysis phase on shortly. Phase Data Analysis: When you’ve performed via online market research, now go to systematize the data you have. Note down what ar

#, market testing

market testing

Differentiate between inbound and outbound marketing, QUESTION a) Diffe...

QUESTION a) Differentiate between inbound and outbound marketing. b) The following statement was the closing statement from the case: "most businesses- including HubSpot

Business to business marketing, You have been tasked by a Salesforce Traini...

You have been tasked by a Salesforce Training firm to produce an article for their newsletter. The article is to be written as part of a special issue for trainee sales people. The

Me, if i make 22 dollars a day how much would i have if 2 days

if i make 22 dollars a day how much would i have if 2 days

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