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:

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 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. network cost that is charged to each division if the number of calls is used as the allocation basis.

common costs of the company’s communications network = $8,900,000

Total Number Of Calls = Air Express + Ground Service

= 588,000 + 252,000

= 840,000

Cost of Communication Network Per Calls = common costs of the company’s communications network / Total Number Of Calls

= $ 8,900,000 / 840,000

= $ 10.5952 Per Calls

Cost Allocation to Air Express= Air Express Calls * Cost of Communication Network Per Calls

= 588,000 * $ 10.5952

= $ 6,230,000

Cost Allocation of Ground Service = Ground Service Calls * Cost of Communication Network Per Calls

= 252000 * $ 10.60

= $ 2,670,000

B. communications network cost to each division using time on network as the allocation basis.

common costs of the company’s communications network = $8,900,000

Total Number Of time in Network (Hours) = Air Express + Ground Service

= 340,000 + 1,020,000

= 1,360,000

Cost of Communication Network Per time in Network (Hours) = common costs of the company’s communications network / Total Number Of time in Network (Hours)

= $ 8,900,000 / 1,360,000

= $ 6.6441 Per Calls

Cost Allocation to Air Express= Air Express time in Network (Hours) * Cost of Communication Network Per time in Network (Hours)

= 340,000 * $ 6.6441

= $ 2,225,000

Cost Allocation of Ground Service = Ground Service time in Network (Hours) * Cost of Communication Network Per time in Network (Hours)

= 1,020,000 * $ 10.60

= $ 6,675,000


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 $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...
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,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...
10. The cost of sending a package by an express delivery service is $16.00 for the...
10. The cost of sending a package by an express delivery service is $16.00 for the first two pounds, and $6.00 for each extra pound or a fraction of a pound. If the package weighs more than 80 pounds, a $25.00 excess weight surcharge is added to the cost. No package over 180 pounds will be accepted. Write a program that accepts the weight of a package in pounds and computes the cost of mailing the package with proper messaging....
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT