Digitized Bulk Buying & Forecasting for Floral Events

To streamline bulk buying, inventory tracking, and cost analysis, I developed a structured buying and recipe system that replaced outdated paper-based methods. By leveraging Excel and pivot tables, this new system improved efficiency, accuracy, and accessibility for large-scale event planning and floral purchasing.
Project Overview:
• Digitized Inventory & Purchasing: Transitioned from handwritten notes to a structured Excel-based system for better tracking.
• Improved Bulk Buying Accuracy: Created a system that simplifies ordering, cost calculations, and inventory forecasting.
• Optimized Pricing for Designers: Developed clear pricing templates to make budgeting and purchasing decisions more efficient.
Key Highlights:
✅ Monthly Flower Price List: Created an up-to-date pricing sheet for individual stems and bunches at the retail level for easier cost estimations.
✅ Hardgoods & Supplies Database: Developed a comprehensive cost and retail pricing list for materials, allowing designers to calculate expenses effortlessly.
✅ Custom Buying & Recipe Templates: Designed templates that standardize ordering and inventory tracking for 300+ events.
✅ Pivot Table Integration: Enabled dynamic bulk ordering and inventory management for streamlined purchasing.
This system revolutionized event and inventory management, ensuring greater efficiency, cost transparency, and accuracy in purchasing—allowing designers to focus on creativity while optimizing costs.