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

A firm has $200, A firm has $200,000 in total assets and $120,000 in owner'...

A firm has $200,000 in total assets and $120,000 in owner's equity. What are the total liabilities? A. $80,000 B. $200,000 C. $320,000 D. Cannot be determined from the info

Computerised accounting systems, The organization's name is Coffee Affectio...

The organization's name is Coffee Affectionardo Pty Ltd and the company imports and sell various  types  of coffee  machines, grinders,  filters and beans. The business has two dir

Describe about ledger, Q. Describe about ledger? A ledger (general ledg...

Q. Describe about ledger? A ledger (general ledger) is the absolute collection of all the accounts of a company. The ledgers are feasibly in a bound volume in, loose-leaf form

Why justin maul wasn''t concerned, Kim presently owns a business that proce...

Kim presently owns a business that processes and distributes fresh vegetable to local supermarkets. She is looking to expand her business by acquiring the Lackawaxen Emu Oil Compan

Adjusting entries. you have been retained to examine, Adjusting entries. Yo...

Adjusting entries. You have been retained to examine the records of Kathy's Day Care Center as of December 31, 20X3, the close of the current reporting period. In the course o

Internal control devices for banking activities, Internal control devices f...

Internal control devices for banking activities include signature cards, deposit tickets, checks, and bank statements. 01.) True 02.) False True or False?

Explain the term- reversing entries and interim statements, Explain the ter...

Explain the term- Reversing entries and Interim statements Reversing entries - Made the first day of new accounting period. They are exact opposite of the adjusting entries

Explain about accrual basis and periodicity, Q. Explain about Accrual basis...

Q. Explain about Accrual basis and periodicity? Accrual basis and periodicity demonstrated that financial statements more accurately reflect the financial status and operations

Explain about purchase discounts, Q. Explain about Purchase discounts? ...

Q. Explain about Purchase discounts? Purchase discounts frequently companies purchase merchandise under credit terms that permit them to deduct a stated cash discount if they p

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