Microsoft Word - Simulation Assignment 1.docx There are three separate questions, each requiring a separate simulation. You are to build the simulation model in Excel or R, run the simulation at least...

1 answer below »

3 basic Simulation Problems.


There are three separate questions, each requiring a separate simulation. You are to build the simulation model in Excel or R, run the simulation
at least
100 times and
provide one paragraph as a response. (Include Graphs and charts for each question.)





Microsoft Word - Simulation Assignment 1.docx There are three separate questions, each requiring a separate simulation. You are to build the simulation model in Excel or R, run the simulation at least 100 times and provide one paragraph as a response. (Include Graphs, and charts for each question.) Q1. Jamming Missiles The enemy has a new GPS jamming device used to misdirect US Missiles after launch. Our missiles have built in countermeasures used to misinform the jammer. · Success of our countermeasures are as follows: 12% great success, 64% some success, and 24% no success. · If we have great success, the enemy jammer is completely ineffective, if we have some success, the missile recognizes it is being jammed and changes its method of target location, if there is no success, the missile is defeated. · For every minute a missile is in the air, the enemy can get another jamming attack. For our current Area of Concern (AOC), a missiles flight time will follow an exponential distribution with a mean of 90 seconds. · If a missile is forced to change its method of target location there is a 25% chance of failure. · If the enemy jammer is completely ineffective, there is a 95% chance of missile success. Current intelligence estimated it will require 19 successful missile strikes to destroy the enemy’s munitions factory. You are to build a simulation model in Excel or R that represents the above scenario and answer the following questions: 1. On average, how many missiles will we need to launch for success against the enemy’s munitions plant? 2. What is the greatest number of missiles we might use and what is the least we might use? 3. What is the probability we can get the job done with exactly 19 missiles? Q2. Fire Fighter Response Time Build a simulation of the firefighter problem. You can use either Excel Spreadsheet, or R. Conduct 100 repetitions of the simulation and answer the following questions: · What is the average response time? · What was your greatest response time? · What is the minimum response time? Q3. ID Card Office (25 points) The Fort Lee ID Card Office has had to reduce staff to one employee and want to know how this impacts operations. People arrive at the office at a rate of 1.7 people per minute (Poisson) and the clerk can serve 3.1 people per minute (Poisson). Build a discrete event simulation to model 8 hours’ worth of the operation. You can use Excel spreadsheet, or R. Provide the longest time a customer was in the system and the server utilization rate.

Answered 8 days AfterJun 21, 2021

Answer To: Microsoft Word - Simulation Assignment 1.docx There are three separate questions, each requiring a...

Karthi answered on Jun 30 2021
137 Votes
Sheet1
    Mean    X
    1.7    3.1    0.1396525274
    3.4    6.2    0.0806116908
    5.1    9.3    0.0530023121
    6.8    12.4    0.020794383
    8.5    15.5    0.0153309332
    10.2    18.6    0.0114153451
    11.9    21.7    0.0047392661
    13.6    24.8    0.003656692
    15.3    27.9    0.0028232374
    17    31    0.0021824854
    18.7    34.1    0.0009414472
    20.4    37.2    0.0007395703
    22.1    40.3    0.0005805997
    23.8    43.4    0.0002519932
    25.5    46.5    0.0001999792
    27.2    49.6    0.0001584952
    28.9    52.7    0.0
000690617
    30.6    55.8    0.0000551739
    32.3    58.9    0.0000440122
    34    62    0.0000350667
    35.7    65.1    0.0000154359
    37.4    68.2    0.0000123709
    39.1    71.3    0.0000099017
    40.8    74.4    0.0000043628
    42.5    77.5    0.0000035089
    44.2    80.6    0.0000028184
    45.9    83.7    0.0000012428
    47.6    86.8    0.0000010023
    49.3    89.9    0.0000008073
    51    93    0.0000006495
    52.7    96.1    0.0000002879
    54.4    99.2    0.0000002324
    56.1    102.3    0.0000001874
    57.8    105.4    0.0000000831
    59.5    108.5    0.0000000672
    61.2    111.6    0.0000000543
    62.9    114.7    0.0000000241
    64.6    117.8    0.0000000195
    66.3    120.9    0.0000000158
    68    124    0.0000000128
    69.7    127.1    0.0000000057
    71.4    130.2    0.0000000046
    73.1    133.3    0.0000000037
    74.8    136.4    0.0000000017
    76.5    139.5    0.0000000013
    78.2    142.6    0.0000000011
    79.9    145.7    0.0000000005
    81.6    148.8    0.0000000004
    83.3    151.9    0.0000000003
    85    155    0.0000000003
    86.7    158.1    0.0000000001
    88.4    161.2    0.0000000001
    90.1    164.3    0.0000000001
    91.8    167.4    0
    93.5    170.5    0
    95.2    173.6    0
    96.9    176.7    0
    98.6    179.8    0
    100.3    182.9    0
    102    186    0
    103.7    189.1    0
    105.4    192.2    0
    107.1    195.3    0
    108.8    198.4    0
    110.5    201.5    0
    112.2    204.6    0
    113.9    207.7    0
    115.6    210.8    0
    117.3    213.9    0
    119    217    0
    120.7    220.1    0
    122.4    223.2    0
    124.1    226.3    0
    125.8    229.4    0
    127.5    232.5    0
    129.2    235.6    0
    130.9    238.7    0
    132.6    241.8    0
    134.3    244.9    0
    136    248    0
    137.7    251.1    0
    139.4    254.2    8.68483699207212E-16
    141.1    257.3    7.0747412484069E-16
    142.8    260.4    3.16314144048309E-16
    144.5    263.5    2.57927268078666E-16
    146.2    266.6    2.10201336313678E-16
    147.9    269.7    9.39557126936031E-17
    149.6    272.8    7.66432154472652E-17
    151.3    275.9    6.2486882353095E-17
    153    279    2.79231558575989E-17
    154.7    282.1    2.27864056844241E-17
    156.4    285.2    1.85847477539341E-17
    158.1    288.3    1.51500906322791E-17
    159.8    291.4    6.77781572948203E-18
    161.5    294.5    5.53001260973771E-18
    163.2    297.6    4.50966758363404E-18
    164.9    300.7    2.01698615188858E-18
    166.6    303.8    1.64621109078316E-18
    168.3    306.9    1.34293314128717E-18
    170    310    6.00487255484304E-19
    171.7    313.1    4.90257417706294E-19
    173.4    316.2    4.00069013274861E-19
    175.1    319.3    3.26319269779939E-19
    176.8    322.4    1.46060319319765E-19
    178.5    325.5    1.19227651295701E-19
    180.2    328.6    9.72797530893709E-20
    181.9    331.7    4.35312058919378E-20
    183.6    334.8    3.55444834474185E-20
    185.3    337.9    2.90100190810771E-20
    187    341    1.2978401058209E-20
    188.7    344.1    1.06001692850398E-20
    190.4    347.2    8.65390623083352E-21
    192.1    350.3    7.06195465145276E-21
    193.8    353.4    3.16221631085381E-21
    195.5    356.5    2.58230947015745E-21
    197.2    359.6    2.10785869170604E-21
    198.9    362.7    9.43630241339956E-22
    200.6    365.8    7.70779415493906E-22
    202.3    368.9    6.2932924625784E-22
    204    372    2.81667943664331E-22
    205.7    375.1    2.30129267804628E-22
    207.4    378.2    1.87944152655156E-22
    209.1    381.3    1.5343097056504E-22
    210.8    384.4    6.87271177018159E-23
    212.5    387.5    5.6142168317316E-23
    214.2    390.6    4.58437564189311E-23
    215.9    393.7    2.05302334002085E-23
    217.6    396.8    1.67746822939822E-23
    219.3    399.9    1.37008442969305E-23
    221    403    6.13429138981351E-24
    222.7    406.1    5.01325476887499E-24
    224.4    409.2    4.09553217852582E-24
    226.1    412.3    3.34456890304728E-24
    227.8    415.4    1.49858527342626E-24
    229.5    418.5    1.22451858636015E-24
    231.2    421.6    1.00020934410348E-24
    232.9    424.7    4.48059272386616E-25
    234.6    427.8    3.66191974660125E-25
    236.3    430.9    2.99175546362215E-25
    238    434    1.3399177568808E-25
    239.7    437.1    1.09531049042395E-25
    241.4    440.2    8.95040172396534E-26
    243.1    443.3    7.31134858265133E-26
    244.8    446.4    3.27678110779158E-26
    246.5    449.5    2.67816427118856E-26
    248.2    452.6    2.18815839553404E-26
    249.9    455.7    9.80474553795661E-27
    251.6    458.8    8.01506968152731E-27
    253.3    461.9    6.54986092151442E-27
    255    465    2.93427662194714E-27
    256.7    468.1    2.39910970...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here