PROJECT OVERVIEW I am looking for a developer to build a simple production and inventory tracking system using AppSheet with Google Sheets as the backend. The developer will be responsible for creating both the Google Sheet structure and the AppSheet interface. The system will allow workers to enter daily quantities in a very simple interface. The workers are not highly educated, so the interface must be clean, simple, and not bulky. DATA STRUCTURE (TO BE CREATED) Sheet 1: MASTER_DATA Columns: Product_ID Product_Name Category MRP Sheet 2: INVENTORY_DATA Columns: Date Product_ID Product_Name Production Night_Balance Damage Workers will only enter: Production Night Balance Damage Date should be captured automatically. Sheet 3: DASHBOARD The developer should create a dashboard in Google Sheets with the following sections: Top (KPIs): Total Production Total Sales Total Damage Total Theft Current Inventory Middle (Charts): Sales Trend Theft Trend Damage Trend Bottom (Reports): Top 10 Selling Items Bottom 10 Selling Items Top 10 Theft Items Top 10 Damage Items APP INTERFACE REQUIREMENTS The AppSheet interface must be very simple. Workers should only see product names and enter quantities beside them. Example: Product | Production | Night Balance | Damage Bread | ___ | ___ | ___ Pastry | ___ | ___ | ___ FUNCTIONAL REQUIREMENTS Workers enter daily quantities in AppSheet Entries automatically update Google Sheets Product list comes from MASTER_DATA Dashboard updates automatically DELIVERABLES Configured AppSheet Google Sheets database Connected dashboard and charts