Concept about Cost Analyzer
My company use excel to simulate cost for sales product. But it is hard to manage and share with other people. So I want to make Cost Analyzer system to manage data.
Let’s think about Cost Analyzer system.
- User can manage product
- User can manage category
- User can manage currency
- User can simulate cost
- User can access using web browser & mobile phone
- User can print or export cost simulation result
Here is ERD(Entity Relationship Diagram) about Cost Analayzer system.
categories, products and currencies tables are very simple. Let’s check about cost_simulations table.
|product_id||Product ID which want to simulate|
|target_month||Simulation target month (Will be used for sorting)|
|unit_price||Unit price from supplier|
|currency_id||Currency which will use|
|cif_amount||CIF Amount to simulate tax|
|bm_percent||Tariff percent (BM is the name in Indonesia)|
|bm_amount||Tariff amount (CIF * Tariff percent)|
|bm_unit_price||Tariff unit price (Tariff amount / Qty)|
|pph_percent||Prepaid tax percent (PPh is the name in Indonesia)|
|pph_amount||Prepaid tax amount ((CIF + Tariff amount) * Prepaid tax percent)|
|pph_unit_price||Prepaid tax unit price (Prepaid tax amount / Qty)|
|ppn_percent||VAT percent (PPN is the name in Indonesia)|
|ppn_amount||VAT amount ((CIF + Tariff amount) * VAT percent)|
|ppn_unit_price||VAT unit price (VAT amount / Qty)|
|forwarding_unit_price||Forwarding Fee per product (Forwarding Fee / Qty)|
|gift_price||Additional Gift price if exists|
|retail_margin||Retail margen percent|
Use Laravel Framework. It is the most popular PHP framework in the world and very well structured.
- Bootstrap & AdminLTE theme for UI design
- FontAwesome for icon
- VueJS for Progressive Web
- DataTables for Table
- axios for AJAX request