Prepare a gantt chart for the stock control project, Database Management System

Prepare a gantt chart for the stock control project:

Scenario

Lucas-TVS is the Leader in Auto Electricals in India today with 50 years experience in design and manufacturing. 4 out of 5 vehicles rolled out daily are fitted with Lucas-TVS products. The company has manufacturing units with fully integrated state-of-the-art technology that includes most advanced design, production, quality, testing and  R& D facilities. You are appointed as Graduate Engineer Trainee. You will be working with different departments of the company and the concerned department managers will test your analytical knowledge and techniques to carry out managerial tasks.

 

 

TASK 1

The company is planning to conduct a large international motor sports rally due to take place in four years time. A significant portion of the project will be provision of new building & facilities.  Major new works associated with the project include the construction of a 30,000 seat outdoor stadium with car racing tracks & a world press & media centre. A further consideration is the upgrade of the current transport network, with major development work required on the local metro rail system between the main stadium & the city centre & an airport bus link.

Success will be measured in terms of trouble free performance of the events, level of customer enthusiasm & satisfaction & sustained economic activity generated in the region.  Completion of the project on time is critical even if costs are adversely affected.

The major software development aspect of the project is the development of communication software in the form of an information database. This will require development of a dedicated website to give public access to event information. The database will contain information about competitors & their events, time & location & availability of tickets. The database will be designed to allow the general public to monitor the events, order tickets for any event  & purchase merchandise. The website will also contain links to local hotels & restaurant facilities.

The project can be broken down into following areas of work :

 

Activity

Activity Description

Preceding Activity


Duration in Weeks

 

A

Obtain financing & sponsorship negotiation

-


22

 

B

Sporting facilities

-


52

 

C

Analysis & design of communications software

A


14

 

D

 Construct media facilities

B,C


16

 

E

Program Communications system

C


26

 

F

Install communications software & telecommunications hardware

D.E


6

 

G

Transport network update & construct participants accommodation

-


40

 

H

Security arrangements & checks

G,F


12

 

I

Public Relations / Advertising / Marketing

F


10

 

J

Human Resources & Volunteers

I


12

 

K

Trial Events, media systems & contingency

H,J


6

 

L

Events (including the opening and closing ceremonies)

K


2

 

 

Each of the above activities is carried out by individual specialist project teams & is led by a  Project Team Manager. It is critical that these events are coordinated & planned effectively, as timing is critical to the success of this project. One of the key tasks to undertake immediately is the determination of the critical path.

You have been asked by your management to prepare a report which includes :

(a)    An explanation of the importance of undertaking critical path analysis for a project such as this.

(b)   A critical path analysis for the project , clearly identifying :

(i)   The critical path activities & the critical duration of the project.

(ii)  The Earliest Event Time for each activity (EET).

(iii) The Latest Event Time for each activity (LET)

(c)    A calculation of the slack time on activity H and an explanation of how this information may assist decision making during this project.

(d)   How using project management software may assist during this project.

 

 

 

TASK 2

 

The company has planned to purchase hardware & develop an in house  software to run a completely new stock control system & a website allowing access to the stock database. The design stage has been completed & the project is progressing through the implementation stage, but is falling behind schedule. The following is the schedule of events for the 16 week implementation phase of the project :

 

Planned :

Task

Planned Start

Planned Duration

Write Programmes

Start of Week 1

8

Purchase & Install hardware

Start of Week 1

5

Create databases

Start of Week 6

4.5

Convert Existing Files

Start of Week 9

2.5

Test Programs

Start of Week 6

3

Test System

Middle of Week 11

2.5

Select & Train personnel

Start of Week 8

5

Cutover

Start of Week 14

3

 

Actual :

Write Programmes

Start of Week 1

9

Purchase & Install hardware

Start of Week 1

6

Create databases

Start of Week 7

4

Convert Existing Files

Middle of Week 10

1.5 ( Continuing)

Test Programs

Start of Week 7

5 ( Continuing)

Test System

Not Started

 

Select & Train personnel

Start of Week 8

4 ( Continuing)

Cutover

Not Started

 

 

Current date is start of week 12.

Required  

(a)    Prepare a Gantt chart for the stock control Project

(b)   Explain the purpose of a Gantt chart & interpret the information shown on the chart prepared for the project.

 

 

TASK 3

The company is planning to develop an in house  software to run a completely new stock control system & a website allowing access to the stock database as indicated in task 2. At the planning stage you are required to prepare a Work Break down structure giving activities & costs.

 

 

 

 

Posted Date: 2/11/2013 1:44:21 AM | Location : United States







Related Discussions:- Prepare a gantt chart for the stock control project, Assignment Help, Ask Question on Prepare a gantt chart for the stock control project, Get Answer, Expert's Help, Prepare a gantt chart for the stock control project Discussions

Write discussion on Prepare a gantt chart for the stock control project
Your posts are moderated
Related Questions

List the types of authorization. A) Read authorization B) Write authorization C) Update authorization D) Drop authorization

Compare the Nested-loop join and block-nested loop join Ans: Nested  loop join - It is costly as worst case cost, no. of block accesses needed is n r * b s + b r   where b

Describe disk manager and their work? Disk Manager: Responsible for fetching data regulated through file Manager from disk storage within Main memory and deciding what data to

Multiple-mode locks : It offers two locks: exclusive locks and shared locks. But why do we require these two locks? There are a lot of transactions in the database system that neve

Fifth Normal Form (5NF) These relations still have a difficulty. While defining the 4NF we mentioned that all the attributes depend upon each other. Whereas creating the two ta

Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

Problem 1. Write the SQL queries using Data Manipulation Language (DML) statements. Insert values into student table with field names using insert command Display the

What are the two main goals of parallelism? Load -balance multiple small accesses, so that the  throughput of such accesses enhances. Parallelize large accesses so that the res

1. Which relational algebra operations do not need the participating tables to be union-compatible? Ans: Join is the relational algebra operations that do not need the particip