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

Success of shoppers stop, what are significant factors that have led to the...

what are significant factors that have led to the success of shoppers'' stop? at least 200 words

Ten principles of reinvention , As per the Osborne and Gaebler, governments...

As per the Osborne and Gaebler, governments don't work well, since they are tall, sluggish, over-centralized, and preoccupied with diverse rules and regulations."We developed publi

Marketing, How should Shoppers’ Stop develop its demand forecasts?

How should Shoppers’ Stop develop its demand forecasts?

Give a documentary, (a) Show one movie genre of particular interest to you ...

(a) Show one movie genre of particular interest to you and give examples from relevant films to illustrate the conventions used. To what extent do you think that genre conventions

Sales force management in rural marketing, Sales force management : as a ge...

Sales force management : as a general rule, rural marketing involves more intensive personal selling effort compared to urban marketing. Rural marketing calls for some specific

Describe the seven core value groups, Problem a) Name and explain the...

Problem a) Name and explain the five determinants that are pertinent to an individual's purchase situation. b) Explain a purchase repertoire (or evoked set) and criticall

Export and import procedures and documentation., What are the procedures of...

What are the procedures of export under deferred paymente?

What is pricing in functions of marketing, What is pricing in functions fac...

What is pricing in functions facilitating exchange? Pricing: Determination of price of a product is a significant function of marketing manager. Product’s price is influen

Explain the steps in outlining advertising budget, Q. Explain the Steps in ...

Q. Explain the Steps in outlining advertising Budget? Steps in outlining advertising Budget 1) Setting advertisement Objective: - Prior to deciding on advertising budget the

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