2007
TANGAIL SAREE KUTIR
Information System Design Lab
Submitted To: Mohammad
Ali (Associate Prof. Department of CSE, Ahsanullah University)
Date of Submission: 9th August’2007 Works Done by:
Nazmus Saquibe
Nazmus
Sayeed
M Saroare jahan
(#04.01.04.098) (#04.01.04.053) (#04.01.04.009)
Md. Ashik Hossain (#03.01.04.041)
[ TANGAIL SAREE KUTIR] 143/1, New Baily Road Dhaka ‐1000 Bangladesh Phone‐ 8802‐8314567
[ TANGAIL SAREE KUTIR] May 31, 2007
1
Overview
3
Working Area
4
Organogram
5
Designation
6
guideline
7
interview
8
Questionnaire
9
forms and documents
12
Existing system
15
Division of Unit
16
Service Charecter/Responsibility
18
DFD
19
Benefit analysis
24
Network layout
28
hardware specification
32
project scheduling
36
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 2
[ TANGAIL SAREE KUTIR] May 31, 2007
9 The Company we work along:
Tangail Saree Kutir is the first chain local Saree store in Bangladesh. It produces scarves, stoles and jewelry along with its cotton and silk sarees in block print, batik, nakhshikatha, jamdani, mirpur, pabna, rajshahi and tangail. The company employs more than 5000 weavers and 1000 hand crafters to create magnificent handloom sarees as well as materials. Inspired by folklore religious stories and nature of rural Bangladesh, design created with dramatic sheer fluidity which gently showcases the body to make simply elegant. Tangail saree Kutir has become one of the most famous share stores of its kinds in Dhaka, Bangladesh to expose the exotic Beauty of Bangladesh women in vibrant sarees. Tangail Saree Kutir pioneered to recapture the glorious image of once famous Dhakai Muslins and also regenerated the local sarees for popular use which largely endangered during seventies. [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 3
[ TANGAIL SAREE KUTIR] May 31, 2007
Tangail Saree Kutir is a large organization with more than 7000 employees. It has huge amount of sales and inventories. As a result it needs a large and sophisticated Information System. This gives us a great opportunity to learn about the Information System, its structure and function and implement what we have learnt so far. By constructing there system, we can find out how to build and maintain a large and sophisticated Information System, which will help us in the future in building as such.
1. 2. 3. 4. 5.
Sales Department Human Resource Management Daily Transaction Inventories Annual Report
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 4
[ TANGAIL SAREE KUTIR] May 31, 2007
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 5
[ TANGAIL SAREE KUTIR] May 31, 2007
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 6
[ TANGAIL SAREE KUTIR] May 31, 2007
N o
Members
Member’s Name
Duration
& Designation
(min)
Issue of the Discussion
Obtained Information
(Scope of Work)
1
5
Nazmus Saquibe (Team Leader)
30
Financial Management
Get details Information about financial management including sales, production, earnings, expenditure etc.
20
Financial Management
Get details Information about financial management including sales, production, earnings, expenditure etc.
30
Human Resource Get details Information about Human Resource Management
Nazmus Sayeed M Saroare jahan Md. Ashik Hossain (Members)
Mr. Shahin (Manager)
2
3
Nazmus Saquibe (Team Leader)
Nazmus Sayeed
(Member)
Mr. Ismail (Store and Sales In charge)
3
4
Nazmus Saquibe (Team Leader)
Nazmus Sayeed Md. Ashik Hossain (Members)
Mr. Shahin
Management including salary structure, employment system, Increment, Facilities etc.
(Manager)
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 7
[ TANGAIL SAREE KUTIR] May 31, 2007
No
1
Interviewee Name and Designation
Interviewer’s Name & Designation
Mr. Shahin
Nazmus Saquibe
Manager
(Team Leader)
Nazmus Sayeed M Saroare jahan Md. Ashik Hossain
Scope of Work
Duration of the Work
Questionnaires & Answers
Human Resource Management
45 Minutes
Questions and the answers are included with the document below.
(Members)
2
Mr. Ismail
Nazmus Saquibe
Store and Sales In charge
(Team Leader)
Nazmus Sayeed M Saroare jahan Md. Ashik Hossain
Financial Management
50 Minutes
Questions and the answers are included with the document below.
(Members)
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 8
[ TANGAIL SAREE KUTIR] May 31, 2007
Q. No
Questions
Answers
1
What do you buy for your company?
Raw materials and produced goods.
2
What raw materials do you buy?
Cotton fabrics and sharees.
3
From whom do you buy these materials?
Several textile industries and from the small entrepreneur and also from the weavers.
4
How do You pay for the materials?
We pay after the materials after on hand by cash.
5
How many showrooms do you have?
4 showrooms including the Baily road main branch.
6
How do you calculate the total Each days transaction is calculated at the end transaction of a day? Per showroom or of the day at every showroom. in a whole?
7
How do you sell? Retail or wholesale?
Both Retail and Wholesale.
8
How do you keep track of sales and inventory?
Daily stock and monthly inventory.
9
Is your Selling system Computerized?
Yes but sparsely.
10
Do your outlets support any other form of payment other than cash?
Yes: Visa Card, Master Card, Citivisa, Brack Card, Dutch Card.
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 9
[ TANGAIL SAREE KUTIR] May 31, 2007
11
How do you manage cash and other forms of payments?
Initially keep at store but after a certain period we keep it to the bank account.
12
How you calculate the selling price of your goods over the costing?
By gross calculation or sometime by calculating some certain percentage. For example if we expense 2000 for a sharee including all the expenditure then we put a price tag of 2500 Tk. Or sometimes we calculate 10% to 15% profit on the expenditure.
13
What are the ways of spending of your Employee salary, Taxes, Vat, Utility bills, company? Store fair, Outlet fair etc.
14
What amount/ percentage of money you keep for your company for future use?
Confidential.
15
Is it possible to withdraw some amount of money from the equity for a director or a share holder?
Confidential.
16
Do you have audit in your office?
Yes. Last in July 2006.
1
What is the office hour?
10 AM to 8 PM
2
How many salary categories in your office?
Two categories.
3
In which basis you employ the employee. Permanent or Temporary?
Both Permanent and temporary. Basically temporary for the sales department.
4
How the Part‐time employees get their salary? Daily or after a month?
Hour basis. But got their payments daily.
5
How long a permanent or temporary employee could be absent?
By notifying the office 2 to 5 days. After a week the temporary employee losses his job.
6
What percentage will be cutoff after the permanent employee miss offices
Double of daily payment will be cutoff from
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 10
[ TANGAIL SAREE KUTIR] May 31, 2007
more then a certain period?
the permanent employee’s salary.
7
What will be the punishment for delaying at office?
For three consecutive working days delay he will be get one day cutoff from his/her salary.
8
Is there any bonus for the temp/permanent employee?
Not for the Temporary employee but for others at the Eid time.
9
Do you give increment after a financial year?
Yes. After every financial year.
10
Is there any loan for employees? If Yes. then what will be the interest system?
11
Is TA/DA present in your office?
Yes.
12
Any scholarship / facilities for the family members of a permanent employee?
No.
13
Does the employee get any percentage Yes. But for the permanent employees only. of shares after a financial year on behalf of percentage?
14
Do the officers/ general employee get any extra salary for the over time duty?
Not everybody. Those who have low salary scale and the temporary employee get over time.
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 11
[ TANGAIL SAREE KUTIR] May 31, 2007
¾ Forms & Documents for Sales: Scope of Work Forms/ Documents
Source of Origin Sales Section
Selling System Advance Sleep Description: Advance payment receipt. Data: Page No: 0196
Used by
Comments
Sales Section
Advance Receipt:
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 12
[ TANGAIL SAREE KUTIR] May 31, 2007
¾ Forms & Documents for Invoice: Scope of Work Forms/ Documents
Source of Origin Sales Section
Used by
Comments
Selling System Invoice Sales Section Description: Commercial Invoice Data: Page No: 200707103972 Date: 11/07/2007 Time: 1:10:44 PM Pay Type: cash.
Commercial Invoice:
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 13
[ TANGAIL SAREE KUTIR] May 31, 2007
¾ Forms & Documents for Attendance: Scope of Work Forms/ Documents
Source of Origin Management
HRM Register Description: Attendance Register. Data: Month: June. Year 2007.
Used by
Comments
Management
¾ Forms & Documents for Attendance: Scope of Work Forms/ Documents HRM Form Description: Salary Statement. Data: Month: June. Year: 2007.
Source of Origin Management
Used by
Comments
Management
¾ Forms & Documents for Attendance:
Scope of Work Forms/ Documents
Source of Origin Accounts
Used by
Comments
Financial Register Accounts Management Description: Daily log of buying from a particular entrepreneur named Rabindranath Basak . Data: Month: June. Year: 2007. [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 14
[ TANGAIL SAREE KUTIR] May 31, 2007
Introduction: Tangail Saree Kutir is the first chain local Saree store in Bangladesh. It produces scarves, stoles and jewelry along with its cotton and silk sarees in block print, batik, nakhshikatha, jamdani, mirpur, pabna, rajshahi and tangail. The company employs more than 5000 weavers and 1000 hand crafters to create magnificent handloom sarees as well as materials. Inspired by folklore religious stories and nature of rural Bangladesh, design created with dramatic sheer fluidity which gently showcases the body to make simply elegant. Tangail saree Kutir has become one of the most famous share stores of its kinds in Dhaka, Bangladesh to expose the exotic Beauty of Bangladesh women in vibrant sarees. Tangail Saree Kutir pioneered to recapture the glorious image of once famous Dhakai Muslins and also regenerated the local sarees for popular use which largely endangered during seventies. [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 15
[ TANGAIL SAREE KUTIR] May 31, 2007
Tangail Saree Kutir has a well balanced division unit. This is given bellow:
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 16
[ TANGAIL SAREE KUTIR] May 31, 2007
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 17
[ TANGAIL SAREE KUTIR] May 31, 2007
Designations
Responsibilities 9 Observe the total Service Admin
Administration: CEO Directors Manager
9 Keep the store tracks.
Store: Store Keeper
9 Buy the products and raw materials.
Purchase: Record keeper
IT:
9 Give technical support
Coordinator IT
9 Maintenance the requirement supply
Accounts
9 Observe the total account section
Assistant Accountant
9 Calculate the Account side
9 Make a combination to the finance. Sales Center
9 Sales Sarees and other Products
Counter In Charge [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 18
[ TANGAIL SAREE KUTIR] May 31, 2007
Scope No. 01 Scope of Work About us Process Description of Tangail Saree Kutir Limited Flow About Sales & Service Data Store About us Terminator Output (About us Allocation of
Data flow Diagram(DFD)
Business/Organogram/Tangail Saree Kutir Directors /Key Persons Figure 1
External Data Store User
About Tangail Saree Kutir
(Admin)
Process the Request
Descriptions of Sales & Service
Requesting
.
about US
Request to Database
User
Output (About us Allocation of Business / Organogram / Tangail Saree Kutir Directors /Key Persons
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 19
[ TANGAIL SAREE KUTIR] May 31, 2007
Scope No. 02 Scope of Work Buying Raw Materials Process Input/ System of Buying Flow Purchase Data Store Purchase Terminator Output (About Purchase methods/products) Data flow Diagram(DFD) Figure 2
External Data Store Admin
About Purchase Products
Process the Request
Descriptions of Products and sellers
Requesting
.………….
Purchase
Request to Database
Admin
Output About purchase methods / products.
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 20
[ TANGAIL SAREE KUTIR] May 31, 2007
Scope No. 03 Scope of Work Selling Products Input / System of Selling Process Process Flow Selling Data Store Tangail Saree Kutir Terminator Output (About Selling Transition) Data flow Diagram(DFD) Figure 3
External Data Store Counter In Charge
Admin
About Selling System
Process the Request
Different kind of product Price
_____________
Requesting
Request to Database
Tangail Saree Kutir
View
Output About sales Transaction.
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 21
[ TANGAIL SAREE KUTIR] May 31, 2007
Scope No. 04 Scope of Work Attendance Submit Request Process Flow Attendance Data Store Tangail Saree Kutir Terminator Output (Attendance of Employee) Data flow Diagram(DFD) Figure 4
External Data Store Employee
About Daily Attendance
Process the Request
Daily Attendance of Employees
Requesting
_______
Tangail Saree Kutir
Request to Database
Admin
Output Attendance of Employee.
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 22
[ TANGAIL SAREE KUTIR] May 31, 2007
Scope No. 05 Scope of Work Salary Submit Request Process Flow Salary Data Store Tangail Saree Kutir Terminator Output (Salary of Employees) Data flow Diagram(DFD) Figure 5
External Data Store Admin
About Salary System
Process the Request
Salary of Employees
Requesting
________
Tangail Saree Kutir
Request to Database
Admin
Output Salary of Employee.
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 23
[ TANGAIL SAREE KUTIR] May 31, 2007
Benefit means total profit of an organization. By deducting total expenditure from the total income for a certain period we get the benefit of any company. There is a difference between expenditure and investment. Building a computer based system in an investment. Costs are incurred throughout its life cycle. Benefits are realized in the form of reduced operating costs, improved corporate image, staff efficiency or revenues. The benefit are of two types: • Tangible benefit • Intangible benefit.
Field Of savings
Benefit in BDT (conjecture)
Less papers
10000
Less pens
2500
No locker
30000
Extra software Buying
5000
Other equipment for filing (i.e.: files, pin etc)
3000
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 24
[ TANGAIL SAREE KUTIR] May 31, 2007
9 Automated system has more accuracy and speed. So can give services to the customers more accurately and fast. 9 Automated system is more secured then a manual system and it has kind automation processes. So decision making is further more easy then manual process. 9 By using an automation process a director can easily get the daily report without any hassle. 9 Surely automated system can bring customer satisfaction. As a result improvement in company image can functional in business. 9 Automated system can be fitted in a small place, which can be cost effective.
Item
Quantity
Cost (BDT)
Operating System (XP)
8
34000/=
Computer (Celeron)
8
320000/=
Printer
3
12600/=
UPS
9
32000/=
Network
30000/=
Server PC
1
50000/=
Radio Link(setup)
4
80000/=
Total
_____________________ 558600/=
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 25
[ TANGAIL SAREE KUTIR] May 31, 2007
Cost 1
st
year Item
Quantity
Cost (BDT)
Server
1
50000
Computer
5
150000
Printer
1
4200
Accessories
3000
Network
10000
Total
217200/=
Running cost 1
st
year
Item
Quantity
Paper
Cost (BDT) 3000
Toner
5
4000
Operator Salary
3
15000
Administrative Overhead
5000
Office Rent
200000
Accessories
5000
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 26
[ TANGAIL SAREE KUTIR] May 31, 2007
Total
234000
Income 1
st
year
Income 2
nd
Income 3
Income (BDT)
Service
200000
Contract
150000
Total
35000
year
rd
Field
Field
Income (BDT)
Service
250000
Contract
260000
Total
510000
year Field
Income (BDT)
Service
260000
Contract
280000
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 27
[ TANGAIL SAREE KUTIR] May 31, 2007
Total
Income 4
th
785000
year
Field
Income (BDT)
Service
265000
Contract
285000
Total
550000
Rate of Return: 14% NPV= = ‐558600‐(217200/1+.14)+((35000‐23400)/(1.14)^1)+((51000‐234000)/(1.14)^2)+((540000‐ 234000)/(1.14)^3)+((555000‐234000)/(1.14)^4)
= 134249 [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 28
[ TANGAIL SAREE KUTIR] May 31, 2007
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 29
[ TANGAIL SAREE KUTIR] May 31, 2007
Counter 1: First Floor [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 30
[ TANGAIL SAREE KUTIR] May 31, 2007
Manager room primary store Office room Road Entrance car parking counter01 [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 31
[ TANGAIL SAREE KUTIR] May 31, 2007
ROOF
Main Store Server Room [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 32
[ TANGAIL SAREE KUTIR] May 31, 2007
Desktop computer specification: Item
Specification
Unit
Brand / Model
Clone
8
Processor & Speed
Intel Celeron , with clock speed of 2.8 GHz
Motherboard
Intel 865 GV Chipset
Bus Architecture
PCI
Cache Memory
256 KB L2 Cache (Integrated with processor)
Ram
512 MB DDR2 Ram with expandability
Hard Disk Drive
80 GB SATA, 7200 rpm
Floppy Disk Drive
1.44 MB 3.5” Floppy Disk Drive
Multimedia
16 x DVD ROM Drive
Sound Card
Integrated 3D Audio
Graphics
Integrated Intel Extreme Graphics
I / O Port
6 USB , 2 Serial , 1 Parallel Port
Monitor
Samsung 15” CRT Color monitor , Resolution 1024 x 768
Key Bored /Mouse
PS2 Keyboard/ Optical Scroll
Form Factor / Casing
ATX Casing
Network Card
Built in 10/100 MB\s
Warranty
1 years full warranty
30000/= Taka Each.
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 33
[ TANGAIL SAREE KUTIR] May 31, 2007
Server computer specification: Item
Specification
Unit
Brand
Clone
1
Processor
Intel Core 2 Duo 2.4 GHz
Motherboard
Intel 965
Cache / Chipset
2MB L2 cache
Ram
2 GB (2*1GB) DDR 2
Hard Drives
160 GB SATA
CD – R / W Drive
ASUS 48*24*48 X
Monitor
Dell 17” LCD
Video Sub System
Integrated ATI‐ Radeon 256MB
I / O Slot
Total 3 PCI Slot
Keyboard / Mouse
PS2/Optical Mouse
Network card
Built IN 10/100MB
Operating System
Linux
Warranty
1 Year Limited warranty
50000/= Taka [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 34
[ TANGAIL SAREE KUTIR] May 31, 2007
Printer specification: Items
Specification
Unit
Brand
Canon
3
Model
Canon Pixma iP1200
Image Ret
1200 dpi for high quality documents (Image Rat)
Resolution
600 * 600 dpi
Speed
17 pages per minute in black (letter)
Interface
USB 2.0 port
Media types
Plain Paper , envelops , transparencies (gray scale only), card stock , postcards and labels
Media Sizes
A4 , letter , Legal , Executive , no. 10 envelops
No . of Toner
2 Black & Color ( Cyan , Yellow , magenta)
Microsoft Windows 98 , 2000, me & XP (32‐bit), Supported O/S
Apple Macintosh 9.x and OS X, Linux
Warranty
1‐ years parts & service
4200 /= Taka. [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 35
[ TANGAIL SAREE KUTIR] May 31, 2007
Possible Network diagram (schematic diagram)
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 36
[ TANGAIL SAREE KUTIR] May 31, 2007
Number
Scheduling Topics
Dependencies
(weeks)
A
User Requirement
‐
4
B
Feasibility Study
A
2
C
Prioritize the Requirement
A
1
D
Analysis the System
B,C
3
E
Specification
D
1
F
Software Design
E
3
G
Hardware Study
E
1
H
Coding
F
5
I
Hardware Procurement
G
2
J
LAN Establishment
I
2
K
Deployment
H,J
1
l
Maintenance
K
3
Total Weeks needed: 28 [Department Of CSE, Ahsanullah University Of Science And Technology]
Page 37
[ TANGAIL SAREE KUTIR] May 31, 2007
After plotting the Gannt Chart the process can be done within 22 weeks.
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 38
[ TANGAIL SAREE KUTIR] May 31, 2007
1
Earliest: 0‐4‐4
Earliest: 4‐2‐6
Latest: 0‐4‐4
Latest: 4‐2‐6
2
Earliest: 6‐4‐ 10
3
Earliest: 10‐2‐12
Earliest: 12‐4‐16
Latest: 10‐2‐12
Latest: 12 4 16
5
6
7
Earliest: 13‐1‐14
Earliest: 16‐5‐21
Latest: 15‐1‐16
Latest: 16‐5‐21
Earliest: 4‐1‐5 Earliest: 5‐0‐5 Latest: 5‐1‐6 Latest: 6‐0‐6
4
9
8 Earliest: 14‐3‐17 Earliest: 21‐3‐23 Latest: 16‐3‐19 Latest: 21‐3‐23
10
12
Earliest: 17‐2‐19 Earliest: 23‐4‐27
Latest: 19‐2‐21
Latest: 23‐4‐27
11
13 Earliest: 19‐0‐19 Latest: 21‐0‐21
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 39
[ TANGAIL SAREE KUTIR] May 31, 2007
Slack Time: Latest starting time – Earliest starting time OR Latest Finishing time – Earliest Finishing time
User Requirement Feasibility Study Prioritize the Requirement Analysis the System Specification Software Design Hardware Study Coding Hardware Procurement LAN Establishment Deployment Maintenance
: 0 : 0 : 1 : 0 : 0 : 0 : 2 : 0 : 2 : 2 : 0 : 0
The Critical Path is displayed by the thick black lines.
[Department Of CSE, Ahsanullah University Of Science And Technology]
Page 40