The Eaglego Arts designs, produces, and sells packaged lego pieces to build replicas of world-famous art sculptures. Each “lego sculpture pack” contains instructions on how to build the sculpture and the lego bricks required for sculpting. The most popular designs are Model A and Model B. Each of these models requires black and white lego bricks. The company has a total of 15,000 pieces of black and 4,000 pieces of white lego bricks in stock. Each Model A requires 50 black and 12 white pieces, and yields a profit of $40 per pack. Each Model B requires 75 black and 25 white pieces and can be sold for a profit of $65 per pack. The company has to determine the optimal product mix (i.e., determine the production quantities that maximize profits). You will formulate a linear programming model for this optimization problem. Do NOT solve the optimization problem.
Q: Are there any sign or type restrictions in your formulation? Why or Why not? Clearly explain the sign and type restrictions (if any). Prepare a spreadsheet to determine the optimal production mix using Excel solver. Provide a screenshot of your spreadsheet model. The screenshot should show all the cells involved in formulating the optimization problem. Provide a screenshot of your spreadsheet with the formula view. Prepare the solver model by logging all the information to the solver parameters window in Excel. Provide a Screenshot of the solver parameters wndow in Excel. Solve the optimization problem using Excel solver. What is the optimal solution i.e. the optimal cost and the optimal values of decision variables?