AutoSave . On - - Chapter 4 Problems Template (1) - Protected View . Search File 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 i COULDN'T VERIFY SUBSCRIPTION Excel couldn't verify your Microsoft 365 subscription. Please make sure that you're connected to the Internet. Retry All X V fx A B C D E F G H K M Activity Data Activity Units Test A Test B Test C Test D N P 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/Test 3 Receive Specimens $10,000 # tests 2,000 1,500 1,000 500 5,000 $2.00 4 Set Up Equipment $25,000 # min/test 5 5 10 10 Run Tests $100,000 # min/test 5 10 20 6 Record Results $10,000 # min/test 2 2 4 7 Transmit Results $5,000 # min/test 3 3 3 3 8 Total Costs $150,000 b. Total Costs/Test 9 10 NOTE: Fill in the shaded cells to calculate the answers c. Total (all tests) 11 12 13 14 15 16 17 18 19 20