Improving Decision Making: Using a Spreadsheet to Evaluate the Total Cost of Ownership $($TCO$)$ for PC Desktop Systems

Desktop and Printer Specifications

Each desktop system must satisfy the minimum specifications shown in the following table:

MINIMUM DESKTOP SPECIFICATIONS

Processor speed $3\mathrm{.}1$ GHz

Storage $512$ GB SSD

RAM $8$ GB

Monitor $($diagonal measurement$)24$ inches

Each desktop printer must satisfy the specifications shown below:

MONOCHROME PRINTER SPECIFICATIONS

HP LaserJet MFP M$234$sdwe printer or comparable

Chapter $5$ Hands on Software Exercise

Note: PC Desktop and printer models are examples. Students searching online can find other models that meet the specifications.

Number of users Number of users

Microsoft $365$ Business Standard license per user per year Microsoft $365$ Business Standard license per user per year

Desktop PC Desktop PC

Printer Printer

Alternative $1$ TCO for Desktop PC Systems Alternative $2$ TCO for Desktop PC Systems

Year $1$ Year$2$ Year $3$ Year $1$ Year$2$ Year $3$

One Time Costs One Time Costs

Desktop PC Desktop PC

Printer Printer

System implementation $17,000$ System implementation $17,000$

Recurring Costs Recurring Costs

Microsoft $365$ license Microsoft $365$ license

User training $12,0006,0006,000$ User training $12,0006,0006,000$

Maintenance $10,50010,50010,500$ Maintenance $10,50010,50010,500$

Tech support $15,00010,00010,000$ Tech support $15,00010,00010,000$

Electric power $1,1001,1001,100$ Electric power $1,1001,1001,100$

Office space $20,00020,00020,000$ Office space $20,00020,00020,000$

TOTAL TOTAL

$3-$YEAR TCO $3-$YEAR TCO

$3-$YEAR TCO PER USER $3-$YEAR TCO PER USER

PC Desktop System Price Sheet

Model Price

Acer Aspire C$24-1651-$UR$16749\mathrm{.}99$

Asus Zen AiO M$5401$WUA$-$DS$503869\mathrm{.}99$

Dell Inspiron $245000649\mathrm{.}99$

HP $24-$D$1036$XT $699\mathrm{.}99$

Lenovo IdeaCentre AIO $3$i $629\mathrm{.}99$