際際滷

際際滷Share a Scribd company logo
KNOWLEDGE IN A CAN OF BEANS




                   息 Ross Hilton
KNOWLEDGE IN A CAN OF BEANS

WHAT HAPPENS:


     The can is scanned at the
            checkout.

     The barcode informs the
     scanner what the product
               is.

      An entire chain of events
          takes place in a
           microsecond.
KNOWLEDGE IN A CAN OF BEANS

WHAT HAPPENS:


      A record of the sale is
      sent to a transactional
            data store.

      This stores short term
       transaction records
        for the individual
              store.
KNOWLEDGE IN A CAN OF BEANS

WHAT HAPPENS:




    An amortised report is sent to
          an ERP system.

       Stock holding levels are
       monitored, a new can is
             reordered.
KNOWLEDGE IN A CAN OF BEANS

WHAT HAPPENS:

  An amortised report is sent to a
   BPM system. Stock turnover is
     analysed against checkout
  position, staff member, product
  placement. Marketing campaign,
  time of sale, day of sale, season
  of sale, date of sale. A series of
  statistical predictions are made.

  These item reports may be made
   available to the supplier, store
   manager, HR staff, marketing
          department, etc.
KNOWLEDGE IN A CAN OF BEANS

WHAT HAPPENS:


          A record of sale is sent to
       finance system. The profit on
            the sale is lodged, the
       transfer from stock to capital
        is made. Capital is allocated
           for replacement stocks.
KNOWLEDGE IN A CAN OF BEANS

WHAT HAPPENS:



     A record is sent
     to the EDW. It is
       stored for 10
     years. Historical
      data from this
     EDW is used for
      trend analysis.
KNOWLEDGE IN A CAN OF BEANS

WHAT WE KNOW:
    FINANCIAL MANAGEMENT
     Financial management know that beans have a 55%
    profit markup, an average shelf life of 12 days and are
    the 28th most profitable items in the store.

     They know that beans account for 0.5% of the
    profitability of the chain of supermarkets.
KNOWLEDGE IN A CAN OF BEANS

WHAT WE KNOW:
   PRODUCT LINE MANAGEMENT
    Product line managers know that more cans of beans are sold
   between 4 and 6 pm on Thursdays than any other day.

     They know that bean can sales are up 3% on last month, but
    down 4% compared to this day last year.

     Seasonal trends show bean sales are declining over the last 5
    years.

     They know that when the "Bean Can" promotion was on store
    bean can sales increased by 2%.

     They know that when bean cans were in isle 5 sales fell by 12%.
KNOWLEDGE IN A CAN OF BEANS

WHAT WE KNOW:
   HR MANAGEMENT
    HR management knows that Debbie on the Checkout handles
   more customers at the end of her Thursday shift than on any
   other day.

    They know her performance compared to the rest of the staff
   has declined in the last 3 months.

    They know that there was a 45 second gap between scanning
   each can of beans.
KNOWLEDGE IN A CAN OF BEANS

WHAT WE KNOW:
   SHIFT MANAGER
    They can plot Debbie's work performance, hour by hour,
   day by day.

    They can compare Debbie's performance against other
   workers, or against her performance for the same period last
   year.

    They can map Debbie's performance against internal events
   (store layout restructure, new manger, new colleagues etc) or
   external factors (wet days, prior or post holidays, day after
   payday etc).
KNOWLEDGE IN A CAN OF BEANS

WHAT WE KNOW:
  SHOPFRONT MANAGEMENT
   Shopfront management know that number 6 checkout
  position sells more canned products between 4 and 6pm on
  Thursdays than any other.

   They know that on Thursday evenings more customers buy
  beans from isle 6 than from any other area of the
  supermarket.

   They know that when the "Bean Can" promotion was on
  bean can sales increased by 2%.

   They know that when bean cans were in isle 5 sales fell by
  12%.
KNOWLEDGE IN A CAN OF BEANS

WHAT WE KNOW:


   SHOPFRONT MANAGEMENT (Cont)

     They know the next customer didn't have products
    scanned until 4 minutes after I paid for the can.

     They know number 6 checkout is the most unprofitable
    on Thursday evenings.
KNOWLEDGE IN A CAN OF BEANS
WHAT WE KNOW:
   MARKETING
    Marketing know that on Thursday evenings more customers
   buy beans than any other canned food product.

     They know that when the "Bean Can" promotion was on bean
    can sales increased by 7%.

     They know that some stores performed better than others
    during the promotion.

     They know that isle placement of beans can alter sales by as
    much as 25%.

     Seasonal trends show bean sales are declining over the last 5
    years in most stores.

More Related Content

Viewers also liked (8)

Financial Audit Leadership and Management
Financial Audit Leadership and ManagementFinancial Audit Leadership and Management
Financial Audit Leadership and Management
Ross Hilton
Johanna ticsJohanna tics
Johanna tics
johanita Mu単oz
4 x4 project_delivery_outline[1]
4 x4 project_delivery_outline[1]4 x4 project_delivery_outline[1]
4 x4 project_delivery_outline[1]
Ross Hilton
Foolproof Business Intelligence
Foolproof Business IntelligenceFoolproof Business Intelligence
Foolproof Business Intelligence
Ross Hilton
犖犢犖犖÷弦犖ム肩犖迦牽犖犖幡犖犖2
犖犢犖犖÷弦犖ム肩犖迦牽犖犖幡犖犖2犖犢犖犖÷弦犖ム肩犖迦牽犖犖幡犖犖2
犖犢犖犖÷弦犖ム肩犖迦牽犖犖幡犖犖2
wilailuk4065
Rx for iOS App. RxMVVM-DataCenter!
Rx for iOS App. RxMVVM-DataCenter!Rx for iOS App. RxMVVM-DataCenter!
Rx for iOS App. RxMVVM-DataCenter!
SUNGCHEOL KIM
Indonesian coal 1
Indonesian coal 1Indonesian coal 1
Indonesian coal 1
Ross Hilton
An Aspect of My Life
An Aspect of My LifeAn Aspect of My Life
An Aspect of My Life
Jenna Wiley
Financial Audit Leadership and Management
Financial Audit Leadership and ManagementFinancial Audit Leadership and Management
Financial Audit Leadership and Management
Ross Hilton
Johanna ticsJohanna tics
Johanna tics
johanita Mu単oz
4 x4 project_delivery_outline[1]
4 x4 project_delivery_outline[1]4 x4 project_delivery_outline[1]
4 x4 project_delivery_outline[1]
Ross Hilton
Foolproof Business Intelligence
Foolproof Business IntelligenceFoolproof Business Intelligence
Foolproof Business Intelligence
Ross Hilton
犖犢犖犖÷弦犖ム肩犖迦牽犖犖幡犖犖2
犖犢犖犖÷弦犖ム肩犖迦牽犖犖幡犖犖2犖犢犖犖÷弦犖ム肩犖迦牽犖犖幡犖犖2
犖犢犖犖÷弦犖ム肩犖迦牽犖犖幡犖犖2
wilailuk4065
Rx for iOS App. RxMVVM-DataCenter!
Rx for iOS App. RxMVVM-DataCenter!Rx for iOS App. RxMVVM-DataCenter!
Rx for iOS App. RxMVVM-DataCenter!
SUNGCHEOL KIM
Indonesian coal 1
Indonesian coal 1Indonesian coal 1
Indonesian coal 1
Ross Hilton
An Aspect of My Life
An Aspect of My LifeAn Aspect of My Life
An Aspect of My Life
Jenna Wiley

Similar to The knowledge in a can of beans (20)

iKEG IS NOW A REALITY
iKEG IS NOW A REALITYiKEG IS NOW A REALITY
iKEG IS NOW A REALITY
Michael Williams
Nimishpantpepsicosip 111106000558-phpapp02
Nimishpantpepsicosip 111106000558-phpapp02Nimishpantpepsicosip 111106000558-phpapp02
Nimishpantpepsicosip 111106000558-phpapp02
Karmveer Singh
Stock Management at Big Bazaar
Stock Management at Big BazaarStock Management at Big Bazaar
Stock Management at Big Bazaar
romeo_reet
Sap Implemented in a Cereal Company ( German Market)
Sap Implemented in a Cereal Company ( German Market)Sap Implemented in a Cereal Company ( German Market)
Sap Implemented in a Cereal Company ( German Market)
Ramon Savi単on
Small Format Academy Fresh 3
Small Format Academy Fresh 3Small Format Academy Fresh 3
Small Format Academy Fresh 3
Gavin Zeff
Restaurant Manager Operational Audit
Restaurant Manager Operational Audit Restaurant Manager Operational Audit
Restaurant Manager Operational Audit
Shelley Cull
Big Bazaar
Big Bazaar Big Bazaar
Big Bazaar
DONPAUL1991
Shopper Insights Wine09
Shopper Insights Wine09Shopper Insights Wine09
Shopper Insights Wine09
Fortune & Associates
Merchandise Management
Merchandise ManagementMerchandise Management
Merchandise Management
Heleen Mills
Shan foods
Shan foodsShan foods
Shan foods
Syed Jabbar Ali Shah
shopper marketing discussion 2-17-11 afternoon
shopper marketing discussion 2-17-11 afternoonshopper marketing discussion 2-17-11 afternoon
shopper marketing discussion 2-17-11 afternoon
Jim Holbrook
Bounty Box Stanford 2015
Bounty Box Stanford 2015Bounty Box Stanford 2015
Bounty Box Stanford 2015
Stanford University
Funky Fruit Stanford 2015
Funky Fruit Stanford 2015Funky Fruit Stanford 2015
Funky Fruit Stanford 2015
Stanford University
Work History
Work HistoryWork History
Work History
James Abraham
How to map a sales process
How to map a sales processHow to map a sales process
How to map a sales process
The Friday Times
Supply chain management - Retail Industry (MBA)
Supply chain management - Retail Industry (MBA)Supply chain management - Retail Industry (MBA)
Supply chain management - Retail Industry (MBA)
Dinesh Pal
Strategic Inventory Planning for the Holiday Shopping Rush
Strategic Inventory Planning for the Holiday Shopping RushStrategic Inventory Planning for the Holiday Shopping Rush
Strategic Inventory Planning for the Holiday Shopping Rush
Tinuiti
13 frl rising-food-costs
13 frl rising-food-costs13 frl rising-food-costs
13 frl rising-food-costs
Warren Dietel
Managing your enterprise growth by numbers by Vinod Keni | #TiEInstitute
Managing your enterprise growth by numbers by Vinod Keni | #TiEInstituteManaging your enterprise growth by numbers by Vinod Keni | #TiEInstitute
Managing your enterprise growth by numbers by Vinod Keni | #TiEInstitute
tiemumbai
Resume for Business Manager
Resume for Business ManagerResume for Business Manager
Resume for Business Manager
Bhuvnendra Bhati
Nimishpantpepsicosip 111106000558-phpapp02
Nimishpantpepsicosip 111106000558-phpapp02Nimishpantpepsicosip 111106000558-phpapp02
Nimishpantpepsicosip 111106000558-phpapp02
Karmveer Singh
Stock Management at Big Bazaar
Stock Management at Big BazaarStock Management at Big Bazaar
Stock Management at Big Bazaar
romeo_reet
Sap Implemented in a Cereal Company ( German Market)
Sap Implemented in a Cereal Company ( German Market)Sap Implemented in a Cereal Company ( German Market)
Sap Implemented in a Cereal Company ( German Market)
Ramon Savi単on
Small Format Academy Fresh 3
Small Format Academy Fresh 3Small Format Academy Fresh 3
Small Format Academy Fresh 3
Gavin Zeff
Restaurant Manager Operational Audit
Restaurant Manager Operational Audit Restaurant Manager Operational Audit
Restaurant Manager Operational Audit
Shelley Cull
Merchandise Management
Merchandise ManagementMerchandise Management
Merchandise Management
Heleen Mills
shopper marketing discussion 2-17-11 afternoon
shopper marketing discussion 2-17-11 afternoonshopper marketing discussion 2-17-11 afternoon
shopper marketing discussion 2-17-11 afternoon
Jim Holbrook
How to map a sales process
How to map a sales processHow to map a sales process
How to map a sales process
The Friday Times
Supply chain management - Retail Industry (MBA)
Supply chain management - Retail Industry (MBA)Supply chain management - Retail Industry (MBA)
Supply chain management - Retail Industry (MBA)
Dinesh Pal
Strategic Inventory Planning for the Holiday Shopping Rush
Strategic Inventory Planning for the Holiday Shopping RushStrategic Inventory Planning for the Holiday Shopping Rush
Strategic Inventory Planning for the Holiday Shopping Rush
Tinuiti
13 frl rising-food-costs
13 frl rising-food-costs13 frl rising-food-costs
13 frl rising-food-costs
Warren Dietel
Managing your enterprise growth by numbers by Vinod Keni | #TiEInstitute
Managing your enterprise growth by numbers by Vinod Keni | #TiEInstituteManaging your enterprise growth by numbers by Vinod Keni | #TiEInstitute
Managing your enterprise growth by numbers by Vinod Keni | #TiEInstitute
tiemumbai
Resume for Business Manager
Resume for Business ManagerResume for Business Manager
Resume for Business Manager
Bhuvnendra Bhati

Recently uploaded (20)

Mac to Windows QuickBooks File Conversion Guide
Mac to Windows QuickBooks File Conversion GuideMac to Windows QuickBooks File Conversion Guide
Mac to Windows QuickBooks File Conversion Guide
dennislopez2310
CTG- Cap nhat KQKD Quy 4.2024_website_EN.pptx
CTG- Cap nhat KQKD Quy 4.2024_website_EN.pptxCTG- Cap nhat KQKD Quy 4.2024_website_EN.pptx
CTG- Cap nhat KQKD Quy 4.2024_website_EN.pptx
ngothithungan1
BUSINESS CORRESPONDENCE - UNIT III notes
BUSINESS CORRESPONDENCE - UNIT III notesBUSINESS CORRESPONDENCE - UNIT III notes
BUSINESS CORRESPONDENCE - UNIT III notes
manikandansMani2
Saraf Furniture Reviews Is It Worth Your Money
Saraf Furniture Reviews Is It Worth Your MoneySaraf Furniture Reviews Is It Worth Your Money
Saraf Furniture Reviews Is It Worth Your Money
Saraf Furniture
Comments on Franchise and License Parts I and II.pdf
Comments on Franchise and License Parts I and II.pdfComments on Franchise and License Parts I and II.pdf
Comments on Franchise and License Parts I and II.pdf
Brij Consulting, LLC
Carborundum Universal - Business Analysis | NSE:CARBORUNIV | FY2024
Carborundum Universal - Business Analysis | NSE:CARBORUNIV | FY2024Carborundum Universal - Business Analysis | NSE:CARBORUNIV | FY2024
Carborundum Universal - Business Analysis | NSE:CARBORUNIV | FY2024
Business Analysis
Wondershare Dr. Fone 13.5.5 Crack + License Key [Latest] Donwload
Wondershare Dr. Fone 13.5.5 Crack + License Key [Latest] DonwloadWondershare Dr. Fone 13.5.5 Crack + License Key [Latest] Donwload
Wondershare Dr. Fone 13.5.5 Crack + License Key [Latest] Donwload
borikhni
GOM Player Plus Free crack Download .
GOM  Player Plus  Free  crack  Download .GOM  Player Plus  Free  crack  Download .
GOM Player Plus Free crack Download .
sgabar822
Carousel - Five Key FinTech Trends in 2025
Carousel - Five Key FinTech Trends in 2025Carousel - Five Key FinTech Trends in 2025
Carousel - Five Key FinTech Trends in 2025
Anadea
Q4 Lesson 1 TLE 7 industrial arts for grade seen
Q4 Lesson 1 TLE 7 industrial arts for grade seenQ4 Lesson 1 TLE 7 industrial arts for grade seen
Q4 Lesson 1 TLE 7 industrial arts for grade seen
CamilleAnneCarlos
Vue vs React In-Depth Comparison of 2 Leading JavaScript Frameworks
Vue vs React In-Depth Comparison of 2 Leading JavaScript FrameworksVue vs React In-Depth Comparison of 2 Leading JavaScript Frameworks
Vue vs React In-Depth Comparison of 2 Leading JavaScript Frameworks
Pixlogix Infotech
Amazon SEO Services: Optimize, Rank Higher & Sell More
Amazon SEO Services: Optimize, Rank Higher & Sell MoreAmazon SEO Services: Optimize, Rank Higher & Sell More
Amazon SEO Services: Optimize, Rank Higher & Sell More
Faith eCommerce Services
Birth Flowers for the Month of March: Daffodil & Jonquil
Birth Flowers for the Month of March: Daffodil & JonquilBirth Flowers for the Month of March: Daffodil & Jonquil
Birth Flowers for the Month of March: Daffodil & Jonquil
allen flower
Realizing the Promise of AI .pdf
Realizing the Promise of AI .pdfRealizing the Promise of AI .pdf
Realizing the Promise of AI .pdf
Auxis Consulting & Outsourcing
TopMate ES10: Effortless Mobility for Everyone
TopMate ES10: Effortless Mobility for EveryoneTopMate ES10: Effortless Mobility for Everyone
TopMate ES10: Effortless Mobility for Everyone
Topmate
20x40 Trade Show Booth Rental Company | RADON LLC
20x40 Trade Show Booth Rental Company | RADON LLC20x40 Trade Show Booth Rental Company | RADON LLC
20x40 Trade Show Booth Rental Company | RADON LLC
RADON LLC
Proof Strategies CanTrust Index 2025 Report
Proof Strategies CanTrust Index 2025 ReportProof Strategies CanTrust Index 2025 Report
Proof Strategies CanTrust Index 2025 Report
Proof
Tran Quoc Bao: Advisory Board Member of Asian Hospital & Healthcare Managemen...
Tran Quoc Bao: Advisory Board Member of Asian Hospital & Healthcare Managemen...Tran Quoc Bao: Advisory Board Member of Asian Hospital & Healthcare Managemen...
Tran Quoc Bao: Advisory Board Member of Asian Hospital & Healthcare Managemen...
Ignite Capital
What is Included in a Purplegator Marketing Agency &. Consultants Branding Book
What is Included in a Purplegator Marketing Agency &. Consultants Branding BookWhat is Included in a Purplegator Marketing Agency &. Consultants Branding Book
What is Included in a Purplegator Marketing Agency &. Consultants Branding Book
Purplegator
Clear the Air How to Choose the Perfect Extractor Fan.pptx
Clear the Air How to Choose the Perfect Extractor Fan.pptxClear the Air How to Choose the Perfect Extractor Fan.pptx
Clear the Air How to Choose the Perfect Extractor Fan.pptx
Meteor Electrical
Mac to Windows QuickBooks File Conversion Guide
Mac to Windows QuickBooks File Conversion GuideMac to Windows QuickBooks File Conversion Guide
Mac to Windows QuickBooks File Conversion Guide
dennislopez2310
CTG- Cap nhat KQKD Quy 4.2024_website_EN.pptx
CTG- Cap nhat KQKD Quy 4.2024_website_EN.pptxCTG- Cap nhat KQKD Quy 4.2024_website_EN.pptx
CTG- Cap nhat KQKD Quy 4.2024_website_EN.pptx
ngothithungan1
BUSINESS CORRESPONDENCE - UNIT III notes
BUSINESS CORRESPONDENCE - UNIT III notesBUSINESS CORRESPONDENCE - UNIT III notes
BUSINESS CORRESPONDENCE - UNIT III notes
manikandansMani2
Saraf Furniture Reviews Is It Worth Your Money
Saraf Furniture Reviews Is It Worth Your MoneySaraf Furniture Reviews Is It Worth Your Money
Saraf Furniture Reviews Is It Worth Your Money
Saraf Furniture
Comments on Franchise and License Parts I and II.pdf
Comments on Franchise and License Parts I and II.pdfComments on Franchise and License Parts I and II.pdf
Comments on Franchise and License Parts I and II.pdf
Brij Consulting, LLC
Carborundum Universal - Business Analysis | NSE:CARBORUNIV | FY2024
Carborundum Universal - Business Analysis | NSE:CARBORUNIV | FY2024Carborundum Universal - Business Analysis | NSE:CARBORUNIV | FY2024
Carborundum Universal - Business Analysis | NSE:CARBORUNIV | FY2024
Business Analysis
Wondershare Dr. Fone 13.5.5 Crack + License Key [Latest] Donwload
Wondershare Dr. Fone 13.5.5 Crack + License Key [Latest] DonwloadWondershare Dr. Fone 13.5.5 Crack + License Key [Latest] Donwload
Wondershare Dr. Fone 13.5.5 Crack + License Key [Latest] Donwload
borikhni
GOM Player Plus Free crack Download .
GOM  Player Plus  Free  crack  Download .GOM  Player Plus  Free  crack  Download .
GOM Player Plus Free crack Download .
sgabar822
Carousel - Five Key FinTech Trends in 2025
Carousel - Five Key FinTech Trends in 2025Carousel - Five Key FinTech Trends in 2025
Carousel - Five Key FinTech Trends in 2025
Anadea
Q4 Lesson 1 TLE 7 industrial arts for grade seen
Q4 Lesson 1 TLE 7 industrial arts for grade seenQ4 Lesson 1 TLE 7 industrial arts for grade seen
Q4 Lesson 1 TLE 7 industrial arts for grade seen
CamilleAnneCarlos
Vue vs React In-Depth Comparison of 2 Leading JavaScript Frameworks
Vue vs React In-Depth Comparison of 2 Leading JavaScript FrameworksVue vs React In-Depth Comparison of 2 Leading JavaScript Frameworks
Vue vs React In-Depth Comparison of 2 Leading JavaScript Frameworks
Pixlogix Infotech
Amazon SEO Services: Optimize, Rank Higher & Sell More
Amazon SEO Services: Optimize, Rank Higher & Sell MoreAmazon SEO Services: Optimize, Rank Higher & Sell More
Amazon SEO Services: Optimize, Rank Higher & Sell More
Faith eCommerce Services
Birth Flowers for the Month of March: Daffodil & Jonquil
Birth Flowers for the Month of March: Daffodil & JonquilBirth Flowers for the Month of March: Daffodil & Jonquil
Birth Flowers for the Month of March: Daffodil & Jonquil
allen flower
TopMate ES10: Effortless Mobility for Everyone
TopMate ES10: Effortless Mobility for EveryoneTopMate ES10: Effortless Mobility for Everyone
TopMate ES10: Effortless Mobility for Everyone
Topmate
20x40 Trade Show Booth Rental Company | RADON LLC
20x40 Trade Show Booth Rental Company | RADON LLC20x40 Trade Show Booth Rental Company | RADON LLC
20x40 Trade Show Booth Rental Company | RADON LLC
RADON LLC
Proof Strategies CanTrust Index 2025 Report
Proof Strategies CanTrust Index 2025 ReportProof Strategies CanTrust Index 2025 Report
Proof Strategies CanTrust Index 2025 Report
Proof
Tran Quoc Bao: Advisory Board Member of Asian Hospital & Healthcare Managemen...
Tran Quoc Bao: Advisory Board Member of Asian Hospital & Healthcare Managemen...Tran Quoc Bao: Advisory Board Member of Asian Hospital & Healthcare Managemen...
Tran Quoc Bao: Advisory Board Member of Asian Hospital & Healthcare Managemen...
Ignite Capital
What is Included in a Purplegator Marketing Agency &. Consultants Branding Book
What is Included in a Purplegator Marketing Agency &. Consultants Branding BookWhat is Included in a Purplegator Marketing Agency &. Consultants Branding Book
What is Included in a Purplegator Marketing Agency &. Consultants Branding Book
Purplegator
Clear the Air How to Choose the Perfect Extractor Fan.pptx
Clear the Air How to Choose the Perfect Extractor Fan.pptxClear the Air How to Choose the Perfect Extractor Fan.pptx
Clear the Air How to Choose the Perfect Extractor Fan.pptx
Meteor Electrical

The knowledge in a can of beans

  • 1. KNOWLEDGE IN A CAN OF BEANS 息 Ross Hilton
  • 2. KNOWLEDGE IN A CAN OF BEANS WHAT HAPPENS: The can is scanned at the checkout. The barcode informs the scanner what the product is. An entire chain of events takes place in a microsecond.
  • 3. KNOWLEDGE IN A CAN OF BEANS WHAT HAPPENS: A record of the sale is sent to a transactional data store. This stores short term transaction records for the individual store.
  • 4. KNOWLEDGE IN A CAN OF BEANS WHAT HAPPENS: An amortised report is sent to an ERP system. Stock holding levels are monitored, a new can is reordered.
  • 5. KNOWLEDGE IN A CAN OF BEANS WHAT HAPPENS: An amortised report is sent to a BPM system. Stock turnover is analysed against checkout position, staff member, product placement. Marketing campaign, time of sale, day of sale, season of sale, date of sale. A series of statistical predictions are made. These item reports may be made available to the supplier, store manager, HR staff, marketing department, etc.
  • 6. KNOWLEDGE IN A CAN OF BEANS WHAT HAPPENS: A record of sale is sent to finance system. The profit on the sale is lodged, the transfer from stock to capital is made. Capital is allocated for replacement stocks.
  • 7. KNOWLEDGE IN A CAN OF BEANS WHAT HAPPENS: A record is sent to the EDW. It is stored for 10 years. Historical data from this EDW is used for trend analysis.
  • 8. KNOWLEDGE IN A CAN OF BEANS WHAT WE KNOW: FINANCIAL MANAGEMENT Financial management know that beans have a 55% profit markup, an average shelf life of 12 days and are the 28th most profitable items in the store. They know that beans account for 0.5% of the profitability of the chain of supermarkets.
  • 9. KNOWLEDGE IN A CAN OF BEANS WHAT WE KNOW: PRODUCT LINE MANAGEMENT Product line managers know that more cans of beans are sold between 4 and 6 pm on Thursdays than any other day. They know that bean can sales are up 3% on last month, but down 4% compared to this day last year. Seasonal trends show bean sales are declining over the last 5 years. They know that when the "Bean Can" promotion was on store bean can sales increased by 2%. They know that when bean cans were in isle 5 sales fell by 12%.
  • 10. KNOWLEDGE IN A CAN OF BEANS WHAT WE KNOW: HR MANAGEMENT HR management knows that Debbie on the Checkout handles more customers at the end of her Thursday shift than on any other day. They know her performance compared to the rest of the staff has declined in the last 3 months. They know that there was a 45 second gap between scanning each can of beans.
  • 11. KNOWLEDGE IN A CAN OF BEANS WHAT WE KNOW: SHIFT MANAGER They can plot Debbie's work performance, hour by hour, day by day. They can compare Debbie's performance against other workers, or against her performance for the same period last year. They can map Debbie's performance against internal events (store layout restructure, new manger, new colleagues etc) or external factors (wet days, prior or post holidays, day after payday etc).
  • 12. KNOWLEDGE IN A CAN OF BEANS WHAT WE KNOW: SHOPFRONT MANAGEMENT Shopfront management know that number 6 checkout position sells more canned products between 4 and 6pm on Thursdays than any other. They know that on Thursday evenings more customers buy beans from isle 6 than from any other area of the supermarket. They know that when the "Bean Can" promotion was on bean can sales increased by 2%. They know that when bean cans were in isle 5 sales fell by 12%.
  • 13. KNOWLEDGE IN A CAN OF BEANS WHAT WE KNOW: SHOPFRONT MANAGEMENT (Cont) They know the next customer didn't have products scanned until 4 minutes after I paid for the can. They know number 6 checkout is the most unprofitable on Thursday evenings.
  • 14. KNOWLEDGE IN A CAN OF BEANS WHAT WE KNOW: MARKETING Marketing know that on Thursday evenings more customers buy beans than any other canned food product. They know that when the "Bean Can" promotion was on bean can sales increased by 7%. They know that some stores performed better than others during the promotion. They know that isle placement of beans can alter sales by as much as 25%. Seasonal trends show bean sales are declining over the last 5 years in most stores.