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

How are tables stored on disk?, How are tables stored on Disk? We reali...

How are tables stored on Disk? We realise that every record of a table can have different amounts of data. This is due to in some records; some attribute values may be "zero".

What are the desirable properties of a decomposition, Define What are the d...

Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

Process of adjustment of inheritance, Process of Adjustment of inheritance ...

Process of Adjustment of inheritance During object design, inheritance is readjusted by rearranging classes and operations, and abstracting common behaviour.

What is a recovery scheme, What is a recovery scheme? An integral part ...

What is a recovery scheme? An integral part of a database system is a recovery scheme that can restore the database to the reliable state that existed before the failure.

What are the benefits of prepared statements, What are the benefits of prep...

What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

Modelling and normalisation, Task Part A. Create an ERD from a business pro...

Task Part A. Create an ERD from a business problem. (50 marks) Read the following problem and complete the tasks listed below. THE ABS Blood Bank Australian Blood Services (ABS) i

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

Creating views with check option-data control, Creating views with check op...

Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

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