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

Explain the term - federal income tax, Federal income tax Except specif...

Federal income tax Except specifically exempted, all income (illegal and legal) is subject to personal income tax. Withholding depends on 1) employee's gross earnings, 2) emplo

The total assets of capp co. are $600, The total assets of Capp Co. are $60...

The total assets of Capp Co. are $600,000 and its liabilities are equal to two-thirds of its total assets. What is the amount of Capp Co.'s owner's equity?

Liquidity ratios (short term solvency ratios), Liquidity Ratios (Short Term...

Liquidity Ratios (Short Term Solvency Ratios):   These Ratios calculate the capability of the firm to meet its current obligations. They point out whether the firm has enough li

Which brand insulating oil tester is the best, GDYJ-503 is developed accord...

GDYJ-503 is developed according to the national standard GB-86 Insulating Oil Dielectric Strength Testing Method .The tester can test three cups of oil at the similar time. LCD scr

Example of accumulated depreciation account, Q. Example of Accumulated Depr...

Q. Example of Accumulated Depreciation account? Along with other items the trial balance of Korman Company for 2010 December 31 includes the following account balances

Balance Sheet Classifications and Relationships, Balance Sheet Classi?catio...

Balance Sheet Classi?cations and Relationships Shelley and Co. has the following balance sheet elements as of December 31, 2012. Land. . . . . . . . . . . . . . . . . . . . . . . $

Determine about the purchasing procedures, Determine the Purchasing Procedu...

Determine the Purchasing Procedures Alarge company would use a "purchasing agent" who heads purchasing department. Small companies would use manager/owner, etc. Seller recei

Advantages and disadvantages of lifo, Q. Advantages and Disadvantages of LI...

Q. Advantages and Disadvantages of LIFO? LIFO: Advantages (a) LIFO reports both sales revenue and cost of goods sold in current dollars and (b) lower income taxes result if use

Accounts for managers, 1. From the following information, prepare a Balance...

1. From the following information, prepare a Balance Sheet showing the workings: 1. Working Capital ` 75,000 2. Reserves and Surplus ` 1,00,000 3. Bank Overdraft ` 60,000 4. Curren

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

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