a$.$ Create a spreadsheet model for this problem and solve it using Solver. What is the optimal solution?

b$.$ Could Valu$-$Com make more money if it schedules assembly workers to work overtime?

c$.$ If the company could buy $1,000$ additional memory chips at the usual cost, should thev do it$?$ If so$,$ how much would profit increase?

d$.$ Will the solution change if the manufacturing cost of MicroLink is reduced by $$5?$

e$.$ Suppose the manufacturing costs used in this analysis were estimated hastily and are known to be somewhat imprecise. Which products would you be most concerned about having more precise cost estimates for before implementing this solution?