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,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 is the communications network cost to each division using time on network as the allocation basis?

Solutions

Expert Solution

  • Working

Calls (thousands)

Time on Network (hours)

Air express

              490,000

             350,000

Ground service

              210,000

          1,050,000

Total

              700,000

          1,400,000

  • Requirement ‘a’

Divisions:

Communication network cost allocated

Working

Air express

$5,600,000

[$ 8,000,000 x 490000 calls/700000 calls]

Ground service

$2,400,000

[$ 8,000,000 x 210000 calls/700000 calls]

TOTAL

$8,000,000

  • Requirement ‘b’

Divisions:

Communication network cost allocated

Working

Air express

$2,000,000

[$ 8,000,000 x 350000 hours/1400000hours]

Ground service

$6,000,000

[$ 8,000,000 x 1050000 hours/1400000hours]

TOTAL

$8,000,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,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...
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