Microsoft Office Forums Budget Resources / Budget Costs / Hourly Labour

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
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
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

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
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

All times are GMT -7. The time now is 02:49 AM.

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