Hi readers, How to create a great schedule that will also be accurate enough for the project budget? And are there any templates for the project budget around? Let’s explore the different aspects of a budget, see if there are any templates already available and create a template that you can use. The Project Budget What are common items within a Project Budget to start with? There is of course a high degree of Human resource in most projects and these need to be payed. But there are also machine hours, travel costs, maybe there is additional training needed. And there is the material costs that you might get involved in. How does Project allow you to add these costs in a schedule? For work resources we have the option of setting a hourly rate, overtime rate and even a cost at the start of a assignment. The last one might be tricky to understand, but just think of it as a starting fee for work resources such as taxi’s. They start billing you even before the car starts to move;-). For expenses such as travel or other reoccurring costs you could create a specific Cost resource. If you add such a resource to a schedule task it will create a assignment that you can provide with costs. Be aware that the cost resources have some specifics to them,. And if you have one time only costs you could even leave the resources alone and add the costs as “Fixed costs” to the task itself. This is probably the fastest way to add costs, but they aren’t very specific either. But,,, all that being said. These are still just the planned costs, that can change into actuals once progress is reported on tasks. This isn’t really the budget of a project. Jul 18, 2000 Small businesses and home users can now use professional templates from leading experts on Microsoft's. Of the Template Gallery, and Microsoft will. Featured Word Templates. Personal letterhead Word Resume (color) Word APA style report (6th edition) Word Banded design (blank) Word Resume Word Tri-fold brochure (blue) Word Report design (blank) Word Student report with cover photo Word Academic calendar (one month, any year, Sunday start) Word. Introducing the Budget resources There is a specific checkbox that you can set for work and cost resources. This changes the resource to a “Budget resource”. This can be very useful, but you need to be aware of some limitations to the budget resource. The most striking one is that the budget resource can only have an assignment on the project summary level. That means that the budget resources only exist on the top level of a schedule. Making it difficult to have a budget for specific parts in the schedule. To counter this you could create budget resources for each time span you would like to have in the schedule. Maybe you want to monitor budgets on a quarterly basis, or maybe on yearly level is enough for you. The difficulty with this approach is how will you set the budget for the year 2017 and let Project know that you only want to see that budget in that year? Templates that I could find Basically the bulk of what I could find was in Excel (go figure). Here are some of the sites that you can visit and grab inspiration from: • • The main issue I have with all of them is that they aren’t MS Project files/templates. And then there is the “Create a budget” file that you can find in MS Project (I added the file to the as well). It’s a great tutorial file and will help you navigate the different parts of a budget as Microsoft sees it. But hardly useful for a wintered PM. If you click on any of the links, be sure to find the report again by selecting a custom report called “Create a Budget”. My own budget template I created my own Budget template, it’s free to use and available from either or you can and get access to the TPC followers OneDrive, which includes this file among other content. The big difference between other project budget template is that I created a yearly and quarterly cost resource. And views that let’s you put in values per year or per quarter for these resources. I suggest you remove the values you will not use (all yearly, or all quarterly) and build your budget accordingly. There are also a “Total budget costs” and a “Total budget work” resource located on the Project summary task. Use the “Total budget, actuals and forcast” view to get a clear picture of the budget. Read the template manual for more information. It’s included in the TechNet gallery and newsletter OneDrive. Alternatives for Project budget templates Projectum Financials app A light weight Project Server and Project Online solution. It was purchased by Microsoft, but hasn’t made it’s entrance in the tool yet. If you are interested in this app please reach out to Projectum through. UMT 360 As mentioned on their own site “Add financial management capabilities to Microsoft Project Online”. It’s a heavy and complete financial solution, and can be very powerful if you are willing to spend the time and money of implementing it. Find out more about their tool set. Other great blogs about Project budget in MS Project I tend to look around on the web, because I don’t think I know nearly enough about Budgets in MS projects or MS Project in general. There is always someone wiser just around the corner right? So here are some excellent posts by excellent people: • • Nenad Trajkovski has 3 very nice posts., and. Final notes This has been a blast! I liked doing the research on the budget template and searching the valuable content that already exists on the web. And although I didn’t find much on the budget templates in regards to MS Project I liked reading the blog articles from others. And I hope you liked reading mine. If you are looking for more great cost related content how about reading the post. It will surely trigger you and provide you with some valuable information. Other then that, thanks for reading through this post, hope to see you around, Erik van Hurck. The Xerox Services Healthcare Payer Group is a global services organization of more than 860 IT professionals, including 410 software developers. Parent firm Xerox is one of the world’s leading providers of business process and document management services. Situation: The company needed to make global development project teams more cohesive, productive, and competitive. A series of acquisitions had resulted in a mix of third-party and homegrown software development and project management tools and methodologies. Benefits: • Improve productivity up to 40 percent • Reduce IT costs up to 30 percent • Use development resources more flexibly. Arup is the creative force at the heart of many of the world’s most prominent projects in the built environment. From more than 90 offices worldwide, Arup planners, designers, engineers, and consultants deliver innovative projects across the globe. Situation: Arup had a global IT Portfolio Management Office (PMO), but that office had to manually create status reports using spreadsheets and email updates from regional offices. Benefits: • Quick, easy insight into project status • Simple yet effective ideation platform • Anywhere access to project data • Platform for continuous improvement.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
April 2018
Categories |