Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed \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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Management Information Systems

Authors: Ken Laudon, Kenneth C Laudon

10th Edition

0133033090, 9780133033090

More Books

Students also viewed these General Management questions

Question

1. Why do we trust one type of information more than another?

Answered: 1 week ago