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

Jbhj, consumer profile of typical buyer of rayban

consumer profile of typical buyer of rayban

What are the several types of promotional schemes, What are the several typ...

What are the several types of promotional schemes? Different types of promotional schemes are distributed within the following manner as given here: a) Consumer-promotion to

What are physical distribution firms, What are physical distribution firms?...

What are physical distribution firms? Physical distribution firms: Transportation, warehouse and other firms which help a company to stock and move goods by their point

Organizing sales promotion compagins, Organizing sales promotion compagins ...

Organizing sales promotion compagins 1.       Identifying the requirement: the first requirement is to identify the specific requirement of the firm in resg orting to sales p

Illustrate the term market and its managing, Illustrate the term market and...

Illustrate the term market and its managing. We comprehend a market like the set of all actual and potential buyers of a service or product, and we control the marketing by ana

Advise the company on the campaign objectives, Question: The Radisson I...

Question: The Radisson International established in Mauritius since 2002 recently faced a big scandal. There was a serious problem of contamination in the food that was serv

Price, Price "The amount of money charged for a product or service, or...

Price "The amount of money charged for a product or service, or the total of the values that consumers exchange for the benefits of having or by using the service or product".

First in Asia and the world, 1. As the first to set up an international air...

1. As the first to set up an international air express business in 1969, DHL had the first- mover advantage over other companies. Is being a first mover as advantageous for a servi

Consumer surplus, Initially supply falls as goods may be destroyed. As the ...

Initially supply falls as goods may be destroyed. As the disaster strikes, the demand also rises in anticipation of more supply disruptions as people want to 'stock up' on the good

Marketing - introduction, Marketing Marketing involves the right produ...

Marketing Marketing involves the right product available in the right place at the accurate time and ensure that the customer is aware of the product. Marketing is necessar

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