Project: Remodeling an Appliance - Accounting & Finance Assignment Help

Assignment Task

As a project manager, you have started to plan a project that aims to remodel an appliance. You created the activities with their durations and predecessors as shown in Table 1.
Table 1 - Project: Remodeling an Appliance
Activity Duration (weeks) Predecessors
A. Conduct competitive analysis 2 —
B. Conduct tech capabilities assessment 3 —
C. Develop focus group data 1 A, B
D. Conduct telephone surveys 3 C
E. Identify relevant specification improvements 2 C
F. Interface with Marketing staff 2 D, E
G. Develop engineering specifications 5 E
H. Check and debug designs 4 F, G
I. Identify critical performance levels 2 H
J. Assess and modify product components 6 I
K. Conduct capabilities assessment 4 J
L. Identify selection criteria 3 J
M. Develop RFQ 2 J
N. Develop production master schedule 2 K, L, M
O. Prepare product launch 1 N

Steps:
Type all the activities of “Remodeling an Appliance” project on a blank Microsoft Project sheet.
Create a Project Summary Task, and rename it “FirstName_LastName_EVM”.
Create a WBS column to the left of the task names (All the tasks are at the same level).
Type all task durations and predecessors. Durations are all in weeks. Total duration must be weeks.
Show all critical activities and their slacks on the Gantt chart.
Add a column “Cost” to the right of Resource Names.
Under “Project” tab, click “Move Project”. Make “New Project Start Date” November 15, 2021.
Under View tab, click “Resource Sheet”. Type resource names and costs as seen in Table 2. Don’t change the resource types.

Table 2 – Resources and Costs
Resource Name Cost/Use Tasks
a $100.00 A
b $100.00 B
c $200.00 C
d $350.00 D
e $300.00 E
f $250.00 F
g $300.00 G
h $500.00 H
i$300.00 I
j $500.00 J
k $300.00 K
l $100.00 L
m $300.00 M
n $200.00 N
o $100.00 O
Extras $150.00 F & G
Mark all the resources (except Extras) for each activity as shown in Table 2.

Under Task tab, select “Tracking Gantt”.
Create a baseline (Under “Project” tab, click “Set Baseline”. Click “OK”.)
Under Format tab, click Baseline, and choose the first baseline you created. You may not need to choose it as MS Project may see it as a default baseline.
Under Project tab, click Project Information, and change the current date and status date as Sunday, April 24, 2022.
Allocate “Extras” as a resource to Activity F and Activity G.
Mark the “Percent Complete” for each task based on Table 3.
Table 3 – Percent Completed for All Tasks
Activity Percent Complete
A. Conduct competitive analysis 100
B. Conduct tech capabilities assessment 100
C. Develop focus group data 100
D. Conduct telephone surveys 100
E. Identify relevant specification improvements 100
F. Interface with Marketing staff 100
G. Develop engineering specifications 100
H. Check and debug designs 50
I. Identify critical performance levels 0
J. Assess and modify product components 0
K. Conduct capabilities assessment 0
L. Identify selection criteria 0
M. Develop RFQ 0
N. Develop production master schedule 0
O. Prepare product launch 0

In the View tab, click Tables, and select More Tables. In the new menu window, choose Earned Value.
In the new sheet, insert SPI as a new column to the right of existing “SV” column.
In the new sheet, insert CPI as a new column to the right of existing “CV” column.
Take a screenshot of all the columns on this table (Earned Value) with all tasks, and paste it on a Word file. Don’t include Gantt Chart in this screenshot.
Interpret SPI, CPI, and VAC values in the Word document.

Explain why SPI and CPI are smaller or bigger than 1.
If the SPI remains the same during the rest of the project, how much delay may be expected?
If the CPI remains the same during the rest of the project, how much money may we spend more over our cost baseline?
Explain what VAC indicates.
Submit both MS Project and MS Word documents on Blackboard.

This Accounting & Finance Assignment has been solved by our Accounting & Finance experts at My Uni Papers. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.