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
- Need this expression solved for mu. This can be done using a symbolic toolbox, however it needs to end up being mu = function (theta, m, L, g). If using MATLAB or something similar, run the code to make sure it works.arrow_forwardA business case scenario and asked to formulate an appropriate software design solution. Theyshould complete the case and upload the solution. will be required to read the case,identify and document the key issues, problems, and opportunities presented, and then design,and develop an appropriate integrated design solution to the problem. mustdemonstrate good spreadsheet, database, analytical, and word-processing skills whendeveloping solutions. Additionally, must be creative and demonstrate synthesising andapplying Database Management and Data Analytics Principles learned in the course. They willalso need to research some aspects of the assessment. CASE BACKGROUNDMGMT SS STATS, an umbrella body that facilitates and serves various Social SecurityOrganizations/Departments within the Caribbean territories, stoodpoised to meet the needs of its stakeholders by launching an onlinedatabase at www.SSDCI.gov. The database will provide membersand the public access to the complete set of…arrow_forwardA business case scenario and asked to formulate an appropriate software design solution. Theyshould complete the case and upload the solution. will be required to read the case,identify and document the key issues, problems, and opportunities presented, and then design,and develop an appropriate integrated design solution to the problem. mustdemonstrate good spreadsheet, database, analytical, and word-processing skills whendeveloping solutions. Additionally, must be creative and demonstrate synthesising andapplying Database Management and Data Analytics Principles learned in the course. They willalso need to research some aspects of the assessment. CASE BACKGROUNDMGMT SS STATS, an umbrella body that facilitates and serves various Social SecurityOrganizations/Departments within the Caribbean territories, stoodpoised to meet the needs of its stakeholders by launching an onlinedatabase at www.SSDCI.gov. The database will provide membersand the public access to the complete set of…arrow_forward
- Using MATLAB symbolic toolbox, given these 3 equations, how would you solve for mu = function(theta), making sure that there are no mu's on the right hand side, making sure theta-dot-dot, theta-dot-squared- and N aren't in the final answer either.arrow_forwardAfter playing our giving implementation, your task is to implement Dinning Philosophers with semaphore in C, by including and Your implementation will require creating five philosophers, each identified by a number 0.4. Each philosopher will run as a separate thread. Create threads using Pthreads as discussed in the Lecture slides on Chapter 4 and Practice Lab on Threads. Your solution needs to accomplish the following: Implement in C (15 points) 1. dp1.c - You are to provide your solution to this assignment as a single C program named 'dp1.c using semaphore. Explain in you code (as comments) that the dead lock will happen or not. If there is a possible deadlock, you can simply solve the deadlock by pick the fork in order like the first solution in our slides. Solve Deadlock by Footman (15 points) 1. Here is a new solution to overcome the deadlock. The Dining Philosophers decide to hire a footman whose task to allow only four philosophers to sit on the table. When entering and…arrow_forward8.4 Self-Bias Configuration 20. Determine Zi. Zo. and A,, for the network of Fig. 8.73 if gf, = 3000 μS and gos = 50 μs. 21. Determine Z, Zo, and A, for the network of Fig. 8.73 if the 20-uF capacitor is removed and the parameters of the network are the same as in Problem 20. Compare results with those of Problem 20. +12 V 3.3 ΚΩ HE C₂ Vo Z Zo C₁ 10 ΜΩ Z₁ 1.1 ΚΩ Cs 20 µF FIG. 8.73 Problems 20, 21, 22, and 59.arrow_forward
- 21. Determine Zi, Zo, and A, for the network of Fig. 8.73 if the 20-μF capacitor is removed and the parameters of the network are the same as in Problem 20. Compare results with those of Problem 20. +12 V 3.3 ΚΩ +6 C₂ C₁ Z₁ 10 ΜΩ 1.1 ΚΩ Cs 20 μF FIG. 8.73 Zoarrow_forwardNinth Edition Determine Zi, Zo and Av 20 V Zi + 1 ΜΩ 2 ΚΩ HH Z IDSS= 6MA Vp=-6V Yos = 40μS 20 and 47arrow_forwardWhat is the worst case time complexity of the following algorithm for i = 1 to x do for j = 2^((i-1)x) to 2^(in) do print(i,j)arrow_forward
- Prove for each pair of expression f(n) and g(n) whether f(n) is big O, little o Ω,ω or Θ of g(n). For each case it is possible that more than one of these conditions is satisfied:1. f(n) =log(n2^n), g(n) = log(sqrt(n)2^(n^2))2. f(n) =nsqrt(n) +log(n^n), g(n) =n + sqrt(n)lognarrow_forwardI need to make a parallel version of this sequential codearrow_forwardI need to make a parallel version of this sequential code.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