Calculate total variance and time variance for the project

Assignment Help Managerial Accounting
Reference no: EM13886284

1. a. Find the schedule variance for a project that has an actual cost at month 22 of $540,000, a scheduled cost of $523,000, and an earned value of $535,000.

b. A project at month 5 had an actual cost of $34,000, a planned cost of $42,000, and value completed of $39,000. Find the schedule and cost variances.

c. A project at day 70 exhibits an actual cost of $78,000, a scheduled cost of $84,000, and a value completed of $81,000. Find the schedule and cost indices.

2. Consider the information about a project plan in the following table.

Task

Immediate

Predecessor

Duration

Scheduled

Cost/Day

A

-

3

$1,000

B

-

5

$2,000

C

A

4

$4,000

D

B

7

$1,000

E

C

6

$2,000

F

D

8

$3,000

The following table shows the weekly control reports for the first two weeks (assume 5 working days each week).

 

End of Week 1

End of Week 2

Task

Actual %

Completed

Cumulative

Actual Cost

Actual %

Completed

Cumulative

Actual Cost

A

60%

$1,500

100%

$ 2,900

B

30%

$3,000

100%

$11,000

C

10%

$2,000

100%

$13,500

D

0%

$        0

90%

$10,000

E

0%

$        0

50%

$ 4,000

F

0%

$        0

0%

$        0

a. Use the earned value approach to calculate BCWP, BCWS, ACWP, SV, CV, SI, and CI for each task and the whole project.

b. Calculate the total variance and time variance for the project at the end of week 2.

c. Use the original estimate approach and the revised estimate approach to respectively estimate the final cost of this project at the end of week 1.

d. Use the original estimate approach and the revised estimate approach to respectively estimate the final cost of this project at the end of week 2.

3. A manufacturer of communication systems currently overhauls its computerized payroll system. Instead of using LOC (lines of code) to track the effort on devel¬oping such a payroll system, the manufacturer adopts a more reliable method, function point analysis, for measuring/monitoring the progress of the project.

The new payroll system consists of eight modules, each with a certain amount of function points. From the manufacturer's experience, each function point takes one week to develop. The ongoing project is evaluated at the end of the eighth week after its start. The schedule/cost report is provided in the follow¬ing table. (Assume linearity of cost vs. function point in each module.)

Comment on the status of the project at the end of week 8 based on the calculation of the project BCWP, BCWS, and ACWP. Is the project "in control"?; if not, why not?

Module

Immediate
Predecessors

Function
Points

Budget
(K)

Completed
Function Point

Money Spent
(K)

A

 

4

$90

4

$110

B

A

3

$65

3

$ 35

C

A

6

$75

2

$ 40

D

B

3

$60

3

$ 75

E

C

8

$55

1

$ 20

F

C

2

$40

1

$ 10

G

D, E

5

$80

0

$ 0

H

F

7

$90

0

$ 0

4. Sandy Point is the project manager of a small project that consists of seven tasks. After careful and extensive planning, Sandy and her project staff agreed on a proposed project schedule that is indicated by the following Gantt chart:

As indicated in their original project plan, Sandy and her staff had estimated the following durations and (total) direct costs for each task:

Task

Duration (weeks)

Planned Value

A

4

$2800

B

7

$2800

C

3

$1150

D

5

$625

E

5

$1350

F

3

$1050

G

3

$270

This morning (beginning of week 6), Sandy received a progress report; as indicated in the Gantt chart, task C could not be started until this week due to the unexpected delay in completing task A. The report also indicates that task B has been completed two weeks earlier than expected. Information from the progress report is summarized in the following table.

Task Current Actual Percent of
Status Expenditures Work
  to Date Completed
A Completed $2,000 100%
B Completed $2,800 100%
C Just started $0 0%
D In progress $330 55%
E Not started $0 0%
F Not started $0 0%
G Not started $0 0%

a. As of today (beginning of week 6), what is the cost variance of the project? What is the schedule variance of the project?

b. Based on information provided to date, what is your assessment of the cur¬rent status of the project?

Reference no: EM13886284

Questions Cloud

Differences between motivational interviewing techniques : What are some of the similarities and differences between motivational interviewing techniques used in a counseling setting and persuasive techniques used in a business sales setting
Who would be your main competitors : Describe this innovative idea and which segmentation technique you would be using to segment the market? And why?
Discuss the value and advantages of an intake interview : In a 2-3 page paper, describe the organization you selected and then discuss the value and advantages of an intake interview for the organization. What situation would it be used in? Why would an intake or counseling interview be a good choice for..
Estimate y-component of the velocity two mm above point b : The x-component of the velocity vector is measured at three locations 8 mm apart on the centerline of a symmetrical contraction. At points A, B, and C, the measurements produce 8.2, 9.4, and 11.1 m=s, respectively.
Calculate total variance and time variance for the project : Calculate the total variance and time variance for the project and what is the cost variance of the project - What is the schedule variance of the project?
Identify the key ethical issues in given case : Discuss your reaction to Ricardo's approach to counseling and the decisions he has made to provide services to lower-income adolescents and families. Identify the key ethical issues in this case, with reference to the ACA or ASCA ethical code
Assume uniform flow with the x-direction along the pipe axis : A compressible flow of a gas occurs in a pipeline. Assume uniform flow with the x-direction along the pipe axis and state the simplified continuity equation.
Write a detailed tutorial on artificial intelligence : Write a detailed tutorial on Artificial intelligence
Represents the correct formula for aluminum oxide : Which of the following represents the correct formula for aluminum oxide?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

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