Convert the following problem into a mathematical model. Using Excel Solver

answer the following questions:

a$)$ What is the optimal mix of products?

b$)$ Which process $($the equipment for that process$)$ should the company invest first to

increase its profit? Why?

Question $2$:

a$)$ Would using an order interval other than every six weeks reduce costs? If so$,$ which order

interval would be best, and what order size would that involve?

b$)$ Would you recommend changing the optimal order interval? Why or why not? Explain.