Question
Consider the 'Change' column (E) in the table privided below. Click the icon to view the Thompson Industries' supplier file. (Table Shown Below) a) Determine
Consider the 'Change' column (E) in the table privided below. Click the icon to view the Thompson Industries' supplier file. (Table Shown Below)
a) Determine the upper and lower limits for a 3 standard deviation accuracy check.
The upper limit for a 3-standard-deviation accuracy check is $_________
The lower limit for a 3-standard-deviation accuracy check is $__________ a negative value, if necessary).
b) Which, if any, values fall outside the limits computed in part a)?
A. Change values for Cowboy Pete's Lumber and Smart Electronics, Inc. fall outside the limits.
B. Change values for Jones Aluminum & Copper and Smart Electronics, Inc. fall outside the limits.
C. Change values for Fred's Foam Molding and Cowboy Pete's Lumber fall outside the limits.
D. No values fall outside the limits. (round your response to the nearest dollar). (round your response to the nearest dollar and use a minus sign to enter
\begin{tabular}{|c|l|r|r|r|r|r|r|r|c|c|} \hline & \multicolumn{1}{|c|}{ A } & B & C & D & E & F & G & H & I & J \\ \hline 1 & Thompson Industries Monthly Supplier Report - April & & & & & & & \\ \hline 2 & & & & & & & & & \\ \hline 3 & SupplierName & SupNo & SupCat & Purchases & Change & Quality & On-Time & Returns & RejShip & NewSup \\ \hline 4 & Maverick Supplies & 6071 & P & $41,047 & $31,001 & 5 & 100% & 0% & 0 & N \\ \hline 5 & Cowboy Pete's Lumber & 6894 & P & $24,853 & $848 & 5 & 90% & 0% & 0 & N \\ \hline 6 & ABC Metals & 5054 & S & $17,580 & $17,580 & 3 & 0% & 75% & 2 & Y \\ \hline 7 & Perkins Plastics & 5528 & P & $28,468 & $2,065 & 4 & 100% & 3% & 0 & N \\ \hline 8 & Everything Brass & 4413 & P & $30,199 & ($3,842) & 5 & 100% & 0% & 0 & N \\ \hline 9 & Jones Aluminum \& Copper & 5858 & P & $16,637 & $16,637 & 4 & 50% & 5% & 0 & Y \\ \hline 10 & Rick's Wrought Iron & 9733 & S & $29,950 & ($2,717) & 1 & 60% & 80% & 0 & N \\ \hline 11 & Penelope's Paper Products & 4718 & P & $26,068 & $8,098 & 3 & 100% & 12% & 1 & N \\ \hline 12 & Anthony's Adhesives & 9944 & P & $22,491 & $5,445 & 4 & 90% & 4% & 3 & N \\ \hline 13 & Columbus Manufacturing & 1343 & S & $20,375 & $671 & 4 & 100% & 0% & 0 & N \\ \hline 14 & Smart Electronics, Inc. & 4785 & P & $30,120 & $30,120 & 2 & 33% & 50% & 0 & Y \\ \hline 15 & Watson Woodworking & 2730 & S & $27,577 & $11,815 & 5 & 25% & 1% & 0 & N \\ \hline 16 & Fred's Foam Molding & 2949 & S & $45,821 & $45,821 & 5 & 100% & 0.50% & 0 & Y \\ \hline 17 & Inpenetrable Insulation, Inc. & 1443 & P & $24,452 & ($4,112) & 4 & 15% & 4% & 0 & N \\ \hline 18 & Suzy's Shipping Supplies & 8039 & P & $24,146 & $703 & 5 & 50% & 0% & 7 & N \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started