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

7P''S, I WANT TO KNOW THE ORGANIZATION FOLLOWS 7p''s concept

I WANT TO KNOW THE ORGANIZATION FOLLOWS 7p''s concept

What is the average sales price, Your company has the opportunity to set up...

Your company has the opportunity to set up a SBU to manufacture solar panels. Your company's cash flow is very tight so you want to be sure that this endeavor will at least pay fo

Marketing, identify and briefly describe four treands in the macro/market

identify and briefly describe four treands in the macro/market

Systems of equations, the sum of square of two is 13 and the sum of thrice ...

the sum of square of two is 13 and the sum of thrice the smaller the larger is 12.what are the numbers?

State the term- channels of distribution, State the term- Channels of distr...

State the term- Channels of distribution You are aware that when a manufacturer of a product is located at one place, its consumers are located at innumerable places spread all

Consumer behaviour, explain VAL"s theory and each types of custmors

explain VAL"s theory and each types of custmors

Participants in the business buying process, own example of participants in...

own example of participants in the business buying process

Wordings of s.j. skinner for organizational buying behaviour, What are the ...

What are the wordings of S.J. Skinner about organizational buying behaviour? In words of S.J. Skinner as, “Organisational buying behaviour consider as the actions  and  decis

Personal Selling, when it comes to selling, personal selling is vital. most...

when it comes to selling, personal selling is vital. most sales people fail due to lack of customer knowledge and proper preparation before

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