Question

In: Accounting

XYZ Inc. sell Product Y at P5 per unit. The variable costs ofmaking and selling...

XYZ Inc. sell Product Y at P5 per unit. The variable costs of making and selling each unit is P3 while the total fixed cost is P2,000. The company wants to earn a profit of P3,000. The company is subject to 40% tax rate.

  1. What is the break-even point in units and pesos?

  2. What should be the level of sales in units and pesos to earn the desired profit if it is before tax?

  3. What should be the level of sales in units and pesos to earn the desired profit if it is after tax?

  4. What is the Margin of Safety for the target sales computed in requirement 3 in units, pesos, and percentage?

Solutions

Expert Solution

Data
Selling price per unit $        5.00
Variable cost per unit $        3.00
Contribution Margin per unit $        2.00
Contribution Margin % 40% ($ 2 / $ 5)
Fixed cost $ 2,000.00
Break even point
In units = Fixed cost / Contribution Margin per unit
= $ 2000 / $ 2
= 1000 units
In pesos = Fixed cost / Contribution Margin %
= $ 2000 / 40%
= $ 5,000.00
Level of sales to earn $ 5000 profit before tax
In units = (Fixed Cost + Desired profit) / Cont. Margin p.u
= ($ 2000 + $ 5000) / $ 2
= 3500 units
In pesos = 3500 units x $ 5
= $ 17,500.00
Level of sales to earn $ 5000 profit after tax
Tax rate is 40%
Therefore, profit before tax shall be $ 8,333.33 ($ 5000 / 60%)
In units = (Fixed Cost + Desired profit) / Cont. Margin p.u
= ($ 2000 + $ 8333.33) / $ 2
= 5167 units
In pesos = 5167 units x $ 5
= $ 25,833.33
Margin of safety
In units = Actual sales - Break even sales
= 5167 units - 1000 units
= 4167 units 20833.33
In pesos = $ 25833.33 - $ 5000
= $ 20,833.33
In % = (Actual Sales - Break Even sales) / Actual sales
= ($ 25833.33 - $ 5000) / $ 25833.33
= 80.65%

Related Solutions

XYZ Inc. sell Product Y at P5 per unit. The variable costs of making and selling...
XYZ Inc. sell Product Y at P5 per unit. The variable costs of making and selling each unit is P3 while the total fixed cost is P2,000. The company wants to earn a profit of P3,000. The company is subject to 40% tax rate. What is the break-even point in units and pesos? What should be the level of sales in units and pesos to earn the desired profit if it is before tax? What should be the level of...
XYZ, Inc. produces a product that will sell this year for $200 per unit. Fixed costs...
XYZ, Inc. produces a product that will sell this year for $200 per unit. Fixed costs are expected to total $10,000 this year and remain constant for the following four years. Variable costs are expected to be $75 per unit this year and increase at a rate of 5% in each of the following four years. XYZ, Inc. expects to sell 2,000 units this year and in each of the following four years. To earn an equivalent uniform annual gross...
1.A company produces a single product. Variable production costs are $13.1 per unit and variable selling...
1.A company produces a single product. Variable production costs are $13.1 per unit and variable selling and administrative expenses are $4.1 per unit. Fixed manufacturing overhead totals $47,000 and fixed selling and administration expenses total $51,000. Assuming a beginning inventory of zero, production of 5,100 units and sales of 4,150 units, the dollar value of the ending inventory under variable costing would be: 1b. Farron Corporation, which has only one product, has provided the following data concerning its most recent...
ABC Inc. manufactures and sell product A. The sale price and costs on a per unit...
ABC Inc. manufactures and sell product A. The sale price and costs on a per unit basis, when 20,000 units per month are sold, are as follows:                         Manufacturing costs:                                                 Direct materials used $2.00                                                 Direct labour               $1.00                                                 MOH variable             $1.20                                                 MOH fixed                 $1.10                         Selling expenses                                                 Variable                      $4.00                                                 Fixed                           $1.10                         Sale price per unit                                                     $15          ABC Inc. received a special order from Africa Co., headquarter located in Zimbabwe, for...
Y enterprises sells is product at Rs. 20 per unit. Variable costs are Pa 15 per...
Y enterprises sells is product at Rs. 20 per unit. Variable costs are Pa 15 per st (2/3 manufacturing and 1/3non manufacturing). Fxed costs are incurred uniformly throughout the year and amount to Rs.750,000 (2/3 mamufacturing and 1/3 non-mammfactaring Required: a) The number of units that must be sold to carn an after-tax income of Ra. 100,000 assume income tax rate of 20%). Prove your answer by prepaning imcome statement to that effect b) Illustrate the role of changes in...
Magic Inc. sells a single product at a selling price of $57 per unit. Magic’s variable...
Magic Inc. sells a single product at a selling price of $57 per unit. Magic’s variable costs are $35 per unit and its total fixed costs are $719,400 per year. Magic is considering the purchase of new equipment which would reduce its variable costs to $28 per unit but increase its total fixed costs to $1,023,700 per year. a. Assuming Magic expects to sell 40,000 units per year, should it purchase the new equipment? b. Would your answer change if...
A manufacturer produces a product that sells for $10 per unit. Variable costs per unit are...
A manufacturer produces a product that sells for $10 per unit. Variable costs per unit are $6 and total fixed costs are $12,000. At this selling price, the company earns a profit equal to 10% of total dollar sales. By reducing its selling price to $9 per unit, the manufacturer can increase its unit sales volume by 25%. Assume that there are no taxes and that total fixed costs and variable costs per unit remain unchanged. If the selling price...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs:...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs: $200,000 Required Each of these are separate situations: What is the break-even point in total sales in dollars? How many units need to be sold to make a profit of $20,000? How many units need to be sold to make a profit of $20,000 if fixed costs increase from $200,000 to $250,000? How many units would they need to sell if they wanted to...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs:...
Given the following information: Selling Price (per unit): $10,000 Variable Costs (per unit): $7,000 Fixed Costs: $200,000 Required Each of these are separate situations: What is the break-even point in total sales in dollars? How many units need to be sold to make a profit of $20,000? How many units need to be sold to make a profit of $20,000 if fixed costs increase from $200,000 to $250,000? How many units would they need to sell if they wanted to...
Product X is selling for $40/unit. Its variable costs are $20/unit. Fixed costs associated with this...
Product X is selling for $40/unit. Its variable costs are $20/unit. Fixed costs associated with this product are $300,000/year. The company expects to sell 250,000 of Product X a year. What is the current annual profit of Product X? What is the breakeven point in units for Product X? Suppose the company decides it wants to charge a 20% markup on cost. What would the target return price of Product X be? The company decides not to change the price...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT