
Orion Tech Solutions has been awarded a 12-month contract to develop a custom software
solution for a major client. The contract is a fixed-price contract valued at $1.5 million.
This is the company’s first project requiring Earned Value (EV) reporting, and as part of
compliance, they have implemented EV metrics to track project performance.
The first EV report is due at the end of Month 3, with monthly reporting thereafter. The
project baseline was established with the following key components:
• Total Planned Value (PV) for the first 3 months: $300,000
• Breakdown of Work Packages and Financial Data (End of Month 3):
Work Package PV (BCWS) EV (BCWP) AC (ACWP) CV SV
A $80,000 $70,000 $85,000 ? ?
B $50,000 $50,000 $48,000 ? ?
C $100,000 $90,000 $110,000 ? ?
D $70,000 $50,000 $55,000 ? ?
Questions
(Basic EV Calculations)
1. Calculate the Cost Variance (CV) and Schedule Variance (SV) for each work
package using the formulas below:
o CV = EV - AC
o SV = EV - PV
2. What do the cost variance values indicate? Explain whether the project is over
budget or under budget.
3. What do the schedule variance values indicate? Explain whether the project is
ahead of schedule or behind schedule.
4. Calculate the overall CV and SV for the entire project. What does this tell you
about Orion Tech Solutions' performance?
(Applying EV Interpretation)
5. Calculate the Cost Performance Index (CPI) and Schedule Performance Index
(SPI) for each work package and the overall project.
CPI = EV / AC
SPI = EV / PV
6. Based on the CPI and SPI values, discuss what actions the project manager
should take to improve project performance.
7. What additional information should be included in the next earned value report
to provide a clearer picture of project performance?
8. The client is concerned about cost overruns and project delays. Prepare a
response as the project manager of Orion Tech Solutions, justifying the current
project performance and outlining a plan for corrective action.
to generate a solution
a solution
- Prepare the financial section of a business case for the Cloud-Computing Case that is listed above this assignment in Canvas. Assume that this project will take eight months to complete (in Year 0) and will cost $600,000. The costs to implement some of the technologies will be $300,000 for year one and $200,000 for years two and three. Estimated benefits will start in year 1 at $400,000 and will be $600,000 for years 2 and 3. There is no benefit in year 0. Use the business case spreadsheet template (business_case_financials.xls) template provided below this assignment in Canvas to calculate the NPV, ROI, and the year in which payback occurs. Assume a 7 percent discount rate for the template. notes* Payback occurs in the first year that there is a positive value for cumulative benefits - costs. (*Negative values are presented in parenthesis) What I have so far is attached I need to make it so Pay back occurs in year 3 where there is positive cumulative benefits - costs.arrow_forwardYou and your team are continuing your work on the Global Treps Project. Your project sponsor, Dr. K. has asked you to refine the existing cost estimate for the project so you can evaluate supplier bids and have a solid cost baseline for evaluating project performance. Recall that your schedule and cost goals are to complete the project in six months for under $120,000. You planned to use up to $50,000 total to pay yourself and your team members, and your initial estimates were $30,000 for travel expenses, $20,000 for hardware and software, and $20,000 for organizing four events, including consultants, legal/business fees, etc.arrow_forwardOn September 30, 2021, Athens Software began developing a software program to shield personal computers from malware and spyware. Technological feasibility was established on February 28, 2022, and the program was available for release on April 30, 2022. Development costs were incurred as follows: September 30 through December 31, 2021 January 1 through February 28, 2022 March 1 through April 30, 2022 Athens expects a useful life of five years for the software and total revenues of $6,500,000 during that time. During 2022, revenue of $1,170,000 was recognized. Required: Prepare a journal entry in each year to record development costs for 2021 and 2022. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) View transaction list Journal entry worksheet < 1 2 Record the development costs for 2021. Note: Enter debits before credits. Date 2021 $2,280,000 880,000 480,000 General Journal Debit Creditarrow_forward
- A project engineer with EnvironCare is assigned to start up a new office in a city where a 6-year contract has been finalized to collect and analyze ozone-level readings. Two lease options are available, each with a first cost, annual lease cost, and deposit-return estimates shown below. The MARR is 15% per year. a. EnvironCare has a practice of evaluating all projects over a 5-year period.If the deposit returns are not expected to change, which location should beselected?b. Perform the analysis using an 8-year planning horizon.c. Determine which lease option should be selected on the basis of a present worth comparison using the LCM.arrow_forwardCompany XYZ has developed the concept of a new product, from preliminary budgetary estimate to final design ready for implementation. The development has required an initial investment at the beginning of the activity, which lasted six months before implementation and beginning of production. At completion of implementation and beginning of production the CEO wants to estimate the expected PV of the investment, he/she has the following data: • Capital for development P1 = $30,000 Development period 0.5 years Capital for Implementation P2 = $2,000,000 %3D Anticipated sales revenues $20,000 Ar = $250,000/yr plus Gr = Anticipated 0&M cost $2,000 A om= $25,000/yr plus G om = Project Life 15 years Salvage Value F = 20% of invested capital %3D • Worth of Capital availability for the Company i= 7.35% QUESTIONS: 1) Draw the Cash Flow Diagram of this investment. 2) Write the expression for deriving PV using generic i and n. Assume the beginning of production as the reference period.arrow_forwardMr. Buzz Lightyear is the project manager for a satellite project. He calculates that an in-house solution will cost the company $320,000 to create the top-secret software package and based on OPA information, another $10,000 per month to maintain the software. Ms. Hrt Thickl, the purchaser for the project advises Buzz that it would cost the project $233,000 to purchase the software. However the supplier requires a maintenance plan for each program installed which will cost the project $15,000 per month. Once the satellite is built the company plans on orbiting the satellite in a low orbit around Earth for 730 days. Question of Project Procurementarrow_forward
- The Chief Operations Officer (COO) of a manufacturing firm recommends one of the manufacturing sites to undergo a process improvement initiative. He claims that this project will enable the company to realize a net savings of at least $3.25 Mln. The Chief Financial Officer (CFO) of the company tasked you to conduct a financial analysis to verify the claims of the COO. After performing cost analysis, you estimated that the project will require an initial investment of $2 Mln today and $1 Mln in Year 1. Afterwards, the initiative will yield an annual cost savings of $850k from Year 2 to Year 10. You assume that these cost savings are realized at the end of each year. (a) Suppose that you use a discount rate of 5%. Will the resulting net savings support the claim of the COO? (b) Determine the Internal Rate of Return (IRR) of the process improvement initiative. (c) Show the NPV profile of the project.arrow_forwardEl Paso Water is planning to install wind turbines to provide enhanced evaporation of reverse osmosis concentrate from its inland desalting plant. The company will spend $1.5 million in year 1 and $2 million in year 2. Annual maintenance is expected to cost $65,000 per year through year 10. Determine the equivalent annual cost of the project in years 1 through 10 at an interest rate of 6% per year. Also, develop a single-cell spreadsheet function to display the total A value.arrow_forwardFor the past 7 years, a quality manager has paid $500 every 6 months for the software maintenance contract on a laser-based measuring instrument. What is the equivalent amount after the last payment, if these funds are taken from a pool that has been returning 10% per year compounded quarterly?arrow_forward
- Airodyne Wind, Inc., has wind tunnels that can operate vertically or horizontally for evaluating the effects of air flow on a component's PCB response and reliability. The company expects to build a new tunnel that will be outfitted with multiple sensor ports. For the estimates below, calculate the equivalent annual cost of the project. First Cost Replacement Cost, Year 2 AOC per Year Salvage Value Life, Years Interest Rate The equivalent annual cost of the project is $ $-570,000 $-300,000 $-870,000 $270,000 7 13%arrow_forwardTwo alternative suppliers are offering to provide a system to recover an organic compound from a process stream in your company's chemical production facility. The cost of the two identical options are quoted as follows: Supplier #1: Total cost of $175,000; 70% of which must be paid now, and the balance to be paid in 12 months time upon completion of the installation of the system. Supplier #2: Total price of $180,000; 25% to be paid now, and the balance to be paid in 3 equal installments at 4 month intervals. You are asked to proceed with the project using the lower cost supplier. Assuming a nominal annual interest rate of 12%, compounded monthly, which one do you choose?arrow_forwardBLTD is investigating the financial viability of a new product called Wimble.The Wimble is a short life product for which a market has been identified at an agreed design specification.The product will only have a life of 12 months.The following estimated information is available in respect of Wimble.• Sales should be 120,000 in the year in batches of 100 units. An average selling price of K1,050 per batch of 100 units is expected. All sales are for cash.• An 80% learning curve will apply for the first 700 batches after which a steady state production time will apply, with the labour time per batch after the first 700 batches equal to the time for the 700th The cost of the first batch was measured at K2,500.This was for 500 hours at K5 per hour.• Variable overhead is estimated at K2 per labour hour.• Direct material will be K500 per batch of wimble for the first 200 batches produced. The second 200 batches will cost 90% of the cost per batch of the first 200 batches. All batches from…arrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage Learning
