Profit Spreadsheet
I need a spreadsheet that I cannot alter except for defined fields for input actions only.
1) I will begin by inputting the revenue from a job, then the spreadsheet needs to subtract the “job expenses” of that job which will produce result 1A. The revenue will begin with labor, which will be a gross amount, so I will input the gross amount, then the program needs to calculate the government sales tax (GST) from that gross amount which will be preset to 5% but must be easy to change if necessary. Then the next revenue I input will be materials, and the calculator will calculate the 2 taxes, which is 5% again, and an additional 7% for Provincial Sales Tax (PST). This net amount will be result 1B.
2) Then, a number of “business expenses” will be subtracted from result 1B, which will produce result 2, the “bonus fund”
Some of these expenses are fixed and some fluctuate and I need the ability to add or delete expenses.
3) Then I need another sheet that tracks employees including myself, our rate, how many hours each of us worked in a calendar month, and the gross amount we were paid. Hours for all employees will then be totaled & then a result will be produced to provide a percentage of hours worked by each employee. So if I have 3 employees, and we worked 1000 hours in total for January, and I worked 413 hours, then I need the spreadsheet to provide the percentage, which in this case would be 41.3%… and then to provide the percentages for the other employees as well.
I need the ability to easily add or delete employees.
There are some expenses related to certain employees earnings, for example, employment insurance is $4.10/$100 of earnings for each registered employee… so I need the program to calculate this number for me and make it optional for each employee.
4) Then the spreadsheet will take result 2 “bonus fund” and multiply that by each employees percentage and produce the amount of money they would receive as a “bonus.”
A simple and easy user interface is important with summary pages.
5) Then I need another sheet… this one will take all the income I was paid (results from #3), then add the bonus on top to provide the gross income. Then it will subtract my personal expenses, taxes, debt payments, etc. and provide me with a result.
The bonuses are paid monthly, so it would be nice if the program knew that it was the start or end of the month and would automatically begin calculating everything for the next month and not add it onto the previous month.
I need to be able to create pdf format.
There is more I would like to do with the last sheet, but lets start with this… unless you have some ideas as far as the program keeping track of debt balances as I make regular payments and make extra payments.
Thanks,
Davyn
