Fly Ash Brick Project (Feasibility Study Using CVP Analysis)-MARCUS.xlsx

This preview shows page 1 - 4 out of 23 pages.

Fixed CostRoutine Expenses Per Month in Indian RupeesBuilding Rent50,000.00 Administrative Cost10,000.00 Office Supply5,000.00 Electricity (for lighting)10,000.00 Miscellaneous20,000.00 Total95,000.00 Variable CostExpenses Related To Volume of Production Per Month In Indian RupeFly Ash250,000.00 Gypsum250,000.00 Lime300,000.00 Sand40,000.00 Electricity10,000.00 Labour50,000.00 Total900,000.00 Fixed CostPersonnel Costs Per Month In Indian RupeesWorkers100,000.00 Office Assistant20,000.00 Watchman15,000.00 Drivers25,000.00 Sharma's Salary50,000.00 Total210,000.00 Total Investment10,000,000.00 Capital Invested6,000,000.00 Interest Rate0.12 Interest Expense Per M 40,000.00 Sales Volume In One Ye 2,400,000 Sales Per Unit7.00 Expected Sales In One Y 16,800,000 Fixed CostWorkers100,000.00 Office Assistant20,000.00 Watchman15,000.00 Drivers25,000.00 Sharma's Salary50,000.00 Building Rent50,000.00 Administrative Cost10,000.00 Office Supply5,000.00 Electricity (for lighting)10,000.00 Miscellaneous20,000.00
depreciation of Plant 133333Expense on Interest on 40000Total Fixed Cost478,333 Fixed CostsPersonnel Cost per monthINR 210,000.00 Routine Expenses per MonthINR 95,000.00 Interest on Loan INR 40,000.00 Monthly Depreciation Expense on Plant & EquipmentINR 133,333.00 Fixed Costs:INR 478,333.00 MonthlyYearly5 YearsTotal Fixed Cost (in Rs)478,333.00 5,739,996.00 28,699,980.00 Total Variable Cost Per Unit (in Rs)4.50 4.50 4.50 Sale price per unit(in Rs)7.00 7.00 7.00 Contribution Margin per unit (in Rs)2.50 30.00 150.00 Break Even Point 191,333.20 2,295,998.40 11,479,992.00 Break Even Value (in Rs)1,339,332.40 16,071,988.80 80,359,944.00 Total Proposed Sales(units)200,000.00 2,400,000.00 12,000,000.00 Total expected Revenue from Sales (i 1,400,000.00 16,800,000.00 84,000,000.00 Margin of Safety (in Rs)60,667.60 728,011.20 3,640,056.00 Margin of safety ratio4.33 4.33 4.33 operating profit in RS21,667.00 66,260,004.00 1,771,300,020.00 per unitxvolumeRevenue7
Variable Expenses4.5Contribution Margin2.5 x200000

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture