Lab 5 Assignment Fall 2023
pdf
keyboard_arrow_up
School
Oakland University *
*We aren’t endorsed by this school
Course
2600
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
Pages
9
Uploaded by GrandTitanium5144
EGR 2600 Lab 5 Assignment Lab Deliverables - 10 points maximum 1.
(3 pts) The completed Excel spreadsheet shown in Deliverables Detailing
section. (watch your decimals). 2.
(3 pts) Formulas used to find percentile and h(p) for station 1 and 2.
Remember to find min, max, average, and standard deviation for the process time data. 3.
(2 pts) Two probability plots. One of h(p) vs. process time for each station
(use XY scatter plots) with a trend line.
4.
(2 pts) Moodle Quiz. Objective: Modify a Tecnomatix Plant Simulation 13 model of a production
system and run a simulation. Use a worker
’s process time data collected from the simulation to construct probability plots and analyze the system's behavior. Use the Lab 5 Manual in parallel with this page. In this laboratory assignment, each team will modify an existing Plant Simulation model of a production system and enter operating parameters for the system
’s elements. The team will then conduct a simulation run of the model and collect process time data from selected worker stations. Then construct probability plots of the process time for the selected worker stations. The objective of this lab is to make you understand the difference between the theoretical equation and the result of a simulation. It is related to what you have learned in class. In order to complete this lab assignment, follow the procedure presented in the EGR 2600 Laboratory Manual
entitled “Laboratory #5” and watch the tutorial video. Your Textbook will also be necessary to answer some questions.
EGR 2600 Model Construction: The construction of a Plant Simulation model is accomplished by following the procedure presented in the manual. For Station 1, S1: The probability distribution to select is: Uniform The parameters for this probability distribution to select are: Minimum (
Start
): 20 sec. (=a) Maximum (
Stop
): 45 sec. (=b) Station 3, S3:
The probability distribution to select is: Normal The parameters for this probability distribution to select are: Mean (
Mu
): 30 sec.
(=μ) Standard Deviation (
Sigma
): 6 sec.
(=
σ
) Simulation Run: A single simulation should be run for the run time given below (see section of entitled “
Running
a simulation
” in the Manual).
Run Time for the simulation run is 18,000 sec. (5 hours) Note at the end of the simulation run, the process time data for both worker stations will be transferred automatically, to the file .txt you created (see manual instruction). Importing Plant Simulation txt file into Excel After you run the simulation and open the .txt file, it should look like the right figure
EGR 2600 : Use Excel to organize and sort through the data in the notepad file. Open Excel then go to File > Open > and select your notepad file (to find your file, “All Files”
must be selected to see the .txt
document).
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
EGR 2600 Then the following menu should appear. Make sure “Delimited”
is selected and select “NEXT”:
EGR 2600 On the next page select Tab, Comma, and Space for Delimiters. Then select next
EGR 2600 Select Finish on the final page and your data should appear like the following (will be over 200 lines long).
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
EGR 2600 Organize your DATA: ·
Delete the column called “Entity” (you won’t need it).
·
Go to the very last line, and copy the last 40 entries, paste in another Excel tab ·
Sort them on S1 and S3 and separate your S1 and S3 entries ·
Sort S1 and S3 from least to greatest and start filling your table like shown below with headings and formulas similar to the ones shown below. Note the “Stations” process times are in seconds. You have 20 cycles of each station.
EGR 2600 Deliverables Detailing: 1.
Complete the Excel spreadsheet shown below. Use the parameters from the stations
’ Plant Simulation process time distributions to c
ompute the percentiles, h(p). Note that the “Process Time” is the values you get from the simulation.
2.
Give formulas used to find percentile and h(p) for station 1 and 2. Remember to find min, max, average (or mean), and standard deviation for the process time data. 3.
Two probability plots. One of h(p) vs. process time for each station (use XY scatter plots) with a trend line. (Don
’t forget axes titles and units).
4.
1 point for quality of your report. Hints for Lab 5: Refer to sections 4-5 on Continuous Uniform Distribution, 4-6 on Normal Distribution and 6-7 on Probability Plots in your textbook
EGR 2600 1.
Percentiles are referred to as cumulative frequency. Refer to page 230 to 232
in your textbook (The book uses j
as the sample number, but in the lab, i
was used.). Use n=20 since we have 20 values per station. (i-0.5)/n
2.
Station 1: To find “x”
-unknown for station 1 refer to CDF function on page 117 of textbook. (Hint: Values “a” and “b” are given in this
assignment). F(x) = (x-a)/(b-a)
(it
’s the percentile)
3.
Station 3: To find the Z score you may refer to table III in the appendix on pg. 742 & 743. Or you can use the Excel function: norm.inv (p, 0, 1)
(recommended, where in this case, using “0” and “1” is to normalize the dis
tribution). Note that “p” here refers to percentile you calculated (see step 2)
for normal distribution: 4.
Station 3: To find x-unknown for station 3 refer to page 122. The Z score means the Z score for each “
p
” or percentile value and µ and σ
are the mean and standard deviation for the normal distribution given in the assignment. 5.
Your “Proc.Time” is the result of the simulation, the “x” unknown is the comparable values compute from the pure distribution (in this case Uniform or Normal). Your results in both column should be close in order to compare them.
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