Problem 3: Personal Peripherals manufactures two types of computer desks from laminated particle board. The PC+I model requires 24 square feet of particle board, 1 keyboard sliding tray and 3 hours of labor to fabricate. The PC+I model has a net profit of $95. The PC+II model requires 30 square feet of particle board, 1 keyboard sliding tray and 5 hours of labor to fabricate. The PC+II model has a net profit of $105. During the next production cycle, the company can buy up to 15,000 square feet of particle board and up to 600 keyboard sliding trays. The company has 3000 hours of labor available during the next production cycle. The company has a limit of 450 of PC+I desks it can make, and due to backorders must make at least 125 PC+II desks.

PLEASE ANSWER THIS QUESTION USING EXCEL SOLVER/XLSTAT

DVI DV2 ... 1. Name the decision variables: Unit Profit DVs Max Profit Used RHS ci C2 C3 2. What is the optimal values of the decision variables: VI VI VI 3. What is the optimal objective function