LL-Bean-SQL-Server-2000-Case-Study

Jun 21st, 2015
Studypool Tutor
Ball State University
Course: general
Price: $15 USD

Tutor description

As the nation’s largest outdoor clothing company, L.L. Bean ships some 500,000 items per day from its 650,000 square-foot Order Fulfillment Center (OFC). The company has more than 200,000 SKUs, so optimizing SKU placement within the warehouse for more efficient order picking is a constant challenge. To help OFC stock planners stay current with product demand, L.L. Bean deployed a Stock Planning System business intelligence (BI) data warehouse, hosted on Microsoft® SQL Server™ 2000 Enterprise Edition, running on the Microsoft Windows Server™ 2003 Enterprise Edition operating system.

Word Count: 2685
Showing Page: 1/6
OverviewCountry or Region: United StatesIndustry: RetailCustomer ProfileHeadquartered in Freeport, Maine, L.L. Bean is the nations largest outdoor clothing company. It serves its customers through catalog and Web sales, as well as with retail stores.Business SituationL.L. Bean needed a business intelligence (BI) data warehouse to help stock planners at its Order Fulfillment Center (OFC) more strategically position items for efficient customer order picking.SolutionL.L. Bean created a Stock Planning System BI data warehouse hosted on Microsoft SQL Server 2000. SQL Server Analysis Services is used to create multidimensional cubes to support drill-down reporting and key performance indicator dashboards.BenefitsBetter view into the businessSavings in order-filling time and expenseBetter customer serviceEnhanced planning effortsThe information was always there in our AS/400 system, but until we deployed our business intelligence solution we had never been able to efficiently tap into it.Bob Olive, Distribution Strategies Manager, L.L. BeanAs the nations largest outdoor clothing company, L.L. Bean ships some 500,000 items per day from its 650,000 square-foot Order Fulfillment Center (OFC). The company has more than 200,000 SKUs, so optimizing SKU placement within the warehouse for more efficient order picking is a constant challenge. To help OFC stock planners stay current with product demand, L.L. Bean deployed a Stock Planning System

Review from student

Studypool Student
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1826 tutors are online

Other Documents

06/21/2015
06/21/2015
06/21/2015
06/21/2015
06/21/2015
06/21/2015

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors