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

Explain the term market segmentation, Mauritius became independent in 1968....

Mauritius became independent in 1968. At this time the economy was basically an agricultural one, sugar and tea being the main foreign exchange earners. In the 1970's it embarked o

Create a demand schedule and a supply schedule, Create a demand schedule an...

Create a demand schedule and a supply schedule for your product. Using these schedules, draw a demand curve and a supply curve using PowerPoint or Excel. Use these to deter

Consumer perceptions of value, Consumer perceptions of value Consumers...

Consumer perceptions of value Consumers are usually going for value. They feel that they have bought the right product to satisfy their requirements and paid a fair price for

Percenta, i dont understand a math question it says: A cclass of students c...

i dont understand a math question it says: A cclass of students conduct a servey of 1,000 students. The servey reveals 20% of the students speak spanish. How many students is that?

PEST ANALYSIS, Select THREE of the godrej consumer products ltd. SBUs and u...

Select THREE of the godrej consumer products ltd. SBUs and undertake a PEST analysis with regard to its business. Identify products which can be considered for launch by the select

Channel planning, process involved in designing channels

process involved in designing channels

Level of the market segmentation, Level of the market segmentation 1. ...

Level of the market segmentation 1.       Segment marketing: a market segment consists of a large identifiable group within a market with similar wants, purchasing power, g

Show the nature of customers, Q. Show the Nature of Customers? Nature ...

Q. Show the Nature of Customers? Nature of Customers: An appropriate media plan should consider the type or class of consumers for whom advertising is to be done. Different c

What is lead generation in personal selling process, What is lead generatio...

What is lead generation in personal selling process? Lead generation: Identification of prospects is initial step in personal selling process. Organization produces the l

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