Calculate breakeven analysis, Accounting Basics

Assignment Help:

Breakeven Analysis - I really need help calculating this.

Our company's breakeven point occurs after the agency consecutively yields two months of positive net income. This actually occurs in in November of Year 1. However, this is predicted to be followed by a series of losses during the proceeding two years of operations. It will not be until the second half of the third year that Six-Star Global will start to show a profit again. Subsequently, during the 3rd quarter, the company will actually breakeven (i.e. our expenses and revenues will equal). For both the third and fourth quarter of year 3, the company is once again expected to have a positive net income.

Budget Project Notes

1.      Inside sales workers can process at least one sale every 30 min. Another inside sales representative is needed for every 15 deals completed during their shift.  The marketing/sales manager can close extra deals that the representatives cannot cover, if needed.

2.      Median salary for an inside sales representative in Mesa, AZ is $34,753 (Salary.com, 2011).

3.      Median salary for marketing manager in Mesa, AZ is $85,405 (Salary.com, 2011).

4.      Median salary for administrative assistant in Mesa, AZ is $35,563 (Salary.com, 2011).

5.     Mesa office space ranging from $8/sq. ft. - $18/sq. ft. per year, depending upon the location. Our 2100 sq. ft. agency location is listed as $8/sq. ft. per year with first 5 months lease  (AZofficespace.com, 2011).

6.      Straight line depreciation is used with our office furniture over 5 years.

7.      Number of Baby Boomers in the US is approximately 26% of the US population (i.e.78 million people). Of that number, 86% were born in the US and 14% are immigrants (Jones, 2010).

8.      Mesa, AZ is in one of the top five counties with the most baby boomers (Jones, 2010).

9.      Our company will not have any real tangible assets to borrow against as collateral. Our funding will come from investors that will receive company stock in return. We will require $750,000 to launch the company and an additional $400,000 each year for continuing our operations. Most of those funds will be invested in marketing for the agency, as well as the normal operations in the business. Overall, marketing and payroll will consistently be our biggest expense.

10.  Cost of computer is based off of prices found on dell.com and other online retailing computer stores.  The costs of the desk and computer chairs are estimates based on IKEA.com. 

11.  The cost of the all-in-one printer is based off of pricing found on Amazon.com.  A very nice efficient laser all-in-one printer can be purchased for under $1,000.

12.  The office supplies include items like pens, notepads, printer ink, etc.  The food and beverages will be purchased at a warehouse store like Costco or Sams Club to benefit from the bulk discount.

13.  The sales budget is very conservative looking to grab less than 5 thousandths of 1% of the total US market share for specific procedures we are specializing in.  Out of the approximate 279 million procedures that are performed in the US each year we hope to capture just over 1,000 of those by the end of year 1 and just over 2,500 by the end of year 3.  Six Star Global Healthcare Solutions will invest heavily into marketing.  We are projecting our sales to increase by 50% each year and to continue on that exponential growth for the first 5 - 7 years after which will begin to level off to normal growth. 

14.  Cost of travel is based off of estimates from costhelper.com, expedia.com, and travelabroad.com.  They an approximation based on hotel and rental rates found on these websites.

15.  The sales budget costs are broken down as follows:

Cosmetic Procedure

US Cost

Costs Abroad

Breast Enlargement

$7,613

$2,500

Breast Reduction

$8,881

$2,011

Breast Uplift

$2,422

$686

Buttock Lift Costs

$7,788

$1,905

Cheek Implant

$5,731

$1,405

Upper Eyelid

$4,769

$805

Facelift

$11,813

$2,345

Liposuction

$5,250

$1,155

Tummy Tuck

$8,418

$1,905

Nose Reconstruction

$6,125

$1,461

Elective Procedure

 

 

Total Knee Replacement

$35,000

$6,300

Carpel Tunnel Release

$2,500

$1,100

Hip Replacement

$39,299

$5,075

 

Dental Procedure

US Cost

Abroad Cost

Porcelain Bonded Crowns

$900

$130

Gold Crowns

$1,000

$214

Full Acrylic Dentures

$1,150

$267

Inlays

$900

$206

Root Canal

$600

$68

Veneers

$1,150

$204

Tooth Whitening Procedures

$500

$156

The following are references that were used in calculating the cost of the procedures as well and the number of procedures that would be performed in the US.

16.  Dental Costs found in Six Star Budget (Medical Staff Writers, 2008).

17.  Hip replacements increased 37% and knee replacements increased 53% in 2004 compared with 2000 (Stacy, 2008).

18.  Hip and knee replacement increased significantly among those aged 45-64 (Stacy, 2008). 

19.  By 2015 there will be an estimated 600,000 hip replacements and 1.4 million knee replacements (Stacy, 2008).

20.  There were 12.5 million cosmetic plastic surgery procedures performed in the US in 2009 (ASPA, 2010).

21.  The cost of a total knee replacement is ~$35,000.


Related Discussions:- Calculate breakeven analysis

Sales returns affect both revenues and cost of good, Q. Sales returns affec...

Q. Sales returns affect both revenues and cost of good? When a company sells merchandise to customers then it transfers the cost of the merchandise from an asset account that i

calculate wacc and rate of return, Calculate WACC and Rate of Return ...

Calculate WACC and Rate of Return Capital Structure: 50% debt and 50% equity financing Current cost of debt is 2% above prime (Prime is currently 2.5%) cost of equity is e

Define expenses in terms of accounting, Q. Define Expenses in terms of acco...

Q. Define Expenses in terms of accounting? Expenses are outflows or else other using up of assets or incurrence of liabilities (or a combination of both) from rendering service

Adjustments for financial reporting, Adjustments for financial reporting ...

Adjustments for financial reporting - Explain the basic characteristics of the cash basis and the accrual basis of accounting. - Recognize the reasons why adjusting entries

LAW OF PERSONS, discuss the features of unincoporated associations

discuss the features of unincoporated associations

Explain about traditional accounting theory, Q. Explain about Traditional a...

Q. Explain about Traditional accounting theory? Conventional accounting theory consists of underlying assumptions rules of measurement major principles and modifying convention

What is the typical time span for long-range plans?, What is the typical ti...

What is the typical time span for long-range plans? A. More than 1 year C. 3-5 years B. 2-3 years D. About 25 years

What is consistency, Q. What is Consistency? Consistency in general req...

Q. What is Consistency? Consistency in general requires that a company use the same accounting principles and reporting practices through time. This concept disallows indiscrim

Retained earnings account, Closing entries perhaps prepared directly from t...

Closing entries perhaps prepared directly from the work sheet. The first journal entry debits all items appearing in the Income Statement credit column as well as credits Income Su

Explain in brief about the purchases account, Explain in brief about the pu...

Explain in brief about the purchases account  keeps a record of cost of merchandise purchased for resale during an accounting period. Assets are recorded as assets-not pu

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd