Answers needed for the highlighted cells, formula needed as well. For example "=B7+C7". i Will Like

Saved ipboard in Font Styles 1 fx The following information relates to overhead cost at Chocolates by Jacki for the A B C D E G The following information relates to overhead cost ht Chocolates by Jacki for the current year. Total costs and distribution of resource consumption across activity cost pools: Activity. Cost Pools 5 6 Production Department: 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities 10 Factory property taxes and insurance 11 12 Genenal Administrative Department: 13 Administrative wages and salaries 14 Office equipment depreciation 15 Administrative property taxes and insurance: \begin{tabular}{c|c|c|c|c|c|} & Customer & Product & Customer \\ Total Cost & Orders & Development & Relations & Other & Total \end{tabular} 16 17 Marketing Department: 18 Marketing wages and salaries 19 Selling expenses \begin{tabular}{rr} \$ 400,000 \\ \hline 150,000 \\ \hline 120,000 \\ \hline 75,000 \\ \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|} \hline 50% & 30% & 15% & 5% & 100% \\ \hline 55% & 30% & 0% & 15% & 100% \\ \hline 59% & 34% & 0% & 7% & 100% \\ \hline 57% & 33% & 0% & 10% & 100% \\ \hline \end{tabular} 20 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 22 When completing the able, copy formulas as appropriate. Activity Cost Pools 25 Sheet1 AEsor Attempte) Saved A1 vvfx The following information relates to overhead cost at Chocolates by Jacki for \begin{tabular}{|l|c|} \hline 1 & U \\ \hline 22 & Use the data to complete a First-Stage Allocation to Activity Cost Pools. \end{tabular} C D E F When completing the table, copy formulas as appropriate. \begin{tabular}{|l|l|} \hline 22 & \\ \hline 24 & \\ \hline 25 & \\ \hline 26 & Production Department: \end{tabular} Activity Cost Pools \begin{tabular}{|l|l|} \hline 27 & \\ \hline 28 & \\ 29 & \\ 30 & \\ 31 & \\ 32 & General Administration Department: \\ 33 & \\ \hline 34 & \end{tabular} Total \begin{tabular}{|l|l|} \hline 32 & General Administration Dep. \\ 34 & \\ 35 & \\ 36 \\ 37 & Marketing Department: \\ 38 & \\ 39 \end{tabular} \begin{tabular}{|l|l|} 39 & \\ 40 & \\ 41 & Total \\ 42 & \end{tabular}