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

Assignment Help:

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.

 

 

 

 


Related Discussions:- Prepare a gantt chart for the stock control project

Define deadlock recovery measures, Define Deadlock recovery measures       ...

Define Deadlock recovery measures                   To recover from deadlock, the cycle in the wait-for-graph should be broken. The common technique of doing this is to rollbac

horizontal fragmentation, Horizontal Fragmentation- Horizontal fragmentati...

Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b

Why dml is used for, Why DML is used for? DML is used to Manipulation and...

Why DML is used for? DML is used to Manipulation and processing of database. DML is provided for manipulation & processing of database. (Data stored in the database is processed

Define signal, Define Signal. It allows methods to respond to events tr...

Define Signal. It allows methods to respond to events triggered by themselves or by other processes. Each signal corresponds to an exacting event. A signal is represented in Sy

How is the database organised in oracle, How is the database organised in O...

How is the database organised in Oracle? Database organized within Oracle in terms of table and table holds attributes and values. A database consists of one or more logical

Discuss the three level architecture of dbms, PRINCIPLES OF DATABASE 1....

PRINCIPLES OF DATABASE 1. State the following terms: a) Database b) Database Management System c) Entity d) Attribute e) Relationship 2. Discuss the Three Level Architecture

In how many parts events are classified, In how many parts events are class...

In how many parts events are classified Events are classified as four types in UML 1.  Signals 2.  Calls 3.  Passing of Time 4.  Change in State

What is meant by the degree of relationship set, What is meant by the degre...

What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.

Define database management system, Define database management system? D...

Define database management system? Database management system (DBMS) is a set of interrelated data and a combination of programs to access those data.

Which two files are used during operation of the dbms, Which two files are ...

Which two files are used during operation of the DBMS? Data dictionary and transaction log are two files used during operation of the DBMS.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd