Question

In: Accounting

Martinez Corporation has collected the following information after its first year of sales. Sales were $1,250,000...

Martinez Corporation has collected the following information after its first year of sales. Sales were $1,250,000 on 125,000 units, selling expenses $250,000 (40% variable and 60% fixed), direct materials $496,000, direct labor $34,900, administrative expenses $280,000 (20% variable and 80% fixed), and manufacturing overhead $358,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10% next year.

Compute (1) the contribution margin for the current year and the projected year, and (2) the fixed costs for the current year. (Assume that fixed costs will remain the same in the projected year.) (1) Contribution margin for current year $ Contribution margin for projected year $ (2) Fixed Costs $ Compute the break-even point in units and sales dollars for the current year. (Round intermediate calculations to 2 decimal places e.g. 2.25 and final answers to 0 decimal places, e.g. 1,225.) Break-even point in units units Break-even point in dollars $ The company has a target net income of $202,000. What is the required sales in dollars for the company to meet its target? (Round answer to 0 decimal places, e.g. 1,225.) Sales dollars required for target net income $ If the company meets its target net income number, by what percentage could its sales fall before it is operating at a loss? That is, what is its margin of safety ratio? (Round answer to 1 decimal place, e.g. 10.5.) Margin of safety ratio %

Solutions

Expert Solution

Sales $   1,250,000
Variable Costs
Direct Material $      496,000
Direct Labor $         34,900
Manufacturing Overhead $      250,600 =358000*70%
Selling Expenses $      100,000 =250000*40%
Adminstrative Expenses $         56,000 =280000*20%
Total Variable Costs $      937,500
Contribution Margin $      312,500
Fixed Costs
Manufacturing Overhead $      107,400 =358000*30%
Selling Expenses $      150,000 =250000*60%
Adminstrative Expenses $      224,000 =280000*80%
Total Fixed Costs $      481,400
Net Operating Income $    (168,900)

(1) Contribution Margin for Current Year = $312500

(2) Fixed Costs for Current Year = $481400

(3) Break even point (Units) = Fixed Costs / Contribution Margin per unit
= $481400 / 2.5 = 192560 units
Contribution Margin per unit = $312500 / 125000 = $2.5 per unit

(4) Break even point (Dollars) = 192560 x $10 = $1925600

(5) Required Sales for target net income = (Fixed Costs+Desired Profit) / Contribution Margin Ratio
= ($481400+202000) / 25% = $2733600
Contribution Margin Ratio = $312500 / 1250000 = 25%

(6) Margin of Safety = ($2733600-1925600) / 2733600 = 29.56%


Related Solutions

Viejol corporation has collected the following information after its first year of sales. Sales were 1,600,00...
Viejol corporation has collected the following information after its first year of sales. Sales were 1,600,00 on 100,00 units, selling expenses 250,000 940, variable and 60% fixed) direct materials 490,00, direct labor 290,000, administrative expenses 270,000 ( 20% variable and 80% fixed), and manufacturing overhead 380,000( 70% variable and 30% fixed). Top management asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...
Viejol Corporation has collected the following information after its first year of sales. Sales were $1,600,000...
Viejol Corporation has collected the following information after its first year of sales. Sales were $1,600,000 on 100,000 units, selling expenses $210,000 (40% variable and 60% fixed), direct materials $498,000, direct labor $296,600, administrative expenses $284,000 (20% variable and 80% fixed), and manufacturing overhead $378,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...
Isaac Corporation has collected the following information after its first year of sales. Sales were $1,800,000...
Isaac Corporation has collected the following information after its first year of sales. Sales were $1,800,000 on 100,000 units; selling expenses $400,000 (30% variable and 70% fixed); direct materials $456,000; direct labour $250,000; administrative expenses $484,000 (50% variable and 50% fixed); manufacturing overhead $480,000 (40% variable and 60% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 20% next...
Lorge Corporation has collected the following information after its first year of sales. Sales were $2,100,000...
Lorge Corporation has collected the following information after its first year of sales. Sales were $2,100,000 on 105,000 units; selling expenses $250,000 (40% variable and 60% fixed); direct materials $1,006,700; direct labor $240,000; administrative expenses $270,000 (20% variable and 80% fixed); and manufacturing overhead $399,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...
Axelle Corporation has collected the following information after its first year of sales. Net sales were...
Axelle Corporation has collected the following information after its first year of sales. Net sales were $2 million on 100,000 units, selling expenses were $400,000 (30% variable and 70% fixed), direct materials were $600,000, direct labour was $340,000, administrative expenses were $500,000 (30% variable and 70% fixed), and manufacturing overhead was $480,000 (20% variable and 80% fixed). Top managers have asked you to do a CVP analysis so that they can make plans for the coming year. They have projected...
Viejol Corporation has collected the following information after its first year of sales. Sales were $2,000,000...
Viejol Corporation has collected the following information after its first year of sales. Sales were $2,000,000 on 100,000 units, selling expenses $210,000 (40% variable and 60% fixed), direct materials $498,000, direct labor $600,200, administrative expenses $280,000 (20% variable and 80% fixed), and manufacturing overhead $374,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...
Viejol Corporation has collected the following information after its first year of sales. Sales were $1,600,000...
Viejol Corporation has collected the following information after its first year of sales. Sales were $1,600,000 on 100,000 units, selling expenses $250,000 (40% variable and 60% fixed), direct materials $510,000, direct labor $290,600, administrative expenses $272,000 (20% variable and 80% fixed), and manufacturing overhead $350,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...
Lorge Corporation has collected the following information after its first year of sales. Sales were $2,875,000...
Lorge Corporation has collected the following information after its first year of sales. Sales were $2,875,000 on 115,000 units; selling expenses $250,000 (40% variable and 60% fixed); direct materials $1,655,900; direct labor $250,000; administrative expenses $270,000 (20% variable and 80% fixed); and manufacturing overhead $343,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...
Viejol Corporation has collected the following information after its first year of sales. Sales were $1,600,000...
Viejol Corporation has collected the following information after its first year of sales. Sales were $1,600,000 on 100,000 units, selling expenses $200,000 (40% variable and 60% fixed), direct materials $508,000, direct labor $290,400, administrative expenses $278,000 (20% variable and 80% fixed), and manufacturing overhead $380,000 (70% variable and 30% fixed). Top management has asked you to do a CVP analysis so that it can make plans for the coming year. It has projected that unit sales will increase by 10%...
Company X has collected the following information after its first year of sales. Sales were TL1,650,000...
Company X has collected the following information after its first year of sales. Sales were TL1,650,000 on 120,000 units. Selling expenses were TL245,000 of which 45% was variable. Direct materials were TL490,000 and direct labor were TL290,000. Administrative expenses were TL270,000 of which 22% was variable. MOH was TL384,000 of which 75% was variable. (9 points) Without using CVP Income Statement, compute contribution margin, unit contributionmargin and the contribution margin ratio. (7 points) Prepare a CVP income statement for both...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT