Question

In: Accounting

Warm Hands, a small company based in Prince Edward Island, manufactures and sells two types of...

Warm Hands, a small company based in Prince Edward Island, manufactures and sells two types of lightweight gloves for runners—Warm and Cozy. Current revenue, cost, and unit sales data for the two products appear below:

Warm Cozy
  Selling price per pair $ 6.00 $ 9.00
  Variable expenses per pair $ 1.50 $ 4.50
  Number of pairs sold monthly 3,000 units 1,000 units

Fixed expenses are $2,880 per month.

Required:

1. Assuming the sales mix above, do the following:

a. Prepare a contribution format income statement showing both dollars and percentage columns for each product and for the company as a whole. (Round percentage answers to 2 decimal places.)

b. Compute the break-even point in dollars for the company as a whole and the margin of safety in both dollars and percentage of sales. (Do not round your intermediate calculations. Round percentage answer to 2 decimal places.)

c. Compute the break-even point in units for the company as a whole and the margin of safety in both units (pairs of gloves) and percentage of sales. (Round percentage answer to 2 decimal places.)

d. Compute how many pairs of gloves must be sold overall if the company wants to make an after-tax target profit of $6,300 and the tax rate is 30%. Assume that the sales mix remains the same as shown above.

2. The company has developed another type of gloves that provide better protection in extreme cold, Toasty, which the company plans to sell for $17.00 per pair. At this price, the company expects to sell 1,000 pairs per month of the product. The variable expense would be $13.60 per pair. The company’s fixed expenses would not change.

a. Prepare another contribution format income statement, including sales of Toasty (sales of the other two products would not change). (Round percentage answers to 2 decimal places.)

b. Compute the company’s new break-even point in dollars for the company as a whole and the new margin of safety in both dollars and percentage of sales. (Round your break-even sales to the nearest whole dollar amount and percentage answer to 2 decimal places.)

Solutions

Expert Solution

Contribution format Income Statement
Warm Cozy Total
Amount % Amount % Amount %
Sales 18000 100.00% 9000 100.00% 27000 100%
Less:Variable Expenses 4500 25.00% 4500 50.00% 9000 33.33%
Contribution Margin 13500 75.00% 4500 50.00% 18000 66.67%
Less:Fixed Expenses 2880
Net Operating Income 15120
Break even point in dollar sales = Fixed costs/Contribution margin ratio

  

2880/66.67% =4320

Break even point in unit sales = Fixed costs/Weighted average contribution margin (Working note)

=2880/4.5 = 640

Margin of safety = Sales - Break even Sales [27000 - 4320] 22680
in % = Margin of Safety in Dollars/Sales (22680/27000) x 100 84.00%
d.Sales in Units = (Desired Income before tax + fixed costs)/Contribution Margin per unit
=(6300/0.7 + 2880)/6
1980
2.
Contribution format Income Statement
Warm Cozy Toasty Total
Amount % Amount % Amount % Amount
Sales 18000 100.00% 9000 100.00% 17000 100.00% 44000
Less:Variable Expenses 4500 25.00% 4500 50.00% 13600 80.00% 22600
Contribution Margin 13500 75.00% 4500 50.00% 3400 20.00% 21400
Less:Fixed Expenses 2880
Net Operating Income 18520

Break even point in dollar sales = fixed cost/contribution margin ratio

=2880/20 = 14400

14400

Margin of safety= sales - Break even Sales

=17000 - 14400

2600
in % 15.29%

Working note:

Warm Cozy Total
% %
Sales $6 100% $9 100%
Variable expenses $1.5 25% $4.5 50%
Contribution margin - A $4.5 75% $4.5 50%
Sales units 3000 1000
Selling price per units $6 $9
Total sales $18000 $9000 $27000
Sales mix - B 66.67% 33.33% 100%
Weighted average contribution - (A x B) $3 $1.5 $4.5

Please rate, thanks.


Related Solutions

Warm Hands, a small company based in Prince Edward Island, manufactures and sells two types of...
Warm Hands, a small company based in Prince Edward Island, manufactures and sells two types of lightweight gloves for runners—Warm and Cozy. Current revenue, cost, and unit sales data for the two products appear below: Warm Cozy   Selling price per pair $ 10.00 $ 15.00   Variable expenses per pair $ 2.50 $ 7.50   Number of pairs sold monthly 2,100 units 700 units Fixed expenses are $2,520 per month. Required: 1. Assuming the sales mix above, do the following: a. Prepare...
A company manufactures and sells two types of gloves – Warm and Cozy – for runners....
A company manufactures and sells two types of gloves – Warm and Cozy – for runners. Current financial data is provided below: WARM COZY Selling Price per pair $8.00 $12.00 VC per pair $2.00 $ 6.00 Number of pairs sold per month 600 200 Fixed costs = $2,250 per month a) Comparing the original information provided and your break-even calculation, what is the Margin of Safety in dollars between them? b) Comparing the original information provided and your break-even calculation,...
1. A company manufactures and sells two types of gloves – Warm and Cozy – for...
1. A company manufactures and sells two types of gloves – Warm and Cozy – for runners. Current financial data is provided below: WARM COZY Selling Price per pair $8.00 $12.00 VC per pair $2.00 $ 6.00 Number of pairs sold per month 600 200 Fixed costs = $2,250 per month a) Compute the break even in dollars for the company in Total?
The economy of a small island nation is based on two​ sectors, agriculture and tourism. Production...
The economy of a small island nation is based on two​ sectors, agriculture and tourism. Production of a​ dollar's worth of agriculture requires an input of $0.25 from agriculture and $0.41 from tourism. Production of a​ dollar's worth of tourism requires an input of $0.50 from agriculture and $0.31 from tourism. Find the output from each sector that is needed to satisfy a final demand of $25 million for agriculture and $63 million for tourism. The output from the agriculture...
(Solve via Excel) The economy of a small island nation is based on two​ sectors, agriculture...
(Solve via Excel) The economy of a small island nation is based on two​ sectors, agriculture and tourism. Production of a​ dollar's worth of agriculture requires an input of $ 0.35 from agriculture and $0.40 from tourism. Production of a​ dollar's worth of tourism requires an input of $0.43 from agriculture and $0.12 from tourism. Find the output from each sector that is needed to satisfy a final demand of $42 million for agriculture and $47 million for tourism. -...
Jones Company produces and sells cookies. The company manufactures two different types of cookies; Chocolate Chip...
Jones Company produces and sells cookies. The company manufactures two different types of cookies; Chocolate Chip and Double Chocolate. The company produced 10,000 Chocolate Chip and 12,000 Double Chocolate cookies for the period. The following information is available for their company for this same period based on this level of production: Volume of Activity Activity Allocation Base Overhead Costs Chocolate Chip Double Chocolate Machine setup Number of setup $275,000 500 500 Production Machine hours $1,250,000 28,500 21,500 Assembly Direct labor...
A & B manufactures and sells two types of products to a number of customers. The...
A & B manufactures and sells two types of products to a number of customers. The resources are as follows: Material Type Product X Product Y Available Material P 8 10 31,250 Material Q 10 5 20,000 Direct Labour 4 5 17,500 Maximum sales(demand) for X is 1000 units and Y 3000 units.Contribution margin X $96 and Y $110 Formulate a linear programme Solve in excel Write a brief report to explain the analysis
Consider an island served by a single ferry company. There are two types of people who...
Consider an island served by a single ferry company. There are two types of people who visit the island, day-trippers who come in the morning to enjoy the island’s beaches on a Saturday or Sunday (or sometimes on a weekday) and permanent summer residents who work in the city during the week but come to the island on Friday night to spend the weekend and then leave on Monday to return to work. The ferry has the following rate schedule:...
Go Camera manufactures and sells two types of cameras for cars and drones. These two models...
Go Camera manufactures and sells two types of cameras for cars and drones. These two models are manufactured in separate facilities and each facility is treated as profit center. Go Camera serves as a supplier to car manufacturers as well as drone manufacturers. The following table provides cost and price information for each model: Car Camera Drone Camera Selling Price $70 $100 Variable Cost $30 $35 Fixed Cost $300,000 $ 600,000 Go Camera has a marketing department with cost $400,000...
manufactures and sells two products: Product T8 and Product P4. The company has an activity-based costing...
manufactures and sells two products: Product T8 and Product P4. The company has an activity-based costing system with the following activity cost pools, activity measures, and expected activity: Estimated Expected Activity Activity Cost Pools Activity Measures Overhead Cost Product T8 Product P4 Total Labor-related DLHs $ 130,200 11,000 5,500 16,500 Production orders orders 61,400 1,200 500 1,700 Order size MHs 960,340 3,100 3,500 6,600 $ 1,151,940 The total overhead applied to Product P4 under activity-based costing is closest to: (Round...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT