MEGA OPTIMIZER HENRY TANG | JEREMY ZHONG | LEE XIANGRUI | CHEONG - PowerPoint PPT Presentation

THE MEGA OPTIMIZER HENRY TANG | JEREMY ZHONG | LEE XIANGRUI | CHEONG WEIJIA | LEE SITING G14 T7

MEGA DISCOUNT STORE LOCAL ELECTRONIC Retailer LOCATED AT KALLANG LEISURE PARK

3 problems Outdated Manual DATA ENTRY SHEET LACK OF PROFIT MODEL and analysis INEFFICIENT DELIVERY SYSTEM

Black box PERFORMANCE DECISIONS measures - Change in price - Revenue - Change in variable cost - profit Black box - Change in demand consequence Parameters variables - Fixed cost - Product demand - Unit cost of - Required qty purchase

THE SOLUTION

The MEGA OPTIMIZER

CHECKLIST Outdated Manual DATA ENTRY SHEET LACK OF PROFIT MODEL and analysis INEFFICIENt DELIVERY SYSTEM

Outdated Manual DATA ENTRY SHEET Paper based HANDLING SYSTEM - Human errors - ILLEGIBLE HANDWRITING - TIME CONSUMING PROCESS

IMPLEMENT DATA ENTRY SHEET

IMPLEMENT DATA ENTRY SHEET + AUTO POPULATION OF FIELDS + INSTALMENT FUNCTION + AUTO GENERATION OF INVOICES

CHECKLIST Outdated Manual DATA ENTRY SHEET LACK OF PROFIT MODEL and analysis INEFFICIENt DELIVERY SYSTEM

CHECKLIST Outdated Manual DATA ENTRY SHEET LACK OF PROFIT MODEL and analysis INEFFICIENt DELIVERY SYSTEM

LACK OF PROFIT MODEL and analysis PROBLEMs IN PROJECTING SALES - UNABLE TO FORECAST QUANTITY FOR PURCHASE

PROBLEMs IN PROJECTING SALES

PROBLEMs IN PROJECTING SALES INSIGHTS ON OPTIMAL QUANTITY TO purchase Reduce expenditure on inventory storage

LACK OF PROFIT MODEL and analysis LACK OF $ $ Pricing model - UNABLE TO predict and price optimally

LACK OF $ $ Pricing model

LACK OF $ $ Pricing model FLEXIBLE AND ABLE TO ADAPT TO MARKET CHANGES ABLE TO DEDUCE OPTIMAL PRICEs FOR VARIOUS PRODUCTS

LACK OF $ $ Pricing model Validation of model: PROJECTED ACTUAL RESULTS VS NUMBERS

LACK OF $ $ Pricing model Validation of model:

LACK OF PROFIT MODEL and analysis VOLATILE VARIABLE COST - COSTS FLUCTUATE DUE TO PRODUCT LAUNCH

VOLATILE VARIABLE COST

VOLATILE VARIABLE COST FLEXIBLE AND ABLE TO ADAPT TO MARKET CHANGES PROVIDE INSIGHTS ON Percentage of absorption

VOLATILE VARIABLE COST Validation of model: ABSORPTION 45 %

VOLATILE VARIABLE COST How we validate: exhaust every scenario

VOLATILE VARIABLE COST 45 % % x

LACK OF PROFIT MODEL and analysis Lack of + - Breakeven model - Unable to identify the minimum quantity of sales

Lack of + - Breakeven model

CHECKLIST Outdated Manual DATA ENTRY SHEET LACK OF PROFIT MODEL and analysis Inefficient DELIVERY SYSTEM

CHECKLIST Outdated Manual DATA ENTRY SHEET LACK OF PROFIT MODEL and analysis INEFFICIENt DELIVERY SYSTEM

INEFFICIENCY DELIVERY SYSTEM MANUAL PLANNING OF DELIVERY ROUTES - Not optimized - Wastage of time - INCREASED FUEL EXPENDITURE

MANUAL PLANNING OF DELIVERY ROUTES

ACTUAL ROUTE BLK 210 Tampines St 21 Jurong East Bedok North Ave 3 5 Stadium Walk SMU

MANUAL PLANNING OF DELIVERY ROUTES

OPTIMISED ROUTE St 21 Jurong East BLK 210 Tampines Bedok North Ave 3 SMU 5 Stadium Walk

MANUAL PLANNING OF - DELIVERY ROUTES Provide shortest route available (traffic jam) Reduce fuel and time Customer satisfaction é

CHECKLIST Outdated Manual DATA ENTRY SHEET LACK OF PROFIT MODEL and analysis Inefficient DELIVERY SYSTEM

Conclusion Reduce paper work Gain better business insights With financial analysis More efficient delivery routes

THANK YOU