Question: We are making four products ( P 1 - P 4 ) . Objective function coefficients are profit per unit for each product. Constraints are

We are making four products (P1-P4). Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials (1,2 and 3) and plant capacity. Use the following excel LP to answer this question.
Variable Cells
Final
Reduced
Objective
Allowable
Allowable
Cell
Name
Value
Cost
Coefficient
Increase
Decrease
1
P1
-
(3.1)
20.0
3.1
1E+30
2
P2
91.7
-
21.0
4.0
6.7
3
P3
225.0
-
20.0
3.9
1.3
4
P4
66.7
-
35.0
4.0
9.875
Constraints
Final
Shadow
Constraint
Allowable
Allowable
Constraint
Name
Value
Price
R.H. Side
Increase
Decrease
1
Labor
383.3
-
500.0
1E+30
116.7
2
Raw1
425.0
5.3
425.0
375.0
111.4
3
Raw2
408.3
-
490.0
1E+30
81.7
4
Raw3
800.0
2.7
800.0
100.0
112.5
5
Capacity
700.0
6.3
700.0
140.6
98.2
One more unit of which constrint would be worth the most (use constraint number 1-5)
Looking at the raw material constraints (2-4). Which raw material constraint has slack? (Enter 2,3, or 4)
The objective function coeficient for product 2 can increase to a value of
without changing the solution quantities (1 decimal place)
An additional unit of Raw1(not constraint 1, look for RAW 1) is worth
1 decimal place

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:

Which valuation model, Discounted Cash Flow (DCF) or Capitalized Cash Flow (CCF), would you use at each stage of the economic life cycle [development, growth, expansion, maturity & decline] for a...

Q:

1. Determine, on the basis of the following figures, the shortage or overage percent. Opening inventory $190,000 Gross purchases $315,000 RTV $21,000 Transfers in $10,500 Transfers out $8,400...

Q:

Prepare the necessary journal entries to record the following transactions relating to the long-term issuance of bonds of Pitts Co. (Credit account titles are automatically indented when the amount...

Q:

We are making four products (P1-P4). Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials (1.2 and 3) and plant capacity....

Q:

Consider a company that manufactures three home air conditioners: an economy model (E), a standard model (S), and a deluxe model (D). The objective is to determine how many economic models, standard...

Q:

Question 2 Product 1 Product 3 Product 4 $900 $650 Product 2 $750 $600 Price Paid by Customer Unit Cost to Make Price to Purchase from 3rd-Party Supplier $500 $200 $400 $550 $800 $1,000 $750 $300...

Q:

We are making four products (P1-P4). Objective function coefficients are profit per unit for each product. Constrain the amount of labor available, raw materials (1, 2 and 3) plant capacity. Use the...

Q:

John's Manufacturing makes four closely related products, which use some of the same inputs. The company has just received an order for 600 units of Product 1, 300 units of Product 2, 400 units of...

Q:

Please solve the following question using excel commands like solver, Analytic Solver, or sensitivity analysis. 5. Reconsider the model given in Problem 5.2. While doing what-if analysis, you learn...

Q:

HEY CAN ANYONE SOLVE ME THIS QUESTIONS IN THE WORD. THANK YOU. (NOTE: There is an Excel Spreadsheet available for these problems but for the ones asking for "Standard Form" hardcopy/manual layout and...

Q:

Two charges, q1 and q2, are located at the origin and at (0.50 m, 0), respectively. Where on the x-axis must a third charge, q3, of arbitrary sign be placed to be in electrostatic equilibrium if (a)...

Q:

What is the future value if $5,000 is deposited in an account at the start of each month for 12 months and the interest rate is 0.5% per month compounded? Question No. 3: What is the present value if...

Q:

Is an Scorp. income tax taxed at an 2 1 % flat rate

Q:

For the Chevron Company: What is the Description and Dollar Value of the first line on the Income Statement (it may be net sales)? Locate the Balance Sheet (it may have a different heading, such as...

Q:

in 300 hundred words or more, please write, in your own words, about one of the entities that establish the rules accountants must follow when preparing financial reports. they include, but are not...

Q:

In the United States, private health insurance plans can be written as group or individual plans, or as indemnity or managed care plans. Comparing Private Insurance Plans Patricia is able to secure...

Q:

PART A: Sparty Corporation adjusts its accounts only at year-end. The following information is available as a source for preparing adjusting entries at December 31, 2019. 1. During July 2019, Sparty...

Q:

Under the check-the-box rules what is the default status of an LLC (single-member or multi-member)? If an entity is incorporated under state law, what are its options for purposes of entity taxation...

Q:

Determine if the overhead allocated to the product relates to a single plantwide overhead rate method, multiple production department factory overhead rate method, or activity-based costing...

Q:

To what extent do you agree with the following statement: Autocracy at work is the price we pay for democracy after hours? Does it apply equally to work in the classroom?

Q:

For most people today, the term rhetoric has unfavorable associations. What synonym or phrase captures what Aristotle meant yet doesnt carry a negative connotation?

Q:

Managers use strategy and consent to maintain control over subordinates. According to Deetz, which practice is more effective? Why?