Work forecast · from Projects

Too much work lands in the week of 7 December.

The Gupta Steel shed, Mehta Infra railings and KRB gates all reach welding the same week. Without a change, 6 of 19 open jobs will finish late.

Open jobs 19 J-1042 approved this week
Likely to finish late 6 jobs 9 days late on average
Busiest week 118% Week of 7 Dec · welding at 140%
To bill before 25 Jan about₹51.1 L From 9 jobs finishing

When each job will really finish

The blue line is the date you promised. The dot is the likely finish, with its range. Click a job for why, and what to do.

Done so far Still to do Likely finish range Promised date

Hours needed vs hours we have

All teams together. The dashed line is what 24 people can do in a week.

Booked jobs Likely from deals Hours we have

Week of 7 December

944 hours needed, 800 hours available.

2 welders short from 1 December
From the people forecast
Open

How full each team is

Share of each team's hours already used, week by week. Click a cell to see which jobs fill it.

OK Tight Too much

What to do about it

Doing one moves the job dates, the team load and the cash plan straight away.

Welding needs 140% of its hours in the week of 7 December.
Moving the Gupta shed by 2 weeks brings the whole shop down to 104%. Two temporary welders for 3 weeks cost about ₹1.1 L; Saturday overtime about ₹45,000.
Try in What-if
Sunrise Hotels hasn't approved the canopy drawing for 9 days.
Each day of waiting moves the finish by a day. It's now likely 14 December, two weeks after the promise.
Relationships
Steel for the KRB gates may arrive late.
Jindal Traders were late on 4 of their last 6 orders, by 5 days on average. Ordering this week keeps the gates on the 24 December date.
Strength
The Prakash staircase will finish 2 days early, on 4 November.
That's a ₹3.8 L bill you can send next week. Prakash Builders usually pay within 4 days of the due date.

Money from work

When each job finishes, when you can bill it, and when the money likely reaches the bank. Click a row for the job.

Open the money forecast
JobFinishesBillAmountCash likely by
Every week the Gupta, Mehta and KRB jobs slip pushes ₹20.6 L of cash a week later.

Why jobs run late

Days lost on the last 30 finished jobs.

Waiting for the customer to approve38%
Steel arrived late27%
Rework after checking16%
Not enough welders12%
Site not ready7%

How good our estimates are

Estimated hours vs real hours on past jobs. The forecast adds this gap to new estimates. Click a row for the jobs.

Kind of jobJobsReal vs estimateHow sure

Make this forecast sharper

Small things to fill in. Each adds points to how sure we are (now /100).

How sure is it?
Estimate hours on 8 jobs
We guess from similar jobs now.
+4
Update 5 jobs not touched in 2 weeks
We can't tell how far along they are.
+3
Set a promised date on 3 jobs
We can't say if they're late.
+2