How to Show Resource Types and Costs by Task in MS Project
Question details
The user needs to display task, resource, and cost breakdowns (labor, materials, equipment) for a construction proposal.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Creating a detailed construction proposal that requires itemizing resource types and their associated costs per task.
- Observed behavior
- The user needs a clear view to distinguish and calculate labor, material, equipment, and cost categories by task without assigning costs to summary tasks.
Ensure all project resources (labor, materials, equipment) are already created in your Resource Sheet with their correct standard rates, cost per use, and resource types before attempting to assign them to tasks.
Use Task Usage View to Display Resource Types and Costs
Switching to the Task Usage view allows you to see individual resource assignments under each task, where you can add specific columns to categorize and calculate expenses.
In Microsoft Project, Work resources represent labor and equipment, Material resources represent consumables (like concrete or fuel), and Cost resources represent other independent expenses. Grouping these accurately requires the correct view and column setup.
Navigate to the 'View' tab on the ribbon and click on 'Task Usage' to display your tasks with their assigned resources listed underneath.
Right-click on the header of any existing column (such as Task Name) and select 'Insert Column'. Type 'Type' or 'Resource Type' to add the column that distinguishes between Work, Material, and Cost.
Right-click the column header again, select 'Insert Column', and type 'Cost'. This will display the calculated total cost for each resource assignment under the specific task.

Manage Project Costs Efficiently with WPS Office
While Microsoft Project is a dedicated scheduling tool, WPS Spreadsheet offers a highly capable, free alternative for tracking construction proposals, calculating task costs, and building detailed resource breakdowns. Enjoy a familiar interface and seamless compatibility with Microsoft Excel files without the steep subscription fees.
- 1. Open WPS Spreadsheet: Launch WPS Office and click on Spreadsheet to create a new project cost tracking workbook.
- 2. Set Up Cost Columns: Create clear headers for Task Name, Resource Type, Hourly Rate or Unit Cost, Quantity, and Total Cost.
- 3. Summarize with Pivot Tables: Select your data range, navigate to the Insert tab, and add a Pivot Table to quickly group and sum costs by task category.

Frequently Asked Questions
Why shouldn't I assign resources to summary tasks in MS Project?
Assigning resources directly to summary tasks can cause MS Project to double-count costs and hours, making your construction proposal inaccurate. You should always assign resources to the specific action items or lowest-level subtasks.
What is the difference between Work, Material, and Cost resources?
Work resources are time-based (e.g., labor hours or equipment rentals), Material resources are quantity-based (e.g., tons of concrete or gallons of fuel), and Cost resources represent fixed financial expenses (e.g., travel expenses or permit fees).
Can I export my Microsoft Project cost data to Excel or WPS Spreadsheet?
Yes, you can use the 'Save As' function in MS Project to export your Task Usage view data as an Excel workbook (.xlsx). This file can then be opened, edited, and formatted seamlessly in WPS Spreadsheet.




