Others

Fix Microsoft Project Earned Value Graphs Showing Incorrect Fixed Costs

Steven ParkerSteven Parker Nov 13, 2026 868 views

Question details

The user needs to correct Microsoft Project earned value graphs so fixed costs appear accurately in BCWS, BCWP, and earned value, using the proper resource type, baseline, status date, or a material-resource workaround.

Product
Microsoft Project
Device & OS
not provided
Scenario
The user is tracking earned value in Microsoft Project and fixed costs are not showing as expected in the earned value graphs.
Observed behavior
Fixed costs do not display correctly in Microsoft Project earned value graphs, including BCWS and BCWP.
Before you start

Open the project in Microsoft Project, confirm that a baseline has been saved, and open the Resource Sheet to review each resource Type. This helps you determine whether the expense should be recorded as a cost, work, or material resource before checking earned value.

Solution 1Recommended

Assign one-time expenses as cost resources and set the status date

Use this solution when a fixed cost is a one-time item that is not appearing correctly because it is assigned to the wrong resource type.

For one-time expenses, Microsoft Project expects a cost resource rather than a work or material resource. The status date must also be set to the date the item was expected so earned value calculations reflect the schedule delay.

1
Open the Resource Sheet

In Microsoft Project, go to the View tab and select Resource Sheet.

2
Review or change the resource Type

Hover over the Type field or open the resource details, then set the one-time expense item as Cost. Use Work only when the expense involves ongoing maintenance, fuel, or usage.

3
Save a baseline

Go to Project > Set Baseline > Set Baseline, choose Entire Project, and click OK.

4
Set the status date

Go to Project > Status Date, then set it to the date the item was expected but did not arrive.

Assign one-time expenses as cost resources and set the status date
Earned value should now reflect fixed costs: Cost-resource fixed costs should now flow into BCWS, BCWP, and earned value. For schedule delays, Tracking Gantt may provide a clearer view than earned value graphs.
Free Microsoft Office alternative

Use WPS Office as a Free Spreadsheet Alternative for Project Cost Tracking

Microsoft Project earned value settings are specific to Microsoft Project, but WPS Office is a free, lightweight alternative for tracking project cost data exported to Excel or CSV. It offers a familiar ribbon interface, strong Microsoft Excel format compatibility, and easy migration for cost tables and formulas.

  1. 1. Download WPS Office Free: Go to the official WPS Office website, click Download WPS Office Free, and install the application on your device.
  2. 2. Open exported cost data: Launch WPS Spreadsheet and open your exported Microsoft Excel .xlsx, .xls, or .csv project cost table.
  3. 3. Add fixed costs and formulas: Enter fixed cost amounts and use formulas to calculate planned cost, actual cost, and earned value-style totals.
  4. 4. Save for Microsoft Excel compatibility: Save the workbook as .xlsx or .xls to keep sharing and editing compatible with Microsoft Excel.
Track fixed costs and earned value-style calculations in WPS Spreadsheet after exporting cost data from Microsoft Project.Opens and saves Microsoft Excel .xlsx, .xls, and .csv files for seamless cost-table migration.Free, lightweight Office suite with a familiar ribbon interface, so it is easy to switch.Works on Windows, macOS, Linux, Android, and iOS without a subscription.
microsoft office alternative - wps office

Frequently Asked Questions

Why are fixed costs not showing in Microsoft Project earned value graphs?

Fixed costs may be assigned to the wrong resource type. One-time expenses should be cost resources, while work resources are for ongoing maintenance, fuel, or usage. Also check that a baseline is saved and the status date is set to the expected item date.

How do I set the status date in Microsoft Project?

Go to Project > Status Date, choose the date you want to use for earned value calculations, and click OK. The status date should be set after saving the baseline.

What is the difference between work, material, and cost resources?

Work resources are people or equipment that consume time, material resources are consumable items, and cost resources are one-time or fixed expenses. Hover over the Type field on the Resource Sheet to see or change the resource type.

Can I use a material resource to fix fixed costs in earned value?

Yes. Set the material resource Standard Rate to $0.00 and enter the item amount as a fixed cost in the cost table. The amount can then appear correctly in BCWS, BCWP, and earned value.

Can WPS Office open Microsoft Project files?

WPS Office does not open .mpp Microsoft Project files directly. You can export project cost data to Excel or CSV and open it in WPS Spreadsheet for further tracking.