Lanfranco Furniture - Custom Application Development, Manufacturing and Reporting System

The Client Lanfranco Furniture is a manufacturer of lounge suites that are sold exclusively through retail outlets across Australia. Some of their customers include Harvey Norman, LeCornu and the Coles Myer group among many others. Currently Lanfranco Furniture processes an average of 200 orders per week (or 500 lines per week) and this is expected to grow by 10% per annum

Click for Photo Gallery

The Challenges

To replace Lanfranco's current Unix (Cobol) based manufacturing system with a new modern system that allows customers to place orders directly into the system.

(Return to top)

The Solution

SRA developed a web-based system that enables orders to be entered by Lanfraco's customers directly over the Internet or by Lanfranco staff for orders that have been faxed or phoned through. Lanfranco staff can then view the orders for checking and accepting.

Once accepted, the system prepares all the order lines ready for "batching". The Lanfranco management team makes the batching decisions at their weekly meeting. From this meeting, administrative staff members select each line that has been selected for batching and mark it with the relevant section. The system sorts these and places lines into suitable batches.

Various "job" reports can be printed for the specific areas within the organisation to use in determining what needs to be created. The factory then cuts/creates the various components and the items of furniture are assembled.

About a week prior to a batch completing, the system is used to generate shipping labels, print invoices (via automated integration with the MYOB Accounting package) and create the dispatch manifests.

(Return to top)

The Technology

Active Server Pages;
Visual Basic;
Microsoft IIS web server;
Microsoft SQL Server 2000 database;
Crystal Reports;
MYOB Accounting package

The Services

Project Management;
Requirements Definition;
Technical Development;
User Interface Design;
System Documentation;
Testing;
Training;
Ongoing Support

(Return to top)

Return to Retail Industry...