You are given the following data. Calculate the VAC (Variance at Completion) for two scenarios as listed below Project A Budget $400,000 Duration 90 days Status 60 days EV $140,000 PV $150,000 AC $178,000 ВАС 1. Assume future budget estimates do not change ETC = EAC = VAC = 2. Assume future costs continue at the same spending rate ETC = EAC = VAC =

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter23: Flexible Budgeting (flexbud)
Section: Chapter Questions
Problem 5R
icon
Related questions
icon
Concept explainers
Question
You are given the following data. Calculate the VAC (Variance at Completion)
for two scenarios as listed below
Project
A
Budget
S400,000
Duration
90 days
Status
|60 days
EV
$140,000
PV
$150,000
AC
$178,000
BAC =
1. Assume future budget estimates do
not change
ETC =
EAC =
VAC =
2. Assume future costs continue
at the same spending rate
ETC =
EAC =
VAC =
Transcribed Image Text:You are given the following data. Calculate the VAC (Variance at Completion) for two scenarios as listed below Project A Budget S400,000 Duration 90 days Status |60 days EV $140,000 PV $150,000 AC $178,000 BAC = 1. Assume future budget estimates do not change ETC = EAC = VAC = 2. Assume future costs continue at the same spending rate ETC = EAC = VAC =
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning