In: Accounting
1. You are a Facility Manager. You have a project that is desperately in need of carpet. a. This project need is 3000 Square Feet. i. A high quality carpet costs $24/Square Yard and a low quality carpet costs $18/Square Yard. ii. The high quality carpet has a life expectancy of 10 years and the low quality carpet of 7 years. iii. The labor to maintain the high quality carpet is $1000 /Year and the low quality is $800. iv. The predicted material costs for the high quality carpet is $200 /Year and the Low is $250 / Year. v. The cost of money/ escalation is 9% annually. b. What do you recommend the company buy and why? The initial requestor does not have a preference on which carpet type is selected and is looking for a recommendation based on what makes the most sense for the company.
Period | PV factor @9% | PVA factor @9% |
1 | 0.91743 | 0.91743 |
2 | 0.84168 | 1.75911 |
3 | 0.77218 | 2.53129 |
4 | 0.70843 | 3.23972 |
5 | 0.64993 | 3.88965 |
6 | 0.59627 | 4.48592 |
7 | 0.54703 | 5.03295 |
8 | 0.50187 | 5.53482 |
9 | 0.46043 | 5.99525 |
10 | 0.42241 | 6.41766 |
Cost of high quality carpet (3000*24) | $ 72,000 | ||
High quality carpet (10 Years) | |||
Cash flow | PV | PVA factor | Present Value | |
Intial cost | $ 72,000 | 1.00000 | $ 72,000 |
Labor cost | $ 1,000 | 6.41766 | $ 6,418 |
Material cost | $ 200 | 6.41766 | $ 1,284 |
Total present value | $ 79,701 | ||
Divided by: PVA factor @9% for 10 years | 6.41766 | ||
Equivalent uniform annual cost (EUAC) | $ 12,419 |
Cost of low quality carpet (3000*18) | $ 54,000 | ||
Low quality carpet (7 Years) | |||
Cash flow | PV | PVA factor | Present Value | |
Intial cost | $ 54,000 | 1.00000 | $ 54,000 |
Labor cost | $ 800 | 5.03295 | $ 4,026 |
Material cost | $ 250 | 5.03295 | $ 1,258 |
Total present value | $ 59,285 | ||
Divided by: PVA factor @9% for 7 years | 5.03295 | ||
Equivalent uniform annual cost (EUAC) | $ 11,779 |
Equivalent uniform annual cost | |||
High quality carpet | $ 12,419 | ||
Low quality carpet | $ 11,779 |
The low quality carpet would recommend. The project with lower EUAC (Equivalent Uniform Annual Cost) is better. Low quality carpet has a lower EUAC. Thus, low quality carpet would be recomanded.