Production & Inventory Tracking System (AppSheet + Google Sheets)

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