80.2K

Verified Solution

Link Copied!

need to find worksheets caculations

I36:I40

Calculate the total Ski Cost of rejected skis in I41

Recently, the Quality Control QC team noticed an increase in the number of TZBlazer skis being rejected for defects. To determine if improvements in the manufacturing process might be required, a worksheet named Data was created. Your assistance is needed to complete the worksheets calculations.

La copy 11/1 Arial Wrap Text BIU- - 3-A. Format Painter Merge & Cente Clipboard Font Alignment A B C G H 12156 174 E 11/18 0.81 2.11 64.50 FALSE 12160 174 E 11/19 0.68 2.22 64.50 TRUE 12161 174 E 11/19 0.67 2.08 64.50 FALSE 12162 181 E 11/19 0.95 2.01 70.50 TRUE 12136 181 R 1.32 2.35 82.50 TRUE 12137 181 R 0.75 1.73 82.50 TRUE 12138 181 R 0.92 2.08 82.50 TRUE 12141 181 R 0.46 2.26 82.50 TRUE 12143 174 R 1.04 2.24 76.50 TRUE 12147 181 A 0.90 2.01 60.50 TRUE 12150 167 A 0.97 2.00 45.50 TRUE 12151 181 A 0.49 2.08 60.50 FALSE 5 12152181 A 0.75 2.17 60.50 TRUE 7 12153167 A 0.30 3.22 45.50 TRUE 8 12155 181 E 101 2.24 70.50 FALSE 9 12157 181 E 0.84 2.34 70.50 TRUE 0 12158 174 E 0.68 2.10 64.50 TRUE 1 12159 181 A 11/19 0.58 233 70.50 TRUE 29 0.76 2.19 $ 1,803.50 3 # of Skis Average Average Total Value Determining the Number of Items That Meet Specified Criteria 35 Range Criteria Results 36 # Friction Coefficient Rejected >1.23 37 # Torsion Strength Rejected 38 # style 39 # Size 167 40 # Shipped Yes alculating the Total Value of Rejected Skis ----New NNNNN 5 2 Materal Cost Data Time Credit Data Options Purchases Equipment Footware 1 Ready La copy 11/1 Arial Wrap Text BIU- - 3-A. Format Painter Merge & Cente Clipboard Font Alignment A B C G H 12156 174 E 11/18 0.81 2.11 64.50 FALSE 12160 174 E 11/19 0.68 2.22 64.50 TRUE 12161 174 E 11/19 0.67 2.08 64.50 FALSE 12162 181 E 11/19 0.95 2.01 70.50 TRUE 12136 181 R 1.32 2.35 82.50 TRUE 12137 181 R 0.75 1.73 82.50 TRUE 12138 181 R 0.92 2.08 82.50 TRUE 12141 181 R 0.46 2.26 82.50 TRUE 12143 174 R 1.04 2.24 76.50 TRUE 12147 181 A 0.90 2.01 60.50 TRUE 12150 167 A 0.97 2.00 45.50 TRUE 12151 181 A 0.49 2.08 60.50 FALSE 5 12152181 A 0.75 2.17 60.50 TRUE 7 12153167 A 0.30 3.22 45.50 TRUE 8 12155 181 E 101 2.24 70.50 FALSE 9 12157 181 E 0.84 2.34 70.50 TRUE 0 12158 174 E 0.68 2.10 64.50 TRUE 1 12159 181 A 11/19 0.58 233 70.50 TRUE 29 0.76 2.19 $ 1,803.50 3 # of Skis Average Average Total Value Determining the Number of Items That Meet Specified Criteria 35 Range Criteria Results 36 # Friction Coefficient Rejected >1.23 37 # Torsion Strength Rejected 38 # style 39 # Size 167 40 # Shipped Yes alculating the Total Value of Rejected Skis ----New NNNNN 5 2 Materal Cost Data Time Credit Data Options Purchases Equipment Footware 1 Ready

Answer & Explanation Solved by verified expert

See Answer