What is the optimal solution

Assignment Help Business Management

Reference no: EM1349409

Use solver to create a sensitivity report and answer the following questions:
Country tables sell for $350 and contemporary tables sell for $450. Management has determined that at least 20% of the table made should be country and at least 30% should be contemporary. How many of each table should the company produce if it wants to maximize it's revenue?

a. Formulate an LP Model for this problem?

b. Create a spreadsheet model for this problem and solve it using Solver?

c. What is the optimal solution?

d. How will your spreadsheet model differ if there are 25 types or tables and 15 machine processes involved in manufacturing them?

Reference no: EM1349409

Questions Cloud

How many electrons does this represent : A frictionless block of mass 1.95 is attached to an ideal spring with force constant 340 . At the spring is neither stretched nor compressed and the block is moving in negative direction at a speed of 12.6.

Explain what can you and others do to use technology : Explain What can you and others do to use technology (including social media) to reduce any negative impact? Why is this important to consider?

What is the linear charge density along the arc : A solid block of mass m2 = 0.5 , at rest on a horizontal frictionless surface, is linked to a relaxed spring (with spring constant k = 150 whose other end is fixed. Another solid block of mass m1 = 2.4 and speed v1 = 2.2 collides with the 0.50 blo..

Explaining factors of various ups systems : What factors of the various UPS systems must concern you? What would you suggest as the lowest cost solution for this situation?

What is the optimal solution : What is the optimal solution and Create a spreadsheet model for this problem and solve it using Solver

Find the present price of the stock : Underwood Industries just paid a dividend of $1.45 each share. The dividends are expected to grow at 25 percent rate for the next 8 years and then level off to a 7 percent growth rate indefinitely.

Illustrate what are the advantages and disadvantages : Illustrate what are the advantages and disadvantages of having monetary policy in the hands of the Federal Reserve System rather than in the legislative or executive branches.

How many electrons leave the battery per minute : A 3500 kg block falls vertically through 5 m and then collides with a 400 kg pile, driving it 3.0 cm into bedrock. Assuming that the block-pile collision is completely inelastic, find out the magnitude of the average force on the pile from the bed..

Implementation plan for organizational change : Implementation Plan for Organizational Change - What would be tenets of an implementation plan for organizational change to enhance creativity and innovation?

User Account

All Pages