SLIDE 1
THE
MEGA
OPTIMIZER
HENRY TANG | JEREMY ZHONG | LEE XIANGRUI | CHEONG WEIJIA | LEE SITING G14 T7MEGA DISCOUNT STORE
LOCAL ELECTRONIC Retailer LOCATED AT
KALLANG LEISURE PARK
MEGA OPTIMIZER HENRY TANG | JEREMY ZHONG | LEE XIANGRUI | CHEONG - - PowerPoint PPT Presentation
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
SLIDE 2
SLIDE 3
problems
3
Outdated Manual DATA ENTRY SHEET LACK OF PROFIT MODEL and analysis INEFFICIENT DELIVERY SYSTEM
SLIDE 4
Black box
Black box
DECISIONS Parameters PERFORMANCE measures consequence variables
- Change in price
- Change in variable
cost
- Change in demand
- Fixed cost
- Unit cost of
- Revenue
- profit
- Product demand
- Required qty
purchase
SLIDE 5
THE
SOLUTION
SLIDE 6
The MEGA OPTIMIZER
SLIDE 7
CHECKLIST
Outdated Manual DATA ENTRY SHEET INEFFICIENt DELIVERY SYSTEM LACK OF PROFIT MODEL and analysis
SLIDE 8
Outdated Manual DATA ENTRY SHEET
Paper based
HANDLING SYSTEM
- Human errors
- ILLEGIBLE HANDWRITING
- TIME CONSUMING PROCESS
SLIDE 9
IMPLEMENT
DATA ENTRY SHEET
SLIDE 10
IMPLEMENT
DATA ENTRY SHEET
AUTO POPULATION OF FIELDS INSTALMENT FUNCTION AUTO GENERATION OF INVOICES
+ + +
SLIDE 11
CHECKLIST
Outdated Manual DATA ENTRY SHEET INEFFICIENt DELIVERY SYSTEM LACK OF PROFIT MODEL and analysis
SLIDE 12
CHECKLIST
Outdated Manual DATA ENTRY SHEET INEFFICIENt DELIVERY SYSTEM LACK OF PROFIT MODEL and analysis
SLIDE 13
- UNABLE TO FORECAST
QUANTITY FOR PURCHASE
LACK OF PROFIT MODEL and analysis
PROBLEMs IN
PROJECTING SALES
SLIDE 14
PROBLEMs IN
PROJECTING SALES
SLIDE 15
INSIGHTS ON OPTIMAL QUANTITY TO purchase Reduce expenditure on inventory storage
PROBLEMs IN
PROJECTING SALES
SLIDE 16
- UNABLE TO predict
and price optimally
LACK OF PROFIT MODEL and analysis
LACK OF
Pricing model
$
$
SLIDE 17
LACK OF
Pricing model
$
$
SLIDE 18
LACK OF
Pricing model
$
$
FLEXIBLE AND ABLE TO ADAPT TO MARKET CHANGES ABLE TO DEDUCE OPTIMAL PRICEs FOR VARIOUS PRODUCTS
SLIDE 19
Validation of model:
PROJECTED ACTUAL NUMBERS RESULTS VS
LACK OF
Pricing model
$
$
SLIDE 20
Validation of model:
LACK OF
Pricing model
$
$
SLIDE 21
- COSTS FLUCTUATE DUE TO
PRODUCT LAUNCH
LACK OF PROFIT MODEL and analysis
VOLATILE
VARIABLE COST
SLIDE 22
VOLATILE
VARIABLE COST
SLIDE 23
VOLATILE
VARIABLE COST
FLEXIBLE AND ABLE TO ADAPT TO MARKET CHANGES PROVIDE INSIGHTS ON Percentage of absorption
SLIDE 24
VOLATILE
VARIABLE COST
Validation of model:
45%
ABSORPTION
SLIDE 25
VOLATILE
VARIABLE COST
How we validate: exhaust every scenario
SLIDE 26
x
45%
%
VOLATILE
VARIABLE COST
SLIDE 27
- Unable to identify the
minimum quantity of sales
LACK OF PROFIT MODEL and analysis
Lack of
Breakeven model
+ -
SLIDE 28
Lack of
Breakeven model
+ -
SLIDE 29
CHECKLIST
Outdated Manual DATA ENTRY SHEET Inefficient DELIVERY SYSTEM LACK OF PROFIT MODEL and analysis
SLIDE 30
CHECKLIST
INEFFICIENt DELIVERY SYSTEM Outdated Manual DATA ENTRY SHEET LACK OF PROFIT MODEL and analysis
SLIDE 31
SLIDE 32
- Not optimized
- Wastage of time
- INCREASED FUEL
EXPENDITURE
MANUAL PLANNING OF
DELIVERY ROUTES
INEFFICIENCY DELIVERY SYSTEM
SLIDE 33
MANUAL PLANNING OF
DELIVERY ROUTES
SLIDE 34
ACTUAL ROUTE
5 Stadium Walk Bedok North Ave 3 St 21 Jurong East BLK 210 Tampines SMU SLIDE 35
MANUAL PLANNING OF
DELIVERY ROUTES
SLIDE 36
OPTIMISED ROUTE
5 Stadium Walk SMU St 21 Jurong East BLK 210 Tampines Bedok North Ave 3 SLIDE 37
- Provide shortest route
available (traffic jam) Reduce fuel and time Customer satisfaction é
MANUAL PLANNING OF
DELIVERY ROUTES
SLIDE 38
CHECKLIST
Outdated Manual DATA ENTRY SHEET Inefficient DELIVERY SYSTEM LACK OF PROFIT MODEL and analysis
SLIDE 39
Conclusion
Gain better business insights With financial analysis More efficient delivery routes Reduce paper work
SLIDE 40