This video deserves WAY more views and attention!! This is exactly what I've been searching for I started as a solo operation this past year and just completely changed the way I thought about business for 2018 and this video has helped me understand business way more! I would definitely used this software or even buy it because it brings some sick value!! Thank You for the upload 😊👊
@PHCCEducationalFoundation
6 жыл бұрын
Thanks, glad it helped! This software is now available at no charge to contractors by request - just e-mail us at foundation@naphcc.org.
@scotolivera8207
3 жыл бұрын
@@PHCCEducationalFoundation thanks for the video, still the software free of charge ?
@PHCCEducationalFoundation
3 жыл бұрын
@@scotolivera8207 Yes, a sponsorship from A.O. Smith allows us to give it away at no cost. Check your gmail!
@mohammedaymanhammad6696
3 жыл бұрын
@@PHCCEducationalFoundation could i have the excel sheet
@PHCCEducationalFoundation
3 жыл бұрын
@@mohammedaymanhammad6696 Yes, just visit phccfoundation.org/overhead to download it.
@moshesherlocksecurity3186
2 жыл бұрын
WOW! Great presentation!! Thank you!
@easyezd
3 жыл бұрын
This is great content!! You have done well organizing it and addressing the point!
@PHCCEducationalFoundation
3 жыл бұрын
Thank you Ermias!
@shanewilliams2330
Жыл бұрын
Im watching this for the first time, very helpful
@teresagentry2253
Жыл бұрын
Finally in English!!! Thank you
@irstaxcollector
8 ай бұрын
I agree that a business should not rely on material mark-ups to recoup lost revenue, but a business should still markup material. I don't care if the customer looks up the price of the material and tries to argue about the price, I just tell them that this is the amount I am charging for the material. If you don't want to pay, I'll cut it out. I should add, the material I use comes at the end like the labor. We won't know what material we have to use till we get there and already use it.
@scottaussem1771
2 жыл бұрын
Every year we used to change our overhead numbers we also used a sliding scale smaller jobs had larger overhead and profit as a genersl rule most jobs had a5% profit if we were busy we might lower OH&P it was better to keep our employees working than have to lay them off snd lose them
@Brandon-ko3rf
23 күн бұрын
Why are the office staff [x3 ppl] lumped into Field Staff [x 5 ppl] hours when calculating Billable Hour? Surely that should be different as they work different hours?
@PHCCEducationalFoundation
20 күн бұрын
They do work different hours, but the company's costs for all employees only gets paid by customers via field staff billable hours. So all costs - office staff, field staff and overhead must be recovered in those billable hours.
@mohannadhalaweh8939
3 жыл бұрын
Hi Thank you for the spreadsheet! It helped me tremulously! What you got going is amazing! I do have a question: I've calculated my billable charge and it came to $204.91 per hour. Is this per employee an hour or for my 5 crew including the owners which is the total of 5 guys total? If you have any email I can reach out that would be great. Thank you!
@PHCCEducationalFoundation
3 жыл бұрын
Got your e-mail - The billable hour charge on the Step 3 worksheet, cell E13 - This number is for each field employee hour spent working on the customer's project. If you have a two-person crew, then the hourly rate to charge is this times 2 for the hours they are doing billable work on the job site. For your 5 person crew, that means $1,024.55 an hour being billed while your crew is in the customer’s home. It should not include any office staff/company owner if they are not at the customer’s site doing the install work. I don’t know the cabinetry field, so I can’t say if that is high or low - but if all your cost inputs have been done right, then that number is what your company needs to charge to make back your cost + the profit % you entered. If that seems really off, then a conversation with your accountant or CPA would be helpful.
@eahteshamsharker931
3 жыл бұрын
@@PHCCEducationalFoundation Please send me the sheet
@CARLOSGONZALEZ-kq1od
Жыл бұрын
what if you own your equipment. how you charge it? (same as a rental store will charge?)
@PHCCEducationalFoundation
Жыл бұрын
Hi Carlos - You buy the equipment you need and then have customers pay for that equipment over the expected useful life of that equipment. There are set accounting rules on how to handle that. In the software, there is a line item on Step 2 of the spreadsheet for Equipment Depreciation. Do a search for capitalization of expenses and depreciation or talk with your accountant to learn more about that.
@CARLOSGONZALEZ-kq1od
Жыл бұрын
@@PHCCEducationalFoundation THANK YOU Trying to lower my overhead to be more competitive. Have older equipment that still use in the field not sure to input it. to lower my overhead
@alirajeh7610
2 жыл бұрын
Thanks
@rogerl8488
8 ай бұрын
Hi havent watch video yet but does this work for every business even down to lawn care?
@PHCCEducationalFoundation
8 ай бұрын
Roger - it should work for most small businesses that operate on a time & material charging basis. If you are charging customers on flat rate/per visit basis, it will take additional work beyond the scope of these spreadsheets to determine what those charges should be. There are many flat rate calculators available for sale from others.
@marknasri3490
4 жыл бұрын
thank you, great video. does quick book has such capability to do the above calculation? thanks
@PHCCEducationalFoundation
4 жыл бұрын
Thanks Mark. Sorry, I don't know if Quickbooks does these calculations.
@marknasri3490
4 жыл бұрын
@@PHCCEducationalFoundation, thanks for the reply
@shadyrrastubbs6978
Жыл бұрын
How many customers do I need? Billable hours is this for the tech out on the field?
@PHCCEducationalFoundation
Жыл бұрын
Hi Shadyrra, the software is built on what percentage of their time technicians are doing billable work - which is related to how many customers you have to keep them busy doing that billable work. The number of customers that takes depends on your unique situation. Billable hours - yes - this is for the techs out in the field while they are doing work that can be charged to a customer.
@marlynbrown5716
Жыл бұрын
In Step 2 (Overhead), In The "Cost As A % Of Sales Revenue" Column, It Stays At 0.0% Although The Other Overhead Numbers Are Entered. Am I Missing Something Perhaps From Another Column Or Something?
@PHCCEducationalFoundation
Жыл бұрын
Marlyn, Hard to say without seeing what you have entered in the worksheets. Best guess is that field employee hours (billable time) have not been allocated in Step 1, which would allow the spreadsheet to calculate sales revenue.
@marlynbrown5716
Жыл бұрын
@PHCC Educational Foundation I figured it out. I ended up erasing all the numbers and starting over from scratch. Works like a charm. Thanks
@b2bcontrolinc353
4 жыл бұрын
Thank you for your hard work! By the way , what is the password to un protect workbook?
@PHCCEducationalFoundation
4 жыл бұрын
Thank you! Sorry, we cannot provide the unlock password. The cells on the spreadsheet are locked to protect the integrity of the formulas and to prevent others from copying these sheets to try to sell for a profit - we make them available for free. Thanks for your understanding.
@Chaserz1
6 жыл бұрын
Is there anyway I can get this software? I found extremely helpful and would like to use it.
@PHCCEducationalFoundation
6 жыл бұрын
This software is now available at no charge to contractors by request - just e-mail us at foundation@naphcc.org.
@Chaserz1
6 жыл бұрын
Ok I sent an email over. Thanks
@MD-eg3zh
6 жыл бұрын
Thank you! I got it. Already deleted the comment. tks.
@Chaserz1
6 жыл бұрын
I dont believe I ever recieved the workbook. I check all my email folders.
@jonathanlogan709
9 жыл бұрын
Hey...what software are you talking about?
@PHCCEducationalFoundation
9 жыл бұрын
Jonathan Logan It's the PHCC Overhead & Profit Calculator - phccfoundation.org/overhead
@olennatos8850
4 жыл бұрын
Do we still need to add the amount of the non billable hours? Otherwise, the more non billable hour, the more amount will be charged to customer.
@PHCCEducationalFoundation
4 жыл бұрын
You must recover the costs of all staff time proportionately in what is being charged to each customer. So the expense of those hours that are not directly attributable to a job (non-productive tech time & the office staff) must be recovered in the billable hours that are charged to customers. Customers are not paying for just a technician, they are hiring your whole company to get a job done - including all of its resources.
@eallen5562
6 ай бұрын
Is this software still available?
@eallen5562
6 ай бұрын
@@PHCCEducationalFoundationwhat if the employee has to work on holidays such as a pianist or organist playing in a religious setting.
@vinniev451
3 жыл бұрын
Could you use this for Pest Control Company?
@PHCCEducationalFoundation
3 жыл бұрын
Vinnie, it was designed with residential service & repair plumbing companies in mind, but should work ok with other trades that follow a similar operation style. It's free to use, so give it a try! Visit phccfoundation.org/overhead to download it.
@jmac213stuff
2 жыл бұрын
Are the power point sheets also available for download?
@PHCCEducationalFoundation
2 жыл бұрын
Jose - the Excel spreadsheets are available at no charge, visit phccfoundation.org/overhead. The PowerPoint is not available except for PHCC chapters who wish to use them for a chapter meeting educational event.
@rmsaccounts5884
Жыл бұрын
how may I get this Worksheet ?? Help me plz
@PHCCEducationalFoundation
Жыл бұрын
Hi, you can grab the PHCC Overhead & Profit Calculator here - phccfoundation.org/overhead
@truthseeker771
Жыл бұрын
17,000 per month
@alirajeh7610
2 жыл бұрын
I need password to open the file Its protected i can't open it
@PHCCEducationalFoundation
2 жыл бұрын
Ali - We keep the formulas locked for two reasons - it prevents people from accidentally editing a formula that breaks the worksheets and to help prevent others from copying the work and then reselling it when we are giving it away for free to help our industry. The unlocked areas of the sheets are where all data entries should be made.
@Smokeslingerowner
11 ай бұрын
I guessed 115/ hour at the beginning of the video.
@eduardoartiaga4825
Жыл бұрын
can i get the powerpoint
@PHCCEducationalFoundation
Жыл бұрын
Eduardo - Unfortunately, the PowerPoint is not available to share.
@eduardoartiaga5158
Жыл бұрын
How can we purchase or get more information.
@PHCCEducationalFoundation
Жыл бұрын
@@eduardoartiaga5158 If you want the spreadsheets, you can download the Excel file at no cost here: www.phccfoundation.org/foundation/phcc-overhead-profit-calculator/
@madra000
Жыл бұрын
why would you not just lower your salary and your taxes as well?
@mcruz4467
2 жыл бұрын
1700
@ssg8161
7 жыл бұрын
about 20 min of value and 40 min of selling there software
@PHCCEducationalFoundation
7 жыл бұрын
Samantha - We absolutely want people to use software (ours or anyone else's) to help them calculate their real costs and proper selling price so they can run a successful company. BTW, this software is now available at no charge by request - just e-mail us at foundation@naphcc.org.
Пікірлер: 73