Hotel room cleaning workload balance calculator

Calculate work allocation and loads and unallocated tasks with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use work allocation and loads and unallocated tasks to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Required room-cleaning minutes by room (input-order room IDs)
20,30,40,15
Staff available workload capacity (same units)
60,60
Work allocation and loads (JSON)
{"assignments":[2,2,1,1],"loads":[55,50],"unassigned":[]}
Unallocated tasks (count)
0
Allocated workload
105

Try another scenario

Required room-cleaning minutes by room (input-order room IDs)
25,35,45,20
Staff available workload capacity (same units)
50,40
Work allocation and loads (JSON)
{"assignments":[null,2,1,null],"loads":[45,35],"unassigned":[1,4]}
Unallocated tasks (count)
2
Allocated workload
80
Calculation method

Calculation method

Work allocation and loads (JSON)

Largest-workload-first; assign feasible staff with currently lowest load, tie by index; preserve original task indices.

Unallocated tasks (count)

Count tasks that fit no remaining staff capacity in the greedy pass.

Allocated workload

Sum final staff loads.

Symbols and units
a
Required room-cleaning minutes by room (input-order room IDs)
b
Staff available workload capacity (same units)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Whole-room cleaning workload assigned to interchangeable qualified staff. Checkout/room-type differences must be included in measured per-room minutes. Supported limits: All numeric inputs and computed intermediates must remain finite. Supported numeric input magnitude is zero or 1e-12 through 1e12 in absolute value; reject values outside this bounded range. All lists/JSON record tables are limited to 100 records unless a stricter bound is stated; reject malformed record arity and wrong member types. Positive work items and nonnegative staff capacities; <=100 items and <=20 staff. All listed staff qualify for all tasks; no time-window constraints unless encoded separately.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.