Below is the Sensitivity Report for Par Inc. In which departments would you not investigate whether...
Below is the Sensitivity Report for Par Inc. In which departments would you not investigate whether it was possible to increase the available hours?
| Variable Cells | |||||||
| Final | Reduced | Objective | Allowable | Allowable | |||
| Cell | Name | Value | Cost | Coefficient | Increase | Decrease | |
| $B$14 | Bags Produced Standard | 540 | 0 | 10 | 3.5 | 3.7 | |
| $C$14 | Bags Produced Deluxe | 252 | 0 | 9 | 5.286 | 2.33 | |
| Constraints | |||||||
| Final | Shadow | Constraint | Allowable | Allowable | |||
| Cell | Name | Value | Price | R.H. Side | Increase | Decrease | |
| $B$19 | Cutting and Dyeing Hours Used | 630 | 4.375 | 630 | 52.364 | 134.4 | |
| $B$20 | Sewing Hours Used | 480 | 0 | 600 | 1E+30 | 120 | |
| $B$21 | Finishing Hours Used | 708 | 6.9375 | 708 | 192 | 128 | |
| $B$22 | Inspection and Packaging Hours Used | 117 | 0 | 135 | 1E+30 | 18 | |
A.Cutting and Dyeing & Sewing
B.Cutting and Dyeing & Finishing
C.Sewing & Finishing
D.Sewing & Inspection & Packaging
E.Finishing & Inspection and Packaging
Cutting and Dyeing & Inspection and Packaging
Homework Answers
Sewing & Inspection & Packaging are already having surplus so we would not look for these two departments.
Option D is correct.
Add Answer to:
Below is the
Sensitivity Report for Par Inc. In which departments would you not
investigate whether...
Below is the Sensitivity Report for the Par Inc. What would be the increase in the objective function if 10 additional hours were available in the Finishing Department? Enter your answer without a do...
Below is the Sensitivity Report for the Par Inc. What would be the increase in the objective function if 10 additional hours were available in the Finishing Department? Enter your answer without a dollar sign and rounded to two decimal places. Microsoft Excel 16.0 Sensitivity Report Worksheet: [Par.xlsx]Model Report Created: 3/1/2018 4:16:53 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$14 Bags Produced Standard 540 0 10 3.5 3.7 $C$14 Bags Produced Deluxe...
How many footballs of each type should Supersport produce in order to increase to maximize the pr...
How many footballs of each type should Supersport produce in
order to increase to maximize the profit?
How much maximum profit it would make?
Overtime rates in the sewing department are $12 per hour. Which
of the following is correct?
Get overtime up to 100 hours as it increases net profit by $8
per hour.
Get as much overtime as possible as it increases net profit by
$8 per hour
Do not get overtime because it would not help in...
X1=130 and X2=0, optimal profit 32,500 Using the solver report and the sensitivity report answer the...
X1=130 and X2=0, optimal profit 32,500
Using the solver report and the sensitivity report
answer the question below. Please show your work:
Assume the marginal profit on the generators will
decrease by $25.00. Without solving the problem again, what is the
optimal profit for the company now?
We were unable to transcribe this imageDecision Variable Cells Final Reduced Objective Allowable Allowable Cell SCS4 Number to produce Generators SDS4 Number to produce Alternators Name Value Cost Coefficient Increase Decrease E+30 150.0000001...
If you could sell 50 oz. of stabilizer at $2.25/oz, how would this affect profit? Adjustable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell $B$5 Varia...
If you could sell 50 oz. of stabilizer at $2.25/oz, how would
this affect profit?
Adjustable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell $B$5 Variable C $C$5 Variable P Name 100 350 0 1E+30 2 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 200 500 50 Cell Name $D$11 Fragrance LHS 1600 $D$12 Intensifier LHS 1300 $D$13 Stabilizer LHS 350 1600 166.6666667 1E+30 50 1.5 1800 350 2
Adjustable Cells Final...
Question 14 5 pts Consider the sensitivity report below for the problems which follow. 6 Variable...
Question 14 5 pts Consider the sensitivity report below for the problems which follow. 6 Variable Cells Name Cell $8$3 $C$3 x1 X2 Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 34 67.333333333 4011 12 Constraints Cell Constraint Allowable Allowable RH. Side Increase Decrease Name $0$10 Extrusion Used $0$11 Packaging Used $D$12 Additive Used Final Shadow Value Price 48 3 18 11 12 0 18 16 2 1E30 4 Which of the following constraints are binding? Extrusion and...
how to graph this? is this correct? The aim of the objective function for Par Inc., should be to Maximize the objective value Objective function Max Z = 5S + 8D Subject to: (1/2)S + 1D <= 300 (C1)...
how to graph this?
is this correct?
The aim of the objective function for Par Inc., should be to
Maximize the objective value
Objective function
Max Z = 5S + 8D
Subject to:
(1/2)S + 1D <= 300 (C1)
1S + (2/3)D <= 420 (C2)
a) The optimum solution is
S = 330
D =135
b) Optimal solution value 'z' = 2730
Par, Inc., produces a standard golf bag and a deluxe golf bag on a weekly basis. Each golf...
If the per unit profit associated with producing the standard glove were to increase by $3...
If the per unit profit associated with producing the standard glove were to increase by $3 a pair, what would the impact be on the total profit? Obje ctive Cell (Max) Original Value Final Value Cell Name $B54 Obje ctive Function (Maxim ize Profit) 218 Variable Cells Integer 18 Contin 16 Contin Original Value Final Value Cell Name $B$1 X1(#of standard gloves) $852 X2(#of deluxe gloves) Constraints Cell Cell Value Formula Status Slack Name $B$8 1) Constraint#1 (le ather cutting...
The time it takes me to go shopping follows an exponential distribution with a mean of...
The time it takes me to go shopping follows an exponential distribution with a mean of 30 minutes. What is the probabil ity that I finish shopping in 40 minutes or less? Round to the nearest decimal! 73.6% 62.3% 77,7% 75.3% None of the above What is the probability that it takes me between 40 and 50 minutes to finish my shopping? Round to the nearest decimal! O 14.1% 10.6% 7.5% 81.1 % None of the above If the per...
(10) Problem #3 Using the Sensitivity Report output for the Blue Ridge Hot Tub example appearing ...
(10) Problem #3 Using the Sensitivity Report output for the Blue Ridge Hot Tub example appearing below: a. What is the range in the number of available pumps that will keep the current basis optimal assuming the amount of labor hours and tubing feet remain constant? b. Blue Ridge is considering introducing a new model of hot tub called the Typhoon-Tub. Suppose that each unit of this new model requires 1 pump, 12 hours of labor, and 13 feet of...
The sensitivity report is shown in Figure below SENSITIVITY REPORT FOR THE DIGITAL CONTROLS, INC., PROBLEM Variable Cel...
The sensitivity report is shown in Figure below SENSITIVITY REPORT FOR THE DIGITAL CONTROLS, INC., PROBLEM Variable Cells Model Final Reduced Objective Allowable Allowable Name Variable Value Coefficient Increase Decrease Cost Models A Manufactured 1.750 IE+30 AM 00.000 0.000 10.000 3.000 Models B Manufactured 0.000 2.333 BM 60.000 6.000 1.750 AP BP Models A Purchased E+30 1.750 0.000 90.000 14.000 0.000 3.000 Models B Purchased 9.000 2.333 Constraints Final Shadow Constraint Allowable Allowable Price Constraint Number Name R.H. Side Value...
How many footballs of each type should Supersport produce in
order to increase to maximize the profit?
How much maximum profit it would make?
Overtime rates in the sewing department are $12 per hour. Which
of the following is correct?
Get overtime up to 100 hours as it increases net profit by $8
per hour.
Get as much overtime as possible as it increases net profit by
$8 per hour
Do not get overtime because it would not help in...
X1=130 and X2=0, optimal profit 32,500
Using the solver report and the sensitivity report
answer the question below. Please show your work:
Assume the marginal profit on the generators will
decrease by $25.00. Without solving the problem again, what is the
optimal profit for the company now?
We were unable to transcribe this imageDecision Variable Cells Final Reduced Objective Allowable Allowable Cell SCS4 Number to produce Generators SDS4 Number to produce Alternators Name Value Cost Coefficient Increase Decrease E+30 150.0000001...
If you could sell 50 oz. of stabilizer at $2.25/oz, how would
this affect profit?
Adjustable Cells Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease Cell $B$5 Variable C $C$5 Variable P Name 100 350 0 1E+30 2 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 200 500 50 Cell Name $D$11 Fragrance LHS 1600 $D$12 Intensifier LHS 1300 $D$13 Stabilizer LHS 350 1600 166.6666667 1E+30 50 1.5 1800 350 2
Adjustable Cells Final...
Question 14 5 pts Consider the sensitivity report below for the problems which follow. 6 Variable Cells Name Cell $8$3 $C$3 x1 X2 Final Reduced Objective Allowable Allowable Value Cost Coefficient increase Decrease 34 67.333333333 4011 12 Constraints Cell Constraint Allowable Allowable RH. Side Increase Decrease Name $0$10 Extrusion Used $0$11 Packaging Used $D$12 Additive Used Final Shadow Value Price 48 3 18 11 12 0 18 16 2 1E30 4 Which of the following constraints are binding? Extrusion and...
how to graph this?
is this correct?
The aim of the objective function for Par Inc., should be to
Maximize the objective value
Objective function
Max Z = 5S + 8D
Subject to:
(1/2)S + 1D <= 300 (C1)
1S + (2/3)D <= 420 (C2)
a) The optimum solution is
S = 330
D =135
b) Optimal solution value 'z' = 2730
Par, Inc., produces a standard golf bag and a deluxe golf bag on a weekly basis. Each golf...
If the per unit profit associated with producing the standard glove were to increase by $3 a pair, what would the impact be on the total profit? Obje ctive Cell (Max) Original Value Final Value Cell Name $B54 Obje ctive Function (Maxim ize Profit) 218 Variable Cells Integer 18 Contin 16 Contin Original Value Final Value Cell Name $B$1 X1(#of standard gloves) $852 X2(#of deluxe gloves) Constraints Cell Cell Value Formula Status Slack Name $B$8 1) Constraint#1 (le ather cutting...
The time it takes me to go shopping follows an exponential distribution with a mean of 30 minutes. What is the probabil ity that I finish shopping in 40 minutes or less? Round to the nearest decimal! 73.6% 62.3% 77,7% 75.3% None of the above What is the probability that it takes me between 40 and 50 minutes to finish my shopping? Round to the nearest decimal! O 14.1% 10.6% 7.5% 81.1 % None of the above If the per...
(10) Problem #3 Using the Sensitivity Report output for the Blue Ridge Hot Tub example appearing below: a. What is the range in the number of available pumps that will keep the current basis optimal assuming the amount of labor hours and tubing feet remain constant? b. Blue Ridge is considering introducing a new model of hot tub called the Typhoon-Tub. Suppose that each unit of this new model requires 1 pump, 12 hours of labor, and 13 feet of...
The sensitivity report is shown in Figure below SENSITIVITY REPORT FOR THE DIGITAL CONTROLS, INC., PROBLEM Variable Cells Model Final Reduced Objective Allowable Allowable Name Variable Value Coefficient Increase Decrease Cost Models A Manufactured 1.750 IE+30 AM 00.000 0.000 10.000 3.000 Models B Manufactured 0.000 2.333 BM 60.000 6.000 1.750 AP BP Models A Purchased E+30 1.750 0.000 90.000 14.000 0.000 3.000 Models B Purchased 9.000 2.333 Constraints Final Shadow Constraint Allowable Allowable Price Constraint Number Name R.H. Side Value...
Most questions answered within 3 hours.
-
1. A boy stands on one end of a boat, and then walks to the
other...
asked 9 minutes ago -
Casey is on trial under criminal allegations that she engaged in
fraudulent behavior at the company...
asked 14 minutes ago -
Surplus Styles is a manufacturer of hair care products,
including shampoos, conditioners, and hair gels. The...
asked 12 minutes ago -
Using an income-expenditure diagram, use the infinite line and
double-drop line tools to show the economy...
asked 21 minutes ago -
Which expression computes a pseudorandom integer between -10 and
10 using rand()
from cstdlib?
A. (rand(...
asked 27 minutes ago -
Roybus, Inc., a manufacturer of flash memory, just reported that
its main production facility in Taiwan...
asked 35 minutes ago -
Two capacitors connected in parallel produce an equivalent
capacitance of 45.0 μF but when connected in...
asked 44 minutes ago -
The differences between the two sets of dependent data are -1,
2,-,2, 2. Round to the...
asked 1 hour ago -
A χ2-curve, looking at the relationship between age and hours
spent working at an office per...
asked 1 hour ago -
The pH of a sample of water from a river is 5.0. A
sample of effluent from...
asked 2 hours ago -
At the beginning of the period, the Fabricating Department
budgeted direct labor of $136,500 and equipment...
asked 2 hours ago -
Please answer all
____ 28. Rent control is usually
justified on the grounds that it protects...
asked 2 hours ago