0 0
Browse > Bookkeeping, Accounting and Tax > Budgeting Worksheets and Calculators > Healthcare

Healthcare Services Break Even Analysis Worksheet

ABOUT THIS DOCUMENT

A healthcare services company can use this template spreadsheet to perform a break-even analysis. A break-even analysis is one form of cost analysis; it is used to calculate the margin of revenues needed to exceed a company's break-even point - the point at which revenues equal the costs associated with producing that revenue. This supply side metric can be used by managers to help understand the relationships between sales, costs, and profits. A break-even analysis can be helpful to companies trying to analyze revenue margins for certain products or services, adjust pricing schemes, or set sales targets.

Reads: 271 times
Used: 17 times
Pages: 1
Size: 28 kb
Format: Excel Spreadsheet

Text Version

BREAK EVEN POINT ANALYSIS

BREAK EVEN UNITS FOR THE YEAR

Break even point Analysis Total Units 1200

For the year Total Revenues 24000



Jan-11 Contribution margin 21600

Total Fixed Cost 10800

Selling price per unit 20 600

BREAK EVEN UNITS FOR THE YEAR



Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11

Number Of Units Sold 100 100 100 100 100 100 100 100 100 100 100 100

TOTAL REVENUES 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000 2000





Variable Cost

Materials 200 200 200 200 200 200 200 200 200 200 200 200

Direct Labor

Indirect Labor

Utilities

Insurance

Taxes

Telephone

Accounting and legal

Advertising

Repairs and maintainer

Misc expense





TOTAL VARIABLE COST 200 200 200 200 200 200 200 200 200 200 200 200



CONTRIBUTION MARGIN 1800 1800 1800 1800 1800 1800 1800 1800 1800 1800 1800 1800



Fixed Cost

Rent 900 900 900 900 900 900 900 900 900 900 900 900

Office and Administrative salaries

Other Fixed Cost





TOTAL FIXED COST 900 900 900 900 900 900 900 900 900 900 900 900



BREAK EVEN UNITS 50 50 50 50 50 50 50 50 50 50 50 50

THIS DOCUMENT IS BEST FOR

Category:

Bookkeeping, Accounting and Tax


Sub-Category:

Budgeting Worksheets and Calculators


Industry:

Healthcare


Region:

United States - Any State


Get Unlimited Access to Our Complete Business Library

Plus

  • All Licenses and Permits For Your Business
  • Customized Legal and Business Forms and Agreements
  • Document Packages for Specific Situations
Learn More »

Document Recommendations

Sign-up for Docstoc Premium
X
Registration enables you to experience on site recommendations of documents, articles, packages and courses as well as recommendation emails for the content we think you'll love the most
Already a member?
Don't have a Facebook account?
Register with E-mail

Enter a valid email address (xxx@xxx.com)
Preloader
By registering with docstoc.com you agree to
our privacy policy and terms of service
Sign-in
X
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Forgot Password?
X
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Don't have a Facebook account?
Login with your Docstoc account.

Email or Username

Preloader

1. Please rate your experience on the following scale:


2. Would you recommend Docstoc to a friend?


Submit

Would you be interested in taking a longer survey for a chance to win a 1-month free subscription to Docstoc Premium?