Here are the calculations for the required questions.
First, let's extract the necessary information and calculate the per-unit costs and total fixed costs.
Given Data:
- Sales: 25,000 units @ N40 each = N1,000,000
- Direct materials = N250,000
- Direct labor = N125,000
- Variable overhead = N62,500
- Fixed Admin expenses = N180,000
- Fixed miscellaneous expenses = N70,000
- Current Net profit = N312,500
Step 1: Calculate per-unit and total fixed costs.
-
Selling Price per unit (SP):
SP=NumberofunitssoldTotalSales=25,000unitsN1,000,000=N40/unit
-
Variable Costs per unit (VC per unit):
- Direct materials per unit = 25,000unitsN250,000=N10/unit
- Direct labor per unit = 25,000unitsN125,000=N5/unit
- Variable overhead per unit = 25,000unitsN62,500=N2.50/unit
VCperunit=N10+N5+N2.50=N17.50/unit
-
Total Fixed Costs (FC):
FC=FixedAdminexpenses+Fixedmiscellaneousexpenses
FC=N180,000+N70,000=N250,000
-
Contribution Margin per unit (CM per unit):
CMperunit=SP−VCperunit=N40−N17.50=N22.50/unit
1. How many units must be sold before the company can break even?
Step 1: Identify the formula for break-even point in units.
Break−evenpointinunits=ContributionMarginperunitTotalFixedCosts
Step 2: Substitute the calculated values into the formula.
Break−evenpointinunits=N22.50/unitN250,000
Step 3: Calculate the break-even point.
Break−evenpointinunits=11,111.11units
Since units must be whole numbers, we round up to the next whole unit to ensure breaking even.
Break−evenpointinunits=11,112units
The company must sell 11,112units to break even.
2. What will be the Net profit if sales increase by 30% assuming no increase in selling price?
Step 1: Calculate the new number of units sold.
Newunitssold=25,000units×(1+0.30)=25,000units×1.30=32,500units
Step 2: Calculate the new total sales revenue.
Newtotalsalesrevenue=32,500units×N40/unit=N1,300,000
Step 3: Calculate the new total variable costs.
Newtotalvariablecosts=32,500units×N17.50/unit=N568,750
Step 4: Calculate the new total contribution margin.
Newtotalcontributionmargin=N1,300,000−N568,750=N731,250
Step 5: Calculate the new Net Profit.
NewNetProfit=Newtotalcontributionmargin−TotalFixedCosts
NewNetProfit=N731,250−N250,000=N481,250
The Net profit if sales increase by 30% will be N481,250.
3. If selling price is reduced by 5%, how many units must be sold in order to maintain a net profit equal to the current profit?
Step 1: Identify the target profit.
Target Net Profit = Current Net Profit = N312,500
Step 2: Calculate the new selling price per unit.