Optimal product mix between product a and product b

Assignment Help Business Management
Reference no: EM131630880

The next few questions refer to the following information:

A company wants to determine the optimal product mix between Product A and Product B. The cost of producing the products is nonlinear (cubed for Product A, quadratic for Product B) so that the objective function is:

Max 4A + 6B - A3 - 2B2

The constraints are:

A + 3B <= 8

5A + 2B <= 14

A >= 0, B >= 0

1. Using Solver's GRG Nonlinear solution algorithm find the optimal solution to this problem and describe it.

2. A screenshot of your spreadsheet setup for this problem

3. A screenshot of your Solver setup for this problem.

Reference no: EM131630880

Questions Cloud

Social media applications contribute to the mission : Social media could themselves trigger dramatic organizational changes. what ways could social media applications contribute to the mission of your organization?
How might erp implementation affect organization suppliers : What benefits should the suppliers and customers of a firm that has successfully implemented an ERP system expect to see?
What is globalization and how it may affect health care : What is Globalization? How it may affect health care? Give an example of how can an international policy can affect health care?
How does the mass media affect politics : What were the major changes from the Articles of Confederation to the Constitution? What problems did the framers "fix"?
Optimal product mix between product a and product b : The cost of producing the products is nonlinear (cubed for Product A, quadratic for Product B) so that the objective function is:
Specific real company could reduce the need for inventory : Describe in detail how a specific real company could reduce the need for inventory.
Should companies be required to take back : Should companies be required to take back their products so that they can be properly disposed of or recycled? Defend your opinion.
Should claim of rape require corroboration before conviction : Should all claims of rape require corroboration before conviction? Does the US Constitution prohibit the death penalty for rape? Why or why not?
Explain the cad cae and cam software : You are a member of the engineering organization for an aircraft parts manufacturer. The firm is considering the implementation of a PLM system.

Reviews

Write a Review

Business Management Questions & Answers

  Meyers-briggs type indicator personality inventory

What is the Meyers-Briggs Type Indicator personality inventory, and why is it a useful tool for healthcare executives? Describe why human resources management is comprised of strategic and administrative actions. If you are responsible for resea..

  Focuses on legal and ethical issues facing companies

This week the discussion focuses on legal and ethical issues facing companies and IT professionals. One of the challenges within an ever changing technology industry is that new technologies can both benefit and hurt society. Companies and IT orga..

  Payment stream assuming your required rate of return

Suppose you wish to receive payments of $1589.4 in one year's time, $794.7 in two years' time, and $7947 in three years' time. What is the cost today of the payment stream assuming your required rate of return is 4.50% p.a.?

  Bank annual income from the loans

A bank lent $1.2 million for the development of three new products, with one loan each at 6%, 7%, and 8%. The amount lent at 8% was equal to the sum of the amounts lent at the other two rates, and the bank's annual income from the loans was $88,00..

  Illustrate what kinds of employee training would help

Illustrate what kinds of employee training would help? Illustrate what would you tell your employees about feedback importance if you were the boss?

  Necessity in the implementation of new policies

1. Do you believe that training is a necessity in the implementation of new policies? Please support your answers. 2. Why are background checks important to information security? What purpose do they serve?

  Manage aspects of unsatisfactory performance in organisation

Critically discuss how well designed performance management system might be used to identify and manage aspects of unsatisfactory performance in an organisation

  If a group of sellers could form a cartel

If a group of sellers could form a cartel, what quantity and price would they try to set?

  Make a residual plot from the linear regression model

Make a residual plot from the linear regression model you constructed above. How confident are you that the prediction is quite accurate?

  Union officials likely to oppose flexible work hours

Why are union officials likely to oppose flexible work hours and other innovative work schedules? Please post your response and include reference material.

  Corporate compliance officer or compliance director

Prepare 10-12 questions that you plan to use to interview the corporate compliance officer or compliance director for the end of the semester assignment.

  Some of the economic factors that influence

What are some of the economic factors that influence individual and family food needs and food choices? Please provide examples. What are at least three different sources of groceries, and how do those sources vary economically from one community to..

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