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

  Overhead is applied on the basis of direct labor costs.

Accounting records for NIC Enterprises (NICE) for September show the following (each entry is the total of the actual entries for the account for the month):

  Conversion costs for the first department for the month

The ending inventory was 80% complete with respect to materials and 20% complete with respect to conversion costs and the cost per equivalent unit for conversion costs for the first department for the month is closest to

  Determine the overall break-even point for the company

Stanger Company, LLC produces and sells three products. Data concerning those products for the most recent month appear below.

  Knowledge-activity based costing

City of Joseph Commercial Bank hired consultants to compute the costs of three products: checking accounts, personal loans, and the Gold visa card. The consultant identified the following activities, costs and activity drivers (annual data):

  Explain lone company trial balance

Journalize the transactions for the company. Lone uses a perpetual inventory system. (record debits first then credits)

  Problem 1 break-even analysis and

problem 1 break-even analysis and profit

  Marginal analysis for optimal decisions

Appalachian Coal Mining believes that it can increase labor productivity and, therefore, net revenue by reducing air pollution in its mines. It estimates that the marginal cost function for reducing air problem in its mines.

  What maximum price to pay for the outside supplier

A budgeted income statement for the two options: paying 20% commission to sales agents and hiring own salespeople and breakeven point for the above two options

  Process cost system and cost transferred

Company uses a process cost system. The company started march with 2,300 units in work in process-department A. During the month 4,000 units were started. At the end of the month there were 3,200 units in ending work in process-dept.

  Questions1a what is the purpose of an entitybwhat are the

questions1.a what is the purpose of an entity?bwhat are the rights of the stakeholders of an entity?2.a outline the

  What is the expected value of perfect information

Tversky and Kahneman describe three types of heuristics that people use in judgments under uncertainty. What do they mean by the term heuristics? Briefly describe the ones that they mention

  Changes in cash conversion cycle

Bello Corp. has annual sales of $50,735,000, an average inventory level of $15,012,000, and average accounts receivable of $10,008,000. The company makes all purchases on credit and has always paid on the 30th day.

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