Question: Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease Decision Variable 1 25 0 40 20 16 Decision Variable 2 20

Variable Cells
Final Reduced Objective Allowable Allowable
Name Value Cost Coefficient Increase Decrease
Decision Variable 1 25 0 40 20 16
Decision Variable 2 20 0 30 20 10
Constraints
Final Shadow Constraint Allowable Allowable
Name Value Price R.H. Side Increase Decrease
Supply 1 20 33 20 1.5 1E+30
Supply 2 4 0 5 1E+30 1
Supply 3 21 44 21 1E+30 2.25
Part a
A company sells tables and chairs to customers Jack and Diane.
Demands and shipping costs are shown in the tables below.
Determine the optimal shipping amounts
Your model can only have four decision variables.
Do not use an integer constraint
Part b
To the model in Part a, add a supply constraint so that 1100 tables are available.
Shipping Costs, $/unit Jack Diane
Tables 1.0 1.2
Chairs 1.4 1.6
Demand, units Jack Diane
Tables 500 625
Chairs 750 875

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

QUESTION 9 Looking at the below excel report for an LP problem, Answer the following question: What is the slack for resource "Labors Hours"? Variable Cells Final Reduced Objective Allowable...

Q:

Looking at the below excel report for an LP problem, Answer the following question: What is the slack for resource "Labors Hours"? Variable Cells Final Reduced Objective Allowable Allowable Name...

Q:

If one additional unit was available to be added to one constraint, which constraint would provide the greatest improvement to the objective function value by gaining that additional unit. Objective...

Q:

Based on the Excel Solver output for a LP Maximization problem below, if additional units were available to be added to one constraint, which constraint would provide the greatest improvement to the...

Q:

undefined A small shipping company sends engines to two different plants, determining the amount they send based on demand from the plants, shipping space restrictions, and rebate requirements. Their...

Q:

Question 6 Biko, a manufacturer of frames for high-end road bicycles, produces two types of frames, the "speedy and the ultimate". The table below shows the usage of resources, well as their sales...

Q:

Y5 Which answer choice results in the biggest improvement to the Objective Function Value? Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase Decrease...

Q:

Problem 5. In a manufacturing company, the manager is trying to determine a weekly production plan There are four products (say, A, B, C, and D). The following LP model is considered to find the...

Q:

Chrissy is a health and fitness coach. She wants to create a nutritional supplement, which meets the required daily dose of key nutrients at the lowest cost. Her goal is to sell this blend to her own...

Q:

The LP problem below determines how many jackets, pants, and shirts a clothing store should stock. Variable Cells Final Reduced Objective Allowable Allowable Name Value Cost Coefficient Increase...

Q:

Which ionization process requires the most energy? a. S(g) S + (g) + e - b. S + (g) S 2+ (g) + e - c. Cl(g) Cl + (g) + e - d. Cl + (g) Cl 2+ (g) + e - Explain

Q:

What is the net present value of a project that has a net investment of $148,000 and net cash flows of $25,000 in the first year, $45,000 in years 2-7 and a negative net cash flow of $27,000 in year...

Q:

The Sarbanes - Oxley Act was enacted in response to: Group of answer choices accountants requests for definitive guidelines for their profession. business scandals involving companies such as Enron,...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...