
In Progress
Posted
Paid on delivery
Project: Production Planning & Resource Scheduling Tool (Excel / Microsoft 365) Background We are a UK-based coachbuilding and vehicle conversion company carrying out bespoke projects including mobile clinics, outreach vehicles, welfare vehicles and specialist van conversions. We currently use an Excel-based production planner to schedule projects and estimate labour requirements. The existing system works but requires significant manual updating whenever project dates change. We are looking for an experienced Excel / Microsoft 365 specialist with production planning experience to either improve our existing workbook or create a replacement solution. Application Process Please provide examples of similar production planning, resource scheduling, manufacturing, engineering or construction planning tools you have developed. Preference will be given to freelancers with experience in manufacturing, engineering, coachbuilding, fabrication, project-based production or resource scheduling environments rather than purely financial or accounting spreadsheets. Timeline : Bids will be reviewed this week (w/c 15 June) and we will reach out w/c 22 June to discuss further. Project / Rate: This is a one off fixed price project. Please indicate your availability to complete the project, anticipated number of hours and hourly rate and total fee in your application. Scope of file Small file (under 1 mb) , low complexity/simple logic with formatting and data linking. data set small - currently c20 rows of active data on 3 tabs but needs to accommodate scope to expand and add new clients. Objectives The system must provide a simple visual overview of: • Current and future labour capacity • Projects in production (current and potential warm leads in pipeline) • Available labour capacity that can be sold • Labour shortages and resource bottlenecks • Project delivery dates • Employee utilisation The solution must be simple enough for non-technical office and workshop staff to use. Key Requirements Project Planning • Multiple concurrent projects • Project start date • Project delivery date • Estimated labour hours per project • Automatic (Gantt or similar) chart/timeline view • Automatic rescheduling when project dates change Resource Planning • Multiple employees with individual weekly available hours • Labour hours allocated across multiple projects • View labour loading by employee • View labour loading by week/month • Highlight overallocated employees • Highlight spare capacity Capacity Management • Dashboard showing available labour hours by week • Dashboard showing labour shortages by week • Ability to identify future capacity that can be sold to customers • Ability to move project dates and instantly see impact on capacity Ease of Use • Locked formulas and protected worksheets • User enters data only into designated fields • Minimal training required • Cloud-based via Microsoft 365 / SharePoint / Excel Online preferred • Suitable for users with limited Excel knowledge Deliverables • Completed planning tool • User guide • Handover session via Teams • Future modification support if required (please allow for this in your quote) User-Interface (UI) Protection: Preventing team members from typing typos (e.g., forcing standard dates, status dropdowns), including for example: Data Validation Dropdowns: Visual Color-Coding: Sheet Protection: Locking all formula rows with passwords so team members don't accidentally click and type over a formula, breaking the sheet. Automated Error Handling: Ensuring formulas use rules
Project ID: 40520731
86 proposals
Remote project
Active 7 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi there, I understand you need a simple but robust Excel / Microsoft 365 production planning and resource scheduling tool for your coachbuilding and vehicle conversion projects, where your current system works but requires too much manual updating when project dates change. I’m confident I can build a structured, low-maintenance solution that gives clear visibility of labour capacity, project timelines, and utilisation without adding complexity for non-technical users. My approach will be to structure the file into three connected layers. First, a project planning sheet where each job includes start date, delivery date, and estimated labour hours, linked to an automated Gantt-style timeline so any date change instantly updates the schedule. Second, a resource planning layer where each employee has defined weekly available hours, with logic that automatically allocates labour across concurrent projects while flagging overallocation and bottlenecks. Third, a capacity dashboard that summarises weekly and monthly demand vs availability, clearly showing labour shortages and spare capacity that can be sold. To ensure ease of use, I will implement controlled input fields, dropdowns for statuses, strict data validation, and protected formula areas so users only edit safe sections. Before I proceed, do you want this built as an improved Excel workbook only, or should I design it with future Power BI integration in mind? I’m ready to start immediately. Warm Regards, Aneesa
£100 GBP in 2 days
7.6
7.6
86 freelancers are bidding on average £150 GBP for this job

SKIP.
£200 GBP in 21 days
8.7
8.7

⭐⭐⭐⭐⭐ Create an Efficient Production Planning & Resource Scheduling Tool ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project requirements and see you're looking for an Excel/Microsoft 365 specialist to enhance your production planning system. Look no further; Zohaib is here to help you! My team has successfully completed 50+ similar projects for production planning and resource scheduling. I will create a user-friendly tool that automates updates and provides clear insights into labor capacity and project timelines. ➡️ Why Me? I can easily create your production planning tool as I have 5 years of experience in Excel solutions, specializing in production planning, resource scheduling, and data management. My expertise includes creating dynamic dashboards and automated scheduling features. Additionally, I have a strong grip on Microsoft 365 tools, ensuring a smooth and efficient project delivery. ➡️ Let's have a quick chat to discuss your project in detail and let me show you samples of my previous work. I look forward to discussing this with you in our chat. ➡️ Skills & Experience: ✅ Excel Automation ✅ Resource Scheduling ✅ Production Planning ✅ Data Management ✅ Dashboard Creation ✅ Gantt Chart Design ✅ User Interface Design ✅ Data Validation ✅ Error Handling ✅ Project Management ✅ Microsoft 365 ✅ SharePoint Integration Waiting for your response! Best Regards, Zohaib
£150 GBP in 2 days
8.0
8.0

Hi there, ★★★ Excel / Microsoft 365 Expert ★★★ 5+ Years of Experience ★★★ I can create or enhance your production planning tool with a user-friendly interface and automated features. This will include: - Developing a dashboard for labour capacity and shortages. - Implementing automatic rescheduling and Gantt chart views. - Ensuring ease of use for non-technical staff. My approach will involve understanding your current processes and requirements, then designing a solution that meets your needs while being easy to maintain. Ready to start once you provide access to your existing workbook and any specific requirements you have in mind. Thanks!
£210 GBP in 5 days
8.2
8.2

As an experienced freelance developer and specialized Excel expert, I am confident in my ability to enhance your existing production planning and resource scheduling tool or develop a comprehensive replacement tailored to your unique business needs. With over nine years of experience in software architecture and data analysis, I have successfully executed projects similar to yours in manufacturing and engineering environments. My uniquely diverse skill set extends beyond just coding; I prioritize user-friendly solutions which are critical when designing for non-technical office and workshop staff. Moreover, I'm well-versed with Microsoft 365 platforms including SharePoint and Excel Online which aligns perfectly with your preference for a cloud-based solution. And given my understanding of the importance of timely communication and delivery, you can rest assured that your project will be completed within the stipulated time frame with meticulous attention to detail and any future modification support you may require will also be provided. Let's discuss how we can streamline your production planning process for long term efficiency and improved performance. Looking forward to our conversation!
£50 GBP in 1 day
7.6
7.6

Hi, We would like to grab this opportunity and will work till you get 100% satisfied with our work. We are an expert team which have many years of experience on PHP, Project Management, Engineering, Excel, Software Architecture, Process Automation, Data Visualization, Data Analysis, Project Planning, Microsoft 365 Please come over chat and discuss your requirement in a detailed way. Regards
£180 GBP in 7 days
7.2
7.2

Upgrading your coachbuilding production planner... I see you need to replace your manual Excel system with a robust, automated Microsoft 365 resource scheduler that dynamically tracks labour capacity and prevents data-entry errors on the workshop floor. (Note: I have extensive experience building capacity planners for manufacturing and fabrication teams, and I will share portfolio examples of my past schedulers in our chat). Here is my exact execution plan to upgrade your workbook: Automated Gantt & Rescheduling: I will engineer modern dynamic formulas to auto-update project delivery dates and instantly highlight labour bottlenecks or spare capacity when your timelines shift. UI Protection & Error Handling: I will strictly lock all formula rows, enforce data validation drop-downs, and implement visual colour-coding so non-technical staff can update it safely without breaking the logic. Cloud Optimization: I will structure the architecture (your ~20 rows across 3 tabs) specifically for Excel Online and SharePoint, ensuring seamless multi-user access for tracking active projects and warm leads. Quick question: When the system handles the automatic rescheduling for project dates, do you need the formulas to automatically skip weekends and standard UK bank holidays?
£220 GBP in 5 days
7.2
7.2

