How could i calculate a break even point for a service bussines and how could I present a graphic?
93788
My answer is based open a single employee (owner/operator) working a forty hour week. Do not change this scenario.\n\nAt this stage you need to remove all of your emotions from this business. (The banker/investor only wants facts)\n\nWhat would a fully established corporation pay you as an employee for this service. Convert salary to hourly. To help simplify this I will use $20.00 an hour.\n\nUnderstand that service is a product, and, product has a true cost. (leave any material, parts or supplies off for know.\nWhat does a twenty dollar an hour employee cost to operate. A twenty dollar an hour employee actually cost the company much more. \n\nNow the required additional cost.\n#1 The FICA tax that is removed from an employee's pay check is only half of the required tax. The company pays the other half has to be matched by the company. \n#2 Add the required workers comp insurance for this service. The rates will vary based upon the risk rating of this category of employee. New business usually pay additional, because, there is not an established annual loss ratio.\n3# Add general liability insurance. These rate are based upon the risk rating of this category of employee. New business usually pay additional, because, there is not an established annual loss ratio.\n\n4# Add two weeks paid vacation then divide by the total hours in a work year. (this is not exact because you still have to add workers comp, general liability and half FICA)\n    (2) 40 hr weeks = 80 hrs\n        80 hrs X $20.00 per hour + $1,600.00\n        $1,600.00 divide by 2080 annual hrs\n         That adds approx .77 per hour\nAdd allowed paid sick days per year. Then use the above vacation formula.\n\nThe employee above is costing you forty hours a week, but, can only produce 60%-80% that is billable. Why? Federal law requires an employer give each employee (2) 15 minute paid breaks in an (8) hour day. Drive time to and from the job or service location. There are additional adds based upon your service.\n\nWe are now at between $30 and $60 per hour.\n\nThen add additional material, parts or supplies. You are responsible for them once they are installed now they become risk, so, you have to add mark up. Dou you have to pick them up. There goes additional production time loss.\n\nThe above can be separated between job cost and overhead. \nIf you work 30 of the 40 hour work week at Mr. Jones (customer)location. This should be applied to an accounting created file or job for Mr. Jones. This is not overhead. The additional 10 hours will go to overhead. If this were reversed. 30 hrs goes to overhead 10 hrs to job cost. Overhead is a killer. \n\nNow we need to add more overhead. Do you need phones, paper, lights, marketing, interest on a start up loan, someone to do your day to day accounting (Remember, this is based upon a single owner/operator company)so you outsource this (overhead) do it yourself (then you have to modify everything above because somewhere in your forty hour week you have change your hourly rate, workers comp rate and general liability rate to meet there going rate and cost), I would recommend out source at first. You are usually a bigger asset to the company doing what you know. \n\nNow it is time to remove you as the employee and you back in as the owner. This is why you started this. The owner has to be paid. Why go through all the above if you could make the same pay with 1/10th of the stress working for someone else. If you have a bank/investor, he wants to see you take reduced pay until you show a move from the red to the black. He will see the reduced pay as you taking on some of the risk. If you take 0 pay it will alarm him. He knows and understands everything involved above. This will give him the impression that you are not 100% confident in your plan. \n\nThen what is the most important thing of all is profit. Everything above is job cost or overhead. Profit is what this is about. If you have a great business and a great product,
800542
You could use GetTickCount\n\n'Put this in a module\nDeclare Function GetTickCount Lib "kernel32" () As Long\n\n'Use something like this in a form\nDim starttime As Long\nDim endtime As Long\n\nPrivate Sub CommandButton1_Click()\n\nstarttime = GetTickCount()\nEnd Sub\n\nPrivate Sub CommandButton2_Click()\nendtime = GetTickCount()\n\nMsgBox (endtime - starttime) / 1000 & " secs"\n\nEnd Sub
808727
I hope that you are not going to be using that specific order though!  Looks pretty comprehensive otherwise, and the only remaining answer for your two pics/graphs is: you need enough to display all your results.
354557
refer to this notes \n\nhttp://www.futureaccountant.com/process-costing/
271355
u could go to www.google.com or www.search.yahoo.com and enter figure scating and find out
739955
Try SAP BW for free here:\n\nhttp://erp.wu-wien.ac.at/sapbw/01_index.htm
362601
Get hold of suppliers and ask them for catalogs wherein they give the tables and specs.\nOther way is to procure DIN or ANSI standards references
330124
You have a point (2.25, 800) and a slope of 40/-0.25, or -160.  The slope is a rate of change - if you lost 40 customers per $0.25, then your slope is 40/-0.25.\n\nTo find the equation of the line, use the point-slope formula:\n\ny - y1 = m(x - x1)\ny - 800 = -160(x - 2.25)\ny - 800 = -160x + 360\ny = -160x + 1160\n\nThe graph will be a line starting at (0, 1160) and going down with a slope of -160.  The domain will start at 0 - since the x-axis represents money, you have to exclude negative numbers.  To find the rightmost value for the domain, find the x-intercept:\n\n0 = -160x + 1160\n160x = 1160\nx = 7.25\n\nSo your domain is [0, 7.25].  The range will be [0, 1160] - 0 for no customers, 1160 from the y-intercept.
1027614
Go to a computer service and ask there
510824
go to Switchboard.com and put in the information/location you want and see what you get
298247
Select your data. You have already entered your data, right?\n\nPull down the "insert" menu to "chart". Choose "line", choose the particular line graph you like best. Hold down the sample bar to see if the graph looks the way you expect it to. If you aren't making any changes, you can pretty much click "next" until you get a chance to click "finish".
911974
Go with a line graph, that way you can also find out (or estimate) temperatures at times when you didnt measure it.
876460
First of All, without the actual file, trouble shooting will be tough...\n\nAnyways,\nI had faced some calculation issues previously. It got solved when I created a fresh Pivot table in a new worksheet "afresh"... Though the Source data was same, the 2 PT's showed different summaries...\nTry it...\n\n\nTip / Info: \nAlso have a look at the Custom calculation of "Running Total", this can be useful for U as well...
84516
From the article "Top 10 Home Businesses with Rapid Break-Even Time" here are some businesses that you can start if you want to break-even as fast as two months to a year.  \n\nBusiness Plan Writer\nEvent or Meeting Planner\nPublic Relations\nComputer Repair\nMedical Transcriptionist   \nCarpet Cleaner\nFinancial Planner\nImage Consultant\nPersonal Chef\nReal Estate Appraiser
562618
Simply Track seems to work pretty good. It will handle wash sales correctly too. Only thing is sometimes it wont match lots correctly say if you have multiple accounts, but you can fix it easily manually. It's free for 30 days. Then if you want it to remain free, go into your BIOS when you start your computer and change the system date back a year. Shhhhhh, secret. Enjoy!
623836
Try this site: it gives a lot of information\n\nwww.commercialbreaksandbeats.co.uk
556899
An animation flash demo with stepwise calculation is given\nhttp://www.technocs.vipzone.biz