\begin{tabular}{|l|l|l|} \hline 21 & \\ \hline 22 & Required: \\ \hline 23 & Use the data to complete a First-Stage Allocation to Activity Cost Pools. \\ \hline 24 & When completing the table, copy formulas as approriate. \\ \hline 25 & \\ \hline 26 & (Use cells A5 to G20, as well as the "Chart of Accounts" tab for cell referencing and/or formulas needed to complete this question.) \\ \hline 27 & \\ \hline \end{tabular} A B C D G H 1 \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 2 & \multicolumn{7}{|c|}{ The following information relates to overhead cost at Chocolates by Jacki for the current year. } \\ \hline 3 & \multicolumn{7}{|c|}{ Total costs and distribution of resource consumption across activity cost pools: } \\ \hline 4 & & & & & & & \\ \hline 5 & & & \multicolumn{4}{|c|}{ Activity Cost Pools } & \multirow[b]{2}{*}{ Total } \\ \hline 6 & & Total Cost & CustomerOrders & ProductDevelopment & CustomerRelations & Other & \\ \hline 7 & Production Department: & & & & & & \\ \hline 8 & Indirect factory wages & $400,000 & 50% & 30% & 15% & 5% & 100% \\ \hline 9 & Factory equipment depreciation & 150,000 & 55% & 30% & 0% & 15% & 100% \\ \hline 10 & Factory utilities & 120,000 & 59% & 34% & 0% & 7% & 100% \\ \hline 11 & Factory property taxes and insurance & 75,000 & 57% & 33% & 0% & 10% & 100% \\ \hline \multicolumn{8}{|l|}{12} \\ \hline 13 & General Administrative Department: & & & & & & \\ \hline 14 & Administrative wages and salaries & 275,000 & 20% & 10% & 40% & 30% & 100% \\ \hline 15 & Office equipment depreciation & 40,000 & 32% & 16% & 15% & 37% & 100% \\ \hline 16 & Adminstrative property taxes and insurance & 60,000 & 0% & 0% & 0% & 100% & 100% \\ \hline \multicolumn{8}{|l|}{17} \\ \hline 18 & Marketing Department: & & & & & & \\ \hline 19 & Marketing wages and salaries & 150,000 & 20% & 10% & 40% & 30% & 100% \\ \hline 20 & Selling expenses & 100,000 & 32% & 16% & 15% & 37% & 100% \\ \hline 21 & & & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline 26 & \multicolumn{6}{|c|}{ (Use cells A5 to G20, as well as the "Chart of Accounts" tab for cell referencing and/or formulas needed to complete this question.) } \\ \hline 27 & & & & & & \\ \hline 28 & \multicolumn{6}{|c|}{ Activity Cost Pools } \\ \hline 29 & & Customer Orders & ProductDevelopment & CustomerRelations & Other & Total \\ \hline 30 & Production Department: & & & & & \\ \hline 31 & Indirect factory wages & T & & & & T \\ \hline 32 & Factory equipment depreciation & V & r & & r & r \\ \hline 33 & Factory utilities & V & r & r & r & r \\ \hline 34 & Factory property taxes and insurance & T & r & r & r & r \\ \hline 35 & & & & & & \\ \hline 36 & General Administration Department: & & & & & \\ \hline 37 & Administrative wages and salaries & T & T & & r & T \\ \hline 38 & Office equipment depreciation & T & r & r & r & r \\ \hline 39 & Adminstrative property taxes and insurance & V & r & r & r & r \\ \hline 40 & & & & & & \\ \hline 41 & Marketing Department: & & & & & \\ \hline 42 & Marketing wages and salaries & T & r & r & r & r \\ \hline 43 & Selling expenses & & r & r & r & r \\ \hline 44 & Total & & T & T & T & T \\ \hline \end{tabular}