# Divide A Budget Of 100k For Each Of My Employees

Oct 23, 2009
how I would be able to divide a budget of 100k for each of my employees.

If I have employees making anywhere from 20,446.40 - 69,659.20 How can I give each employee a portion on these funds?

For example if:

Lisa makes 20,446.40

Tom - 24,448.20

Liz - 34,854.60

Mike - 44,564.80

Jan - 62,061.48

Dan - 54,324.20

What would be the precentage that I could give each employee?

View 9 Replies
ADVERTISEMENT
May 21, 2006

In the attached spreadsheet i have a budget amount, billed to date, %complete, %remaining and forecast figure. What i am trying to do is estimate the forecast spend vs the budget or billed to date and percent remaining. I am struggling with how to do this based on in some cases the budget is already overspent but the %complete is less than 100%. What i really want to do is create a forecast based on the billed to date or budget depending on which is greater and work out estimated spend based on whether the task is complete or there is still a % remaining.

View 2 Replies
View Related
Dec 17, 2013

I am trying to create a spreadsheet that will keep track of budget spent and budget remaining.

I need the values to take what is spent from expenses claim forms that are filled out,

Each budget category has a code and within that code there are sub heddings

View 2 Replies
View Related
Jan 12, 2009

We have hourly amounts remaining on projects, we want to project cost at 40 hour work weeks and 50 hour work weeks. We simply multiply the 40 hour budgets times the straight time rate, but we need to calculate the over time on the 50 hour budgets.

examples:

600 hours on 40 hour budget at $25 and hour is $15,000. However on a 50 hour budget it would include 480 straight time hours and 120 overtime hours for a budget of $16,500.

Our data is hourly bugets in column "A". In column "B" we did =A3*straighttimerate. Is there a formula that can calculate 40hrs straight time then 10hrs over time until the budget runs out? We are working with Microsoft Office Proffesional 2007 with Excel 2007 but need to remain compatible with Excel 2003.

Budget (hours)straight time ($25)over time ($37.5)240$6,000.00?4652$116,300.00?152$3,800.00?258$6,450.00?645$16,125.00?

View 9 Replies
View Related
May 18, 2009

finding a way to compare the two budgets i.e 08/09 and 09/10 and if a new cost centre appears in 09/10 it will bring a yes in column G(New cc) and if the Cost Centre already exist in 08/09 it will bring a blank--but in both cases i want a variance in the next column H i.e 09/10 less 08/09.

View 2 Replies
View Related
Jul 4, 2008

I have to run payroll every two weeks, and part of the process involves calculating overtime for over 50 employees. The total amount of overtime hours for each employee is usually split on two or three budgets and after I calculate the budget splits, I have to enter these amounts into the payroll system. (The payroll system takes up to 2 decimal spaces.)

I have a spreadsheet set up for each employee, but what I've noticed is that the sum of the parts does not always equal the whole.

For example, Bob Goodworker worked 9 hours of overtime this pay period.

His budget split will be as follows:

Budget A (58.5%) = 5.27

Budget B (31.5%) = 2.84

Budget C (10%) = 0.90

However, 5.27 + 2.84 + .90 = 9.01

The payroll system only allows for numbers up to 2 decimal places.

View 10 Replies
View Related
Mar 5, 2009

I am looking for a formula to sort out a budget problem I am currently working on... I am guessing that the formula is pretty simple but my mind is blank...

What I am trying to do is:

Cell A1 is my cash budget

Cell A3 is actual cash used

Cell A5 is The Difference between A1 & A3 (sum A1-A3)

What I want in Cell A7 is a formula to tell me if my Budget is over 50% either way..

For instance if A1 = 100 and A3 = 155 then I am 55% over and would like a note to appear saying "Explanation required".

If A1 = 100 and A3 = 45 then I am 55% under my Budget and would like a note to appear saying "Explanation required".

View 9 Replies
View Related
Mar 16, 2014

I am trying to do my homework for college and the below excel grid was given to us to complete. I do not understand where to get the information it is asking. the first grid is the numbers we are suppose to use to input in the other grids. We are suppose to put a formula in on the last to two columns on each grid but I do not even know where to start.

Budget

Actual

Product

SaleUnits

$/Unit

View 7 Replies
View Related
Aug 1, 2014

My boss has asked me to find a way to charge a mark-up on our project budgets based on a certain budget tier system ($0-1000, $1001-5000, $5001-10000, $10001+) He doesn't want a general percentage. Is there a way to do this is Excel?

He was talking about Boolean functions, but he was also used to using Logic. I do not know logic or if there is any such function within Excel.

View 2 Replies
View Related
Aug 15, 2014

Working on a Checkbook Register/Monthly Budget.In column A I have the Check # or Type of Transaction, in column D is Debit, in column F is Credit, and in column G is Balance. I am writing the Check #, Debit, Elect., or Bill in column A.What I want to do is write a formula in column H to find all the Bills in column A and add all there Debit in column D together. I don't know if I change the word Bill to a code # if that would work or not. If it does, could I use a range of number of different bills like 200-299.

Example: If (A2-A50) = "Bill" or (200-299) add the same row # in column D for a total sum.Would like to use the code # if possible so I can budget the Bills individually if possible.

Using the Formula: =IF(ISBLANK(C3),"",G2-D3+F3) in column G for Balance, don't want to mess with this formula.

View 6 Replies
View Related
Mar 19, 2014

Solution to keep track of bank transaction in a budget - both in and out

With:

=SUMPRODUCT(--(Table[[CAT]:[CAT]]=$C5);--(Month(Table[[DATE]:[DATE]])=G$3);--(Table[[IN]:[IN]]))

Table1:

DATE | CAT | IN | OUT

----------------------

The transaction CATegory and Date place the amount from table - column IN to the corresponding cell in my budget.

I would like my bank account to reflect both income an expenses from 2 columns in Table: IN and OUT

Workbook example: [URL] ...........

View 3 Replies
View Related
Aug 6, 2009

I've devised a monthly savings sheet to allow me to track my savings towards a deposit on a house. My target is £xxx a month, but as I could contribute loose amounts of money I'd like to be able to display a field next to each month of how much over I've contributed or how much under I've contributed.

I'd like this to be represented as:- If I contribute more than £xxx for a month then display it as green text and calculate how much over has been contributed.

If I contribute less than £xxx for a month then display it as red text and calculator how much under the contribution has been. I'm really not sure how to do this, I would do it manually normally but surely there is a way of automatically representing it.

View 4 Replies
View Related
Jun 19, 2008

I am trying to use excel to forecast budget expenditure for the fiscal year, using actuals from months past + unknown (future months).

I have this formula in cell G2: =IF((worksheet A!G70>0),F2,IF((B2

>D2),(B2-C2)*F6+F2,IF((B2

View 9 Replies
View Related
Oct 2, 2009

I have a couple of columns in excel and one of them " total budget" and another is "Business Case". How can I do a check on the budget, say if total budget is less than $250,000 then business case value should change to N/A.

View 9 Replies
View Related
Jul 24, 2014

So I am trying to create a budget worksheet for past and future expenses, basically an excel checkbook with running balance

In Column A I have my debits/credits

In Column B I have my running balance so that there is a current total next to each of the debit/credits in column A, it is formulated as follows, it adds the cells directly above it to the cell directly to the left of it (i.e. Cell B10 = B9+A10, which was dragged and iterated to many cells below)

I wan to be able to drag in drop cells in the A column (Just moving them up and down different cells in the A column) with out it changing formulas in the B column.

I tried the $ trick so that for example B10 = B9+$A$10 but if I moved cell A9 to say A10, I get a reference error in cell B10 (why is it doing this when B10 is locked with $)

I then tried going to format and locking the B column and not the A column and then protected the document but I still get the same REF error.

I know I can copy and paste with out effecting it but this is tedious, the whole reason I did this was so that I can move around bills EASILY and play around with what get paid when. There has to be a way to do this, but I'm probably searching with the wrong keywords.

View 1 Replies
View Related
Mar 19, 2013

I have a Master Worksheet that I am using to populate other worksheets using the Table function. I would like to keep the format the same as the Master worksheet even if lines get added or deleted. I have seen that others group the sheets together when making the changes but I can not really us that options. I will be giving the Budget to someone else to fill out and they will not know how to do that.

View 1 Replies
View Related
Jul 29, 2014

I am working towards creating a spreadsheet for making a budget for a film + a system to monitor the expenses vs budget allocated on a day to day basis (to ensure the budget is not being crossed).

View 3 Replies
View Related
Mar 16, 2014

In looking for examples of business budgets I found a sample spreadsheet that used these two conditional statements:

A) to calculate the difference between the Budget and Actual numbers: =IF(OR(B10,A1), B1-A1,) where B1 is Actual $ and A1 is the budget $.

B) to calculate the percentage (+ or -) =IF(A1,C1/A1,) where A1 is, again the budget, and C1 is the result of the difference calculated in A) above.

What is the advantage of these conditional formulas over the more straight forward B1-A1 and C1/A1

View 1 Replies
View Related
Jul 3, 2014

I am working on a budget spreadsheet and want to find a formula that will automatically tell me what my take home pay is depending on the yearly salary and see if covers my expenses (linked to another spreadsheet). It will be easier to budget my expenses depending on my salary. My attempts to create IF and = haven't worked.

View 2 Replies
View Related
Feb 5, 2007

I am having an issue creating a formula that calculates % of Budget based on signs. What I mean is positive budget, negative actual and vice versa. Here are all the cases. Can someone please create a formula that I can copy down.

Actual Plan% Budget

85,60696,85188.4%

70-82185.9%

-1,530-3,786247%

-100100-200%

View 9 Replies
View Related
May 1, 2008

I have weekly budget report (for the entire year) that I put in a Pivot Table with approx 20 different row labels. The actual revenue numbers come only once a month (several different reports make up the actual revenue numbers). I need to put the actual numbers on the same row as the budget numbers and I can't figure it out.

For example, for the first three months of the year, I have the pivot table showing everything perfectly. In February, I get January's actual revenue numbers that now "replace" the budget numbers for January. If this was a regular table, I could easily overwrite these numbers, but with the pivot table, I can't get these two fields to line up. For now, I have the Actual Revenue numbers on the Rows above the Budget numbers for their respective months/quarters.

View 6 Replies
View Related
Feb 28, 2014

I have created an monthly budget spreadsheet on excel with a calendar. Formula to show the recurring expenses in the calendar? (Example: Rent/Mortgage on the 1st of every month).

This is what I have : Monthly Budget.xlsâ€Ž

View 1 Replies
View Related
May 6, 2014

I have written a code for equal distribution of Budget Data based on condition.

The user will enter annual budget number in Column K (highlighted in Green) and based on condition in Column N (highlighted in Yellow), the data will be divided by 12 and it need to be equally distributed from Colum P to Column AA. The condition for distribution is 'Y' (Yes)/ 'N' (No).

I have also attached the sample file.Budget_Input Form.xlsm

View 2 Replies
View Related
May 6, 2014

Here's my example: We budgeted $15,000 (cell C38) for tuition reimbursement and YTD have already paid out $11,500 (cell B38).

I currently have the formula =100*B38/C38

This returns the answer $76.67. When I format the column to percentage, it the returns the answer 7666.67%.

How do I get this to read as 76.67%???

View 2 Replies
View Related
Mar 28, 2007

I am trying to create a budget in excel and want to type my numbers (in certain cells only) without a - sign but I want them to appear, and calculate, as negative numbers. Basically, I am lazy and don't want to have to remember to use a - for all of my expenses when I am inputting the data.

View 5 Replies
View Related
May 21, 2014

Fabrication and Site Visit in Budget/Spend Analysis - Budget, not pulling through information from drop down boxes - in both cost type columns (they dont seem to be active any more either, not sure what I have done there!

View 1 Replies
View Related
Jan 30, 2014

I am trying to create a document that takes our client PO amounts, tactics/spend line items, and dates from one sheet and averages them across the months that it is eligible, so we can know the total amount of money we can expect to go out from our clients each month.

For example:

Client1 Tactic1 StartDate EndDate TotalAmount

Client1 Tactic2 StartDate EndDate TotalAmount

Client1 Tactic3 StartDate EndDate TotalAmount

Client2 Tactic1 StartDate EndDate TotalAmount

Client2 Tactic2 StartDate EndDate TotalAmount

I have mostly figured this out in a really complicated way with many nested if statements, but there HAS to be a simpler way. There will be lots of hands in this document, so I would like to make it as simple and easy as possible.

View 4 Replies
View Related
May 6, 2014

Data Validation setup: "Allow" is: List "Source" is: =$E$12:$E$15

D___E____F

12__CA__CASH

13__OT__ONLINE TRANSACTION

14__DD__DIRECT DEPOSITE

15__AW__AUTOMATIC WITHDRAWAL

The codes in E column are what is entered in a worksheet range (user cannot see the list). Needed is to show both the two-character code in column E and the text definitions in column F in the dropdown. As data validation now works, users only see the two-character code and are not remembering what the code stands for - they need to see the definition.

Is there a way to show both the two-character code from column E along with the text in column F? When user selects, only the code would be entered in the target cell. (Is data validation the correct technique?)

I have set this problem up in closely located cells to construct the issue. In reality, the validation list is well off-screen from where the user is actually inserting the codes and there are many more codes/definitions.

View 3 Replies
View Related
May 19, 2014

I been working on excel sheet that will distribute 200 items between the employees that are available to work. I've attached a copy of the workbook. First I need to look at the quantity of employees I have working that day. Second Distribute the items to each one of the employees. Third give the first employee the first piece. Fourth give the next available piece to the last person with a zero piece in their list.

book8.zipâ€Ž

View 12 Replies
View Related
Sep 19, 2008

How can I protect by workbook from ex-employees and the competition from using (I am aware of the weak security measures Excel offers, but something is better than nothing)? Each worksheet is password protected to slow down novice Excel users. However, ex-employees know the password. I was thinking if there was a way to have a changing password (which only a couple people would know) or have the worksheet look for a hidden file on our network, that one of these methods (or another) might work.

View 6 Replies
View Related
Apr 17, 2009

I am creating a employee time sheet.

I am doing calculation.

I used total hours formula is =(I5-B5+(I5<B5))*24

and also worked hours formula is =((I5-B5-(I5<B5))-(D5-C5+(D5<C5))-(F5-E5+(F5<E5))-(H5-G5+(H5<G5)))*24

Problem is don't show the correct time of total hrs & worked hrs

Here i am attaching my timesheet format.

View 14 Replies
View Related
Jan 11, 2013

I am trying to get a count of supervisors and employees at any given time during a few day span. I think maybe a pivot chart might work but I'm stuck.

In my example I have a number of supervisors and employees in separate groups. I would like to type in two dates and two times for an in between time and get the total amount of employees working during a certain time.

Count of Employees at any given time.xlsx

View 6 Replies
View Related
Dec 9, 2013

After much searching today I've been unable to find a way to do this. All my searches resulted in some generic looking site looking to sell me some scheduling software.

I have a team of 7 people and I need one person to work a late shift each day of the business week. M-F

I would like a way to have the schedule automatically advance to the next person.

View 1 Replies
View Related
Dec 1, 2012

I have aworkbook with Employee details data sheet. And, I have built two userforms to search and view the employeeâ€™s full details. I donâ€™t know how to link the rowsource for combobox and textbox.

I have attached the excel file of what I'm trying to accomplish.

Book2.xlsm

View 9 Replies
View Related
Sep 25, 2013

I am a part of an construction company, I am looking to calculate Rig Pay, Truck pay and Perdiem for each employee based on an Excel Spreadsheet pulled from the Time Card Lines out of our accounting software. I am struggling terribly, and need assistance. The Calculations are as follows

Every Employee has multiple lines in the Time Cards sheet.

Rig Pay, Truck Pay, and Perdiem come from the Employee file in our system

If employee id is the same, job number is the same, cost code is the same, calc rig pay * hrs

If employee id is the same, job number is the same, cost code is the same, calc truck pay * hrs

If employee id is the same, job number is the same,Data, and cost code is the same, calc Perdiem /day

The final result i should see how much each employee charges rig pay, truck pay, and perdiem per job, and cost code.

View 9 Replies
View Related
Apr 22, 2014

I have a list of employees and the dates they worked. I'm trying to formulate an IF function that will check the name of employees in the list against the to the contents of a particular cell and also check the date the employees worked against another cell that contains a specific date, and if both these conditions are met, mark that cell with an X, if not leave it empty.

The formula I have right now is =IF(AND(A2:A27=G4, D2:D27,H3),"X",""). A2:A27 is the range that contains employee names, G4 is the first employee's name who I want to check if he is on the list, D2:D27 is the list of days they worked on and H3 is the date I want to know if this particular employee worked in. Using this formula returns either an empty cell of a #NAME? error. Is this a cell formatting issue?

View 14 Replies
View Related
Nov 28, 2013

I am attempting to create a rotating weekend work schedule in Excel to make life easier. There are 30 people who rotate Saturday's and Sunday's every month. Technically, they are only supposed to work 2 weekends a month, and am attempting a way to create this in Excel to make it more fair to the group instead of just picking and choosing which weekend these employees work, I would like an Excel program to do this for me.

View 1 Replies
View Related
May 31, 2014

Im doing a spreed sheet to calculate employees hours. I have the employees names in column R and their hours in column S. example R5 = Mike S5 = 8. I need to search column R for all the mike's and total his hours, then move to the next employee and so on... I have already sorted the employees names so that all the names and hours correspond and starting in column R5 and S5 until the proceeding row is blank and then paste the results in column B5 (employee name) and D5(total hours)

View 4 Replies
View Related
Feb 11, 2009

I am trying to rank employees by seniority date. Some employees share the same seniority date. They should have the same rank. I took a formula from another thread =RANK(C2,C$2:C$8) and applied it to my worksheet and it worked out great except that the ranking skips the next number (in this case 4)...........

View 2 Replies
View Related
Mar 6, 2012

I am trying to write an IF statement. The IF statement should calculate BONUS for an employee GREATER THAN 50 YEARS OLD.

View 4 Replies
View Related