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

Find names of employees, Consider the relations EMP(ENO,ENAME,AGE,BASIC_S...

Consider the relations EMP(ENO,ENAME,AGE,BASIC_SALARY) WORK_IN(ENO,DNO) DEPT(DNO,DNAME,CITY) Express the following queries in SQL (i) Find names of employees who work in a dep

Customer service, as a customer service employee, explain five measures you...

as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

Explain an attributes, What are attributes? Give examples. An entity is...

What are attributes? Give examples. An entity is shown by a set of attributes. Attributes are descriptive properties possessed by every member of an entity set. Example: pos

Views-data control, Views A view is like a window by which data from ta...

Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

What are the constituents of file, What are the Constituents of File? Also ...

What are the Constituents of File? Also elaborates all the possible file operations? A file is organised logically as sequence of record. These records are mapped onto disk blo

Explain projection operation distribute over union operation, Illustrate th...

Illustrate the statement 'Projection operation distributes over the union operation'. Give an example.    Ans: Π L (E 1 ∪ E 2 ) = (Π L (E 1 )) ∪ (Π L (E 2 ))   This says th

ERD, A student entity type has the following attributes,name..

A student entity type has the following attributes,name..

What is dbms and what are functions of dbms, What is DBMS and what are func...

What is DBMS and what are functions of DBMS? DBMS consist of collection of integrated data and set of program to admission those data. The functions performed by a typical

Advantages of database systems, Problem 1. Describe the following a)...

Problem 1. Describe the following a) Advantages of Database Systems b) Functions of a DBMS Explanation of part (a) and (b) 2. Explain the following concepts w

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