As an experienced financial analyst with a strong background in data analytics and working knowledge of Excel, I have created numerous tools and models that could effectively address your current production planning concerns. My ability to design complex spreadsheets while keeping them intuitive and easy to use aligns perfectly with your requirement for a user-friendly tool. I understand the importance of viewing the bigger picture while simultaneously focusing on granular details – this skill would be invaluable in creating an automated Gantt chart-style timetable view. As a freelancer, my advantage lies in being adaptable and flexible making it easier for me to rework existing structures or build new models based on your preference and needs. When it comes to the specific resource planning needs you have mentioned,I have been involved in similar projects in manufacturing and engineering domains, implying that I'm well-acquainted with reconciling competing priorities, juggling multiple resources, and balancing resource allocations across various projects. My familiarity with cloud-based storage including Microsoft 365 / SharePoint/ Excel online could be crucial in relatively quick data transfer, format consistency as well as file security maintenance.
£40 GBP in 1 day
7.6
7.6

With over 13 years of experience in creating customized solutions, I am confident that I can build a Production Planning & Resource Scheduling Tool that caters specifically to your unique requirements. My expertise in Python and web automation combined with my experience in data mining, extraction, and AI make me an ideal choice for this project. I have previously developed similar planning tools for manufacturing and engineering industries - skills that I will bring to develop your resource scheduling system. One of my key strengths is building highly user-friendly tools, so even employees unfamiliar with complex software like Excel will find it easy to use the system. Given your preference for a system that can be extended and used by limited-excel knowledge users, my solution would best-fit your needs. Moreover, as a Full-Stack Developer, I am also proficient in cloud-based platforms like Microsoft 365/SharePoint/Excel Online which you consider as preferred. My commitment to long-term support also aligns with your requirements. Should you require further modifications or assistance even after the completion of the project, I am prepared to provide uninterrupted help. Feel free to reach out and let's discuss how we can optimize your production planning and resource scheduling process. Your challenges will be translated into effective and efficient digital solutions!
£30 GBP in 1 day
7.2
7.2

Hello! We can improve your planning tool or build a replacement solution for this workflow. 1. Which part should be handled first: improving the workbook or creating a replacement? 2. Do you already have the current file and workbook structure available? — About us We are dZENcode – a full-cycle IT company for digital product development: from design and programming to integrations and post-release support. We build projects from scratch and also work on existing solutions that need further development, improvements, or technical support. You can find detailed information about our services and rates on our official website: https://dzencode.com. Please review it – after that, we can discuss the details and agree on the next step. ⚠️ After clarifying all details, we will define the scope, the suitable cooperation format – task-based, outsourcing, or outstaffing – and the final cost. Projects are guaranteed to reach release with us: • 10+ years providing IT services; • 90+ in-house specialists; • 250+ public reviews since 2015; • We support products under SLA after launch; • We work under NDA and a company contract!
£135 GBP in 7 days
6.5
6.5

An advanced planning spreadsheet must be engineered as a high-speed, dynamic visual engine that eliminates manual shifting and instantly highlights resource bottlenecks. We will rebuild your system in Excel Online (M365/SharePoint) using dynamic arrays, Lambda functions, and conditional formulas. Here is how we deliver your coachbuilding planning tool: Cascading Timeline: An automated Gantt view. Move a project's start date, and the entire labor forecast instantly shifts across your active matrix. Capacity Dashboard: A visual control panel tracking employee utilization by week. It automatically flags labor shortages, highlights overallocated skills, and isolates sold vs. open capacity. Bulletproof Workshop UI: Password-locked formulas, strict Data Validation dropdowns, and clear color-coding to prevent typos by shop floor staff. Project Logistics: Availability & Hours: Available immediately. Estimated 12–15 hours of engineering. Rate & Total Fee: £30/hr, total fixed price of £450 GBP (includes the M365 file, user guide, live Teams handover, and 30 days of support). We handle manufacturing workflows daily. Let's optimize your workshop's scheduling. Drop me a message in the chat right now to review our custom production dashboards and resource allocation blueprints. Best regards, Waqas Ahmed
£135 GBP in 7 days
6.1
6.1

Hi, I am a full stack AI developer with 8 years of rich experience. I am familiar with Excel, Microsoft 365, Data Analysis, Data Visualization, and Process Automation. For this project, the most important part is creating a planning tool that automatically updates capacity and resource allocation when project schedules change. I can improve the existing workbook or build a new solution with dashboards, resource planning, validation rules, protected formulas, and an easy-to-use interface for non-technical users. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
£250 GBP in 7 days
5.7
5.7

Hi there, I am a Data Scientist I am pleased to submit my bid for your data analysis project. With strong expertise in statistical modeling, data mining, and visualization, I will transform raw datasets into actionable insights to support informed decision-making. Using advanced tools such as Python, R, Power BI, and Excel, I will ensure accurate analysis, clear reporting, and interactive dashboards tailored to your business needs. My approach focuses on data cleaning, trend identification, predictive analysis, and delivering concise summaries that highlight key findings. I am committed to providing high-quality, timely results that add measurable value and help optimize your strategies for growth and efficiency. Let's discuss this further via chat, and I'll start your project right now. Thank you. Gdev
£135 GBP in 7 days
5.7
5.7

Hi, I can upgrade your M365 Excel planner into a fully automated, dynamic scheduling tool tailored for your coachbuilding workflows. Using native Excel Online formulas (like SUMIFS and XLOOKUP) rather than rigid VBA, I will build a self-rescheduling Gantt timeline that instantly visualizes labor capacity, employee utilization, and weekly bottlenecks. The tool will feature strict data validation dropdowns, visual color-coding, and password-protected formula sheets to ensure non-technical workshop staff can update records without breaking the logic. Quick question: Do your bespoke vehicle conversions follow standardized production phases (e.g., Fabrication, Electrical, Fit-out), or are labor hours allocated as a single pool across the project timeline? Let's connect!
£20 GBP in 1 day
5.9
5.9

Hello, I am excited to submit my proposal for upgrading your Production Planning and Resource Scheduling Tool in Excel and Microsoft 365. With extensive experience in advanced Excel development, process automation, and business planning systems, I can enhance your existing tool to improve efficiency, accuracy, and visibility across production operations. My goal is to create a reliable solution that streamlines scheduling, resource allocation, and decision-making. I will analyze your current workflow and tool structure to identify opportunities for optimization. Whether the upgrade involves advanced formulas, Power Query, VBA automation, dynamic dashboards, Microsoft 365 integration, or improved reporting capabilities, I will develop a user-friendly system tailored to your operational requirements. Special attention will be given to data accuracy, scalability, and ease of maintenance to ensure long-term usability. I am committed to delivering a robust and efficient scheduling solution that helps maximize resource utilization and supports production planning objectives. Throughout the project, I will maintain clear communication, provide regular progress updates, and incorporate feedback to ensure the final tool aligns perfectly with your business needs. I look forward to discussing your requirements and contributing to the success of your operations.
£100 GBP in 3 days
5.2
5.2

With over a decade of experience as a freelance Web & Software Developer, I've designed and executed robust, scalable solutions for clients across various industries. I firmly believe in problem-solving through innovation, a value that aligns perfectly with your need for upgrading your excel-based production planning and resource scheduling tool. Though many freelancers possess technical prowess, not all can truly use it to deliver practical solutions. That's where I distinguish myself—I understand that the ultimate goal is to create a system that revolutionizes your process. From project planning and resource allocation, right through to capacity management and user-interface protection, I'm well-versed in every facet of requirement you mentioned. Moreover, given the scope of the project, my expertise in cloud-based solutions using Microsoft 365 / SharePoint / Excel Online can prove invaluable for generating practical, accessible tools even for those with limited Excel knowledge. If chosen for this exciting opportunity, I won't only deliver a comprehensive planning tool matching your brief but would also be available for future modifications or customer support if you ever require it. Let's build a powerful digital solution together that would redefine how your team functions!
£100 GBP in 5 days
5.1
5.1

Hi, I reviewed your Production Planning & Resource Scheduling Tool Upgrade project and can help enhance your existing solution to improve planning accuracy, resource utilization, automation, and reporting. I have experience with Microsoft 365, Excel, VBA, Power Query, Power Pivot, Power Automate, SharePoint, and business planning systems. I have worked on scheduling tools, production planning models, capacity management, resource allocation, forecasting, and operational dashboards. I can help with: • Production planning tool enhancement • Resource scheduling optimization • Excel VBA automation • Power Query & Power Pivot improvements • Capacity planning workflows • Automated reporting & dashboards • Microsoft 365 integration • Data validation & error handling • Performance optimization • Documentation and support A few questions: • Is the current system Excel-only or connected to SharePoint/Power Automate? • What specific improvements are required in the scheduling process? • How many users currently use the tool? • Are there existing performance or reporting issues that need attention? I focus on building reliable, scalable solutions that reduce manual work and improve operational visibility. Thanks
£98 GBP in 7 days
5.5
5.5

