Suppose you are a machine learning$/$artificial intelligence researcher. You need to buy a pow$-$

erful computer to handle all of your data and to run your algorithms efficiently. You want to

buy the best computer possible, but only have $$5,000$ to spend. Luckily, there are companies

that allow you to customize your own PC $($Like this company$).$ The company offers a base

computer for $$3,090,$ but they allow upgrades from the base computer for a fee. The following

is the list of options for the custom computer, along with the cost. For example, if you were to

choose all base components, the price of the computer will be $$3,090.$

$$ 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)$

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 can must choose

one, and only one, item from each category. For example, if you choose the fastest processor

you cannot choose any other processor.

a$.(6$ pts$)$ Solve this problem in Excel.

b$.(3$ pts$)$ What is the total happiness from

your computer build?

c$.(3$ pts$)$ What computer parts did you se$-$

lect?

d$.(3$ pts$)$ Suppose you increase your budget

to $$7,000.$

What changes to your com$-$

Suppose you are a machine learning$/$artificial intelligence researcher. You need to buy a pow$-$

erful computer to handle all of your data and to run your algorithms efficiently. You want to

buy the best computer possible, but only have $$5,000$ to spend. Luckily, there are companies

that allow you to customize your own PC $($Like this company$).$ The company offers a base

computer for $$3,090,$ but they allow upgrades from the base computer for a fee. The following

is the list of options for the custom computer, along with the cost. For example, if you were to

choose all base components, the price of the computer will be $$3,090.$

$$ 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)$

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 can must choose

one, and only one, item from each category. For example, if you choose the fastest processor

you cannot choose any other processor.

a$.(6$ pts$)$ Solve this problem in Excel.

b$.(3$ pts$)$ What is the total happiness from

your computer build?

c$.(3$ pts$)$ What computer parts did you se$-$

lect?

d$.(3$ pts$)$ Suppose you increase your budget

to $$7,000.$ What changes to your com$-$

puter build?

Item Happiness

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$puter build?

Item Happiness

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$