Collins Enterprises Has Four Divisions,commercial,retail,research,and Consumer,that Share the Common Costs

Essay

Collins Enterprises has four divisions,commercial,retail,research,and consumer,that share the common costs of the company's computer server network.The annual common costs are $2,400,000.You have been provided with the following information for the upcoming year: $\begin{array}{|l|r|r|}\hline &\text { Connections } & \text { Time on } \\&&\text { Network (hous) }\\\text { Commercial } & 60,000 & 120,000 \\\hline \text { Retail } & 80,000 & 150,000 \\\hline \text { Research } & 40,000 & 100,000 \\\hline \text { Consumer } & 100,000 & 330,000\\\hline \end{array}$
Required (use three decimal places in your calculations):
a.What is the allocation rate for the upcoming year assuming Collins uses the single-rate method and allocates common costs based on the number of connections? Calculate the allocated amount for each division.b.What is the allocation rate for the upcoming year assuming Collins uses the single-rate method and allocates common costs based on the time on network? Calculate the allocated amount for each division.c.The cost accountant determined $1,700,000 of the server network's costs were fixed and should be allocated based on the number of connections.The remaining costs should be allocated based on the time on the network.What is the total server network costs allocated to each division?