Scribd
Upload
176 views22 pages

Project Excel File

The document contains information about the resources used and cash flow for a boxes manufacturing project across multiple dates. It shows the number of people working on assembly, cutting, and design each date. Total manpower requirements decreased from 21 people initially to 6 people, then increased again to 26 people by the end of April. The cash flow table tracks weekly expenditures and cumulative cash flow over time, with the highest cash outflow of $15,105 occurring in the week of April 7th. The project budget outlines costs for requirements analysis, design, assembly, cutting, materials, and potential risks over the project duration.

Uploaded by

Conception & Fabrication Mécanique
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
176 views22 pages

Project Excel File

The document contains information about the resources used and cash flow for a boxes manufacturing project across multiple dates. It shows the number of people working on assembly, cutting, and design each date. Total manpower requirements decreased from 21 people initially to 6 people, then increased again to 26 people by the end of April. The cash flow table tracks weekly expenditures and cumulative cash flow over time, with the highest cash outflow of $15,105 occurring in the week of April 7th. The project budget outlines costs for requirements analysis, design, assembly, cutting, materials, and potential risks over the project duration.

Uploaded by

Conception & Fabrication Mécanique
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 22

Activity Name 10-Mar-14 17-Mar-14 24-Mar-14 31-Mar-14 7-Apr-14 14-Apr-14 21-Apr-14

Assembly 5 1 4 2 6 26
Cutting 3 6
Design 16.33 7.67 12 2
Total Man Power 21.33 8.67 12 6 5 12 26

Boxes Manufacture Project Revised Resource His


30

26
25

21.33
20
Daily Man Power

15

12 12

10
8.67

6 5
5

0
10-Mar-14 17-Mar-14 24-Mar-14 31-Mar-14 7-Apr-14 14-Apr-14 21-Apr-14

Axis Title

Assembly Cutting Design Total Man P


28-Apr-14 5-May-14 12-May-14 19-May-14
6 2.13 4.88

3.34 7.66
6 0 5.47 12.54

ect Revised Resource Histogram

26

12.54
12

6 5.47

0
14-Apr-14 21-Apr-14 28-Apr-14 5-May-14 12-May-14 19-May-14

Axis Title

tting Design Total Man Power


Activity Nam 10-Mar-14 17-Mar-14 24-Mar-14 31-Mar-14 7-Apr-14 14-Apr-14 21-Apr-14
Assembly 5 1 4 2 6 26
Cutting 3 6
Design 16.33 7.67 12 2
28-Apr-14 5-May-14 12-May-14
6 2.13 4.88

3.34 7.66
Boxes Project Communication Plan

S.N Stakeholder Name Stakeholder Group Type of information

1 FM Company group product design


Roy Benjamin
detailed drawings
2 FM Company group
Michael Gartner assembly drawings
3 FM Company group design drawings
Philip Cloony

vendor management, market


4 FM Company group analysis, contracting, and procuring
required resources

Jim Stanford

information on the progress


5 FM Company group
project management processes
John Morris

6 FM Company group budget


Caroline Smith
External stakeholders
7 Progress, photos, and project status
Joseph Bukhmann group
progress of the technical design
8 Client Group
Paul Lee Progress presentation
tion Plan

Sequence of Information Delivery


Communication Method

alternate day Email


Client Group
Weekly Email & Hard Copy
External stakeholders group
Weekly Email & Hard Copy

Weekly Email

Web-based project tracking


Daily system
Reports and Memo's
one-on-one meetings
Weekly telephone calls

Monthly Email & Hard Copy

Weekly report Email


biweekly call Phone Call
10-Mar-14 17-Mar-14 24-Mar-14 31-Mar-14 7-Apr-14 14-Apr-14 21-Apr-14
Weekly Cash Flow $3,200 $1,300 $1,800 $1,200 $15,105 $1,710 $3,900
Cumm. Cash Flow $3,200 $4,500 $6,300 $7,500 $22,605 $24,315 $28,215

Boxes Manufacture Projec


$16,000
$15,105

$14,000

$12,000

$10,000

$8,000

$6,000

$4,000
$3,200

$2,000 $1,800 $1,710


$1,300 $1,200

$0
10-Mar-14 17-Mar-14 24-Mar-14 31-Mar-14 7-Apr-14 14-Apr-14

Weekly Cash Flow


28-Apr-14 5-May-14 12-May-14 19-May-14
$2,614 $3,000 $2,106 $1,880
$30,829 $33,829 $35,935 $37,815

Manufacture Project Revised Cash Flow


$40,000
$15,105

$35,000

$30,000

$25,000

$20,000

$15,000

$3,900
$10,000
$3,000
$2,614
$2,106 $1,880$5,000
$1,710

$0
7-Apr-14 14-Apr-14 21-Apr-14 28-Apr-14 5-May-14 12-May-14 19-May-14

Weekly Cash Flow Cumm. Cash Flow


$40,000

$35,000

$30,000

$25,000

$20,000

$15,000

$10,000

$1,880$5,000

$0
19-May-14
Design Assembly Cutting Materials
Task
Boxes Project Revised Budget Risk Cost Total Cost
Duration Total Days Cost Per Day Total Days Cost Per Day Total Days Cost Per Day Total QTY Cost Per unit

1 Requirements Analysis 22 150 6 150 4,200


1.1 Interview client stakeholders 4 days 8 150 1,200
1.2 Product detail analysis 6 days 10 150 6 150 2,400
1.3 Refinement of the final draft 2 days 4 150 600
2 Design and Concept                        16 150 2,400
2.1 High level design 4 days 4 150 600
2.2 Details with operation designs 6 days 12 150 1,800
3 Production 44 150 9 90 8,265
3.1 Set up 4 days 6 150 450 1,350
3.2 Cutting and parts development 3 days 9 90 405 1,215
3.3 Sub-assembly 1 6 days 12 150 1,800
3.4 Sub-assembly 2 6 days 12 150 1,800
3.5 Sub-assembly 3 4 days 8 150 1,200
3.6 Assembly integration 3 days 6 150 900
4 Material 11,250
4.1 Cardboard sheet 50 20 1,000
4.1 Metal sheets 50 25 1,250
4.1 Cubes 900 10 9,000
5 Delivery 11 150 7 150 11,700
5.1 Pre-delivery 2 days 3,000
5.2 Shipment/Delivery—delivery takes 2 weeks by sea. 6,000
5.3 Implementation 7 days 11 150 7 150 2,700

Total Cost 37,815


Risk Analysis
Original Additional Additional Revised
Boxes Project Quantitative Risk Analysis Time Cost Original Cost Revised Cost
Risk ID Probability Duration Cost Duration Duration
Impact Impact
1 Requirements Analysis 4,200 0 4,200 0
1.1 Interview client stakeholders 1,200 4 0 1,200 4
1.2 Product detail analysis 2,400 6 0 2,400 6
1.3 Refinement of the final draft 600 2 0 600 2
2 Design and Concept                        2,400 0 2,400 0
2.1 High level design 600 4 0 600 4
2.2 Details with operation designs 1,800 6 0 1,800 6
3 Production 7,410 855 8,265
3.1 Set up R3 0.5 1 1 900 4 450 2 1,350 6
R1 0.7 0.6 1.26
3.2 Cutting and parts development 810 3 405 1,215 5.76
R3 0.5 1 1 1.5
3.3 Sub-assembly 1 1,800 6 0 1,800 6
3.4 Sub-assembly 2 1,800 6 0 1,800 6
3.5 Sub-assembly 3 1,200 4 0 1,200 4
3.6 Assembly integration 900 3 0 900 3
4 Material 11,250 0 11,250 0
4.1 Cardboard sheet 1,000 0 1,000 0
4.1 Metal sheets 1,250 0 1,250 0
4.1 Cubes 9,000 0 9,000 0
5 Delivery 11,700 0 11,700 0
5.1 Pre-delivery 3,000 2 0 3,000 2
Shipment/Delivery—delivery takes 2
5.2 R2 0.3 0.3 6,000 0 6,000 0
weeks by sea.
5.3 Implementation 2,700 7 0 2,700 7
Total 36,960 855 5 37,815
High Risk
Medium risk
Low risk
Task
Boxes Project Decomposing Design
Duration
1 Requirements Analysis 22 person days
1.1 Interview client stakeholders 4 days 8 person days
1.2 Product detail analysis 6 days 10 person days
1.3 Refinement of the final draft 2 days 4 person days
2 Design and Concept                        16 person days
2.1 High level design 4 days 4 person days
2.2 Details with operation designs 6 days 12 person days
3 Production
3.1 Set up 4 days
3.2 Cutting and parts development 3 days
3.3 Sub-assembly 1 6 days
3.4 Sub-assembly 2 6 days
3.5 Sub-assembly 3 4 days
3.6 Assembly integration 3 days
4 Material
4.1 Cardboard sheet
4.1 Metal sheets
4.1 Cubes
5 Delivery 11 person days
5.1 Pre-delivery 2 days
5.2 Shipment/Delivery—delivery takes 2 weeks by sea.
5.3 Implementation 7 days 11 person days

Task
Boxes Project Decomposing Resource Type
Duration
1 Requirements Analysis
1.1 Interview client stakeholders 4 days Design
Design &
1.2 Product detail analysis 6 days
Assembly
1.3 Refinement of the final draft 2 days Design
2 Design and Concept                       
2.1 High level design 4 days Design
2.2 Details with operation designs 6 days Design
3 Production
3.1 Set up 4 days Assembly
3.2 Cutting and parts development 3 days Cutting
3.3 Sub-assembly 1 6 days Assembly
3.4 Sub-assembly 2 6 days Assembly
3.5 Sub-assembly 3 4 days Assembly
3.6 Assembly integration 3 days Assembly
4 Material
4.1 Cardboard sheet sheets
4.1 Metal sheets sheets
4.1 Cubes pieces
5 Delivery
5.1 Pre-delivery 2 days

5.2 Shipment/Delivery—delivery takes 2 weeks by sea.

