System OverviewItem StructureSupplier ItemSales Amount InformationMonthly Purchase InformationReceive ReportBarcodeSales AmountPurchase PriceReturn ReportMerchandise SystemFront SystemPOS SystemWeight ScaleCommercial SystemAPD System Accounts Payable by DepartmentPeople Soft SystemStore SystemBack Office SystemSales PriceBarcode Sales PricePurchase DataInvoice Not Yet ReceivedCPC SystemInvoice for PaymentSupplierPay Money to SupplierCustomerDaily Sales DataMargin Calculation 毛利计算Where is the margin ? Item Maintenance Page2 (Non-Fresh)毛利计算毛利计算Margin Calculate before VAT :Gross Margin = 100 - Net Cost*100Selling Price*100/(100+VAT)Com. Margin = 100 - Net Cost*(100-Rebate) Selling Price*100/(100+VAT)毛利计算毛利计算Item Maintenance Page3 (Non-Fresh)Margin Calculate before VAT :Gross Margin = 100 - Net Cost*100*Unit Code Selling Price*100/(100+VAT)Com. Margin = 100 - Net Cost*(100-Rebate)*Unit Code Selling Price*100/(100+VAT)毛利计算毛利计算Fresh Products Item Maintenance Page2 (Fresh Products)Margin Calculate before VAT :Gross Margin = 100 - Net Cost*100Selling Price*100/(100+VAT)Com. Margin = 100 - Net Cost*(100-Rebate) Selling Price*100/(100+VAT)Fresh Products Item Maintenance Page3 (Fresh Products)毛利计算毛利计算Margin Calculate before VAT :Gross Margin = 100 - Net Cost*100*Unit Code Selling Price*100/(100+VAT)Com. Margin = 100 - Net Cost*(100-Rebate)*Unit Code Selling Price*100/(100+VAT)Selling Price Promotion Maintenance毛利计算毛利计算Gross Margin :100 - Net Cost x (100 + VAT) PSPDaily Sales Report毛利计算毛利计算ABCD毛利计算毛利计算 A Sales Amount From POS system Include 3 parts Each Day Sales Amount. Each Day Customer Return Amount. Each Day Customer Refund Amount. B Sales Qty. From POS system Include 2 parts Each Day Sales Qty. Each Day Customer Return Qty. C Net Cost Automatic update by P4 system. Daily Margin = A B*CDaily Margin Non Fresh A Sales Amount From POS system Include 3 parts Each Day Sales Amount. Each Day Customer Return Amount. Each Day Customer Refund Amount. D P4 System Selling Price B Sales Qty P4 calculate B = A / D C Net Cost Maintenance directly in P4 for Fresh Products. Automatic update in P4 for Fish & Vegetables. Daily Margin = A - B*C = A (A/D)*C毛利计算毛利计算Daily Margin Fresh Monthly Margin = Sum (Daily Margin) + F + B + C + I F. Monthly Free Goods Adjustment Amount F = Sum (Daily Free Goods Adjustment Qty. * Last Purchase Price) B. Breakage Adjustment Amount B = Sum (Daily Breakage adjustment Qty. * Last Purchase Price) C. Cycle Count Adjustment Amount C = Sum (Daily Cycle Count adjustment Qty. * Last Purchase Price) I. Inventory Adjustment Amount I = Inventory Adjustment Qty. * Last Purchase Price毛利计算毛利计算P4 Monthly Thales Margin毛利计算毛利计算P4 Margin Incorrect Reason:-Wrong Last Purchase Price Solution: Check the Purchase order in P4 before print order and fax to supplier. -Free Goods Solution: Follow the new procedure of free goods. -Wrong Sales(Sales Qty. & Sales Amount) Solution: 1. Cashier scan the item correctly. 2. IT check the unknown barcode sales every day. 3. IT check the P4 daily sales report with turnover report every day. -Deduct Discount in invoice Solution: Do not allow to press discount in invoice. -Fresh Sales Qty. Solution: Manually calculate margin for Fresh Division.