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

Case study, #Should video game companies continue to alter their products t...

#Should video game companies continue to alter their products to include other functions such as email? Shouldvideo_game_companies_continue_to_alter_their_products_to_include_othe

Buying process, what is proposal solicitation in buying process

what is proposal solicitation in buying process

Financial plan, The financial plan consists of a 12-month profit and loss p...

The financial plan consists of a 12-month profit and loss projection, a four-year profit and loss projection (optional), a projected balance sheet, a cash flow projection and a bre

Henry Assael Model of buying decision behavior, Explain Henry Assael Model ...

Explain Henry Assael Model of buying decision behavior .

Categorization of the advertising, Categorization of the advertising:- ...

Categorization of the advertising:- The objective of advertising differs under different situations. One advertiser may perhaps seek to generate immediate response from the cus

Need of the environmental analysis, Need of the environmental analysis: th...

Need of the environmental analysis: the strategies that a company may adopt are influenced by the environment. An organization cannot keep itself insulated from the environment. I

Steps involved in designing a channel system, Steps involved in designing a...

Steps involved in designing a channel system: Formulating the channel objective: Formulating the channel objectives is the first step in designing a channel system. The objecti

Expalin the benefts of targeting to a marketer, Question 1: a) Define ...

Question 1: a) Define market segmentation and briefly describe the different bases for segmenting markets. b) Expalin the benefts of targeting to a marketer. c) Explain th

Describe in detail about the nature of market, Describe in detail about the...

Describe in detail about the Nature of Market There are several aspects of market which determine choice of channel of distribution. Say for instance, where number of buyers

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