Design &
5.3 Implementation 7 days
Assembly
Assembly Cutting Materials

6 person days
22
6 person days

44 person days 9 person days 44


6 person days
9 person days
12 person days
12 person days
8 person days
6 person days

50
50
900
7 person days

7 person days

Assembly Cutting Materials


50
50
900
Design Assembly Cutting Materials
Task
Boxes Project Budget Total Cost
Duration Total Days Cost Per Day Total Days Cost Per Day Total Days Cost Per Day Total QTY Cost Per unit

1 Requirements Analysis 22 150 6 150 4,200


1.1 Interview client stakeholders 4 days 8 150 1,200
1.2 Product detail analysis 6 days 10 150 6 150 2,400
1.3 Refinement of the final draft 2 days 4 150 600
2 Design and Concept                        16 150 2,400
2.1 High level design 4 days 4 150 600
2.2 Details with operation designs 6 days 12 150 1,800
3 Production 44 150 9 90 7,410
3.1 Set up 4 days 6 150 900
3.2 Cutting and parts development 3 days 9 90 810
3.3 Sub-assembly 1 6 days 12 150 1,800
3.4 Sub-assembly 2 6 days 12 150 1,800
3.5 Sub-assembly 3 4 days 8 150 1,200
3.6 Assembly integration 3 days 6 150 900
4 Material 11,250
4.1 Cardboard sheet 50 20 1,000
4.1 Metal sheets 50 25 1,250
4.1 Cubes 900 10 9,000
5 Delivery 11 150 7 150 11,700
5.1 Pre-delivery 2 days 3,000
5.2 Shipment/Delivery—delivery takes 2 weeks by sea. 6,000
5.3 Implementation 7 days 11 150 7 150 2,700

Total Cost 36,960


Risk Analysis
Task
Boxes Project Qualitative Risk Analysis Time Cost
Duration Risk ID Probability
Impact Impact
1 Requirements Analysis
1.1 Interview client stakeholders 4 days
1.2 Product detail analysis 6 days
1.3 Refinement of the final draft 2 days
2 Design and Concept                       
2.1 High level design 4 days
2.2 Details with operation designs 6 days
3 Production
3.1 Set up 4 days R3 0.5 1 1
R1 0.7 0.6
3.2 Cutting and parts development 3 days
R3 0.5 1 1
3.3 Sub-assembly 1 6 days
3.4 Sub-assembly 2 6 days
3.5 Sub-assembly 3 4 days
3.6 Assembly integration 3 days
4 Material
4.1 Cardboard sheet
4.1 Metal sheets
4.1 Cubes
5 Delivery
5.1 Pre-delivery 2 days
Shipment/Delivery—delivery takes 2
5.2 R2 0.3 0.3
weeks by sea.
5.3 Implementation 7 days

High Risk
Medium risk
Low risk
10-Mar-14 17-Mar-14 24-Mar-14 31-Mar-14 7-Apr-14 14-Apr-14 21-Apr-14
Weekly Cash Flow $3,200 $1,300 $1,800 $1,200 $15,960 $3,900 $2,614
Cumm. Cash Flow $3,200 $4,500 $6,300 $7,500 $23,460 $27,360 $29,974

Boxes Manufacture Pro


$18,000

$15,960
$16,000

$14,000

$12,000

$10,000

$8,000

$6,000

$3
$4,000
$3,200

$2,000 $1,800
$1,300 $1,200

$0
10-Mar-14 17-Mar-14 24-Mar-14 31-Mar-14 7-Apr-14 14-

Weekly Cash Flow C


28-Apr-14 5-May-14 12-May-14
$3,000 $2,106 $1,880
$32,974 $35,080 $36,960

xes Manufacture Project Cash Flow


$40,000

$15,960
$35,000

$30,000

$25,000

$20,000

$15,000

$3,900 $10,000

$3,000
$2,614
$2,106 $1,880$5,000
200

$0
ar-14 7-Apr-14 14-Apr-14 21-Apr-14 28-Apr-14 5-May-14 12-May-14

Weekly Cash Flow Cumm. Cash Flow


Activity Name 10-Mar-14 17-Mar-14 24-Mar-14 31-Mar-14 7-Apr-14 14-Apr-14 21-Apr-14
Assembly 5 1 6 12 22 4
Cutting 9
Design 16.33 7.67 12 2
Total Man Power 21.33 8.67 12 8 21 22 4

Boxes Manufacture Project Resource Histogram


25

21 22
21.33
20

15
Daily Man Power

12

10
8.67
8

5
4

0
10-Mar-14 17-Mar-14 24-Mar-14 31-Mar-14 7-Apr-14 14-Apr-14 21-Apr-14

Axis Title

Assembly Cutting Design Total Man Power


28-Apr-14 5-May-14 12-May-14
3.13 3.88

4.91 6.09
0 8.04 9.97

ject Resource Histogram

22

9.97

8.04

0
14-Apr-14 21-Apr-14 28-Apr-14 5-May-14 12-May-14

Axis Title

Design Total Man Power


Boxes Manufacture Project
Organization Chart

You might also like