Making Sales calls Negotiating Contracts Processing Orders Warehousing Activities New customer development Post-sale Customer Service Shipping other total 36,800.00 $ 36,800.00 $ $ 18,400.00 $ 14,370.40 18,400.00 $ 110,400.00 $ 18,400.00 $ $ 14,370 36450 $ 25,167 420 $ 3,360 $ 1,680 2,900 $ 36,142 $ Administrative Wages Advertising Building Depreciation Maintenance Office Equipment Depreciation Promotional Materials Sales Staff Commissions and Wages Shipping Taxes and Insurance Travel Utilities and Fuel Warehouse Wages Other Total in Cost Pool $ 55,200.00 $ $ $ $ $ 420 $ $ 5,800 $ 18,071 $ $ $ $ 420 $ 29,000 $ 234,920 $ 20,300 54,212 73,600.00 $ 43,111.20 $ 12,150.00 $ 13,551 $ 2,100 $ $ 18,071 $ $ 1,528 $ $ 2,596 $ 7,641 $ 11,548 $ 185,897 $ 368,000 71,852 48,600 38,718 8,400 58,000 361,416 42,893 15,283 92,788 6,491 152,817 11,548 1,276,806 $ $ 42,893 5,349 $ 4,639 $ $ 46,394 $ 1,623 8,406 $ 1,298 $ 122,254 37,115 649 $ $ $ 22,923 $ $ 4,639 325 $ $ $ 84,455 $ $ $ 345,128 $ 62,501 $ 136,683 $ 228,025 $ 149,077 $ 85,042 $ Activity Cost Driver Quantity Activity Rate Activity Making Sales Calls Negotitating Contracts Processing Orders Warehousing Activities New Customer Development Shipping Post-Sale Customer Support Other Cost Driver (Activity Measure) # of sales calls # of hours of negotiation # of orders Cost of Goods Sold # of new customers Pounds shipped x Distance in Miles # of support hours Amount of sales dollars per # of sales calls per # of hours of negotiation per # of orders per Cost of Goods Sold per # of new customers per Pounds shipped x Distance in Miles per # of support hours per Amount of sales dollars The purpose of this spreadsheet is to come up with the activity rates. Driver Quantity 215 200 600 Activity Making Sales Calls Negotitating Contracts Processing Orders Warehousing Activities New Customer Development Shipping Post-Sale Customer Support Other Cost Driver (activity measure) # of sales calls # of hours of negotiation # of orders Cost of Goods Sold # of new customers Pounds shipped x Distance in Miles # of support hours Amount of sales dollars $ 1,779,520 17 87,000,000 1,800 3,114,160 $ Making Sales calls Negotiating Contracts Processing Orders Warehousing Activities New customer development Post-sale Customer Service Shipping other total 36,800.00 $ 36,800.00 $ $ 18,400.00 $ 14,370.40 18,400.00 $ 110,400.00 $ 18,400.00 $ $ 14,370 36450 $ 25,167 420 $ 3,360 $ 1,680 2,900 $ 36,142 $ Administrative Wages Advertising Building Depreciation Maintenance Office Equipment Depreciation Promotional Materials Sales Staff Commissions and Wages Shipping Taxes and Insurance Travel Utilities and Fuel Warehouse Wages Other Total in Cost Pool $ 55,200.00 $ $ $ $ $ 420 $ $ 5,800 $ 18,071 $ $ $ $ 420 $ 29,000 $ 234,920 $ 20,300 54,212 73,600.00 $ 43,111.20 $ 12,150.00 $ 13,551 $ 2,100 $ $ 18,071 $ $ 1,528 $ $ 2,596 $ 7,641 $ 11,548 $ 185,897 $ 368,000 71,852 48,600 38,718 8,400 58,000 361,416 42,893 15,283 92,788 6,491 152,817 11,548 1,276,806 $ $ 42,893 5,349 $ 4,639 $ $ 46,394 $ 1,623 8,406 $ 1,298 $ 122,254 37,115 649 $ $ $ 22,923 $ $ 4,639 325 $ $ $ 84,455 $ $ $ 345,128 $ 62,501 $ 136,683 $ 228,025 $ 149,077 $ 85,042 $ Activity Cost Driver Quantity Activity Rate Activity Making Sales Calls Negotitating Contracts Processing Orders Warehousing Activities New Customer Development Shipping Post-Sale Customer Support Other Cost Driver (Activity Measure) # of sales calls # of hours of negotiation # of orders Cost of Goods Sold # of new customers Pounds shipped x Distance in Miles # of support hours Amount of sales dollars per # of sales calls per # of hours of negotiation per # of orders per Cost of Goods Sold per # of new customers per Pounds shipped x Distance in Miles per # of support hours per Amount of sales dollars The purpose of this spreadsheet is to come up with the activity rates. Driver Quantity 215 200 600 Activity Making Sales Calls Negotitating Contracts Processing Orders Warehousing Activities New Customer Development Shipping Post-Sale Customer Support Other Cost Driver (activity measure) # of sales calls # of hours of negotiation # of orders Cost of Goods Sold # of new customers Pounds shipped x Distance in Miles # of support hours Amount of sales dollars $ 1,779,520 17 87,000,000 1,800 3,114,160 $