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

Differentiate business market and the consumer market, What is difference b...

What is difference between Business Market and the Consumer Market? The business market comprises all the organizations which obtain goods and services that are used for furthe

Importance of the market segmentation, Importance of the market segmentatio...

Importance of the market segmentation: 1.       Adjustment of product and marketing appeals: market segmentation presents an opportunity to understand the nature of the mar

Product life cycle, considering the concept of product life cycle where wou...

considering the concept of product life cycle where would you put video games in their life cycle

What are requirements to make finished goods for consumers, What are the re...

What are the requirements to make finished goods for consumers? All needs to make finished goods for consumers are as given below: i. Installations: For producing any prod

#title, Companies are forced to follow sales orientation because the result...

Companies are forced to follow sales orientation because the results are measured in short term and incentives are based on short term achievements. This leads to a high level of r

Reasons of channels distribution in economic system, What are the reasons o...

What are the reasons of channels of distribution in economic system? Channels of distribution in any specified economic system emerge due to the following reasons: Effici

Customer relationship management, Customer Relationship Management Cus...

Customer Relationship Management Customer relationship management (CRM) has been described narrowly as a customer database management activity. Customer relationship manage

What is structural realignment, What is Structural realignment Marketi...

What is Structural realignment Marketing communications agencies are attempting to adjust the way they can best serve interests of their clients. One of the results is structu

Write a report on swot analyses for the company, According to the MCCI Busi...

According to the MCCI Business Confidence Indicator (September 2010), the morale of business leaders is morose with a drop to 96.3 of the confidence level index(March 2010=100)

Nelson mathematics sharing and grouping, use the equation of 42 divded by 7...

use the equation of 42 divded by 7 to write 2 promblems one about sharing the other about grouping

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