\begin{tabular}{|c|c|} \hline Allocate Overhead Costs based on Wages and Salaries & \\ \hline Supporting Direct Labor: $500,00025%= & $125,000 \\ \hline Order Processing: $500,00030%= & $150,000 \\ \hline Customer Support: $500,00020%= & $100,000 \\ \hline Delivery: $500,00020%= & $100,000 \\ \hline Other: $500,0005%= & $25,000 \\ \hline TOTAL & $500,000 \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline \multicolumn{2}{|l|}{ Allocate Overhead Costs based on Auto and Truck Expenses } \\ \hline Supporting Direct Labor: $150,00010%= & 15,000 \\ \hline Order Processing: $150,0000%= & $ \\ \hline Customer Support: $150,00010%= & 15,000 \\ \hline Delivery: $150,00080%= & $120,000 \\ \hline Other: $150,0000%= & $ \\ \hline TOTAL & $150,000 \\ \hline & \\ \hline \multicolumn{2}{|l|}{ Allocate Overhead Costs based on Other Overhead Costs } \\ \hline Supporting Direct Labor: $125,00030%= & 37,500 \\ \hline Order Processing: $125,00020%= & 25,000 \\ \hline Customer Support: $125,00025%= & 31,250 \\ \hline Delivery: $125,00010%= & $12,500 \\ \hline Other: $125,00015%= & $18,750 \\ \hline TOTAL & $125,000 \\ \hline \multicolumn{2}{|l|}{ Allocate Overhead Costs based on Other Overhead Costs } \\ \hline Supporting Direct Labor: $125,000+$15,000+$37,500= & $177,500 \\ \hline Order Processing: $150,000+$0+$25,000= & $175,000 \\ \hline Customer Support: $100,000+$15,000+$31,250= & $146,250 \\ \hline Delivery: $100,000+$0+$12,500= & $112,500 \\ \hline Other: $25,000+$0+$18,750= & $43,750 \\ \hline TOTAL & $655,000 \\ \hline \end{tabular} 2. Based on the above information and estimated activity drivers for the year, calculate activity rates for each activity \begin{tabular}{|l|l|r|r|l|} \hline Activity & Activity Measure & \begin{tabular}{c} Activity for \\ the Year \end{tabular} & & \\ \hline Supporting Direct Labor & Direct labor hours & 22,000 & & \\ \hline Order Processing & \# of Orders & 800 & & \\ \hline & & & \\ Customer Support & Number of Customers & 250 & & \\ \hline Delivery & \# of Deliveries & 700 & & \\ \hline Other & N/A & N/A & & \\ \hline \end{tabular}