Question

In: Accounting

Question: During FY 2016, Alpha Company sold 500 units for total sales of $20,000. Manufacturing costs...

Question: During FY 2016, Alpha Company sold 500 units for total sales of $20,000. Manufacturing costs consisted of direct labor $2,500, direct materials $5,400, variable factory overhead $1,100, and fixed factory overhead $3,500. Alpha Company does not maintain any inventories. Selling expenses were $900 variable and $1,000 fixed. Administrative expenses were $1,500 variable and $2,000 fixed. Net Income was $3,100. Use this information to determine the following using CVP Analysis: (Round all final answers to nearest dollar or whole unit number.)

1. Breakeven Point in total sales dollars

2. Breakeven Point in total units

3. Breakeven Point in total sales dollars if the fixed factory overhead increased by $1,500

4. Breakeven Point in total units if the fixed factory overhead increased by $1,500

5. Net Income if sales units increased by 35%

Solutions

Expert Solution

Selling price per unit = 20,000/500

= $40

Total variable cost = Direct material + Direct labor + Variable factory overhead + Variable selling expenses + Variable administrative expenses

= 5,400 + 2,500 + 1,100 + 900 + 1,500

= $11,400

Hence, variable cost per unit = 11,400/500

= $22.8

Fixed cost = Fixed factory overhead + Fixed selling expenses + Fixed administrative expenses

= 3,500 + 1,000 + 2,000

= $6,500

Contribution margin = Selling price per unit - Variable cost per unit

= 40 - 22.8

= $17.2

Contribution margin ratio = Contribution margin/Sales

= 17.2/40

= 43%

(1)

Break even point (in $) = Fixed cost/Contribution margin ratio

= 6,500/43%

= $15,116

(2)

Break even point (in units) = Fixed cost/Contribution margin per unit

= 6,500/17.2

= $378 units

(3)

New fixed cost = 6,500 + 1,500

= $8,000

Break even point (in $) = Fixed cost/Contribution margin ratio

= 8,000/43%

= $18,605

(4)

New fixed cost = 6,500 + 1,500

= $8,000

Break even point (in units) = Fixed cost/Contribution margin per unit

= 8,000/17.2

= 465 units

(5)

Increase in sales units = 500 x 35%

= 175

Hence, new sales units = 500 + 175

= 675

Profit = (Sales x Contribution margin ratio) - Fixed cost

= (675 x 40 x 43%) - 6,500

= 11,610 - 6,500

= $5,110

Kindly give a positive rating if you are satisfied with the answer. Feel free to ask if you have any doubts. Thanks.


Related Solutions

During FY 2016, Alpha Company sold 500 units for total sales of $20,000. Manufacturing costs consisted...
During FY 2016, Alpha Company sold 500 units for total sales of $20,000. Manufacturing costs consisted of direct labor $2,500, direct materials $4,400, variable factory overhead $1,100, and fixed factory overhead $3,500. Alpha Company does not maintain any inventories. Total cost of goods sold was $4,400. Selling expenses were $900 variable and $1,000 fixed. Administrative expenses were $1,500 variable and $2,000 fixed. Net Income was $3,100. Use this information to determine the following using CVP Analysis: (Round all final answers...
A company sold a total of 1,000 units for total sales revenue of $70,000. The company...
A company sold a total of 1,000 units for total sales revenue of $70,000. The company incurred total variable expenses of $38,500 and total fixed expenses of $ 23,310. Based on this, the company reported a total contribution margin of $31,500 and net operating income of $ 8,190. Use this information to answer the following questions. Assume that all units are within the relevant range. 1 Calculate the net operating income if the variable cost per unit increases by $1,...
A company sold a total of 1,000 units for total sales revenue of $70,000. The company...
A company sold a total of 1,000 units for total sales revenue of $70,000. The company incurred total variable expenses of $38,500 and total fixed expenses of $ 23,310. Based on this, the company reported a total contribution margin of $31,500 and net operating income of $ 8,190. Use this information to answer the following questions. Assume that all units are within the relevant range. 1.Calculate the per-unit contribution margin 2.Calculate the contribution margin ratio. 3. Calculate the increase in...
Acme Company sold 500 units for $450 each. Variable costs were $275 per unit, and total...
Acme Company sold 500 units for $450 each. Variable costs were $275 per unit, and total fixed expenses were $53,000. Prepare a contribution margin income statement. . Scottso Enterprises has presented the following information for the past eight months operations: Month Units Total Cost Aprl 4,000 $ 17,000 May 3,200 $ 14,900 June 1,400 $ 11,100 July 2,800 $ 13,200 August 3,500 $ 16,000 September 4,200 $ 17,400 October 3,900 $ 16,500 November 3,400 $ 15,700 a. Using the high-low...
Units sold 1,180 Price $ 10 Sales $ 11,800 Variable manufacturing costs 4,720 Fixed manufacturing costs...
Units sold 1,180 Price $ 10 Sales $ 11,800 Variable manufacturing costs 4,720 Fixed manufacturing costs 2,360 Variable selling costs 1,180 Fixed administrative costs 1,180 Required: Using the data provided, compute the margin of safety and margin of safety ratio. mos: mos ratio:
You have a company that has sold 500 units for $300,000. Each unit costs $200 to...
You have a company that has sold 500 units for $300,000. Each unit costs $200 to make. Each year we also have a sales commission of $40 per bike. Our fixed costs are 15,000, but I want to make a target profit of $30,000. What is the breakeven in sales
No of units   Fixed costs   Total variable costs   Total Costs   Total Sales 0   15,000   0   15,000  ...
No of units   Fixed costs   Total variable costs   Total Costs   Total Sales 0   15,000   0   15,000   0 50   15,000   10,500   25,500   15,000 100   15,000   21,000   36,000   30,000 150   15,000   31,500   46,500   45,000 200   15,000   42,000   57,000   60,000 250   15,000   52,500   67,500   75,000 300   15,000   63,000   78,000   90,000 Create a CVP graph.
2015 2016 Sales Revenue $920,000 $840,000 Cost of Goods Sold 575,000 545,000 Interest Expense 20,000 20,000...
2015 2016 Sales Revenue $920,000 $840,000 Cost of Goods Sold 575,000 545,000 Interest Expense 20,000 20,000 Income Tax Expense 27,000 30,000 Net Income 61,000 52,000 Cash Flow from Operations 65,000 55,000 Capital Expenditures 65,000 55,000 Acc Receivable (net) 31 Dec 126,000 120,000 Inventory 31 Dec 196,000 160,000 Stockholders' Equity 31 Dec 450,000 400,000 Total Assets 31 Dec 750,000 675,000 Required: Calculate the following ratios for 2016. The 2015 results are given for comparative purposes. Round answers to one (1) decimal...
Suppose marginal costs are below average total costs at 500 units of output for a manufacturer....
Suppose marginal costs are below average total costs at 500 units of output for a manufacturer. If the manufacturer produces an additional unit, will its average total costs rise, fall, or stay the same? Explain.
Question 33 During 2016, Rafael Corp. produced 39,120 units and sold 39,120 for $16 per unit....
Question 33 During 2016, Rafael Corp. produced 39,120 units and sold 39,120 for $16 per unit. Suppose the accountant for Rafael Corp. uses normal costing and uses the budgeted volume of 48,900 units. Variable manufacturing costs were $6 per unit. Annual fixed manufacturing overhead was $78,240 ($2 per unit). Variable selling and administrative costs were $2 per unit sold, and fixed selling and administrative expenses were $19,400. The company expenses production volume variance to cost of goods sold in the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT