Question

In: Accounting

Year 1 year 2 year 3 Sales Units 2500 2750 2900 sales Price Unit $150.00 $         ...

Year 1

year 2 year 3
Sales Units 2500 2750 2900
sales Price Unit $150.00 $          150.00 $          150.00
REVENUE $185,000 $250,000 $440,000
$375,000.00 $ 412,500.00 $ 435,000.00
Variable Costs:
             Direct Materials $20.00 $20.50 $26.01
              Direct Labor $17.15 $17.60 $19.22
              Variable OH

$2.50

$2.53 $2.55
Fixed Costs:
                                               Rent 80,000 $80,000 $80,000
                                    Supervision 200,000 $205,000 $210,250
Mixed Costs:
                           Utilites-Fixed 20,000 20,000 20,000
                           Utilities-Variable $2.50 $2.50 $2.50
Total Costs:
Variable cost per unit $42.15 $43.13 $50.28
Fixed Costs $300,000 $305,000 $310,250
Contribution Margin 3.74 4.12 4.34
37% 41% 43%
Breakeven:
Sales Units
Sales Revenue
Margin of Safety:
What would be the margin of safety and the breakeven sales units and sale revenue

im not understanding what details are wrong ?

Solutions

Expert Solution

Year 1 Year 2 Year 3
Sales in Units              2,500              2,750              2,900
Sales Price Per Unit            150.00            150.00            150.00
Variable Cost per Unit:
Direct Materials              20.00              20.50              26.01
Direct Labor              17.15              17.60              19.22
Variable Overhead                 2.50                 2.53                 2.55
Utilities - Variable                 2.50                 2.50                 2.50
Total Variable Cost per Unit              42.15              40.63              47.78
Contribution Per Unit            107.85            109.37            102.22
Contribution Margin 71.90% 72.91% 68.15%
Fixed Costs:
Rent      80,000.00      80,000.00      80,000.00
Supervision    200,000.00    205,000.00    210,250.00
Utilities      20,000.00      20,000.00      20,000.00
Total Fixed Costs    300,000.00    305,000.00    310,250.00
BEP (In Units) (Approx.)              2,782              2,789              3,035
BEP (In $) (Approx)          417,246          418,305          455,268
Sales Revenue          375,000          412,500          435,000
Margin Of Safety            42,246              5,805            20,268
BEP (In Units) = Fixed Costs / Contribution Margin per Unit
BEP (In $) = Fixed Costs / Contribution Margin Ratio
Magin of Safety = Sales - BEP (In $)

Related Solutions

  Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales...
  Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000   Selling price per unit $7 per unit             1 Chapter 7: Applying Excel 2 3 Data Year 2 Quarter Year 3 Quarter 4 1 2 3 4 1 2 5 Budgeted unit sales 50,000 65,000 115,000 70,000 80,000 90,000 6 7 � Selling price per unit $8 per unit 8 � Accounts receivable, beginning balance...
Year 1 Year 2 Year 3 Year 4 Year 5 Units Sales                 75,000          95,000...
Year 1 Year 2 Year 3 Year 4 Year 5 Units Sales                 75,000          95,000           125,000        130,000    140,000 Equipment Cost        61,000,000 Salvage value Units Price                       650 Variable cost (per unit)                       300 Fixed costs (per year)           4,300,000 Tax rate 35% NWC (% of sales) 15% Required return 12% Required Payback Period (years)                             3 MACRS Schedule Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 3-year...
Currently, the sales of a company is $12,800,000 per year: price per unit $12.8; units sold...
Currently, the sales of a company is $12,800,000 per year: price per unit $12.8; units sold 1,000,000 per year; direct cost per unit $9.60; A/R 25% of $ sales (ignore A/P); inventory 25% of direct cost; cash operating expense $890,000 per year; annual depreciation $600,000; tax rate 34%; capital expenditure is zero. Now you are estimating the free cash flow for the next year when the unit sales price changes to $15.36, thus changing $ sales; however, the number of...
BWP projects sales of 100000 units next year at an average price of $50 per unit....
BWP projects sales of 100000 units next year at an average price of $50 per unit. Variable costs are estimated at 40% of revenue, and fixed costs will be $2.4 million. BWP has $1 million in bonds outstanding, on which it pays 7%, and its marginal tax rate is 38%. There are 100000 shares of stock outstanding which trade at their book value of $30. Compute BWP's contribution, contribution margin, net income, DOL, and EPS. Round the answers to two...
1.A company has provided the following data:   Sales 12,000 units   Sales price $100 per unit   Variable...
1.A company has provided the following data:   Sales 12,000 units   Sales price $100 per unit   Variable cost $50 per unit   Fixed cost $300,000             If the dollar contribution margin per unit is increased by 10%, total fixed cost is decreased by 20%, and all other factors remain the same, by how much will net income increase? 2.   Hamada Company sells a single product. The product has a selling price of $100 per unit and variable expenses of 80% of sales. If the...
Sales price per unit: (current monthly sales volume is 120,000 units). . . . $25.00 Variable...
Sales price per unit: (current monthly sales volume is 120,000 units). . . . $25.00 Variable costs per unit: Direct materials. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $6.60 Direct labor. . . . . . . . . . . . . . . ....
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10...
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10 410 7/6 Purchase 800 4.20 3,360 7/7 Sale 300 7.00 2,100 7/10 Sale 300 7.30 2,190 7/12 Purchase 400 4.50 1,800 7/15 Sale 200 7.40 1,480 7/18 Purchase 300 4.60 1,380 7/22 Sale 400 7.40 2,960 7/25 Purchase 500 4.58 2,290 7/30 Sale 200 7.50 1,500 Totals 2,100 9,240 1,400 10,230 Compute FIFO, LIFO, Average for the perpetual inventory system. Be sure to do...
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10...
Date Transaction Units In Unit Cost Total Units Sold Sales Price Total 7/1 Balance 100 4.10 410 7/6 Purchase 800 4.20 3,360 7/7 Sale 300 7.00 2,100 7/10 Sale 300 7.30 2,190 7/12 Purchase 400 4.50 1,800 7/15 Sale 200 7.40 1,480 7/18 Purchase 300 4.60 1,380 7/22 Sale 400 7.40 2,960 7/25 Purchase 500 4.58 2,290 7/30 Sale 200 7.50 1,500 Totals 2,100 9,240 1,400 10,230 Compute FIFO, LIFO, Average for the periodic inventory system. Be sure to do...
1. Consider the Following 10-year project: Year Cash Flow 0 -30000 1 2500 2 5000 3...
1. Consider the Following 10-year project: Year Cash Flow 0 -30000 1 2500 2 5000 3 6750 4 7000 5 7250 6 6000 7 6250 8 8000 9 3750 10 2000 Complete the following questions on excel: What is the Payback Period for the project? What is the Discounted Payback Period for the project at 12% required rate of return? What is the NPV of the project if the required rate of return is 12% What is the PI of...
Year   Unit Sales 1   109,000 2   125,000 3   136,000 4   158,000 5   97,000 Production of the...
Year   Unit Sales 1   109,000 2   125,000 3   136,000 4   158,000 5   97,000 Production of the implants will require $812,000 in net working capital to start and additional net working capital investments each year equal to 20% of the projected sales increase for the following year. (Because sales are expected to fall in Year 5, there is no NWC cash flow occurring for Year 4.) Total fixed costs are $194,000 per year, variable production costs are $290 per unit, and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT