based on the following data, find out the break event point for this project. how we change the data to have break event point in this budget? 

Transcribed Image Text:

years production capacity (hrs) Units production (kWh) 30MW = 30000 KW unit selling price years Revenue COGS Gross profit Operationg expenses: Fixed cost: Wages (Manager) Depreciation Interest fee Total Fixed cost 0 Maintenance and utilities 0 Insurance 0 Varible cost: wages (Labours) yr1 0 Subscription and renewals 0 Marketing and advertising 0 Safety certificate 0 Consumables Maintenance Total Variable cost 0 Total expenses Net profit before tax Loss caryforward Tax 30% Net profit after tax yr1 0 0 0 0 0 0 0 0 0 0 yr2 2000 60,000,000 $0.150 yr2 $9,000,000 $5,130,000 $3,870,000 $80,000 $200,000 $25,000 $542 $50,000 $5,000 $800,000 $1,300,000 $2,460,542 $200,000 $300,000 $1,000,000 $1,500,000 $3,960,542 -$90,542 -$90,542 yr3 4000 yr4 5000 yr5 6000 120,000,000 150,000,000 180,000,000 $0.154 yr3 $0.158 yr4 $18,480,000 $23,700,000 $29,160,000 $10,533,600 $13,509,000 $16,621,200 $7,946,400 $10,191,000 $12,538,800 $0.162 yr5 $160,000 $160,000 $160,000 $400,000 $400,000 $400,000 $50,000 $50,000 $50,000 $42 $42 $42 $50,000 $50,000 $0 $0 $600,000 $500,000 $600,000 $1,600,000 $1,600,000 $1,600,000 $1,300,000 $1,300,000 $1,300,000 $3,560,042 $3,560,042 $3,565,042 $50,000 $5,000 $800,000 $1,000,000 $650,000 $1,400,000 $3,050,000 $1,200,000 $1,300,000 $2,300,000 $2,700,000 $5,860,042 $6,260,042 $6,615,042 $2,086,358 $3,930,958 $5,923,758 -$90,542 $598,745 $1,179,287 $1,777,127 $1,487,613 $2,751,671 $4,146,631 years production capacity (hrs) Units production (kWh) 30MW = 30000 KW unit selling price years Revenue COGS Gross profit Operationg expenses: Fixed cost: Wages (Manager) Depreciation Interest fee Total Fixed cost 0 Maintenance and utilities 0 Insurance 0 Varible cost: wages (Labours) yr1 0 Subscription and renewals 0 Marketing and advertising 0 Safety certificate 0 Consumables Maintenance Total Variable cost 0 Total expenses Net profit before tax Loss caryforward Tax 30% Net profit after tax yr1 0 0 0 0 0 0 0 0 0 0 yr2 2000 60,000,000 $0.150 yr2 $9,000,000 $5,130,000 $3,870,000 $80,000 $200,000 $25,000 $542 $50,000 $5,000 $800,000 $1,300,000 $2,460,542 $200,000 $300,000 $1,000,000 $1,500,000 $3,960,542 -$90,542 -$90,542 yr3 4000 yr4 5000 yr5 6000 120,000,000 150,000,000 180,000,000 $0.154 yr3 $0.158 yr4 $18,480,000 $23,700,000 $29,160,000 $10,533,600 $13,509,000 $16,621,200 $7,946,400 $10,191,000 $12,538,800 $0.162 yr5 $160,000 $160,000 $160,000 $400,000 $400,000 $400,000 $50,000 $50,000 $50,000 $42 $42 $42 $50,000 $50,000 $0 $0 $600,000 $500,000 $600,000 $1,600,000 $1,600,000 $1,600,000 $1,300,000 $1,300,000 $1,300,000 $3,560,042 $3,560,042 $3,565,042 $50,000 $5,000 $800,000 $1,000,000 $650,000 $1,400,000 $3,050,000 $1,200,000 $1,300,000 $2,300,000 $2,700,000 $5,860,042 $6,260,042 $6,615,042 $2,086,358 $3,930,958 $5,923,758 -$90,542 $598,745 $1,179,287 $1,777,127 $1,487,613 $2,751,671 $4,146,631