--- description: Find out how you can save costs in your project with the free cost management plan Excel template that we have created for you. image: https://gdm-localsites-assets-gfprod.imgix.net/images/capterra/og_logo-e5a8c001ed0bd1bb922639230fcea71a.png?auto=format%2Cenhance%2Ccompress title: Get resources under control with the cost management plan template --- # Get resources under control with the cost and resource planning template Canonical: https://www.capterra.co.uk/blog/1259/free-cost-and-resource-planning-template Published on 14/03/2023 | Written by Ines Bahr, Sonia Navarrete, Eduardo Garcia. ![Get resources under control with the cost and resource planning template](https://images.ctfassets.net/63bmaubptoky/2SdZBiu8Rluvb0JXYHHTFm/fae07346cc6da9bee99fe3f3e1404d4b/resource_planning_template_-UK-Capterra-Header.png) > This article was originally published on 24/01/2020  How can you use a cost and resource planning template using Excel to manage project resources and avoid scheduling conflicts? How can other tools like Enterprise Resource Planning (ERP) software help business process management? This article covers these topics and guides users on the planning process to help determine resource requirements, allocate resources and adapt an action plan as needed. ----- ## Article Content This article was originally published on 24/01/2020 How can you use a cost and resource planning template using Excel to manage project resources and avoid scheduling conflicts? How can other tools like Enterprise Resource Planning (ERP) software help business process management? This article covers these topics and guides users on the planning process to help determine resource requirements, allocate resources and adapt an action plan as needed.In this articleWhat is a resource planning template?How do you create a resource plan?How to create a resource plan in ExcelWhen carrying out a project, managers often ask themselves questions to ensure everything stays on track. How many employees do I need to complete the project on time? Am I on budget with procurement? What are the unplanned costs of my project? To be able to answer these questions, a cost and resource management plan is carried out in projects to determine the best actions to take. First, let’s start with a definition of the term ‘resource’. A resource is a generic term that can refer to either employees, material or financial resources within a project. And precisely these resources need to be planned as efficiently and effectively as possible in the interest of project success. To help your company, we have created a free cost and resource planning template in Excel for you. What is a resource planning template?A resource planning template is a document or spreadsheet that can help project managers and team leaders plan and allocate resources for a project. These templates usually include information such as the project timeline, the tasks and activities required to complete the project, and the resources that need allocating for each task. These resources include personnel, equipment, and budget. Resource planning templates can help managers assign tasks within a project without creating scheduling conflicts or workload imbalances. Managers also get an overview of who is doing what within a project and the timeline for these activities. Furthermore, the template can be used to ensure that projects have the necessary resources available to complete tasks on schedule. Managers can identify potential resource constraints and bottlenecks and adjust the resource plan accordingly. What is Enterprise Resource Planning?Many businesses seek further help when it comes to planning resources and business processes. Enterprise resource planning (ERP) is a type of software that companies can use to manage and integrate business processes. A key feature of ERP software is that it can help businesses implement resource planning by integrating all the processes needed to run their companies with a single system.ERP systems integrate and centralise data and processes across different functional areas of an organisation, including finance, human resources, manufacturing, supply chain, and customer relationship management.ERP systems typically include a set of modules that can be customised to meet the specific needs of the organisation. These modules can include functions such as accounting, inventory management, procurement, sales and distribution, production planning, and quality control. The modules are designed to work together seamlessly, allowing information to be shared across departments and processes.The benefits of ERP systems include improved efficiency, better data visibility, and increased collaboration across teams. By automating routine tasks and streamlining processes, organisations can reduce costs, improve accuracy, and make more informed decisions based on real-time data.How do you create a resource plan?Creating a cost and resource plan involves several steps. Firstly, a work breakdown structure needs to be made for the Gantt chart to help individual processes into a sequence. Here is a summary of the key steps when creating your resource plan.1. Define the project scope and objectivesThe first step in creating a resource plan is to define the scope of the project, its goals and the processing effort this entails. This will help you identify the resources required to complete the project successfully.2. Identify the tasks and activitiesAfter determining the project scope and objectives, the next step is to identify the tasks and actions required to complete the project. This will help you figure out what resources are needed for each task.3. Determine the resource requirementsOnce you have identified the tasks and activities, you need to determine the resource requirements for each task. This includes identifying the type of resources needed, the quantity required, and for how long these resources will be needed. 4. Choose the best tool for your resource planningProject managers can use either project management software or Excel templates to plan for project costs and resources. While Excel templates are suitable for small projects, project management or project planning software is recommended for larger and more complex projects. One advantage of using software is that it can detect and resolve conflicts related to resourcing through data analysis. The software also generates a Gantt chart that includes all dependencies.5. Allocate resourcesWith the resource requirements clarified, project managers can assign resources and team members to specific tasks. This can require a resource schedule to know when a resource is needed. 6. Monitor and adjust the resource planOnce the resource plan is in place, you need to monitor it regularly and make adjustments as necessary. For example, what happens if a team member is over or under-scheduled? This may involve reallocating resources, changing the resource schedule, or bringing in additional resources if required.Overall, creating a resource plan requires careful planning and coordination to ensure that the right resources are available at the right time to complete the project successfully. Capacity and availability of resources are crucial factors. If an employee is scheduled for more than 100% of their capacity, this is referred to as overload. If this overload occurs because the person is dispatched for two competing or parallel operations, it is a resource conflict. Resource plans should help managers prevent these issues. How to create a resource plan in ExcelA resource action plan template in Excel is a simple way to give you a quick overview of the costs incurred in your project. But how do you use the delivery plan template available in this article? Let us show you how. The template contains three tabs: Basic Data, General Plan and Analysis.Basic DataManagers can use the first tab to enter project-specific framework data. Here, you can enter the general project data and different cost types. Then you can assign the appropriate types, units and costs to project members, services and materials in the Resources box. Under Types, you can differentiate between internal and external costs, whether the units are hourly rates or lump sums. While the hourly rates are fixed for the duration of the project, the flat rates differentiate between planned costs and change costs.General PlanIn the second tab, you can enter all the work packages of your work breakdown structure (WBS) and assign them to the corresponding resource. The resources available for selection are only those that have been stored in the basic data.  The Planned costs area in green allows for the entry of forecast quantities, with the corresponding price calculated automatically. Any changes to costs can be noted in the “unplanned costs” area in red. The field ‘Release on’ only applies to unplanned costs.AnalysisThe Analysis tab allows you to view representations of the plan and resources in pivot tables and charts. Download the free cost and resource planning template here.In conclusion, resource planning is a crucial aspect of project management that requires careful planning and coordination to ensure that the right resources are available at the right time to complete the project successfully. Resource planning templates can help managers assign tasks within a project, avoid scheduling conflicts or workload imbalances, and ensure that projects have the necessary resources available to complete tasks on schedule. Additionally, ERP systems can help businesses implement resource planning by integrating all the processes needed to run their companies with a single system, improving efficiency, data visibility, and collaboration across teams.You can find other free templates here:The Gantt-Chart Excel Template for easy project planningThe Burn Down Diagram – Efficient Tool for Agile TeamsLooking for ERP Software? Check out our catalogue. ## About the authors ### Ines Bahr Ines Bahr is a senior content analyst with nearly 10 years of experience in content marketing and tech trends in the German market. Her research highlights market trends that enable companies to be innovative and keep up with their competitors. She is an expert in helping small and medium-sized businesses find the right software for their needs. In Capterra’s YouTube channel, she presents tool lists that are important for German companies. Her areas of expertise are human resources, cybersecurity, and digitalization strategies. Her digitization tips are based on more than 30 studies she has conducted for German and other markets around the world, and her software product recommendations are based on the analysis of user reviews on Capterra (more than 2 million in total) and follow a precise methodology. Ines research has been published in multiple tier 1 publications, such as Spiegel, Heise, t3n, FAZ, Business Insider, Tagesspiegel, Focus, and Handelsblatt. In addition she has participated in events as a speaker, produced podcasts, and given multiple interviews, e.g. the Digital Bash event and Zielgruppengerecht podcast. ### Sonia Navarrete Sonia is a Senior Content Analyst at Capterra, helping SMEs choose the best software. She published in Raconteur, Computer Weekly and IT Pro. Journalist and PR. ### Eduardo Garcia Eduardo is a Content Analyst for the UK. Providing research and digital tech tips for SMBs. MA in Journalism and in Diplomatic Studies. Animal loving, sea revering, Mancunian. ## Related Categories - [Accounting Software](https://www.capterra.co.uk/directory/1/accounting/software) - [Inventory Management Software](https://www.capterra.co.uk/directory/30006/inventory-management/software) - [MRP System](https://www.capterra.co.uk/directory/30034/mrp/software) - [Task Management Software](https://www.capterra.co.uk/directory/10030/task-management/software) - [Workflow Management Software](https://www.capterra.co.uk/directory/30091/workflow-management/software) ## Related Articles - [5 Key Takeaways From The Switch To Remote Work In the UK](https://www.capterra.co.uk/blog/1471/key-takeaways-from-uk-going-remote) - [Online Teaching Software: A Guide To Tools And Best Practices](https://www.capterra.co.uk/blog/1409/online-teaching-guide-tools-software-best-practices) - [AI in Finance: Applications & benefits](https://www.capterra.co.uk/blog/1945/3-applications-of-finance-ai) - [Short-term rentals, long-term issues: Utilising technology to solve tenant challenges](https://www.capterra.co.uk/blog/6891/short-term-rentals-utilising-tech-to-address-tenant-concerns) - [The impact of the UK economic crisis on consumer spending habits](https://www.capterra.co.uk/blog/3660/consumer-spending-habits-cost-of-living-crisis-UK) ## Links - [View on Capterra](https://www.capterra.co.uk/blog/1259/free-cost-and-resource-planning-template) - [Blog](https://www.capterra.co.uk/blog) - [Home](https://www.capterra.co.uk/) ----- ## Structured Data