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

Illustrates the term product, Illustrates the term product? In straight...

Illustrates the term product? In straightforward words we can say that Product is anything which can be given to a market to satisfy a need or want. This represents a solution

Pricing policy, Pricing policy Pricing policy is a highly visible and k...

Pricing policy Pricing policy is a highly visible and key component of a company's marketing strategy and marketing plan. A company's pricing policy is the ultimate expression

Jbhj, consumer profile of typical buyer of rayban

consumer profile of typical buyer of rayban

Math problem help, 1.) Cost Revenue Model: Roberto operates a delivery serv...

1.) Cost Revenue Model: Roberto operates a delivery service in a large city. His start up cost amounted to $3900. He estimates that it costs him (in terms of gasoline, wear and tea

Effect of discounting prices, Effect of Discounting Prices Another sign...

Effect of Discounting Prices Another significant function of a marketing manager is to find any discounting of prices of the goods and services of a business. Every business di

Write short notes on pull sales promotion strategy, Write short notes on pu...

Write short notes on pull sales promotion strategy. A pullstrategy tries to get consumers to “ pull ” the product through the manufacturer from the marketing channel. The compa

Methods for collecting survey data by burger king, Question 1: A questi...

Question 1: A questionnaire is an important tool for getting information from respondents. Questionnaire should thus be properly designed to meet research objectives. (a)

Product related segmentation, Product related segmentation: Product us...

Product related segmentation: Product use situations: one of the important bases is the product use situations. Different customers may use the same product in different use

Mis, what is mis

what is mis

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