PLEASE use Excel

Wood Specialties Company produces wall shelves, bookends, and shadow boxes. It is necessary to plan the production schedule for next week. The wall shelves, bookends, and shadow boxes are made of oak, of which the company has 600 board feet. A wall shelf requires 4 board feet, bookends require 2 board feet, and a shadow fox requires 3 board feet. The company has a power saw for cutting the oak boards into the appropriate pieces; a wall shelf requires 30 minutes, bookends require 15 minutes, and a shadow box requires 15 minutes. The power saw is expected to be available for 36 hours next week. After cutting, the pieces of work in process are hand finished in the finishing department, which consists of 4 skilled and experienced craftsmen, each of whom can complete any of the products. A wall shelf requires 60 minutes of finishing, bookends require 30 minutes, and a shadow box requires 90 minutes. The finishing department is expected to operate for 40 hours next week. Wall shelves sell for $29.95 and have a unit variable cost of $17.95; bookends sell for $11.95 and have a unit variable cost of $4.95; a shadow box sells for $16.95 and has a unit variable cost of $8.95. A: Formulate this as an LP problem. Clearly describe your decision variables, objective function and constraints. B: Solve the LP problem using Excel Solver and interpret the results of the solution. Attach a copy of solver answer report to this sheet.