Dunder Miflin Technologies (DMT) produces trendy tablets. Two of its models are the market leaders: Supercool and Ubercool. Supercool has a profit margin of $200 and Ubercool brings in a profit of $250. Producing Supercool requires 1 processor and 2 standard memory chips whereas Ubercool needs 2 processors and 3 premium memory chips. DMT has 150 processors, 120 standard memory chips and 150 premium memory chips. Variable definitions for the linear programming problem, the profit maximization problem and the sensitivity analysis are provided below. You are required to answer the questions which follow using this information.
Let, S = number of Supercool models produced
U = number of Ubercool models produced
Max. 200 S+ 250U
Subject to:
S + 2U < 150 (Processor Constraint)
2S < 120 (Standard Chip Constraint)
3U < 150 (Premium Chip Constraint)
S, U > 0
Final |
Reduced |
Objective |
Allowable |
Allowable |
||
Cell |
Name |
Value |
Cost |
Coefficient |
Increase |
Decrease |
$A$2 |
Supercool |
60 |
0 |
200 |
1E+30 |
75 |
$B$2 |
Ubercool |
45 |
0 |
250 |
150 |
XXX |
Final |
Shadow |
Constraint |
Allowable |
Allowable |
||
Cell |
Name |
Value |
Price |
R.H. Side |
Increase |
Decrease |
$A$9 |
Processor |
150 |
XXX |
150 |
10 |
90 |
$A$10 |
Standard Chip |
120 |
37.5 |
120 |
180 |
20 |
$A$11 |
Premium Chip |
135 |
XXX |
150 |
1E+30 |
15 |
Group of answer choices
75
∞
150
250
0
Correct option will be 250.
Below is the screenshot of the sensitivity report -
Dunder Miflin Technologies (DMT) produces trendy tablets. Two of its models are the market leaders: Supercool...
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...
Performance Cooling Inc. manufactures air conditioners for home use and they currently have three models serving this market: (1) the essential model, (2) the comfort model, and (3) the majestic model. The units sell for reasonable prices and bring in a profit of $63, $95, and $135 respectively. Currently, the resources required for production of each unit is given in the table below. Fans Cooling Coils Assembly Time (hr) 1 8 1 2 12 Essential Comfort Majestic In Stock/Available 1...
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...
Apple has announced a new family of tablet
I need 4-5-6 please thanks
Four key resources were used to produce the five products (rom the previous pag), d th following lower table was derived Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Cell Name SHS3 High-Cap memory 5500 300 500 200 0 SHS4 Mid-cap memory 66000 1E+30 6600 3400 SHS5 Solid-state drive 3400500 3200 3200 $H56 Mechanical drive 5300 300 5300 Apple has $700,000 to spend on...
2. In a Air Conditioning manufacturing problem, the firm is maximizing the profit by selling three different products. Linear programming model for this problem will be as follows: Decision Variables: E := Number of economy models to be produced S := Number of standard models to be produced D := Number of deluxe models to be produced Linear Program: max 68E + 86S + 118D s.t. E + S + D ≤ 230 (Fan Motors) E + 2S + 4D...
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...
Problem 3-12 (Algorithmic) Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $69, 91, and $127, respectively. The production requirements per unit are as follows: Number ofNumber of Manufacturing Fans Cooling Coils Time (hours) Economy 8 Standard 12 Deluxe 14 4 For the coming production period, the company has 200 fan motors, 340 cooling coils, and 2800 hours of manufacturing time available. How many economy models...
Problem 3-12 (Algorithmic) Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $67, $93, and $129, respectively. The production requirements per unit are as follows: Number of Manufacturing Number of Cooling Coils Time (hours) Fans Economy Standard 12 Deluxe 14 For the coming production period, the company has 250 fan motors, 360 cooling coils, and 1800 hours of manufacturing time available. How many economy models (E),...
HERE IS THE SENSITIVITY REPORT!!!!!!!!!
PLEASE SHOW ALL WORK
A B C D E F G H J K M N O 1 Transportation Model (Basic) Use Solver on Data Ribbon to solve 2 3 Input Matrix: Destinations C D A 4 1 4 7 7 1 100 5 SUPPLY 8 8 2 12 3 200 6 5 3 10 16 150 7 90 80 120 160 8 Demand Required 10 Do not change or delete unshaded cells. 11 12...
1 2 12 1 14 Performance Cooling Inc. manufactures air conditioners for home use and they currently have three models serving this market: (1) the essential model, (2) the comfort model, and (3) the majestic model. The units sell for reasonable prices and bring in a profit of $63, 995, and $135 respectively. Currently, the resources required for production of each unit is given in the table below. Fans Cooling Coils Assembly Time (hr) Essential 8 Comfort Majestic In Stock/Available...