1.
Calculate the sales mix of portable grills, stationary grills and smokers.
1.
Answer to Problem 45E
The sales mix of portable grills, stationary grills and smokers is 4:10:1.
Explanation of Solution
Sales Mix:
Sales mix refers to the proportion of different products that is sold. It is expressed in the ratio of sales of the products. The ratio of sales mix is reduced to the lowest whole units.
Use the following formula to calculate sales mix for portable grills:
Substitute 20,000 for number of portable grills and 75,0001 for total number of items in the above formula.
Therefore, sales mix for Portable grills is
Use the following formula to calculate sales mix for stationary grills:
Substitute 50,000 for number of Portable grills and 75,0001 for total number of items in the above formula.
Therefore, sales mix for stationary grills is
Use the following formula to calculate sales mix for smokers:
Substitute 5,000 for number of smokers and 75,0001 for total number of items in the above formula.
Therefore, sales mix for smokers is
The portable grills and stationary grills sold were four times and ten times respectively of the number of smokers sold. Therefore, the sales mix is 4:10:1.
Working Note:
1. Calculation of total number of items:
2.
Calculate the break-even quantity of each product.
2.
Answer to Problem 45E
Break-even quantity for Portable grills, stationary grills and smokers are 8,600 units and 21,500 and 2,150 units units respectively.
Explanation of Solution
Break-Even Point:
The point or situation where the amount of total cost is equivalent to total revenue is known as the break-even point. It is the point where there is no loss or no profit.
The package of portable grills, stationary grills and smokers is given below:
Product |
Price ($) A |
Unit Variable Cost ($) B |
Unit Contribution Margin ($) C |
Sales Mix D |
Package Unit Contribution Margin ($) |
Portable grills | 90 | 45 | 45 | 4 | 180 |
Stationary grills | 200 | 130 | 70 | 10 | 700 |
Smokers | 250 | 140 | 110 | 1 | 110 |
Total | 990 |
Table (1)
Use the following formula to calculate break-even quantity:
Substitute $2,128,500 for total fixed cost and $990 for contribution margin in the above formula.
Therefore, break-even quantity is 2,150 units.
Use the following formula to calculate break-even quantity for Portable grills:
Substitute 2,150 for number of units and 4 for sales mix in the above formula.
Therefore, the break-even quantity for Portable grills is 8,600 units.
Use the following formula to compute break-even point for stationary grills:
Substitute 2,150 for number of units and 10 for sales mix in the above formula.
Therefore, the break-even quantity of stationary grills is 21,500 units.
Use the following formula to compute break-even point for smokers:
Substitute 2,150 for number of units and 1 for sales mix in the above formula.
Therefore, the break-even quantity of smokers is 2,150 units.
3.
Construct an income statement for Company TQ. Also calculate overall contribution margin ratio and overall break-even sales revenue.
3.
Explanation of Solution
Income Statement:
The statement that shows revenue and expenses incurred over a period of time (usually one year) is called an income statement. It is used for external financial reporting as it helps the outsiders and investors in evaluating the firm’s financial health.
Contribution Margin Ratio:
The sales percentage remaining after covering the amount of total variable cost is known as the contribution margin ratio. It is the available sales dollar percentage which will be used to cover the total fixed cost.
Break-Even Sales Revenue:
Break-even sales revenue can be evaluated by dividing the total amount of fixed cost by the contribution margin ratio.
The following table represents the income statement of Company TQ:
Company TQ | |
Income Statement | |
Amount ($) | |
Sales revenue | 13,050,0002 |
Less: Variable cost | 8,100,0003 |
Contribution margin | 4,950,000 |
Less: Fixed cost | 2,128,500 |
Operating income | 2,821,500 |
Table (1)
Therefore, the operating income of Company CRP will be $2,821,500.
Use the following formula to calculate overall contribution margin ratio:
Substitute $4,950,000 for contribution margin and $13,505,000 for sales in the above formula.
Therefore, the contribution margin ratio is 0.3793.
Use the following formula to calculate break-even sales revenue:
Substitute $2,128,500 for the total fixed cost and 0.3793 for contribution margin ratio in the following formula.
Therefore, the break-even sales revenue is $5,611,653.
Working Note:
2. Calculation of sales:
3. Calculation of variable cost:
4.
Calculate margin of safety.
4.
Answer to Problem 45E
The margin of safety is $7,438,347.
Explanation of Solution
Margin of Safety:
The number of units sold or the income earned in excess of the break-even sales is known as margin of safety. It is calculated by deducting the break-even sales from the sales revenue.
Use the following formula to calculate the margin of safety:
Substitute $13,505,000 for sales and $5,611,653 for break-even sales revenue in the above formula.
Therefore, the margin of safety in sales dollars is $7,438,347.
Want to see more full solutions like this?
Chapter 7 Solutions
Managerial Accounting: The Cornerstone of Business Decision-Making
- Vista Company manufactures electronic equipment. It currently purchases the special switches used in each of its products from an outside supplier. The supplier charges Vista $1.80 per switch. Vista’s CEO is considering purchasing either machine A or machine B so the company can manufacture its own switches. The projected data are as follows: Machine A Machine B Annual fixed costs $ 141,450 $ 188,325 Variable cost per switch 0.57 0.25 Required: For each machine, what is the minimum number of switches that Vista must make annually for total costs to equal outside purchase cost? What volume level would produce the same total costs regardless of the machine purchased? What is the most profitable alternative for producing 155,000 switches per year and what is the total cost of that alternativearrow_forwardVista Company manufactures electronic equipment. It currently purchases the special switches used in each of its products from an outside supplier. The supplier charges Vista $5.50 per switch. Vista's CEO is considering purchasing either machine A or machine B so the company can manufacture its own switches. The projected data are as follows: Annual fixed costs Variable cost per switch Machine A $632,400 1.78 Required: 1. For each machine, what is the minimum number of switches that Vista must make annually for total costs to equal outside purchase cost? 2. What volume level would produce the same total costs regardless of the machine purchased? 3. What is the most profitable alternative for producing 235,000 switches per year and what is the total cost of that alternative? Required 1 Required 2 Required 3 Complete this question by entering your answers in the tabs below. Machine B $ 860,100 0.80 Minimum number of switches For each machine, what is the minimum number of switches that…arrow_forwardSunland, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $25 and are sold for $35. Glass pitchers cost $24 and are sold for $45. All other costs are fixed at $572,000 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year.arrow_forward
- Crane, Inc., sells two types of water pitchers, plastic and glass. Plastic pitchers cost the company $30 and are sold for $40. Glass pitchers cost $26 and are sold for $47. All other costs are fixed at $280,800 per year. Current sales plans call for 14,000 plastic pitchers and 28,000 glass pitchers to be sold in the coming year. How many pitchers of each type must be sold to break even in the coming year? (Use contribution margin per unit to calculate breakeven units.)arrow_forwardHitter Corporation produces baseball bats for kids that it sells for $36 each. At capacity, the company can produce 56,000 bats a year. The costs of producing and selling 56,000 bats are as follows: E (Click to view the costs.) Read the requirements Requirement 1. Suppose Hitter is currently producing and selling 42,000 bats. At this level of production and sales, its fixed costs are the same as given in the preceding table. Mantle Corporation wants to place a one-time special order for 14,000 bats at $21 each. Hitter will incur no variable selling costs for this special order. Should Hitter accept this one-time special order? Show your calculations. Determine the effect on operating income if the order is accepted. (Enter decreases in operating income with parentheses or a minus sign.) Increase (decrease) in operating income if order is accepted Hitter should Mantle's special order because it operating income by Sarrow_forwardHomerun Corporation produces baseball bats for kids that it sells for $36 each. At capacity, the company can produce 50,000 bats a year. The costs of producing and selling 50,000 bats are as follows: (Click to view the costs.) Read the requirements. Requirement 1. Suppose Homerun is currently producing and selling 38,000 bats. At this level of production and sales, its fixed costs are the same as given in the preceding table. Cobb Corporation wants to place a one-time special order for 12,000 bats at $20 each. Homerun will incur no variable selling costs for this special order. Should Homerun accept this one-time special order? Show your calculations. Determine the effect on operating income if the order is accepted. (Enter decreases in operating income with parentheses or a minus sign.) Data Table Increase (decrease) in operating income if order is accepted Cost per Bat Total Costs Homerun should Cobb's special order because it operating income by $ Direct materials 11 $ 550,000…arrow_forward
- Vandenberg, Inc., produces and sells two products: a ceiling fan and a table fan. Vandenberg plans to sell 40,000 ceiling fans and 50,000 table fans in the coming year. Product price and cost information includes: Ceiling Fan Table Fan Price $52 $15 Unit variable cost $12 $9 Direct fixed cost $25,200 $48,000 Common fixed selling and administrative expenses total $78,000.See screenshotsarrow_forwardThe Cool Can Company manufactures drink koozies and has been approached by a new customer with an offer to purchase 15,000 units at a per-unit price of $7.00. The new customer is geographically separated from Cool Can's other customers, and existing sales will not be affected. Cool Can normally produces 95,000 units but plans to produce and sell only 65,000 in the coming year. The normal sale price is $16 per unit. Unit cost information is as follows: Direct materials Direct labor Variable overhead Fixed overhead. Total In addition, assume that the new customer also wants to have its company logo affixed to each koozie using a label. Cool Can would have to purchase a special logo labeling machine that will cost $12,000 The machine will be able to label the 15,000 units and then it will be scrapped (with no further value). No other fixed overhead activities will be incurred. In addition, each special logo requires additional direct materials of $0.20 $3.10 2.50 1.15 1.00 $8.55…arrow_forwardSuko Na Ba Co. produces cellular phone cases. Each case requires a keypad which it also manufactures at a cost of P20 per unit, inclusive of fixed overhead cost of P5. Suko Na Ba Co. needs 50,000 units of this keypad annually. A supplier, Hindi Pa Co. has offered to sell to Suko Na Ba Corporation its keypad requirements at P24 per unit. If Suko Na Ba decides to buy the keypads, P2 per unit of the fixed overhead based on the annual estimate could be eliminated, and the facility previously used to produce the key pad could be rented to another company.If Suko Na Ba Co. outsource the keypads but does not rent the unused facility, it would __?arrow_forward
- Stevie's Scooters plans to sell a standard scooter for $850 and a chrome scooter for $1350. Stevie's purchases the standard scooter for $450 and the chrome scooter for $600. Stevie's expects to sell one standard scooter for every three chrome scooters. Stevie's monthly fixed costs are $715,500. Requirement 1. How many of each type of scooter must Stevie's Scooters sell each month to break even? Start by selecting the formula and entering the amounts to compute the breakeven point in units for the "package" of products—total scooters to be sold. (Enter a "0" for any zero balances. Enter currency amounts to the nearest cent. Abbreviation used: Weighted-avg. CM = weighted-average contribution margin.) ? ? ? ? ( Fixed costs + Target profit ) ÷ Weighted-avg. CM per unit = Required sales in units ( + ) ÷ = Requirements Dialog…arrow_forward1. Micro Enterprises has the capacity to produce 10,000 widgets a month, and currentiy makes and sells 9,000 widgets a month. Widgets normally sell for $6 each, and cost an average of $5 to make, including fixed costs. The monthly fixed costs are $18,000. Coyote Corp. has offered to buy 1,000 widgets at $4 each. What is the "cost" per unit in the context of evaluating the offer from Coyote Corp.? $2 $3 $4 $5 $6arrow_forwardThe Cool Can Company manufactures drink koozies and has been approached by a new customer with an offer to purchase 15,000 units at a per-unit price of $7.00. The new customer is geographically separated from Cool Can's other customers, and existing sales will not be affected. Cool Can normally produces 82,000 units but plans to produce and sell only 65,000 in the coming year. The normal sales price is $12 per unit. Unit cost information is as follows: Direct materials $3.10 Direct labor Variable overhead Fixed overhead Total 1.50 1.00 1.80 $7.40 However, assume that Cool Can plans to produce and sell 70,000 units in the coming year (rather than the originally anticipated 65,000 units). Required: 1. Using Excel (or some other spreadsheet software tool), calculate the amount by which total operating income increases or decreases if the order is accepted. Decrease -84,000 X 2. Conceptual Connection: Should Cool Can accept the special order when sales at the regular price are expected to…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education