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

Briefly describe market - oriented pricing characteristics, Question 1: ...

Question 1: a) Distinguish clearly between the aims and the specific objectives of a food and beverage operation. Critically assess some of the specific "qualitative" and "qua

Lead time management, impact of having inadequate system design in the lead...

impact of having inadequate system design in the lead time and engineering cost

Choice of an advertising agency by location, Q. Choice of an advertising ag...

Q. Choice of an advertising agency by location? A main consideration in the choice of an advertising agency is location of office of agency. A significant amount of communicati

3C of Marketing, Illustration of 3C of Marketing Triangle

Illustration of 3C of Marketing Triangle

Consumers confound marketers, difference between marketing efficiency and m...

difference between marketing efficiency and marketing effectiveness

Various approaches for selecting target markets, What are the various appro...

What are the various approaches for selecting target markets? Once a firm understand its markets and the suitable bases for segmenting such markets, this should choose an appro

Shopeersstop, what are significant factors that have led to the success of ...

what are significant factors that have led to the success of shoppers'''' sto

Store layout, Store layout The word store layout refers to: How stor...

Store layout The word store layout refers to: How store fixtures and display gondolas are positioned within the store The size of the store fixtures and display gondolas

Distinguish between quantitative and qualitative research, Question: Ma...

Question: Marketing Research plays a crucial role in any company. However, Marketing research is a time consuming and expensive process and therefore, requires careful plannin

Case Let 2, Ask questionThe rise of personal computers in the mid 1980s spu...

Ask questionThe rise of personal computers in the mid 1980s spurred interest in computer games. This caused a crash in home Video game market. Interest in Video games was rekindled

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