Preview

Calculating Ficed Cost Variable Costs

Satisfactory Essays
Open Document
Open Document
57 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Calculating Ficed Cost Variable Costs
Average Customers:
2002 5,962.00
2003 6,821.00
2004 11,822.00

Total 24,605.00
No.Of Years 3
Average customers 8,202

Average Revenue Per Unit : 2002 $1,165,065
2003 1,244,261.00
2004 2,191,243.00
Total $4,600,569.00

No.of Years 3
Average Revenue $1,533,523.00
Average Customers 8,202.00
Average Revenue per Unit $ 187.00

Average Variable Cost :
2002 $1,011,008** **$417,004+$124,101.20+$117,903+$351,000
2003 1,142,681.00** ** $520,069+$171,622.70+$79,888+$371,101
2004 1,798.131.00 ** ** $915,787.50+$320,525.52 +$115,999+$445,819
Total $3,951,820.00
No.of Years 3
Average VC $1,317,273.00
Average Customers 8,202.00
Average VC per unit $161.00

Fixed Cost $174,000 ** ** 151,000+24,000
Breakeven=fix cost /(average revenue per unit –average vc per unit )
Breakeven =$174,000/($187-$161)
Breakeven=$174,000/$26
Breakeven=6,692 customer

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Revenue Estimates Revenue Item 100% Monthly 75% Monthly 50% Monthly Notes Rooms $2,956,500 $2,217,375 $1,478,250 8,100 daily Leases $180,000 $135,000 $90,000 TOTAL REVENUE $3,136,500 $2,352,375 $1,568,250 Expences TOTAL VARIABLE COSTS $454,000 $340,500 $227,000 TOTAL FIXED COSTS $1,403,000 $1,403,001 $1,403,002 TOTAL EXPENSE BEFORE IT $1,857,000 $1,743,501 $1,630,002 EBIT $1,279,500 $608,874 -$61,752 Depreciation $320,000 $320,001 $320,002 EBITDA $1,599,500 $928,875 $258,250 Furnishing Interest $110,000 $110,000 $110,000 20yr Mortgage Interest $182,000 $182,000 $182,000 TOTAL INTEREST $292,000 $292,000 $292,000 TAXES (40%) $395,000.00 $126,749.60 -$141,500.80 Furnishing Principal $180,160 $180,160 $180,160 20yr Mortgage Principal $49,713 $49,713 $49,713 TOTAL PRINCIPAL $229,873 $229,873 $229,873 NET INCOME $362,627 -$39,749 -$442,124 DIVIDEND PAYMENT $29,010 -$3,180 -$35,370 RETAINED EARNINGS $333,617 -$36,569 EBIT/INTEREST 4.38 2.09 (0.21) EBITDA/INTEREST 5.48 3.18 0.88 BURDEN $675,121.67 $675,121.67 $675,121.67 EBIT/BURDEN 1.90 0.90 (0.09) ROE= Net Income/OE (H1) 32.97% -3.61% -40.19% Revenue Estimates Revenue Item 100% Monthly 75%…

    • 1302 Words
    • 21 Pages
    Satisfactory Essays
  • Good Essays

    Acct 505 Course Project

    • 1431 Words
    • 6 Pages

    | BE (Revenue) = Fixed Cost/Contribution Ratio Contribution Margin Ratio =[(Selling Price per unit – Variable Cost per unit) /Selling price per unit ] = (160-70)/160 = 56%BE Target Sales in $ = (Fixed cost + target income)/ contribution margin ratio = 3,500,000/56% = $5,625,000…

    • 1431 Words
    • 6 Pages
    Good Essays
  • Good Essays

    $5,400 - Depreciation $26,180 - Operations (salaried staff) $21,600 - Systems development and maintenance $12,000 - Administration $9,000 - Sales $11,200 - Sales promotion $8,083 - Corporate services $15,236 TOTAL: $212,939 Sales $192,400 Variable Expenses ($9,844.10) Contribution Margin $182,555.90 Fixed Expenses ($212,939) Net Profit/Loss ($30,383.10) 4.) BREAK-EVEN Intracompany (revenue): 205 hrs * $400/hr = $82,000 - Variable Expenses: 205 hrs * 28.7/hr = $5,883.50 - Contribution Margin: $76,116.50 Total Fixed Cost: $212,939 Contribution Margin: ($76,116.50) “Remaining”: $136,822.50 136,822.50 / (800 – 28.7) = 177 units (Break-Even) 5.)…

    • 454 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Cost Accounting Cc2 Unit 2

    • 2988 Words
    • 12 Pages

    Sales have increased over the years, but the rate of this increase is not steady. The highest sales point was in 2006. Cost of sales and expenses with the exception of other expenses have increased at a steady rate. Other operating expenses have fluctuated over the years; the lowest point was in the first year with the highest being in 2006. Finance cost seems to have reached a peak in 2006 and the fallen by 2008. Net Profit after Tax follows a similar pattern to sales. CC3 CONSOLIDATED BALANCE SHEET…

    • 2988 Words
    • 12 Pages
    Good Essays
  • Satisfactory Essays

    Bus 630 Week 1

    • 393 Words
    • 2 Pages

    (1) Estimated contribution margins for the next fiscal quarter (000s omitted): Computer Place Poster Paper Napkins Mats Board Total Number of units 30 120 45 80 275 Sales $420 $840 $540 $680 $2,480 Cost of goods sold: Variable costs 225 612 270 360 1,467 Contribution margin $195 $228 $270 $320 $1,013 Unit revenue and costs information: Computer Place Poster Paper Napkins Mats Board Selling price $14.00 $ 7.00 $12.00 $ 8.50 Materials $ 6.00 $ 4.50 $ 3.60 $ 2.50 Variable factory overhead 1.50 .60 2.40 2.00 Unit variable cost $ 7.50 $ 5.10 $ 6.00 $ 4.50 Contribution margin per unit $ 6.50 $ 1.90 $ 6.00 $ 4.00 (2) Revised contribution margins: Computer Place Poster Paper Napkins Mats Board Total Number of units 35 120 45 80 280 Sales $490.00 $840 $540 $680 $2,550.00 Cost of goods sold: Variable costs 297.50 612 288 360 1,557.50 Contribution margin $192.50 $228 $252 $320 $ 992.50 Unit revenue and costs information: Computer Place Poster Paper Napkins Mats Board Selling price $14.00 $ 7.00 $12.00 $ 8.50 Materials $ 7.00 $ 4.50 $ 4.00 $ 2.50 Variable factory overhead 1.50 .60 2.40 2.00 Unit variable cost $ 8.50 $ 5.10 $ 6.40 $ 4.50 Contribution margin per unit $ 5.50 $ 1.90 $ 5.60 $ 4.00 (3) (a) Breakeven point: $1,013,000 contribution margin 275,000 units = $3.684 contribution margin per unit $1,013,000 contribution margin $2,480,000 sales = 40.8% contribution margin ratio ($420,000 + $118,000 fixed costs) $3.684…

    • 393 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The remaining questions are based on the following assumptions: (1) Cost of Sales & Operating Expenses are Fixed Costs; (2) Contribution Margin =60%.…

    • 270 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    3. The Lyons Company's cost of goods manufactured was $120,000 when its sales were $360,000 and its gross margin was $220,000. If the ending inventory of finished goods was $30,000, the beginning inventory of finished goods must have been:…

    • 2041 Words
    • 9 Pages
    Good Essays
  • Satisfactory Essays

    Both Q and Q2 are significant at an Alpha of .05 with the entire model being highly significant, if you conclude one or more of the coefficients is not equal to zero the probability of being wrong is less than 0.000000000449. This function is statistically better and can actually be used to estimate plant…

    • 341 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Cost Accounting Answers

    • 9270 Words
    • 38 Pages

    An advertising campaign for Pepsi is likely to be very specific to that individual client. Job costing enables all the specific aspects of each job to be identified. In contrast, the processing of checking account withdrawals is similar for many customers. Here, process costing can be used to compute the cost of each checking account withdrawal.…

    • 9270 Words
    • 38 Pages
    Good Essays
  • Satisfactory Essays

    4. Which of the following would produce the largest increase in the contribution margin per unit?…

    • 1377 Words
    • 7 Pages
    Satisfactory Essays
  • Satisfactory Essays

    | Barcelona Bagpipes produces two models: Model 24 has sales of 500 units with a contribution margin of $40 each; Model 26 has sales of 350 units with a contribution margin…

    • 836 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Determining Product Cost

    • 463 Words
    • 2 Pages

    Managerial accountants must decide what types of managerial accounting information to provide to managers, how to measure such information, and when and to whom to communicate the information. For example, when making most strategic and operating decisions, managers typically rely on managerial accounting information that is prepared in whatever manner the managerial accountant believes provides the best analysis for the decision at hand. However, there is one major exception. Managerial accountants must follow specific external reporting rules (i.e., generally accepted accounting principles) when their companies provide outside parties with cost information about the amount of ending inventory on the balance sheet and the cost of goods sold on the income statement.…

    • 463 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    variable costing sm7 libre

    • 8831 Words
    • 74 Pages

    as inventory are finally sold, the fixed manufacturing overhead cost that has been carried over…

    • 8831 Words
    • 74 Pages
    Powerful Essays
  • Good Essays

    Cost Estimation

    • 724 Words
    • 3 Pages

    Cost estimation is a fundamental aspect of managerial/cost accounting (Datar et al. 2008; Eldenburg and Wolcott 2005). The cost predictions are used in each of the management functions. for example used to predict costs so that management can determine the desirability of alternative options and to budget expenditures, profits, and cash flows. The objective is to support students in learning how to apply regression analyses to understand cost behavior and forecast future costs using real data from firms. The case focuses on the harsh financial situation faced by Continental Airlines as a result of the recent financial crisis and the challenges it faces to remain profitable.…

    • 724 Words
    • 3 Pages
    Good Essays

Related Topics