Question

In: Accounting

Bartolo Delivery has two divisions, air express and ground service, that share the common costs of...

Bartolo Delivery has two divisions, air express and ground service, that share the common costs of the company’s communications network, which are $8,900,000 a year. You have the following information about the two divisions and the common communications network:

Air Express: 623,000 (Calls, thousands), 355,000 (time on network, hours)

Ground Service: 267,000 (Calls, thousands), 1,065,000 (time on network, hours

------(testing if copy paste worked completely)-------------------

Bartolo Delivery has two divisions, air express and ground service, that share the common costs of the company’s communications network, which are $8,900,000 a year. You have the following information about the two divisions and the common communications network:

Calls (thousands) Time on Network (hours)
Air express 623,000 355,000
Ground service 267,000 1,065,000

Required:

a. What is the communications network cost that is charged to each division if the number of calls is used as the allocation basis? (Do not round intermediate calculations.)

b. What is the communications network cost to each division using time on network as the allocation basis?(Do not round intermediate calculations.)

Solutions

Expert Solution

a. What is the communications network cost that is charged to each division if the number of calls is used as the allocation basis?

Allocation rate = Total commumication network cost/Total number of calls

                     = 8900000/(623000000+267000000)

Allocation rate = 0.01 per number of calls

Allocated cost
Air express (623000000*.010) 6230000
Ground service (267000000*.010) 2670000
Total communication network cost 8900000

b. What is the communications network cost to each division using time on network as the allocation basis?

Allocation rate = Total commumication network cost/Total Times of network (hours)

                     = 8900000/(355000+1065000)

Allocation rate = 6.26761 per hour

Allocated cost
Air express (355000*6.26761) 2225000
Ground service (1065000*6.26761) 6675000
Total communication network cost 8900000

Related Solutions

Bartolo Delivery has two divisions, air express and ground service, that share the common costs of...
Bartolo Delivery has two divisions, air express and ground service, that share the common costs of the company’s communications network, which are $9,000,000 a year. You have the following information about the two divisions and the common communications network: Calls (thousands) Time on Network (hours) Air express 504,000 350,000 Ground service 216,000 1,050,000 Required: Determine the cost allocation if $6.30 million of the communications network costs are fixed and allocated on the basis of time on network, and the remaining...
Bartolo Delivery has two divisions, air express and ground service, that share the common costs of...
Bartolo Delivery has two divisions, air express and ground service, that share the common costs of the company’s communications network, which are $8,100,000 a year. You have the following information about the two divisions and the common communications network: Calls (thousands) Time on Network (hours) Air express 525,000 362,500 Ground service 225,000 1,087,500 Required: Determine the cost allocation if $4.86 million of the communications network costs are fixed and allocated on the basis of time on network, and the remaining...
Bartolo Delivery has two divisions, air express and ground service, that share the common costs of...
Bartolo Delivery has two divisions, air express and ground service, that share the common costs of the company’s communications network, which are $8,900,000 a year. You have the following information about the two divisions and the common communications network: Calls (thousands) Time on Network (hours) Air express 588,000 340,000 Ground service 252,000 1,020,000 Required: a. What is the communications network cost that is charged to each division if the number of calls is used as the allocation basis? (Do not...
Bartolo Delivery has two divisions, air express and ground service, that share the common costs of...
Bartolo Delivery has two divisions, air express and ground service, that share the common costs of the company’s communications network, which are $8,000,000 a year. You have the following information about the two divisions and the common communications network: Calls (thousands) Time on Network (hours) Air express 490,000 350,000 Ground service 210,000 1,050,000 Required: a. What is the communications network cost that is charged to each division if the number of calls is used as the allocation basis? b. What...
In the early 2000’s, DHL expanded its worldwide air express package delivery service to the US...
In the early 2000’s, DHL expanded its worldwide air express package delivery service to the US market in direct competition with UPS and FedEx. After several years and more than one billion dollars in losses, DHL admitted defeat in 2008 withdrawing from most US markets while shedding some 15,000 US jobs. Think back to DHL announcement of its intention to enter the US market. Various stakeholders would greet the prospect of increased competition differently. In this discussion forum, address the...
National Express reports the following costs and expenses in June 2020 for its delivery service. Indirect...
National Express reports the following costs and expenses in June 2020 for its delivery service. Indirect materials $7,400 Drivers’ salaries $16,200 Depreciation on delivery equipment 11,400 Advertising 5,400 Dispatcher’s salary 5,710 Delivery equipment repairs 400 Property taxes on office building 910 Office supplies 760 CEO’s salary 12,900 Office utilities 1,030 Gas and oil for delivery trucks 3,200 Repairs on office equipment 210 Determine the total amount of (a) delivery service (product) costs and (b) period costs. Delivery service (product) costs...
Express Delivery is a rapidly growing delivery service. Last year, 80% of its revenue came from...
Express Delivery is a rapidly growing delivery service. Last year, 80% of its revenue came from the delivery of mailing “pouches” and small, standardized delivery boxes (which provides a 20% contribution margin). The other 20% of its revenue came from delivering non-standardized boxes (which provides a 70% contribution margin). With the rapid growth of Internet retail sales, Express believes that there are great opportunities for growth in the delivery of non-standardized boxes. The company has fixed costs of $12,100,000. (a)...
Exercise 19-08 Express Delivery is a rapidly growing delivery service. Last year, 80% of its revenue...
Exercise 19-08 Express Delivery is a rapidly growing delivery service. Last year, 80% of its revenue came from the delivery of mailing “pouches” and small, standardized delivery boxes (which provides a 20% contribution margin). The other 20% of its revenue came from delivering non-standardized boxes (which provides a 70% contribution margin). With the rapid growth of Internet retail sales, Express believes that there are great opportunities for growth in the delivery of non-standardized boxes. The company has fixed costs of...
A regional express delivery service company recently conducted a study to investigate the relationship between the...
A regional express delivery service company recently conducted a study to investigate the relationship between the cost of shipping a package ($), the package weight (in pound) and the distance shipped (in miles). Twenty packages were randomly selected from among the large number received for shipment, and a detailed analysis of the shipping cost was conducted for each package. The data for this sample observations are given in the file Assignment 4 S1 2020.XLS. a. Estimate a simple linear regression...
A regional express delivery service company recently conducted a study to investigate the relationship between the...
A regional express delivery service company recently conducted a study to investigate the relationship between the cost of shipping a package ($), the package weight (in pound) and the distance shipped (in miles). Twenty packages were randomly selected from among the large number received for shipment, and a detailed analysis of the shipping cost was conducted for each package. Cost_of_Shipment Package_Weight Distance_Shipped $3.30 4.10 95 $2.00 0.30 160 $11.00 5.10 240 $2.60 5.90 47 $1.90 4.50 53 $8.00 3.50 250...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT