Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-20-2017, 11:57 AM
mattfromcanada mattfromcanada is offline Budget Resources / Budget Costs / Hourly Labour Windows 7 64bit Budget Resources / Budget Costs / Hourly Labour Office 2016
Novice
Budget Resources / Budget Costs / Hourly Labour
 
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
 

Tags
budget, costs, resources



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
Budget Resources / Budget Costs / Hourly Labour 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:40 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft