POM+ Project

Baseline Information

Question:

Assume that today is April 12, 2024 and Table below contains the tracking information for the project up till now. Enter this information into your saved baseline file and prepare as status report for the POM+ project.

Below extracted from MS Projects after adding in the above information

Write a detailed status report to the committee, using earned value management to report on the progress of the project. the progress of the project.

1. Enter the below indicators and explain in relation to the project

2. Comment on the Earned Value indicators.

3. What activities have gone well?

4. What activities have not gone well?

5. What is the estimated date of completion of the project now? Will it finish on time?

6. How well is the project doing in terms of its priorities? (Refer back to the priorities and comment on them), comment on any activities that pose a risk to the project.

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & Task Name & \begin{tabular}{l} Fixed \\ Cost \end{tabular} & \begin{tabular}{l} Fixed Cost \\ Accrual \end{tabular} & Total Cost & Baseline & Variance - & Actual & Remaining \\ \hline 0 & POM+ Project & $0.00 & Prorated & $1,610,400.00 & $1,610,400.00 & $0.00 & $0.00 & $1,610,400.00 \\ \hline 1 & \begin{tabular}{l} R\&D Product \\ Development \end{tabular} & $0.00 & Prorated & $150,400.00 & $150,400.00 & $0.00 & $0.00 & $150,400.00 \\ \hline 2 & Needs survey & $0.00 & Prorated & $64,000.00 & $64,000.00 & $0.00 & $0.00 & $64,000.00 \\ \hline 3 & Set product specs & $0.00 & Prorated & $57,600.00 & $57,600.00 & $0.00 & $0.00 & $57,600.00 \\ \hline 4 & Shelf Life Report & $0.00 & Prorated & $19,200.00 & $19,200.00 & $0.00 & $0.00 & $19,200.00 \\ \hline 5 & Nutrition Report & $0.00 & Prorated & $9,600.00 & $9,600.00 & $0.00 & $0.00 & $9,600.00 \\ \hline 6 & Select fruit suppliers & $0.00 & Prorated & $9,600.00 & $9,600.00 & $0.00 & $0.00 & $9,600.00 \\ \hline 7 & Initial Production & $0.00 & Prorated & $906,000.00 & $906,000.00 & $0.00 & $0.00 & $906,000.00 \\ \hline 8 & Equipment rehab & $0.00 & Prorated & $480,000.00 & $480,000.00 & $0.00 & $0.00 & $480,000.00 \\ \hline 9 & Production trials & $0.00 & Prorated & $217,200.00 & $217,200.00 & $0.00 & $0.00 & $217,200.00 \\ \hline 10 & Quality trials & $0.00 & Prorated & $78,400.00 & $78,400.00 & $0.00 & $0.00 & $78,400.00 \\ \hline 11 & Quality metrics & $0.00 & Prorated & $11,600.00 & $11,600.00 & $0.00 & $0.00 & $11,600.00 \\ \hline 12 & Quality training & $0.00 & Prorated & $118,800.00 & $118,800.00 & $0.00 & $0.00 & $118,800.00 \\ \hline 13 & Distribution & $0.00 & Prorated & $207,200.00 & $207,200.00 & $0.00 & $0.00 & $207,200.00 \\ \hline 14 & Market testing & $0.00 & Prorated & $96,000.00 & $96,000.00 & $0.00 & $0.00 & $96,000.00 \\ \hline 15 & Package design & $0.00 & Prorated & $31,200.00 & $31,200.00 & $0.00 & $0.00 & $31,200.00 \\ \hline 16 & Select distributors & $0.00 & Prorated & $80,000.00 & $80,000.00 & $0.00 & $0.00 & $80,000.00 \\ \hline 17 & Legal & $0.00 & Prorated & $86,400.00 & $86,400.00 & $0.00 & $0.00 & $86,400.00 \\ \hline 18 & \begin{tabular}{l} Complete MPI \\ certification \end{tabular} & $0.00 & Prorated & $72,000.00 & $72,000.00 & $0.00 & $0.00 & $72,000.00 \\ \hline 19 & Register trademark & $0.00 & Prorated & $14,400.00 & $14,400.00 & $0.00 & $0.00 & $14,400.00 \\ \hline 20 & Prepare product launc & $0.00 & Prorated & $250,800.00 & $250,800.00 & $0.00 & $0.00 & $250,800.00 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & Task Name & \begin{tabular}{l} Planned Value \\ - PV (BCWS) \end{tabular} & \begin{tabular}{l} Earned Value - \\ EV (BCWP) \end{tabular} & AC(ACWP) & SV & CV & EAC & BAC & VAC & Add Nev \\ \hline 0 & POM+ Project & $38,400.00 & $0.00 & $0.00 & $38,400.00 & $0.00 & $1,610,400.00 & $1,610,400.00 & $0.00 & \\ \hline 1 & \begin{tabular}{l} R\&D Product \\ Development \end{tabular} & $38,400.00 & $0.00 & $0.00 & $38,400.00 & $0.00 & $150,400.00 & $150,400.00 & $0.00 & \\ \hline 2 & Needs survey & $38,400.00 & $0.00 & $0.00 & $38,400.00 & $0.00 & $64,000.00 & $64,000.00 & $0.00 & \\ \hline 3 & Set product specs & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $57,600.00 & $57,600.00 & $0.00 & \\ \hline 4 & Shelf Life Report & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $19,200.00 & $19,200.00 & $0.00 & \\ \hline 5 & Nutrition Report & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $9,600.00 & $9,600.00 & $0.00 & \\ \hline 6 & Select fruit suppliers & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $9,600.00 & $9,600.00 & $0.00 & \\ \hline 7 & Initial Production & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $906,000.00 & $906,000.00 & $0.00 & \\ \hline 8 & Equipment rehab & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $480,000.00 & $480,000.00 & $0.00 & \\ \hline 9 & Production trials & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $217,200.00 & $217,200.00 & $0.00 & \\ \hline 10 & Quality trials & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $78,400.00 & $78,400.00 & $0.00 & \\ \hline 11 & Quality metrics & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $11,600.00 & $11,600.00 & $0.00 & \\ \hline 12 & Quality training & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $118,800.00 & $118,800.00 & $0.00 & \\ \hline 13 & Distribution & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $207,200.00 & $207,200.00 & $0.00 & \\ \hline 14 & Market testing & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $96,000.00 & $96,000.00 & $0.00 & \\ \hline 15 & Package design & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $31,200.00 & $31,200.00 & $0.00 & \\ \hline 16 & Select distributors & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $80,000.00 & $80,000.00 & $0.00 & \\ \hline 17 & Legal & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $86,400.00 & $86,400.00 & $0.00 & \\ \hline 18 & \begin{tabular}{l} Complete MPI \\ certification \end{tabular} & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $72,000.00 & $72,000.00 & $0.00 & \\ \hline 19 & Register trademark & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $14,400.00 & $14,400.00 & $0.00 & \\ \hline 20 & \begin{tabular}{l} Prepare product \\ launch \end{tabular} & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & $250,800.00 & $250,800.00 & $0.00 & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|} \hline & Task Name & Act. Start & Act. Finish - & \begin{tabular}{l} % \\ Comp. - \end{tabular} & \begin{tabular}{l} Phys. \% \\ Comp. \end{tabular} & \begin{tabular}{l} Act. \\ Dur. \end{tabular} & \begin{tabular}{l} Rem. \\ Dur. \end{tabular} & Act. Cost - & \begin{tabular}{l} Act. \\ Work \end{tabular} & Add New Colum \\ \hline 0 & POM+ Project & NA & NA & 0% & 0% & 0 days & 145 days & $0.00 & 0hrs & \\ \hline 1 & \begin{tabular}{l} R\&D Product \\ Development \end{tabular} & NA & NA & 0% & 0% & 0 days & 50 days & $0.00 & 0hrs & \\ \hline 2 & Needs survey & NA & NA & 0% & 0% & 0 days & 20 days & $0.00 & 0hrs & \\ \hline 3 & Set product specs & NA & NA & 0% & 0% & 0 days & 15 days & $0.00 & 0hrs & \\ \hline 4 & Shelf Life Report & NA & NA & 0% & 0% & 0 days & 10 days & $0.00 & 0hrs & \\ \hline 5 & Nutrition Report & NA & NA & 0% & 0% & 0 days & 5 days & $0.00 & 0hrs & \\ \hline 6 & Select fruit suppliers & NA & NA & 0% & 0% & 0 days & 20 days & $0.00 & 0hrs & \\ \hline 7 & Initial Production & NA & NA & 0% & 0% & 0 days & 90 days & $0.00 & 0hrs & \\ \hline 8 & Equipment rehab & NA & NA & 0% & 0% & 0 days & 30 days & $0.00 & 0hrs & \\ \hline 9 & Production trials & NA & NA & 0% & 0% & 0 days & 15 days & $0.00 & 0hrs & \\ \hline 10 & Quality trials & NA & NA & 0% & 0% & 0 days & 20 days & $0.00 & 0hrs & \\ \hline 11 & Quality metrics & NA & NA & 0% & 0% & 0 days & 5 days & $0.00 & 0hrs & \\ \hline 12 & Quality training & NA & NA & 0% & 0% & 0 days & 15 days & $0.00 & 0hrs & \\ \hline 13 & Distribution & NA & NA & 0% & 0% & 0 days & 70 days & $0.00 & 0hrs & \\ \hline 14 & Market testing & NA & NA & 0% & 0% & 0 days & 30 days & $0.00 & 0hrs & \\ \hline 15 & Package design & NA & NA & 0% & 0% & 0 days & 30 days & $0.00 & 0hrs & \\ \hline 16 & Select distributors & NA & NA & 0% & 0% & 0 days & 25 days & $0.00 & 0hrs & \\ \hline 17 & Legal & NA & NA & 0% & 0% & 0 days & 35 days & $0.00 & 0hrs & \\ \hline 18 & \begin{tabular}{l} Complete MPI \\ certification \end{tabular} & NA & NA & 0% & 0% & 0 days & 25 days & $0.00 & 0hrs & \\ \hline 19 & Register trademark & NA & NA & 0% & 0% & 0 days & 5 days & $0.00 & 0hrs & \\ \hline 20 & \begin{tabular}{l} Prepare product \\ launch \end{tabular} & NA & NA & 0% & 0% & 0 days & 15 days & $0.00 & 0hrs & \\ \hline \end{tabular} \begin{tabular}{lcccc} \hline Activity & Actual Start & Actual Finish & Actual Duration & \begin{tabular}{l} Remaining \\ Duration \end{tabular} \\ \hline Need Survey & 06/11/23 & 05/12/23 & 22 & 0 \\ Set product specs & 06/12/23 & 12/01/24 & 18 & 0 \\ Shelf life report & 15/01/24 & 26/01/24 & 10 & 0 \\ Nutrition report & 30/01/24 & 02/02/24 & 4 & 0 \\ Select fruit suppliers & 05/02/24 & 04/03/24 & 20 & 0 \\ Equipment Rehab & 15/01/24 & 28/02/24 & 31 & 0 \\ Production trails & 05/03/24 & 22/03/24 & 14 & 0 \\ Quality trails & 25/03/24 & 19/04/24 & 18 & 0 \\ Quality metrics & 22/04/24 & 06/05/24 & 10 & 0 \\ Market testing & 05/02/24 & 12/03/24 & 26 & 0 \\ Package design & 13/03/24 & 18/04/24 & 25 & 0 \\ Select distributors & 19/03/24 & & 12 & 0 \\ Complete MPI certification & 13/03/24 & 03/04/24 & 14 & 0 \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & Task Name & AC(ACWP) & \begin{tabular}{l} Planned Value - \\ PV (BCWS) \end{tabular} & \begin{tabular}{l} Earned Value - \\ EV (BCWP) \end{tabular} & SV & CV & CV% & EAC & BAC & VAC & CPI \\ \hline 0 & POM+ Project & $1,109,200.00 & $1,165,200.00 & $1,151,421.95 & $13,778.05 & $42,221.95 & 4% & $1,551,347.60 & $1,610,400.00 & $59,052.40 & 1.04 \\ \hline 1 & R&D Product Development & $166,400.00 & $150,400.00 & $150,400.00 & $0.00 & $16,000.00 & 11% & $166,400.00 & $150,400.00 & $16,000.00 & 0.9 \\ \hline 2 & Needs survey & $70,400.00 & $64,000.00 & $64,000.00 & $0.00 & $6,400.00 & 10% & $70,400.00 & $64,000.00 & $6,400.00 & 0.91 \\ \hline 3 & Set product specs & $69,120.00 & $57,600.00 & $57,600.00 & $0.00 & $11,520.00 & 20% & $69,120.00 & $57,600.00 & $11,520.00 & 0.83 \\ \hline 4 & Shelf Life Report & $19,200.00 & $19,200.00 & $19,200.00 & $0.00 & $0.00 & 0% & $19,200.00 & $19,200.00 & $0.00 & 1 \\ \hline 5 & Nutrition Report & $7,680.00 & $9,600.00 & $9,600.00 & $0.00 & $1,920.00 & 20% & $7,680.00 & $9,600.00 & $1,920.00 & 1.25 \\ \hline 6 & Select fruit suppliers & $9,600.00 & $9,600.00 & $9,600.00 & $0.00 & $0.00 & 0% & $9,600.00 & $9,600.00 & $0.00 & 1 \\ \hline 7 & Initial Production & $749,680.00 & $759,920.00 & $753,821.95 & $6,098.05 & $4,141.95 & 1% & $901,021.89 & $906,000.00 & $4,978.11 & 1.01 \\ \hline 8 & Equipment rehab & $496,000.00 & $480,000.00 & $480,000.00 & $0.00 & $16,000.00 & 3% & $496,000.00 & $480,000.00 & $16,000.00 & 0.97 \\ \hline 9 & Production trials & $202,720.00 & $217,200.00 & $217,200.00 & $0.00 & $14,480.00 & 7% & $202,720.00 & $217,200.00 & $14,480.00 & 1.07 \\ \hline 10 & Quality trials & $50,960.00 & $62,720.00 & $56,621.95 & $6,098.05 & $5,661.95 & 10% & $70,560.34 & $78,400.00 & $7,839.66 & 1.11 \\ \hline 11 & Quality metrics & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & 0% & $23,200.00 & $11,600.00 & $11,600.00 & 0 \\ \hline 12 & Quality training & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & 0% & $118,800.00 & $118,800.00 & $0.00 & 0 \\ \hline 13 & Distribution & $143,200.00 & $184,800.00 & $165,600.00 & $19,200.00 & $22,400.00 & 14% & $179,172.95 & $207,200.00 & $28,027.05 & 1.16 \\ \hline 14 & Market testing & $83,200.00 & $96,000.00 & $96,000.00 & $0.00 & $12,800.00 & 13% & $83,200.00 & $96,000.00 & $12,800.00 & 1.15 \\ \hline 15 & Package design & $21,600.00 & $21,600.00 & $31,200.00 & $9,600.00 & $9,600.00 & 31% & $21,600.00 & $31,200.00 & $9,600.00 & 1.44 \\ \hline 16 & Select distributors & $38,400.00 & $67,200.00 & $38,400.00 & $28,800.00 & $0.00 & 0% & $80,000.00 & $80,000.00 & $0.00 & 1 \\ \hline 17 & Legal & $40,320.00 & $60,480.00 & $72,000.00 & $11,520.00 & $31,680.00 & 44% & $48,384.00 & $86,400.00 & $38,016.00 & 1.79 \\ \hline 18 & \begin{tabular}{l} Complete MPI \\ certification \end{tabular} & $40,320.00 & $60,480.00 & $72,000.00 & $11,520.00 & $31,680.00 & 44% & $40,320.00 & $72,000.00 & $31,680.00 & 1.79 \\ \hline 19 & Register trademark & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & 0% & $14,400.00 & $14,400.00 & $0.00 & 0 \\ \hline 20 & Prepare product launch & $0.00 & $0.00 & $0.00 & $0.00 & $0.00 & 0% & $250,800.00 & $250,800.00 & $0.00 & 0 \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|} \hline PV & EV & AC & BAC & CV and CPI \\ \hline SV and SPI & VAC & EAC & TCPI & \\ \hline \end{tabular}