Part B only

15-27 (0BJECTIVE 15-3) a. As a staff auditor, you need to develop a sampling plan and select an unbiased ran- dom sample for each of the three independent scenarios listed below. The in-charge on the audit engagement has instructed you to use the Excel RANDBETWEEN function to select the sample items. For each scenario, develop a sampling plan that includes defining the sampling unit, establishing a numbering system for the popula- tion, and determining how to use the Excel RANDBETWEEN function to select the sample. After the plan has been designed, select the sample items according to the plan. Assume that the sample size is 75 for each of (1) through (3) (1) Prenumbered sales invoices in a sales journal where the lowest invoice number is 1 and the highest is 8274 (2) Prenumbered bills of lading where the lowest document number is 18221 and the highest is 29427 15-27 (0BJECTIVE 15-3) a. As a staff auditor, you need to develop a sampling plan and select an unbiased ran- dom sample for each of the three independent scenarios listed below. The in-charge on the audit engagement has instructed you to use the Excel RANDBETWEEN function to select the sample items. For each scenario, develop a sampling plan that includes defining the sampling unit, establishing a numbering system for the popula- tion, and determining how to use the Excel RANDBETWEEN function to select the sample. After the plan has been designed, select the sample items according to the plan. Assume that the sample size is 75 for each of (1) through (3) (1) Prenumbered sales invoices in a sales journal where the lowest invoice number is 1 and the highest is 8274 (2) Prenumbered bills of lading where the lowest document number is 18221 and the highest is 29427