Question: For the Change column (E) in Figure G.5: a) Determine the upper and lower limits for a 3-standarddeviation accuracy check. b) Which, if any, values

For the ‘Change’ column (E) in Figure G.5:

A B C 1 Thompson Industries Monthly Supplier Report - April 2


a) Determine the upper and lower limits for a 3-standarddeviation accuracy check.

b) Which, if any, values fall outside the limits computed in part (a)?

A B C 1 Thompson Industries Monthly Supplier Report - April 2 3 SupplierName 4 Maverick Supplies 5 Cowboy Pete's Lumber 6 ABC Metals 7 Perkins Plastics 8 Everything Brass 9 Jones Aluminum & Copper 10 Rick's Wrought Iron 11 Penelope's Paper Products 12 Anthony's Adhesives 13 Columbus Manufacturing 14 Smart Electronics, Inc. 15 Watson Woodworking 16 Fred's Foam Molding 17 Impenetrable Insulation, Inc. 18 Suzy's Shipping Supplies Sup No 6071 6894 5054 5528 4413 5858 9733 4718 9944 1343 4785 2730 2949 1443 8039 SupCat P P S P P P S P P S P S S P P D Purchases $39,117 $25,554 $13,051 $27,886 $29,300 $16,862 $29,078 $25,716 $22,750 $20,103 $30,062 $32,589 $47,886 $24,971 $23,851 E Change $5,000 $400 $13,051 $3,256 ($4,658) $16,862 ($3,121) $8,795 $1,268 $469 $30,062 $471 $47,886 ($6,895) $1,269 F Quality 5 5 3 4 5 4 1 3 4 4 2 5 5 4 5 G On-Time 100% 90% 0% 100% 100% 50% 60% 100% 90% 100% 33% 25% 100% 15% 50% H Returns 0% 0% 75% 3% 0% 5% 80% 12% 4% 0% 50% 1% 0.50% 4% 0% RejShip 0 0 2 0 0 1 6 0 0 0 0 0 0 0 0 New Sup N N Y N N Y N N N N Y N Y N N

Step by Step Solution

3.55 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a Average 5000 400 13051 3256 4658 16862 3121 8795 ... View full answer

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 Operations Management Questions!