Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If you could show your work that would be great. Required information The Bureau of Indian Affairs provides various services to American Indians and Alaska
If you could show your work that would be great.
Required information The Bureau of Indian Affairs provides various services to American Indians and Alaska Natives. The Director of Indian Health Services is working with chief physicians at some of the 230 clinics nationwide to select the better of two medical X-ray system alternatives to be located at secondary-level clinics. X-Ray Systems Del Medical Siemens First cost, $ -214,000 -188,000 Annual operating cost, $/year -195,000 -199,000 Overhaul in year 3, $ -26,000 Overhaul in year 4, $ -140,000 Salvage value, $ 50,000 10,000 Expected life, years 16 16 At 5% per year, select the more economical system. Solve using single-cell spreadsheet functions. The spreadsheet function for calculating the present worth of Del Medical is (Click to select) and the present worth of Del Medical is $- 1281626 (Click to select =-PV(5%,6,-214000,50000) - 195000 - PV(5%,4,,-140000) The spreadsheet function for calculating the present worth of Siemens is (ci --PV(5%,6,-195000,50000) - 214000 - PV(5%,4,,-140000) d the =-PV(5%,4,-195000,50000) - 214000 - PV(5%,6,,-140000) present worth of Siemens is $- 1213060 =-PV(5%,6,-195000,50000) - 214000 - PV(5%,6,-140000) The more economical system is (Click to select) ! Required information The Bureau of Indian Affairs provides various services to American Indians and Alaska Natives. The Director of Indian Health Services is working with chief physicians at some of the 230 clinics nationwide to select the better of two medical X-ray system alternatives to be located at secondary-level clinics. X-Ray Systems Del Medical Siemens First cost, $ -214,000 -188,000 Annual operating cost, $/year -195,000 -199,000 Overhaul in year 3, $ -26,000 Overhaul in year 4, $ -140,000 Salvage value, $ 50,000 10,000 Expected life, years 16 16 At 5% per year, select the more economical system. Solve using single-cell spreadsheet functions. and The spreadsheet function for calculating the present worth of Del Medical is (Click to select) the present worth of Del Medical is $- 1281626 and the The spreadsheet function for calculating the present worth of Siemens is: (Click to select) present worth of Siemens is $- 1213060 (Click to select) --PV(5%,6,-188000,10000) - 199000 - PV(5%,3,,-26000) The more economical system is (Click to select) =-PV(5%,6,,-199000,10000) - 188000 - PV(5%,6,-26000) =-PV(5%,3,-199000, 10000) - 188000 - PV(5%,6,,-26000) --PV(5%,6,-199000, 10000) - 188000 - PV(5%,3,,-26000)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started