Assignment ASSIGNMENT 4 - LP DUE USING EXCEL BY MIDNIGHT NOVEMBER 26TH MOODLE LBC Co. manufactures two different types of chairs: Indoor model and outdoor model. Each chair produced must go through three departments: carpentry, painting, and finishing. The Indoor chair spends 3 hours in Carpentry, 1.5 hours in Painting, 0.75 hours in Finishing. The outdoor chair spends 2 hours in Carpentry, 1 hours in Painting, 0.75 hours in Finishing Department capacity (hours): 360 hrs for Carpentry, 300 hrs for Painting, and 195 hrs for Finishing. Table below contains the profits per each type of chair produced. The owner would like to determine a product mix to maximize his daily revenue. Revenues Requirements: / per 1. Formulate as an LP problem. chair 1. Decision variables Indoor- $28 2. Constraints. Chair 3.Objective function. Outdoor- 2. Solve LP graphically with mentioning what is the optimal product mix. $25 Chair