Chapter 4 Problems Template (1) - Protected View . Search oSave . Off Home Insert Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing COULDN'T VERIFY SUBSCRIPTION Excel couldn't verify your Microsoft 365 subscription, Please make sure that you're connected to the Internet. Retry X V fx B C D E F G H K L M A Activity Data Activity Units Test A Test B Test C Test Activity Annual Costs Cost Driver Test A Test B Test C Test D Total Units a. Allocation Rate Cost/Test Cost/Test Cost/Test Cost/Te Receive Specimens $10,000 # tests 2,000 1,500 1,000 500 5,000 $2.00 Set Up Equipment $25,000 # min/test 5 5 10 10 Run Tests $100,000 # min/test 1 5 10 20 Record Results $10,000 # min/test N IN 2 4 Transmit Results $5,000 # min/test W 3 3 3 Total Costs $150,000 b. Total Costs/Test 0 NOTE: Fill in the shaded cells to calculate the answers c. Total (all tests) 13 14 15 16 17 18