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

Show the media-availability in advertising, Q. Show the Media-Availability ...

Q. Show the Media-Availability in advertising? Media-Availability: Sometimes it is probable that desired space for advertisements in print media is already booked by some oth

Communication plan, i need a plan for pop up shops in airports and hotels f...

i need a plan for pop up shops in airports and hotels for cosmetic products, also budgeting for 2 years

Define nature of personal selling, Define the nature of personal selling wi...

Define the nature of personal selling within significant points. Nature of personal selling: There are different types of sales jobs utilize to sell the product of the

Factors affecting the life cycle of a product, Factors affecting the life c...

Factors affecting the life cycle of a product: there are many factors that affect the life cycle of a product. Statement of Joe Dean is very important in this regard. He said, "th

Affordability based pricing, Affordability Based Pricing  : The affordab...

Affordability Based Pricing  : The affordability based pricing is relevant in regard  of  necessary  commodities,  which  meet  the  basic  requirement  of  all sections of peop

Marketing information, Marketing information: to perform the complex task ...

Marketing information: to perform the complex task of marketing the marketer needs many pieces of information as a basis for drawing marketing decisions. Market information as a b

Describe the marketing audit in detail, Question 1: Describe the market...

Question 1: Describe the marketing audit in detail. Characteristics of marketing audit Components of marketing audit Question 2: Explain consumer research p

Brand loyalty, Brand loyalty: The starting point in understanding brand...

Brand loyalty: The starting point in understanding brand equity is the extent to which a brand enjoys customer loyalty. It is important to discriminate between habitual buying

How many key elements are comprised in green marketing, How many key elemen...

How many key elements are comprised in green marketing? Definition of green marketing has three key elements: a) This is a subset of the overall marketing activity. b) Th

Business environment, assess the impact of fiscal and monetary policy on bu...

assess the impact of fiscal and monetary policy on business organisation and their activities ?

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