How to Create and Assign Material Resources in Microsoft Project (Fixed vs. Variable Consumption Rates)

In this blog post, I’m going to show you how to create and assign Material Resources in Microsoft Project, including the critical difference between a Fixed Consumption rate and a Variable Consumption rate. If your projects involve physical consumables (such as concrete, steel, lumber, bricks, network cable, or fuel), Material Resources let you track both physical quantities and total material costs right inside your schedule!

Companion Articles in This Resources, Assignments & Cost Management Series: Explore these connected tutorials in the same topic area to build your skills step by step:

How to Create and Assign Material Resources in Microsoft Project (Fixed vs. Variable Consumption Rates)

YouTubeWatch the Step-by-Step Video

Prefer to follow along visually? This video demonstrates the exact steps you’ll learn below using Microsoft Project Desktop.

At a Glance: Material Resources in Microsoft Project:

  • Applies to: Microsoft Project Standard and Professional (2016, 2019, 2021, 2024, and Project Online Desktop Client).
  • Step 1: In the Resource Sheet view, enter the consumable item’s name, set the Type value to Material, enter the unit of measure in Material Label (such as cubic yards, tons, or feet), and enter the unit price in Std. Rate.
  • Step 2 (Fixed Consumption): In the Assign Resources dialog, enter a plain number in Units (such as 20) when the total quantity of material stays constant regardless of task Duration.
  • Step 3 (Variable Consumption): Enter a rate per time unit in Units (such as 2/d for 2 units per day or 5/h for 5 units per hour) when material usage scales up or down with task Duration!

Need hands-on help with your schedule? Explore my $399 Microsoft Project Desktop Course, Project Server Training, or book 1-on-1 Private Training & Consulting.

How Are Material Resources Different from Work and Cost Resources?

Microsoft Project supports three distinct resource types on the Resource Sheet:

  1. Work Resources: People and equipment (assigned to tasks with hours of Work and subject to resource overallocation).
  2. Cost Resources: Financial expense categories like travel, lodging, or permits (measured strictly in dollars, as covered in my guide on Cash Flow reports in Microsoft Project).
  3. Material Resources: Physical consumable supplies (such as concrete, pipe, lumber, cable, or fuel) where you want Microsoft Project to track how many physical units are consumed and multiply those units by a unit price (Std. Rate) to calculate total cost!

Step 1: How Do I Set Up Material Resources on the Resource Sheet?

Let’s start by creating two Material Resources in the Resource Sheet view:

  1. Click the View ribbon tab and click Resource Sheet in the Resource Views section.
  2. In the first blank row, enter your Material Resource details:
    1. In the Resource Name column, type the name of the consumable material (for example, Concrete or Fuel).
    2. In the Type column, click the pick list button and select Material.
    3. In the Material Label column (which only unlocks when Type is set to Material!), type the unit of measurement for that material (for example, cubic yards, tons, linear feet, or gallons).
    4. In the Std. Rate column, type the cost per single unit of that material (for example, $150.00 per cubic yard of concrete, or $4.00 per gallon of fuel).

Notice that Microsoft Project grays out Max. Units and Base Calendar for Material Resources because physical materials do not take vacations and cannot be overallocated!

Step 2: How Do I Assign a Fixed Material Consumption Rate?

Use a Fixed Material Consumption assignment when a task requires a specific, fixed quantity of material, no matter how long the task takes to finish. For example, pouring a foundation pad of a fixed size requires 20 cubic yards of concrete whether the crew finishes in 4 days or 6 days:

  1. Switch to the Gantt Chart view (View -> Gantt Chart) and select the task where the material resource will be used.
  2. Click the Resource ribbon tab and click the Assign Resources button to open the Assign Resources dialog.
  3. In the Assign Resources dialog:
    1. Select your Material Resource (for example, Concrete).
    2. Click in the Units column on that row, type 20 (a plain number with no slash), and press Enter.
    3. Notice that Microsoft Project automatically appends your Material Label so the Units column displays 20 cubic yards, and multiplies 20 * $150.00 to display $3,000.00 in the Cost column!

Because this is a Fixed consumption rate, if the task Duration later slips from 5d to 8d, the material quantity stays locked at 20 cubic yards and the material cost stays locked at $3,000.00.

Step 3: How Do I Assign a Variable Material Consumption Rate?

What if a piece of heavy machinery burns 15 gallons of fuel per day (or 2 gallons per hour)? If the task Duration increases from 5 days to 8 days, the machine is going to burn 3 extra days of fuel! That is called a Variable Material Consumption rate. Here’s how to assign a Material resource using this method:

  1. Select the task in the Gantt Chart view and display the Assign Resources dialog.
  2. Select your Material Resource (for example, Fuel).
  3. In the Units column, type the quantity followed by a forward slash (/) and the time unit:
    1. Type 15/d (for 15 units per working day) or 2/h (for 2 units per working hour) and press Enter.
    2. Microsoft Project displays 15 gallons/day in the Units column of the Assign Resources dialog (and shows Fuel[15 gallons/day] next to the Gantt bar).
  4. Watch what happens in the Task Usage view (View -> Task Usage):
    1. On a 5-day task at 15 gallons/day, the Work column on the Fuel assignment row displays 75 gallons (5 days * 15 gallons/day), and the cost is calculated as 75 * $4.00 = $300.00!
    2. If you increase the task Duration from 5d to 8d, Microsoft Project automatically recalculates the material consumption to 120 gallons and updates the cost to $480.00!

Frequently Asked Questions

Why does Microsoft Project show Material Resource quantities inside the “Work” column?

In the Task Usage and Resource Usage views, Microsoft Project reuses the Work column to store physical material quantities so it does not have to maintain a separate database field. For a Work Resource (a person), the Work column displays hours (such as 40 hrs); for a Material Resource on its assignment row, that exact same Work column displays your Material Label quantity (such as 20 cubic yards or 75 gallons)!

Do Material Resource quantities roll up to the Task and Summary Task rows in the Work column?

No! Because you cannot add 40 hours of carpenter labor to 20 cubic yards of concrete and 75 gallons of fuel, Microsoft Project only rolls up Work Resource hours to the task and Summary Task rows in the Work column. However, in the Cost column, Microsoft Project rolls up all labor costs, material costs, and expense costs together cleanly!

How do I track actual material usage if we used more concrete than planned?

Switch to the Task Usage view (View -> Task Usage), insert the Actual Work and Remaining Work columns (or apply the Work table via View -> Tables -> Work), and expand the task row. On the Concrete assignment row, enter the actual quantity consumed (for example, 24 cubic yards) in the Actual Work column!

Can Material Resources be leveled using Resource Leveling?

No. Resource Leveling in Microsoft Project only levels overallocated Work Resources (people and equipment). Material and Cost resources cannot be overallocated or leveled.


Ready to master Microsoft Project? If you found this article helpful, check out my free tutorials on my YouTube channel, download my Free Microsoft Project Quality Filters, or explore my structured, expert-led training courses and 1-on-1 coaching at dalehowardmvp.com.

Leave a Reply

Your email address will not be published. Required fields are marked *

Are you human? Please solve:Captcha