I am stuck on 3&4.

Biltrite Bicycles' recorded additions to factory equipment increased approximately 20% from 2019 to 2020. The recorded additions for 2020 totaled $9,000,000. Although controls over factory equipment additions have been evaluated as effective in prior years, the financial statement audits have uncovered occasional instances in which items on vendor invoices that should have been expensed were capitalized. Since errors of this nature cause the factory equipment account to be overstated, you have been instructed to use probability-proportional-to-size (PPS) sampling to determine the extent to which such misstatements occurred during 2020. Your supervisor set the following sampling plan parameters Risk of incorrect acceptance: 15% Tolerable misstatement: $450,000 (5% of recorded additions) Expected misstatement: $180,000 (2% of recorded additions) An Excel file, Case Assignment 10 Solution, containing the three workpapers listed below is posted on Blackboard in the Information\\Textbook Chapter 10\\Case Assignment 10 folder. WP 11.3A: Sample Size and Sampling Interval Information. WP 11.3B: Calculation of Projected Misstatement. WP 11.3C: Calculation of Upper Misstatement Limit. Download the Excel file and save it to an Excel file named "Your Name" - Case Assignment 10 Solution Required: 1. Review the Sample Size and Sampling Interval Information on WP 11.3A. Insert your name and the date you reviewed the workpaper. 2. Finish the partially completed Calculation of Projected Misstatement on WP 11.3B. Insert your name and the date you finished the workpaper. 3. Prepare a Calculation of Upper Misstatement Limit in good form on WP 11.3C. Show all supporting calculations. Insert your name and the date you finished the workpaper 4. Document your evaluation of the sampling results at the bottom of WP 11 30. Include: a. Your statistical conclusion. b. The audit decision you reached based on your quantitative sampling results, including the reason for your decision.AutoSave . Off Shasta Outland - Case Assignment 10 Solution - Search Shasta Ou File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Insert E Arial 11 AA ab Wrap Text General Delete Paste B IU HY Merge & Center $ ~ % " Conditional Format as Cell Sor Formatting ~ Table ~ Styles [ Format Filte Clipboard Font Alignment Number Styles Cells Edit F11 fx B D E F G H J K WP 11.3C BIL TRITE BICYCLES, INC. - December 31, 2020 Name: Shasta Outland 3 PPS Sampling Analysis of Factory Equipment Additions Date: 5/10/2021 10 11 12 13 21 -22 Sample Size and SI Projected Misstatement Upper Misstatement Limit +ave ( Off ShastaOutland - Case Assignment 10 Solution . Search Shasta Outland Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Arial ~ 11 AA 20 Wrap Text General Insert Delete ~ BI UVE Merge & Center " $ ~ % 9 78 98 Conditional Format as Cell Sort & Find & Formatting Table ~ Styles ~ Format ~ Filter ~ Select board Font Alignment Number Styles Cells Editing C D E F G H WP 11.3B BILTRITE BICYCLES, INC. - December 31, 2020 Name: Shasta Outland PPS Sampling Analysis of Factory Equipment Additions Date 5/10/2021 Calculation of Projected Misstatement Invoice Misstatement Tainting % Sampling Projected Number Vendor Book Value Audit Value (BV-AV) (BV-AV)/BV Interval Misstatement 372134 Loxley Machine Works, Ltd $166,580 $152,060 $14, 520 8.72% $1,915 $167 1778927 Gerald Equipment and Parts, Inc. $2,360 $0 $2,360 100.00% $27 $27 10 3668498 Cradle Corporation $98,530 $96,000 $2,530 2.57% $1, 133 $29 11 9873625 Johnson's Welding and Machining $15,570 $15,000 $570 3.66% $179 $7 12 10224680 Laidlow Parts and Repairs $28,790 $28,000 $790 2.74% $331 $9 13 $311,830 $291 060 $20, 770 $239 14 15 16 17 18 19 20 22 Sample Size and SI Projected Misstatement Upper Misstatement Limit + TB C D E F WP 11.3A N BIL TRITE BICYCLES, INC. - December 31, 2020 Name: 3 PPS Sampling Analysis of Factory Equipment Additions Date: 5 Sample Size and Sampling Interval Information N Recorded factory equipment additions $9,000,000 8 Risk of incorrect acceptance 15.00% 9 Tolerable misstatement $450,000 (5% of recorded additions) 10 Expected misstatement $180,000 (2% of recorded additions) 11 Sample size used 87 (rounded up from 86.4) 12 Sampling interval $103,000 (rounded down from $103,448) 13 14 15 16 17 18 19 20 21 22 23 24 25