View the step-by-step solution to:

Total Work in Total Work in Total Work in Total Total Orders Process: Orders Process: Orders Process: Orders: Lines: 24-Jan Placed: Product Placed:...

I need the attached information charted on a run chart and pareto chart.
Date 24-Jan 312 31 103 30 41 34 456 5974 25-Jan 316 26 51 34 26 28 393 930 28-Jan 337 38 55 36 36 23 428 909 Orders in process have 3 main contributors: This information should help drive the Pareto chart. 29-Jan 357 50 59 26 46 22 462 888 1. Pricing Discrepancies = 40% 30-Jan 341 36 88 28 58 29 487 1081 2. Account Mismatch = 30% 31-Jan 334 34 80 27 51 25 465 940 3. Mismatch of Terms or Conditions = 20% 1-Feb 348 28 47 24 50 28 445 904 4. Order Sorting Errors = 10% 4-Feb 328 43 81 21 40 24 449 974 5-Feb 422 39 108 23 69 21 599 1403 6-Feb 364 37 90 24 42 21 496 1117 For the Run Chart: I would recommend adding all WIP (groups A+B+C - columns c+e+g ) and charting them against the total number of orders for that day (column h) 7-Feb 387 39 78 30 49 21 514 1043 For the Pareto: we could calculate the % above for WIP and chart 8-Feb 290 37 34 27 42 24 366 814 This is 8 weeks of data that should be charted by week instead of daily. 11-Feb 395 38 61 31 76 36 532 1149 12-Feb 362 43 64 20 76 32 502 1146 13-Feb 292 43 63 28 73 20 428 989 14-Feb 320 42 89 31 61 18 470 1050 15-Feb 298 44 44 26 53 24 395 806 18-Feb 365 45 72 34 48 10 485 990 19-Feb 350 32 65 20 46 17 461 918 20-Feb 369 25 89 20 52 24 510 1146 21-Feb 394 25 78 8 50 16 522 1068 22-Feb 242 25 50 6 81 18 373 916 25-Feb 252 42 83 11 53 25 388 876 26-Feb 198 60 60 16 61 25 319 761 27-Feb 311 110 65 18 65 30 454 1043 28-Feb 356 145 87 15 60 25 503 1056 1-Mar 330 143 58 10 58 24 446 947 4-Mar 336 196 46 10 60 33 442 1003 5-Mar 294 116 45 12 89 32 428 928 6-Mar 248 197 83 8 70 28 401 1045 7-Mar 372 61 131 14 47 20 550 1235 8-Mar 440 98 37 12 56 43 533 976 11-Mar 244 97 113 45 48 35 405 959 12-Mar 320 124 106 31 87 21 513 988 13-Mar 341 163 97 24 111 24 549 1282 14-Mar 340 104 74 24 76 28 490 1001 15-Mar 255 93 53 26 81 30 389 843 18-Mar 392 61 95 20 39 38 526 1063 19-Mar 357 63 84 20 76 40 517 1079 20-Mar 396 51 70 18 79 62 545 1143 21-Mar 343 50 52 19 67 59 462 911 22-Mar 283 54 37 21 70 51 390 806 Total Orders Placed: Work in Process: Product Total Orders Placed: Work in Process: Product Total Orders Placed: Work in Process: Product Total Orders: Groups Total Lines: Groups
Background image of page 1
Sign up to view the entire interaction

Top Answer

The answer to this question... View the full answer

Pareto and Run Chart Information (1).xlsx

Total
Work in
Total
Work in
Total
Work in
Total
Orders Process: Orders Process: Orders Process: Orders:
24-Jan Placed: Product Placed: Product Placed: Product Groups
312
31
103
30
41
34
456
25-Jan...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online