Problem 2. RW Designers makes bookcases and coffee tables. Each bookcase takes 1 gallon of varnish and 2 lengths of redwood. Each coffee table takes 1 gallon of varnish and 1 length of redwood. During a one- week production period, the firm has 100 gallons of varnish and 120 lengths of redwood available. A bookcase yields profits of $12 and a coffee table yields profits of $9. Demand for furniture requires that the number of coffee tables cannot exceed the number of bookcases. The firm would like to determine how many items of each type to make to maximize overall profits in one week. a) Create an Excel linear model for this problem, your model must have two decision variables and three constraints. Then, design a user form to input the available gallons of varnish (use a scroll bar from 0 to 500 in increments of 1, default is 100) and lengths of redwood (use a scroll bar from 0 to 500 in increments of 1, default is 120). Add a button entitled "Solve" to your form such that when the button is pressed, the program will use Solver to compute the optimal amount of each type of furniture to be made with the given inputs. The optimal answer (optimal profits and optimal amounts of each type of furniture) must be reported using message boxes. Add a button to the sheet to open your user form. Problem 2. RW Designers makes bookcases and coffee tables. Each bookcase takes 1 gallon of varnish and 2 lengths of redwood. Each coffee table takes 1 gallon of varnish and 1 length of redwood. During a one- week production period, the firm has 100 gallons of varnish and 120 lengths of redwood available. A bookcase yields profits of $12 and a coffee table yields profits of $9. Demand for furniture requires that the number of coffee tables cannot exceed the number of bookcases. The firm would like to determine how many items of each type to make to maximize overall profits in one week. a) Create an Excel linear model for this problem, your model must have two decision variables and three constraints. Then, design a user form to input the available gallons of varnish (use a scroll bar from 0 to 500 in increments of 1, default is 100) and lengths of redwood (use a scroll bar from 0 to 500 in increments of 1, default is 120). Add a button entitled "Solve" to your form such that when the button is pressed, the program will use Solver to compute the optimal amount of each type of furniture to be made with the given inputs. The optimal answer (optimal profits and optimal amounts of each type of furniture) must be reported using message boxes. Add a button to the sheet to open your user form