Office Equipment & Supplies Logo

Related Topics:

Question about Office Equipment & Supplies

1 Answer

How do I find out a percentage of a number

If I have 3223.5 hours of work for a month and the month has 28 days and the total number of employees are 306 for the month, what is the percentage of employees per day?

Posted by Anonymous on

Ad

1 Answer

Sean Cole

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Sergeant:

    An expert that has over 500 points.

  • Expert
  • 255 Answers

You likely mean this to be the 'Average' number of employees per day rather than percentage. However you need to work out based on hr's per day that each employee can work. Lets assume though that they work full time, 8hrs per day. Then you would work out as follows:
3223.5 /8 /28 /306 = 0.047 employees per day

If they only work 1 hr per day it would be:
3223.5 /28 /306 = 0.376 employees per day

Each employee would need to work:
3223.5 /306 = 10.53hrs per month

Posted on Mar 02, 2015

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2helpful
2answers

What is formula to find percentage of females in my workplace?

      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet

    https://exceljet.net/formula/get-percentage-of-total
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.
0helpful
1answer

HOW MAN HOURS BREAK IN CALIFORNIA AFTER 8 HOUR SHIFT?

Employees must, with two exceptions, receive at least eight hours free from work between shifts, whether they are "split shifts," "on call shifts," "back-to-back" shifts or ordinary daily shifts.
Rest between shifts is not required if:
  • the total time worked during both shifts does not exceed 13 hours; or
  • the employer and employee agree in writing to reduce or forego the eight-hour rest period.
Example
Monica works in a restaurant. She is on split shifts, working from 11:30 am to 2:30 pm and then from 4:00 pm to 7:00 pm. The total time of her two shifts is 6 hours. Monica does not need to have eight hours off between the shifts because her total hours worked on the shifts do not exceed 13 hours.
Note: The requirement for rest between shifts operates simultaneously with the requirement for daily rest; an employee's schedule must satisfy both requirements. For example, an employee might agree in writing to work two eight-hour shifts in a row without any time free from work between them (the employee's agreement means there is no violation of the rest between shifts rule), but if that results in the employee receiving less than 11 consecutive hours off in a day, the employer will be in violation of the daily rest rule* and therefore it is not permitted.
* Unlike the case with the rest between shifts requirement, an employee cannot agree to waive the daily rest requirement.
0helpful
1answer

What make the gross profit percentage increase

Gross profit =total revenue -cost of doing business
Gross profit percentage = Gross profit/(Total revenue.)*100%
To increase the gross profit percentage, you decrease the cost of doing business.
Costs= all you have to spend to be able to do business (merchandises, employees' pay, rent of facilities, electric bills, etc.)
0helpful
1answer

Can i work 15 hours a day

If you are salary employee, then you can work as much as you want.
If you are hourly employee, then employer must pay overtime beyond 40 hours per week.
If you own your business, then 16 hour day is normal, except 7 days per week instead of 6.
http://www.dol.gov/compliance/guide/

If you need further help, I’m available over the phone at https://www.6ya.com/expert/gene_9f0ef4df2f9897e7

2helpful
1answer

EMPLOYEE MAKES $52,612.00 will get a 15% incentive. What will the amount of the incentive be?

The amount of the incentive is the percentage, or fraction of the total amount.

To calculate the incentive, multiply the total amount by the percentage all over hundred:

that is,
Incentive = (initial amount) * (percentage/100)

In this case, we have:

Incentive = (52612) * (15/100)
= 52612 * 0.15
= 7891.8.

So, the incentive would be $7891.8

Hope that was helpful?
Take care.
0helpful
1answer

I have a total number of students which is 3474, I need to have percentage in racial segregation out of the total African Americans is 2863, Whites -490 and Hispanics 72

The percentages for your students according to race are as follows:
African American - 82.4%
White - 14.1%
Hispanic - 2.1%
I hope this helps and have a nice day!
0helpful
1answer
0helpful
1answer

Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.

The easiest way to do this is to use Excel spreadsheet.
This is what you need to do.
Create a label at the top of each column as detailed.
Add a employee to each row under Name of employee
Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee
2nd column - salary rate per hour
3rd column - hours worked
4th column - gross pay (formula = salary rate X hours worked)
5th column - tax deduction
6th column - other deductions
7th column - total deductions (formula = tax deduction + other deduction)
8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.
You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.
0helpful
1answer

I want an formula in excel to find out number of days present per month an perticular worker

Hello this is Baris,
Can you tell me more about this employee. Are you creating an excel spreadsheet to keep record of his days. Are you just getting the numbers from an outside source like a schedule.

To be able to give you an answer I will assume that you have the info already in the same spreadsheet.

Lets say Column A is the days of the month.
Column B is the information column like the hours that the employee worked. If the month has 31 days this is what you need to do.
Click on the cell B32 and type the formula
=count(B1:B31) and press enter. This will count the number off cells which have a value in it in that month.

If you provide me more info we may come up with a better solution. Hope this helps :)

0helpful
1answer

Creating vacation accrual spreadsheet

Here is one way to do it:
1. In column A enter the name
2. In column B enter their start date in the format day-month-2008 (31-12-2008 for Dec. 31, 2008); if a day is less than 10, put zero in front (03, 04, etc.)
3. In column C put 31-12-2008 (December 31, 2008, the last day of the year)
4. In column D, put C1-B1 and format as a number with 2 places after the period (10.25 for example) if you want to track partial days, other format for no zeroes after the period (13)
5. In column E, put this formula:
(D2/30)*1.25 (assuming this is line 2)
You can then copy these lines as many times as you need to, total them, etc.
Not finding what you are looking for?

199 views

Ask a Question

Usually answered in minutes!

Top Office Equipment & Supplies Experts

Marvin
Marvin

Level 3 Expert

85241 Answers

The Knight
The Knight

Level 3 Expert

76851 Answers

Brad Brown

Level 3 Expert

19166 Answers

Are you an Office Equipment and Supply Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...