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

Stocks, Please help journalize: -On January 1, 2017 Harmony issued 1,500 sh...

Please help journalize: -On January 1, 2017 Harmony issued 1,500 shares of $22 par, 8% preferred stock for $43,700. -On January 1, 2017 Harmony also issued 2,000 shares of common s

A vendor reduces an item listed at $140 on july 1st by 20%, A vendor reduce...

A vendor reduces an item listed at $140 on July 1st by 20%, and then reduces it another 25% on September 1st. What is the sale price of the good after the last reduction? A. $7

What is periodic inventory procedure, Q. What is periodic inventory procedu...

Q. What is periodic inventory procedure? In the periodic inventory procedure the Merchandise Inventory account is updated periodically subsequent to a physical count has been m

#nocluewhattodo, I need help understanding and filling out an income statem...

I need help understanding and filling out an income statement packet!

Describe the term - payroll, Describe the term in detail Payroll PAYR...

Describe the term in detail Payroll PAYROLL is very vital for all employees. Employees are under the direct control of employer on a continuing basis. An independent contract

International recommendations on how IAS 40 can be improved, I need an expe...

I need an experts advice, I''m nearly finished with my Dissertation on IAS 40 - but I need some more guidance on issues with the standard and how it can be improved

5 multiple choice questions, 1. PDQ Corp. has sales of $4,000,000; the firm...

1. PDQ Corp. has sales of $4,000,000; the firm''s cost of goods sold is $2,500,000; and its total operating expenses are $600,000. The firm''s interest expense is $250,000, and the

What is differences in access to financial information, What is differences...

What is differences in access to financial information Distinction between the two areas of accounting reflects, to some extent, differences in access to financial information.

Illustrate unearned service fees, Q. Illustrate unearned service fees? ...

Q. Illustrate unearned service fees? Micro Train reports the service income in its income statement for 2010. The company enters the USD 3000 balance in the Unearned Service Fe

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