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

Companys marketing audit process, Question 1: You are a marketing assi...

Question 1: You are a marketing assistant for a manufacturer of a branded range of household cleaning products: (a) Describe key factors that could be taken into account wh

Roles of peoples in the purchase decision procedure, What are the roles of ...

What are the roles of peoples who participating in the purchase decision procedure? The roles of peoples who participating in the purchase decision procedure is as follows:

What do you mean by business to business in e-commerce, What do you mean by...

What do you mean by Business to Business in e-commerce? B2B stands for Business to Business , it is the type of e-commerce. This is a mode of conducting business among two

Main features of market or marketing orientation, Explain the main features...

Explain the main features of organisations that do NOT adopt a market or marketing orientation. Marketing-orientated organisations have a major focus of the customers and their

Characteristics of the promotional types, Characteristics of the promotiona...

Characteristics of the promotional types: Factor Advertising Publicity Personal selling Sales promotion Audien

Explain existence of marketing as indispensable activity, Explain about exi...

Explain about existence of marketing as an indispensable activity. Existence of Marketing: Marketing is as old as mankind that a young child trying to persuade his mother

Paradigm shifts in america, do you think paradigm shifts having taken place...

do you think paradigm shifts having taken place in marketing?

What is advertising agency, Q. What is Advertising Agency? Advertising ...

Q. What is Advertising Agency? Advertising Industry engages three major components. Advertiser, Media and advertising agency. The person who makes a decision to advertise the p

Explain the purpose of internal marketing, Question: (a) Explain the p...

Question: (a) Explain the purpose of internal marketing. (b) Identify the three levels organizational culture and discuss the importance organizational culture for successf

Marketing strategy multi player, #questionThis week in the Music2Go Multi-P...

#questionThis week in the Music2Go Multi-Player you will be required to launch a New Product into one of the empty Market Segments (Sports or Youth). Part of this process will be t

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