Dear Client, Are you looking for an Excel and Microsoft 365 systems expert who can convert your manual production schedule into an automated, dynamic capacity planning tool? I specialize in advanced Excel architecture, dynamic array formulas, interactive Gantt visualizations, and automated resource utilization dashboards for project-based manufacturing. With 10+ years of experience, I can see what you are going to implement for your coachbuilding resource scheduling system. I will implement this by designing an optimized Microsoft 365 Excel workbook fully optimized for SharePoint and Excel Online synchronization. I will construct automated timeline matrices using dynamic formulas so that modifying a project start date instantly shifts the labor distribution and timeline charts without manual intervention. Finally, I will apply strict data validation dropdowns, robust error handling, and password-protected sheet parameters to guarantee that workshop and non-technical staff can only modify designated inputs without breaking the formulas. Should the resource allocation model divide labor hours evenly across the project duration, or do you need the flexibility to manually distribute specific hour blocks per week? I can start immediately and you will never be disappointed. Best regards, Oleksandr
£135 GBP in 7 days
4.9
4.9

Hi, This is the type of planning tool where simplicity and usability are more important than complexity. Based on your description, I would recommend either enhancing the existing workbook or rebuilding it as a structured Microsoft 365 solution using Excel Online and SharePoint friendly features, depending on the current file's limitations. I can create a production planning and resource scheduling tool that automatically recalculates labour capacity, employee utilisation, project timelines, and resource bottlenecks whenever project dates change. The solution would include Gantt style planning views, capacity dashboards, employee loading analysis, shortage alerts, spare capacity visibility, protected worksheets, dropdown driven data entry, validation rules, conditional formatting, and error resistant formulas designed for non technical users. My focus would be on making the tool robust enough for workshop and office staff while keeping it easy to maintain and expand as project volume grows. Documentation, user guide, Teams handover session, and future support can all be included. Best, Justin
£135 GBP in 7 days
5.9
5.9

Hello Mate!Greetings , Good evening! I’ve carefully checked your requirements and really interested in this job. I’m full stack node.js developer working at large-scale apps as a lead developer with U.S. and European teams. I’m offering best quality and highest performance at lowest price. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in React/Redux, Angular JS, Node JS, Ruby on Rails, html/css as well as javascript and jquery. I have rich experienced in Microsoft 365, Data Visualization, Excel, Data Analysis, Project Planning, PHP, Software Architecture, Project Management, Process Automation and Engineering. For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Please respond at your earliest convenience
£150 GBP in 6 days
4.5
4.5

This is a good fit. You need a simple planning tool that removes manual spreadsheet updates and gives staff a clear view of capacity, timelines, and workload. I’ve built Excel/Microsoft 365 tools for planning, tracking, and reporting where non-technical users need protected sheets, clean data entry, and reliable formulas. For your setup, I’d focus on keeping the workbook simple, but making the scheduling logic automatic so date changes flow through the plan without constant rework. I can help shape the workbook into something practical: a clear dashboard for labour capacity, project timelines, overallocations, and spare hours, with locked formulas, dropdowns, and basic error protection so it’s hard to break. I’m comfortable working in Excel Online / SharePoint style setups and can also leave you with a short handover guide and support after delivery if needed. Osama
£250 GBP in 2 days
4.4
4.4

St Helens, United Kingdom
Payment method verified
Member since Jun 17, 2026
$2-8 USD / hour
$15-25 USD / hour
$30-250 USD
$30-250 USD
€250-750 EUR
$1500-3000 USD
$30-250 USD
$25-50 USD / hour
$30-250 USD
$10-30 USD
$250-750 NZD
₹12500-37500 INR
₹750-1250 INR / hour
$2-8 USD / hour
$1500-3000 USD
$10-30 USD
$250-750 USD
₹12500-37500 INR
$30-250 AUD
₹750-1250 INR / hour