Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-20-2017, 11:57 AM
mattfromcanada mattfromcanada is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Oct 2017
Posts: 1
mattfromcanada is on a distinguished road
Default Budget Resources / Budget Costs / Hourly Labour


I知 newer to the MS Project scene, particularly to working with resources. I recently was upgraded to MS Project 2016 from MS Project 2000 via server access (yep) so I知 playing catch-up. I work in offsite / pre-fabricated construction, and as the PM I receive the project estimate at the front end. This will include fixed costs (i.e. sub-trade quotes for HVAC / Transport / Electrical) and unit rate costs such as wall framing, flooring install on a Lnft / Sqft rate. Basically all your carpentry type items. When it comes to these Unit Rate items, we either 1) compile a Purchase Order to a sub-contractor (i.e. framer) and essentially this becomes a fixed costs, or our in-house labour would complete the work, which would be done on an hourly basis. When we do issue to a sub-contractor, the costs will be fixed whether it takes them 5 days or 10 days. However, when we do it in-house it痴 less cut & dry. It then becomes an issue of how many man hours we致e completed in house. What I知 trying to do is assign the total amount from the estimate (i.e. the estimate allowed a budget of $1000 to install the ceiling grid/tile) to that line-item on the schedule, and then assign the plant hourly resource at say $50 / hr. Essentially, creating a cost pool that our staff can draw from, and be tracked. I知 hoping it would forecast how much I have remaining from the $1000 based upon the duration. For example, at 8hrs a day, and $50 / hr, I would have 20 hours to complete the work, so if I致e assigned (2) * hr days, I should have $200 left over. Long winded now, so I知 hoping I can get a springboard to start this. As we have a lot of repeat / similar projects, I知 hoping I can come up with a template that would be fairly versatile to my ongoing projects.
Reply With Quote
Reply

Tags
budget, costs, resources

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Budget Cost MAJID Project 1 08-10-2017 07:48 PM
Budget Tracker Excel vill Excel 1 07-11-2017 01:14 PM
Best presentation gear on a budget... Akc123 PowerPoint 0 09-01-2015 11:41 PM
I can't figure out getpivotdata for my monthly budget ThegoLopez Excel 2 01-05-2015 02:59 PM
Income/Budget Calendar? Guinea Excel 4 03-11-2010 09:11 PM


All times are GMT -7. The time now is 04:23 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft