We urgently require a well-structured Materials Log to help us track materials across various home renovation projects (bathrooms, kitchens, wardrobes, windows, doors, etc.).
The log must be in Google Sheets and easy for our team to update in real time. It should help us track:
• Job Reference Number (e.g., CR01500)
• Customer Name
• Installation Date
• Project Type (Bathroom / Kitchen / Wardrobe / Windows / Other)
• Material Type (e.g., Glass, Frames, Handles, Hinges, Panels, Worktops, Cabinets)
• Supplier Name
• Quantity Required
• Quantity Ordered
• Quantity Received
• Delivery Date
• Status (Pending / Delivered / Backorder)
• Notes / Issues
• Cost Price
• Total Value of Materials for Job
We want the layout to be clean, intuitive, and colour-coded if possible (e.g., red for delays, green for completed, yellow for pending). This sheet will be used daily, so speed, structure, and clarity are key.
Skills Needed:
• Google Sheets / Excel expert
• Workflow/Operations understanding
• Eye for detail and formatting
• Quick turnaround (within 1-2 hours)
What to include in your proposal:
• Examples of similar tracking sheets/logs you’ve created
• Estimated delivery time
• Any suggestions you have to make this even more efficient |
