Fix Microsoft Project Earned Value Graphs Showing Incorrect Fixed Costs
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.
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.
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.
In Microsoft Project, go to the View tab and select Resource Sheet.
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.
Go to Project > Set Baseline > Set Baseline, choose Entire Project, and click OK.
Go to Project > Status Date, then set it to the date the item was expected but did not arrive.

Workaround: Use a material resource with a zero rate and enter the amount as fixed cost
Use this workaround when you need the amount to appear correctly in BCWS, BCWP, and earned value without changing the broader resource model.
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. Download WPS Office Free: Go to the official WPS Office website, click Download WPS Office Free, and install the application on your device.
- 2. Open exported cost data: Launch WPS Spreadsheet and open your exported Microsoft Excel .xlsx, .xls, or .csv project cost table.
- 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. Save for Microsoft Excel compatibility: Save the workbook as .xlsx or .xls to keep sharing and editing compatible with Microsoft Excel.

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.




