We are looking to build external (MYSQL based) reports for our (input) program – Inflow Inventory. We currently have Crystal reports but will consider other programs like Excel...for ease of use sake.
9 main general reports with sub reports (switchable by total company/brand & time period). If we will not use excel, the data should be able to be exported to excel & ppt as a table or chart form.
These are the reports we want:
1. Monthly sales (chart)
2. Moving annual total | 12 month sales data (chart)
3. Quarterly sales vs YAGO (chart)
4. Monthly sales analysis vs YAGO (chart)
5. Distribution of business (chart & table. absolute & Percentage)
6. SKU distribution (peso value & units) (month &/or year) (per branch & total company)
7. Average sales per branch | HQ | total company
8. Sales by Kiosk
9. Inventory by location (current)
Attached here are sample pictures & instructions on how we calculate the data.
It would be great if you could demo for me your proposed solution. Please indicate how long it would take to complete this project
Thank you for your time.
17 freelancers are bidding on average ₱6918 for this job
So you need your inventory report in excel form for easy use. Do you have any format? do you use this excel sheet for other application for data exchange? do you also need to show chart on the excel report?
Hello sir , I am expert with php , mysql . I can create report for you and even whcih can be exported using excel format . Please review and let us know your feedback. Regards, [login to view URL]