Question

In: Accounting

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 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

Note

1 Let us first calculate contribution per unit and PV ratios :-

Contribution :-

Sales 20000
(-) variable cost
Direct labour (2500)
Direct material (4400)
Variable factory overhead (1100)
Variable selling exp (900)
Variable administrative exp (1500)
Contribution $9600

Contribution per unit = 9600/500 = $19.20

PV ratio = (contribution / sales )x100

= (9600/20000)x100 = 48%.

Total fixed cost

Fixed factory overhead 3500
Fixed selling exp 1000
Fixed administrative exp 2000
Total fixed cost $6500

1 . Breakeven point in total sales dollar = fixed cost /PV ratio = 6500/48% = $13541.67

2 .Breakeven point in total units = fixed cost / contribution per unit = 6500/19.20 = 338.54 or 339 units.

3. Breakeven point in total sales dollars if fixefixed factory overhead increase by $1500

In such case total ftotal fixed cost = 6500+1500 = $8000

Breakven = 8000/48% = $16666.67

4. Breakeven in total units if fixed factory overhead increase by $1500 =✓8000/19.2 = 416.67 units.

5. Net income if total sales units increase by 35%.

Total sales units in such case = 500x1.35 = 675

We know that per unit sales price is 20000/500 = $40

Net income = (675x40)x48%-6500 = $6460


Related Solutions

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...
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.
Alpha company uses the straight-line method for amortization of all bond premium & discounts. During FY...
Alpha company uses the straight-line method for amortization of all bond premium & discounts. During FY 2016 Alpha had the following bond payable transaction: -January 2, issued 10, $1,000 bonds at 102 1/2. These 5-year bonds are dated January 1, 2016. The contract interest rate is 6%. Interest is payable semi-annual on January 1 and July 1. -July 1, Alpha issued $500,000 of 10%, 10-year bonds. These bonds are dated January 1, 2016, were issued at 88 1/2, and pay...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT