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 solutionChapter AE Solutions
Using MIS (10th Edition)
- If you wanted to start a media firm, for instance, and hire graphic designers and media producers, you would have to go out and find individuals to work for you. Create a list of the hardware that will be delivered to the workers of each department, along with a description of why the hardware is required, and include both on the list. How do they go about ensuring that they have a copy of their data at all times?arrow_forwardHi, I wanted to know what the relationships (like one-to-one, one-to-many, or many-to-many) would be like between these entities: Customer Sales Order Inventoryarrow_forwardIn your answer, describe the Transaction Processing Cycle (TPC) and provide two instances of when you would use batch processing and two examples of when you would use online transaction processing (OLTP).arrow_forward
- In your response, please define the Transaction Processing Cycle (TPC) and offer two examples of batch processing and two examples of online transaction processing (OLTP).arrow_forwardSome companies move their relational database (for instance a reporting database residing in MS SQL server) to Hadoop ecosystem. a. Do some web search and find out why do companies do that? b. What do they gain from that? c. Is it wise to do so? d. What is the upside and what is the downside?arrow_forwardAnswer this: when you hear the word "email," what are some of the first things that spring to mind? What happens to an email after it has been delivered? Make a note of all the information you've learned that wasn't available to you previously. It would be fascinating to learn if anybody has theories on what could be causing these discrepancies. Does your company's models differ in complexity?arrow_forward
- 26 The transaction Business Model follows the approach to provide users with a comfortable online communication platform. Select one: a. True b. Falsearrow_forwardProvide a brief description of the Transaction Processing Cycle (TPC) and two business case examples of when you would use batch processing and two business case examples of when you would utilize online transaction processing (OLTP) in your response.arrow_forwardGive examples to illustrate the demands you should take into account while outsourcing data to the cloud. with citationsarrow_forward
- The following are the necessary tables for a Bank Database customer table: | customer_id | customer_name | customer_street | customer_city |+-------------+---------------+-----------------+---------------+| C-101 | Jones | Main | Harrison || C-201 | Smith | North | Rye || C-211 | Hayes | Main | Harrison || C-212 | Curry | North | Rye || C-215 | Lindsay | Park | Pittsfield || C-220 | Turner | Putnam | Stamford || C-222 | Williams | Nassau | Princeton || C-225 | Adams | Spring | Pittsfield || C-226 | Johnson | Alma | Palo Alto || C-233 | Glenn | Sand Hill | Woodside || C-234 | Brooks | Senator | Brooklyn || C-255 | Green | Walnut | Stamford…arrow_forwardDineo has given what she wants to display on the website a lot of thought. And she has come up with quite a comprehensive set of business rules 1. A launchpad hosts multiple launches over time, and each launch is hosted by exactly one launchpad. Launchpads will be created in the database even before the first launch is hosted there.2. A launchpad is located in a country, and a country in turn is located on a continent.3. Each launchpad has a name and a location.4. A launch requires three things: a launchpad that hosts it, a launch vehicle (the rocket), and the payload.5. For a launch, the date, time and name should be recorded as well as whether it is a crewed launch or not.6. Each launch is performed by a launch vehicle. The serial number for the launch vehicle should be recorded. A launch vehicle can perform multiple launches over time.7. Each launch vehicle is of a specific launch vehicle type. The name, maximum thrust and whether it is reusable needs to be recorded for the launch…arrow_forwardWrite a business solution proposal for a retail store that wishes to implement an M-Commerce Solution to Enhance Customer Experience. Taking the 'AS-IS' model, elaborate on how technology will be utilized to streamline or optimize the current process in order to solve the stated business problem. Explain the future, or ‘ 'TO-BE', state process and illustrate it with a UML Activity Diagram. Include any key technology in its own Swimlane. Also, elaborate on any new, updated, enhanced IT Infrastructure (hardware, databases, networks, business intelligence, RFID, sensor networks, and/or software) required to support the solution. The line items that come out of this section should be part of the investment cost details in the solution assessment.arrow_forward
- Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
- Fundamentals of Information SystemsComputer ScienceISBN:9781305082168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning