Project Staffing formula in Excel

  • Context: High School 
  • Thread starter Thread starter Sue Hughes
  • Start date Start date
  • Tags Tags
    Excel Formula Project
Click For Summary

Discussion Overview

The discussion revolves around determining the staffing requirements for a project involving 461 clients, with each task taking a minimum of 10 minutes to complete. Participants are exploring how to calculate the total hours needed for project completion on a quarterly basis and are seeking an Excel formula to facilitate this calculation.

Discussion Character

  • Technical explanation
  • Mathematical reasoning
  • Homework-related

Main Points Raised

  • One participant calculates that the total time required for 461 tasks at 10 minutes each is 4610 minutes, or 77 hours per quarter.
  • Another participant expresses the need for an Excel formula that can adapt to changing numbers of clients and task durations.
  • A participant suggests an algebraic approach to derive total hours based on the number of clients and task duration, proposing a formula that could be used in Excel.
  • There is a clarification regarding the variables in the formula, with a participant pointing out a potential typo to ensure clarity in the calculations.

Areas of Agreement / Disagreement

Participants generally agree on the total time required for the project but there is no consensus on the exact formulation of the Excel equation, as some details remain unclear or are subject to interpretation.

Contextual Notes

The discussion includes assumptions about the consistency of task duration and the need for rounding in the calculations, which may affect the final staffing requirements.

Sue Hughes
Messages
4
Reaction score
0
Greetings all -

I am trying to determine the staffing requirement for an ongoing project. Here are the project specs, and I need to know if I need a part time or full time person.

461 clients
10 minutes to complete each client task (minimum of 10 minutes)
Repeat each task quarterly

How many hours a week would be needed to complete these 461 clients at ten minutes each. We need to repeat this quarterly.

Do you need more information to get the Excel formula?

Thank you!
Sue
 
Mathematics news on Phys.org
Erm, at least 4610 minutes, or 77 hours will be the total time for 461 ten minute tasks. I'm not really sure what you're looking for, though.
 
Thank you for your quick reply Cristo

I need to tell management how many hours a quarter an employee would be working on this project.
If I had a formula in Excel, I could change those numbers of clients and numbers of minutes.


Sue
 
Ok, well there you go: 77 hours a quarter (if every slot is ten minutes precisely).
 
Do you by chance have the formula I could plug into Excel for when the times and number of clients change?

Sue
 
I can't remember what equations in Excel look like (I've not used it for a very long time), but algebraically, if n is the number of hours, and m is the number of minutes each task takes, then the number of hours in total is n*m/60 (then rounded up to the nearest hour).

I guess in excel this would look something like A1*B1/60
 
Excellent! I've got it. Thank you SO much!
Sue
 
You're welcome :smile:
 
cristo said:
I can't remember what equations in Excel look like (I've not used it for a very long time), but algebraically, if n is the number of hours, and m is the number of minutes each task takes, then the number of hours in total is n*m/60 (then rounded up to the nearest hour).

I guess in excel this would look something like A1*B1/60

I'm sure you meant number of clients rather than number of hours for n (the part I bolded). Just pointing it out to make sure Sue isn't confused by a typo. :wink:
 
  • #10
Moonbear said:
I'm sure you meant number of clients rather than number of hours for n (the part I bolded). Just pointing it out to make sure Sue isn't confused by a typo. :wink:

Indeed I did mean number of clients: thanks MB!
 

Similar threads

High School Exponential formula for Excel sheet
  • · Replies 2 ·
Replies
2
Views
2K
MATLAB Converting Excel formulae into Matlab code
  • · Replies 2 ·
Replies
2
Views
4K
MHB How to Model Capacity for Training 5000 Trainees Annually?
  • · Replies 1 ·
Replies
1
Views
2K
How does AM broadcasting/receiving work + a project for HS students?
  • · Replies 20 ·
Replies
20
Views
3K
Art I suck at practical art tests, but am excellent at theoretical art exams
  • · Replies 5 ·
Replies
5
Views
2K
High School It works but why? (Matching experimental data to a random equation)
  • · Replies 3 ·
Replies
3
Views
2K
High School Strange cosmic particles in my detector
  • · Replies 24 ·
Replies
24
Views
4K
Admissions Advice on how best to spend my time for graduate school applications
  • · Replies 15 ·
Replies
15
Views
3K
Studying Why am I not doing well in physics?
  • · Replies 16 ·
Replies
16
Views
3K
High School Applying the distance formula d= v*t + 1/2a*t^2
  • · Replies 5 ·
Replies
5
Views
9K