Case Study Week 5 Excel

Case Study Week 5 Excel - 30 Check file for violations and...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
State Automobile License-Renewal Process Times Step 1 Review renewal application for correctness 2 Process and record payment 3 Check file for violations and restrictions 4 Conduct eye test 5 Photograph applicant 6 Issue temporary license Total 4) Step 1 2 3 4 5 6 In order to achieve 120 renewals the propsed solutio steps 2-5, and adding 15 seconds to step 1 to create
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Discussion Ques Average Time to Perform (sec) 1) 15 30 60 40 20 2) 30 195 3) Average Time to Perform (sec) Review renewal application for correctness 15 Process and record payment
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 30 Check file for violations and restrictions 60 Conduct eye test 40 Photograph applicant 20 Issue temporary license 30 Total 195 ion will be to get 30 sec per average time to perform. By adjusting e balance and each step equaling 30 secs. stions Seconds Hour (Min) / Avg. Time to Perform = 60 60 / 195 = 3600 / 195 = 18.46 Seconds Hour (Min) / Avg. Time to Perform = 60 60 / 165 = 3600 / 165 = 21.82 Seconds Hour (Min) / Avg. Time to Perform = 60 60 / 97.5 = 3600 / 97.5 = 36.92...
View Full Document

This note was uploaded on 06/19/2010 for the course MGMT 101 taught by Professor Hamilton during the Spring '10 term at Baylor College of Dentistry.

Page1 / 3

Case Study Week 5 Excel - 30 Check file for violations and...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online