Class 5 Worksheet
docx
School
Bentley University *
*We aren’t endorsed by this school
Course
610
Subject
Mechanical Engineering
Date
Jan 9, 2024
Type
docx
Pages
4
Uploaded by ProfessorKnowledgeDolphin27
Class 5 Sensitivity Analysis
Example 1:
A pen manufacturer makes three items – a ballpoint pen, a mechanical pencil, and a
fountain pen. All are available only in black and sell in specialty stores and online. The per-unit
profit of the items is $3.00 for the ballpoint pen, $3.00 for the mechanical pencil, and $5.00 for
the fountain pen. These values take into account labor, cost of materials, packing, quality
control, and so on.
The company is currently trying to plan its production mix for each week. They believe
they can sell all the pens and pencils they produce, but production is limited by the available
resources. They are able to get at most 1000 ounces of plastic, 1200 ounces of chrome and 2000
ounces of stainless steel each week.
Each ballpoint pen requires 1.2 ounces of plastic, 0.8 ounces of chrome, and 2 ounces of
stainless steel. Each mechanical pencil requires 1.7 ounces of plastic, no chrome, and 3 ounces
of stainless steel. Each fountain pen requires 1.2 ounces of plastic, 2.3 ounces of chrome and 4.5
ounces of stainless steel. Other resources such as labor time available are not taken into
consideration at this point.
a)
Formulate (algebraic formulation) the LP that finds the production plan that maximizes
profit.
b)
Use Analytic Solver to find the solution and generate the sensitivity report.
c)
Due to some unexpected cost increases, the manufacturer realizes that the profit on the
mechanical pencil may actually be less than $3.00. If the actual profit is $2.00 on the pencil,
will they have to change the production schedule?
d)
If the profit on the ballpoint pens is $3.50 will the production schedule change?
e)
If 500 ounces of additional stainless steel are available for 0.60 more than what is currently
being paid, should the company buy additional steel at this price?
f)
Based on the allowable ranges, which unit profit is most sensitive?
g)
If additional plastic is available at $1.00 over the usual cost of $5.00 per ounce, if the
manufacturer agrees to purchase 500 ounces. Should the plastic be purchased? Does the
answer change if they can purchase less than 500 ounces at this price?
h)
If the manufacturer discovers that only 1,000 ounces of chrome are available this week,
what happens to the profit?
i)
Due to some unexpected cost savings, the profits on the ballpoint and fountain pens
may actually be larger than expected. If the profit on the ballpoint pens is $3.50 and
the profit on the fountain pens is $5.50, will the production schedule change?
Example 2:
Case 6-5 and 8-4 in textbook
The Springfield School Board has made the decision to close one of its middle schools (sixth,
seventh and eighth grades) at the end of this school year and reassign all of the next year’s
middle school students to the three remaining middle schools. The school district provides
busing for all middle school students who must travel more than approximately a mile, so the
school board wants to plan for reassigning the students that will minimize the total busing cost.
The annual cost per student for busing from each of the six residential areas of the city to each of
the schools is shown in the following table (along with other basic data for next year), where 0
indicates that busing is not needed and a dash indicates an infeasible assignment.
Busing Cost per Student
Area
Number
of
Student
s
Percent
in 6
th
Grade
Percent
in 7
th
Grade
Percent
in 8
th
Grade
School
1
School
2
School
3
1
450
32
38
30
$300
$0
$700
2
600
37
28
35
---
400
500
3
550
30
32
38
600
300
200
4
350
28
40
32
200
500
---
5
500
39
34
27
0
---
400
6
450
34
28
38
500
300
0
School capacity:
900
1100
1000
The school board has imposed the restriction that each grade must constitute between 30 and 36
percent of each school’s population. The above table shows the percentage of each area’s middle
school population for next year that falls into each of the three grades. The school attendance
zone boundaries can be drawn so as to split any given area among more than one school, but
assume that the percentages shown in the table will continue to hold for any partial assignment of
an area to a school.
a)
Please find the Excel spreadsheet for the problem.
b)
Obtain the sensitivity report
c)
How much can the change in busing cost from area 6 to school 1 increase (assuming no
change in the cost for other schools) before the current optimal solution will no longer be
optimal?
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
d)
Now assume the bussing cost from area 6 to all schools will increase by 1%. Will the
solution still be optimal? What if the change is 10%?
e)
The school can add a portable classroom to increase the capacity of one or more of the
middle schools for a few years. However, this is a costly move that the board would only
consider if it would significantly decrease busing costs. Each portable classroom holds 20
students and has a leasing cost of $2,500 per year. Is it worthwhile to add portable
classrooms to any school?
f)
Will this analysis be valid if we consider adding portable classrooms to all schools
considered in part e?
Related Documents
Related Questions
The data shown in Table 1 are the deviations from nominal diameter for holes drilled in a
carbon-fiber composite material used in aerospace manufacturing. The values reported are
deviations from nominal in ten-thousandths of an inch.
(a) Set up and R charts on the process. Is the process in statistical control?
(b) Estimate the process standard deviation using the range method.
(c) If specifications are at nominal ±100, what can you say about the capability of this
process? Calculate the PCR Cp
Table 1. Hole Diameter Data
Sample
Number X1 X2
1
2
3
4
5
6
7
8
9
10
11
12
14
15
16
17
18
19
20
-30 +50
0
-50
-10 -10
+20
-40
0
0
-30
0
+20
0
0
+70
0
+10
+40
+30
+30
+30
+10
0
+20
+50
+50
-20
+50 -60
+10
0
0
+20
+10 -20
-10
0
+20
X3 X4 X5
-30
+20
+30
+50
+40
+20
+30
+20
+30
+20
+30
0
+20
+10 +40
+10 +10
-10 +50
-10 -30
-10
+50
+40
0
+30
-10
0
+30
+30
-20
+50 +30 +10
+40
+20
0 +30
+10 +30
-20 +30
+30
+20
-20 +50
+20
+10
-40 +20
-20
-10
-10
0
-20
+10
+10 +50
0
+10
arrow_forward
A work measurement analyst at the Dorben Company took 10 observations of a high-production job. He rated the performance of each cycle and then calculated the average normal time for each item. The item with the largest dispersion had a mean of 0.30 minutes and a standard deviation of 0.03 minutes. If it is desired to have sample data within ±5% of the actual data, how many observations should the time study analyst take of this operation?
arrow_forward
9
arrow_forward
The sales of a product during the last four years were 860, 880, 870 and 890 units. The forecast for the fourth year was 876 units. If the forecast for the fifth year, using simple exponential smoothing, is equal to the forecast using a three period moving average, what is the value of the exponential smoothing constant?
arrow_forward
One step in the manufacture of a certain metal clamp involves the drilling of four holes. In a sample of 100 clamps, the average time needed to complete this step was
80seconds and the standard deviation was 15 seconds.
a.Find a 95% confidence interval for the mean time needed to complete the step.
b.Find a 99.5% confidence interval for the mean time needed to complete the step.
c.What is the confidence level of the interval (78,82)?
d.How many clamps must be sampled so that a 95% confidence interval specifiesthe mean to within ±1 seconds?
e. How many clamps must be sampled so that a 99.5% confidence interval specifies the mean to within ±1 seconds?
arrow_forward
The network diagram for a project is shown in the accompanying figure, with three timeestimates for each activity. Activity times are in weeks. Do the following:a. Compute the expected time for each activity and the expected duration for each path.b. Identify the critical path.c. Compute the variance of each activity and the variance and standard deviation of eachpath.
arrow_forward
Basic Manufacturing Process with 2 Job Types +
Inspection
Time between job arrivals at a machining station is exponentially distributed with mean 4.4 minutes.
There are 2 types of jobs to be processed 30% of which is Type 1 and, 70% are of Type 2. Processing
times are exponentially distributed. Mean processing time for Type 1 is 4.8 minutes, for Type 2 it is
2.5 minutes.
After the job is processed, they go through an inspection process with one single inspector and an
inspection time with triangular distribution (1,2,3.5). Inspector decides whether the part is good
enough, scrap or should be reworked. 80% of the parts produced is good, 10 % is scrap and the rest
needs rework.
Rework is done by the same manufacturing machine. The priority among the parts will be Part1 first,
part2 second and reworks of both type comes later. Rework time is normally distributed with mean 2
minutes and 0,2 std dev.
Simulate the system for one 8-hour day.
arrow_forward
A process is in statistical control with and ?= 39.7. The control chart uses a sample size of n = 2. Specifications are at 40 ± 5. The quality characteristic is normally distributed. How much improvement could be made in process performance if the mean could be centered at the nominal value?
arrow_forward
(a) A very important component of a system has a mean time between failures of 100 hr and a mean time to repair of 10 hr. Determine the inherent availability of the system.
(b) If the equipment in Q7 (c i) above is required to meet an inherent availability requirement of 0.985 and a mean time between failures of 100 hr. Calculate the permissible mean time to repair and if the system as a mean of the time intervals between corrective maintenance actions of 900 hrs and the sum of the mean corrective maintenance time intervals including supply downtime and administrative down time of 10 hrs Determine the operational availability of the system
arrow_forward
A hotel chain based in the United States contracts with a European vacuum cleaner manufacturer to supply a large number of upright
cleaner units. After delivery, the hotel raises questions about manufacturer vacuum cleaner performance claims, pointing out that the
units should have been tested to meet ASTM 558, an American standard. The manufacturer notes the advertised performance is based
on IEC 60312, a European standard, and the two test codes will yield similar, if not exact, results. Investigate both test codes and
address similarities and differences. Is there a legitimate claim here?
arrow_forward
How do expectations about future economic conditions influence the speed of adjustment in the error correction model (ECM)? Are there any other factors that might affect the speed of adjustment?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press

Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON

Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education

Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY

Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning

Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Related Questions
- The data shown in Table 1 are the deviations from nominal diameter for holes drilled in a carbon-fiber composite material used in aerospace manufacturing. The values reported are deviations from nominal in ten-thousandths of an inch. (a) Set up and R charts on the process. Is the process in statistical control? (b) Estimate the process standard deviation using the range method. (c) If specifications are at nominal ±100, what can you say about the capability of this process? Calculate the PCR Cp Table 1. Hole Diameter Data Sample Number X1 X2 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 18 19 20 -30 +50 0 -50 -10 -10 +20 -40 0 0 -30 0 +20 0 0 +70 0 +10 +40 +30 +30 +30 +10 0 +20 +50 +50 -20 +50 -60 +10 0 0 +20 +10 -20 -10 0 +20 X3 X4 X5 -30 +20 +30 +50 +40 +20 +30 +20 +30 +20 +30 0 +20 +10 +40 +10 +10 -10 +50 -10 -30 -10 +50 +40 0 +30 -10 0 +30 +30 -20 +50 +30 +10 +40 +20 0 +30 +10 +30 -20 +30 +30 +20 -20 +50 +20 +10 -40 +20 -20 -10 -10 0 -20 +10 +10 +50 0 +10arrow_forwardA work measurement analyst at the Dorben Company took 10 observations of a high-production job. He rated the performance of each cycle and then calculated the average normal time for each item. The item with the largest dispersion had a mean of 0.30 minutes and a standard deviation of 0.03 minutes. If it is desired to have sample data within ±5% of the actual data, how many observations should the time study analyst take of this operation?arrow_forward9arrow_forward
- The sales of a product during the last four years were 860, 880, 870 and 890 units. The forecast for the fourth year was 876 units. If the forecast for the fifth year, using simple exponential smoothing, is equal to the forecast using a three period moving average, what is the value of the exponential smoothing constant?arrow_forwardOne step in the manufacture of a certain metal clamp involves the drilling of four holes. In a sample of 100 clamps, the average time needed to complete this step was 80seconds and the standard deviation was 15 seconds. a.Find a 95% confidence interval for the mean time needed to complete the step. b.Find a 99.5% confidence interval for the mean time needed to complete the step. c.What is the confidence level of the interval (78,82)? d.How many clamps must be sampled so that a 95% confidence interval specifiesthe mean to within ±1 seconds? e. How many clamps must be sampled so that a 99.5% confidence interval specifies the mean to within ±1 seconds?arrow_forwardThe network diagram for a project is shown in the accompanying figure, with three timeestimates for each activity. Activity times are in weeks. Do the following:a. Compute the expected time for each activity and the expected duration for each path.b. Identify the critical path.c. Compute the variance of each activity and the variance and standard deviation of eachpath.arrow_forward
- Basic Manufacturing Process with 2 Job Types + Inspection Time between job arrivals at a machining station is exponentially distributed with mean 4.4 minutes. There are 2 types of jobs to be processed 30% of which is Type 1 and, 70% are of Type 2. Processing times are exponentially distributed. Mean processing time for Type 1 is 4.8 minutes, for Type 2 it is 2.5 minutes. After the job is processed, they go through an inspection process with one single inspector and an inspection time with triangular distribution (1,2,3.5). Inspector decides whether the part is good enough, scrap or should be reworked. 80% of the parts produced is good, 10 % is scrap and the rest needs rework. Rework is done by the same manufacturing machine. The priority among the parts will be Part1 first, part2 second and reworks of both type comes later. Rework time is normally distributed with mean 2 minutes and 0,2 std dev. Simulate the system for one 8-hour day.arrow_forwardA process is in statistical control with and ?= 39.7. The control chart uses a sample size of n = 2. Specifications are at 40 ± 5. The quality characteristic is normally distributed. How much improvement could be made in process performance if the mean could be centered at the nominal value?arrow_forward(a) A very important component of a system has a mean time between failures of 100 hr and a mean time to repair of 10 hr. Determine the inherent availability of the system. (b) If the equipment in Q7 (c i) above is required to meet an inherent availability requirement of 0.985 and a mean time between failures of 100 hr. Calculate the permissible mean time to repair and if the system as a mean of the time intervals between corrective maintenance actions of 900 hrs and the sum of the mean corrective maintenance time intervals including supply downtime and administrative down time of 10 hrs Determine the operational availability of the systemarrow_forward
- A hotel chain based in the United States contracts with a European vacuum cleaner manufacturer to supply a large number of upright cleaner units. After delivery, the hotel raises questions about manufacturer vacuum cleaner performance claims, pointing out that the units should have been tested to meet ASTM 558, an American standard. The manufacturer notes the advertised performance is based on IEC 60312, a European standard, and the two test codes will yield similar, if not exact, results. Investigate both test codes and address similarities and differences. Is there a legitimate claim here?arrow_forwardHow do expectations about future economic conditions influence the speed of adjustment in the error correction model (ECM)? Are there any other factors that might affect the speed of adjustment?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University PressMechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSONThermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
- Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEYMechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage LearningEngineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY

Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press

Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON

Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education

Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY

Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning

Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY