Question

In: Accounting

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) What is the company’s break-even point in total sales dollars? At the break-even point, how much of the company’s sales are provided by each type of service? (Use Weighted-Average Contribution Margin Ratio rounded to 4 decimal places e.g. 0.2552 and round final answers to 0 decimal places, e.g. 2,510.)

Total break-even sales

$enter a dollar amount rounded to 0 decimal places

Sale of mail pouches and small boxes

$enter a dollar amount rounded to 0 decimal places

Sale of non-standard boxes

$enter a dollar amount rounded to 0 decimal places


(b) The company’s management would like to hold its fixed costs constant but shift its sales mix so that 60% of its revenue comes from the delivery of non-standardized boxes and the remainder from pouches and small boxes. If this were to occur, what would be the company’s break-even sales, and what amount of sales would be provided by each service type? (Use Weighted-Average Contribution Margin Ratio rounded to 4 decimal places e.g. 0.2552 and round final answers to 0 decimal places, e.g. 2,510.)

Total break-even sales

$enter a dollar amount rounded to 0 decimal places

Sale of mail pouches and small boxes

$enter a dollar amount rounded to 0 decimal places

Sale of non-standardized boxes

$enter a dollar amount rounded to 0 decimal places

Solutions

Expert Solution

(A)
Total Break even sales $ 40333333
Sale of mail pouches and small boxes $ 32266666
Sale of non-standard boxes $ 8066667
Working:
Particular mail pouches non- standard
& small boxes boxes
Contribution margin ratio 20% 70%
Percentage 80% 20%
Weighted average contribution margin ratio 20*80% =16 70*20% =14 30%
Fixed cost 12100000
Break even point (total) seats 40333333 (12100000/30%)
Break even point (individually) 32266666 8066666.6
(40333333*80%) (40333333*20%)
(B) Total Break even sales $ 24200000
Sale of mail pouches and small boxes $ 9680000
Sale of non-standard boxes $ 14520000
Working:
Particular mail pouches non- standard
& small boxes boxes
Contribution margin ratio 20% 70%
Percentage 40% 60%
Weighted average contribution margin ratio 20*40% =8 70*60% = 42 50%
Fixed cost 12100000
Break even point (total) seats 24200000 (12100000/50%)
Break even point (individually) 9680000 14520000
(2420000*40%) (2420000*60%)

Related Solutions

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...
an express dog food delivery service based in Frankfurt is considering changing its capital structure. its...
an express dog food delivery service based in Frankfurt is considering changing its capital structure. its capital structure is as follows: it has 2000 5% annual coupon 10 year bonds outstanding which currently trade at 85. the book value for these bonds is 2.0 million. its common stock sells at $20 per share with 200,000 shares issued and outstanding . its par value is 5.00 per share and 400,000 shares are authorized. its common stock has a book value o...
an express dog food delivery service based in Frankfurt is considering changing its capital structure. its...
an express dog food delivery service based in Frankfurt is considering changing its capital structure. its current capital structure is as follows: it has 2,000 5% annual coupon 10 year bonds outstanding which currently trade at 85. The book value for these bonds is $ 2.0 million. its common stock sells at $20 per share with 200,000 shares issued and outstanding. Its par value is $ 5 per share and 400,000 shares are armortized. its common stock has a book...
an express dog food delivery service based in Frankfurt is considering changing its capital structure. its...
an express dog food delivery service based in Frankfurt is considering changing its capital structure. its current capital structure is as follows: it has 2,000 5% annual coupon 10 year bonds outstanding which currently trade at 85. The book value for these bonds is $ 2.0 million. its common stock sells at $20 per share with 200,000 shares issued and outstanding. Its par value is $ 5 per share and 400,000 shares are armortized. its common stock has a book...
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....
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...
The Bicol Express food company needs to raise money to finance sales which are growing rapidly....
The Bicol Express food company needs to raise money to finance sales which are growing rapidly. The company is deciding whether to issue corporate bonds, common stocks, or preferred stocks to accomplish this purpose. Answer the following questions; What should the company consider before making this choice? What are the advantages and disadvantages of each of the three options?
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