Can someone create a spreadsheet for breakeven/ profit analysis

[ccoaston]

Can someone create a spreadsheet for me so i can figure out a profit/break even analysis. I want to know how many of what packages I need to sell to break even and make profit. I have all my details here. I just can't find a spreadsheet that has a format I can put my specific info in.

Pay per ticket Price - $85.00 / 3.50per mile for travel based on google maps
All packages include Startup dvd for tech support
--------------------------------------------------------------------------
Silver
Standard windows/Mac updates
Free from any virus, adware, spyware check
Make sure windows is running optimal (Defragmentation, cleaning cookies, temp)
Consulting
Troubleshooting software issues (no printers)*
Malewarebytes retail 1/yr - $24.99 value
Weekly Report (sent to email)*

3 months - $150

6 months - $250

12 months - $450

==========================================================
Gold -
Standard windows/Mac updates
Free from any virus, adware, spyware check
Make sure windows is running optimal (Defragmentation, cleaning cookies, temp)
Consulting
Troubleshooting software issues (no printers)
Weekly Report (sent to email)
Malewarebytes retail 1/yr - $24.99
Training*
On-site repair (local only) other fees may apply such as transport/parts*
Additional software updates*
Data Backup Service (Carbinite) Optional*

6 months - $450

12 months - $650
-------------------------------------------------------------------------
Expenses

Rent - $500

Internet - $80

hosting - 7.99

Utilities - $150

Attached to packages Software- $24.99

Attached to package- Backup with carbinite- $59.99 per year

 

[Kitten Kong]

I can quickly throw something together for you, but to be honest, its a pretty straifhtforward calculation, you should be able to do it yourself.

Couple quick questions.

Thats it for overheads?.

I can think of a lot more youve not considered.

Your only doing 2 plans?
And your charging mileage on top of your plans?. I oersonally think thats a no no..

 

[ccoaston]

I would greatly appreciate it if you can whip something up. When it comes to this i get brain dead unless someone is near me helping me organize and put in the formulas. Before we had a bronze plan but it just got confusing, so we took it out. As for the mileage..this has been on my mind all night on rather we should keep it or not. We can actually do away with it for the packages. However for the pay per ticket price they would have to pay for millage.

The utilities I have are the only ones I can really think of. We have all the tools and hardware we need.

 

[ccoaston]

Do you think we should have like a month to month rec-curing plan that they can drop when ever they fee? Not locked in?

 

[Kitten Kong]

Ill put something together for you later.

Things i think your 'missing' with your overheads are:

Petrol, motoring fees, servicing
Advertising
Promotions
Stationary
Printing
Postage
Bank charges
Bank interest charges
Credit card charges
Do you have a card terminal?. Their fees.
Wages, you and staff
Sickness
Cell phone
Tax
Accountants fees
Legal fees
Pensions

Thats just off the top of my head.

Without you listing every single overhead, and OVER budgeting for them, id be wasting my time doing the ss.

 

[Kitten Kong]

Do you think we should have like a month to month rec-curing plan that they can drop when ever they fee? Not locked in?

I cant answer this for you. This should be in your business plan already. Not something which your thinking of just now.

 

[Martyn]

Moved discussion about turnover etc to TEO

http://www.technibble.com/forums/showthread.php?t=58432

 

[PCSupportGlasgow]

Breakeven point is a standard financial procedure and no different because we are IT companies.

No use reinventing the wheel as there is thousands of them on google and even loads of boring lectures on them.

 

[frederick]

see if this helps you out. we put this together awhile back, and used it as a mid point for PCRT and Quickbooks. We've since then modified PCRT to just integrate into QB for us.

 

[Kitten Kong]

Good Spreadsheet there Fred. Good for any business, not just techs.

Course it only works, if people inputting the figures knows which row to put them in. And I think it would be surprising to some exactly what constitutes overheads/expenses

 

[frederick]

Good Spreadsheet there Fred. Good for any business, not just techs.

Course it only works, if people inputting the figures knows which row to put them in. And I think it would be surprising to some exactly what constitutes overheads/expenses

Getting there. Gradually increasing what's in my post. I'm working towards breaking it down even further, and further. Really help those who are new, those who are clueless, and those who think they got it all handled. Even I can say we still don't have it all handled. That's why having a CPA is so important in my eyes. He breaks it down barney style to wife, who breaks it down retard style to me.

 

[ccoaston]

Truthfully, we are just doing this from home to start off. We use square to accept payments (2.5%) charge, and the only overhead really are utilities we use at home. We want the business to really be 85% remote management and troubleshooting and the other travel, if need be. I'm not looking to do it the traditional way and getting a store front like some. Printing and buying postage will be used very rarely, the start-up cost of things are already taken care of (business LLC registration, registered agent, paid for 2 years insurance, registered with the BBB, Dun and brad, tools, software etc). Our accounting service will be used by quickbooks. For advertising we are using facebook with well connected folks, craigslist, and person to person, business to business, organization connections and churches and other services such as thumbtack. We want to keep the expenses as low as possible only the essentials to start. Doesn't make sense to get store space. Its just a colleague and I doing our day jobs and working our dream at night until this becomes clear. WE JUST WANT TO KNOW IS IT WORTH STARTING A BUSINESS SUCH AS THIS ONE BEFORE WE PULL IN POTENTIAL CUSTOMERS. For example what would we have to sell a month that makes sense to compare to both of our salaries. Both of us make about $2400 a month after taxes at our slave jobs. Or if we just made to at-least one of salaries a month

**we were a straight forward computer repair business before**

Ill put something together for you later.

Things i think your 'missing' with your overheads are:

Petrol, motoring fees, servicing
Advertising
Promotions
Stationary
Printing
Postage
Bank charges
Bank interest charges
Credit card charges
Do you have a card terminal?. Their fees.
Wages, you and staff
Sickness
Cell phone
Tax
Accountants fees
Legal fees
Pensions

Thats just off the top of my head.

Without you listing every single overhead, and OVER budgeting for them, id be wasting my time doing the ss.

 

[frederick]

Truthfully, we are just doing this from home to start off. We use square to accept payments (2.5%) charge, and the only overhead really are utilities we use at home. We want the business to really be 85% remote management and troubleshooting and the other travel, if need be. I'm not looking to do it the traditional way and getting a store front like some. Printing and buying postage will be used very rarely, the start-up cost of things are already taken care of (business LLC registration, registered agent, paid for 2 years insurance, registered with the BBB, Dun and brad, tools, software etc). Our accounting service will be used by quickbooks. For advertising we are using facebook with well connected folks, craigslist, and person to person, business to business, organization connections and churches and other services such as thumbtack. We want to keep the expenses as low as possible only the essentials to start. Doesn't make sense to get store space. Its just a colleague and I doing our day jobs and working our dream at night until this becomes clear. WE JUST WANT TO KNOW IS IT WORTH STARTING A BUSINESS SUCH AS THIS ONE BEFORE WE PULL IN POTENTIAL CUSTOMERS. For example what would we have to sell a month that makes sense to compare to both of our salaries. Both of us make about $2400 a month after taxes at our slave jobs. Or if we just made to at-least one of salaries a month

**we were a straight forward computer repair business before**

Seriously, look at my thread on how to do up your rates. That will help you out so much to figure out what all it is going to take. Use the spread sheet I loaded up to see how things are getting divided up. If you really look at the graph on the first page, it'll show you a month-to-month comparison of your expenses and incomes.

 

[ccoaston]

Thank you so much!