Question type: Module B Linear Programming Each coffee table produced by Kevin Watson Designers nets the firm a profit of $11. Each bookcase yields a $20 profit. Watsons firm is small and its resources limited. During any given production period (of 1 week), 21 gallons of varnish and 30 lengths of high-quality redwood are available. Each coffee table requires approximately 1 gallon of varnish and 1 length of redwood. Each bookcase takes 1 gallon of varnish and 2 lengths of wood. Formulate Watsons production-mix decision as a linear programming problem, and solve. How many tables and bookcases should be produced each week? What will the maximum profit be? PLEASE TAKE SCREENSHOOT OF THE FORMULAS IN EXCEL TO SEE HOW YOU GET THE ANSWERS. I NEED TO SEE THE FORMULAS (CELLS YOU CLICK TO GET THE ANSWERS AND ALSO SEE THE ANSWERS )

THANKS