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

Implement a crm system solution, Question: "If a decade ago, we had had...

Question: "If a decade ago, we had had a greater understanding of the business and organizational dynamics of technology, I think we would now have an even greater payback from

Enumerate about the target marketing and research, Enumerate about the Targ...

Enumerate about the Target marketing and research Use of target marketing processes in the consumer market has been more advanced and sophisticated than in organisational ma

What are the several types of promotional schemes, What are the several typ...

What are the several types of promotional schemes? Different types of promotional schemes are distributed within the following manner as given here: a) Consumer-promotion to

Branding, The Boeing Company makes a number of different types of aircraft ...

The Boeing Company makes a number of different types of aircraft for the commercial airline industry, e.g., the 727, 747, 757, 767, and 777 jet models. Is there any way for Boeing

Market analysis, Milk consumption per day 1)250ml 2)500ml 3)1 litr 4)More ...

Milk consumption per day 1)250ml 2)500ml 3)1 litr 4)More than 1 litr

State the term- public relations, State the term- Public Relations Pub...

State the term- Public Relations Public relations is 'the art and social science of analysing trends, predicting their consequences, counselling organisations' leadership and

Create a graph of widget sales, Q1 Create a graph of widget sales on the t...

Q1 Create a graph of widget sales on the tab "Q1-Graph" and characterize the time series.  That is, does the time series appear to include the effects of ( 1 ) cyclicality, ( 1 )

State the characteristics of communications, State the characteristics of c...

State the characteristics of communications Within market exchanges, communications are characterised by planning and formality. Relational exchanges are supported by more fre

Case study, How are Indian customers visiting Shoppers’ Stop any different ...

How are Indian customers visiting Shoppers’ Stop any different from customers of developed western countries?

Major decisions in sales promotion, Major decisions in sales promotion: in...

Major decisions in sales promotion: in using sales promotion a company must establish its objectives select the tools develop the program pretest the program implement and control

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