Office2000 produces expensive, quality 2-drawer and 4-drawerfiling cabinets from solid oak for major corporations. A 2-drawermodel utilizes 2 labor hours to produce and package for a netprofit of $75. The 4-drawer model utilizes 3 labor hours to produceand package and nets a profit of $125. Each month Office2000 has360 labor hours available and can obtain up to 200 2-drawer frames,200 4-drawer frames, and 400 drawers from its oak supplier. Alinear programming model is formulated to maximize monthly profitfrom the manufacture of filing cabinets at Office2000. MAX 75X1 +125X2 ST 2X1 + 3X2 ? 360 2X1 + 4X2 ? 400 X1 ? 200 X2 ? 200 Set upthe model in Excel and solve for the optimal solution using Solver.In the boxes below, enter the optimal values of X1 (first box) andX2 (second box).
