Explanation of Solution
a.
Spreadsheet set up for buy-alternative calculation:
Let us consider the assumption inputs are given below:
- Server cost is $2,500.
- Software costs is $1,250.
- Straight-line depreciation is 3 years.
- Maintenance percentage range varies from 2 to 7 %...
Explanation of Solution
b.
Spreadsheet set up for lease-alternative calculation:
Let us consider the assumption inputs are given below:
- The cost of 3 year lease is $285.
- The cost of 2 year lease is $335.
- The cost of 1 year lease is $415.
- Discount for 20 to 30 computers is 5%.
- Discount for 31 to 50 computers is 10%...
Explanation of Solution
c.
(1)
Organization needs 20 servers for 5 years.
For Buy-Alternative calculation:
The given inputs are,
- Server cost is $2,500.
- Software costs is $1,250.
- Straight-line depreciation is 3 years.
- Maintenance percentage is 3 %.
The formula to calculate the total buy payment is given below:
Total buy payment = Depreciation + Maintenance
For 1 year:
Server cost = Server cost × servers purchased
= 2500 × 20
= $50,000
Software cost = Software cost × servers purchased
= 1250 × 20
= $25,000
Depreciation1 = (Server1 cost + software1 cost) / Depreciation year
= (50000 + 25000) / 3
= $25,000
Interest Expense = Server cost × maintenance percentage
= 50000 × 0.03
= $1,500
Maintenance = Server cost × maintenance percentage
= 50000 × 0.03
= $1,500
Total buy payment = Depreciation + Maintenance
= 25000 + 1500
= $26,500
For 2 year:
Depreciation2 = Depreciation1
= $25,000
Interest Expense = Server cost × maintenance percentage
= 0 × 0.03
= 0
Maintenance = Server cost × maintenance percentage
= 50000 × 0.03
= $1,500
Total buy payment = Depreciation + Maintenance
= 25000 + 1500
= $26,500
For 3 year:
Depreciation3 = Depreciation1
= $25,000
Interest Expense = Server cost × maintenance percentage
= 0 × 0.03
= 0
Maintenance = Server cost × maintenance percentage
= 50000 × 0.03
= $1,500
Total buy payment = Depreciation + Maintenance
= 25000 + 1500
= $26,500
For 4 year:
Depreciation = (Server cost + software cost) / Depreciation year
= (0 – 0)/3
= 0
Interest Expense = Server cost × maintenance percentage
= 0 × 0.03
= 0
Maintenance = Server cost × maintenance percentage
= 50000 × 0.03
= $1,500
Total buy payment = Depreciation + Maintenance
= 0 + 1500
= $1,500
For 5 year:
Depreciation = (Server cost + software cost) / Depreciation year
= (0 – 0)/3
= 0
Interest Expense = Server cost × maintenance percentage
= 0 × 0.03
= 0
Maintenance = Server cost × maintenance percentage
= 50000 × 0.03
= $1,500
Total buy payment = Depreciation + Maintenance
= 0 + 1500
= $1,500
Total Server cost:
Total Server cost = Sum of the server cost for 5 years
= 50000+0+0+0+0
= $50,000
Total Software cost:
Total Software cost = Sum of the software cost for 5 years
= 25000+0+0+0+0
= $25,000
Total depreciation:
Total depreciation= Sum of the depreciation for 5 years
= 25000+25000+25000+0+0
= $75,000
Salvage value:
Salvage value = (Total Server cost + Total Software cost) – Total depreciation
= 50000+25000 – 75000
= $0.00
Total cost:
Sum of yearly costs less salvage value = sum of totals buy expenses for 5 years
= 26,500 + 26,500 + 26,500 + 1,500 + 1,500
= $82,500
Finally, the sum of the yearly costs less salvage value is,
Total = total cost – salvage value
= 82,500 – 0.00
= $82,500
Therefore, the sum of the yearly costs less salvage value for buy-alternative is “$82,500”.
For Lease-Alternative calculation:
The given inputs are,
- The cost of 3 year lease is $285.
- The cost of 2 year lease is $335.
- The cost of 1 year lease is $415.
- Discount for 20 to 30 computers is 5%.
- Discount for 31 to 50 computers is 10%.
The formula to calculate the total lease payment is given below:
Total lease payment = (Payment for leased servers – Discount amount) × 12
For 1 year:
Payment for leased servers = Payment per unit × Servers leased
= 285 × 20
= 5700
Discount amount = Payment for leased servers × Discount
= 5700 × 0.05
= 285
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (5700 – 285) × 12
= 5415 × 12
= $64,980
For 2 year:
Payment for leased servers = Payment per unit × Servers leased
= 285 × 20
= 5700
Discount amount = Payment for leased servers × Discount
= 5700 × 0.05
= 285
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (5700 – 285) × 12
= 5415 × 12
= $64,980
For 3 year:
Payment for leased servers = Payment per unit × Servers leased
= 285 × 20
= 5700
Discount amount = Payment for leased servers × Discount
= 5700 × 0.05
= 285
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (5700 – 285) × 12
= 5415 × 12
= $64,980
For 4 year:
Payment for leased servers = Payment per unit × Servers leased
= 335 × 20
= 6700
Discount amount = Payment for leased servers × Discount
= 6700 × 0.05
= 335
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (6700 – 335) × 12
= 6365 × 12
= $76,380
For 5 year:
Payment for leased servers = Payment per unit × Servers leased
= 335 × 20
= 6700
Discount amount = Payment for leased servers × Discount
= 6700 × 0.05
= 335
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (6700 – 335) × 12
= 6365 × 12
= $76,380
Total cost:
Total = Sum of Lease payments for 5 years
= 64,980 + 64,980 + 64,980 + 76,380 + 76,380
= $347,700
Therefore, the sum of the yearly costs for lease-alternative is “$347,700”.
The screenshot ofBuy-Alternative calculation andLease-Alternative calculation:
(2)
Organization needs 20 servers for first 2 years and 40 servers for next 3 years.
For Buy-Alternative calculation:
The given inputs are,
- Server cost is $2,500.
- Software costs is $1,250.
- Straight-line depreciation is 3 years.
- Maintenance percentage is 3 %.
The formula to calculate the total buy payment is given below:
Total buy payment = Depreciation + Maintenance
For 1 year:
Server1 cost = Server cost × servers purchased
= 2500 × 20
= $50,000
Software1 cost = Software cost × servers purchased
= 1250 × 20
= $25,000
Depreciation1 = (Server1 cost + software1 cost) / Depreciation year
= (50000 + 25000)/3
= $25,000
Interest Expense = Server1 cost × maintenance percentage
= 50000 × 0.03
= $1,500
Maintenance = Server1 cost × maintenance percentage
= 50000 × 0.03
= $1,500
Total buy payment = Depreciation + Maintenance
= 25000 + 1500
= $26,500
For 2 year:
Depreciation2 = Depreciation1
= $25,000
Interest Expense = Server1 cost × maintenance percentage
= 0 × 0.03
= 0
Maintenance = Server1 cost × maintenance percentage
= 50000 × 0.03
= $1,500
Total buy payment = Depreciation + Maintenance
= 25000 + 1500
= $26,500
For 3 year:
Server2 cost = Server2 cost × servers purchased
= 2500 × 20
= $50,000
Software2 cost = Software2 cost × servers purchased
= 1250 × 20
= $25,000
Depreciation3 = Depreciation2 + (Server3 cost + software3 cost) / Depreciation year
= 25,000 + (50000 + 25000)/3
= 25,000 + 25,000
= $50,000
Interest Expense = (Server2 cost × maintenance percentage)
= 50000× 0.03
=$1,500
Maintenance = (Server1 cost × maintenance percentage) + (Server2 cost × maintenance percentage)
= (50000 × 0.03) + (50000 × 0.03)
= 1500 + 1500
= $3,000
Total buy payment = Depreciation + Maintenance
= 50000+3000
= $53,000
For 4 year:
Depreciation4 = Depreciation2
= $25,000
Interest Expense = Server cost × maintenance percentage
= 0 × 0.03
= 0
Maintenance = (Server1 cost × maintenance percentage) + (Server2 cost × maintenance percentage)
= (50000 × 0.03) + (50000 × 0.03)
= 1500 + 1500
= $3,000
Total buy payment = Depreciation + Maintenance
= 25000 + 3000
= $28,000
For 5 year:
Depreciation5 = Depreciation4
=$25,000
Interest Expense = Server cost × maintenance percentage
= 0 × 0.03
= 0
Maintenance = (Server1 cost × maintenance percentage) + (Server2 cost × maintenance percentage)
= (50000 × 0.03) + (50000 × 0.03)
= 1500 + 1500
= $3,000
Total buy payment = Depreciation + Maintenance
= 25000 + 3000
= $28,000
Total Server cost:
Total Server cost = Sum of the server cost for 5 years
= 50000+0+50000+0+0
= $100,000
Total Software cost:
Total Software cost = Sum of the software cost for 5 years
= 25000+0+25000+0+0
= $50,000
Total depreciation:
Total depreciation= Sum of the depreciation for 5 years
= 25000+25000+50000+25000+25000
= $150,000
Salvage value:
Salvage value = (Total Server cost + Total Software cost) – Total depreciation
= 100000+50000 – 150000
= $0.00
Total cost:
Sum of yearly costs less salvage value = sum of totals expenses for 5 years
= 26,500 + 26,500 + 53,000 + 28,000 + 28,000
= $162,000.00
Finally, the sum of the yearly costs less salvage value is,
Total = total cost – salvage value
= 162,000– 0.00
= $162,000
Therefore, the sum of the yearly costs less salvage value for buy-alternative is “$162,000”.
For Lease-Alternative calculation:
The given inputs are,
- The cost of 3 year lease is $285.
- The cost of 2 year lease is $335.
- The cost of 1 year lease is $415.
- Discount for 20 to 30 computers is 5%.
- Discount for 31 to 50 computers is 10%.
The formula to calculate the total lease payment is given below:
Total lease payment = (Payment for leased servers – Discount amount) × 12
For 1 year:
Payment for leased servers = Payment per unit × Servers leased
= 335 × 20
= 6700
Discount amount = Payment for leased servers × Discount
= 6700 × 0.05
= 335
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (6700 – 335) × 12
= 6365 × 12
= $76,380
For 2 year:
Payment for leased servers = Payment per unit × Servers leased
= 335 × 20
= 6700
Discount amount = Payment for leased servers × Discount
= 6700 × 0.05
= 335
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (6700 – 335) × 12
= 6365 × 12
= $76,380
For 3 year:
Payment for leased servers = Payment per unit × Servers leased
= 285 × 40
= 11400
Discount amount = Payment for leased servers × Discount
= 11400 × 0.10
= 1140
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (11400 – 1140) × 12
= 10260 × 12
= $123,120
For 4 year:
Payment for leased servers = Payment per unit × Servers leased
= 285 × 40
= 11400
Discount amount = Payment for leased servers × Discount
= 11400 × 0.10
= 1140
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (11400 – 1140) × 12
= 10260 × 12
= $123,120
For 5 year:
Payment for leased servers = Payment per unit × Servers leased
= 285 × 40
= 11400
Discount amount = Payment for leased servers × Discount
= 11400 × 0.10
= 1140
Total lease payment = (Payment for leased servers – Discount amount) × 12
= (11400 – 1140) × 12
= 10260 × 12
= $123,120
Total cost:
Total = Sum of Lease payments for 5 years
= 76,380 + 76,380 + 123,120 + 123,120 + 123,120
= $522,120.00
Therefore, the sum of the yearly costs for lease-alternative is “$522,120”.
The screenshot ofBuy-Alternative calculation andLease-Alternative calculation:
(3)
Organization needs 20 servers for first 2 years, 40 servers for next 2 years, and 50 servers for last year.
For Buy-Alternative calculation:
The given inputs are,
- Server cost is $2,500.
- Software costs is $1,250.
- Straight-line depreciation is 3 years.
- Maintenance percentage is 3 %.
The formula to calculate the total buy payment is given below:
Total buy payment = Depreciation + Maintenance
For 1 year:
Server1 cost = Server cost × servers purchased
= 2500 × 20
= $50,000
Software1 cost = Software cost × servers purchased
= 1250 × 20
= $25,000
Depreciation1 = (Server1 cost + software1 cost) / Depreciation year
= (50000 + 25000)/3
= $25,000
Interest Expense = Server1 cost × maintenance percentage
= 50000 × 0.03
= $1,500
Maintenance = Server1 cost × maintenance percentage
= 50000 × 0.03
= $1,500
Total buy payment = Depreciation + Maintenance
= 25000 + 1500
= $26,500
For 2 year:
Depreciation2 = Depreciation1
= $25,000
Interest Expense = Server1 cost × maintenance percentage
= 0 × 0.03
= 0
Maintenance = Server1 cost × maintenance percentage
= 50000 × 0.03
= $1,500
Total buy payment = Depreciation + Maintenance
= 25000 + 1500
= $26,500
For 3 year:
Server2 cost = Server2 cost × servers purchased
= 2500 × 20
= $50,000
Software2 cost = Software2 cost × servers purchased
= 1250 × 20
= $25,000
Depreciation3 = Depreciation2 + (Server3 cost + software3 cost) / Depreciation year
= 25,000 + (50000 + 25000)/3
= 25,000 + 25,000
= $50,000
Interest Expense = (Server2 cost × maintenance percentage)
= 50000× 0.03
=$1,500
Maintenance = (Server1 cost × maintenance percentage) + (Server2 cost × maintenance percentage)
= (50000 × 0.03) + (50000 × 0.03)
= 1500 + 1500
= $3,000
Total buy payment = Depreciation + Maintenance
= 50000 + 3000
= $53,000
For 4 year:
Depreciation4 = Depreciation2
= $25,000
Interest Expense = Server cost × maintenance percentage
= 0 × 0.03
= 0
Maintenance = (Server1 cost × maintenance percentage) + (Server2 cost × maintenance percentage)
= (50000 × 0.03) + (50000 × 0.03)
= 1500 + 1500
= $3,000
Total buy payment = Depreciation + Maintenance
= 25000 + 3000
= $28,000
For 5 year:
Server3 cost = Server3 cost × servers purchased
= 2500 × 10
= $25,000
Software2 cost = Software2 cost × servers purchased
= 1250 × 10
= $12,500
Depreciation5 = Depreciation4+ (Server5 cost + software5 cost) / Depreciation year
= 25000 + (25000 + 12500) / 3
= 25000 + 12500
= $37,500
Interest Expense = Server cost × maintenance percentage
= 25000 × 0...
Want to see the full answer?
Check out a sample textbook solution
- What should the next three steps be in my machine based home security system after deployment and after the following current steps: Enhancing Security & Privacy Measures User Interface (UI) and Experience (UX) Improvement Machine Learning Model Refinement & Continuous Improvementarrow_forwardI am creating a machine learning home based security system, have completed initial deployment and in the following phases of the project: Expanding device compatibility and integration, preparing for cloud integration, and implementing system reduncancy and disaster recovery. What should the next three phases be?arrow_forwardHands-On Assignments Part II Assignment 1-5: Querying the DoGood Donor Database Review the DoGood Donor data by writing and running SQL statements to perform the following tasks: 1. List each donor who has made a pledge and indicated a single lump sum payment. Include first name, last name, pledge date, and pledge amount. 2. List each donor who has made a pledge and indicated monthly payments over one year. Include first name, last name, pledge date, and pledge amount. Also, display the monthly payment amount. (Equal monthly payments are made for all pledges paid in monthly payments.) 3. Display an unduplicated list of projects (ID and name) that have pledges committed. Don't display all projects defined; list only those that have pledges assigned. 4. Display the number of pledges made by each donor. Include the donor ID, first name, last name, and number of pledges. 5. Display all pledges made before March 8, 2012. Include all column data from the DD PLEDGE table.arrow_forward
- Write a FancyCar class to support basic operations such as drive, add gas, honk horn, and start engine. FancyCar.java is provided with method stubs. Follow each step to gradually complete all methods. Note: This program is designed for incremental development. Complete each step and submit for grading before starting the next step. Only a portion of tests pass after each step but confirm progress. The main() method includes basic method calls. Add statements in main() as methods are completed to support development mode testing. Step 0. Declare private fields for miles driven as shown on the odometer (int), gallons of gas in tank (double), miles per gallon or MPG (double), driving capacity (double), and car model (String). Note the provided final variable indicates the gas tank capacity of 14.0 gallons. Step 1 (2 pts). 1) Complete the default constructor by initializing the odometer to five miles, tank is full of gas, miles per gallon is 24.0, and the model is "Old Clunker". 2)…arrow_forwardFind the error: daily_sales = [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0] days_of_week = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'] for i in range(7): daily_sales[i] = float(input('Enter the sales for ' \ + day_of_week[i] + ': ')arrow_forwardFind the error: daily_sales = [0.0, 0,0, 0.0, 0.0, 0.0, 0.0, 0.0] days_of_week = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'] for i in range(7): daily_sales[i] = float(input('Enter the sales for ' \ + days_of_week[i] + ': ')arrow_forward
- Find the error: daily_sales = [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0] days_of_week = ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'] for i in range(6): daily_sales[i] = float(input('Enter the sales for ' \ + days_of_week[i] + ': '))arrow_forwardWhat are the steps you will follow in order to check the database and fix any problems with it and normalize it? Give two references with your answer.arrow_forwardWhat are the steps you will follow in order to check the database and fix any problems with it? Have in mind that you SHOULD normalize it as well. Consider that the database offline is not allowed since people are connected to it and personal data might be bridged and not secured. Provide three refernces with you answer.arrow_forward
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education