Excel Production Inventory Spreadsheet Creation for Bulk Tea Busienss

We are currently seeking an Excel professional to undertake a one-time project to create a comprehensive production inventory spreadsheet and interactive dashboard for our tea business. This project involves designing an intuitive spreadsheet to track various aspects of our production process, including bulk tea powder inventory, daily production quantities, and billing for different sizes and color varieties produced for each brand. Additionally, the dashboard will provide visual representations of the production data, with graphs and adjustable timelines for enhanced analysis. If you have expertise in Excel, a solid understanding of production tracking and inventory management, and experience in creating interactive dashboards, we invite you to apply for this project.

Responsibilities:

-Collaborate with relevant stakeholders to gather information and understand the requirements for the production inventory spreadsheet and interactive dashboard.
-Design and create an Excel spreadsheet that incorporates different sections for tracking various aspects of the production process.
-Set up a section to track and update the inventory of bulk tea powder, considering multiple warehouses and accounting for daily production usage.
-Implement formulas and functions to automatically subtract the daily production quantities from the bulk tea powder inventory.