3) Collins Enterprises has four divisions, commercial, retail, research, and consumer, that share the common costs...

Transcribed Image Text:

3) 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: Connections Commercial Retail Research Consumer Required: 60,000 80,000 40,000 120,000 Time on Network (hours) 120,000 150,000 100,000 330,000 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. Note: Do not round rate - carry out six decimal places. 5 points 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. Note: Do not round rate - carry out six decimal places. 5 points 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? Note: Round immediate calculations to three decimal places. 3) 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: Connections Commercial Retail Research Consumer Required: 60,000 80,000 40,000 120,000 Time on Network (hours) 120,000 150,000 100,000 330,000 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. Note: Do not round rate - carry out six decimal places. 5 points 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. Note: Do not round rate - carry out six decimal places. 5 points 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? Note: Round immediate calculations to three decimal places.