A furniture company manufactures tables and chairs. Each table and chair must be made entirely out of oak or entirely out of pine. A total of 15,000 board feet of oak and 21,000 board feet of pine are available. A table requires either 17 board feet of oak or 30 board feet of pine, and a chair requires either 5 board feet of oak or 13 board feet of pine. Each table can be sold for $800, and each chair for $300.

a.Determine how the company can maximize its revenue.

A screenshot is included below of the template that needs to be used. Please provide a step by step guide I can follow.

Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v Calibri 11 AA ab Wrap Text v General Ex Delete Paste BIUV A Merge & Center v v % 9 00 0 Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format Filter Select Data M14 X V fx C D F G H M N O P Q R S U V W X Manufacturing tables and chairs Unit selling price Oak tables Pinetables Oak chairs Pine chairs Usage of wood Oak tables Pinetables Oak chairs Pine chairs Used Available 8 Oak Pine 10 11 Produced Total revenue 43 Model Revised model STS_1 + Ready Calculate 100%