This expert answer really helped me, check it out!
Open the app to get the solution:
https://chegg-study.app.link/sF1kHLinTyb
Download the Excel template and data file and complete the questions below. Creations is a wholesaler that bakes and decorates special occasion multi-tiered cakes, the majority of which are wedding cakes. The supervisor, Clara Cook, is questioning if using direct labor cost provides an accurate allocation base for overhead assigned to each cake. Creations uses job costing for each job which usually consists of six to nine cakes. Cakes produced for each job are delivered to local retail locations that have ordered the cakes for their respective customers. After meeting with the cost accountant, Clara identified seven activities used in the production of cakes. She has provided estimates of the annual activities along with the actual usage of activities for the jobs completed during the busiest quarter of the year presented here. Activities, drivers, annual estimated activity, and estimated annual overhead cost Download the Excel template and data file and complete the questions below. Creations is a wholesaler that bakes and decorates special occasion multi-tiered cakes, the majority of which are wedding cakes. The supervisor, Clara Cook, is questioning if using direct labor cost provides an accurate allocation base for overhead assigned to each cake. Creations uses job costing for each job which usually consists of six to nine cakes. Cakes produced for each job are delivered to local retail locations that have ordered the cakes for their respective customers. After meeting with the cost accountant, Clara identified seven activities used in the production of cakes. She has provided estimates of the annual activities along with the actual usage of activities for the jobs completed during the busiest quarter of the year presented here. Activities, drivers, annual estimated activity, and estimated annual overhead cost Activities, drivers, annual estimated activity, and estimated annual overhead cost \begin{tabular}{llllllllll} 439 & 31.21 & 0.95 & 2.66 & 11.75 & 17.34 & 0.58 & 2.09 & 7 \\ 440 & 29.47 & 0.98 & 2.67 & 12.08 & 19.19 & 0.64 & 2.02 & 6 \\ 441 & 29.51 & 1.01 & 2.75 & 13.46 & 17.62 & 0.56 & 2.11 & 4 \\ 442 & 29.86 & 0.95 & 2.66 & 14.63 & 17.35 & 0.57 & 2.44 & 5 \\ 443 & 31.39 & 0.98 & 2.68 & 14.68 & 19.70 & 0.58 & 2.03 & 4 \\ 444 & 27.98 & 1.01 & 2.79 & 11.10 & 17.77 & 0.61 & 2.06 & 6 \\ 445 & 28.00 & 1.02 & 2.78 & 12.33 & 18.98 & 0.57 & 2.08 & 5 \\ 446 & 27.83 & 0.99 & 2.66 & 14.36 & 18.68 & 0.58 & 2.41 & 4 \\ 447 & 31.87 & 1.02 & 2.68 & 11.99 & 18.43 & 0.61 & 2.48 & 6 \\ 448 & 29.75 & 0.96 & 2.79 & 11.07 & 18.13 & 0.59 & 2.49 & 6 \\ \hline 449 & 31.20 & 0.97 & 2.78 & 13.21 & 18.08 & 0.63 & 2.03 & 7 \\ 450 & 30.37 & 0.96 & 2.66 & 11.42 & 17.16 & 0.59 & 2.38 & 6 \\ \hline 451 & 28.43 & 0.95 & 2.67 & 12.64 & 19.03 & 0.57 & 2.17 & 6 \\ 452 & 29.69 & 0.98 & 2.75 & 13.97 & 17.33 & 0.58 & 2.26 & 5 \\ 453 & 29.76 & 0.95 & 2.66 & 14.60 & 18.71 & 0.64 & 2.17 & 4 \\ 454 & 28.67 & 0.98 & 2.68 & 13.89 & 19.53 & 0.56 & 2.35 & 6 \\ 455 & 28.54 & 1.01 & 2.79 & 11.48 & 17.86 & 0.57 & 2.31 & 4 \end{tabular} Question 1 of 1 11 45645745845946046146246346446546646746846929.4530.8529.3428.5129.1427.1631.5127.8027.4428.5329.8429.6331.5830.681.020.991.020.960.970.960.950.981.011.020.991.020.960.972.782.662.672.752.662.682.662.682.792.782.662.672.752.7612.1111.7013.7314.6313.9312.5811.5612.2413.5114.8714.8914.5414.4711.5020.0017.2119.0019.2619.1417.6719.8017.9717.8818.5017.1317.5717.5319.550.580.610.630.610.590.630.640.560.570.580.610.590.630.632.492.462.092.332.372.082.062.072.332.462.292.072.042.3954455654447576 here are four parts to this problem. Use Excel to perform the following. etermine the average daily usage of each activity. (Round answers to 2 decimal ploces, e.s. 15.25.) Attempts: 0 of 2 used Download the Excel template and data file and complete the questions below. Creations is a wholesaler that bakes and decorates special occasion multi-tiered cakes, the majority of which are wedding cakes. The supervisor, Clara Cook, is questioning if using direct labor cost provides an accurate allocation base for overhead assigned to each cake. Creations uses job costing for each job which usually consists of six to nine cakes. Cakes produced for each job are delivered to local retail locations that have ordered the cakes for their respective customers. After meeting with the cost accountant, Clara identified seven activities used in the production of cakes. She has provided estimates of the annual activities along with the actual usage of activities for the jobs completed during the busiest quarter of the year presented here. Activities, drivers, annual estimated activity, and estimated annual overhead cost Download the Excel template and data file and complete the questions below. Creations is a wholesaler that bakes and decorates special occasion multi-tiered cakes, the majority of which are wedding cakes. The supervisor, Clara Cook, is questioning if using direct labor cost provides an accurate allocation base for overhead assigned to each cake. Creations uses job costing for each job which usually consists of six to nine cakes. Cakes produced for each job are delivered to local retail locations that have ordered the cakes for their respective customers. After meeting with the cost accountant, Clara identified seven activities used in the production of cakes. She has provided estimates of the annual activities along with the actual usage of activities for the jobs completed during the busiest quarter of the year presented here. Activities, drivers, annual estimated activity, and estimated annual overhead cost Activities, drivers, annual estimated activity, and estimated annual overhead cost \begin{tabular}{llllllllll} 439 & 31.21 & 0.95 & 2.66 & 11.75 & 17.34 & 0.58 & 2.09 & 7 \\ 440 & 29.47 & 0.98 & 2.67 & 12.08 & 19.19 & 0.64 & 2.02 & 6 \\ 441 & 29.51 & 1.01 & 2.75 & 13.46 & 17.62 & 0.56 & 2.11 & 4 \\ 442 & 29.86 & 0.95 & 2.66 & 14.63 & 17.35 & 0.57 & 2.44 & 5 \\ 443 & 31.39 & 0.98 & 2.68 & 14.68 & 19.70 & 0.58 & 2.03 & 4 \\ 444 & 27.98 & 1.01 & 2.79 & 11.10 & 17.77 & 0.61 & 2.06 & 6 \\ 445 & 28.00 & 1.02 & 2.78 & 12.33 & 18.98 & 0.57 & 2.08 & 5 \\ 446 & 27.83 & 0.99 & 2.66 & 14.36 & 18.68 & 0.58 & 2.41 & 4 \\ 447 & 31.87 & 1.02 & 2.68 & 11.99 & 18.43 & 0.61 & 2.48 & 6 \\ 448 & 29.75 & 0.96 & 2.79 & 11.07 & 18.13 & 0.59 & 2.49 & 6 \\ \hline 449 & 31.20 & 0.97 & 2.78 & 13.21 & 18.08 & 0.63 & 2.03 & 7 \\ 450 & 30.37 & 0.96 & 2.66 & 11.42 & 17.16 & 0.59 & 2.38 & 6 \\ \hline 451 & 28.43 & 0.95 & 2.67 & 12.64 & 19.03 & 0.57 & 2.17 & 6 \\ 452 & 29.69 & 0.98 & 2.75 & 13.97 & 17.33 & 0.58 & 2.26 & 5 \\ 453 & 29.76 & 0.95 & 2.66 & 14.60 & 18.71 & 0.64 & 2.17 & 4 \\ 454 & 28.67 & 0.98 & 2.68 & 13.89 & 19.53 & 0.56 & 2.35 & 6 \\ 455 & 28.54 & 1.01 & 2.79 & 11.48 & 17.86 & 0.57 & 2.31 & 4 \end{tabular} Question 1 of 1 11 45645745845946046146246346446546646746846929.4530.8529.3428.5129.1427.1631.5127.8027.4428.5329.8429.6331.5830.681.020.991.020.960.970.960.950.981.011.020.991.020.960.972.782.662.672.752.662.682.662.682.792.782.662.672.752.7612.1111.7013.7314.6313.9312.5811.5612.2413.5114.8714.8914.5414.4711.5020.0017.2119.0019.2619.1417.6719.8017.9717.8818.5017.1317.5717.5319.550.580.610.630.610.590.630.640.560.570.580.610.590.630.632.492.462.092.332.372.082.062.072.332.462.292.072.042.3954455654447576 here are four parts to this problem. Use Excel to perform the following. etermine the average daily usage of each activity. (Round answers to 2 decimal ploces, e.s. 15.25.) Attempts: 0 of 2 used
