Costing and Scheduling Progress Report

This document presents a detailed costing and scheduling progress report for a project, likely named 'Red Zuma Project'. It includes a Gantt chart analysis showing which activities are progressing well and which are critical. The report also calculates the Product has been accomplished (PCIB) and the forecasted cost at completion (EAC) for each task. The estimated completion date is noted as approximately November 10th, 2019. The report uses earned value metrics to assess project performance and identify areas needing attention.

Part 4 A
Student Name
University

Costing and scheduling progress report:
Scheduling:

The activates are gone well or not well demonstrate in Gantt chart:
As shown in above table, the activities are in blue marks are gone well and activities are in “red”
marks are gone critical or not well.

Market analysis, product design, manufacturing study, product design selection, detail marketing
plan, detail product plan and order complete are gone well.
At same time, manufacturing process, build prototypes, lab test prototypes, field test prototypes,
finalized product design, finalized manufacturing design, order production equipment and install
production equipments are not gone well .
Product has been accomplished (PCIB):
In order to find product accomplished, the following formula used for each activities:
PCIB= EV
BAC
Task Name
Planned
Value - PV
(BCWS)
Earned
Value - EV
(BCWP)
EAC PCIB
Red Zuma Project $228,413.46 $228,413.46 $903,699.04 0.252754
Market Analysis $30,769.23 $30,769.23 $30,769.23 1
Product Design $112,500.00 $112,500.00 $112,500.00 1
Manufacturing Study $47,692.31 $47,692.31 $47,692.31
1
Product Design
Selection $37,451.92 $37,451.92 $37,451.92
1
Detailed Marketing Plan $0.00 $0.00 $18,461.54
0
Manufacturing Process $0.00 $0.00 $74,423.08
0

Detailed Product Design $0.00 $0.00 $190,168.27
0
Build Prototypes $0.00 $0.00 $83,653.85 0
Lab Test Prototypes $0.00 $0.00 $23,676.92 0
Field Test Prototypes $0.00 $0.00 $56,353.85 0
Finalized Product
Design $0.00 $0.00 $83,365.38
0
Final Manufacturing
Process $0.00 $0.00 $17,067.31
0
Order Components $0.00 $0.00 $2,019.23
0
Order Production
Equipment $0.00 $0.00 $4,038.46
0
Install Production
Equipment $0.00 $0.00 $115,096.15
0
Celebrate $0.00 $0.00 $6,961.54 0
Forecasted cost at completion (EAC):
Task Name
Planned
Value - PV
(BCWS)
Earned
Value - EV
(BCWP)
EAC BAC CP
I EAC
Red Zuma
Project
$228,413.4
6
$228,413.4
6
$903,699.0
4
$903,699.0
4 1 $903,699.0
4
Market
Analysis $30,769.23 $30,769.23 $30,769.23 $30,769.23 1 $30,769.23

Product
Design
$112,500.0
0
$112,500.0
0
$112,500.0
0
$112,500.0
0 1 $112,500.0
0
Manufacturi
ng Study $47,692.31 $47,692.31 $47,692.31 $47,692.31 1
$47,692.31
Product
Design
Selection
$37,451.92 $37,451.92 $37,451.92 $37,451.92 1
$37,451.92
Detailed
Marketing
Plan
$0.00 $0.00 $18,461.54 $18,461.54 0
#DIV/0!
Manufacturi
ng Process $0.00 $0.00 $74,423.08 $74,423.08 0
#DIV/0!
Detailed
Product
Design
$0.00 $0.00 $190,168.2
7
$190,168.2
7 0
#DIV/0!
Build
Prototypes $0.00 $0.00 $83,653.85 $83,653.85 0 #DIV/0!
Lab Test
Prototypes $0.00 $0.00 $23,676.92 $23,676.92 0 #DIV/0!
Field Test
Prototypes $0.00 $0.00 $56,353.85 $56,353.85 0 #DIV/0!
Finalized
Product
Design
$0.00 $0.00 $83,365.38 $83,365.38 0
#DIV/0!
Final
Manufacturin
g Process
$0.00 $0.00 $17,067.31 $17,067.31 0
#DIV/0!
Order
Components $0.00 $0.00 $2,019.23 $2,019.23 0
#DIV/0!
Order $0.00 $0.00 $4,038.46 $4,038.46 0 #DIV/0!

Production
Equipment
Install
Production
Equipment
$0.00 $0.00 $115,096.1
5
$115,096.1
5 0
#DIV/0!
Celebrate $0.00 $0.00 $6,961.54 $6,961.54 0 #DIV/0!
Estimated completion date:
From the Gantt chart, the project completion date will be 10th, Nov-2019 approximate.
Project Priority:

Earn value metrics and Gantt chart: