Re: Cost Vs. Sell Resource Rates
- From: Jim Aksel <JimAksel@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 2 Sep 2007 10:50:00 -0700
On the resource sheet, add costs as standard rates, cost per use, etc. These
will be cost based.
The answer to an "At Sell" price is going to be different depending on what
you want to do.
Suppose you want to sell all of a resource... on the Resource Sheet you
could insert a Cost1 column, make a formula for [work]*price
If you are selling an entire task on the Gantt chart with multiple subtasks
and resources assigned, then it gets more complicated...
Information on the resources sheet and the Gantt chart (Task sheets) are
stored in two different places. One is a Resource cost1, the other is a Task
cost1. Same name different tables and storage locations.
Read FAQ#37 on the link below (go to the FAQ section of the site). It will
explain how to make these variables the same in both Task and Resource views.
You may do better looking at the Task Usage View. There, you can use your
newly created Cost1 (task) and Cost1 (resource). Let's assume Resource Cost1
is a sell price for 1 unit of the resource (1 brick, 1 hour of labor, etc).
Insert a Cost2 field into the task usage view, and a cost1. The formula in
Cost2 becomes [Cost1]*[Work] or [Cost1]*[Units] if it's a material resource.
To make formulas, right click on the column header (Cost1) and select
"Customize Fields". From there, select your variable (cost1, cost2, etc) and
then click the formula button. It is pretty intuitive.
After all that, it should also display on the Gantt chart for each task.
--
If this post was helpful, please consider rating it.
Jim
Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
"engineer12345" wrote:
Thank you for your kind reply,.
would you pls send me or explain me (for a newbie) how can i enter cost
price and sell price for the same material and/or work on the resource sheet
and show on gant chart.
Thanks in advance for your greate help.
Regards.
"Jim Aksel" wrote:
Microsoft Project is used as a scheduling application which will also allow
for tracking of cost data. Generaly resources in the schedule are listed at
the price the program must pay for them (cost), not sell price. Costs are
calculated up through your cost accounting sytem and may include Actual Work
Rate, General & Administrative, Overhead, Cost of Money, etc. Profit (Fee)
and price at sell is usually added afterwards and external to the project.mpp
file.
However, Project contains extra Cost fields such as Cost1, Cost2, Cost3...,
or, more general fields Number1, Number2... If you wanted, you could use
these fields to represent "sell price", Formulas could be created to cacluate
profit as well.
--
If this post was helpful, please consider rating it.
Jim
Visit http://project.mvps.org/ for FAQs and more information
about Microsoft Project
"engineer12345" wrote:
Hello All,
I would like to keep control and keep track of actual cost and sellin
price of each resource (material and/or work).(with example pls)
I look forward for your kind help.
Best Regards
--
engineer12345
------------------------------------------------------------------------
engineer12345's Profile: http://forums.techarena.in/member.php?userid=30413
View this thread: http://forums.techarena.in/showthread.php?t=642863
http://forums.techarena.in
- References:
- Re: Cost Vs. Sell Resource Rates
- From: engineer12345
- Re: Cost Vs. Sell Resource Rates
- Prev by Date: Re: List of resources in stock
- Next by Date: Re: List of resources in stock
- Previous by thread: Re: Cost Vs. Sell Resource Rates
- Next by thread: Re: multiple rates per person possible?
- Index(es):
Relevant Pages
|
