ANS using Solver EXCEL

-------------

Budget $5,000. ALL BASE parts computer cost $3,090.

Computer customization:

You assign a numeric value for the preference of each component (you can think of this as happiness points). You want to maximize your happiness- while staying within your budget. The table below contains your preference for each upgrade.

Note that you must choose one, and only one, the item from each category. like if you choose the fastest processor you cannot choose any other processor.

- Processor: Base ($0); fast ($279); faster ($399); fastest ($999) - Memory: Base (\$0); 64 GB ($199);128 GB ($549);192 GB ($969);256 GB ($1499) - Power Supply: Base ($0); advanced ($59) - Operating System: Base ($0); Windows 11 Pro ($199) - Video Card: Base ($0); fast ($199); faster ($269); fastest ($399) - Hard drive: Base ($0);1 TB ($129);3 TB ($839) - Warranty: Base ($0);4 years ($247);5 years ($464) \begin{tabular}{ll} \hline Item & Happiness \\ \hline Base processor & 5 \\ Fast processor & 10 \\ Faster processor & 12 \\ Fastest processor & 13 \\ Base memory & 0 \\ 64 GB memory & 5 \\ 128 GB memory & 10 \\ 192 GB memory & 14 \\ 256 GB memory & 16 \\ Base power supply & 0 \\ Advanced power supply & 1 \\ Base operating system & 2 \\ Windows 11 Pro operating system & 4 \\ Base video card & 3 \\ Fast video card & 6 \\ Faster video card & 9 \\ Fastest video card & 10 \\ Base hard drive & 1 \\ 1 TB hard drive & 4 \\ 3 TB hard drive & 7 \\ Base warranty & 3 \\ 4 year warranty & 4 \\ 5 year warranty & 7 \\ \hline \end{tabular}