Question

In: Accounting

1. Glacial Springs produces and sells water filtration systems for homeowners. Information regarding its three models...

1. Glacial Springs produces and sells water filtration systems for homeowners. Information regarding its three models is shown below.

Basic Basic Plus Premium Total
Units sold 540 300 360 1,200
Selling price $240 $435 $755
Variable cost $185 $270 $430

3. The Richibouctou Inn is trying to determine its break-even point. The inn has 71 rooms available that are rented at $60 a night. Operating costs are as follows:

Salaries $9,240 per month Maintenance $480 per month
Utilities $1,930 per month Housekeeping service $6 per room
Depreciation $1,310 per month Other costs $24 per room

Determine the inn’s break-even point in the number of rented rooms per month and dollars.

If the inn plans on renting 32 rooms per day (assuming a 30-day month), what is the monthly margin of safety in dollars and the margin of safety ratio?


The company’s total fixed costs to produce the filtration systems are $199,470.

Determine the sales mix as a function of units sold for the three products.

Sales mix
Basic %
Basic Plus %
Premium

Determine the weighted-average unit contribution margin. (Round answer to 2 decimal places, e.g. 15.25.

Determine the total number of units that the company must sell to break even.

Determine the number of units of each model that the company must sell to break even.

2. Determine the missing amounts:

Unit Selling Price Unit Variable Costs Contribution
Margin per Unit
Contribution
Margin Ratio
1. $850 $595 $ %
2. $450 $ $225 %
3. $ $ $430 25%

3.

Solutions

Expert Solution

1. Sales Mix

Total Units Sold = 1,200

Sales Mix for Basic = 540/1,200

=45%

Sales Mix for Basic plus = 300/1,200

=25%

Sales Mix for Premium = 360/1,200

=30%

2.

Basic Basic Plus Premium Total
Sales      240.00      435.00      755.00    1,430.00
Variable Cost      185.00      270.00      430.00       885.00
Contribution         55.00      165.00      325.00       545.00
Sales Mix 45% 25% 30%
Weighted Average Contribution Margin         24.75         41.25         97.50       163.50

3.

Fixed Cost =  199,470

Break-even point in units = 199,470/163.50

=1,220 Units

4. Basic = 1,220 x 45% = 549 Units

Basic Plus = 1,220 x 25% = 305 Units

Premium = 1,220 x 30% = 366 Units

Unit Selling Price Variable cost Contribution Margin Contribution Margin ratio
1                       850.00              595.00                              255.00 30%
2                       450.00              225.00                              225.00 50%
3                   1,720.00          1,290.00                              430.00 25%

Related Solutions

Snow Cap Springs produces and sells water filtration systems for homeowners. Information regarding its three models...
Snow Cap Springs produces and sells water filtration systems for homeowners. Information regarding its three models is shown below. Basic Basic Plus Premium Total Units sold 580 220 200 1,000 Selling price $251 $404 $800 Variable cost $200 $283 $417 The company’s total fixed costs to produce the filtration systems are $185,920. Determine the sales mix as a function of units sold for the three products. Basic Basic Plus Premium The sales mix as a function of units sold   %...
Snow Cap Springs produces and sells water filtration systems for homeowners. Information regarding its three models...
Snow Cap Springs produces and sells water filtration systems for homeowners. Information regarding its three models is shown below. Basic Basic Plus Premium Total Units sold 1,071 391 238 1,700 Selling price $252 $399 $804 Variable cost $194 $293 $416 The company’s total fixed costs to produce the filtration systems are $126,764. Determine the sales mix as a function of units sold for the three products Determine the weighted-average unit contribution margin Determine the total number of units that the...
Snow Cap Springs produces and sells water filtration systems for homeowners. Information regarding its three models...
Snow Cap Springs produces and sells water filtration systems for homeowners. Information regarding its three models is shown below. Basic Basic Plus Premium Total Units sold 912 368 320 1,600 Selling price $248 $404 $801 Variable cost $194 $287 $411 The company’s total fixed costs to produce the filtration systems are $203,535. Determine: The sales mix as a function of units sold for the three products (round answers to 0 decimal places) The weighted-average unit contribution margin (round answers to...
Please answer B Safe and Secure, Inc. produces three models of home security systems. Information on...
Please answer B Safe and Secure, Inc. produces three models of home security systems. Information on the three products is given below: Assurance Decoder Burglar Beware Sales $455,400 $759,000 $303,600 Variable expenses 227,700 303,600 212,520 Contribution margin 227,700 455,400 91,080 Fixed expenses 176,400 345,000 142,800 Net income $51,300 $110,400 $(51,720 ) Fixed expenses consist of $446,600 of common costs allocated to the three products based on relative sales, and additional fixed costs of $44,400 (Assurance), $121,400 (Decoder), and $51,800 (Burglar...
Way Cool produces two different models of air conditioners. The company produces mechanical systems in its...
Way Cool produces two different models of air conditioners. The company produces mechanical systems in its components department. The mechanical systems are combined with the housing assembly in its finishing department. The activities, costs, and drivers associated with these two manufacturing processes and production support processes follow. Process Activity Overhead Cost Driver Quantity Components Changeover $586,950 Number of batches 910 Machining $355,355 Machine hours 7,810 Setups $72,400 Number of setups 40 $1,014,705 Finishing Welding $296,550 Welding hours 4,500 Inspecting $289,000...
Agnew Manufacturing produces and sells three models of a single product, Standard, Superior, and DeLuxe, in...
Agnew Manufacturing produces and sells three models of a single product, Standard, Superior, and DeLuxe, in a local market and in a regional market. At the end of the first quarter of the current year, the following income statement (in thousands of dollars) has been prepared. Total Local Regional Sales revenue $ 15,300 $ 11,790 $ 3,510 Cost of goods sold 12,105 9,315 2,790 Gross margin $ 3,195 $ 2,475 $ 720 Marketing costs 1,230 705 525 Administrative costs 606...
Agnew Manufacturing produces and sells three models of a single product, Standard, Superior, and DeLuxe, in...
Agnew Manufacturing produces and sells three models of a single product, Standard, Superior, and DeLuxe, in a local market and in a regional market. At the end of the first quarter of the current year, the following income statement (in thousands of dollars) has been prepared: Total Local Regional Sales revenue $ 7,800 $ 6,000 $ 1,800 Cost of goods sold 6,060 4,650 1,410 Gross margin $ 1,740 $ 1,350 $ 390 Marketing costs 630 360 270 Administrative costs 312...
Khloe’s Boys produces and sells three models of action figures representing the athletes and celebrities Khloe...
Khloe’s Boys produces and sells three models of action figures representing the athletes and celebrities Khloe Kardashian has been involved with (let’s assume there are just three). In March 2018, Lamar Odom's sales were $100,000 and its variable expenses were $58,000. French Montana's sales were $150,000 and its variable expenses were $102,000. Tristan Thompson’s sales were $250,000 and its variable expenses were $130,000. The company's fixed expenses were $96,600 a. Determine the overall break-even point for the company in sales...
Question 1 Cedar Grove Industries produces and sells a cell phone-operated home security control. Information regarding...
Question 1 Cedar Grove Industries produces and sells a cell phone-operated home security control. Information regarding the costs and sales of security controls during May 2017 are provided below. Unit selling price of security control $45 Unit variable costs $27 Total monthly fixed costs $135,000 Units sold 8,500 Prepare a CVP income statement for Cedar Grove Industries for the month of May. Provide per unit values and total values. Cedar Grove Industries CVP Income Statement Total Per Unit $ $...
Way Cool two different models of air conditioners. The company produces mechanical systems in its components...
Way Cool two different models of air conditioners. The company produces mechanical systems in its components department. The mechanical systems are combined with the housing assembly in its finishing department. The activities, costs, and drivers associated with these two manufacturing processes and the production support process follow. Process Activity Overhead Cost Driver Quantity Components Changeover $470,000 Number of batches 750 Machining $309,000 Machine hours 8,220 Setups $226,000 Number of setups 140 $1,005,000 Finishing Welding $192,000 Welding hours 5,700 Inspecting $224,000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT