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

Elements of the marketing, Elements of the marketing: the marketing thinki...

Elements of the marketing: the marketing thinking starts with the customer needs. Today each marketer wants to retain and satisfy the customer because of the intense competition.

Test management, explain the various approach that are followed by SMCG com...

explain the various approach that are followed by SMCG companies in test marketing

BLOCK BOX, CUSUMER MIND IS A BLOCK MIND DISCOUSES

CUSUMER MIND IS A BLOCK MIND DISCOUSES

Sales promotion, Sales promotion: it includes activities other than advert...

Sales promotion: it includes activities other than advertising, personal selling publicity and public relations which are used in the promotiong of the product or in persuading th

What are the advantages of public relations, What are the Advantages of Pub...

What are the Advantages of Public Relations? Advantages of Public Relations are as illustrated below: a) This helps in building and having relations along with local comm

Decision making model in organisations, Question 1 "Negotiation is a po...

Question 1 "Negotiation is a powerful method for resolving conflict which needs skill, and experience. Negotiation will be viewed as either hard or soft. It will be a positi

Marketing manager, As marketing manager you have been assigned to promote a...

As marketing manager you have been assigned to promote a new product of beer. Your competitors are Angkor & Cambodia beer. Describe the factor that you would have to deal with to

Determine the number of decision-makers, Determine the Number of decision-m...

Determine the Number of decision-makers In consumer markets a single person very often makes decision. In organisational markets decisions are made by many people within buy

Marketing, marketing factors influencing pricing decisions

marketing factors influencing pricing decisions

Open cover-policies, Open 'Cover: Open Cover is an insurance arrangement d...

Open 'Cover: Open Cover is an insurance arrangement designed specifically to the need of those firms which have substantial import/export turnover and frequent transactions. Such

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