Warehouse Fulfillment Cost Tracker

Warehouse Fulfillment Cost Tracker

Total Fulfillment Cost

$0.00

Cost Per Order

$0.00

Total Orders

0

Avg. Labor Cost / Order

$0.00

Cost Breakdown

Cost Per Order Over Time

Fulfillment Log

No fulfillment data to display.

`; } renderBreakdownChart(metrics.costBreakdown); renderTimeChart(metrics.costByDate); }; const renderBreakdownChart = (costBreakdown) => { const ctx = elements.breakdownChartCanvas?.getContext('2d'); if (!ctx) return; const labels = Object.keys(costBreakdown); const data = Object.values(costBreakdown); if (breakdownChart) breakdownChart.destroy(); breakdownChart = new Chart(ctx, { type: 'pie', data: { labels, datasets: [{ label: 'Cost Breakdown', data, backgroundColor: ['#0d9488', '#0ea5e9', '#f43f5e', '#8b5cf6'], hoverOffset: 4 }] }, options: { responsive: true, maintainAspectRatio: true, plugins: { legend: { position: 'top' } } } }); }; const renderTimeChart = (costByDate) => { const ctx = elements.timeChartCanvas?.getContext('2d'); if (!ctx) return; const sortedDates = Object.keys(costByDate).sort((a, b) => new Date(a) - new Date(b)); const chartData = sortedDates.map(date => { const dayData = costByDate[date]; return dayData.orderCount > 0 ? dayData.totalCost / dayData.orderCount : 0; }); if (timeChart) timeChart.destroy(); timeChart = new Chart(ctx, { type: 'line', data: { labels: sortedDates, datasets: [{ label: 'Cost Per Order', data: chartData, borderColor: '#0d9488', backgroundColor: 'rgba(13, 148, 136, 0.1)', fill: true, tension: 0.3 }] }, options: { responsive: true, maintainAspectRatio: true, scales: { y: { ticks: { callback: value => `$${value.toFixed(2)}` } } } } }); }; const renderConfigPanel = () => { const container = elements.editableList; if (!container) return; container.innerHTML = ''; fulfillmentData.forEach(v => { const card = document.createElement('div'); card.className = 'grid grid-cols-1 md:grid-cols-6 gap-4 items-center bg-white p-3 rounded-lg border'; card.innerHTML = `
`; container.appendChild(card); }); }; const handleAddLog = (e) => { e.preventDefault(); try { const getNumericValue = (id) => parseFloat(document.getElementById(id).value) || 0; const newLog = { id: fulfillmentData.length > 0 ? Math.max(...fulfillmentData.map(v => v.id)) + 1 : 1, orderId: document.getElementById('orderId').value, date: document.getElementById('fulfillmentDate').value, labor: getNumericValue('laborCost'), packaging: getNumericValue('packagingCost'), shipping: getNumericValue('shippingCost'), other: getNumericValue('otherCost'), }; fulfillmentData.push(newLog); elements.addForm.reset(); renderAll(); showToast('Fulfillment record added!'); } catch (error) { console.error("Error adding record:", error); showToast("Error: Could not add record."); } }; const handleConfigListClick = (e) => { const target = e.target.closest('button'); if (!target) return; const action = target.dataset.action; const id = parseInt(target.dataset.id, 10); if (action === 'update') { try { const index = fulfillmentData.findIndex(v => v.id === id); if (index === -1) return; const inputs = target.closest('.grid').querySelectorAll('input'); inputs.forEach(input => { const field = input.dataset.field; let value = input.value; if (input.type === 'number') value = parseFloat(value) || 0; fulfillmentData[index][field] = value; }); renderAll(); showToast('Record updated!'); } catch (error) { console.error("Error updating record:", error); showToast("Error: Could not save data."); } } else if (action === 'delete') { fulfillmentData = fulfillmentData.filter(v => v.id !== id); renderAll(); showToast('Record deleted.'); } }; const handleGeneratePDF = () => { try { const { jsPDF } = window.jspdf; const doc = new jsPDF(); const metrics = calculateMetrics(); if (metrics.totalOrders === 0) { showToast("Cannot generate PDF with no data."); return; } doc.setFontSize(20); doc.text("Warehouse Fulfillment Cost Report", 105, 20, null, null, 'center'); doc.setFontSize(10); doc.text(`Generated on: ${new Date().toLocaleDateString()}`, 105, 26, null, null, 'center'); doc.autoTable({ startY: 35, head: [['Metric', 'Value']], body: [ ['Total Fulfillment Cost', `$${metrics.totalCost.toFixed(2)}`], ['Cost Per Order', `$${metrics.costPerOrder.toFixed(2)}`], ['Total Orders', metrics.totalOrders], ['Avg. Labor Cost / Order', `$${metrics.avgLabor.toFixed(2)}`] ], theme: 'grid' }); let finalY = doc.lastAutoTable.finalY || 60; doc.setFontSize(14); doc.text("Cost Breakdown", 14, finalY + 15); doc.addImage(elements.breakdownChartCanvas.toDataURL('image/png', 1.0), 'PNG', 14, finalY + 20, 80, 80); doc.text("Cost Per Order Over Time", 105, finalY + 15); doc.addImage(elements.timeChartCanvas.toDataURL('image/png', 1.0), 'PNG', 105, finalY + 20, 90, 50); finalY += 95; doc.setFontSize(14); doc.text("Fulfillment Log", 14, finalY); const sortedData = [...fulfillmentData].sort((a, b) => new Date(b.date) - new Date(a.date)); const tableBody = sortedData.slice(0, 20).map(v => { const total = v.labor + v.packaging + v.shipping + v.other; return [v.orderId, new Date(v.date).toLocaleDateString(), `$${v.labor.toFixed(2)}`, `$${total.toFixed(2)}`]; }); doc.autoTable({ head: [['Order ID', 'Date', 'Labor Cost', 'Total Cost']], body: tableBody, startY: finalY + 5, theme: 'striped', headStyles: { fillColor: [13, 148, 136] } }); doc.save('Warehouse-Cost-Report.pdf'); } catch (error) { console.error("Failed to generate PDF:", error); showToast("Error: Could not generate PDF."); } }; const switchTab = (tabName) => { currentTab = tabName; Object.values(elements.tabs).forEach(tab => tab.classList.add('hidden')); Object.values(elements.tabButtons).forEach(btn => btn.classList.remove('active')); elements.tabs[tabName].classList.remove('hidden'); elements.tabButtons[tabName].classList.add('active'); updateNavButtons(); }; const navigateTabs = (direction) => { const currentIndex = tabOrder.indexOf(currentTab); const newIndex = direction === 'next' ? Math.min(currentIndex + 1, tabOrder.length - 1) : Math.max(currentIndex - 1, 0); if (newIndex !== currentIndex) switchTab(tabOrder[newIndex]); }; const updateNavButtons = () => { const currentIndex = tabOrder.indexOf(currentTab); elements.navButtons.prev.disabled = currentIndex === 0; elements.navButtons.next.disabled = currentIndex === tabOrder.length - 1; }; const showToast = (message) => { if (!elements.toast) return; elements.toast.textContent = message; elements.toast.classList.add('show'); setTimeout(() => { elements.toast.classList.remove('show'); }, 3000); } elements.addForm.addEventListener('submit', handleAddLog); elements.editableList.addEventListener('click', handleConfigListClick); elements.pdfButton.addEventListener('click', handleGeneratePDF); elements.tabButtons.dashboard.addEventListener('click', () => switchTab('dashboard')); elements.tabButtons.config.addEventListener('click', () => switchTab('config')); elements.navButtons.prev.addEventListener('click', () => navigateTabs('prev')); elements.navButtons.next.addEventListener('click', () => navigateTabs('next')); renderAll(); updateNavButtons(); });
Scroll to Top