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

Marketing function of the physical supply, Function of the physical supply:...

Function of the physical supply: The second group of the marketing process is the physical supply. These are the functions that are related with creation of place and time u

Growth stage - product life cycle, Growth Stage The growth stage is th...

Growth Stage The growth stage is the manufacture life-cycle stage during which a product's sales begin climbing rapidly.    Early adopters will continue purchasing and l

Case, Should video game companies continue to alter their products to inclu...

Should video game companies continue to alter their products to include other functions, such as e-mail

Implement the product development strategy, Question: a. With referenc...

Question: a. With reference to appropriate theory, explain how a product development strategy could be implemented to expand sales within a Fast-Moving Consumer Goods (FMCG) o

Main advantages of keeping an in-house is function, Identify FIVE main adva...

Identify FIVE main advantages of keeping an in-house IS function.   There are several significant advantages of maintaining an in-house IS function, five are listed below. H

Cannibalization Analysis (Marketing) Tutor Needed, I''m looking for a Marke...

I''m looking for a Marketing Ph.D. student or a graduate to help me understand Cannibalization Analysis. You can be a Marketing undergrad or an MBA with the knowledge. As long as y

Effectiveness of the promotional tools, Effectiveness of the Promotional To...

Effectiveness of the Promotional Tools Every element of promotions mix has different capacities to communicate and to achieve different objectives. Effectiveness of each tool

How is marketing an indispensable activity, How is marketing for any organi...

How is marketing for any organization an indispensable activity? “Marketing is an indispensable activity for any organization”. Well I am agreeing with the declaration, because

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