![]() |
how do i work out what price to charge
i am a nail technician, and would like help with working out what i spend
every month( on supplies e.g nails, nail polish , nail polish remover, fuel( car) , etc etc ), then be able to have a total figure at the end where i charge for a certain job, i.e french nails $30... by being able to work out how much im spending a month, compared to how much im earning... i'll soon realise whether or not im under charging myself look forward to your response kind regards |
Good questions. You could start with a simple table, say with 5
columns: Date, Category, Description, Expense, Revenue. Each entry will have a date, category, and description, and an amount in either the Expense or Revenue column. Date Category Description Expense Revenue 3/1/05 Indirect Polish Remover 2.50 .... 3/3/05 Direct Nails 4.50 3/3/05 French Nails New customer 20 mi. drive 30.00 ... 3/5/05 Indirect Gas 24.45 .... 3/10/05 Overhead Business cards 40.00 Now, whenever you want, total up the Expense column and the Revenue column and you'll know how you are doing. What you can charge for a service depends less on your expenses and more on the competition. You can use the Category column to further refine your analysis. I would keep it as simple as possible. As you become more familiar with the analysis and if you perceive a need for it, add more bells and whistles. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... i am a nail technician, and would like help with working out what i spend every month( on supplies e.g nails, nail polish , nail polish remover, fuel( car) , etc etc ), then be able to have a total figure at the end where i charge for a certain job, i.e french nails $30... by being able to work out how much im spending a month, compared to how much im earning... i'll soon realise whether or not im under charging myself look forward to your response kind regards |
All times are GMT +1. The time now is 08:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com