1 / 74

MRC at Rectella Limited

MRC at Rectella Limited. Andy Hughson Commercial Manager. Who are Rectella? IT Infrastructure Reporting options & needs Why MRC?. Report Examples MRC on Blackberry Stock Man. Case Study Web Ordering Benefits Questions. Agenda. Who are Rectella?.

honey
Télécharger la présentation

MRC at Rectella Limited

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. MRC at Rectella Limited Andy Hughson Commercial Manager

  2. Who are Rectella? IT Infrastructure Reporting options & needs Why MRC? Report Examples MRC on Blackberry Stock Man. Case Study Web Ordering Benefits Questions Agenda

  3. Who are Rectella? • UK’s leading importer & distributor of ready-made soft furnishings • Privately owned limited company • Established in 1947 • 110 employees at head office in Blackburn • 140 employees in retail • Small office in China

  4. Business Profile • Limited UK production – small amount of MTM • Almost all stock now sourced from the Far East • 6,500 SKUs • Fashion industry – 1/3 range replaced every year

  5. Sales & Customer Base Annual Sales • £14 million turnover • 1.2 million units Customers • 300 accounts, 1300 branches • Chain stores, multiples, mail order & independents • Matalan, Debenhams, B&Q, John Lewis, CWS, Dunelm, Littlewoods, BHS

  6. AS400 P10 machine Movex v12.5 RPG Live in August 2003 10 Windows servers MOM MEX BPW Payroll ADS/Firewall MS Exchange Blackberry Web intranet/extranet File share server Backup server 2 staff Applications Support Technical Support IT Infrastructure

  7. In the Beginning. . . Reporting options: • AS/400 Query • Pros: • Useful tool for IT staff • Ad hoc file contents query • Cons: • Inefficient • Experienced IT skills • Machine resource hungry • Not an end-user tool • Inflexible • No run-time prompts • Limited formatting

  8. In the Beginning. . . Reporting options: • BPW • Pros: • Output to Excel • Quick refresh of saved file • Offline from AS/400 • Cons: • Relatively complex to set up • Experienced pivot users • Not really an end-user tool • Inflexible • No run-time prompts • Limited formatting

  9. Rectella’s Reporting Needs • End-user reporting tool • Run-time prompts • Flexible formatting options • Easy to learn and set up • Efficient data handling • Web browser deployment • Good support services • Relatively inexpensive licensing

  10. Known Alternatives • COGNOS PowerPlay • Pros: • Previous IT use/experience • Cons: • Expensive user licensing • Limited end-user knowledge • Similar to BPW methods • Crystal Reports • Pros: • Cheap licensing • Cons: • Little prior experience • Uncertain scope

  11. MRC – A Brief Encounter. . . • MUA Demo – May 2004 • Ticked all the boxes: • End-user reporting tool • Run-time prompts • Flexible formatting options • Easy to learn and set up • Efficient data handling • Web browser deployment • Good support services • Relatively inexpensive licensing • Existing Movex Users: • GBC & Kerrygold

  12. Next steps • Proof of Concept: • FOC • Setup on Rectella’s AS400 • Online Demo • www.crazybikes.com

  13. Why MRC? • We would be able to create: • Data warehouse to summarise large files, e.g. OSBSTD, MITTRA • New data tables & new fields in existing Movex tables • New applications for data maintenance and data enquiries • End-user prompted reports • Intranet for report deployment • Extranet/website for customer access • Simple Low Pricing – Licensed per processor not per user • Dictionary can be configured for end-user report creation • Key Project:TJ Hughes concession management options • Flexible & rapid KPI deployment • “Low-skills based solution with no raw application coding”

  14. Report Examples • Brief look at some reporting examples • Customer Sales • Best Selling Ranges • Product Placement • Top 20 by Retail Store • Order Source

  15. Ex 1: Customer Sales Report Sensitive data Prompts: Payer No. / Customer Name / Product Group

  16. Ex 1: Customer Sales Report Sensitive data Features: monthly columns, 1 pass of 2005 OSBSTD summary file

  17. Ex 2: Best Selling Design/Colour Report Prompts: None

  18. Ex 2: Best Selling Design/Colour Report Features: uses 2 summary files, 7 summaries in all

  19. Ex 3: Product Placement Report Prompts: Design Name, Item Group, Invoice Date Range (Date Picker)

  20. Ex 3: Product Placement Report Sensitive data Features: 1 pass

  21. Ex 4: Top 20 Design/Colours Prompts: Store Name (Drop-down list)

  22. Ex 4: Top 20 Design/Colours Features: Dynamic column month names

  23. Ex 5: Order Source Report Sensitive data Prompts: Customer Name, Order Date Range (Date Picker)

  24. Ex 5: Order Source Report Features: on demand sorting of report output

  25. MRC on Blackberry • Custom Reports written for deployment to Blackberry users in retail • Simple Deployment to existing menu

  26. MRC on Blackberry Example • Safety Stock Report • Prompts: • Store Name • Design Name

  27. MRC on Blackberry Run-time Prompts • Users chooses their Store from the drop-down store list

  28. MRC on Blackberry Run-time Prompts • User enters Design name they are interested in • User scrolls to Run button and initiates report request

  29. MRC on Blackberry Report Output • Designed to fit the limited screen size • Shows Store Number (Movex Warehouse) and Design chosen • Shows Safety Stock for each SKU

  30. MRC on Blackberry Report Output • Scrolling down reveals rest of data and Grand Total

  31. Stock Management Case Study Challenge • 30 TJ Hughes concessions • Optimise retail stock profile • Limited head office resource Solution • Define stock profile rules • Schedule MRC summaries • Produce net change output • Update MITBAL file

  32. Process – Count & Replenish Retail Outlet = Movex Whs Distribution orders shipped Stock records for each store Replenish to Safety Stock Weekly count by exception API update of physical stock

  33. Process – Optimise & Update Net Variance ≡ Sales Update MITBAL using WinSQL MRC table for stocked ranges Review output/ sanity check Nightly schedule MRC summaries Suggested new stock levels

  34. Pillowcases: Min 6 max 12 Tiebacks: Min 2 max 4 Curtains: At least 5 sizes 1 from each width Min 1 max 4 Valances: Size 3 & 5 only Min 1 max 2 Duvet Covers: All sizes Min 2 max 6 Example Output Plan to maintain 6 weeks shelf stock (subject to min/max rules)

  35. Store Summary – Sanity Check

  36. Web Ordering • Requirement: • Low cost B2B website • Features: • Order entry • Simple navigation • Accurate product pricing • Up to date stock availability • Order tracking • Invoice audit trail • Account status information • Flexible user security • Product imagery • Customer/Product views

  37. Solutions Considered • Intentia’s e-Sales • Costs: • Licenses £39k • Development £23k • Maintenance £8k p.a. • Pros: • Existing Movex integration • Existing Movex knowledge • Cons: • Licensed per customer/user (100) • Costs exclude modifications • e-Sales longevity? • Rectella Board perception 

  38. Solutions Considered • MRC • Costs: • Licenses £0 • Development £21k • Maintenance £0k p.a. • Pros: • Prior experience with Raleigh • No additional license/maint. fees • Custom built to our design brief • Open nature of design architecture • Cons: • No additional “out of box” website features 

  39. User login – multiple users per customer

  40. Welcome screen and notice board

  41. Sensitive data Main account status information

  42. Sensitive data Sensitive data Branch links

  43. Sensitive data Branch status information

  44. Design / Colour / Item Group navigation

  45. Designs available for this customer

  46. (Optional) Colours available for this Design

  47. (Optional) Item Groups available for this Design/Colour

  48. Launch the search

  49. Search in progress

  50. Search results – 10 per page

More Related