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.

TOTAL

$3-$YEAR TCO PER USER

PC Desktop System Price Sheet Chapter $5$ Hands$-$on MIS

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

Can you show how to answer this question in Excel?