Computing Breakven Sales

I have tried to compute the Breakeven sales for a workshop, but my answer appears to be incorrect. I have used Goal Seek in Excel and get a higher breakeven sales. I have use fixed costs/the contribution margin, to compute my breakeven sales

It would be appreciated if someone would kindly assist me so I can see where I have gone wrong. I have attached sample data

 

Attached File : 945060 20191225150550 breakeven analysis and data analysis.xlsx downloaded: 120 times
Replies (1)

 resolved my problem in computing the estimated Net Profit using data tables.

My Breakeven was 100% but I was getting an incorrect answer when computing forecasted Net Profit based on increased sales data when using a data table.

My Contribution margin was 27.1111% (GP %)

To resolve the problem regarding the incorrect forecasted net profit , I set my variable costs to be Sales * (1-0.271111) and now I get correct forecasted net profit

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
13 November 2026
Chartered Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details