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

Explain degree of relation, Explain degree of relation? Degree of a Re...

Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.

Cartisian product, Explain the cartesian product in Database Management Sys...

Explain the cartesian product in Database Management System

What are deadlocks, What are deadlocks?  How can they be avoided?  Ans:...

What are deadlocks?  How can they be avoided?  Ans: Deadlock considers to a particular condition when two or more processes are every waiting for another to release a resource,

Data Relation diagram, Can you assist me in Database management system? I n...

Can you assist me in Database management system? I need help in my courses, please email me at and get back me soon...

Determine object representation, Determine object representation As a ...

Determine object representation As a designer, we must choose properly that when to use primitive types in representing objects and when to combine groups of related objects,

Text mining, Text Processing: Use readLines to read SOU.txt into R. Cr...

Text Processing: Use readLines to read SOU.txt into R. Create a vector called Pres containing the names of the presidents giving each speech. To do this, rst identify the lin

Back up files, what is the importance of back up files

what is the importance of back up files

Define the relations as tables in sql, Consider the relations given below ...

Consider the relations given below Borrower (id_no, name) Book (accno., title, author, borrower_idno) (a) Define the above relations as tables in SQL forming real world assumptio

Create a query to produce single output-er model, This assignment concerns ...

This assignment concerns the Research database. The database ER model is shown above, where attributes are omitted for clarity. The relational model for the database is: Departm

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