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

  Prepare a flowchart using job order cost system

Knox Company begins operations on January Because all work is done to customer specifications, the company decides to use a job order cost system.

  Menlo company distributes a single product the companys

menlo company distributes a single product. the companys sales and expenses for last month

  Compute the cost of a single unit of product

Compute the cost of a single unit of product under both the absorption costing and variable costing approaches.

  Develop a company and determine producation and sell

Compare and contrast financial and managerial accounting. Define fixed, variable, and mixed costs and explain the cost behaviors of each. Demonstrate the proper accounting for job order costing and process costing. Distinguish between and demonstrate..

  Calculate the companys predetermined overhead rate

Calculate the companys predetermined overhead rate for the year and complete the job cost sheet for the two jobs worked on in June:

  Accountants and other members of the management team

accountants and other members of the management team searching for means of understanding and improving standard

  Mr banner has recently contacted your accounting professor

mr. banner has recently contacted your accounting professor to find a replacement for his general manager and

  Cost of goods manufactured during the period

Calculate the Cost of Goods Manufactured during the period and calculate the Cost of Goods Sold during the period.

  Schedule of cost of goods manufactured

Preparation of a schedule of costo goods Manufactured and cost goods sold. The following cost and inventory data for the just completed year are taken from the accounting records of eccfles company:

  Preparation of a schedule of cost of goods

Preparation of a Schedule of Cost of Goods Manufactured and Cost of Goods Sold for last years accounts.Explain why some items have been excluded from the Schedules.

  Cash conversion cycles for edison company

Edison Inc. has annual sales of $49,000,000, or $44,100,000 a day on a 365-day basis. The firm's cost of goods sold are 75% of sales. On average, the company has $9,000,000 in inventory and $8,000,000 in accounts receivable.

  Calculate the firms break-even point

Calculate the firm's break-even point in units of production and predict the firm's profitability if volume is 1,200 units.

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