Question: Problem 4 In the manual simulation of Section 3.3.1 and the Excel file Model 03 04.xls, speed up the service times by decreasing them all

Problem 4 In the manual simulation of Section

Problem 4 In the manual simulation of Section 3.3.1 and the Excel file Model 03 04.xls, speed up the service times by decreasing them all by 20%. What's the effect on the same set of output performance measures? Discuss (in particular) utilization, average time in the system, average time in the queue, L, and Lq? Manual Single-Server-Queue Simulation (spreadsheet-assisted for arithmetic) 0.5636531 4 Given Arrival, Service Times (Minutes) Entity Arrival Interarrival Service Number Time Time Time 1 0.000000 0.486165 2 1.965834 1.965834 0.665121 3 2.275418 0.309584 0.354917 4 2.909957 0.634539 5 5 1.123406 0.051575 6 6 5.136229 1.102866 2.652734 ..652734 7 6.539427 1.403198 0.379540 8 6.744513 0.205086 9 9 7.845616 1.101103 2.9851741 10 8.330407 0.484791 0.290218 0.330272 The last three service times Pink-shaded cells below are not completely general, i.e., the formulas in them depend on these particular given arrival and service times, so this spreadsheet will not in general update correctly with different arrival and service times. are not used. Event Calendar Entity-Based Observations Time in Time in System Queue Next Departure 0.486165 0.000000 0.486165 0.000000 0.665121 Event Event Time Type 0.000000 Initialize 0.000000 Arrival 0.486165 Departure 1.965834 Arrival 2.275418 Arrival 2.630955 Departure 2.909957 Arrival 2.985872 Departure 3.549525 Departure 4.033363 Arrival * 4.084938 Departure pa 5.136229 Arrival 6.539427 Arrival 6.744513 Arrival 7.788963 Departure 7.845616 Arrival 8.000000 End Sim 2.630955 2.630955 2.985872 2.985872 3.549525 0.355537 Next Arrival 0.000000 1.965834 OCTO 1.965834 2.275418 2.909957 2.909957 4.033363 4.033363 4.033363 5.136229 120429 5.136229 --- 6.539427 2012 6.744513 re 7.845616 7.845616 8.330407 8.330407 System State Variables Arrival Times of Customers Entity Server Number in Number in In 1st in 2nd in Number Status System Queue Service Queue Queue 0 0 1 1 0 0.000000 1 0 0 0 1 1 0 1.965834 3 1 2 1 1.965834 2.275418 2 1 1 0 2.275418 4 1 2 1 2.275418 2.909957 1 1 0 2.909957 0 0 0 1 1 0 4.033363 0 0 0 1 1 0 5.136229 1 2 1 5.136229 6.539427 8 1 3 2 5.1362291 6.539427 6.744513 6 1 2 1 6.539427 6.744513 9 1 3 2 6.539427 6.744513 7.845616 1 3 2 6.539427 6.744513 7.845616 Average Need time- weighted averages, not simple averages (036 .. 036) Minimum: 0 0 0 Maximum: 1 3 2 End Simulation 8.000000 8.000000 8.000000 &000000 8.000000 8.000000 8.000000 8.000000 8.000000 8.000000 . 8.000000 . 8.000000 8.000000 8.000000 8.000000 8.000000 8.000000 8.000000 Areas of Individual Rectangles Under Curves Server Number in Number in Busy System Queue 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 000000 0.486165 0.486165 0.000000 000000 0.000000 0.000000 0.000000 0.309584 0.309584 0.000000 0.355537 0.711074 0.355537 0.279002 0.279002 0.000000 Doser 0.075915 0.151830 0.075915 0.563653 0.563653 0.000000 0.000000 0.000000 0.000000 wed 0.051575 0.051575 0.000000 S. . 0.000000 0.000000 0.000000 1.403198 1.403198 0.000000 0.205086 0.410172 110175 0.205086 1.044450 3.133350 2.088900 0.056653 0.113306 0.056653 0.154384 0.463152 0.308768 0.075915 0.710454 0.639568 4.084938 0.000000 0.051575 0.000000 7.788963 7.788963 7.788963 8.168503 8.168503 8.168503 2.652734 1.249536 0.8676 0.2401 0.6232 1.0095 0.3864 0.0516 2.6527 0.0000 The averages in 036.036 are time 1.2495 averages, not simple averages. Problem 4 In the manual simulation of Section 3.3.1 and the Excel file Model 03 04.xls, speed up the service times by decreasing them all by 20%. What's the effect on the same set of output performance measures? Discuss (in particular) utilization, average time in the system, average time in the queue, L, and Lq? Manual Single-Server-Queue Simulation (spreadsheet-assisted for arithmetic) 0.5636531 4 Given Arrival, Service Times (Minutes) Entity Arrival Interarrival Service Number Time Time Time 1 0.000000 0.486165 2 1.965834 1.965834 0.665121 3 2.275418 0.309584 0.354917 4 2.909957 0.634539 5 5 1.123406 0.051575 6 6 5.136229 1.102866 2.652734 ..652734 7 6.539427 1.403198 0.379540 8 6.744513 0.205086 9 9 7.845616 1.101103 2.9851741 10 8.330407 0.484791 0.290218 0.330272 The last three service times Pink-shaded cells below are not completely general, i.e., the formulas in them depend on these particular given arrival and service times, so this spreadsheet will not in general update correctly with different arrival and service times. are not used. Event Calendar Entity-Based Observations Time in Time in System Queue Next Departure 0.486165 0.000000 0.486165 0.000000 0.665121 Event Event Time Type 0.000000 Initialize 0.000000 Arrival 0.486165 Departure 1.965834 Arrival 2.275418 Arrival 2.630955 Departure 2.909957 Arrival 2.985872 Departure 3.549525 Departure 4.033363 Arrival * 4.084938 Departure pa 5.136229 Arrival 6.539427 Arrival 6.744513 Arrival 7.788963 Departure 7.845616 Arrival 8.000000 End Sim 2.630955 2.630955 2.985872 2.985872 3.549525 0.355537 Next Arrival 0.000000 1.965834 OCTO 1.965834 2.275418 2.909957 2.909957 4.033363 4.033363 4.033363 5.136229 120429 5.136229 --- 6.539427 2012 6.744513 re 7.845616 7.845616 8.330407 8.330407 System State Variables Arrival Times of Customers Entity Server Number in Number in In 1st in 2nd in Number Status System Queue Service Queue Queue 0 0 1 1 0 0.000000 1 0 0 0 1 1 0 1.965834 3 1 2 1 1.965834 2.275418 2 1 1 0 2.275418 4 1 2 1 2.275418 2.909957 1 1 0 2.909957 0 0 0 1 1 0 4.033363 0 0 0 1 1 0 5.136229 1 2 1 5.136229 6.539427 8 1 3 2 5.1362291 6.539427 6.744513 6 1 2 1 6.539427 6.744513 9 1 3 2 6.539427 6.744513 7.845616 1 3 2 6.539427 6.744513 7.845616 Average Need time- weighted averages, not simple averages (036 .. 036) Minimum: 0 0 0 Maximum: 1 3 2 End Simulation 8.000000 8.000000 8.000000 &000000 8.000000 8.000000 8.000000 8.000000 8.000000 8.000000 . 8.000000 . 8.000000 8.000000 8.000000 8.000000 8.000000 8.000000 8.000000 Areas of Individual Rectangles Under Curves Server Number in Number in Busy System Queue 0.000000 0.000000 0.000000 0.000000 0.000000 0.000000 000000 0.486165 0.486165 0.000000 000000 0.000000 0.000000 0.000000 0.309584 0.309584 0.000000 0.355537 0.711074 0.355537 0.279002 0.279002 0.000000 Doser 0.075915 0.151830 0.075915 0.563653 0.563653 0.000000 0.000000 0.000000 0.000000 wed 0.051575 0.051575 0.000000 S. . 0.000000 0.000000 0.000000 1.403198 1.403198 0.000000 0.205086 0.410172 110175 0.205086 1.044450 3.133350 2.088900 0.056653 0.113306 0.056653 0.154384 0.463152 0.308768 0.075915 0.710454 0.639568 4.084938 0.000000 0.051575 0.000000 7.788963 7.788963 7.788963 8.168503 8.168503 8.168503 2.652734 1.249536 0.8676 0.2401 0.6232 1.0095 0.3864 0.0516 2.6527 0.0000 The averages in 036.036 are time 1.2495 averages, not simple averages

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1-1 Explain the components that make up the definition of consumer behavior.

