I have been beating my head against the keyboard for two days trying
to remember how to assign a piece of equipment an initial price.  I am
running Project Professional 2007.

For example: (yes I know I am missing a million steps to make this
truly feasible)
Tasks: (Gantt Chart)
Making widget
     Cast aluminum - resources- Me, foundry, aluminum ingots
     Weld aluminum - resources - Me, wielder, welding rods

Resources:
Me- we won't worry too much about him
Foundry - cost $1000 to build and $40 every time I use it
Aluminum Ingots - cost $10
Welder - cost $2000 to buy and $10 every time I use it
Welding rods - cost $1 each

The Aluminum and Rods I can deal with.  They are materials that have a
cost / use.  Easy enough.  (right???)
Dealing with the foundry and welder is my problem.  I would like to
capture that initial cost and a cost per use and have all of the costs
show up when I go back to my Gantt chart and look at the top line!

Irrelevant background data:
In my research I found that setting them up as baselines and using a
separate line item to account for each use was referenced to.  I am
pretty certain, especially after reading about it in this forum, and
having it not work, that is NOT the correct way to handle this
situation.

This is my first post (and I'm a bit stressed about this, and it is
1:30) so please try and work with me a bit!!

Thanks so much!!

Andrew Spencer

Standard accounting practice is to amortize the cost of the welding 
equipment over the expected life/usage. Your accounts dept should be able to 
give you a cost per use.

-- 

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com




<spencera12@yahoo.com> wrote in message 
news:7628bdde-269c-487d-860a-64f16c02cdec@j24g2000yqa.googlegroups.com...
> I have been beating my head against the keyboard for two days trying
> to remember how to assign a piece of equipment an initial price.  I am
> running Project Professional 2007.
>
> For example: (yes I know I am missing a million steps to make this
> truly feasible)
> Tasks: (Gantt Chart)
> Making widget
>     Cast aluminum - resources- Me, foundry, aluminum ingots
>     Weld aluminum - resources - Me, wielder, welding rods
>
> Resources:
> Me- we won't worry too much about him
> Foundry - cost $1000 to build and $40 every time I use it
> Aluminum Ingots - cost $10
> Welder - cost $2000 to buy and $10 every time I use it
> Welding rods - cost $1 each
>
> The Aluminum and Rods I can deal with.  They are materials that have a
> cost / use.  Easy enough.  (right???)
> Dealing with the foundry and welder is my problem.  I would like to
> capture that initial cost and a cost per use and have all of the costs
> show up when I go back to my Gantt chart and look at the top line!
>
> Irrelevant background data:
> In my research I found that setting them up as baselines and using a
> separate line item to account for each use was referenced to.  I am
> pretty certain, especially after reading about it in this forum, and
> having it not work, that is NOT the correct way to handle this
> situation.
>
> This is my first post (and I'm a bit stressed about this, and it is
> 1:30) so please try and work with me a bit!!
>
> Thanks so much!!
>
> Andrew Spencer
>
> __________ Information from ESET Smart Security, version of virus 
> signature database 4602 (20091113) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
> 

__________ Information from ESET Smart Security, version of virus signature database 4602 (20091113) __________

The message was checked by ESET Smart Security.

http://www.eset.com

Rod,

I figured I didn't give enough info!

I am trying to determine the TOTAL cost to start a business,
specifically the R&D.  Therefore, I am the accounting, public
relations, purchasing, engineering, drafting and management
departments!  Thus, my conundrum!

Andrew

p.s. I am horrible at accounting, therefore I was trying to get it
into one line.

This is a multi-part message in MIME format.

------=_NextPart_000_0044_01CA6445.F8D637B0
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi Andrew,

Welcome to this Microsoft Project newsgroup :)

For the Foundry, enter $1000 in the Fixed Cost column (Insert/Fixed Cost =
or View/Table: ()/Cost) against the task "Build Foundry" =20

As for usage, make the Foundry a resource and enter a per use cost in =
the Resource Information dialog.  Then assign the resource to the =
appropriate tasks.

Do the same for the Welder

FAQs, companion products and other useful Project information can be =
seen at this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials


=20
  <spencera12@yahoo.com> wrote in message =
news:7628bdde-269c-487d-860a-64f16c02cdec@j24g2000yqa.googlegroups.com...=

  I have been beating my head against the keyboard for two days trying
  to remember how to assign a piece of equipment an initial price.  I am
  running Project Professional 2007.

  For example: (yes I know I am missing a million steps to make this
  truly feasible)
  Tasks: (Gantt Chart)
  Making widget
       Cast aluminum - resources- Me, foundry, aluminum ingots
       Weld aluminum - resources - Me, wielder, welding rods

  Resources:
  Me- we won't worry too much about him
  Foundry - cost $1000 to build and $40 every time I use it
  Aluminum Ingots - cost $10
  Welder - cost $2000 to buy and $10 every time I use it
  Welding rods - cost $1 each

  The Aluminum and Rods I can deal with.  They are materials that have a
  cost / use.  Easy enough.  (right???)
  Dealing with the foundry and welder is my problem.  I would like to
  capture that initial cost and a cost per use and have all of the costs
  show up when I go back to my Gantt chart and look at the top line!

  Irrelevant background data:
  In my research I found that setting them up as baselines and using a
  separate line item to account for each use was referenced to.  I am
  pretty certain, especially after reading about it in this forum, and
  having it not work, that is NOT the correct way to handle this
  situation.

  This is my first post (and I'm a bit stressed about this, and it is
  1:30) so please try and work with me a bit!!

  Thanks so much!!

  Andrew Spencer
------=_NextPart_000_0044_01CA6445.F8D637B0
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3Dtext/html;charset=3DWindows-1252 =
http-equiv=3DContent-Type>
<META name=3DGENERATOR content=3D"MSHTML 8.00.7600.16444"></HEAD>
<BODY style=3D"PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: =
15px"=20
id=3DMailContainerBody leftMargin=3D0 topMargin=3D0 =
CanvasTabStop=3D"true"=20
name=3D"Compose message area">
<DIV><FONT face=3D"Comic Sans MS">Hi Andrew,</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS">Welcome to this Microsoft Project =
newsgroup=20
:)</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS">For the Foundry, enter $1000 in the =
Fixed Cost=20
column (Insert/Fixed Cost or View/Table: ()/Cost) against&nbsp;the task =
"Build=20
Foundry"&nbsp; </FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS"></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS">As for usage, make the Foundry a =
resource and=20
enter a per use cost in the Resource Information dialog.&nbsp; Then =
assign the=20
resource to the appropriate tasks.</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS"></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS">Do the same for the =
Welder</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS">FAQs, companion products and other =
useful=20
Project information can be seen at this web address: <A=20
title=3D"http://project.mvps.org/faqs.htm&#10;CTRL + Click to follow =
link"=20
href=3D"http://project.mvps.org/faqs.htm">http://project.mvps.org/faqs.ht=
m</A></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS">Hope this helps - please let us know =
how you get=20
on :)</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS">Mike Glen<BR>MS Project MVP<BR>See <A=20
title=3D"http://tinyurl.com/2xbhc&#10;CTRL + Click to follow link"=20
href=3D"http://tinyurl.com/2xbhc">http://tinyurl.com/2xbhc</A> for my =
free Project=20
Tutorials</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS"></FONT>&nbsp;</DIV>
<DIV><FONT face=3D"Comic Sans MS"><BR>&nbsp;</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; =
PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
  <DIV>&lt;<A =
href=3D"mailto:spencera12@yahoo.com">spencera12@yahoo.com</A>&gt;=20
  wrote in message <A=20
  =
title=3D"news:7628bdde-269c-487d-860a-64f16c02cdec@j24g2000yqa.googlegrou=
ps.com&#10;CTRL + Click to follow link"=20
  =
href=3D"news:7628bdde-269c-487d-860a-64f16c02cdec@j24g2000yqa.googlegroup=
s.com">news:7628bdde-269c-487d-860a-64f16c02cdec@j24g2000yqa.googlegroups=
..com</A>...</DIV>I=20
  have been beating my head against the keyboard for two days =
trying<BR>to=20
  remember how to assign a piece of equipment an initial price.&nbsp; I=20
  am<BR>running Project Professional 2007.<BR><BR>For example: (yes I =
know I am=20
  missing a million steps to make this<BR>truly feasible)<BR>Tasks: =
(Gantt=20
  Chart)<BR>Making widget<BR>&nbsp;&nbsp;&nbsp;&nbsp; Cast aluminum - =
resources-=20
  Me, foundry, aluminum ingots<BR>&nbsp;&nbsp;&nbsp;&nbsp; Weld aluminum =
-=20
  resources - Me, wielder, welding rods<BR><BR>Resources:<BR>Me- we =
won't worry=20
  too much about him<BR>Foundry - cost $1000 to build and $40 every time =
I use=20
  it<BR>Aluminum Ingots - cost $10<BR>Welder - cost $2000 to buy and $10 =
