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

What types of tools use in sales promotion scheme, What types of tools use ...

What types of tools use in sales promotion scheme? Sales Promotion Schemes: 1. Price-off: A straight discount off the list price upon every case purchased throughout a

Determine the major decision of marketing activities, Determine the major d...

Determine the major decision of marketing activities So marketing manager concentrates on four major decision areas when planning the marketing activities, namely, (i) products

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

State about the marketing mix, State about the marketing mix Marketing ...

State about the marketing mix Marketing comprise a number of activities. To start   with, an organisation may decide on its target group of customers to be served. Once the tar

IN DEPTH, I WANT TO KNOW THAT WHAT IS INTERNET OF THE FUTURE WHAT IS WHAT I...

I WANT TO KNOW THAT WHAT IS INTERNET OF THE FUTURE WHAT IS WHAT I AM CURRENTLY STUDING IN MY MASTERS OF BUSINESS ADMINISTRATION ABOUT CUSTOMIZATION WOULD YOU KINDLY PROVIDE ME SOME

Retail management, what is the significance of retail as an industry

what is the significance of retail as an industry

State the concept of marketing as an exchange, State The Concept of Marketi...

State The Concept of Marketing as an Exchange Concept of exchange, according to most marketing academics and practitioners, is central to our understanding of marketing. For a

Explain product communication strategies, Question 1: (i) If a local ...

Question 1: (i) If a local firm wishes to grow internationally, describe the alternative strategies available? (ii) What are the major advantages and disadvantages of each

Feedback from customers for better customer satisfaction, Question 1: (...

Question 1: (a) CRM means different things to different people. For one it is direct mailing for others it is an IT system. Draw a diagram and discuss the basic model for CR

.., what are the challenges that a production manager faces?

what are the challenges that a production manager faces?

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