$***$PLEASE SOLVE USING EXCEL$***$

$8.$ Suppose you are a machine learning$/$artificial intelligence rescarcher. You need to buy a powerful computer to handle all of your data and to run your algorithms efficiently. You want to buy the best computer possible, but only have $\backslash (\backslash$$ $5,000\backslash )$ to spend. Luckily, there are companies that allow you to customize your own PC $($Like this company$).$ The company offers a base computer for $\backslash (\backslash$$ $3,090\backslash ),$ 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 $\backslash (\backslash$$ $3,090\backslash ).$

$-$ Processor: Base $(\backslash$$$0)$; fast $(\backslash$$$279)$; faster $(\backslash$$$399)$; fastest $(\backslash$$$999)$

$-$ Memory: Base $(\backslash$$$0)$; $64$ GB $(\backslash$$$199)$; $128$ GB $(\backslash$$$549)$; $192$ GB $(\backslash$$$969)$; $256$ GB $(\backslash$$$1499)$

$-$ Power Supply: Base $(\backslash$$$0)$; advanced $(\backslash$$$59)$

$-$ Operating System: Base $(\backslash$$$0)$; Windows $11$ Pro $(\backslash$$$199)$

$-$ Video Card: Base $(\backslash$$$0)$; fast $(\backslash$$$199)$; faster $(\backslash$$$269)$; fastest. $(\backslash$$$399)$

$-$ Hard drive: Base $(\backslash$$$0)$; $1$ TB $(\backslash$$$129)$; $3$ TB $(\backslash$$$839)$

$-$ Warranty: Base $(\backslash$$$0)$; $4$ years $(\backslash$$$247)$; $5$ years $(\backslash$$$464)$

You assign a numeric value for the preference of each component $($you can think of this as happiness points$).$ You want to mazimize 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$\backslash ()\backslash )$ 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 select?

d$.(3$ pts$)$ Suppose you increase your budget to $\backslash (\backslash$$ $7,000\backslash ).$ What changes to your computer build?