KEMBAR78
Breakeven Analysis in EGP | PDF | Pricing | Business
Scribd
Upload
92 views1 page

Breakeven Analysis in EGP

This document presents a breakeven analysis for a company. It shows that the company's breakeven point is 5,833 units. The analysis also includes a sales volume analysis that projects the company will sell 355,000 units total in the year, generating total sales of EGP 14.2 million and a net profit of EGP 3.42 million. Variable costs are projected to be EGP 9.94 million and fixed costs EGP 840,000 for the year.

Uploaded by

ssakr911
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
92 views1 page

Breakeven Analysis in EGP

This document presents a breakeven analysis for a company. It shows that the company's breakeven point is 5,833 units. The analysis also includes a sales volume analysis that projects the company will sell 355,000 units total in the year, generating total sales of EGP 14.2 million and a net profit of EGP 3.42 million. Variable costs are projected to be EGP 9.94 million and fixed costs EGP 840,000 for the year.

Uploaded by

ssakr911
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

BREAKEVEN ANALYSIS

FFF
AMOUNTS SHOWN IN EGP.
Breakeven Analysis Chart
SALES
EGP 100,000,000.00
SALES PRICE PER UNIT EGP 40.00
SALES VOLUME PER PERIOD (UNITS) 355,000 EGP 10,000,000.00
TOTAL SALES EGP 14,200,000.00 EGP 1,000,000.00

EGP 100,000.00
VARIABLE COSTS

EGP
COMMISSION PER UNIT EGP 3.00 EGP 10,000.00
DIRECT MATERIAL PER UNIT EGP 18.00 EGP 1,000.00
SHIPPING PER UNIT EGP 1.00
EGP 100.00
PAKING PER UNIT EGP 2.00
OTHER VARIABLE COSTS PER UNIT EGP 2.00 EGP 10.00
DEPRETIATION COST PER UNIT EGP 2.00 EGP 1.00
VARIABLE COSTS PER UNIT EGP 28.00 0 10,000 20,000 25,000 30,000 30,000 30,000 105,000 105,000 355,000
TOTAL VARIABLE COSTS EGP 9,940,000.00 SALES VOLUME (UNITS)

UNIT CONTRIBUTION MARGIN EGP 12.00 FIXED COSTS PER PERIOD TOTAL COSTS TOTAL SALES NET PROFIT (LOSS)
GROSS MARGIN EGP 4,260,000.00

FIXED COSTS PER PERIOD


ADMINISTRATIVE COSTS EGP 50,000.00 Variable Costs per Unit Unit Contribution Margin
EGP 2.00 , 7%
Plant RENT EGP 10,000.00 EGP 2.00 , 7% COMMISSION PER UNIT
OTHER FIXED COSTS EGP 10,000.00
EGP 12.00 , 30%
TOTAL FIXED COSTS Per Month EGP 70,000.00 EGP 2.00 , 7% EGP 3.00 , 11% DIRECT MATERIAL PER UNIT VARIABLE COSTS PER UNIT
TOTAL FIXED COSTS PER Year EGP 840,000.00 EGP 1.00 , 4% SHIPPING PER UNIT
NET PROFIT (LOSS) EGP 3,420,000.00
EGP
18.00 , PAKING PER UNIT

RESULTS 64%
OTHER VARIABLE COSTS PER UNIT
EGP 28.00
UNIT CONTRIBUTION MARGIN
, 70%
BREAKEVEN POINT (UNITS): 5833.33 DEPRETIATION COST PER UNIT

SALES VOLUME ANALYSIS:


Period Start Up 1st Month 2nd Month 3rd Month 4th Month 5th Month 6th Month 3rd Quarter 4th Quarter Total Year
SALES VOLUME PER PERIOD (UNITS) 0 10,000 20,000 25,000 30,000 30,000 30,000 105,000 105,000 355,000
SALES PRICE PER UNIT EGP 40.00 EGP 40.00 EGP 40.00 EGP 40.00 EGP 40.00 EGP 40.00 EGP 40.00 EGP 40.00 EGP 40.00 EGP 40.00
FIXED COSTS PER PERIOD EGP 70,000.00 EGP 70,000.00 EGP 70,000.00 EGP 70,000.00 EGP 70,000.00 EGP 70,000.00 EGP 70,000.00 EGP 210,000.00 EGP 210,000.00 EGP 840,000.00
VARIABLE COSTS EGP - EGP 280,000.00 EGP 560,000.00 EGP 700,000.00 EGP 840,000.00 EGP 840,000.00 EGP 840,000.00 EGP 2,940,000.00 EGP 2,940,000.00 EGP 9,940,000.00
TOTAL COSTS EGP 70,000.00 EGP 350,000.00 EGP 630,000.00 EGP 770,000.00 EGP 910,000.00 EGP 910,000.00 EGP 910,000.00 EGP 3,150,000.00 EGP 3,150,000.00 EGP 10,780,000.00
TOTAL SALES EGP - EGP 400,000.00 EGP 800,000.00 EGP 1,000,000.00 EGP 1,200,000.00 EGP 1,200,000.00 EGP 1,200,000.00 EGP 4,200,000.00 EGP 4,200,000.00 EGP 14,200,000.00
NET PROFIT (LOSS) EGP (70,000.00) EGP 50,000.00 EGP 170,000.00 EGP 230,000.00 EGP 290,000.00 EGP 290,000.00 EGP 290,000.00 EGP 1,050,000.00 EGP 1,050,000.00 EGP 3,420,000.00

You might also like