every=20
  time I use it<BR>Welding rods - cost $1 each<BR><BR>The Aluminum and =
Rods I=20
  can deal with.&nbsp; They are materials that have a<BR>cost / =
use.&nbsp; Easy=20
  enough.&nbsp; (right???)<BR>Dealing with the foundry and welder is my=20
  problem.&nbsp; I would like to<BR>capture that initial cost and a cost =
per use=20
  and have all of the costs<BR>show up when I go back to my Gantt chart =
and look=20
  at the top line!<BR><BR>Irrelevant background data:<BR>In my research =
I found=20
  that setting them up as baselines and using a<BR>separate line item to =
account=20
  for each use was referenced to.&nbsp; I am<BR>pretty certain, =
especially after=20
  reading about it in this forum, and<BR>having it not work, that is NOT =
the=20
  correct way to handle this<BR>situation.<BR><BR>This is my first post =
(and I'm=20
  a bit stressed about this, and it is<BR>1:30) so please try and work =
with me a=20
  bit!!<BR><BR>Thanks so much!!<BR><BR>Andrew =
Spencer</BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0044_01CA6445.F8D637B0--

There you have a problem as Project costs just one file. You will need to 
define some accounting standards. How much of the capital cost are you going 
to allocate to each project until it's paid off?

-- 

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com




<spencera12@yahoo.com> wrote in message 
news:8f63828d-8069-4c8c-85f3-52f1c19f76a9@d5g2000yqm.googlegroups.com...
> Rod,
>
> I figured I didn't give enough info!
>
> I am trying to determine the TOTAL cost to start a business,
> specifically the R&D.  Therefore, I am the accounting, public
> relations, purchasing, engineering, drafting and management
> departments!  Thus, my conundrum!
>
> Andrew
>
> p.s. I am horrible at accounting, therefore I was trying to get it
> into one line.
>
> __________ Information from ESET Smart Security, version of virus 
> signature database 4605 (20091113) __________
>
> The message was checked by ESET Smart Security.
>
> http://www.eset.com
>
>
> 

__________ Information from ESET Smart Security, version of virus signature database 4605 (20091113) __________

The message was checked by ESET Smart Security.

http://www.eset.com

I am not an accountant but the way I think of it is that because capital 
equipment isn't used up in a project the way a bucket of paint or a gallon 
of fuel is, you sort of pay it a salary equal to its straightline 
depreciation.  You buy the welder of $2000 and use it in the project but 
when the current project is done, you can move it over to another project 
and use it there.  The current project shouldn't be totally responsible for 
its cost.

Let's say the your new $2000 welder will need replacing in 5 years.  The 
cost per year is $400.  In many respects, $400 per year is like a salary 
you're paying the welder.  Its cost per hour of use is about 20 cents 
($400/2000hours).  If you use it for 100 hours in this current project, the 
portion of its total cost of ownership born by the current project is $20. 
Other projects you use it in and general business overheads pick up the 
balance.  So in MS Project I would list it as a work resource with a 
standard rate of $400/yr.
-- 
Steve House
MS Project Trainer & Consultant


<spencera12@yahoo.com> wrote in message 
news:7628bdde-269c-487d-860a-64f16c02cdec@j24g2000yqa.googlegroups.com...
>I have been beating my head against the keyboard for two days trying
> to remember how to assign a piece of equipment an initial price.  I am
> running Project Professional 2007.
>
> For example: (yes I know I am missing a million steps to make this
> truly feasible)
> Tasks: (Gantt Chart)
> Making widget
>     Cast aluminum - resources- Me, foundry, aluminum ingots
>     Weld aluminum - resources - Me, wielder, welding rods
>
> Resources:
> Me- we won't worry too much about him
> Foundry - cost $1000 to build and $40 every time I use it
> Aluminum Ingots - cost $10
> Welder - cost $2000 to buy and $10 every time I use it
> Welding rods - cost $1 each
>
> The Aluminum and Rods I can deal with.  They are materials that have a
> cost / use.  Easy enough.  (right???)
> Dealing with the foundry and welder is my problem.  I would like to
> capture that initial cost and a cost per use and have all of the costs
> show up when I go back to my Gantt chart and look at the top line!
>
> Irrelevant background data:
> In my research I found that setting them up as baselines and using a
> separate line item to account for each use was referenced to.  I am
> pretty certain, especially after reading about it in this forum, and
> having it not work, that is NOT the correct way to handle this
> situation.
>
> This is my first post (and I'm a bit stressed about this, and it is
> 1:30) so please try and work with me a bit!!
>
> Thanks so much!!
>
> Andrew Spencer