Submit the homework as an excel file. Do NOT submit a word file. All answers should be clearly labelled on the excel spreadsheet. Problem 1 The local Department of Motor Vehicles office (DMV) is designed so that people enter the office and go to a reception desk to retrieve a ticket number for service. There are three different services available, permit test, photo license and other. On average 75 people per hour enter the DMV and approximately 65% of the people renew licenses, 25% are there to take a permit test and 10% have other issues that need to be addressed. The process flow diagram is below: Get Pass/Fail paperwork stamped: Wait for Permit Agent: 3 people Take Permit Test: 30 min. 3 min. 75 people/hr Resolve issue: Wait for Ticket: Wait for Special Agent: 1 person Get Ticket: 1 min. 5 people 655 Wait for License Agent Renew License: 15 min. earch ul-Hiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Assume a stable process and use the information above to determine the following 1. How long does the average person wait in the buffer "Wait for Ticket? 2. How many people are in the activity "Get Ticket? 3. How long does the average person wait in the buffer "Wait for Permit Agent? 4. How long does the average person wait in the buffer "Wait for License Agent"? 5. How long does the average person wait in the buffer "Wait for Special Agent"? 20SP OPM 352 Homework 30 points 6. How long does the average person coming to renew a license spend in the DMV from the time they enter to the time they leave? 7. How long does the average person coming to take a permittest spend in the DMV from the time they enter to the time they leave? to search 6. How long does the average person coming to renew a license spend in the DMV from the ti they enter, to the time they leave? 7. How long does the average person coming to take a permit test spend in the DMV from the time they enter to the time they leave? 8. How long does the average person coming for a special issue spend in the DMV from the time they enter, to the time they leave? 9. How many people on average are in the activity of Take Permit Tests? 10. What is the average number of people in the DMV? 11. What is the average time for an average person to get through the DMV? 12. What is the Flow Unit? e to search Submit the homework as an excel file. Do NOT submit a word file. All answers should be clearly labelled on the excel spreadsheet. Problem 1 The local Department of Motor Vehicles office (DMV) is designed so that people enter the office and go to a reception desk to retrieve a ticket number for service. There are three different services available, permit test, photo license and other. On average 75 people per hour enter the DMV and approximately 65% of the people renew licenses, 25% are there to take a permit test and 10% have other issues that need to be addressed. The process flow diagram is below: Get Pass/Fail paperwork stamped: Wait for Permit Agent: 3 people Take Permit Test: 30 min. 3 min. 75 people/hr Resolve issue: Wait for Ticket: Wait for Special Agent: 1 person Get Ticket: 1 min. 5 people 655 Wait for License Agent Renew License: 15 min. earch ul-Hiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Enable Editing Assume a stable process and use the information above to determine the following 1. How long does the average person wait in the buffer "Wait for Ticket? 2. How many people are in the activity "Get Ticket? 3. How long does the average person wait in the buffer "Wait for Permit Agent? 4. How long does the average person wait in the buffer "Wait for License Agent"? 5. How long does the average person wait in the buffer "Wait for Special Agent"? 20SP OPM 352 Homework 30 points 6. How long does the average person coming to renew a license spend in the DMV from the time they enter to the time they leave? 7. How long does the average person coming to take a permittest spend in the DMV from the time they enter to the time they leave? to search 6. How long does the average person coming to renew a license spend in the DMV from the ti they enter, to the time they leave? 7. How long does the average person coming to take a permit test spend in the DMV from the time they enter to the time they leave? 8. How long does the average person coming for a special issue spend in the DMV from the time they enter, to the time they leave? 9. How many people on average are in the activity of Take Permit Tests? 10. What is the average number of people in the DMV? 11. What is the average time for an average person to get through the DMV? 12. What is the Flow Unit? e to search