you do not edit the resource spreadsheet the costs and units are spread over the activities start and end date based on the cost and units that you input for the resource. 

this is based on your calendar and availabe work hours per day.

the only way to change distribution is to change the duration, chnage the costs, change the units or assign a curve to the resource so that the distribution is different.

this is not excel 

Hi Ijaz,

As mentioned in previous post, you cannot edit/modify cost manually whether it is Labor, Nonlabor & Material Resource Type.

This is just a suggestion, I think the best thing you can do is to set your Budgeted Cost equal to your Budgeted Units. To perform this try the following:

1. I pressumed you have cost-loaded schedule and no Budgeted Units in your schedule.

2. Perform a global change or do it in Excel.

Select Subject Area = "Activity Resource Assignments"
Where
Resource ID Name "is under" "Assigned Resource ID/Name"
Then
Budgeted Labor Units = Budgeted Cost

3. When done, set your Price/Unit = 1

4. Do not forget to "Recalculate Assignment Cost" under Tools Menu.

Now, You have a Budgeted Unit & Cost. If you wish to modify your Budgetd Units, your cost as well will be modified and updated according to your units.

If you find some difficulties try to send PM to me.

Regards,

Arnold

Hi Ijaz,

I agree with Rodel, you cannot modify/edit cost but only budget units and remaining units.

Tell us what is really your intention otherwise, we can suggest another perspective.

Regards,

Arnold