Manual Single-Server-Queue Simulation (spreadsheet-assisted for arithmetic) LCLORO SE Ge As Mere Arri Time Time 1 OOOOOO 1.54 1.965834 . 2215418 0.109554 010 2017 0.6145 0.56 40161 LO 0515 109 11M...

Help with problem ! Problem 4 In the manual simulation of Section 3.3.1 and the Excel file Model 03 04.xls, speed up the service times by decreasing them all by 20%. What's the effect on the same set...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Submitted to Management Science manuscript MS-0001-1922.65 Authors are encouraged to submit new papers to INFORMS journals by means of a style file template, which includes the journal title....

IfyouhaveplayedaSimulationcalledProBankerIneedhelpansweringthesequestionsassoonaspossible from the pro bankerassignment attachment..please use spreadsheet and players manual for reference. Need...

Yego Domestic: a bond is issued in the US Global: a bond is issued in the US and foreign markets Eurobonds: a bond denominated in USD is issued in the foreign market. You need to estimate the...

D O NO T Ta KE IF YOU CANNOT ANSWEAR ALL THE QUESTION AS SUPPOSED OR I WILL RATE UNHELPFUL AND REPORT FOR PLAG Peru Domestic: a bond is issued in the US Global: a bond is issued in the US and foreign...

Assignment USE THE HARVARD REFERENCING SYSTEM THROUGHOUT THE REPORT Problem 1 (25 pts) The cost of 14 models of digitals cameras at a camera specialty store during 2014 was as follows: 340 450 450...

seventh pages Chapter 3 Curve Sketching How much metal would be required to make a 400-mL soup can? What is the least amount of cardboard needed to build a box that holds 3000 cm3 of cereal? The...

FILM REVIEW (HARRY POTTER) Talk about: 1. The plot = the genre and basic story 2. The main characters identity & personality. How did they develop in the film? 3. The themes and your opinion of the...

John Stevens owned a dilapidated apartment that he rented to James and Cora Chesney for a low rent. The Chesneys began to remodel and rehabilitate the unit. Over a four-year period, they installed...

What should not be done if an error is made on a pay cheque given to an employee a . Do not inform the employee b . The original cheque should be voided and a new one issued. c . Make the necessary...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...