Jul 15 2022 03:30 PM
We want to use Project to track the daily usage of equipment.
using this total to know if we have enough equipment each day.
how can this be totaled and displayed
thanks
Jul 15 2022 07:11 PM
Jul 18 2022 11:16 AM
We are starting to use Project to track and show projects/jobs and how they overlap by dates.
We also want to show how the qty of equipment is used by totals.
There will be 20 to 50 jobs going on at once. Some are a few days, some go for months.
Looking to monitor how many trucks, trailers, and flagger personnel are needed by day. This will allow us to know when we will be overbooked or need to get more equipment or hire more personnel.
What do you think is best tool to track this?
Thank you for your opinion.
Jul 18 2022 11:39 AM
Jul 18 2022 12:17 PM
Jul 18 2022 03:35 PM
Resources are assigned as either a percentage or as a decimal value. What you want is a decimal value. To set that go to, File > Options > Schedule tab as shown here:
Then on the Resource Sheet the Max Units field sets the number of available resources for each resource type as shown here. In this example, there is one piece of Equipment A, four people on Work team 1, and two people on Work team 2.
As far as daily usage values for resources, the Resource Usage view shows that type of data. In this example, the piece of equipment is overallocated since concurrent tasking shows it's usage at 1.5. Work team 2 is also overallocated with a usage of 3 when there are only 2 people on the team. Work team 1 is okay, the tasking never exceeds the 4 person availability. Unfortunately the overallocation values can only be expressed in hours so you won't get a direct read of quantity.
How this helps.
John