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

Case study, how should shoppers'' stop develop its demand forecasts?

how should shoppers'' stop develop its demand forecasts?

What is economic utility of marketing, What is economic utility of marketin...

What is economic utility of marketing? Economic Utility of Marketing: The extent to that, a product satisfied customer requirements and wants is called utility. The amount

What is maturity stage in marketing strategies, What is Maturity Stage in m...

What is Maturity Stage in marketing strategies? Maturity Stage: a. Try to convert non users in utilize of product. b. Enter latest market segments. c. Try to along

Illustrates advertisement and ethics together in points, Illustrates Advert...

Illustrates Advertisement and Ethics together in points? Advertisement and Ethics: Points of both illustrated below: a) The Advertising Standards Council of India (ASC

Illustrates the social environment in marketing activities, Illustrates the...

Illustrates the Social Environment in marketing activities? Social Environment: Social Environment Living standards and quality of life Green movement: the trend occurri

Environmental Apprisal, Why is environmental appraisal important for an org...

Why is environmental appraisal important for an organization

CONSUMER, CONSUMER MIND IS A BLACK BOX DISCUSS

CONSUMER MIND IS A BLACK BOX DISCUSS

Description of algebra, In algebra, it seems appropriate that a sequence of...

In algebra, it seems appropriate that a sequence of content designed to help mother and father better comprehend Algebra's primary ideas should start with a description of Algebra

How marketing techniques ensured a competitive advantage, The Intercontinen...

The Intercontinental Hotels Group (IHG) has over 4,000 hotels worldwide. IHG owns Holiday Inn (a medium-price hotel chain), Holiday Inn Express (a budget chain), Candlewood Suites

Marketing plan , Your first assignment is to create a brand name, perform a...

Your first assignment is to create a brand name, perform a name search online and create a relevant logo that reinforces the brand. The university liked the idea of “engaged and

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